Rick Stratman Email & Phone Number

Richmond, Indiana, United States

- Created Power Apps to fill gaps and replace current operations and quality control systems- Implemented Power BI solutions including replacing Excel data charts used in meetings, generating TV display slides, production reporting verification dashboards, and inventory maps.- Took charge of Excel production tracking system. Modified macro-based Excel production trackers to be more user friendly and ensure correct data input, reducing user error by 75%.- Create new shop floor KPIs to drive continuous improvements through data driven analysis to maximize throughput and minimize quality defects. - Lead transfer from Clearly Inventory to low-code Quickbase system, fleshing out raw material reporting, adding finished goods inventory, and adding shipping label support.- Part of core team formed to design planned move of a manufacturing department to a new warehouse and gained Lean Six Sigma Green Belt in the process.

Richmond, Indiana

- Brought on to spearhead a project to reduce on-hand amount of regrind, reusable scrap. Reduced inventory by $500,000 while avoiding mass disposals.- Pioneered switch from MS Access database of warehouse inventory to Clearly Inventory web-based system, allowing better inventory visibility and usability.- Monitors and corrects data of production trackers to ensure integrity of reporting- Perform audits of inventory, identifying and fixing gaps in reporting and labelling that cause misses to keep cycle count accuracy above 98%.

Hamilton, Ohio

Client facing, first to receive calls and respond to client problems- Troubleshoots issues and keeps detailed reports of what has been done- Overviews and updates documentation located on OneNote and SharePoint as needed- Manage users accounts through account creation, termination, and maintenance- Software used: IBM Tivoli/Omnibus, PRTG Network Monitor, Samanage Ticket and Asset Management Agent, LogMeIn Remote Desktop

Fairfield, Ohio

Fairfield Ohio

• Setup and managed a landscaping business to help defray school expenses• Increased customer base to provide good source of ongoing income• Over 30 local customers through advertisement and word of mouth• Sold business at the end of 2015