Dheeraj Bhatia

Jobs 0% verified

Senior Data Analyst

ICF

Feb 2023 - Current (3 years 4 months)

• Promoted for consistently delivering actionable insights and streamlining analytics workflows for aviation and marketing clients. • Used advanced SQL to extract, manipulate, and analyze large datasets (500k+ records/month) supporting customer satisfaction and pricing strategies. • Created dynamic dashboards in Power BI and Excel, improving executive visibility of KPIs and operational performance by 40%. • Built and automated ETL pipelines in Python and Power Query to reduce reporting cycle time by 60% and ensure consistency across data sources. • Translated business requirements into technical solutions, leading to the development of a pricing optimization model for 12,000+ SKUs, identifying 15% cost-saving potential. • Developed Po
C

Data Associate

CAPA India

Aug 2020 - Feb 2023 (2 years 7 months)

• Conducted market research and customer analysis for international airline clients to support targeted marketing and route decisions. • Maintained and optimized relational databases containing 50+ datasets using SQL, improving query performance and data accessibility. • Designed Excel forecasting models and dashboards with 100+ KPIs, enabling better planning and profitability tracking. • Automated manual data transformation tasks using Python (Pandas, NumPy, OpenPyxl), reducing turnaround time by 50%. • Regularly communicated analytical results to cross-functional teams, influencing campaign design and promotional strategies.

Education 0% verified

About

Detail

Timeline

Résumé