Prerna Singh
Data Analyst And Consultant
Bengaluru
Summary
Seasoned data analyst and consultant for 2+ years, engaging with CPG predominantly. Responsible for delivering value to clients at a monthly revenue of $100k for 2 years now. Good at Data analysis, visualization and delivering great client experience through valuable insights generation. Diligent worker with strong communication and task prioritization skills.
Overview
3
3
years of professional experience
4
4
years of post-secondary education
Work History
Data Analyst Consultant
Fractal Analytics
Bengaluru
08.2020 - Current
- Working for major CPG client projects to help them make informed strategic decisions using relevant data and business acumen - Unilever's Net Revenue Management
- Generated consumer and customer insights to identify opportunities to 'sell more for more' and hence drive turnover
- Worked on Five Lever approach to drill down the deep level analysis was taken into account across 50 countries under Unilever for various categories such as Food & Dressings, Beauty and Personal care, Haircare and Home& Hygiene
- Created descriptive analysis for Market Overview, Pack-Price Architecture, P&L optimization (Finance data) and Promotional Analysis (OPSO data). Nielsen and Kantar datasets are used under the NRM analysis
- Data ingestion, cleaning & harmonization using Excel and Python
- Developed tables, views and materialized views using SQL
- Data Visualization using Microsoft Think-Cell and Power-BI to drive relevant business insights
- End to End SKU recommendation using Shopper Analysis, Product Analysis and Price & Mix Optimization
- Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users
- Worked on automation of data preparation, data modelling and visualization using Python, making above work-flow 3x efficient
Full Stack Developer Intern
Global Groupware Solutions Ltd.
Gurgaon
06.2019 - 11.2019
- Developed, coded, modified and debugged application programs of varying degree of complexity under senior developers.
- Wrote production-ready code with fluency in modern front-end and back-end frameworks using advanced Java frameworks such as Spring boot, Hibernate for backend and strengthened multiple frontend functionalities using Java Script, HTML and CSS
- Planned and engineered RESTful web services to manipulate dynamic datasets such as creating API to fetch data from DB (DB2 database) using spring - JPA and return in JSON format
- Conducted unit testing to deliver optimal browser functionality.
Education
Bachelor of Science - Computer Engineering Technology
Banasthali University
Tonk, Jaipur, India 07.2016 - 04.2020
Skills
Project Management
Technical Analysis
Business needs analysis
Competive Programming using Python & Java
Data Structures & Algorithms
Projects
Projects
Online Hotel Booking Web Application
My role : Backend Developer
Tools & Technologies Used:
- Spring MVC & Hibernate (Advance Java Framework)
- MySQL
- Maven
- Eclipse
Functionalities:
- Search Hotel by city
- Book only after Login
- Validation on Booking Date and User Information
- Display booking orders
Timeline
Data Analyst Consultant
Fractal Analytics
08.2020 - Current
Full Stack Developer Intern
Global Groupware Solutions Ltd.
06.2019 - 11.2019
Bachelor of Science - Computer Engineering Technology
Banasthali University
07.2016 - 04.2020