PRITHVI PURWAR
NEW DELHI
Summary
Experienced Data Analyst with over 12 years of experience in FMCG & Food industry. Excellent reputation for resolving problems, Skilled in working under pressure and adapting to new situations and challenges to best enhance the organizational brand.
Overview
17
17
years of professional experience
1
1
Certification
Work History
SENIOR ASSOCIATE
SAMSUNG INDIA ELECTRONICS Ltd
Gurugram
07.2022 - Current
- Manage PAN India 10 K Secs and 6500 Store Data
- Design data models to transform raw data into meaningful insights for Business Requirement in BI context
- Collecting data from a variety of sources, create dashboards and interactive visual reports using Power Pivot at Model Level
- Sellout Targets setting in coordination with Product team after which drive the sellout against the planned targets
- Creating Competition Analysis Report for counter Share and Display Share
- Analyzing Monthly Average Price with Competition and present data through reports that aid decision-making
- Track BDN Secs Stores
- Creating Plano Adherence on Product Level
- Analysis the Manpower Cost and Incremental Business thru them
- Productivity Analysis
- Create Target Vs Achievement with growth on Product and SEC Level for Pan India
- Create MR Partner (RDRL and Croma) Dashboard, Analysis CS, DS Growth Delta for CS and DS Run rate and Inventory with Different Sources of Data in One Single Dashboard report
- Analyzing the data using statistical methods to draw insights and conclusions
- Interpreting the analysis and presenting it to a wider audience, such as executives or stakeholders
- Create relationships between data and develop tabular and other multidimensional data models using Power BI
- Chart creation and data documentation explaining algorithms, parameters, models, and relations
- Perform DAX queries and functions in Power Pivot
- Analyze current ETL process, define and design new systems
- Design, develop and deploy business intelligence solutions as per needs.
Assistant Manager Business Support
Devyani International Limited
Gurgaon
03.2017 - 02.2018
- Monitored company inventory to keep stock levels and databases updated
- Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting
- Adhering to all cost control procedures
- Updates menu costs quarterly for all outlets and meal periods
- Reviewed costs percentages on daily basis for both food and beverage and prepares daily report
- Reviewed P&L statements
- Monitoring budget allocation and effective utilization of resources (human, information, data, etc.)
- Maintained track of market trends and competitive movements
- Compiled financial data to comply with budget.
Sales Coordinator / MIS Executive
MTR Foods PVT Ltd
07.2014 - 02.2017
- Assist sales team by focusing on managing schedules and following up on sales reporting
- Liaise between departments to provide support in devising and implementing sales strategies
- Perform sales reporting and analysis
- Coordinate with different functions to ensure that set procedures are implemented
- Preparation of Trade Claims, and process for approval
- Prepare Office Budget, Team Budget and Sales Budget on Quarterly Basis
- Build target databases with crucial sales information.
Logistic MIS Executive
MOTHER DAIRY FRUITS & VEGETABLE PVT LTD
New Delhi
10.2011 - 04.2014
- Handling 35 DEO's for taking care of Customer Order Booking and Invoice Process
- Track Daily basis sale order with previous date to maintain Zero percent Error
- Maintain records for Crate Reconciliation in every plant
- Responsible for clear all credit check issue by coordinating with field force
- Maintain Records for All returns with their respective plant.
ZONAL SALES COORDINATOR
PIRAMAL HEALTHCARE LTD
New Delhi
02.2007 - 09.2011
- Generation of Daily/Weekly/Monthly Excel reports and validating reports according to QA documents
- Making Daily Sales Reports
- Preparing Presentations of analyzed reports for Business Development meeting.
DATA ANALYTICS EXECUTIVE
MTR Foods PVT Ltd
New Delhi
- Manage data for over 30K outlets and 180 packs
- Analyzed key aspects of business to evaluate factors driving results and summarized into presentations
- Analyzed open orders, backlog and sales data to provide sales team with insights
- Assessed business requirements to forecast monthly budgets
- Supported leadership team with reporting, analysis and business presentations to inform divisional strategies
- Analyzing both primary & secondary trend by geography & Pack wise level to find problematic areas to and highlighting in to business head
- Develop Business dashboard with Key KPI to drive business
- Build & monitor Sales Budgets by region / SKU & ASM wise
- Stock and Sales Report Update @ Stockiest & SKU Level for ROI India
- Standardizing & developing review format & MIS format across Zones
- Create mechanisms for exploring structured, semi-structured, and unstructured data
- Preparing BI reports for upper management that effectively communicate trends, patterns, and predictions using relevant data
- Track key metrics such as sales revenue and monthly activities results to help business leads against goals
- Identifying, analyzing, and interpreting trends or patterns in complex data sets
- Build and maintain basic data artifacts (e.g., ETL, data models, queries) and reports
- Participated in collecting, organizing, and interpreting data along with fellow colleagues.
Education
BSC IT -
SIKKIM MANIPAL UNIVERSITY
01.2014
Intermediate: Science -
BVM
01.2005
High School: Science -
BVM
01.2002
Skills
- Mathematical skills (especially statistics and probability)
- Power BI
- Data analysis
- Visualization
- Advance Excel
- Power Query
- Power Pivot
- Data collection
- Organizing
- Operational Data Management
- Strong Problem Solving Skills
- Large dataset management
Certification
- Advanced Excel for data analysis, 05/2022
- Microsoft Power BI Master Class, 05/2022
Accomplishments
- Awarded with the Data Automation for excellence in Creating Valuable Dashboard
- Used Microsoft Excel to develop Efficiency tracking Model Dashboard
- Modified and improved existing databases to reduce processing time by Hrs. and improve accuracy by 98%
- Developed methods to integrate Power Pivot to significantly Track measure KPIs
Personal Information
Title: Data Analyst
Timeline
SENIOR ASSOCIATE
SAMSUNG INDIA ELECTRONICS Ltd
07.2022 - Current
Assistant Manager Business Support
Devyani International Limited
03.2017 - 02.2018
Sales Coordinator / MIS Executive
MTR Foods PVT Ltd
07.2014 - 02.2017
Logistic MIS Executive
MOTHER DAIRY FRUITS & VEGETABLE PVT LTD
10.2011 - 04.2014
ZONAL SALES COORDINATOR
PIRAMAL HEALTHCARE LTD
02.2007 - 09.2011
DATA ANALYTICS EXECUTIVE
MTR Foods PVT Ltd
BSC IT -
SIKKIM MANIPAL UNIVERSITY
Intermediate: Science -
BVM
High School: Science -
BVM
Similar Profiles
Vivek JainVivek Jain
Area Sales Executive at Samsung India Electronics Pvt. Ltd, SamsungArea Sales Executive at Samsung India Electronics Pvt. Ltd, Samsung
Tulin Mark SamuelTulin Mark Samuel
Manager - CS Operations at Samsung India Electronics LtdManager - CS Operations at Samsung India Electronics Ltd
Aashish GondaneAashish Gondane
Manager - SCM West Region at One-Rx India Pvt Ltd. (subsidiary of OFFICE Samsung India Electronics Pvt Ltd)Manager - SCM West Region at One-Rx India Pvt Ltd. (subsidiary of OFFICE Samsung India Electronics Pvt Ltd)