Welcome to Mourya's Portfolio!
Who am I?
I am a passionate individual who has honed an exceptional attention to detail and innovative problem-solving skills through over five years of experience in Supply Chain space in retail and manufacturing companies, coupled with a year of education in analytics.
Inside this portfolio, you'll discover a collection of my finest work, insights, and experiences that define my journey in business and analytics.
Dive in to explore the milestones and creative solutions that have marked my path. I'm thrilled to share my adventures in melding business acumen with analytical prowess with you and eagerly anticipate the collaborative opportunities that lie ahead.
Let's embark on this exciting journey together!
Core Competencies
- Technical: Data Analysis & Visualization, Supply Chain Systems Knowledge, Forecasting & Statistical Modeling, Process Improvement Methodologies, Supply Chain Analytics
- Managerial: Strategic Planning, Leadership & Team Management, Communication & Stakeholder Management, Risk Management & Decision-Making, Project Management
WORK EXPERIENCE
Krenicki Center for Business Analytics and Machine LearningWest Lafayette, Indiana
ConsultantNovember 2023 - Present
Client: Kimball International, Inc.
- Facilitated inventory reallocation by identifying product cannibalization with -0.34 correlation between brands.
- Performed k-means clustering, identifying 56.7% of positive purchases from a unit contributing only 13% overall.
- Enhanced inventory management by forecasting shipping and booking trends with 9.84% MAPE using SAP SD data.
- Successfully led a team of 5, achieving results 20% ahead of the original deadlines through planning, task prioritization.
Gupta Sales CorporationMandapeta, India
Worked in retail, distribution, and manufacturing company
ManagerNovember 2021 - July 2023
- Boosted revenue by 43% by managing the supply chain to launch a retail unit & introducing a new electrical division.
- Decreased Days Inventory Outstanding from 59 to 46 days by streamlining procurement strategies through retail unit.
- Achieved less than 20% sales variance for 73% of products through effective assortment planning for the retail unit.
- Drove 25% sales growth and expanded the retail network by 40 retailers by building strategic partnerships with brands.
- Streamlined labor planning using MS Project and workload analysis, increasing on-time delivery rate by 20%.
- Drove down cost of quality by 20% using FMEA and SPC, improving inspections and testing to cut defects by 25%.
- Managed a team of 8 and worked cross-functionally with product, sales, & operations teams using agile methodologies.
Senior AnalystMay 2020 - October 2021
- Lowered costs by 40% & multiplied margins by 3x through vendor analysis & supplier change for water line products.
- Mitigated risk by identifying a 16% loss from a 2% sewer pipe discount using A/B testing on retailers.
- Increased daily tank production from 28 to 36 by optimizing production processes through DMAIC methodology.
- Reduced raw material costs by 9% by price prediction with 4.23% MAPE, aiding budgeting & procurement strategies.
- Shortened avg. trip duration by 2 hrs & no. of delivery points per trip by optimizing pricing strategy for 3,000-ltr orders.
- Led a team of 3 to identify & resolve supply chain inefficiencies and implement process improvement strategies.
AnalystMay 2019 - April 2020
- Minimized Stock-Outs by 27% in a quarter by conducting supply chain vulnerability analysis, mitigating risks.
- Improved inventory turnover by 18% in a quarter by forecasting demand and adjusting reorder points & quantities.
- Attained a 25% reduction in logistics costs by optimizing vehicle routes, improving network efficiency.
- Cut down inventory holding costs by 21% through inventory rebalancing between warehouses and manufacturing unit.
EDUCATION
Purdue University Daniels School of BusinessWest Lafayette, Indiana
Master of Science in Business Analytics and Information ManagementAugust 2023 - July 2024
Coursework: Optimization, Business Analytics, Supply Chain Management, Analyzing Unstructured Data, AI for Business, Project Management
Christ (Deemed to be University)Bengaluru, India
Bachelor of Technology in Electronics and Communication EngineeringJune 2015 - April 2019
Coursework: Digital Image Processing, Speech Processing, MATLAB.
PROJECTS
Explore my Personal Projects in this section.
FMCG spend and price forecasting Code
Tech Stack: Time series forecasting, Deep Learning, Analytics
Developed advanced time series forecasting models combining statistical techniques (ARIMA, VMD-ARIMA) and machine learning (LSTM, GRU) to optimize spending predictions for FMCG packaging materials over 12 months. LSTM and GRU excelled at predicting commodity prices, while VMD-ARIMA accurately captured package price trends and seasonality, enabling precise cost management strategies.
Supply Chain Optimization for Environmental Impact Reduction
Tech Stack: Supply chain, Optimization, Gurobi, Excel
Undertook a case study optimizing a consumer electronics supply chain to reduce CO2 emissions within budgetary constraints. Evaluated transportation modes through scenario planning, devising a cost-effective strategy minimizing environmental impact. Gained insights into integrating sustainability in logistics operations through data analysis and strategic decision-making.
Descriptive analytics using SQL queries
Tech Stack: SQL, MySQL, DBMS
Descriptive analytics conducted on clothing shipment data involved SQL queries to analyze vendor performance, regional quantity breakdowns, pandemic impacts, and shipment delays. The insights guide strategic decisions for optimizing vendor relationships, regional strategies, and supply chain efficiencies.
Classifying Craigslist Ads to Improve User Experience Code
Tech Stack: Python, Logistic Regression, Naive Bayes, XGBoost, LSTM, NLP, Deep Learning, Machine Learning
This project aims to improve Craigslist's accuracy and user experience by addressing misclassified computer-related listings. Using NLP and LSTM neural networks, it targets the prevalent issue where 40% of computing product listings are misclassified. By training various ML models, notably LSTM, promising results were obtained, emphasizing continuous retraining and broader applicability for enhanced marketplace relevance and user satisfaction.
Optimizing Airbnb's Performance: A Dual Analysis of Superhost Impact and Booking Factors Code
Tech Stack: Python, Business Analysis
The project scrutinizes Airbnb's superhost status impact on revenue and proposes program restructuring for enhanced host benefits and increased bookings. Additionally, tract-level analysis identifies factors influencing average bookings, aiding strategic decisions for hosts and Airbnb. By leveraging data-driven strategies, the aim is to optimize host revenue and guest experience, ensuring a profitable and efficient platform.
Agile Project Management for Optimizing Airbnb's Global Operations and Superhost Program Code
Tech Stack: Agile, Jira, MS Project, Project Management, Kanban
Utilizing MS Project and Jira for comprehensive project management, the initiative evaluated Airbnb's superhost criteria and conducted tract-level analysis to optimize booking processes. Agile methodologies, stakeholder collaboration, and robust data analysis techniques like machine learning enabled actionable insights and policy refinements, while emphasizing flexibility to adapt to evolving requirements for Airbnb's global service excellence.
Production Planning Case Study
Tech Stack: Optimization, Gurobi, Excel, Production planning
Built an optimized production strategy for a salmon processing plant handling fish under operational constraints and fluctuating market demands. Employed scenario planning, data analysis, and strategic decision-making to maximize output, profitability, and resource utilization while adhering to quality standards and market requirements, enhancing supply chain management skills.
Global Tapestry: Charting the Nexus of GDP, Food Security, and Climate Change Code
Tech Stack: Tableau, Excel, Web Scraping
This project explores the interplay between economic performance, food trade, and environmental sustainability using World Bank data from the 1960s to the 2020s. By identifying correlations and regional patterns, it aims to inform policy for sustainable development, emphasizing the complex global context and interconnectedness of economic growth, food security, and climate change for better governance and practices.
Predicting Consumer Tastes with Big Data at Gap Code
Tech Stack: Web Scraping, Python, Data Analytics
The project analyzes Gap's declining sales and proposes a data-driven solution. It emphasizes the balance between brand identity and data-driven strategies, advocating for leveraging insights for marketing while maintaining creativity in product design. It cautions against overreliance on predictive analytics and recommends a balanced approach to blend data insights with emotional connection for effective brand building.
Enhancing Digital Reach and Engagement: A Google Ads NMI for Dream Preparatory Academy Code
Tech Stack: Digital Marketing, Google Ads
Collaborated with Dream Preparatory Academy through the Google Nonprofit Marketing Immersion Program, enhancing their digital marketing. They expanded geographic targeting nationwide, significantly improved ad quality by introducing over 600 new keywords, and achieved better engagement, leading to increased impressions and click-through rates.
Interactive LEGO Set Analysis Dashboard Code
Tech Stack: Power BI, Business Intelligence, Data Visualization, Descriptive Analytics
Created an interactive PowerBI dashboard visualizing LEGO set production trends, parts usage, and component characteristics over time. Users can apply filters for themes, sets, years, colors, and part categories to dynamically explore data, analyze complexity, forecast part counts, and investigate color/part category distributions across different LEGO products.
SKILLS
Here is a snapshot of Technical Skills that I bring to the table.
Technical Skills
- SQL, Python, R
- Tableau, Power BI, Excel (Advanced)
- SAP, Tally ERP Systems
- CRM, WMS, TMS, IMS
- Smartsheets, Jira, MS Project
- Cloud Platforms (AWS, Azure, GCP)
- Forecasting Tools and Techniques
Supply Chain Expertise
- Inventory Management & Optimization
- Procurement & Vendor Management
- Logistics & Transportation Planning
- Demand Forecasting & Sales Planning
- Supply Chain Risk Assessment
- Warehouse Management & Rebalancing
- Vendor Performance Analysis
Analytical & Process Improvement Skills
- Lean Six Sigma (Black Belt Certified)
- Statistical Modeling & Forecasting (ARIMA, Regression)
- Root Cause Analysis (RCA), DMAIC
- Risk Assessment & Mitigation
- Cost-Benefit Analysis
- Process Workflow Optimization
- Predictive Analytics
Business and Project Management
- Strategic Planning & Cost Optimization
- Cross-Functional Team Leadership
- Agile & Waterfall Methodologies
- Stakeholder Communication & Reporting
- Project Roadmap Development
- Financial Budgeting & Cost Control
- Change Management
CONTACT
Write to me:
e-mail: mourya1991998@gmail.com
Call me: +1 765-694-5023
Location: Cary, NC - 27519