SUMMARY

• Over 12 years of experience in the field of Information Technology with emphasis on SAP BW 7.x/3.x, SAP HANA and SAP ECC with four complete full - cycle BW Implementation Experience
• SAP Certified Application Associate SAP HANA(Edition 2016 SPS12)
• Solution Consultant mySAP BI - Business Warehouse 2002
• Experience with SAP Native HANA and SAP BW7.4 On HANA
• Big 4 Consulting experience
• Extensive experience with SAP BW 7.4
• Data Provisioning in SAP HANA with SLT & Data Services
• Hands-on experience with Data Modeling Experience with SAP HANA EIM SDI/SDQ
• Hands-on experience with SDA
• Experience in BW 7.x/3.X and skills in the area of Extraction, Transformation, Data Staging & Loading, Data modeling, Performance Tuning and Administration
• Used WEBI for building and analyzing reports on corporate data
• Proficient in development of BW applications for FI, CO, MM, PM, HR, SD, GTM modules
• Experience in Standard and Generic Extractors, Design and develop data extracts from SAP and non-SAP systems
• Experience in enhancing DataSources using User-exits
• Experience in activating standard Business Content, extending/enhancing InfoCubes, ODS objects, datasources according the requirements
• Experience in creating Transformations, Update routines, Transfer routines, User Exits using ABAP
• Expertise in creating BW reports using BEx query designer, Analyzer, Browser, Web Application Designer
• Expertise in working with BW Statistics to improve the overall performance
• Worked with OpenHub feature to distribute data from BW data objects into external systems, for Disaster Recovery Implementation
• Experience in BW transport mechanism.
• Worked on Datamarts to transfer data within the BW system
• Provided technical support to other developers and coordinated escalation of issues to SAP's Online Support System(OSS) for resolution
• Hands on experience on using Analysis Process Design(APD)
• Implemented EDW(Enterprise Data Warehouse) concept to provide each organizational unit with the needed reliable, consolidated, integrated, up-to-date, and historical information
• Knowledge of BW security and authorizations, installation and upgrading
• Experience in Implementing BI Administration Cockpit and New BI Statistics
• Content in SAP NetWeaver 7.0Creative and effective problem solver, who can deliver on time and within budget. Excellent oral and written communication skills with capacity to work effectively as an individual as well as in a team environment. Flexible in any fast-paced and diverse environment

TECHNICAL SKILLS

• SAP BW 7.x/3.x
• SAP HANA
• SAP ECC 6.0
• SAP R/3 4.6c
• BEx and Web Reporting
• Crystal Reports 8.5
• Business Objects-XI
• ABAP/4
• PL/SQL
• Windows NT 4.0/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, St. Louis, MO

Sr. SAP BW/HANA Consultant

Environment: SAP BW 7.4/7.1, SAP HANA (hana1sp12), BEx Analyzer/Web Browser Business Explorer, SAP ECC 6.0

Responsibilities:

• Hands-on experience with ADSO, Composite Providers, Calculation Views
• Worked with ODP data sources.
• Developed SAP BW Objects using LSA/LSA++ Architecture and SAP BW best practices
• Hands on experience with HANA SDI for Batch, real-time and Virtual access of external system
• Performed Real Time Replication from ECC to HANA DB using SDI for real-time reporting in BW/HANA.
• Involved in upgrade of BW system from BW7.1 to BW 7.4.
• Involved in the implementation of SAP HANA.
• Involved in the migration of 3.x datasources to 7.x data sources.
• Extensively worked on Design, development and maintenance of data targets and Process chains for Logistics, Finance extraction.
• Worked on APDs, RSCRM BAPI.
• Involved in debugging of User-exits, Start Routines, BADI to resolve issues.
• Involved in design and development of Complex BW queries.
• Involved in Performance tuning of data loads and BW queries.
• Worked with non-cumulative info cubes.

Confidential, North Chicago, IL

Sr. SAP BW Consultant

Environment: SAP NetWeaver BI 7.0, BEx Analyzer/Web Browser Business Explorer, SAP ECC 6.0, HR.

Responsibilities:

• Designed and Developed High visibility BEx queries for Leadership Impact Goal Reports.
• Developed reports for Impact goal Report program based on the criteria for determining which OM (Officials & Managers) to include in the impact goal report.
• Developed data targets for Head Count and Personal Actions.
• Enhanced Head Count and Personal Actions Data Sources.
• Extracted and enhanced Employee master data.
• Worked with various infotypes.

Confidential, Saint Louis, MO

Sr. SAP BW/BW Admin/Team Lead

Environment: SAP NetWeaver BI 7.0, SAP BW 3.5, SAP ECC 6.0, BEx Analyzer/Web Browser Business Explorer, Crystal reports, Business Objects-XI, PM, CO, MM, FI, HR.

Responsibilities:

• Daily responsibilities include new requirement gathering, data load monitoring, resolve data loading issues, customer support.
• Was part of the Global ERP implementation team that implemented SAP BW 7.0 according to Global template for Canada
• Managed a BW team of 4, in US, Mexico and India
• Worked on creation and enhancements for Master and Transaction data sources in CO, FI, HR, MM, and PM modules for the US implementation
• Extensively worked on Cost Center Accounting, Product Costing and Activity based Costing in a BW perspective
• Extensively worked on Cost Object Controlling: Plan/Actual Data and Cost Object Controlling: Period-End Closing extraction
• Created Standard Vendor Spend Analysis Reports based on Finance data
• Hands on experience in HR
• Worked on Employee Personal Information, Employee withholdings, Tax Authority Information, Employee Filing Status Data targets in HR module
• Worked on Organizational Management, Organizational Assignment Information, HR relationships table data, Job Band Assignments
• Involved in the design on BW Architecture
• Created and modified APD process for storing Financial variances
• Involved in BW release testing and upgrade testing.
• Developed BEx queries, Crystal reports & Business Object Reports for Financial Data & dashboards Using XCELCIUS
• Used WEBI for building and analyzing reports on corporate data
• Implemented SAP Business Objects Planning & Consolidation(BPC) application to simplify forecasting and effectively plan Budget.
• Worked on Performance enhancement measures for data loads and BW Queries
• Co-ordinate with Off-shore team

Confidential, Saint Louis, MO

Sr. SAP BW Developer

Environment: SAP BI 7.0, SAP R/3 4.6c, BEx Analyzer/Web Browser Business Explorer.

Responsibilities:

• Involved in Confidential ’s global implementation and support of BI 7.0.
• Gathered BI related data according to end-user requirements in the areas of Plant Maintenance, Quality Management, Sales and Distribution, Purchasing, Production Planning, Inventory Management, CRM.
• Transformed the Business requirement into suitable data model design.
• Designed and developed datatargets and master data objects for global reporting requirements.
• Worked on new BI Open Hub Destination to deliver data from BI to an external system (CDW).
• Designed & developed various DSOs, Infocubes and master data objects. Generated and enhanced standard datasources and developed generic datasources for transaction and master data.
• Involved in the Data Modeling. Defined dimensions and developed a worksheet for Fact Table details in the BW Extended Star Schema
• Implemented EDW(Enterprise Data Warehouse) concept to provide each organizational unit with the needed reliable, consolidated, integrated, up-to-date, and historical information
• Created Info Objects, DataSources, Datatargets, InfoPackages, DTP and InfoProviders to load Master and Transactional data from SAP R/3 system into BW system.
• Performed Unit and Integration testing.
• Created Standard Vendor Spend Analysis Reports using SRM data
• Implemented and extracted data from CRM extractor 0CRM SALES ORDER I.
• Extracted data from APO for Demand Planning for Forecasting.
• Implemented BI Administration Cockpit and New BI Statistics Content in SAP NetWeaver 7.0 to pro-actively support administrators in status monitoring and performance optimization in order to ensure a smooth running system, and aid in providing optimal performance.
• Developed query objects including Restricted Key Figures, Calculated Key Figures, user entry variables, SAP exit variables
• Created start routines and end routines in transformations.
• Used custom exits in creation of Variables
• Used debugging process for verification of extraction process.
• Implemented OSS notes and posted OSS messages to resolve technical issues.
• Involved in performance tuning for loading data and improving the query response times using aggregates, InfoCube partitioning and indexing.
• Activated and implemented various InfoCubes from Business Content
• Created Process Chains to automate data load process.

Confidential, Federal Way, WA

SAP BW/BI Consultant

Environment: SAP BW 7.0, SAP ECC 6.0, BEx Analyzer/Web Browser Business Explorer.

Responsibilities:

• Enhanced Business Content DataSources as per the business requirements using User-Exits.
• Defined new Transformations, changed existing transformations for SD Info Cubes
• Create Process chains for effective scheduling of various processes.
• Was involved in User Acceptance Testing
• Developed BW reports using Query Designer

Confidential, Saint Louis, MO

SAP BW/BI Consultant

Environment: SAP BW 7.0, SAP ECC 6.0, BEx Analyzer/Web Browser Business Explorer.

Responsibilities:

• Involved in a very large implementation of SAP Netweaver 2004s and ECC 6.0
• Gathered BW related data according to end-user requirements in the areas of Plant Maintenance, FI, and Treasury.
• Transformed the Business requirement into suitable data model design
• Designed and developed datatargets and master data objects for Plant Maintenance reporting requirement.
• Designed & developed various DSOs, Infocubes and master data objects. Generated and enhanced standard datasources and developed generic datasources for transaction and master data.
• Involved in the Data Modeling. Defined dimensions and developed a worksheet for Fact Table details in the BW Extended Star Schema
• Created Info Objects, DataSources, Data targets, InfoPackages, DTP and InfoProviders to load Master and Transactional data from SAP R/3 system into BW system
• Developed query objects including Restricted Key Figures, Calculated Key Figures, user entry variables, SAP exit variables
• Created ABAP routines in transformations.
• Used custom exits in creation of Variables
• Used debugging process for verification of extraction process
• Involved in performance tuning for loading data and improving the query response times using aggregates, InfoCube partitioning and indexing.
• Activated and implemented various InfoCubes from Business Content
• Created process chain to automate transaction, Master data and Hierarchy loads
• Created Process Chains to automate data load process.

Confidential, Saint Louis, MO

SAP BW Consultant

Environment: SAP BW 3.5/3.0b, SAP R/3 4.6c, BEx Analyzer/Web Browser Business Explorer, BO-XI, PM, CO.

Responsibilities:

• Gathered BW related data according to end-user requirements in the areas of Plant Maintenance and Controlling modules
• Transformed the Business requirement into suitable data model design
• Produced detailed Gap Analysis for BW
• Worked extensively on LO and Generic data extraction mechanisms.
• Involved in the Data Modeling. Defined dimensions and developed a worksheet for Fact Table details in the BW Extended Star Schema
• Involved in the redesign of existing BW Architecture by introducing Transient data targets to hold small volumes of data and Analysis Process Design (APD)
• Implemented various Cost Center Accounting, Product Costing, Activity Based Costing datatargets as a part of BOT project.
• Improved query read performance by splitting the existing infocubes. The split was based on value type and fiscal year/period.
• Created Info Objects, DataSources, InfoSources, Data targets, InfoPackages and InfoProviders to load Master and Transactional data from SAP R/3 system into BW system
• Created custom hierarchies in R/3 using sets and extracted the same in BW
• Implemented Analysis Process design (APD) using Datasource queries and Transactional ODS as a part of Integrated Costing & Reporting project (ICR).
• Automated the execution of APD processes by developing Process Chains.
• Developed BW queries to support BO-XI reporting
• Developed various queries for various categories like Brewing Process Loss, Brewing material Usage, Costcenter variances, Warehouse Process Loss, Packaging etc. these queries were source of data for BO-XI reports.
• Developed query objects including Restricted Key Figures, Calculated Key Figures, user entry variables, SAP exit variables
• Created ABAP routines in Update rules and Transfer Rules. Used custom exits in creation of Variables
• Used debugging process for verification of extraction process
• Involved in performance tuning for loading data and improving the query response times using aggregates, InfoCube partitioning and indexing.
• Activated and implemented various InfoCubes from Business Content
• Created process chain to automate transaction, Master data and Hierarchy loads
• Involved in BW release testing and upgrade testing.
• Created Process Chains to automate data load process.
• Scheduled Monthly & Weekly extractions using Process Chains on weekends & End of month.