SUMMARY:

• 10 Years of Experience on SAP BW Implementation, Global rollouts and Support projects for clients from CPG, Pharmacy & Chemical, and Construction Industry.
• Experienced on Native HANA and BW on HANA.
• Experience in Migrating BW to BW on HANA.
• Experienced in Implementing BI solutions across Sales and Distribution, Material Management, Finance and Controlling, COPA, Customer Relationship Management
• Experienced in Project planning & Management, Managing and Mentoring teams.
• Created Functional specs interacting with the client and Technical flow documents for the Business flows based on the Functional Specifications.

PROFESSIONAL EXPERIENCE:

Confidential, California

SAP HANA Developer

Environment: SAP HANA 2.0, SAP BW 7. 5

• Worked on Sales order bookings summarized report calculation view which gives count of orders created by the user with document date in Native HANA.
• Worked on creating RMA Returns calculation view which should give output similar ECC ABAP program created for RMA returns.
• Worked on sales order bookings drill down report calculation view from detailed report Calculation view using SD tables VBAK, VBAP,VBPA, KNA1,SE01,SE02,OBJK tables in Native HANA. Tuned the performance by joining manually create time table.
• Worked on Sales order EDI report calculation view which uses SD tables and Change log tables CDHDR and CDPOS to get the processed by user from change log tables.
• Worked on production support issues & performance tuning.

Confidential, California

SAP BW HANA Consultant

Environment: SAP HANA 2.0, SAP BW 7.4

Responsibilities:

• Created a calculation view which gives output similar to ECC tcode YAP18(AP Open line item ageing report) using existing BW Multiprovider and enhancing the generated view
• Created a calculation view which gives output similar to ECC Tcode FBL3N(GL Line item) with Using existing BW Multiprovider and enhancing the generated view
• Worked on Performance tuning of the calculation views by analyzing the execution plan of the calculation view.
• Worked on extracting data from non - SAP sources using SDA and creating calculation views on top of the third party source system tables
• Worked in mixed modeling by converting existing multiproviders to composite infoproviders and creating calculation views in Native HANA
• Enhanced the existing FI data sources and the flow till multi provider before converting the multi providers to composite info providers

Confidential, Oregon, USA

SAP BI Business Analyst

• Worked on COPA Migration BW to BW on HANA Project.
• Worked in Production support on Incidents reduction in SAP BW by closely monitoring process chains and suggesting development changes to BW teams.
• Worked on HPQC defects resolution in Weekly, Monthly releases
• Resolve and fulfill SAP BI Incidents and service requests raised by users according to SLA.
• Support the day-to-day data load monitoring, fix data and performance issues.
• Worked on SNOW Incident reduction in SAP BW by closely monitoring process chains and suggesting development changes to BW frontline and BW operations team.
• Worked on Confidential Automation tools Autosys, Coach, WCC, JAWS and very good understanding of Batch Concepts.
• Very good understanding of Confidential Change Management process. Worked closely with Business functional analysts in creating Kintana in relay preparing Visio Documentation, test documentation, creating/changing jobs docs as per the requirement.

Confidential, Marlborough, Massachusetts

SAP BW HANA Consultant

Environment: SAP BW 7.4, SAP HANA 1.0

Responsibilities:

• Replicated Master data and Transaction Data Tables Using SLT from SAP ECC to HANA.
• Designed calculation views on top of ECC tables, created calculated columns, Restricted Columns, Input Parameters according to the Reporting requirement.
• Worked on transporting modeled objected from Dev to QA.
• Worked with different teams (SD, SCM, and FI) teams during poofing the materials from Confidential acquired companies.
• Worked on configuring the functionality for new Acquisitions in both BW and ECC.
• Worked on Extracting data from different Sources (ECC, Hyperion, Flat files) into BW.
• Worked on Creating Test cases, running test scripts and correcting the Defects during Regression and User acceptance testing.
• Worked on creating BOBJ WEBI reports on top of calculation views.
• Worked on creating BEX reports.

Confidential - Atlanta, USA

SAP BW/BO Lead

Environment: SAP BW 7.3

Responsibilities:

• Preparing the technical design documents from understanding the Business process and the Functional Design.
• Worked on extracting data from SD, MM, FI.
• Involved in Activating the Business Content Data Sources, Generating the Data Source.
• Extracted data from different CRM data sources using BADI.
• Developed BI customized objects like Info Objects, DSOs, Cubes, Multi providers, Process chains.
• Created Transformation's, DTP's between data targets with Start routines, End routines and field level routines.
• Worked BEX Report using CKF, RKF, Formulas, selections, Structures, Variables as per the reporting requirement.
• Created Direct process chains and Meta chains for all Master data attribute, Master data Text and Transaction data loads.
• Worked on creating reports using BOBJ WEBI on BEX reports.
• Worked extensively with the Transportation activities.
• Working in resolving the issues during data loads, Unit testing and SIT of the build objects and in fixing bugs.

Confidential, New York, USA

SAP BW/BO Lead

Environment: SAP BW 7.0, BO 4.0

Responsibilities:

• Understanding the Functional designs by interacting with the Client. Collecting the requirements and report functionalities
• Preparing the technical design documents from understanding the Business process and the Functional Design.
• Worked on extracting data from SD, MM,FI,COPA applications
• Involved in Activating the Business Content Data Sources, Generating the Data Source.
• Developed BI customized objects like Info Objects, DSOs, Cubes, Multi providers, Process chains.
• Created Transformation's, DTP's between data targets with Start routines, End routines and field level routines.
• Worked BEX Report using CKF, RKF, Formulas, selections, Structures, Variables as per the reporting requirement.
• Worked on creating reports using BOBJ WEBI and Advanced analysis as per the user requirement.
• Created Direct process chains and Meta chains for all Master data attribute, Master data Text and Transaction data loads.
• Worked extensively with the Transportation activities.
• Working in resolving the issues during data loads, Unit testing and SIT of the build objects and in fixing bugs.

Confidential

Sr. SAP BW Consultant

Environment: SAP BW 7.0

Responsibilities:

• Understanding the Functional designs by interacting with the Client. Collecting the requirements and report functionalities.
• Preparing the technical design documents from understanding the business process and the Functional Design.
• Handling the Deliverables in specified timelines. Resolving the issues and concerns in the team.
• Creating the objects as per the technical design documents and client naming standards.
• Involving in the peer review process for Development, Technical documents and the Unite testing
• Understanding the Business functionality to validate the business specific end user reports
• Resolving the defects that were raised during the Integration testing.
• Preparing the unit test documents.

Confidential

Sr. SAP BW Consultant

Environment: SAP BW 7.0

Responsibilities:

• Understanding the Functional designs by interacting with the Client. Collecting the requirements and report functionalities
• Preparing the technical design documents from understanding the Business process and the Functional Design.
• Worked on extracting data from ECC system and in modeling BI & Integrated Planning objects to provide the data for reporting and planning.
• Involved in complete data migration for one of the Business unit.
• Involved in Activating the Business Content Data Sources, Generating the Data Source.
• Developed BI customized objects like Info Objects, DSOs, Cubes, Multi providers, Process chains.
• Created Transformation's, DTP's between data targets with Start routines, End routines and field level routines.
• Worked BEX Reports, Planning reports with input layouts, workbooks.

Confidential - Plano, Dallas

Sr. SAP BW Consultant

Environment: SAP BW 7.0, BO 4.0

Responsibilities:

• Done Prototyping on BI 7.3 and Webi 4.0 Functionality on test systems to check the feasibility of reports and backed design
• Collected Report requirements from Onsite and worked on Front end Functional Designs from BEX and WEBI point of view.
• Created some complex WEBI reports in BO 4.0 Version to check on how to apply measure values, MTD and YTD as input control.
• Created WEBI report with Grid and Graph layout, applied element linking and content linking in input controls, based on the user selection from input control Graph and grid values will change.
• Worked on Front end Technical Designs, the reporting tool used for the Front end is Business Objects-Web Intelligence.
• Worked on Back end technical designs, which includes Business Partner, Customer Master, Territory master data from CRM and Sales from Informatica.
• Worked on Interface TD's with Informatica as Source System.
• Actively Participated with Onsite team in Backend data model Design for BI 7.3.
• Lead the team from offshore and provided timely updates to onsite and made proper follow-ups of the deliverables.

Confidential - Pennsylvania

Sr. SAP BW Consultant

Environment: SAP BW 7.0

Responsibilities:

• Lead the team from offshore and Involved in testing Phase apart from doing development.
• Creating TD documents by understanding the FD documents shared by the Client.
• Worked on BEX, WAD, and BOBJ reports.
• Collecting all developed Queries into TRs and releasing them and coordinating to get them transported to designated target systems.
• Testing of BEX Reports, WEBI reports to check the data consistency
• Worked on Test management like creating the test cases for BI reports, uploading the test cases to HPQC, running the test scripts, raising the defects in HPQC.
• Worked on High priority defects as a Developer by coordinating with the client.

Confidential - Benton Harbor, Michigan

Sr. SAP BW Consultant

Environment: SAP BW 7.0

Responsibilities:

• Involved in total BW Application support from converting Business requirement document into Functional specifications document, technical specification document
• Interaction with Onshore and client team to discuss the Business requirements.
• Involved in Activating the Business Content Data Sources, Generating the Data Source.
• Developed BI customized objects like Info Objects, DSOs, Cubes, Multi providers, Process chains.
• Created Transformation's, DTP's between data targets with Start routines, End routines and field level routines.
• Worked on BEX reporting tool and created the reports.
• Created test scripts for testing the objects
• Worked on testing of existing queries and updated them with new changes as a part of standardization among all regions.
• Working on the defects raised by the users in QC tool.

Confidential - Redmond, Washington, US

Sr. SAP BW Consultant

Environment: SAP BW 7.0

Responsibilities:

• Implemented Project Washington and Project GTS in Confidential .
• Involved in Activating the Business Content Data Sources, Generating the Data Source.
• Enhanced the standard data sources to meet the requirement.
• Created Generic Data source using Table, View and Function Module.
• Worked on extracting data from ECC system and in modeling BI objects to publish the data at Feed store side by using Open hubs.
• Worked on extracting data from GTS systems and in modeling BI objects to provide the data for reporting through SSRS.
• Developed BI customized data targets like DSOs, Cubes, Multiproviders, Process chains.
• Implemented Routines to meet the Requirement
• Created Direct process chains and Meta chains for all Master data attribute, Master data Text and Transaction data loads.
• Scheduled the Process chains as per the client requested timings and also resolved the upcoming issues during the Monitoring of Process chains.
• Worked extensively with the Transportation activities.
• Working in resolving the issues during data loads, Unit testing and SIT of the build objects and in fixing bugs.

Confidential - New Jersey, USA

SAP BW Consultant

Environment: SAP BW 3.5,7.0

Responsibilities:

• Installed relevant SAP business content objects and enhanced them as per requirement.
• Worked extensively on LO extractors. Installed relevant SAP business content objects. Used LO structures for SD and MM modules.
• Created Info objects, Info cubes, DSO's, Data Source and Multi Cubes.
• Created Transformations, DTP's between the Objects.
• Created Multiproviders for reconciliation.
• Created Queries on Multi providers and Info cubes. Worked on Web Application Designer.
• Designed process chains for Batch job scheduling of loads and Updating data targets.
• Transported the objects in system landscape using Solution Manager(SOLMAN)
• Solving performance-related issues by applying Partitioning, Aggregates, and Compression
• Monitoring of BW loads through process chains and Solving load failures during the data Loads.