p
p_solver_nitian

Ankit K

@p_solver_nitian

Data Analyst ,Business Analyst

India
Inglés, Hindi
Parte de la información aparece en idioma inglés.
Sobre mí
I am a Business Analyst with expertise in Supply Chain Management, advanced SQL, and Python data analysis. I increased stock availability by 30%, reduced dead stock by 50%, and improved demand forecasting accuracy by 25%. I am experienced in stakeholder management, developing data pipelines, and creating dashboards for apparel, home decor, and FMCG industries.... Lee más

Habilidades

p
p_solver_nitian
Ankit K
desconectado • 
Tiempo medio de respuesta: 2 horas

Revisa mis servicios

Análisis de la cadena de suministro
I will create dashboards, and data analysis reports using sql, pandas
DeUSD 10 / proyectoMás información
Consulta de Data Analytics
I will write complex sql queries and optimize queries
DeUSD 10 / proyectoMás información

Porfolio

Experiencia laboral

PANDORA

Data Analyst || Business Analyst

PANDORA • Tiempo completo

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%.