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.