SG

Shikhar Gupta

DATA ANALYST · Quantum Sight Marketing, LLC


In My Own Words

Around 4 years of experience as a Supply Chain Analyst and Data Analyst; with focus on E-commerce, Merchandising and Marketing. Proficiency in developing mathematical models for efficient supply chain and regression analysis. My expertise lies in performing logistical predictions, inventory management and report generation while working effectively with cross-departmental team members to maximize productivity, efficiency and overall performance.

Work Experience

DATA ANALYST

Quantum Sight Marketing, LLC

2018 – 2018

• Developed mathematical model to determine which attributes are most likely to yield brand consideration and the likelihood to seek treatment with a particular brand. • Determined which attributes strongly align with Novant and with competitor brands, by geography. • Developed competitive analysis report for Novant Healthcare to understand which attributes are highly coefficient to brand Novant and its competitor. • Assisted in mining and interpreting of data using R Programming and MS Excel.

SUPPLY CHAIN ANALYST

Felt Fetish, LLC

2014 – 2016

• Managed end to end supply chain. Used modelling and optimizing to determine the efficient supply chain. • Expedited internal process improvement opportunities and implemented improvement process like Just in Time, Kanban and six-sigma. • Developed Inventory management plan. • Analyzed root causes of inventory issues and provided resolutions; improving the inventory accuracy by 15%. • Developed mathematical model by geography taking into account population, frequency of order and distances for efficient supply chain. • Tracked KPI (key performance indicator) in order modify procurement. • Coordinated with vendors to negotiate terms, maintain relations and address problem areas. • Performed monthly forecasting analysis and managed logistics accordingly. • Performed inventory and sales analysis to identify areas of concern and suggest improvement. • Created comprehensible dashboards with MS-Excel utilizing pivot tables and VLOOKUP to discuss trends, identify inconsistencies and areas of improvements. • Analyzed monthly, quarterly and annual spend on logistics, materials to improve cost saving and controlled stock pile- up in warehouse through key findings. • Analyzed sales and inventory data, performed comparison analysis between local and central routes and figured out best routing solution for raw material transportation with $10000 cost saving.

ASSOCIATE PROJECT MANAGER

Mahalaxmi Constructions Pvt

2013 – 2014

• Close Monitoring of on-site activities in order to streamline day to day operations. • Analyzed inventory and waste resources which resulted in cost cutting on future orders of raw material. • Developed status report, cost estimated report and resource plan report. • Provided fortnightly projections for material requirements for smooth operations. • Developed Key Performance Indicators for Supply Chain Department. • Implemented six sigma and other process improvement methodologies to improve operations.

Education

PGDM in Marketing Management

Madurai Kamraj University

2015 – 2016

PGDM in Marketing Management

Bachelor of Commerce

Mumbai University

2009 – 2012

Bachelor of Commerce

Master in Operational Analytics and Management

Worcester Polytechnic Institute

2017 – 2018

Master in Operational Analytics and Management