Specific Analytical Skills:

• Accomplished as SAP BW Consultant with a proven track record of implementing projects in SAP BW/BI Implementation Projects.
• Actively involved in the complete life cycle implementation of SAP BW.
• Currently reserved for Planning Applications to get rid of SAP BPS Apps and convert to BPC10.0 Modelling with EPM Functions.
• Records of Achievement on SAP BW on HANA from open.sap.com.
• Implemented layer scalable Architecture LSA and familiar with LSA in HANA.
• Involved as a key member of project team through all phases of realization, go-live, rollout and post implementation support SAP BW.
• Acquired experience on SAP BI tools like WEBI, Dashboard, Explorer and Analysis as a source BEx OLAP Connection.
• Good knowledge on functional flow like SD, MM, FI GL Accounts COPA, CCA, PCA.
• Robust exposure on HANA technology like SAP BW on HANA, HANA studio, SAP BPC10.1 on HANA and well aware of data replication technologies like SLT, DS and DXC.
• Excellent diagnostic, problem solving and issue resolution ability Confidence in the accuracy of recommendations and analytical results.

Specific Technical Skills:

• SAP BW/BI 3.5/7.x/7.3: Expertise in Back-end Business Warehouse Components Extractors, Info Objects, Transformations, DTP's, Info Cubes, and Info Packages and front-end Business Warehouse Components Queries, CKF's, RKF's, Structures, Variables, BEx Analyzer, BEx browser and web reports.
• Performance Tuning in SAP BI 7.0: Performance tuning in BW Modeling, Extraction Reporting.
• SAP BW7.3 Upgrade: Experienced on SAP BW7.3 upgrade, Involved in preparation for migration post processing the migration Activities.
• SAP HANA: HANA Architecture, Good Conceptual knowledge on SAP HANA, SAP Replication Technologies HANA studio Information Views like Attribute views, Analytical views, Calculation views etc ,
• SAP Net weaver BW 7.30 Powered by HANA: Good exposure on SAP BW on HANA like SAP HANA optimized DSO's, Info cubes, SPO's etc
• SAP BO Good exposure on UDT, IDT, Webi, Dashboard etc
• SAPBI ABAP: Function modules, Start Routine, End Routine, Field routine, Expert Routine and Customer Exits in BEx, Data Source Enhancements, DTP routines, IP Routines.
• Communication Having strong ethics, interpersonal skills, communication, and ability to effectively manage stress and engage in continuous learning.

Professional Experience

Confidential

SAP BW Technical lead Consultant

Environment: SAP BW/BI, SAP ECC 6.0 Production Support

Responsibilities:

• Implemented BPC10.0 Planning Applications like Return Analytics and HR planning Input-forms and Reports.
• Currently engaged with HR Planning Applications to build input-forms for Power users on cost center level.
• Performed setup and maintenance tasks for Administration console tasks for RETA App.
• Replicated sales billing data sources from SAP ECC and maintained relevant data in data targets like DSO and Std. Info cube and processed data with different datasets into BPC Model.
• Managed and Maintained Transformations file and Conversions file for appropriate master data loads and transaction data loads.
• Designed and managed data upload structure with Transformation file conversion file for Hierarchy data uploads from BW to BPC.
• Replicated data from BW key Figure Model into BPC Account based Model using Transformation file.
• Executed Data management tasks in the data manager involves adding, modifying, moving, copying, and removing packages and package groups.
• Implemented custom ABAP code to process the data to specific requirement. And triggered BADI Implementations on the backend ABAP system, known as start/End routine.
• Using EPM Add-in, designed reporting and input layouts for end users and applied EPM functions for better presentation.
• Good Understanding on Business Process Flows BPFs in BPC to monitor end-user tasks and send e-mail notifications to responsible BPF owners to review submitted actions and ready to be finalized.

Confidential

Project responsibilities:

• Handled alone BEx Tools migration from 3.x to 7.x objects.
• BEx Query Designer Migration
• Workbooks Migration
• WAD Templates Migration Re build for incompatible WAD Templates.
• Variants Migration

Confidential

System Responsibilities:

• Evaluated statistical performance using BW Statistics and suggested recommendations for performance optimization. Improved data load and query performance by redesign the legacy models.
• Responsible to Check data inconsistency in RSRV tool for Master data and transaction data.
• Perform Administration tasks like Daily, weekly, Monthly, quarterly and Yearly.
• Responsible for Business users raised tickets like Day to Day business activities.
• Involved in BW Upgrade7.3, executed test cases for all Metadata Repository objects.
• Designed SPO's for large data providers to increase BWA performance.
• Designed LSA Architecture for few data flows for data staging.
• Implemented data modelling performance to improve data integrity and reporting accuracy.
• Driven Data Flow migration from 3.x to 7.x versions.
• Serving as SAP BW consultant for SAP BW, BPS,IP BPC10.0 Applications .
• Using BWA to improve query performance, Created BWA indexes for info providers and Explorer reports.
• Execute Regression test cases, key reports to check the parameters with production server before SAP Release.
• Responsible to resolve High prioritized issues occurred in BW Production system.
• Involved in EHP5,6 upgrade in ECC, Involved in Cut-Over Plan for BW side Activities.
• Anticipate and resolve project and support services risks and obstacles, and recommend solutions.

Confidential

SAP BW Technical Consultant

Environment: SAP BI 7.0, SAP R/3 4.6C, ECC 6.0, BEx Designer.

Responsibilities:

• Served as SAP BI developer Experienced on BW Roll out projects.
• Build the components for the data transformations and mappings to move and transform content from the data supply layer into the information delivery layer. Used tools like BEx Designer Xcelsius to present data in visually rich intuitive format.
• SAP BW Configuration Basic system settings while implementation.
• Installation and activation of business content objects.
• Created the Data Source and Replicate the Data Source by using Generic Extraction.
• Involved in creating custom KPI reports like Material consumption and Material forecast using generic data sources.
• Worked extensively on reports like Goods Movement, Stock Analysis COPA.
• Worked Extensively on Material Requirement Planning MRP Reports.
• Worked on Remodeling to modify an Info cube Selective deletion On cube.
• Experienced on MM COPA Data Sources Enhancement.
• Worked on RRI Report to report interface to call other reports from one single report .
• Designed varies BEx WAD Templates as per user requested for different Reports.
• Responsible for Transport Management for all objects till Production.

Confidential

Senior Software Engineer

Environment: SAP BI7.0, SAP R/3 4.6C.

Responsibilities:

• Served as SAP BW/BI developer Support after go-live.
• Built DSO objects, Info cubes, Info sets and BEx reporting using SAP BW 7.0.
• Designed automated loads for Global Settings Transfer Exchange Rates.
• Worked on SD Application to extract data, Using LO's Generic Extraction.
• Performed extraction, transformation, and loading of data ETL by preparing SAP R/3 for SAP BW and defining the loading strategies, initial and delta data loads using IDocs and PSA TRFCs , loading data via flat files and scheduling and monitoring data loads.
• Developed a custom Info Cube as per design specifications in order to meet the business user requirements.
• Involved in creation of reports by using free characteristics, restricted key figures, calculated key figures, Variables.
• Designed and developed process chains RSPC for master data loads and Transaction data Loads.

• Monitoring of loads and analyzing the reasons for frequent failures of Process Chains.

Confidential

Software Engineer SAP BI Support Role

Environment: SAP BI7.0, SAP R/3 4.6C ECC.

Responsibilities:

• Primarily worked on Support Project for front end/back end and Report Designer
• Tested and supported complex data extraction, transformation, and load processes to support reporting needs.
• Developed various info-objects, DSO, Cubes, Multi Providers , Virtual providers Transformations etc .
• Scheduled and monitored data loads as part of production support and handled enhancements as part of go-live support.
• Tested and analyzed data using SAP BW Business Explorer, defined queries, and delivered data from various sources in an organized fashion using BEx Query Designer.
• Tested, loaded master data and transaction data into the warehouse via the DW workbench.
• Created process chains RSPC for master data loads and transaction data that was scheduled for periodic loads using events
• Tested Multi-provider and Info Sets and performed reporting on them and maintained BEx Queries in BEx Analyzer and BEx WAD for analysis and web reporting respectively published in Enterprise Portal.