Jenison, Michigan, United States
Experienced leader in Information Technology and Intelligent Reporting Management, this includes Technology Infrastructure, Application Support, Business Process Analysis, Technology Strategy, and Architecture as well as Project and Program Management. Backed by over 20 years of Financial Analysis experience. I bring a practiced, analytical approach to all challenges. Strong background in technical project management proficiency. Facilitate and expedite projects under reasonable time constraints allowing for mission-critical development and process enhancements. Specialties: Information Technology & Strategy development, Infrastructure Processes, Automating & Programming Development, Project Management and IT leadership Specialties: Financial Analysis, Project Management, and Techincal Management
● Evaluate and report on critical information regarding operational performance for the Challenge Production facilities. Generated comprehensive reports detailing company headcount using Set-At or RTO(Required to Operate) analysis and assist with management functions to evaluate, and provide recommendation for improvements and best practices that will address, minimize or remove cost associate with headcounts. ● Drive monthly KPI’s and Plant Metrics: Build and support Report Development using PLEX Management Tools and Database Management to assist in Financial Reviews for all Plants. Contributed to the reporting of actual versus standard manufacturing costs and associated variances. Managed Plant Cost Recoveries, facilitated coordination among Plant Managers to address supplier debits and issued debit memos to intercompany plants while overcoming challenges. ● Drive Cost Management objectives by planning, studying, collecting, and recording data to determine costs of business activity such as raw material purchases, inventory, labor and the allocation of overhead. Accountable for establishing and disseminating Key Performance Indicators (KPIs) for Quality Cost reporting, ensuring the precise measurement and submission of the Cost of Poor Quality (Profit and Loss) metric for each plant and company-wide, showcasing monthly Quality Costs and highlighting both favorable and unfavorable outcomes. ● Develop performance metrics on Material Adjustments and cost associated with Quality Team to develop process improvements on cost reductions for Year over Year planning purposes. Evaluate Supply Chain Risk Management by managing the development, and implementation of efficient and effective strategies and processes to continuously identify and evaluate risk across the Supply Chain.
● Reported on new and existing quoting activity to Commercial Manager/Commercial Director. Focused on Vehicle Access Equipment with ADAC contracts ranging from 10 to 60 million dollars in total program life. Customers include Ford, Chrysler, and BMW. Quotes supported equipment on vehicles outside door handles, inside door handles, and spoilers. ● Worked closely with Program Managers and Engineering to collect critical quoting data requirements from ADAC internal manufacturing business using Excel to build templates to quote piece part pricing and mold/assemble tooling cost. The departments included Molding and Assembly, Quality Control, Testing & Gauging, Packaging, and Tooling. ● Responsible for New Business RFQ package deliverables (Regional & Global) to meet customer time tables. Supported Sales Team though customer contracts involving Account Manager and ADAC Engineers. Assisted machine capacity estimates in providing information and directed quoting activities as requested by Commercial Capacity Analyst. Modified Excel quote templates in order to update purchased part cost and automate costing processes using links, pivot tables, and filter functionalities in providing pricing estimates.
● Responsible for developing and maintaining North American Savings Tracker Report (Excel/VBA) – This was a repository for all aggregate purchasing spend data, purchasing price variance, supplier spend, material spend and other miscellaneous purchasing data including Crystal Reports/Business Objects. ● Responsible for reporting divisional monthly budget and current actual material spend. Reporting was distributed to Senior Management, Director of Purchasing, and Commodity Managers within Magna North America team. ● Created a risk assessment model (Excel/VBA) to scrutinize actual and forecasted component volume, PPV, and spend (over 400 million dollars in commodity procurement I.e. Resin, Glass, Electrical Components, etc.) on all commodities purchased by Magna Mirrors NA. ● Developed annual operating commodity budgets (Excel/VBA). Worked with Divisional Controllers/Buyers to identified market risk and pricing volatility with future commodity acquisitions. ● Performed independent and objective analyses of purchasing spend data including special studies (Excel/VBA). Resulting spend data analyses and performance metrics (SharePoint) requiring additional resolution was forwarded onto the Director of Purchasing for resolution. ● Maintained purchasing application database system (BAAN ERP) for supplier analysis. ● Assumed the additional responsibility as Buyer Specialist to procure testing and calibration equipment and supplies for Magna’s Engineer and Research Facility. ● Worked with Product Engineers and set up requisitions/purchase orders (BAAN/ERP) for all component testing equipment and external consultant work request.
● Developed an Underwriting Risk Assessment Model (Excel/VBA) in support of Internal (Underwriting and Sales) and External (Clients, Consultants and Brokers) matrix business partners. ● Extracted data from BI (Business Objects), performed analysis, communicated results of financial analyses and provided recommendations to manage findings. ● Consulted and matrixed external leadership activities with business partners, clients, brokers and consultants with report development (Facets ERP). ● Provided support for Chief Underwriter and Sales Director as well as other internal departments and external matrix business partners. ● Streamlined critical underwriting Quote Log reporting and Quote Performance analysis to support client reporting and related metrics (Excel/VBA). ● Reconciled the generated reports with the control totals using an acceptable percentage variance (Excel/VBA). ● Prepared and organized supporting documentation to ensure reports were readily available to the underwriting and sales management, clients, brokers and consultants.
● Acted as a liaison between the Business Line, Support Services, and IT department to ensure that business requirements were identified, defined and documented, and appropriately fulfilled. ● Supported the implementation and design of financial reporting using (Comshare) and database using (PeopleSoft) by the Regional Controllers of BDO Seidman. ● Provided improvement and feedback on business problems within the Comshare ERP and PeopleSoft financial systems to determine the accuracy and functionality of monthly reports. ● Displayed leadership (project based) for the justification, planning, implementation, and quality assurance testing of assigned projects. Coordinated with appropriate resources and scope to ensure database systems were rolled out efficiently with associated training materials provided to end users. ● Interfaced internally with BDO software programmers, developers, and external users to implement best practices towards project completion. ● Maintained accountability to functional BDO comptrollers for processes and systems improvements within their areas of responsibility. Advised management on ethical adherence to effective project management methodologies.