Children's Hospital of Philadelphia

Supply Chain Analytics

Walmart Labs

•Implemented analytical solutions to reduce stock outs at stores, with 74% accuracy (~20% previous solution) on ~70k items in the US assortment  
•Experimented using algorithms such as XGBoost and Facebook Prophet to design machine learning powered inventory optimization 
•Created a waterfall dashboard using SQL-Hive and Tableau to root cause vendor order forecasting error 
•Introduced an outlier detection tool coded in Python to flag unusual customer item demand time series

Senior Data Analyst

Chewy

• Analyzed customer data, surfaced insights and tracked a variety of initiatives to reduce shipping damages. Led cross-functional weekly calls and helped reduce the rate by 19% 
• Improved a process to catch customer abuse of the refund policy, increased the numbers of abusers caught by 42%. Wrote the logic in SQL and implemented tableau dashboards for efficient deep dive into fraudulent customer transactions 
• Conducted statistical root cause analysis, tested various hypothesis, tracked output metrics and coordinated across cross functional teams to improve products with the lowest customer rating
• Supported product managers and developed A/B tests for various features implemented on the website

Analytics Program Manager

• Increased efficiency by 37% through development of an automated inventory purchase system, used R programming to create the tool
• Designed supply models for 23 globally sourced categories, in six months improved the in-stock ratio by 15%  
• Consolidated millions of data points and created a predictive inventory model using SQL and R programming. The marketing team used the inventory projection for promotional product selection
• Created an automated Python script to scrape delivery status of LTL vendor shipments from the FedEx website, saved 15-man hours per week 
• In four months launched 112 globally sourced products, with the collaboration of marketing, forecasting, transportation and category teams

Supply Chain Planner

• Set the inventory strategy for a $10MM product category, improved the in-stock ratio by 21%  
• Implemented a safety stock plan to meet 99% SL for 35,000 items at four US warehouses, created the review process and data pipelines for a weekly automated item level setting change based on dynamic variables 
• Responsible for the mentorship and management of 6 junior analysts
• Designed the company’s first data warehouse for inventory and forecasting teams. Attended weekly meetings and served as a liaison between tech and business teams 
• Created validation metrics and reduced the daily error rate of supply chain planning software

Senior Supply Chain Data Analyst

• Defined various inventory metrics and provided deep dives into KPI’s using SQL and tableau. Built a data infrastructure to scale any change across all supply chain tableau dashboards at the same time 
• Developed a standardized vendor performance scorecard for ~800 vendors with metrics such as on-time, in-full and warehouse appointment cancellation rate, which was used by the category teams   
• Created and maintained 43 tableau dashboards for forecasting, vendor compliance, transportation and purchasing teams 
• Designed outbound on-time delivery metrics with an expected delivery date, considered variables such as routes, trailer cut times, weekend transit and holidays 
• Responsible for the labor forecast at three fulfillment centers

Supply Chain Data Analyst

ARRIS

• Worked in global S&OP department, led continuous improvement by building interactive dashboards (similar to KPI metrics) using Macros and VBA for raw materials cost trends to improve data collection and analysis. Modified the tool to suit the needs of new product introduction and S&OP teams
• Conducted market research and collected data to assist in the forecasting of supplier prices using current market trends. Designed an internal system for updating of information.

Supply Chain Intern

I am experienced in applying analytical solutions to supply chain, e-commerce, customer service and product domains. 


Taplio

Sivin Mathew's Linkedin Analytics

Sivin Mathew

Want to drive more opportunities from LinkedIn?