Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
USLBMMaster Data Analyst
Mar. 2022 - Mar. 2025Springfield MOCompleted data mapping for Eagle ERP for a client integration on the (ETL Team).
Enterworks administration (ETL Team)
SQL Coding developed for data matching for incoming integrations from Catalyst, Eagle, Spruce, ECS Pro, Agility, Ponderosa (Data conversion Team)
Developed new process for fuzzy matching using product descriptions (Data conversion Team)
Developed python script for data transfers between DEV and Production environments for harmonization of data.
ACS American Construction SourceMaster Data Specialist
Oct. 2020 - Mar. 2022Springfield, Missouri, United StatesMillwork data transformation for two different acquisitions coming from other ERP’s onto BT.
Direct client consultations for data transformation onto BT.
Developed ticket reporting process for group using sharepoint system.
Developed SQL views for inventory analysis and cycle counts in BT.
Forecast reporting for lumber prices and inventory management.
Worked with EPICOR consultants for data uploads for go live.
Salon Service GroupData Analyst
Mar. 2020 - Oct. 2020Springfield, Missouri, United StatesLearned SQL coding on the job in a short time frame. Developed sales analytics reporting that allowed the company to reduce sundries. department by 100$k Across all stores.
Dashboard development for shipments and receipts as well as PO’s. Worked directly with the CEO, finance, distribution and IT departments to provide data solutions .
Forecasting reporting for purchasers.
SRC ElectricalProduction Scheduler
Jan. 2019 - Mar. 2020Springfield, Missouri, United StatesProduction Scheduler
SRC Electrical - Springfield, MO
Jan 2019 to Feb 2020 Scheduling for starter line, coordinated with team leads and floor personnel to meet on time delivery for finished goods.
Scheduled production for starters side of the reman business.
Worked with production managers, team leads to determine future parts shortages due to supplier limitations.
Built a schedule evaluation tool to establish which products will have problems based on shortages.
Handled projections and forecast for starters, drives, solenoids, and generators.
Involved in launch/testing phase of CSI at SRC electrical.
Developed parts yield tracking in a visual format for reclaim to identify jobs that still need to be completed.
Parts shortage tracking and updating, including historical records for repeat offenders. Working on a report to tell us how far into the future we can tear down core and still build FG. Developed grid method for WIP materials saving hours and money.
Forecast reporting for production output for meeting customer demand.
John DeereInventory Analyst
Oct. 2017 - Jan. 2019Springfield, Missouri, United StatesInventory Analyst III
John Deere - Strafford, MO
October 2017 to Jan 2019
Adjustments to all John Deerereman inventory representing millions of dollars.
Managed cycle counters and scheduled daily counts.
Forecasting of material losses based on current incoming reman products.
Analyzed parts inventory reports to determine they ensure accuracy Preform logistical analysis on new and Core parts to determine a replenishment strategy. - Monitor and resolve parts inventory discrepancies causes, i.e missed receipts, scrap, wrong parts used. Acted as liaison between manufacturing, sourcing factories and product engineering, parts distribution centers to ensure parts are available when needed. Developed and participated in inventory related continuous improvement initiatives to reduce costs and improve efficiencies. Developed access based dashboard for SAP processing and documentation.
CertainTeedProduct Analyst
Sep. 2004 - Sep. 2015Kansas City, Kansas, United StatesHelped the Implementation process of SAP in 2004.
Developed schedule charting system by converting orders to a numerical system based on change/run difficulty and re organized the schedule accordingly.
Worked with accounting to setup SAP standards for finished goods materials.
Involved in 5S projects to improve plant performance and reduce cost.
Tracked daily material and time efficiency by each crew, shift, and facility.
Worked with the scheduler to identify material requirement gaps for future schedule and adjusted accordingly.
Tracked raw material consumption and projection for purchaser to ensure materials needed are on hand for batch, packaging, binder, facing, and labels.
Forecasted production on a monthly basis for management.
Completed daily payroll analysis to keep management informed of overhead costs and catch abuse of hours.
Developed a safety reporting system using excel macros to save, email, archive, log, and report all near misses and incidents.
Trash tracking and analysis, comparing reported scrap with actual scrap reported at the landfill.
Assisted in developing the plant headcount budget with accounting.
Developed an alternative quality database to track material performance metrics when a primary system crashed.
-Developed and updated a production dashboard for management using crystal reporting that published results on all efficiencies.
Back calculated SAP batch efficiencies, and identified a gap between what the budgeted and the standard efficiencies were.
Implemented production changeover scoreboard on our largest line to track how many packages were completed each hour.
Intch is a Professional Networking App for the Future of WorkSee more people like Jacob on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
607696 people
21
Visual Designer
17
Assistant manager
16
Customer service specialist
127348 people
17
Assistant manager
15
Founder & Integrative Nutrition Coach @ RENEW with Caroline
16
Customer Interaction Specialist