OBJECTIVE:

Seeking a growth opportunity as a SAP Business Intelligence (BW) Consultant, specializing in the implementation and support of both functional and technical aspects of BW.

SUMMARY:

Over 14 years of SAP experience with the last 13 exclusively within BW:

BW Consultant

Confidential, Dallas, TX

Application Partners, Atlanta, GA

• Multiple full cycle BW and BW - IP implementations
• Thorough understanding of BW architecture including design of custom infocubes, DSO objects, and datasources
• Proficient with BW Admin Workbench, data extraction and transformation, transport management, BEx Analyzer, Web Application Designer, Integrated Planning, performance tuning, and basic ABAP programming
• Knowledge of SAP BusinessObjects 4.0

FI/CO Consultant

Other Experience:

Senior Financial Analyst - Confidential, Irving, Texas

Financial Analyst - Confidential, Dallas, Texas

SAP Experience

Dallas, TX

BW 7.2 / BW Integrated Planning (IP) Consultant

Responsibilities/Deliverables:

• Designed and developed a custom solution for repricing selected purchase orders using SAP Integrated Planning custom planning functions, datasources, DSO objects, infocubes, queries, and web templates
• Designed and developed a custom solution for Workflow Metrics including datasources, DSO objects, infocubes, queries, and web templates
• Designed and developed a custom solution to determine open obligations within Funds Management (FM), enhancing business content datasources and transformations with ABAP programming
• Lead expert and go-to consultant for developing custom web templates using the BI 7.2 Web Application Designer
• Exposure to SAP BusinessObjects 4.0 and creation of a Universe for Material Movements

Dallas, TX

BW 7.0 / BW Integrated Planning (IP) Consultant

Responsibilities/Deliverables:

• Designed and developed a custom solution within BI Integrated Planning (IP) to calculate production lead time - a key element of product demand forecasting
• Led other BI Consultants with the design and development of the IP solution for other demand forecast components
• Became the lead expert and go-to consultant for developing custom web templates using the BI 7.0 Web Application Designer

Phoenix, AZ

BW HR/SCEM Lead Consultant

Responsibilities/Deliverables:

• Developed standards and procedures to build structure within the BW team and improve the quality of the system
• Overhauled the existing BW HR environment to improve performance and correct invalid data
• Created a custom HR dashboard for upper management for headcount reporting
• Created a custom solution within Supply Chain Event Management (SCEM) to monitor the progress of sales orders from order creation to cash. The development included 17 dataproviders, 70+ queries, and 60+ web templates. The objective of this solution is to reduce sales order cycle time by identifying bottlenecks and holding managers accountable to SLAs (service level agreements)

Confidential, Irving, TX

BW MM/PP/SD Consultant

Responsibilities/Deliverables:

• Responsible for MM, PP, & SD end-to-end development
• Customized logistic extractors to meet reporting requirements
• Created custom enterprise-level ODS layers preceding all infocubes where appropriate

Confidential, Dallas, TX

BW Retail Lead Consultant

Responsibilities/Deliverables:

• Activated delivered content in anticipation of specific requirements within the Retail industry solution
• Created custom enterprise-level ODS layers preceding all infocubes where appropriate
• Created the blueprint technical design document

Confidential, Phoenix, AZ

BW FI/HR Lead Consultant

Responsibilities/Deliverables:

• Activated delivered content in anticipation of specific requirements within the Financial and HR modules
• Created custom enterprise-level ODS layers preceding all infocubes where appropriate
• Created a custom HR dashboard to demonstrate the capabilities of BW to the subject matter experts that aided in requirements gathering
• Created a proof of concept demo for the Finance team within Profitability Analysis (CO-PA) to demonstrate the ability to extract sales order information and calculated key figures from R/3
• Created the BW standards for naming conventions, technical design documents, and online documentation

Confidential, Richmond VA

BW HR Lead Consultant

Responsibilities/Deliverables:

• Gathered requirements and created the technical design documents for three phases of a BW HR implementation
• Created custom infocubes and ODS objects to support reporting requirements for HR modules - Organizational Management (OM), Personnel Administration (PA), Personnel Development, and Recruiting (RC)
• Created ABAP routines and function modules to support complex requirements such as forecasting retirement eligibility and tracking employee movements within the organization
• Responsible for the design and development of the HR Cockpit and 20+ custom queries
• Responsible for the on-time delivery of the end-to-end solution within a limited timeframe
• First IS project to ever go live on time and under budget

Confidential, Annapolis, MD

BW Consultant

Responsibilities/Deliverables:

• Designed and configured BW proof-of-concept model to gain advocacy for BW within the organization
• Created custom infocubes, ODS objects, queries, and web cockpits in support of proof-of-concept demo
• Assisted in the development of the BW project plan for the implementation of SAP Product Lifecycle Management (PLM) using ASAP methodology
• Lead for PS & PLM end-to-end development
• Designed data models for custom infocubes & ODS objects in support of Navy analytical reporting requirements

Confidential, Tampa, FL

BW Lead Consultant

Responsibilities/Deliverables:

• Created an export datasource of a SEM-BPS transactional infocube to feed two custom basic infocubes for reporting
• Transformed data using ABAP routines in the update rules, transfer rules and start routines
• Further knowledge transfer to the BW Administrator

Confidential, Tampa, FL

BW Lead Consultant

Responsibilities/Deliverables:

• Cleansing of data using multiple ODS levels and start routines to homogenize data into one fiscal year variant
• Modify existing queries and simplify future query development after data cleansing
• Further knowledge transfer to the BW Administrator

Confidential, Tampa, FL

BW Lead Consultant

Responsibilities/Deliverables:

• Benchmark queries to improve query performance
• Tested multiple scenarios using cube partitioning, compression, query modifications, and aggregates
• End result of 80% reduction in average runtimes
• Provide knowledge transfer to SAP staff

Confidential, Tampa, FL

BW Consultant

Responsibilities/Deliverables:

• Initial responsibilities of SEM-BCS reporting expanded to creation of MultiCubes, custom ODS objects, data cleansing and performance tuning
• Create customer exit variables to report on data from different fiscal period variants and for key performance indicator formulas
• Create custom ODS objects to cleanse data to make reporting easier
• Create source systems and InfoSources to load flat files to BW
• Modify business content using custom InfoObjects to create financial statements and meet other strict reporting requirements
• Create MultiCubes and queries to report across different InfoCubes
• Provide knowledge transfer to the BW Administrator

Confidential, Raleigh, NC

BW Lead Consultant

Responsibilities/Deliverables:

• Lead for an on-time BW 2.0B project from development to go-live. Scope of the project included modifying 7 standard FI/CO InfoCubes and developing over 30 queries to meet the client’s reporting needs
• Responsible for configuration of the entire BW project from system setup to go-live
• Create source systems and InfoSources to load non-R/3 budget data to BW
• Design and configure the daily loading strategy with the use of custom ABAP, InfoPackage Groups and trigger events
• Modify business content using custom InfoObjects to create financial statements and meet other strict reporting requirements
• Format workbooks containing multiple queries for easy navigation using hyperlinks and Visual Basic programming
• Create and manage all transport development from BW Development to BW Quality Assurance and BW Production environments

Confidential, Monroe, LA

BW Consultant

Responsibilities/Deliverables:

• Activation of eight standard FI/CO InfoCubes, monitoring of load and query performance and extensive query development
• Manage and automate the job scheduling processes for daily loads with InfoPackage groups and custom ABAP
• Document procedures for activating business content, load scheduling, load monitoring, and transport development

Confidential, San Diego, CA

BW Consultant

Responsibilities/Deliverables:

• Support the upgrade to BW 2.0B. One of the first U.S. customers to have 2.0B installed
• Test 2.0B functionality - Web reporting, ODS reporting, and SAP remote infocubes

Confidential, Knoxville, TN

BW Consultant

Responsibilities/Deliverables:

• Analyze customer requirements against SAP-delivered Business Content
• Model legacy data for custom InfoSource development

Confidential, Chicago, IL

FI/CO Consultant

Responsibilities/Deliverables:

• Support the implementation of FI, CO and FM modules using ASAP methodology
• Responsible for all master data creation and integration into SAP R/3
• Assist with documentation, configuration, unit testing, and integration testing
• Gather reporting requirements