p
p_solver_nitian

Ankit K

@p_solver_nitian

Data Analyst ,Business Analyst

India
Engels, Hindi
Sommige informatie wordt in het Engels weergegeven.
Over mij
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.... Lees meer

Skills

p
p_solver_nitian
Ankit K
offline • 
Gemiddelde reactietijd: 2 uur

Bekijk mijn diensten

Supply Chain analyse
I will create dashboards, and data analysis reports using sql, pandas
VanafUS$ 10 / projectMeer informatie
Data Analytics hulp en advies
I will write complex sql queries and optimize queries
VanafUS$ 10 / projectMeer informatie

Portfolio

Werkervaring

PANDORA

Data Analyst || Business Analyst

PANDORA • Fulltime

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