Ankit K

Data Analyst || Business Analyst

PANDORA • Full time

Dec 2023 - Present • 2 yrs 5 mos

Leveraged advanced SQL techniques including window functions, CTEs, and multiple nested subqueries to create complex data pipelines for comprehensive inventory analysis and forecasting dashboards, reducing query processing time by 40%. ◦ Developed sophisticated Python scripts implementing STL (Seasonal-Trend) decomposition methods for time series analysis, enhanc- ing demand forecasting accuracy by 25% while optimizing runtime performance by 60%. ◦ Automated client Excel workflows through Python and SQL integration, reducing manual processing time by 85% and eliminating human error in data processing for 50+ weekly reports. ◦ Enhanced data readiness through extensive pre and post-processing using Python and Microsoft Excel, resolving 200+ complex SCM queries with PostgreSQL, and creating 30+ impactful, customized dashboards that improved decision-making speed by 35%. ◦ Managed end-to-end SCM operations for 15+ clients across apparel, home decor, and FMCG industries, increasing operational effi- ciency by 30%. ◦ Conducted on-site stakeholder meetings with key clients, fast-tracking 3 project configurations within 1 month each. ◦ Developed SCM models that reduced stock-out occurrences by 40% and dead stock by 50%, improving revenue outcomes by 20%.