Data Analyst - Supply Chain
Current- Analyzing and interpreting data to drive decisions on operational efficiency and providing actionablebusiness insights to senior stakeholders using dashboards in Tableau and Google Sheets.- Conducted Ad-hoc analysis for the Risk and Commercial team which led to identifying 4k+ products lost in transition and providing service improvements to eliminate issues and process gaps leading to cost savings and revenue optimization by estimated cost savings of €37K- Created a data model for forecasting outbound and inbound shipment volume using statistical analysis, A/B testing and machine learning algorithms in Python with an accuracy of 98% leading to improved Warehouse capacity management and reducing backlog days by 72%- Optimized Return to Sender (RTS) workstream by automating data extraction (ETL) in an integrated dashboard using AppScripts in Google Sheets for improved tracking, claims, and incidences reporting leading to increased efficiency by 90% with DHL and 70% with UPS Q/Q providing impact using dashboard in Looker studio.- Owned and managed a project for improving B2B and B2C ticket resolution providing actionablerecommendations, service improvements, and creating a script in Python leading to improved solving of tickets within 7 days SLA by 64% Q/Q and faster customer contract closure.- Collaborated with Product Owners, senior stakeholders, and B2B teams to provide actionable business insights and key metrics using Tableau and Google Sheets that improved decision-making and optimized KPIs in areas such as product development, customer returns, and warehouse management.- Collaborated with Supply chain and Warehouse teams to optimise Customer returns process by writing a SQL script in Redash leading to cost savings of 24K YoY- Owned and managed LOX project to identify potential lost products by carriers using SQL script in Python leading to submitting claims on time and cost savings of €13K/Month
