SUMMARY

• Over 15+ years of IT experience including 13 years in SAP BW and 2 years in ABAP. Ability to work independently and as part of a team. In - depth knowledge of ETL Concepts.
• Expertise in implementing SAP BW/4HANA and BW on HANA projects and involved in data base Migration and Green Field implementation Projects. Involved in Sizing and modeling of In-memory optimized objects.
• Very Good knowledge on LSA++ based data modeling for HANA and BW Implementations. Involved in design, develop and maintenance of Full Life cycle implementation Projects.
• Designed and developed BW4HANA transformations with AMDP Script and Used Table functions to replicate ABAP logic in Native side.
• 4 Full Life Cycles Implementations involved in Sizing, Security and Data Modeling in SD, MM, PP, Vistex, Retail, APO, FICO and COPA functional areas.
• Hands on experience in HANA Studio data modeling including building Bex queries, ADSO’s, Composite providers and HANA views.
• Extensive knowledge of SAP BW/BI components and ETL process like creating Info Cubes, Multi Providers, Remote Cubes, Transactional Cubes, Data Marts, Info Source, Info Package, Data Source, Info Objects, DSO, Update rules, routines, Transfer rules, Process Chains and Event management for Automation process, Transformations in BI 2004s.
• Expertise in Business Objects 4.2, Design Studio, Universe Designer, Web Intelligence Dashboard Designer, Crystal Reports and OLAP Analysis. Built reports using SAP BO 4.1 and integrating with BI 7.5 on HANA.
• Involved in SAP Net Weaver BW Accelerator (BWA) sizing and Implementation, familiar with all BWA day to day Issues and trouble shooting.
• Expertise in OLTP extractions from SAP R/3 using LO Cockpit, CO-PA, Generic Extractions and flat files.
• Written complex ABAP user exits for transaction/master data extraction and Bex variables and complex routines in start routine and update routines.
• Involved in Setting up Information Broadcasting by creating Pre-calculation servers. Worked on query and workbook-based broadcasting.
• In-depth knowledge in BPC 10.1, SEM-BPS, Planning Area, Planning Levels, Planning Layouts, Planning Folders, Planning Profiles, Planning Functions, Planning Packages.
• Expertise in Performance Tuning of OLTP, Reporting Performance, Roll-up performance, performance analysis during Extraction/Data load and System Monitoring.

TECHNICAL SKILLS

Applications: SAP BW (3.x to 7.5), SAP BW on HANA, BW4/HANA, ECC 6.0 ABAP, HANA StudioSEM-BPS, BPC 10.1, SAP BO (3.1 and 4.2).

Reporting Tools: Query Designer, Analyzer, Web Application Designer, BOBI 4.0 (Information Design Tool, Web Intelligence, Explorer, Analysis Office, Lumira).

Programming: ABAP, VBA and SQL.

PROFESSIONAL EXPERIENCE

Confidential, NC

BW/4HANA Senior Consultant

Environment: SAP BW/4HANA, BO 4.2, and SAP ECC6.0.

Responsibilities:

• Involved in Greenfield implementation of BW/4HANA which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting.
• Designed and developed Hybrid data models combining HANA views with ADSO generated Objects and developed AO and BOBJ Reports.
• Worked on BW4/HANA Migration Cockpit and converted BW Objects to the BW/4HANA Objects.
• Designed and developed BW4HANA transformations with AMDP Script and Used Table functions to replicate ABAP logic in Native side.
• Simplified Oracle based BW data models and developed using HANA external/dictionary views and used in ABAP transformations . Developed Composite providers based on HANA Views and ADSO and created Bex and Webi reports.
• Created Multiple webi and AO reports based on bex queries and HANA views and Published through dynamic recipient based on company code / Plants.
• Installed IMO content for LO Shipments, Cost center accounting-based business content and developed simplified Hybrid data models.
• Developed Function module-based Hierarchy extractors and combined multiple hierarchies to Global customer-based hierarchy for reporting.
• Worked on ODP enabled extractors and familiar with all ODQMON based delta activities.

Confidential, TX

BW Analyst

Environment: SAP BW 7.5, BO 4.2, and SAP ECC/DBM 8.0.

Responsibilities:

• Involved in Migration Project from BW 7.3 to 7.5 on HANA, Including Sizing, preparation, Cutover activities and Testing. Converted old data flow objects to new dataflow using new in memory business content.
• Created Multiple webi reports using bex queries and HANA views and Published through dynamic recipient based on branch roles. Created/Updated Design studio dashboards using Bex queries and Visual BI Components.
• Installed IMO Inventory management data models and created dynamic No Sale, inventory turns and goods movement analysis reports.
• Involved in Production Support activities and finetuned several process chains and ABAP extractors.
• Involved in ECC/DBM 8.0 Upgrade project and responsible for all BW related extractors, ABAP user exits and upgrade cutover activities.
• Worked on ETL Extraction using Data Services and Data stage.

Confidential, Collegeville, PA

Senior Consultant

Environment: SAP BW 7.5, BO 4.1, and SAP ECC 6.0.

Responsibilities:

• Worked on BW 7.5 on HANA migration project including data flow migration from 7.0 to 7.5 and converting BW data models to ADSO and Composite providers by replacing info sets and Multi providers and related ABAP code changes.
• Worked on Migration of Bex to BOBJ conversion project, scope include Analysis, design and development of Bex and WAD reports to OLAP Analysis, Webi and Design Studio reports.
• Re-designed Genealogy Model with delta capability to improve the data load performance and related simplifications. Designed Backend model and reconciliation process to validate the Genealogy data.
• Involved in NLS Data Archiving project, was responsible for Identify and analyze the impact on Manufacturing, Quality and Packaging data models and develop the archiving process for those data models.
• Designed and developed/enhanced Design Studio dashboards for Manufacturing Production schedule adherence and Operational Metrics. Developed backend data model, BEx queries for these Dashboards.
• Responsible for analyzing and enhancing the data models and making Global Report changes for new international Rollouts.
• Responsible for onsite and offshore Co-ordination for Development work in Migration of data flows and archiving projects.

Confidential, Maryland, MD

BI Lead Consultant

Environment: SAP BW 7.4 on HANA, BO 4.1, and SAP ECC 6.0.

Responsibilities:

• Involved in Greenfield implementation of Confidential BW 7.4 on HANA project from feasibility analysis to implementation of BW 7.4 on HANA.
• Designed and developed POC for Impact Analysis of existing ECC data source feeding to BW 7.0 and BW 7.4 on HANA. Analyzed COPA and other time stamp-based extractors for delta Issues and parallel maintenance.
• Worked on HANA Modeler extensively worked on Relational Join and consumed data via IDT and published Business layer for BOBJ Reporting
• Installed HANA Optimized IMO content by activating Business functions and developed HANA optimized DSO’s and info cubes based on requirement. Implemented inventory with HANA optimized cube and build snap shot cubes for inventory aging.
• Built analytical and calculated view on MBEW and MBEWH tables to support operational reports. Consumed BW Models in HANA for BOBJ Reporting. Global Spend reporting rolled out on Business Explorer. Built analytical views and consumed in BW via Operation ODS, designed Virtual Data marts
• Consumed HANA views into BW through SAP HAP and Open ODS view to develop custom manufacturing data model by combing SAP, Hyperion and flat files data. Built operational reports for Raw material consumption and manufacturing cost.
• Created composite provider and joined DSO and HANA view for Non SAP source data and budget data.
• Replicated sales volume plan LIS table data from ECC through SLT and created HANA calculated views and exposed as analytical index and loaded data into DSO.
• Built open hubs and APD’s to migrate historical data from BW 7.0 to BW 7.4 on HANA.
• Created Webi reports for operational and dashboards with Bex queries developed on BW 7.4 on HANA.
• Redesigned existing BI data models in BI on HANA, migrated objects to HANA optimized DSO’s and SPO’s.
• Resolved performance issues in BI data loads, Bex quires and BW Accelerators.
• Front-line production support, to include help desk ticket resolution and on-call responsibilities.