EXPERIENCE SUMMARY:

• Confidential is an SAP Business Intelligence Architect and Project Manager with 23 years of technology related experience.
• His background includes 20 years of consulting experience primarily centered in the area of SAP Business Intelligence solution design and delivery.
• He has worked with every major version of SAP BW since version 1.2A .
• Recent experience includes BW4/HANA design and development, HANA native modeling, SAP Analytics Architecture and Roadmap.
• Leadership experience includes lead architect and program management positions supervising consultants and client personnel.
• Implementation experience includes 20+ Business Intelligence engagements involving managerial, technical and functional responsibilities across a variety of industries.

DETAILED WORK EXPERIENCE:

SAP Analytics Architect

Confidential

Responsibilities:

• Served in a variety of Architecture and Development roles during a Greenfield implementation of BW/4HANA with S/4HANA (IS - Oil).
• Authored initial Analytics Architecture strategy covering the following components:
• Analytics Portals
• Analysis and Visualization
• Enterprise Data Warehouse (EDW) Platform
• Transactional Platform
• Data Transformation and Integration
• Performed Analytics Capability Assessment resulting in product recommendations for required capabilities
• Initiated process for review of Fiori application relevance and readiness
• Worked with SAP Max Attention team to reconcile RICEF reports with Fiori Embedded analytics
• Drafted conceptual architecture and project plan for execution of a Digital Boardroom Proof of Concept
• Developed and communicated options for combining data from S/4 HANA and a HANA based Enterprise Data Warehouse. (SDA/SDI/SLT)
• Participated in workshops on Dynamic Tiering/ILM
• Drafted high level architecture for Risk Analytics to in corporate key Hydrocarbon Supply Chain processes (i.e. Deal Mgmt., SD, MM, TSW, IPW, LCFS/RINS, etc.)
• Reviewed CDS view components and developed internal development reference guides
• Used SAP Web IDE to perform initial table replication using SDI prior to formal architecture decision to utilize SLT.
• Developed BW/4HANA hybrid data models (Composite Providers, Open ODS views, InfoObjects and HANA Calculation Views, BW Queries) in the following areas:
• Project and Portfolio Management
• Holistic PPM view with join to PS Financials
• Project Systems
• Projects - Actual vs. Budget
• Purchasing
• Cash Forecasting & PO Details
• Finance
• Actuals vs. Budget (BPC) with movement volumes
• Hydrocarbon Supply Chain
• End to End (Nominations to Financial Postings)

SAP HANA Business Analyst/ BI SME

Confidential

Responsibilities:

• Acted as the business analyst and overall SAP Business Intelligence SME for the implementation of the “Trends in Immunization Practices” application on an SAP HANA platform.
• Solution will support all the major processes which comprise the existing IIS-TIPS application including: Data Acquisition, Data Evaluation, Deduplication, Vaccination Validation, Metric Generation and Reporting & Analytics.
• Platform/Application components include: HANA Enterprise SP10, SAP Data Services, BusinessObjects 4.2 and HANA Rules Framework
• Responsibilities included:
• Creation of Business Process and RICEFs functional specifications covering 800+ requirements
• Development of Measures/KPI catalog(~400 objects) for Reporting & Analytics
• Conceptual solution design & Prototyping
• HANA content creation: Attribute, Analytical and Calculation Views
• HRF content creation: Vocabularies, Decision Tables, If-then rules
• Development of Test Strategy, Plans and Test Cases
• Execution of Test Cases

SAP BI Lead

Confidential

Responsibilities:

• Developed a technical roadmap focused on the transition of SPE’s existing Planning and Analytics platform from BW 7.3/BPC 7.5 environment to a future state architecture.
• Platform/Application components being evaluated include:
• BW 7.3 to BW 7.4 on HANA
• BPC 7.5 to BPC 10.1 Embedded
• Enterprise HANA (w/HANA Live)
• BusinessObjects 4.1
• Responsibilities include the development of high level project plans with costs and resource estimates for technical platform establishment, dual landscape maintenance, reporting transition and planning application transition.

SAP BW SME

Confidential

Responsibilities:

• Provided functional and technical subject matter expertise during the upgrade of SAP BW from 7.3 to 7.4 and during the new installation of the SAP BI Java instance
• Prepared environments for regression testing after technical upgrades
• Executed regression test scripts in HPQC (60+ process chains), documented errors, researched and identified SAP notes for application. Opened customer messages with SAP
• Setup Inventory Controlling business content to evaluate development environment after upgrade
• Reviewed Analysis Authorization setup and provided security recommendations for Power User program
• Performed initial testing of major Java Stack functions (Web Application Designer, Broadcasting, BEx Web)
• Prototyped various Web Application Design applications for client evaluation.

Independent Consultant

Confidential

Responsibilities:

• Setup cloud instance of SAP BW on HANA with BusinessObjects under SAP’s trial program
• Converted Standard DSOs & InfoCubes to HANA optimized
• Created Transient providers, Virtual Providers & Composite providers to join BW and HANA data
• Created Design Studio dashboard based on HANA data
• Imported BW data into HANA

SAP BW/BOBJ SME

Confidential

Responsibilities:

• Acted in a multi-faceted role to rapidly deliver BusinessObjects Dashboards and self-service Ad-hoc reporting to Mylan’s Global Quality organization.
• Wrote functional specs, technical specs and test scripts. Worked with Business Leads to improve monthly data submission process (approx. 200 files from 40 sites)
• Constructed BW Architecture objects, BEx Queries, OLAP Connections and Web Intelligence reports to support multi-page Dashboard comprised of 80+ analytical components with drill through reports. Developed BEx queries and OLAP connections to support Ad-hoc Web Intelligence reporting. Added key enhancements to Dashboard after initial Go-live.
• Developed approach, templates and guidelines for historical data conversion.
• Developed Web Intelligence training for power users and transitioning the solution to the production operations team.

Confidential

Pre-Sales Engineer - SAP Supply Chain Analytics

Responsibilities:

• Worked as a Sales/Solutions engineer guiding customers through SAP based Proof of Concept engagements to demonstrate the value of Best Practice Supply Chain Analytics in their organization.
• Successfully led Fossil, Honda R&D, and Greenlee(Textron) through POCs and onto production customer status. Typical engagement activities included:
• Working with key business stakeholder to identify requirements for KPI's, Dashboards and Operational Reports
• Translation/Mapping of customer requirements to Confidential data models (subject areas/dimensions/measures)
• Perform Gap/Fit analysis for custom requirements vs. existing data models
• Create technical specifications for engineering team to create custom measures or adjust data model processing: Examples:
• Adjust logic to accommodate SAP AFS sizing during evaluation of Material receipts against POs
• Custom measures for: AFS Allocated but not Shipped, not Allocated and not Shipped, etc.
• Custom measures to evaluate Stock Out Potential/Inventory weeks of supply
• Add Vendor EFT flag based on banking details to identify non-EFT Vendors who require manual/high effort processing
• Supported additional customer accounts including: Columbia Sportswear, Kimball Electronics, Varian Medical, etc.
• Delivered KPIs, Dashboards and Reports for key business processes including:
• Sales/Deliveries/Billing/Accounts Receivable
• Purchasing/Accounts Payable
• Inventory/Material Movements
• MRP/Production Planning/Quality Management
• Sales and Inventory Forecasting
• Various custom processes
• Worked with clients to develop deployment plans and security approach
• Worked with product engineering to develop/test core product enhancements (AFS, WMS, Dynamic currency and UOM conversions, etc).
• Performed extensive data validation and reconciliation between Confidential and sources systems (SAP ECC, SAP BW, etc.)
• Concurrently managed up to 7 client engagements across multiple business processes

SAP BW/BOBJ SME

Confidential

Responsibilities:

• Acted as a subject matter expert and hands-on developer for three SAP BusinessObjects projects focused on delivery of Supply Chain and Customer Service metrics via Dashboards
• Developed working prototypes for Spend Analytics, including parameter driven drill through to Web Intelligence
• Developed Dashboard templates, specification and best practice documents
• Guided BW developers in data model and BEx query design to support Dashboards
• Conducted multiple training sessions to client personnel on Dashboard functionality and how to transition prototypes to various BW connections (NetWeaver BW, QaaWS, Query Panel - Universe and BICS based)
• Developed complex BEx queries and associated BW architecture to support high performance dashboard reporting
• Developed Conceptual, Logical and Physical Data Models to support Customer Service KPIs and detailed reporting
• Developed initial BusinessObjects Explorer prototype
• Miscellaneous responsibilities include ad-hoc BW support: data loading, process chain creation, SAP customer message administration, security design, etc.

SAP BW/BOBJ Architect

Confidential

Responsibilities:

• Supported two Proof of Concept projects in a disparate landscape leveraging SAP BusinessObjects XI 4.0 as the primary tool for federating data from SAP BW, MS SQL, Oracle and MS Excel.
• Prototype “One” leveraged multi-source relational connections to join high volume data from BIA to data from MS SQL Server and MS Excel.
• Provided BOBJ 4.0 architecture and tool usage recommendations.
• Outlined guidelines and roles/responsibilities for a Power User program under the new architecture.
• Supported the BW environment by creating new aggregated InfoProviders and adjusting existing InfoProviders to leverage BIA indexes.
• Drafted a document providing an overview of BOBJ security and outlining data security considerations in a disparate landscape.
• Assisted with overall BusinessObjects sizing recommendations.
• Prototyped new solutions in the Information Design Tool to support business requirements.
• POC “Two” leveraged the BusinessObjects Platform and Report Engine SDKs to customize web intelligence reports from an Oracle DB for presentation to external customers.
• Provided architectural and functional guidance for the project.
• Decomposed custom database schemas and matched against high level business reporting requirements.
• Constructed Data Foundations and Business Layers including joins, contexts and calculated columns.
• Created and demonstrated a variety of Web Intelligence features including: Lists of Values, Parameters, Cascading Prompts, Navigation Paths, Drill-down, Document Linking, Custom Date Ranges/Filters, Groups, Sections, Variables

SAP BW/BOBJ Lead Architect

Confidential

Responsibilities:

• Provided solution expertise during the discovery phase of a Management Reporting re-engineering project.
• Attended workshops to assess the impact and opportunities encompassed in proposed changes to data and process changes.
• Performed an analysis of Lam's merger with Novellus and outlined the impact of various integration scenarios on the BI landscape.
• Provided formal recommendations for tactical BI opportunities to be pursued in advance of the merger based on analysis of the existing BI environment.
• Provided short and long term integrated reporting options leveraging BusinessObjects 4.0, SAP BW 7.3, EPM 10 and SAP CRM.
• Developed a POV whitepaper for the Dimensional Insight Diver BI product.

SAP BW/BOBJ Lead Architect

Confidential

Responsibilities:

• Lead BI Architect for Levi’s SAP Global Template project responsible for establishing, communicating and enforcing architecture standards.
• Technical components of the BI solution consisted of ramp-up versions of SAP BW 7.3 and Business Objects XI 4.0, with Teradata foundation.
• Implemented an Enterprise Data Warehouse providing Analytical capabilities for all major business processes and a data foundation which supported other BI Projects and ancillary applications.
• Overall Blueprint Reporting scope included 175 Reports covering Managerial, Operational and Transactional reporting requirements. 85 Reports were identified for initial Phase 1 delivery.
• Key integration points included SAP AFS/ECC 6.3, SAP SCM 7.1(ramp-up) and Hyperion Essbase/HFM.
• Overall project staffing consisted of 9 Architects (direct reports) and 14 off-shore developers.
• Led Cutover Planning and Execution activities, including two rehearsals and final cutover.
• Worked with Project Security team to design BI security model.
• Assisted Project Manager with project/resource planning and risk/issues management.
• Reviewed all Functional and Technical Specifications for completeness and consistency.
• Prototyped and developed guidelines for Web Intelligence Ad-hoc reporting using various BW InfoProviders and Relational/BICS connections.
• Additional miscellaneous activities included:
• Identification and application of SAP Notes for AFS extensions.
• Performed initial fit-gap analysis of SAP’s SCPM product.
• Performance Test Execution, Go-live Performance Monitoring/Tuning.

SAP BI Lead

Confidential

Responsibilities:

• Architected and developed a Global SAP BI solution for Confidential concurrent with their implementation of SAP ECC 6.0.
• Primary BI solution consisted of SAP 7.0, Crystal Reports 2008 and Business Objects Integration Kit for SAP.
• Scope of the solution included installation/development of 60+ InfoProviders covering most major subject areas including: SD, MM, PP, PM, QM, PUR, CO-PA, AR, AP, GL, CO-PC, CO-OM
• Integration points included APO Demand Planning and BPC 7.0.
• Staffing consisted of one BW developer and a part-time business resource resulting in a significant percentage of time being spent on direct hands-on activities including:
• Review and implementation of business content.
• Construction of process and meta chains(230+) and development of overall load schedule.
• Initial transport collection, release and import of all development objects to build the QA environment and subsequently the Production environment.
• Initialization of 23 Logistics Extractors .
• Custom development of Purchasing Schedule Line solution utilizing a Write Optimized DSO to maintain transaction level detail.
• Development of custom data models for APO and export DataSource integration back to APO for Demand Planning inputs.
• Development of BEx queries to meet functional requirements, assist with data validation and to provision data for Crystal Reports.
• Creation of Crystal Reports using InfoProviders and BEx queries. Debugging/Performance benchmarking use of BW Query MDX driver vs. BW Query driver.
• Identification and application of SAP Notes for various issues.
• Design of process chain solutions for financial extractors which minimize data volume when delta loads are not available.
• Setup of automated process chain notification(RSPCM) and monitored daily, weekly and monthly chains.
• Developed overall Architecture Strategy, Project Plans and Cutover Plan/Schedule.
• Provided templates and guided client resources through the creation of functional specifications.
• Created 30+ cross functional Technical Specifications, identifying InfoProviders, InfoObjects, Query Layouts and use of formulas, selections, variables, calculated and restricted key figures.
• Created sizing estimate for overall BW landscape (i.e. - Year 1 Growth).
• Provided overview of BW Security including Analysis Authorizations to the Security Team and recommended BW roles.

Confidential

Manager - Business Intelligence

Responsibilities:

• Objective of the project was to document requirements and develop a high level architecture supporting the ability to calculate effective tax rate and profitability by legal entity.
• Collected analytical requirements and documented current business processes of the corporate tax department. Reviewed existing SAP BW/BPS architecture and AOP/Forecasting business processes with the Financial Planning and Analysis Team.
• Reviewed existing Tax Planning Solution developed in SAP BPS for another PepsiCo division.
• Documented the overall solution blueprint, developed high level implementation timelines and budget estimates and presented findings to key stakeholders.
• Led the successful delivery of several workstreams during the implementation of an SAP BI 7.0 Analytical Supply Chain Management solution.
• Project scope focused on quick wins in the areas of Inventory Management, Production Planning, Capacity Utilization and Procurement.
• Managed several developers and progressed the project through all phases: design, development, testing and go-live
• Performed initial configuration of the Production Planning and Capacity Utilization deliverables.
• Continued role at this client as the security architect responsible for the BI 7.0 security design and construction.
• Supervised enhancements to a customized Power User training course and the actual conduct of the training sessions.
• Served as a team lead with broad responsibilities during the implementation of an SAP BI 7.0 reporting capability focused on Financial reporting.
• Jointly drafted the Statement of Work with the Account Manager.
• Provided oversight during requirements collection for Inventory, Sales and Gross Margin Reporting.
• Supported the Correction and Transport System (CTS). Completed and finalized the initial project plan and developed governance documents including the Change Control process and Issue and Risk Tracking.
• Developed the overall Testing Strategy, presented the strategy to the project team and client. Developed templates used for capturing test cases and recording execution results.
• Developed the BI 7.0 Security Strategy including both Standard and Analysis Authorizations and created the security roles.
• Drafted key components of the Operations Support materials.
• Acted as the subject matter expert during the initial design/builds stages of a major SAP BI 7.0 enhancement project performed at the Business & Decision Competency Center in Lyon, France.
• The project objective was to overhaul the BI architecture and supporting KPIs for the client’s servicing and repair processes.
• Project scope required the review and modification of 15 DSOs, 8 InfoProviders, associated transformations and data sources.
• 160+ new InfoObjects and 135+ new KPIs were created.
• Supported the local project manager by providing project planning support, architectural guidance and supervision of development resources.
• Jump started the project by dissecting the complex project into a manageable plan which could be executed by local resources.
• Developed a Sales Planning application utilizing BI Integrated Planning, Web Application Designer and the Status and Tracking System(STS) for pre-sales purposes.
• Joined Actual and Planned Sales information via an Aggregation Level based on a MultiProvider.
• Configured Test users and setup Analysis Authorizations to limit data access.
• Input ready queries and multiple planning functions were incorporated into a Web Application template.
• Planning sessions were configured within STS and the overall planning scenario was executed.
• Planning scenario was recorded as a screencam and a script was developed for pre-sales demonstration purposed.
• Configuration steps were formally documented and data files was placed in a repository to enable the use of the application for training purposes.
• Prototyped financial reporting solutions using the latest NetWeaver(7.0) BI products.
• Extracted financial information from SAP ECC 6.0 and transformed in a multi-tier SAP BI landscape.
• Reporting scope included: Profit and Loss, Balance Sheet and GL Account Detail. Reports were delivered via BEx Analyzer, BEx Web Analyzer, Web Application Designer and Report Designer.

Confidential

Program Manager

Responsibilities:

• Responsible for delivery of a portfolio of projects for the Commercial business function. Portfolio represented approximately $7 million of IT spend.
• Specific duties include managing initial project estimates, guiding projects through stage gate approvals and providing oversight for projects underway.
• Provided oversight for the implementation of Hyperion Planner within a SOA framework.
• Additionally responsible for delivery of application support services for existing commercial applications, including break-fix and enhancement activities using a mix of on-shore and off-shore resources.
• Miscellaneous duties include resource demand planning for four Centers of Excellence, Commercial stakeholder management, championing established policies procedures and processes and preparing the annual Service Delivery budget($11.5M).
• Managed a project for the establishment of a hosted solution which provides for the synchronization of pricing information between bottlers and retailers. Scope of the project included utilization of Global Data Synchronization standards for data exchange.
• Drafted the Statement of Work and participated in contract negotiations.
• Managed the RFI and RFP development and vendor selection process.
• Successfully coordinated the activities of individuals from multiple departments includingSales Technology, Legal, IT, Procurement and our external vendor.
• Managed the implementation of Trade Spend Analytics for the Canadian confectionary division. Solution was delivered using Cognos, Informatica and ERwin software on an Oracle database.
• Trade Spend Analytics were derived from data extracted from SAP R/3, APO (Demand Planning) and MEI TPM.
• Oversaw the daily activities of three Cognos, four Informatica and two Business Objects Data Integrator developers.
• Worked closely with Project sponsors and business analysts to ensure quality of reporting deliverables.
• Led status meetings, managed risk and issues.
• Created project plans covering the testing, implementation and cutover phases.
• Led successful cutover and managed post go-live stabilization process.
• Managed the transition to production support.
• Assisted with estimating process for an implementation of Vision Chain(Wal-Mart POS Analytics) within the Confectionary division.
• Refined and communicated an Information Delivery Strategy.
• Led a Master Data Harmonization Proof of Concept using Kalido software.