analyst with 2.7 of experience

5
Harshashree Email: harsha.3185 @gmail.com Ph: +91-9611332082 #234, Appoorva Nilaya, 1 th A Cross, Byatarayanapura New Ext , Mysore Road, Bangalore-560026 Professional Objective To work for a reputed organization, where I can demonstrate sound leadership, logical, analytical and team-work skills and rise to a level that will enable me to serve the organization to produce effective results and also improve my career. Professional Summary 2.5 Years of diverse experience in Business Intelligence, Data Analysis and Insights, Secondary Market Research, Reporting, Strategy, Project Management and Operations spinning across Retail, Energy, Engineering and Sales and store operations and presentations Hands on experience into Tableau Desktop building various views, worked with large data sets and create interactive charts and dashboards, connect data to various sources and publish dashboards on server. Experience in interacting with various department managers and team leads for data collection Good experience in data extraction, data conversion, data cleaning, data quality management, data analysis, data validation, data consolidation & merging, Data Tagging, Data Blending, Data Management, Visual Appealing Charts and build dashboards, scorecards with drill down filtering in Tableau. Proficiency in Microsoft Office applications – Excel, Word and PowerPoint. People and project management of a team of analysts delivering actionable insight to clients. Hands on knowledge of retail data analysis and providing data based insights. Strong analytical skills with ability to deep dive and make fact based decisions. Defined, Transitioned and Executed projects/operations from POC (Proof of Concept) to “Go Live” stages for reporting and analysis functions. Managed knowledge transfer of several complex work and projects Capable of working in a fast paced environment and delivering solid, successful solutions in short development cycles that hit the mark on the initial delivery Capable in working independently and within a team environment as well and open to travel onsite on business requirement if needed.

Upload: shree-harsha

Post on 12-Aug-2015

136 views

Category:

Documents


1 download

TRANSCRIPT

Page 1: Analyst with 2.7 of Experience

HarshashreeEmail: harsha.3185 @gmail.com

Ph: +91-9611332082

#234, Appoorva Nilaya, 1th A Cross, Byatarayanapura New Ext , Mysore Road, Bangalore-560026

Professional Objective

To work for a reputed organization, where I can demonstrate sound leadership, logical, analytical and team-work skills and rise to a level that will enable me to serve the organization to produce effective results and also improve my career.

Professional Summary

2.5 Years of diverse experience in Business Intelligence, Data Analysis and Insights, Secondary Market Research, Reporting, Strategy, Project Management and Operations spinning across Retail, Energy, Engineering and Sales and store operations and presentations

Hands on experience into Tableau Desktop building various views, worked with large data sets and create interactive charts and dashboards, connect data to various sources and publish dashboards on server.

Experience in interacting with various department managers and team leads for data collection

Good experience in data extraction, data conversion, data cleaning, data quality management, data analysis, data validation, data consolidation & merging, Data Tagging, Data Blending, Data Management, Visual Appealing Charts and build dashboards, scorecards with drill down filtering in Tableau.

Proficiency in Microsoft Office applications – Excel, Word and PowerPoint. People and project management of a team of analysts delivering actionable insight to

clients. Hands on knowledge of retail data analysis and providing data based insights. Strong analytical skills with ability to deep dive and make fact based decisions. Defined, Transitioned and Executed projects/operations from POC (Proof of Concept) to

“Go Live” stages for reporting and analysis functions. Managed knowledge transfer of several complex work and projects Capable of working in a fast paced environment and delivering solid, successful solutions

in short development cycles that hit the mark on the initial delivery Capable in working independently and within a team environment as well and open to

travel onsite on business requirement if needed. Consistent track records of successfully employing best business practices that improve

efficiency along with identifying process improvements for increasing business efficiency and effectiveness and handling operations single handedly.

Educational Qualification Education Board/University Year of PassingMBA Kalpataru institute of technology July - 2011BCA Vidyavahini First Grade College July - 2009PUC St Joseph’s PU College June- 2003

Page 2: Analyst with 2.7 of Experience

Specialties/Technical Skills

Sound knowledge of Base and Advance SAS, Oracle SQL Developer 11g, MS Office, Data analysis, Reporting and providing data based Insights

Knowledgeable Tableau 8.1 & 8.2, C and Java Strong Data visualization techniques. Hands-on experience of Advanced Excel (Pivot Table, Charts, Functions - like SumIf,

CountIf, Lookups - vlookups, hlookups, match, index, Indirect, Mathematical & Database Functions, including automation)

Hands-on experience on data analysis, operation management, project management, forecasting

Knowledge of statistical techniques like Correlation, Regression Analysis

Work Experience

1. TESCO HINDUSTAN SERVICE CENTRE PVT LTDDesignation: AnalystDepartment : Property Services (Analytics & Support Team) (Engineering Insights)Duration : Since February 17, 2014

Roles & Responsibilities

The work profile includes retail data analytics involving various statistical, forecasting and projection techniques using SAS and Excel.

Delivering Ad-hoc analysis involving energy spends data across stores to strategize energy saving project roll outs to drive maximum benefits and reduce overall store’s energy consumption

Spotting exceptions in store’s excessive energy consumption remotely by investigating the data trends w.r.t. the seasonal and operational rule and flagging out the issues for resolution

Identifying and developing new energy saving opportunities in millions of pounds across Tesco UK and Thailand stores each year which could be implemented to reduce like for like consumption

Forecasting future consumption (both short-term and long-term) through analysis of historical energy consumption data using statistical techniques and its correlation to a variety of factors like temperature, net sales area, location (geography) etc

Working closely with the UK and Thailand stakeholders to deliver meaningful and actionable insights to help them in targeting potential areas to reduce energy consumption within the store

Delivering periodical energy performance summaries and analysis on energy consumption trends along with periodical insights derived out of data analysis to Tesco UK and Thailand executive leadership team

Ownership and designing of overall deliverables flow from data analysis

Achievements:

Achieved KPI of Energy loss identification opportunities of £2 million against a KPI of £1.3 million for the 2014-15

Page 3: Analyst with 2.7 of Experience

Transitioned the Energy Process for Thailand store for the first time into Tesco, been in Thailand for 2 months to understand the business and completely transitioned the process to HSC in India.

Energy budgets created by HSC team close to 99.73% accurate against actual for 14/15 & 15/16 YTD against a target of 97%

Streamlined and automated several reports of Engineering and Energy. Identified & championing 2 projects in areas of energy spend reduction and supply-side

generation

1. Validated the Saturation Project worth for Tesco Stores worth £ 60 million and reverted back to the business on Loop holes that saved the business lose to around £2.5 million

2. Created a Governance report for the Thailand Stake holders based on the data and provided an insight to the team for process improvement and also identified a drift worth 1 million.

Awarded best performer in quarter 4.

PROFESSIONAL CONTOUR

Employer : Blueocean Market Intelligence Private Ltd.

Designation : Analyst

Duration : Since December 2012 to 2014

Professional Summary

Provide Business Solutions using SAS, Excel and Statistical tools. Running regression Analysis to estimate sales at store level Performed data analysis on the datasets using PROC UNIVARIATE, PROC MEANS, PROC

FREQ and PROC ANOVA Provide the Business KPI’s to the clients to know the key performing indicators in the

FMCG (Retail) domain. Apply the predictive analytics technologies to discover revenue, sales trends and make

forecast ( Using ARIMA) . Created customized reports and presentation quality data summary tables and figures

using PROC SORT, PROC PRINT, and PROC REPORT.

Performed sorting and merging of data and generated tables, listings and graphs using SAS/Base, SAS/Stat and SAS/Graph, SAS/SQL

MBA ACADEMIC PROJECT:

Project Title : Centralized purchasing

Company : Export Syndicate, Bangalore

Problem statement : “Pros and Cons of Centralized purchasing”

Page 4: Analyst with 2.7 of Experience

Description : The aim of this project is to know how purchases are carried out in an organization and how decisions will be taken by purchase manager and Understand how purchase will be carried out in a single purchase department for many units Data analysis and reporting of purchase department using primary and secondary research techniques. Role : Management traineeTools : Primary and secondary research techniques and Ratio analysisAnalysis : Centralization has the advantages of reducing duplication of effort,

Pooling Volume purchases for discount, enabling more effective inventory control, consolidating transport loads to achieve lower cost etc.

Result : Centralized purchasing is well suited for large and medium scale industries in the context of better result; it is possible to tap the advantage of the specialized skill of buying staff of the company, inventory carrying cost will be reduced due to centralized purchasing. The specific requirements of the individual items may not be attended successfully and the centralized standards may result in delays in receiving the materials.

Personal Details

Father’s Name : Permanent Address : #23, Appoorva Nilaya, 1th A main, Byatarayanapura New Ext Bangalore-560026 Ph: +91-9611332082

Gender : Male

Date of Birth : 31-03-1985

Marital Status : Married

Nationality : Indian

Languages known : English, Hindi, Telugu, Kannada, Tamil.

DECLARATION

I hereby declare that all the details mentioned above are true to the best of my knowledge.

Date:

Place: (Harshashree)