Data Analyst

Data Analytics Newark, New Jersey, United States

Profile
Contacts

Summary

Data Analyst Diageo Aug20 Current
DiageoNow Sales Analysis Project:
- Developed an ETL process in Azure Datafactory to ingest 2M rows of planning data to create custom deliverables
- Implemented SQL scripts to normalize, interpret, and analyze data and conducted final QA/QC tests to ensure consistency and integrity of reporting outcomes
- Performed detailed analysis of data from third-party vendors to understand sales criteria based on KPIs such as market share dynamics, brand performance, pricing strategies, consumer demographics and competitive landscape in the alcohol manufacturing industry
- Developed dashboards in powerBI to monitor sales metrics like market share, distribution reach, CAC, CLV and sales by channel enabling managers to improve their strategies for product innovation, and effective marketing campaigns resulting in a 20% increase in sales revenue.
ETL Project:
- Designed and implemented data pipelines using Azure Datafactory to make 280 API calls, extract coupons, calendar, planning and events data from various sources, and aggregate data based on time intervals
- Configured data pipelines to transform and write data into files to ADLS location/SFTP server every 30 minutes for downstream consumption
- Monitored production data pipeline performance, analyzed logs, and resolved production issues, ensuring 99% pipeline uptime
- Conducted UAT cycles to validate data pipeline changes by coordinating with cross-functional teams, documenting test plans, executing test plans, and ensuring smooth production release for 10+ use cases
- Created comprehensive documentation for ETL processes and PowerBI reports facilitating knowledge sharing and onboarding of new team members. This documentation improved team efficiency and reduced the time required for onboarding by 30%