Recession-Era Workforce Analysis and Strategic Insights - POWER BI
→
Summary
Designed a dynamic Power BI dashboard to analyze company layoffs during the recession years (2020-2023).
About
Myself Shruti Pal, a results-oriented Modelling Analyst with over a year of experience at NielsenIQ, specializing in statistical analysis, trade planning, and consumer behavior insights for top FMCG clients. Recognized as a Gold Medalist in M.Sc. Statistics and a CAS ACE Performer, she excels at leveraging data to drive strategic decisions and manage complex projects efficiently. With a proven ability to deliver high-quality, actionable insights, Shruti is poised to contribute to data-driven success in a dynamic analytical environment.
Work
NielsenIQ
|Junior Data Analyst
Vadodara, Gujarat, India
→
Summary
As a Junior Data Analyst at NielsenIQ, Shruti Pal delivered actionable insights using Nielsen CPS data for top-tier FMCG clients across European markets, driving strategic decisions in consumer behavior.
Highlights
Delivered actionable, data-driven consumer behavior insights using Nielsen CPS data for top-tier FMCG clients (Colgate, Heineken, Mars, Nestlé, Henkel, Wella) across European markets.
Developed and applied advanced analytics solutions, including Trade Planning, NLR Analysis, CPA, HML Buyer Analysis, Brand Shifting, and Migration Analysis, to optimize client marketing and sales strategies.
Translated complex data into clear, actionable insights, enabling clients to improve marketing and sales strategies by understanding customer behavior and retention.
Managed multiple concurrent projects efficiently, consistently maintaining high quality and delivering insights under tight deadlines, earning recognition as a CAS ACE Performer of the Quarter.
Utilized Python and Advanced Excel to conduct in-depth data analysis and generate impactful reports, enhancing strategic decision-making for clients.
SquareRisk
|Data Analyst Intern
Indore, Madhya Pradesh, India
→
Summary
During her internship at SquareRisk, Shruti Pal streamlined data retrieval through API testing, improved data collection with dynamic forms, and analyzed Excel datasets to support critical business decisions in a fast-paced startup.
Highlights
Streamlined data retrieval processes by implementing API testing with Postman, enhancing efficiency and data integrity for business operations.
Developed dynamic forms using FormIO to significantly improve data collection methods, ensuring higher accuracy and completeness of essential business data.
Analyzed complex Excel datasets to provide critical insights, directly supporting strategic business decisions and operational improvements.
Contributed to team coordination and delivered training sessions in a fast-paced startup environment, fostering skill development and knowledge transfer.
Education
Devi Ahilya Vishwavidyalaya
Regular
Statistics
Grade: 9.33
Devi Ahilya Vishwavidyalaya
Indore, Madhya Pradesh, India
→
Master of Science
Statistics
Grade: 9.33 CGPA
Awards
CAS ACE Performer of the Quarter
Awarded By
NielsenIQ
Honored for exceptional client-focused delivery through strong project management, fast turnaround, and attention to detail in a high-paced environment.
Gold Medalist in M.Sc. Statistics
Awarded By
D.A.V.V University
Recognized for achieving the highest academic honor in M.Sc. Statistics, awarded by the President of India, Smt. Draupadi Murmu, reflecting a strong foundation in statistical analysis, quantitative techniques, and problem-solving.
Languages
English
Hindi
Skills
Advanced Excel
Python
SQL
Power BI
IBM SPSS
KPI
Problem solving
Project management
Data Analysis & Visualization
Python, Advanced Excel, Power BI, SQL, IBM SPSS Statistics, Data Modeling, Statistical Analysis, Data Interpretation, Reporting, Data Storytelling.
Machine Learning
ML Azure, Random Forest Classifier, Feature Engineering, Model Evaluation, Predictive Modeling.
Data Management & Tools
Postman API, FormIO, Nielsen CPS Data.
Professional Competencies
Problem Solving, Critical Thinking, Attention to Detail, Project Management, Teamwork, Interpersonal Skills, Time Management, Quick Learning.
Interests
Nature Exploration
Traveling
Dancing
Projects
Exoplanet Hunting in Deep Space
→
Summary
Completed the 'Exoplanet hunting' project with 99.9% accuracy using Random Forest classifier.