Mark Spaulding Email & Phone Number

Waterford Township, Mi, Us

Centerline, Mi

• Develop and maintain a solution to collect, manage and analyze key Supply Chain performance metrics data from all of FCA’s major global markets using MS Office suite. • Establish a method to quickly and accurately summarize and aggregate each of the individual global markets Supply Chain data into Country, Regional and/or Global Supply Chain performance metrics. • Work with the global markets to train them on new data collection processes and templates, data requirements and definitions, calculations and continuously working to standardize metrics across all FCA business entities.• Develop, validate and support various Supply Chain KPI metrics reports to include data summarization tables, aggregations, dashboards and graphic visualizations in different reporting formats such as PowerPoint presentations and MS Excel reports as well as data preparation and feeds for QlikView and Qlik Sense applications.• Assigned to various projects within the Mopar Supply Chain group with focus on process documentation, process improvement, detailed data validation across multiple systems and platforms and warehouse performance analysis.

Troy, Mi

• Work with external clients to gather all business requirements, logic and criteria related to their contingent workforce data.• Build automated MS Excel programs by updating VBA macros based on the client’s requirements, determining and adding customized validation formulas and produce summarized error reports in order to repeatedly validate new data sets.• Consistent communication with the client to review their data and any exceptions, develop plans and/or adjustments to the data or data hierarchies until 100% compliance is achieved. • Project management of (3) or more clients at a time, each with specific deadlines, budgeted hours, scope, implementation type and project time frames ranging anywhere from (3) to (12) months.• Work directly with the IT developers building the VMS systems to coordinate and ensure all data formats and layouts are synced and aligned for the final process of uploading the data to the system.

Centerline, Mi

• Create a solution to determine the daily Supply Chain performance for (8) international markets based on order fulfillment, backorders quantities, warehouse inventory levels as well as inventory levels in the Supply Chain/Logistics pipeline such as pending orders, ocean/air shipments, customs, etc. using Chrysler and Fiat systems including SAP.• Develop, automate and maintain daily and weekly reporting for each market using MS Access and Excel to communicate performance, backorder levels, inventory pipeline analysis and other KPI metrics to the markets and upper management.• Work with other business units to identify requirements and criteria for ad-hoc reporting and presentations.

Troy, Mi

• Manage inventory levels (including reconciliation) for a majority of the company’s products located at (2) warehouses including “virtual” inventory based on different sales channels.• Create and maintain trending and forecast reports to determine additional purchasing quantities and timing, supplier priorities and timing schedules and warehouse kitting, de-kitting and shipment expectations.• Worked closely with many other business units such as marketing, finance, purchasing and sales to determine best Supply Chain business decisions based on these trending and forecasts reports.• Maintain and communicate all current backorders and even potential future shortages, provide status updates and assist in the quick and timely resolution of all backorders.• Maintain efficient warehouse costs by evaluating and making recommendations for destroying excess and obsolete products and materials.

Troy, Mi

• Develop and maintain Access databases to link systems to collect data for the banks $200+ billion worth of loans. • Create queries, formulas and macros within these databases and link with Excel templates to efficiently and accurately create high level reporting and graphs and analyze for accuracy, data integrity and trending spikes.

Troy, Mi

• Work with several different business units within the post-closing group to develop and maintain business process standards and tangible ways to track the performance of each business unit. • Develop Access databases and Excel reporting to assist each business unit in tracking their production performance. • Create dashboard based reporting specific to each business unit using Six Sigma methodology from several data sources such as Access, Excel and Crystal Reports to assist in monitoring many aspects of the businesses performance. • Participate on Six Sigma projects, Six Sigma Champion training, and collect and report data for other projects as needed.