Data Analyst

AARON WOOD

Royal Oak, MI 517-***-**** *********@*****.*** linkedin.com/in/aaron-m-29a7631715 Analysis /Buyer/Supply Chain

I have a passion for finding ways to reduce cost, through new suppliers, six sigma process improvement activities or through supply chain activities. This is the key to ensuring a healthy profitable supply base with quality products and raw materials to help an organization achieve its goals of producing a quality product to its end users. I excel at building and fostering relationships to collaborate and achieve cost reductions as a partnership. Recently I earned a Google Data Analytics certificate, I did this as data should be driving the decision making to achieve organizational goals and I wanted to understand the process behind the analytics to be able to utilize this tool when needed. PROFESSIONAL EXPERIENCE

FANUC North America Rochester Hills, MI

Logistics Process Improvement Analysis January 2024 – March 2025 Worked with upper management to document and improve internal processes.

• Wrote over 20 plus Work Instructions/Processes for FAUNC Logistics to adhere to ISO9001 standards.

• Facilitated and trained multiple ORG’s/Plant Logistics personnel on processes and guidelines.

• Participated in the ISO9001 Audit process for FANUC Corporate to obtain ISO9001 Certification of a newly open ORG’s/Plants.

• Participated in ISO9001 Audit process for FANUC Corporate ISO9001 Recertification of existing ORG’s/Plants.

• Help Facilitate the redesign of the internal PRL site to Log incoming non-project and non-inventoried items to be more efficient and effective.

• Develop and created an inspection process to drive outbound quality to eliminate damaged items being shipped to end users.

• Process improvement of the RTS process from work centers back to warehouse inventory items/parts to reduce risk of shipping used damage parts to external end users.

• Facilitated FANUC Service Department to adhere to RTS Guidelines so that warehouse inventory items/parts to reduce risk of shipping damage parts to external end users.

• Managed 5 CAR’s that were assigned to Logistics to ensure processes are followed to eliminate risk of the event happening again.

United Wholesale Mortgage (UWM) Pontiac, MI

Underwriter April 2021 – April 2023

Conducted loan underwriting activities for the top mortgage company in the US, adhering to guidelines and consistently exceeding Loan Quality (LQ) and customer service Key Performance Indicators (KPIs).

• Subject matter expert for the following products; Fannie Mae, Freddie Mac, jumbo, HELOCs, and MI Busters products.

• Analyzed credit reports to understand borrower's credit capacity, housing to debt ratios. Also reviewed and approved third-party documents, including purchase contracts and title reports.

• Analyzed and assessed risks for Automated Underwriting (AUS) findings, insurance, taxes, title, and appraisal documents. Validated accuracy calculations and ensured data integrity in the AUS response.

• Verified appraisals to ensure adequate collateral following Fannie Mae and Freddie Mac guidelines.

• Collaborated with processors and mortgage brokers to identify alternative solutions for denied loan files.

• Provided mentoring for new hires on processes for underwriting and clearing conditions as well as assessing required documentation. Assessed confidence and readiness for role.

• Mentored poor performing teammates, double checked work and help develop and implement process improvement and knowledge gaps to reduce Loan Quality errors for the company to help management to improve Loan Quality. Helix Diagnostics Waterford, MI

Logistics/Warehouse/Purchasing Supervisor March 2020 – September 2020 Managed the high-volume Supply Chain, outbound logistics, inbound logistics and Couriers for growing medical laboratory specializing in providing COVID tests at the height of the worldwide epidemic.

• Managed a 9-member team providing warehouse shipping, receiving, and inventory.

• Sourced and developed new relationships with 4 distributors as volume increases gave the company negotiating power to reduce cost.

• Optimized laboratory supplies across all product lines supporting unprecedented outbound PCR test, decreased cost 55% from previous supplier, with daily usage increasing from 2.5K per month to 2.5K per day.

• Built and implemented inventory tracking and reporting system using complex Excel spreadsheet to set reorder points.

• Was instrumental in costs reduction activity across labs by 33% through group purchasing umbrella and monthly allocations.

• Collaborated with Blood, Toxicology, and PCR Lab Departments to meet time-sensitive purchasing needs.

• Expanded courier routes by 100%, including hiring, training, and scheduling courier staff.

• Developed Standard Operating Procedures (SOPs) for shipping and courier roles to help ensure compliance with College of American Pathologists (CAP) standards. Wrote department-wide training manual to improve staff performance. Atlas Copco Auburn Hills, MI

Business Systems Analyst/Project Manager December 2018 – August 2019 Oversaw SAP Project process design and software roll outs to three North and South American (NASA) partners.

• Collaborate with South American managers to gather business requirements then categorized and prioritized each as a government requirement, business need, or business want.

• Partnered with business process experts across business areas to identify best practices, share knowledge, and design efficient end-to-end process flows during and after SAP implementations. This included developing a tariff calculation system and one to generate government Nota Fiscal paperwork.

• Collaborated with Customer Center stakeholders and global implementation team to review customer support and inside sales business processes and drive continuous improvements.

• Created a workaround solution for the Mexican VAT tax document which was not working correctly.

• Used Jira agile tool to manage software improvements backlog and track project requirements through completion.

• Streamlined communication of requirements and software changes between business area and implementation teams to keep all stakeholders informed.

• Facilitated change management activities related to SAP implementations, including new solutions and providing support to Key Business Users to help foster confidence in the new system. American Mitsuba Corporation Novi, MI

Program Manager/Sales Representative December 2015 – November 2018 Account Manager for multi-million-dollar, Original Equipment Manufacturer (OEM) Tier 1 and 2 supplier sales program generating

$120M+ in sales from leading suppliers, including Nissan.

• As a Program manger communicated with cross-functional teams of engineers, suppliers, and plant-operations to design, build, and deliver specialized automotive parts in time for new product launch.

• Maintained and analyzed product pricing, cost changes, retroactive payments, lump sum discounts, and partner numbers/deviations of pricing and design levels returning savings up to 3% over life of programs.

• Led a Process Improvement activity that led to Value Analysis (VA) and Value Engineering (VE) activities to find opportunities to reduce costs and improve products as part of Kaizen activities.

• Created Sales reports for responsible product lines, forecasting 1 - 5 year outlook on profitability and future financial performance of current business.

• Reduced product costs up to 3% and reduced environmental impacts by switching to green packaging optimizing shipping locations.

• Prepared Request for Quotation (RFQs) to maintain current business on seven platforms and multiple product lines, including an award for new flagship vehicles.

• Led APQP activities for one of the production plants as new business was awarded.

• Developed strong customer relationships and leveraged product knowledge to support key accounts, forecast and drive sales, and maintain high levels of satisfaction through renewed business. Pipeline Packaging Troy, MI

Inside Sales Representative September 2014 – July 2015 Managed 125+ key accounts and established reorder points to streamline purchasing and growing sales to $640K annually.

• Followed up on leads and used product and industry knowledge to close sales.

• Developed sales forecasts and sales reports as well as analyses of price increases/decreases, driving overall profit margin from 33.62% to 35.37%.

• Drove sales performance by providing exceptional customer service and maintaining strong working relationships with key decision makers to manage expectations on all new and existing accounts.

• Reviewed lost opportunities with inside sales associates to guide process improvements. ADDITIONAL PROFESSIONAL EXPERIENCE

Operations Manager in Training (2005), • JB Hunt, Lansing, MI TRANSPORTATION / LOGISTICS OPERATIONS & SALES REPRESENTATIVE (2006 to 2009) C.H. ROBINSON WORLDWIDE, Brighton, MI LOGISTICS COORDINATOR (2011 to 2012) RYDER AUTOMOTIVE (EXPRESS EMPLOYMENT), Farmington Hills, MI Inside Sales Representative (Honda) (2012), • Worthington Specialty Processing, Taylor, MI EDUCATION

• Bachelor of Business Administration, Northwood University, Midland, MI Marketing Management CERTIFICATION AND TRAINING

Google Data Analytics Certificate (Coursera), Six Sigma Black Belt (Central Michigan University) TECHNOLOGY SKILLS

Oracle, SAP ERP, Salesforce, R, SQL, Tableau, Jira, Customer Relationship Management, MS 365/MS Office (Word/Excel/ PowerPoint/Outlook)

Contact this candidate