Data Anayst

Resume of

Scott Brewer

Home: **** **** **** ****: 586-***-****

Rochester Hills, MI 48306 Email : *******@****.****

OBJECTIVE:

Strategic Sourcing, Spend, and Supply Chain Analytics / Management Consultant. Identify, collect, process, analyze, and report information to drive strategic decisions.

I have been a consultant for over 20 years. This has mostly involved road warrior work : travelling to the client site Monday morning / returning Thursday night. Most engagements have been between three and seven months but some have been one month. During the Covid period situations changed in that I was almost exclusively working from home. I do not mind travel, but it would be nice to work from home or local office 50% of the time.

My area of specialty (assisting Management Consultants) is small. My engagements have come from referrals from other consultants who have worked on previous engagements with me.

SUMMARY OF EXPERIENCE:

Byte Consulting Jul 2003 to Present

Independent data analysis using Microsoft Access, SQL Server, Excel, and Qlik for management consulting engagements. Many engagements have been strategic sourcing with AT Kearney. Other consulting firms have been Advanced Operations Partners, Emerging Sun, Maine Pointe, Tenzing Consulting, Rejoined Consulting, Privatin Consulting, nSource Advisors, Maine Pointe Consulting, Athlon Group, Lansdowne Consulting, TransPac Access, Freedom Square, QP Group, and Detroit Public Schools. Examples of these projects include :

SPEND ANALYSIS ENGAGEMENTS (from home) ---

Included developing a Business Intelligence process to improve spend visibility. This process uses an ETL (Extract, Transform, and Load) process to lace information into a Qlikview spend tool housing charts, graphs, and tables. Clients included Portland General Electric, Integer, Brightview, Sedgwick, Go Daddy, Groupon, US Foods, Westcon, Toys R Us, and Catamaran.

STRATEGIC SOURCING ASSESSMENTS / REVIEWS ---

Identify savings opportunities including data cleansing for Astra Zeneca (Pharmaceuticals) in Wilmington DE, Tronox (Mining) 2015 in Rye NY, Jabil Circuits (Manufacturing) from home, Novolex (Manufacturing) 2015 from home / OH, Louis Dreyfus Commodities (Brazil - Agriculture) from home, Zain Communications (Saudi Arabia – Communications) from home,

OTHER ENGAGEMENTS

Instant Brands (Nov 2023 to Jan 2024) Downers Grove, IL

Assisting C-Suite and cost reduction for a private equity purchased company out of bankruptcy. This company sourced kitchen equipment from China and sold to retailers in the US and Canada. Areas of this engagement included:

Sourcing from China (entire product)

Transportation / distribution

oFrom China to Long Beach, CA (ocean transport)

oFrom Long Beach, CA to retail distribution centers (usually Full Truck Load)

oFrom Long Beach, CA to web customers (individual FedEx shipments)

Product research and development

Adverting and marketing, both standard and internet

St Gobain (May 2022 to Oct 2023) from home and Atlanta GA

Developed several tools for a chemical company providing additives for concrete. The first was to add visibility and intelligence for a third-party tracking tool used for auto-ordering additives. Others included an inventory planning tool to identify raw material requirements and a capacity planning tool to identify capacity constraints.

Beacon Mobility (Apr 2022) from home

Assisted in data analytics for a transportation sourcing engagement.

Mac Papers & Packaging (Aug to Oct 2021) Jacksonville, FL

Strategic sourcing for a paper distributor. This company supplies a significant portion of direct mail in the country.

ConAgra Foods (2020 to Apr 2021) from home

Developed a resource requirements tool for research & development. This tool imported data from their tracking tool and added manually defined data to evaluate resource requirements. Characteristics included type of project, complexity, stage, and resource requirements for each by resource type. Benefits included visibility on the ability to start new projects and began to address return on investment decisions as to which projects to start, hold and terminate.

CHC Helicopter (Jan 2019 to Mar 2019) Houston, TX

Strategic sourcing of repair parts for servicing helicopters.

Canadian National Railway (Apr 2018 to Nov 2018) Homewood, IL

Developed and implemented a tracking tool to monitor material logistics and construction progress of capital improvement projects. Schedules and statuses were provided by key stakeholders in Excel, imported into an Access database, and generated an Excel dashboard identifying concerns. This process was refreshed weekly and distributed using a toolbar placed on their desktop to download the dashboard and input files from a corporate server.

Treehouse Foods – Development and Maintenance of Cost Savings Tracking System (2018)

Developed a tracking tool to manage and identify cost savings initiatives for a food manufacturing company. Process imported reports from initiatives and reported on savings projections and progress.

Treehouse Foods – Integration of ERP Data (2016, 2017) Oak Brook, IL

Developed and implemented an ETL (Extract Transfer Load) process to integrate customer information into a harmonized system consisting of seven ERP systems with over 100 data sources. Created a reporting tool to track and monitor progress.

Caterpillar – Complexity Reduction (2016) Aurora, IL

Supported data analytics for a complexity reduction engagement. Identified like parts using bill of materials.

Miner Handling Systems – Serviceability Analysis (2015) Atlanta, GA

Defining and using key metrics in determining “gaps” between service demands and availability of third-party providers.

CB Richard Ellis (2015) Atlanta, GA

Data cleaning tasks providing assistance for a sourcing engagement.

US Army (2015) from home

Developed a tracking tool to assist in management of US Army contracts by company, spend, start and end time.

Famous Dave’s Restaurants (2013) Minneapolis, MN

Strategic sourcing assessment. Strategic sourcing of disposables, fish, repair and maintenance activities.

National Express (United Kingdom) (2012) from home

Strategic sourcing engagement to identify key cost drivers in reducing cost-of-purchase for buses and coaches.

PF Chang’s (2012) from home

Strategic sourcing assessment to identify savings opportunity. Continued with analysis supporting the sourcing of janitorial services, equipment services, and office supplies.

BE Aerospace – Total Cost Model (2012) from home

Engagement to determine total purchase cost of items to be assembled between low-cost countries and non-low-cost countries.

British Petroleum (US Refineries) (2011) from home

Strategic sourcing engagement included categorization, manufacturer name / part number identification, RFP creation and analysis for MRO spend of US refineries.

Kalvin Consulting (2010) Mason, OH

Employee learning and working with SAP systems.

Bridgestone / Firestone – Customer pricing strategy (2010) Chicago, IL

National service center (2,500+ stores nationwide with 100,000+ customers daily) uniquely prices parts and labor for each customer. This engagement highlighted price variances through the analysis of customer invoices and recommended price strategy improvements.

Caterpillar (2004, 2009) Peoria, IL

Indirect strategic sourcing engagements for Cat including segments MRO, transportation, wood products packaging, marketing, chemicals/gases, security, IT services, waste, site services, and temp labor.

Caterpillar - Price configuration of RF transmission modules (2009) Peoria, IL

60,000 RF modules placed on equipment send satellite transmissions to report their operating status. The monthly cost was based on number of modules within specific usage buckets. Each bucket was defined by different capacity and price. This engagement developed a system to assign modules to cost buckets minimizing cost while maintaining contract requirements.

Hertz Equipment Rental – Business intelligence cost allocation (2009) Park Ridge, NJ

Equipment rental revenue can easily be determined by store, month, and equipment type. Not so with the cost of this equipment. An object-oriented business intelligence system was designed, developed, and implemented to allocate costs to specific equipment. This system became an automated monthly process. It extracted data from multiple corporate legacy systems, then transformed it into a manageable format. An object-oriented system allowed user-defined parameters to aggregate, query, calculate, and present useful statistics in usable format.

Avon – Global finance system integration (2007) Rye, NY

Prior to the global finance system, Avon used 30 to 35 finance systems run at the country / regional level. As part of a team integration effort, old standards were identified, conformance to the old standards assessed and exceptions resolved. New standards were created, and users trained. Old data was transformed and loaded into the new system.

Chrysler (2006, 2007) Troy, MI

AT Kearney MRO sourcing and procurement for Chrysler. This initiative managed MRO supply chain and procurement activities for all Chrysler factories. In addition to strategic sourcing, this engagement developing tactical approaches for paper operations (an e-catalog, ordering, invoicing and payments), as well as physical distribution (warehousing, delivery, and stock room cribs / vending machine replenishment) for all MRO related purchases.

Detroit Public Schools – Risk finance database development (2005, 2006) Detroit, MI

Managed the design, development, and maintenance of risk finance databases for Detroit Public Schools. Included a worker’s compensation system and other minor systems. Detroit Public Schools is a self-funded program with approximately 1,500 claims per year. The system records key information, pays bills, and provides state and federal regulatory reporting.

Intier Automotive (2005) Northville, MI

Intier’s strategic sourcing direction was to consolidate purchasing into a global organization. Many recently purchased Intier factories were single-shop factories with their own purchasing. Global purchasing was to improve supplier relations and reduce costs.

Arvin Meritor (2003, 2004) Troy, MI

Two direct strategic sourcing engagements for direct purchasing including castings, stampings, forgings, motors, plastics, fasteners, bearings, and packaging, springs, and powder metals.

Federal Mogul (2002) Troy, MI

Strategic sourcing engagement for direct purchasing. Interfacing with AT Kearney E-breviate.

Other employment prior to consulting included:

General Motors May 1994 to Jul 2003 Troy, MI

Responsible for developing, supporting, and maintaining software tools and techniques for the Industrial Engineering department.

EDUCATION : University of Houston (Houston, TX)

Completed Masters in Business Administration (MBA).

Wayne State University (Detroit, MI)

Completed Masters of Science in Operations Research (MSOR) degree from the Industrial Engineering Department.

Hope College (Holland, MI)

Completed Bachelor of Arts (BA) degree with majors in Computer Science, Mathematics, and Chemistry.

KEYWORDS: Management Consulting, Strategic Sourcing, Supply Chain Management, Data Analyst, Business Intelligence, Software Development, Microsoft Office (Expert), Microsoft Access (Expert), Microsoft Excel (Expert), Microsoft Visual Basic for Applications (VBA – Expert), Microsoft Word (Good), Microsoft PowerPoint (Good), Microsoft Visual Basic For Applications (Expert), Microsoft SQL Server (Good),, Extract, Transform and Load (ETL), Qlikview/QlikSense (Good), Tableau, PowerBI.

Contact this candidate