S&OP Manager/BI Developer Resume Example Raytheon Technologies Corp

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
Raytheon Technologies Corp – Fort Bliss , TX

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
Qorvo – Greensboro , NC

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
Greenfield Products LLC – 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)

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

S&OP Manager/BI Developer Resume Example

DISCLAIMER

Your resume earned a perfect score!

Resume Overview

Create a job alert for [job role title] at [location].

Similar Resumes