Supply Chain Analytics Manager, 09/2012 to Current FIAT CHRYSLER AUTOMOBILES – Center Line, MI
Transformed analytics landscape from a collection of limited-scope, flat-file backed Excel files to suite of self-service dashboards providing deep insights into the supply chain.
Lead a team of 3 business analysts and programmers.
Manage business reporting for NAFTA operations, ensuring accurate and timely provision of mission-critical performance metrics to internal customers, including senior executives.
Redesigned initial reporting to allow for deep-dive analysis and more easily identify opportunities for corrective action.
Supervised the design, development, and implementation of a suite of web-based applications (Qlik), generating annual cost savings of $4M and a reduction of 200+ man-hours of data gathering per month.
Coverage areas include: Operational Efficiency, Quality, Forecasting, Inventory, Supplier Management, and Storage Capacity Created application used to pursue remedy from suppliers responsible for failed dealer orders, resulting in $8M in annual cost recovery.
Directed efforts with Corporate IT teams and data owners to migrate and validate 300+ tables in the new Big Data environment (Greenplum).
Designed and built initial Supply Chain data repository using PostgreSQL.
Program and administer Corporate IT-provided Azure / SQL Server stack to further support analytics.
Senior Sourcing Analyst, 03/2010 to 04/2012 MASONITE – Charlotte, NC
Standardized, automated, and redesigned of all Global Sourcing reporting.
Improved profitability through developing cost models and detailed commodity and market analysis.
Redesigned monthly presentation materials, increasing senior leadership's confidence in results, introducing new actionable information and decreasing the hours required for completion by 90%.
Created cost models used by Procurement and Sales teams to detail impact of changes on the highest running assemblies and finished goods and more accurately measure of product line profitability.
Led Procurement team efforts to migrate sourcing data to newly-created data warehouse environment.
Designed initial series of sourcing reports for new corporate Business Intelligence team.
Created materials used support price increase negotiations with customers and cost decrease negotiations with suppliers, generating over $8M in additional revenue and $4M in cost savings/avoidance respectively.
Procurement Analyst / Business Analyst, 09/2005 to 02/2010 TEXTRON – Troy, MI
Simultaneously a member of Procurement and IT organizations, leveraging analytics abilities and technical skills to drive price improvements, standardize operating practices, and build/manage systems.
Generated quarterly commodity market guidance reports for Procurement and Strategy organizations, in addition to performing material analyses in support of cost reduction strategies.
Stimulated cross-division spend leveraging discussions by completing detailed assessment that uncovered actionable commonalities among suppliers and commodities.
Developed enterprise supplier assessment process including developing detailed capability surveys, tools for measuring financial health and risk, and a customizable on-site assessment.
Drove compliance to corporate software licensing agreements through periodic auditing and negotiations with software vendors and monitoring of all desktops / laptops to ensure absence of unapproved software.
Procurement Analyst, 01/2003 to 09/2005 COLLINS & AIKMAN – Troy, MI
Automated manual processes, reducing completion times from hours to minutes.
Reduced the time required to generated weekly performance reporting by over 95% through automation.
Oversaw budget and developed monthly variance reports for Finance Director.
Master of Business Administration (MBA): Finance, 2004 Oakland University - Rochester, MI Finance
Bachelor of Science (BS): Business Administration, 2002 University of Detroit Mercy - Detroit, MI Business Administration Resume -
High-performing, strategic thought leader and concept-to-execution driver with a unique mix of technical, business, and research proficiency. 15+ years of experience in mining, analyzing, visualizing, and presenting data to construct solutions that improve operations, support strategy, and drive increased profitability. Cross-functional collaborator well-versed in Supply Chain, Purchasing, Finance, Sales, Production, and IT operations within multiple industries. Track record of building dynamic teams, interacting with partners, and managing complex technical projects while delivering successful results.
QlikView / QlikSense