SUMMARY

• Over 11+ years of industry experience in which 2+ years is in telecom industry and around 9 years in software industry with in the field of SAP BW, BW on HANA, BO & multiple projects of BW - BPC Integration.
• Expertise in various versions of SAP BW / BI which includes 3.5 to 7.4, with multiple implementations and support projects experience.
• Extensively worked on SAP BW - BPC Integration projects.
• Strong expertise in integrating SAP ECC with SAP BPC for Budgeting, Planning & Consolidation purposes.
• Provided data to BPC from various modules like FI, HR, PS, SD, CO-PA & Funds Management.
• Extensively worked on SEM BPS and integrated CRM & PS with BW for Marketing Planning scenarios.
• Strong Hands-on experience in large-scale Data Warehousing projects with Expertise in BW, BW on HANA and BW-BPC Integration & Administration expertise.
• Functional exposure and working experience on various modules such as FI/CO, COPA, SD, MM, BPC, HR and SAP CRM.
• Strong understanding of dimensional modeling & datawarehousing concepts.
• Strong expertise in BW Modeling, BEx Reporting & BW-BPC Integration Projects.
• Experience in developing dataflow between BO & R/3, BO & BW.
• Developed Web Intelligence reports using OLAP & BICS connection.
• Transporting objects from BO Dev to BO Production & Knowledge on importing BW roles to BI system via CMC.
• Experience of implementing BW-BEx broadcasting.
• Good hands on experience in various phases of the project such as design, development and hyper care and support.
• Worked in different type of roles ranging from a Developer to Team Lead, SME & Project Management.
• Extensively worked in Data Extraction from SAP and Non SAP (Legacy) Systems using LO, FI GL, LIS, Flat file and generic extraction methods.
• Prepared project plans and effective systems development schedules and monitored team work to ensure that tasks are performed according to schedules.
• Extensively worked on BW BEx reporting tool.
• Having good Understanding and expertise of Integrating ECC/BW with SAP BPC.
• Strong experience in configuration of SAP BW, Multi Providers, Info Cubes, DSO, Info Sources and different types of extractors based on the business requirement.
• Extensively worked with ABAP Programs, Routines in transfer rules, Update Rules, Transformations routines,
• Expert in (ETL) batch schedules using process chains for data loading.
• Hands on experience in Performance tuning Techniques for overall system performance (Cube compression, Line Item Dimension, Indexing) for Improving the Reporting.
• Extensively worked on creation of Information Models in HANA as per best practices.
• Created Analytical and Attribute Views and Calculation Views based on Best Practices.
• Worked on Data Provisioning using SLT Replication server from ECC.
• Excellent Communication, work ethics, Go-getter, Self-starter, Analytical, Presentation skill with ability to work in a team and individually

TECHNICAL SKILLS

Business Warehouse: SAP BW 3.x, 7.X, BW 7.4 on HANA, HANA

Business Planning: SAP BPS, BPC 7.5 & BPC 10.0

Reporting: SAP BW BEx, WAD, SAP BO Overview

ERP: SAP R/3 4.7/4.6C and SAP ECC 5.0/6.0

PROFESSIONAL EXPERIENCE

Confidential, New York City

SAP BW / HANA Consultant

Responsibilities:

• Involve in data migration and conversion activities that include, extraction, transformation, migration, validation and reconciliation of data at offshore location.
• Involved in information gather phase
• Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Extensively worked on migration of standard Info cube and DSOs to HANA-Optimized Info Cubes and DSOs by using Tcode 'RSMIGRHANADB'.
• Worked on Advanced DSO, Open ODS View, Composite providers & Transient providers.
• Proficient in importing HANA models into BW system.
• Extensively worked on Attribute Views (Standard, Time and Derived), Analytic and Calculation Views
• (Graphical and Script based), Creation of Hierarchies, Variables and Input parameters.
• Worked with Transient Providers, Hybrid Providers and Operational Data Provisioning.
• Excellent knowledge on Data replication Techniques using SLT, DXC and SDA.
• Proficient in SLT configuration and replication of tables by using various replication techniques.
• Involved in importing the BW models from SAP BW HANA to the HANA Studio.
• Involved in SAP HANA Security including User Management, Roles, and Privileges, Reporting, Accessing Analytical and Calculation views from EXCEL.
• Provide guidance to internal IT key users to design and develop data loaders/templates to fit the business requirements.
• Identify problematic areas and conduct research to determine the best course of action to correct data.
• Proactively identify project risks and create feasible solutions. Escalate cross-functional issues and identify SMEs required for resolution.
• Involved in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Involved in supporting the data migration strategy and processes to enable efficient and effective deployment data conversion.
• Worked with MDM data which will allow the client to resolve issues with the quality of data, maintain consistent classification and identification of data, and data-reconciliation issues.
• Gathered and analysed the requirement to replicate the ECC content in HANA using data provisioning. Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Perform review of the Technical Designs, ETL Code and Unit Test Plan.
• Worked with the infrastructure team to define reference architecture of the various reporting tools.
• Work with downstream application users to gather reporting/data requirements.

Confidential, Westlake, Ohio

SAP BW & BW-BPC Interface Development Lead

Responsibilities:

• Involved in creating and managing of Info Areas, Info Object Catalogs, Characteristics, Key Figures, Application Components, Transfer Rules, Update Rules, PSA, DSOs, Info Cubes, DTP, Info package, transformation, Info Sources, MutliProviders, Info sets and Process Chains.
• Worked on Extraction (LO, FI, CO-PA and Generic extraction).
• Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Ad-hoc Queries and Web application designer.
• Created & maintained Process Chains and Meta Chains for automating data loads.
• Worked in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques, OLAP cache.
• Extensively used Open hub service to extract Data from BI and transferred to other Systems.
• Extensively worked on dealing production support issues, which involved debugging of data loads, process chains and monitoring and scheduling data loads.
• Extensively involved in installing and customizing the standard BW business content to pull information from various source systems including SAP R/3 and flat files to load the data into Info Providers.
• Handled tickets posted by users and monitored daily and monthly loads using process chains.
• Resolved complex BW isssues & requirements gathering for new enhancements & finalizing solution approach.
• Evaluated statistical performance and suggested recommendations to basis support for optimization, improved data load and query performance using compression, aggregates and partitioning.
• Extensively used APDs for fetching the data from BEx Queries & fed to the BW Cubes for BPC purposes.
• Widely worked on integrating ECC modules & BW with BPC for Actuals data reporting, budgeting, planning & consolidation purposes.
• Worked on various Integration scenarios & sourced the data from different SAP modules depending on the business planning requirement.
• Worked on integrating the SAP FI-GL, SD & MM for various business budgeting & planning purposes.
• Extracted the Line item information from FI-GL to get the customer & vendor based information with the intercompany transactions that are needed for IC eliminations in BPC Consolidation.
• Also worked on integrating the Head count information from SAP HR for Headcount Budgeting & Planning purposes.
• Worked on creating transformation & conversion files for data mapping & loading purposes from BW to BPC.
• Also worked on designing & extracting the CO information from CO-PA module for Sales Planning purposes.
• Also worked on BPC Administration activities like creation of dimensions, models, creation of master data, creating data manager packages, linking & scheduling for both master & transaction data and so on.

Confidential

Project Management (SAP BI-BPC)

Responsibilities:

• Successfully led and managed BI implementation projects for one of leading Oil and Gas Company.
• Created dashboards using chart crosstab and dimension filters.
• Developed Web Intelligence reports using OLAP & BICS connection.
• Transporting objects from BO Dev to BO Production.
• Worked on importing BW roles to BI system via CMC.
• Delivered the BW reports in the area of Refinery Marketing, Supply and Trading, Exports and Import, Entry tax and Management Reports.
• It is fairly complex project involving integration of multiple source system and the reporting requirements spanning across multiple business units.
• Designed the data flow to bring the data from Treasury module from SAP into BW for Budgeting & Reporting purposes.
• Also designed to bring the Purchasing & Inventory management information into BW.
• Streamlined the BW design, data flow & integrated the same with BPC 7.5 for Budgeting & Planning purposes.
• Also integrated the BW cubes with Business Objects for Reporting purposes.
• Helped the team to do various BW settings in BW system, that are specific to BPC.
• Extensively involved in fixing the various performance issues in SAP BPC during testing & UAT phases.
• Conducted regular status calls to track the status of project & guided the dependent teams to re-prioritize the tasks to not to miss the project deadlines.
• Helped the team to fix the automation issues wrt master data & transaction data.
• Worked on BPC Administration to streamline the data loading & automation processes in BPC.
• Fixed data reconciliation issues by fine tuning the conversion files & BADIs.
• Involved in debugging & fixing the BADIs written for report calculations.
• Helped the client to understand BADIs & enabled them to do slight changes if required in future to meet the latest reporting requirements.
• Documented the design, configuration & reviewed before handing over to the client.

Confidential

BW Lead

Responsibilities:

• Gathered the requirements for implementing the BW system wrt BPC planning & consolidation requirements.
• Implemented BW solution for various BPC Planning requirements.
• Sourced the data from various SAP modules like FI-GL, MM, HR, PS & SD for various models in SAP BPC.
• Extensively used APD for feeding the data to SAP BPC from various BEx Queries.
• Automated the data loading process in SAP BPC by linking the Data manager packages in BW process chains.
• Designed & Implemented BW Solution for BO Reporting purposes also.
• Extensively used customer exit variables to automatically determine the Fiscal period, year etc for BO.
• Designed Bi-Weekly reports for top management
• Independently handled the whole BW solution for both BO reporting and BPC Planning & Consolidation purposes.
• Helped the team to do various BW settings in BW system, that are specific to BPC.
• Extensively involved in fixing the various performance issues in SAP BPC during testing & UAT phases.
• Conducted regular status calls to track the status of project & guided the dependent teams to re-prioritize the tasks to not to miss the project deadlines.
• Received good appreciation from the Client for helping them in meeting the timelines with the assigned tasks & delivering the BW solution independently.
• Helped the BPC team in crisis situations by doing BPC administration work during UAT & Go-Live.
• Requirement gathering and created technical specification and supported the BO application.
• Review & Understanding design of the project.
• Created dashboards using chart crosstab and dimension filters & extensively worked on development of dashboards using Design studio.
• Manual testing & validation of the application data.
• Worked on creating the reporting logical design document, security & unit test case document.
• Transporting objects from BO Dev to BO Production.
• Responsible for creating unit test cases & solving SIT defects.

Confidential

BW Consultant

Responsibilities:

• Extensively worked on migration of standard Info cube and DSOs to HANA-Optimized Info Cubes and DSOs by using Tcode 'RSMIGRHANADB'.
• Worked on Advanced DSO, Open ODS View, Composite providers & Transient providers.
• Proficient in importing HANA models into BW system.
• Extensively worked on Attribute Views (Standard, Time and Derived), Analytic and Calculation Views
• (Graphical and Script based), Creation of Hierarchies, Variables and Input parameters.
• Worked with Transient Providers, Hybrid Providers and Operational Data Provisioning.
• Excellent knowledge on Data replication Techniques using SLT, BODS, DXC and SDA.
• Proficient in SLT configuration and replication of tables by using various replication techniques.
• Involved in importing the BW models from SAP BW HANA to the HANA Studio.
• Good Knowledge in SAP HANA security including User Management, Roles and Privileges.
• Worked on both BPC 7.5 & BPC 10.0 versions.
• Widely worked on integrating ECC modules & BW with BPC for Actuals data reporting, budgeting, planning & consolidation purposes.
• Worked on integrating the SAP FI-GL, SD, MM & Funds Management for various business budgeting & planning purposes.
• Extracted the Line item information from FI-GL to get the customer & vendor based information with the intercompany transactions that are needed for IC eliminations in BPC Consolidation.
• Also worked on integrating the Head count information from SAP HR for Headcount Budgeting & Planning purposes.
• Worked on creating transformation & conversion files for data mapping & loading purposes from BW to BPC.
• Also worked on designing & extracting the CO information from CO-PA module for Sales Planning purposes.
• Also worked on BPC Administration activities like creation of dimensions, models, creation of master data, creating data manager packages, linking & scheduling for both master & transaction data and so on.
• Proficient in creating Business Planning & Simulation scenarios for various business requirements.
• Implemented BPS for Trade promotion planning (TPM) scenarios.
• Also implemented BPS for Marketing & Planning management scenarios.
• Also implemented BPS for Budgeting scenarios while integrating the CRM, PS & BW in Marketing management.
• Extensively used Top-Down Budgeting process while implementing the BPS for Marketing Management scenarios.
• Created customized BW Cubes, Planning areas & planning profiles to accommodate customer planning scenarios by copying the standard content.
• Integrated Master data & transaction data with the Planning data & reporting done to do Actual vs Plan comparison.
• Also created characteristic relationships, planning packages, planning levels & layouts.
• Coordinated with SAP support for product related issues & got the sap notes released from them.
• Coordinated very well with different functional team owners & business owners to integrate various sap components like SD, CRM, BW & PS.
• Involved in creating and managing of Info Areas, Info Object Catalogs, Characteristics, Key Figures, Application Components, Transfer Rules, Update Rules, PSA, DSOs, Info Cubes, DTP, Info package, transformation, Info Sources, MutliProviders, Info sets and Process Chains.
• Good command on Extraction (LO, FI, CO-PA and Generic extraction).
• Worked on Info Objects, DSO's, Info Cubes, Multi Providers and Info Sets.
• Expertise in front-end Business Warehouse components (BEx Analyzer, Query Designer) for Queries, workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, Ad-hoc Queries and Web application designer.
• Proficient in performance tuning techniques which involves the evaluation of statistical performance, data load improvisation and query performance using compression, aggregates and partitioning techniques, OLAP cache.
• Experience using Open hub service extracted Data from BI and transferred to other Systems.
• Resolve complex BW isssues & requirements gathering for new enhancements & finalizing solution approach.
• Evaluated statistical performance and suggested recommendations to basis support for optimization, improved data load and query performance using compression, aggregates and partitioning.
• Extensively used APDs for fetching the data from BEx Queries & fed to the BW Cubes for BPC purposes.
• Created dashboards using chart crosstab and dimension filters in SAP BO Design Studio.
• Developed Web Intelligence reports using OLAP & BICS connection.
• Transporting objects from BO Dev to BO Production.
• Worked on importing BW roles to BI system via CMC.
• Proficient in all kinds of Routines (Start, Field, End and Expert routines). Ability to identify the suitable routine based on the scenario.
• Extensively worked on Customer Exit Variables using Customer Exit.
• Expertise in Info Package and DTP routines, Debugging, Performance tuning of various objects, Code reviews and designed the documents for best practices in BW environment.