AK

Apurva Kanyalkar

Inventory Analyst - Forecasting Team · Supplyhouse.com

New York, NY

In My Own Words

I am an Inventory Analyst and an MS Graduate in Engineering Management with around 3 years of experience in the Supply Chain Industry and
fluency in supply chain, inventory management, data analytics and business reporting. I am a driven problem solver with proven aptitude in
communication and teamwork, eager to leverage my professional expertise and advanced graduate-level training to drive optimal business results.

Work Experience

Inventory Analyst - Forecasting Team

Supplyhouse.com

2020 – Present

Melville, NY • Worked extensively with inventory forecasting software Blueridge SCP to identify and track product trends, product life cycles, current and future product demands. • Analyzed supply and demand variability, product availability and sales history to optimize inventory cycles and product mix. • Allocated inventory efficiently and analyzed product performance as needed throughout multiple product categories and departments. • Managed inventory levels for 70 brands and over 8000 unique SKUs and showcased efficient handling of late shipments, order cancellations, allocation limits and stock outs to ensure goods arrive to our 4 distribution centers on time therefore maximizing profits. • Created analytical tools and KPI trackers using Excel and analyzed trends to successfully maintain above 94% service level. • Accurately generated active, discontinued and new product purchase plans during normal, promotional and seasonal sales periods. • Ensured optimal product placement, allocation strategy and replenishment quantity to exceed last year's net sales by 58.6%. • Coordinated with Marketing, Vendor Management, Finance and Warehouse/Logistics operations teams to plan and schedule regular pickups, manage backorders, request volume-buy deals and solve pricing discrepancies. • Supported senior company leaders by delivering sales trends and inventory availability reports using data visualization software Blueridge SCA outlining performance metrics and actionable items to drive process improvement. • Demonstrated industry knowledge of inflation, trade policies, consumer behaviour, weather conditions and information not seen strictly in the numbers to improve planning strategy.

Business Intelligence Analyst Co-op - Web Analytics/Product Management team

Business Intelligence Analyst Co-op

2019 – 2019

Developed complex SQL queries using Microsoft SQL Server and Vertica that pulled user activity data and assessed activation rate, adoption rate and other key operational performance metrics for Storefront products across all platforms and for all user-types. • Designed automated dashboards and reports using Tableau to distribute complex business insights in an easily digestible manner to over 300 global employees. • Spearheaded competitive analysis project that focused on studying competitors that utilize camera, voice, location and other services as an entry-point to promote Mobile App usage and explored upcoming trends pertaining to these entry-points. • Piloted the Product Manager (PM) Onboarding initiative for the entire Product Department, managed day-to-day onboarding functions and acted as a liaison between Product Development and the Talent departments. • Analyzed customer data using PostgreSQL to locate customer pain-points to influence App and Site performance improvement. • Computed weekly Net Promoter Score (NPS) for storefront product services and distributed it to product managers. • Optimized inefficient SQL queries and fixed discrepancies in segmentation, ordering and encoding to improve query performance.

Logistics System Project Member

ImEx Cargo LLC

2018 – 2018

• Collaborated with ImEx Cargo LLC, an airline cargo sales agency, to work on improving their customer order tracking system. • Investigated customer order recording and reporting system, Request for Quote (RFQ) process and customer order data and suggested improvements to current quote tracking system. • Designed a relational database model using Toad Data Modeler with 5 data tables that effectively housed customer orders. • Composed a SQL script with Microsoft SQL Server Management Studio that seamlessly integrated customer order database with in-house Logistics system. • Created a user interface with Google Forms to standardize incoming data during the RFQ process. • Slashed number of errors occurring while receiving orders down by ~20% and number of errors while storing data down by ~40%.

Education

Master of Science in Engineering Management

Northeastern University

2017 – 2019

Master of Science in Engineering Management

Graduate Certificate in Supply Chain Management

University of Mumbai

2012 – 2016

Graduate Certificate in Supply Chain Management