Summary
Overview
Work History
Education
Skills
Projects
Timeline
Generic

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

undefined

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

Similar Profiles

CREATE PROFILE
Prerna SinghData Analyst And Consultant