John M Jarosinski Email & Phone Number

Mt. Juliet, Tn

Inventory Management and Business Analytics

Inventory Management and Business Analytics

Smyrna, Tennessee

Inventory Management and Business Analystics

Successfully manage the retailer’s service parts inventory at over 400 Saturn facilities nationwide. Manage a team of RIM analysts that work closely with the Retail Parts Managers determining the appropriate amount of inventory needed to support the Saturn customers. - Sales of $400 million per year. - Managing $42 million of inventory. - Achieving 87% Off the Shelf Availability of service parts to the customer. - Successfully managed project to receive accessory orders from the vehicle platform and process, ship and invoice appropriately. Completed project without spending any IT budget.

Supply Chain Management Project Manager (November 2004-July 2006) - Developed process and system to manage 40 million dollars of consigned inventory at 3rd party locations. - Saved GM $3 million by working with local resources to build PC based windows system instead of adding new functionality to legacy mainframe system. - Developed business requirements for various system convergence activities between SSPO and GM Service Parts North American Operations to lower operating costs.Forecasting/Supplier Management Team Leader (January 2004-November 2004) - Implemented new Safety Stock Strategies which lowered the inventory investment by 20% while still achieving 97% warehouse availability. - Saved millions of dollars by successfully implementing a new custom Long Term Forecasting module which was co-developed with 3rd party software company (Mercia Software). This Long Term Forecasting module provides 15 year forecasts used to perform economic analysis on long term buy decisions. This system was originally quoted to cost $2 million, but we completed the project for $200 thousand. - Improved availability of parts from European suppliers, Ship Direct suppliers, and Allied suppliers by increasing visibility of parts throughout the order cycle. - Improved supplier performance by developing a supplier development process for all SSPO suppliers.

System Support Analyst Team Leader (August 1998-January 2003) - Successfully expanded my role as the System Support Analyst into a team of Analysts. - Lead, trained and developed the System Support Analyst Team which was responsible for the development and support of SSPO’s Decision Support System. - Expanded the power, scalability and effectiveness of our Decision Support System by leading the project to implement SQL Server as our new Data Warehouse and reporting server.System Support Analyst (January 1995-August 1998) - Embraced newly created role specifically tailored to utilize my business, computer programming and data warehousing knowledge. - Successfully completed project to move from a Paradox data warehouse and reporting environment to a MS Access environment. - Improved the effectiveness of various SSPO business teams by creating computer applications that supported new streamlined/automated processes. - Trained and provided technical assistance to the Data Analysts on the proper use of IT tools while developing policies and procedures for maintaining a central repository of data (a Data Mart). Data Analyst (June 1993-January 1995) - Improved the performance, efficiency and quality of the end users day-to-day activities by developing customized personal computer tools and reports. - Saved the company thousands of dollars a month by reducing transactional system costs by moving the reporting environment off the mainframe into a windows based local area network environment. - Successfully implemented a Data Warehouse/Data Mart that allowed the Data Analysts to quickly analyze data and create reports to satisfy our rapidly growing business.

Powertrain Manufacturing - Saved the Plant Metallurgist hours per day by developing, coding and implementing a C++ computer program to automate the printing of Statistical Process Control charts used to manage the heat treat process. - Improved efficiencies in the Metallurgy lab by implementing the use of a computer controlled hardness tester used in the daily process of monitoring the heat treat process. I was responsible for procuring and programming the equipment, as well as training the technicians. - Equipped the executive leadership of Saturn’s Powertrain Manufacturing facility with a presentation which told the story of Saturn’s difference and uniqueness as it related to manufacturing engines and transmissions.Vehicle Systems Manufacturing - Improved effectiveness of the door assembly line by designing superior tools, fixtures and procedures. - Improved the ergonomics of the door header seal installation process by working with the supplier to ensure the door headers were built to specification. Service Engineering - Utilized my Technical Writing skills to write the Electrical section of the Vehicle Service Manual used by the retailer’s technicians. - Validated and improved removal and installation procedures - Validated and improved diagnostic troubleshooting procedures.