DILEEP KUMAR GUJJURU
Chennai
Summary
Insightful Data Analyst known for high productivity and efficient task completion. Specialize in data mining, statistical analysis, and machine learning algorithms to solve complex problems. Excel in critical thinking, communication, and problem-solving skills which enhance team collaboration and project success. Adapt quickly to new technologies to continuously improve processes and outcomes.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Processing Analyst
NielsenIQ
Chennai
10.2021 - Current
- Led efforts in collecting, cleansing, validating, and analyzing large and complex FMCG datasets to provide actionable insights, patterns, and trends as part of the ETL process
- Performed extensive quantitative analysis on both external and internal data, presenting key insights and trends to support strategic decision-making
- Managed stakeholder inquiries, ad-hoc requests, and escalations by conducting root cause analysis and resolving tickets efficiently
- Developed deep expertise in FMCG market data, identifying critical data points for actionable business insights
- Spearheaded an interdepartmental automation initiative using Python to optimize task queue management for the operations team, significantly improving efficiency
- Designed and developed dashboards and business intelligence reports, including KPIs, to support decision-making for top US FMCG retail giants
- Conducted thorough analysis of US market FMCG retail datasets using analytical tools, delivering critical insights to enhance business planning and operations
- Collaborated with team leads on business planning, resource allocation, task management, and KPI tracking to ensure smooth project execution and alignment with business goals
Education
B.Tech - Electrical and electronics engineering
Sree Rama engineering College
Tirupati07.2021
Diploma - Electrical and electronics engineering
Govt Polytechnic college
Sathyavedu07.2018
Degree in SSC -
Govt high schoool
Sathyavedu07.2015
Skills
- Python
- Pandas
- Numpy
- GitHub
- PowerBI
- Advanced Excel
- Collecting information
- Data modeling
- SQL
Certification
- Analyzing and Visualizing Data with Microsoft Power BI - CloudyML
- Python - CloudyML
- SQL - CloudyML
- Excel & Advanced Excel - CloudyML
- GIT&GITHUB - CloudyML
Projects
Retail Data Integration and Analysis Platform Enhancement
Data Analyst (PowerBI,SQL,Python)
PowerBI, SQL, Python, Led the enhancement of NielsenIQ's retail data integration and analysis platform, streamlining data processes for more accurate and efficient business insights., Developed custom Python scripts to automate ETL processes, including data cleansing, transformation, and validation, which reduced manual efforts and improved data quality., Utilized SQL to perform complex data extraction, transformation, and loading (ETL) processes, ensuring accurate and consistent data for reporting and analysis., Designed Star and Snowflake schemas to optimize data models, improving query performance and enhancing reporting accuracy., Created dynamic Power BI dashboards to visualize key performance metrics, market trends, and consumer behavior, providing actionable insights to stakeholders., Leveraged advanced Power BI features such as filters, slicers, and drill-through functionality to enable deep data exploration and interactive reporting., Developed advanced DAX calculations for complex measures and time series analysis, supporting predictive insights and trend forecasting within Power BI., Automated repetitive tasks using Python, including data validation and cleansing, improving efficiency and enabling timely reporting.
Awards
Employee of the Month, NielsenIQ, 09/01/23
Timeline
Data Processing Analyst
NielsenIQ
10.2021 - Current
B.Tech - Electrical and electronics engineering
Sree Rama engineering College
Diploma - Electrical and electronics engineering
Govt Polytechnic college
Degree in SSC -
Govt high schoool
Similar Profiles
Patryk BadowskiPatryk Badowski
Associate Manager at NielseniqAssociate Manager at Nielseniq
ROSHNI SHETHROSHNI SHETH
ME Customer Success Lead at NielsenIQME Customer Success Lead at NielsenIQ
Nidhi KochrekarNidhi Kochrekar
Senior BI Analyst at NielsenIQSenior BI Analyst at NielsenIQ
Debayan MazumdarDebayan Mazumdar
Technical Support Specialist at NielsenIQTechnical Support Specialist at NielsenIQ
Zaheer Syed.SZaheer Syed.S
Team Manager at GSR Global ServicesTeam Manager at GSR Global Services