Data Analyst Manager

Swapnil Sharma

***** **** ********* ******, *********, CO, 80111 +1-717-***-**** ************@*****.***

SUMMARY

Supply Chain Management professional that utilizes an analytical mindset, creativity, and passion to drive business growth and operational efficiency as well as help foster enduring connections. Skilled in Microsoft tools, SAP platforms, and logistics operations & planning.

EDUCATION

Pennsylvania State University

Bachelor of Science: Project and Supply Chain Management August 2016 – May 2020

Bachelor of Science: Business Management August 2016 – May 2020

Lean Six Sigma Training

EXPERIENCE

Reckitt Benckiser, RB Gurgaon, India

Supply Chain Analyst Intern II July 2019 – August 2019

Worked under the Supply Chain Director and National Customer Service Manager to assist in managing the flow of orders and the ability to add value to local business.

Reported and managed orders in EDI and 3PL systems, facilitated, tracked, and optimized RB operations with planners and recommended strategies to improve fill rate, order frequency, lead-times variability, and inventory levels/issues.

Led an intern team to build a high accuracy time series forecasting tool that identified seasonality patterns, customer behaviors, and predictors for bulk returns.

Devised a strategy to study SRN history and analyses to evaluate cost and benefit of Traditional and Modern Trade SRN using advanced Excel and SAP ERP (P1) to bring the current average of 4% per month down to 1% per month.

Incorporated an SRN punching delay in the Modern Trade tracker and suggested what was required to bring the age of SRN (punching) to within 7 days and not more than that.

Li & Fung, LF Delhi NCR, India

Project Management and Supply Chain Analyst Intern June 2019 – July 2019

Managing Warehousing & Logistics Vertical of IN country operation including ZARA & ZARA Perfume E-commerce.

Analyzed key performance indicators (KPI’s) to identify opportunities to improve Warehouse Management System (WMS).

Identified and implemented business process improvements across the supply chain, including inventory control, order management, fulfillment, consolidation, picking and packaging for inventory worth $1.5m with $750k in monthly inventory turnover.

Redesigned the warehouse aisles and shelves by performing advanced data analysis in Microsoft Excel; improved picking productivity by 20% and ensured on-time delivery to customers through detailed FMR & ABC analysis.

Used advanced Excel to strategically sort SKUs based on size and seasonality to improve warehouse space optimization by 35% and reduce the amount of time employees spend searching for specific items in picking.

Conducted time studies on packaging stations to determine the non-value-added activities by designing a value stream map; revised the work instructions to improve efficiency resulting in a 15% increase in productivity.

Capgemini Mumbai, India

Associate Consultant Intern June 2018 – August 2018

Worked with the Project Manager and Data Analyst focusing on projects from various clients.

Delivered research and consulting projects across multiple sectors such as insurance, financial services, FMCG, automotive, etc.

Provided tangible insights and recommended to help formulate solutions for clients in terms of strategy on projects which included leading and best practice studies, benchmarking studies and market and competition analysis.

Researched and developed customer centricity maturity matrix model and value chain framework for the organization to measure across industries of various clients.

RELEVANT BUSINESS PROJECT

Business Project Warehouse Management Software: A Comparative Analysis

Skillfully analyzed and researched two different warehouse management softwares systems that will benefit a particular company and improve the work coming from employees within the organization.

LEADERSHIP AND INVOLVEMENT

President International Affair Association/Rotaract Club Pennsylvania State University August 2016 – May 2020

Assisted to develop a positive, collaborative environment that engages the campus, community and commonwealth through community event that allows the University to have a vibrant environment academically and socially.

Delegate of Model United Nation University of Pennsylvania February 2016

Contributed to the conference while working to maintain international peace and security.

TECHNICAL AND COMMUNICATION SKILLS

Applications: Advanced proficiency in Microsoft Office (Word, Excel, PowerPoint, Outlook and Access) Microsoft Visio Microsoft Project

Software: SAP Warehouse Management Software SolidWorks CREO Parametric Dreamweaver Logger Pro Adobe InDesign

Languages: Fluent in English Hindi Turkish Bahasa Indonesia & Partially in Spanish French

Contact this candidate