DON WELKER, ENTERPRISE EDW/BI DELIVERY MANAGER & SOLUTIONS ARCHITECT CAREER PROFILE

* ** * *** ****** February 20, 2017

Don Welker

Bridgewater, NJ

908-***-****

www.linkedin.com/in/donwelker

Snapshot

DON WELKER, ENTERPRISE EDW/BI DELIVERY MANAGER & SOLUTIONS ARCHITECT

20+ years of experience

Located in Bridgewater, NJ

Subject matter expertise in Enterprise Data Warehousing (EDW) and Business Intelligence (BI)

Vast project experience as EDW/BI Delivery Manager and Solutions Architect in both SAP and non-SAP environments

Open, honest, and passionate

BS, Rutgers University

Career Profile

Don Welker is an Enterprise Data Warehouse (EDW) and Business Intelligence (BI) Delivery Manager & Solutions Architect who has 20+ years of experience as a Management & Technology professional focused on designing and delivering full systems life cycle solutions. Don has hands-on experience with multiple EDW/BI engagements that required close collaboration with key IT and business stakeholders to understand business challenges and complex requirements and to establish the overall strategic and tactical direction. Don has an extensive background integrating SAP Business Warehouse (BW) with SAP and non-SAP applications as both a consultant and within industry. He has successfully delivered, supported, and evolved numerous DW/BI reporting and analytics solutions for major consumer products and life sciences companies as well as companies in a variety of other industries. Companies & Consulting Firms

CONSUMER PRODUCTS LIFE SCIENCES OTHER INDUSTRIES CONSULTING

Benjamin Moore & Co.

Campbell Soup

Charmer Sunbelt Group

Coca-Cola

Esteé Lauder

First Quality

L’Oréal

Seneca Foods

The Andersons

Tory Burch

Merck

GlaxoSmithKline (GSK)

Stiefel Labs

WellCare Health Plans

AT&T

Manulife Financial

Operator Assistance

Network (OAN)

Peugeot

PR Newswire (PRN)

United Parcel Service

(UPS)

Capgemini

Clarkston Consulting

Fujitsu Consulting

HP (EDS)

IBM

Knowledgent

DON WELKER, ENTERPRISE EDW/BI DELIVERY MANAGER & SOLUTIONS ARCHITECT CAREER PROFILE 2 of 6 Don Welker February 20, 2017

Consumer Products and Retail – Industry Vertical Experience SERVICE SUMMARIZED EXPERIENCES

Enterprise Data Warehousing

(EDW) / Business Intelligence (BI)

Strategy, Design, and

Implementation

For numerous consumer products companies, as a Delivery Manager and Solutions Architect, planned, designed, delivered, supported, and transitioned reporting and analytics solutions leveraging the SAP NetWeaver BW platform.

For a cosmetics company, Business Information Architecture (BIA) Director who collaborated with key stakeholders, sponsors and business users, and the BW Development Team to deliver an SAP BW reporting/analytics solution by ensuring work products and key project milestones were met, developing comprehensive project plans, and communicating the strategy and project progress to senior leadership.

For a beverage manufacturer and distributor, Enterprise BI Delivery Manager and Solutions Architect; managed the delivery and architected BI solutions by collaborating with Business Process Experts (BPEs), Business Analysts, and Development/Support Teams; identified key SAP BW performance optimization opportunities, prioritized work efforts, and implemented plans and methods for capturing and communicating results to senior leadership.

For a manufacturer of feminine hygiene, baby diaper, and adult incontinence disposables for retail and institutional distribution, EDW/BI Solutions Architect who assessed the current SAP BW solution and developed the SAP BW going-forward approach and action plan.

For a canned fruit and vegetable company, SAP BW Delivery Manager on a BI implementation project; architected solutions and provided leadership to the BI development team.

For a beverage distributor, SAP BW Delivery Manager & Solutions Architect delivering a reporting/analytics solution that enabled the company's Finance

& Accounting staff to perform general ledger and profitability analysis across companies, operating concerns, and states, which was previously unavailable.

For an upscale retailer, Technical Project Manager responsible for integrating the existing BI solution in conjunction with the company’s SAP ERP implementation; defined project scope, planned, budgeted, estimated the work effort, and led the BI project team.

Data Warehousing (DW), Business

Intelligence (BI), Reporting &

Analytics (R&A) Strategy, Design

and Development

For various consumer product companies, extensive experience as a Delivery Manager and Solutions Architect, establishing the strategy, architecture, requirements gathering, design, development, testing, and delivery of EDW/BI solutions.

Life Sciences – Industry Vertical Experience

SERVICE SUMMARIZED EXPERIENCES

Enterprise Data Warehousing

(EDW) / Business Intelligence (BI)

Strategy, Design, and Delivery

For numerous life science companies, Delivery Manager and Solutions Architect who planned, designed, delivered, supported, and transitioned reporting and analytics solutions leveraging the SAP NetWeaver BW platform.

For a pharmaceuticals manufacturer, Global SAP Business Warehouse

(BW) Delivery Manager and Solutions Architect who defined and initiated DON WELKER, ENTERPRISE EDW/BI DELIVERY MANAGER & SOLUTIONS ARCHITECT CAREER PROFILE 3 of 6 Don Welker February 20, 2017

SERVICE SUMMARIZED EXPERIENCES

the BW toll gate review process, identified performance optimization opportunities, provided oversight and guidance for HW/SW upgrade projects, developed the business case for upgrading BW's underlying Oracle database to SAP HANA, provided work effort estimates, and helped prioritize new pipeline demand.

Reporting & Analytics (R&A)

Strategy, Design and Development

For a dermatological pharmaceutical company, EDW/BI Strategy Consultant who defined the strategy and go-forward plan for delivering a global EDW/BI solution that enabled the co-existence of reporting and analytics solutions across numerous countries around the world.

Big Data Strategy For a provider of Medicare and Medicaid managed care, contributed to defining and establishing the supporting technical capabilities for Big Data platforms, including standards, guidelines, and selection of platform components; analyzed requirements, established scope, time, and resource estimates; provided subject matter expertise for interfacing/ integrating SAP related data into the Big Data environment.

Other – Industry Vertical Experience

SERVICE SUMMARIZED EXPERIENCES

EDW/BI Strategy & Implementation For an agricultural business as the Lead SAP Business Analytics

(BW/BOBJ) Delivery Manager & Solutions Architect, managed the delivery and architected the SAP BI (BW/BOBJ) solution in conjunction with a large scale SAP Commodities Trading & Risk Management (CTRM) implementation.

Current Skills Summary

Primary Skills Enterprise Data Warehousing (EDW), Business Intelligence (BI) Strategy, Solutions Architecture, Delivery and Support within the Consumer Products and Life Sciences industries, SAP Business Warehouse (BW) Secondary Skills Project Management, Business Development Support, Data Modeling, Training

Years of Experience Enterprise Data Warehousing (EDW) 20+ years Business Intelligence (BI) 20+ years

SAP Business Warehouse (BW) 12+ years

SAP ECC (MM, SD, FI, CO) 12+ years

SAP CRM, SCM, TM, EWM, MDG ~1-2 years per functional area PMO 10+ years

Consulting 20+ years

Notable Highlights 4 Full Life-Cycle SAP BI (BW/BOBJ) implementations

7 Partial Life-Cycle / Ongoing Support & Evolution SAP BI engagements

4 Non-SAP Reporting/Analytics projects

Experience with Off-Shore (India, Argentina) Development & Support Teams

DON WELKER, ENTERPRISE EDW/BI DELIVERY MANAGER & SOLUTIONS ARCHITECT CAREER PROFILE 4 of 6 Don Welker February 20, 2017

Chronological Experience

CLIENT / ROLE / INDUSTRY PROJECT / ROLE DETAILS

Clarkston Consulting

Client: Benjamin Moore & Co.

Dates: 06/16 – 01/2017

Role: EDW/BI Solutions Architect

Industry: Consumer Products

Sub-vertical: Paint and Coating

Manufacturing

For a leading manufacturer of paint and coating products, Don is responsible for defining and delivery the Manufacturing Analytics components of the SAP centric evolution for the company.

Solution leverages SAP BW 7.4 on HANA and Business Objects Web Intelligence (WebI) and Analysis for Office

Clarkston Consulting

Client: First Quality

Dates: 02/16 – 04/16

Role: EDW/BI Solutions Architect

Industry: Consumer Products

Sub-vertical: Home & Personal

Care

For a leading manufacturer of feminine hygiene, baby diapers and adult incontinence disposables for retail and institutional distribution, Don was the EDW/BI Solutions Architect on the an SAP ERP Implementation project; Don’s results include assessing the current SAP BW solution and developing the SAP BW going-forward approach and action plan. DW Consulting Solutions

Client: Tory Burch

Dates: 04/15 – 08/15

Role: Technical BI Project Manager

Industry: Consumer Products

Sub-vertical: Retail Luxury

For an upscale retailer of ladies handbags, shoes, clothing and accessories, Don was the Technical Project Manager integrating the existing BI solution in conjunction with the company’s SAP ERP implementation; Don’s results included project definition, planning, budgeting, work effort estimating, staff planning, resource leveling and leading the BI project team . Knowledgent

Client: WellCare Health Care

Dates: 04/14 – 11/14

Role: Principal Informationist

Industry: Life Sciences

Sub-vertical: Health Care

For a provider of Medicare and Medicaid managed care, Don was a Principal Informationist contributing to defining and establishing the supporting technical capabilities for the Big Data platform, including standards, guidelines, and selection of platform components; Don’s results included: analyzing requirements, defining the Big Data strategy, and establishing scope, time, and resource estimates; he provided subject matter expertise for interfacing/integrating SAP related data into the Big Data environment

Merck

Dates: 04/13 – 04/14

Role: Global SAP BW Delivery

Manager & Solutions Architect Lead

Industry: Life Sciences

Sub-vertical: Pharmaceutical

For a leading research-driven global healthcare company delivering vaccines, medications, and consumer and animal health products, Don was the Global SAP Business Warehouse (BW) Delivery Manager and Solutions Architect Lead; Don’s results included defining and initiating the SAP BW toll gate review process; identifying performance optimization opportunities and collaborating with the BW Development and Operations teams to establish the implementation plan; providing oversight and guidance for the SAP BW 7.0 to SAP BW 7.3 and BW Accelerator (BWA) HW/SW Upgrade projects; developing the business case for migrating the corporate SAP BW database from Oracle to SAP HANA; and providing work effort estimates for pipeline demand and participating in the prioritization process DON WELKER, ENTERPRISE EDW/BI DELIVERY MANAGER & SOLUTIONS ARCHITECT CAREER PROFILE 5 of 6 Don Welker February 20, 2017

IBM

Client: The Andersons

Dates: 04/12 – 04/13

Role: SAP Business Analytics

Delivery Manager & Solutions

Architect

Industry: Agriculture

Sub-vertical: Agribusiness / Global

Trade

For an agricultural business that provides merchandising, production and distribution of products and services to the agribusiness community, Don was the Lead SAP Business Analytics (BW/BOBJ) Delivery Manager; Don’s accomplishments included providing delivery management and solutions architecture for the data integration and reporting/analytics components associated with a large scale SAP Commodities Trading & Risk Management (CTRM) implementation; estimating time and work effort for delivering requested functional requirements in order to establish scope, associated resources, identifying roadblocks and corresponding risks, and communicating to senior leadership.

Capgemini

Client: Coca-Cola

Dates: 03/10 – 04.12

Role: Enterprise BI Delivery

Manager & Solutions Architect

Industry: Consumer Products

Sub-vertical: Beverage

For the world’s leading beverage manufacturer and distributor, Don was the Enterprise BI Delivery Manager and Solutions Architect on Bottling Services Group and Refreshment project engagements; Don results included: providing delivery management and solutions architecture for the data integration and reporting/analytics components associated with supporting a large scale SAP ECC implementation in accordance with the client’s global template; providing relationship management and acting as liaison between global Business Process Experts (BPEs), Business Analysts, and on-shore and off-shore (US, Argentina, India) Solutions Development & Support teams; analyzing and identifying key SAP BW performance optimization opportunities, establishing the overall strategy/framework, and collaborating with the BW Development and Operations teams to prioritize efforts, implementation plans and methods for capturing and communicating results. Clarkston Consulting

Client: Seneca Foods

Dates: 10/08 – 08/09

Role: BI Delivery Manager &

Solutions Architect

Industry: Consumer Products

Sub-vertical: Food and Beverage

For one of the nation’s leading canned fruit and vegetable companies, Don was the SAP BW Delivery Management Lead on an SAP ERP/BI Implementation project; Don’s results included providing technical project management, leadership, and solutions architecture for a BI solution that incorporated SAP Business Warehouse (BW), Business Explorer (BEx), and Cognos.

Clarkston Consulting

Client: Charmer Sunbelt Group

Dates: 07/08 – 10/08

Role: BI Delivery Manager &

Solutions Architect

Industry: Consumer Products

For one of the nation’s leading distributors of fine wine, spirits, beer, and non-alcoholic beverages, Don was the SAP BW Delivery Manager & Solutions Architect on an SAP BW Financial Accounting & Controlling

(Fi/CO) Pilot Strategy & Realization engagement; Don’s results included delivering a BI solution that enabled the client’s Finance & Accounting staff to perform general ledger and profitability analysis across companies, operating concerns, and states in aggregate, which was previously unavailable.

Clarkston Consulting

Client: Stiefel Labs, a GSK Co.

Dates: 01/08 – 07/08

Role: BI Delivery Manager &

Solutions Architect

Industry: Life Sciences

Sub-vertical: Pharmaceutical

For a global dermatological pharmaceutical, Don was the EDW/BI Strategy Consultant in conjunction with a global SAP ERP implementation; Don’s results included defining the strategy and plan for delivering a global EDW/BI solution that enabled the co-existence of reporting and analytics solutions across numerous countries around the world. DON WELKER, ENTERPRISE EDW/BI DELIVERY MANAGER & SOLUTIONS ARCHITECT CAREER PROFILE 6 of 6 Don Welker February 20, 2017

L’Oréal

Dates: 07/04 – 10/07

Role: Business Information &

Architecture (BIA) Director

Industry: Consumer Products

Sub-vertical: Health & Beauty

For one of the world’s leading cosmetics companies, Don was the BIA Director for the an SAP ERP/BW multi-divisional implementation; Don’s results included: successfully designing, developing and delivering the company’s USA BW solution from Project Prep to go-Live for their luxury products and active cosmetics divisions; collaborating with key stakeholders, sponsors, and business to address the strategic business objectives; ensuring work products and key project milestones were met by developing comprehensive project plans and communication strategies; interfacing with the client’s SAP Centre de Competence (CdC) in France to localize the global BW template for the USA company; systematically evaluating the system to ensure optimal performance during peak workloads and to proactively identify and resolve performance related issues; managing the BW team, including team building, career development, coaching and mentoring; selecting and supervising vendors and external resources; defining EDW/BI IT architecture and technology standards. Prior experience includes:

For the world’s largest soup manufacturer and distributor, managed the planning, requirements gathering, design, development, and implementation of business intelligence solutions utilized by over 600 internal and external field sales force users, Customer Business Managers and Sales Finance Specialists.

For the world’s largest telecommunications company, led the Data Warehouse Development Team to deliver a global financial reporting and analysis solution that was tightly integrated with Oracle Financials.

For the nation’s largest logistics and shipping company, projects led the strategy and design for DW/BI solutions.

For the world’s largest telecommunications company, led a reporting and analytics development team leading to recovering over $20M in unbilled local exchange company (LEC) phone calls. Additional Biography

Awards, Publications, Speaking Engagements:

Presented “Get the Most out of OTC & PTP Reporting with SAP NetWeaver BI” at the 2008 SAPinsider Reporting & Analytics Conference

Published WRICEF Needs a Kick in the ‘A’ point-of-view blog on LinkedIn Certifications, Training

SAP NetWeaver BI Solutions Academy

SAP HANA

IBM Big Data University

Education

BS, Rutgers University

o BS - Marketing (1987)

o Dean's List (3.4 GPA)

o Recipient of Award for Academic Excellence

<back to the top>

Contact this candidate