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, LLC2018 – 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, LLC2014 – 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 Pvt2013 – 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 University2015 – 2016
PGDM in Marketing Management
Bachelor of Commerce
Mumbai University2009 – 2012
Bachelor of Commerce
Master in Operational Analytics and Management
Worcester Polytechnic Institute2017 – 2018
Master in Operational Analytics and Management