SEARCH

S&OP Manager/BI Developer Resume Example

Resume Score: 80%

Love this resume?Build Your Own Now
S&OP MANAGER/BI DEVELOPER
Professional Summary

CPIM and LSSGB certified Supply Chain Professional with over 7 years of successful experience in Demand, Operations and Inventory Planning. Successful track record in achieving performance excellence and business targets for supply chain processes. Strengths in Team management, process improvement and Data Analytics backed by training in Leadership and Continuous Improvement.

Skills
  • Python
  • Advanced Excel, Macros, VBA
  • ETL Processes
  • Predictive Models
  • Effective Problem-Solving
  • Dashboard Development
  • SQL
  • Data Analysis
  • Business Intelligence (Bi), Power BI
  • Process Improvement
  • Reporting Systems
  • Automation
  • Attention To Detail
  • Descriptive, Predictive, and Prescriptive Analytics
Work History
S&OP Manager/BI Developer08/2016 to Current
Company Name – City, State
  • Designed, built, and oversaw S&OP, Demand and Supply planning data system by merging multiple complex data sources to increase visibility and accountability into key forecast and KPI metrics
  • Publish build plan and coordinate cross-functional research activities to reconcile significant variances from KPI's, refine forecast models and mitigate supply and demand risks.
  • Collaborate with leaders within sales, marketing, finance, operations and supply chain to establish, lead and drive S&OP process to meet near and long-term demand, supply, financial, and material/inventory goals.
  • Directed implementation and development of supply chain business intelligence tools to extract key information from data and aid in Root Cause Analysis.
  • Designed and built Multi-Layer KPI reports model using Power BI, Python, SQL and Excel. Report is capable of descriptive, predictive, prescriptive and "what-if" data analytics
  • Revised forecasting model to use blend of quantitative and qualitative inputs from multiple sources using Python and PBI. Reduced forecasting errors by 30%
  • Achieved 33% improvement in business growth by developing key metrics and applying Lean Six Sigma methodologies.
  • Achieved 0% stock out and 16% inventory reduction by establishing inventory targets, stock level and risk mitigation targets and managing flexibility strategy to optimize inventory
  • Managed shortage meetings to identify material shortages and monitored inventory levels to meet order delivery requirements.
  • Achieved 33% improvement in business growth by developing key metrics and applying Lean Six Sigma methodologies.
  • Revised forecasting model to use blend of quantitative and qualitative inputs from multiple sources using Python and PBI. Reduced forecasting errors by 30%
  • Achieved 0% stock out and 16% inventory reduction by establishing inventory targets, stock level and risk mitigation targets and managing flexibility strategy to optimize inventory.
  • Designed and Built data and analytics-based capacity simulation model in Power BI
  • Achieved equal revenue in 2020 compare to 2019 with 15% less head count, resulting in $1.4mil+ in labor cost savings.
  • Trained multiple process owners in root cause analysis, data analysis, Lean, Six Sigma, CI, Power BI, Python, Excel, VBA, Macro skills
Materials Planning Manager01/2016 to 12/2018
Company Name – City, State
  • Designed and built company's first automated Warehouse and Inventory monitoring system visualizing receipts, put away, and adjustment. Improved supplier On-Time-Delivery by more than 15%
  • Develop and control Cycle Count(CC) program and responsible for ABCD classification, Variance monitoring, and Root-Cause Analysis
  • Develop and control multi-layer inventory control KPI module to track Inventory Turns, PPV, Supplier PPM and On Time Delivery(OTD)
  • CTB Manager, responsible for conducting shortage meeting to provide visibility on material supply and highlight gaps and constraints
  • Decreased material expenses by 20-30% by warehouse redesign, managing EOQ, managing safety stock and managing tracking and supply.
  • Improved On Time Delivery by 20% (up to 99%) by scheduling deliveries of materials by specified time to begin production on time.
  • Realigned production schedules to factor in changing conditions such as materials shortages and changing designs.
  • Created, implemented and adjusted SOPs.
  • Strengthened inventory processes to balance supply needs with budget and space limitations.
  • Developed and monitored obsolescence (O&E) contingency plan working with Engineering, Purchasing, and operations. Successfully dispositioned $1.5mil+ worth of material
  • Improved Inventory accuracy by 30%, taking it from 50% to 80% by implementing mix of Point-of-Use, Kanban, supermarket, and traditional warehouse strategies
Production Planner/Master Scheduler01/2016 to 12/2018
Company Name – City, State
  • Worked directly with production personnel to resolve production scheduling issues and conflicts.
  • Development and monitoring of rolling 3-6 months Master Production Schedule. Created Automated Master Schedule Reports with use of Python, SQL, Excel (VBA and Pivot Tables)
  • Engaged in both long and short-term project planning, from 1 to 12 month, strategizing for on-time, high-quality deliverables.
  • Realigned production schedules to factor in changing conditions such as materials shortages and changing designs.
  • Designed, Built and Controlled fully automated Master Production Scheduling system
  • Managed and lead supply plan execution and optimization meeting responsible for expediting, postponement, Lead time review, consolidation etc.
  • Designed and Built Shortage report meeting structure with business leaders to reconcile schedule and material shortages and create future roadmap to close gaps
  • Lean, Six Sigma, TOC and Continuous Improvement principles training to operators and supervisors, leading multiple Lean and Six Sigma project for continuous improvement
  • Improved production lead time by 15% by reducing waste and variability in production system using Lean and Six Sigma continuous improvement strategies.
  • Reduced backlog levels by around 40% by managing bottlenecks, leveling load and maintaining Master Production Schedule
  • Improved On Time Delivery by about 20% by implementing standardized production system resulting in predictable and repeatable process.
Education
Master of Science: Industrial Engineering12/2014Northern Illinois University- City, State
  • Graduated with 3.91 GPA
Bachelor of Science: Mechanical Engineering12/2011Tribhuvan University- City
Certifications
  • Certified Production and Inventory Manager (CPIM) - APICS
  • Lean Six Sigma Green Belt (LSSGB)
Build Your Own Now

DISCLAIMER

Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.

Resume Overview

School Attended

  • Northern Illinois University
  • Tribhuvan University

Job Titles Held:

  • S&OP Manager/BI Developer
  • Materials Planning Manager
  • Production Planner/Master Scheduler

Degrees

  • Master of Science : Industrial Engineering 12/2014
    Bachelor of Science : Mechanical Engineering 12/2011

Similar Resumes

View All
S&OP-Manager/BI-Developer-resume-sample

S&OP Manager/BI Developer

Union City, Tennessee