SUMMARY:

• Overall 10+ Years of working on different versions of SAP HANA, SLT & BI .
• HANA Design - Expertise in Enterprise HANA modeling and Development with emphasis on performance and minimal Database usage levering capabilities of HANA DB like XS engine, Smart Data Access (SDA).
• Very good knowledge in HANA In-Memory concepts.
• Extensive experience with Calculation views with graphical and scripted methods.
• Experience on creating the CDS views.
• Created stored procedures for different use cases.
• Very good understanding on improving the performance.
• Experience in Dynamic Tiering.
• Experience on data loads using SLT for transaction data loads.
• Worked in functional areas of General Ledger, MM,AP/FA, LO Cockpit and Generic Data Extraction Data Extraction for both Master data and Transaction data. Data extraction from ECC, CRM, Flat files, Third Party systems.
• Worked with SAP AGS Team on various performance issues related to the project on BWA & SAP BW7.4/7.3.
• Worked on SAP Net Weaver 2004s BI 7.5/7.3/7.0 Implementation Projects and possess sound knowledge on the various New Concepts in BI 7.4/7.3.
• Extensively Worked on Extraction, Data Modeling & Reporting. Created Semantically Partitioned Objects (SPO), Info Cubes, Data Store Objects, Info Objects, Transformations, Data Transfer Process, Data Sources, Info Packages, Multi Provider, Info Sets, Virtual providers, RDA and Open Hub Destination & Involved in BW related ABAP such as Enhancing Standard DS using BADI.
• Extensively Worked on BWA related problems and solutions.
• BO 4.0, 4.1 experience using IDT and reports with Web I. Good knowlede on Analysis for Office and Tabluea.
• Worked on Solution manager for transports using CHARM.

TECHNICAL SKILLS:

ERP Packages: Net Weaver 7.4, Net Weaver 2004, ECC 6.0 and SAP R/3

Data Warehouse: SAP BI 7.x, SAP BW 3.x

Reporting Tools: BEx Explorer, Webi reports, WAD, BEx Browser, Lumira (Visual Intelligence), Analysis for Office, Tabluea

SD, SCM, IM, MM, FI: AP, FI-AR, GL, PP, CRM, CO-PA

Languages: ABAP/4, SQL, Visual Basic, JavaScript

Database: HANA, Oracle 9i

Other Applications: MS Office MS Visio

PROFESSIONAL EXPERIENCE:

Confidential

SAP HANA Consultant

• Involved in detailed analysis of the existing BI system.
• Worked on the requirements and design sessions to convert the exact business cases into the world class analytics using HANA.
• Extracted the data from ECC using the SLT and third party data using SDA and staged the data into HANA DB.
• Created Different HANA views based on different business areas like Sales, Delivery and billing.
• Created Attribute, Analytical and Calculation views.
• Extensively worked on creating the CDS views which were uses as base for the calculation views.
• Created stored procedures to achive the dynamic user selection options to execute the views, populate the HANA Tables.
• Used SDA to report out of a third party data which is on DB2.
• Implemented the security using the analytical privileges.
• Working closely with basis team on implementing the dynamic tiering.
• Actively working on HANA views performance issues and settings to avoid major problems.
• Assisted the Business users and BI team on executing the HANA views in AO and Tabluea users.

Environment: SAP HANA 2.0, SAP ECC 6.0, SLT, AO & Tabluea

Confidential

SAP BI/HANA Consultant

• Analyze the Existing project to understand the scope for HANA.
• Creating the HANA calculation views using the graphical and scripted methods on top of Bank Analyzer tables and views.
• Worked with SAP to understand the technology and tools that can be used for Bank environment. Worked on POC's for SAP LT, HANA views, composite providers and NLS SAP IQ.
• Implemented the SAP LT for replicating the ECC tables (FAGLFLEXT, FAGLFLEXA, BSEG, BKPF etc...) for GL transactions data.
• Involved in End to End activities of BW migration to HANA using DMO.
• Extensively involved in various meetings and worked with different
• Purpose of the project is to provide the data to legacy downstream applications like MIRD, Green sheet, FTP etc.
• Worked with the ADB (Average Daily Balances) data sources provided by SAP for Bank of America to meet the specific requirements.
• 3FI GL SI* Data sources for multiple ledgers like US GAAP, IFRS and Local. Enhanced them using the ABAP BADI ZCL IM RSU5 SAPI BADI for user requirements.
• Designed and developed the BW Data models to send huge volumes and meet the SLA's.
• Worked on complex look ups using Expert, start and end routines. Wrote ABAP exits to achieve the reporting requirments.
• Providing the warranty support after project goes live.

Environment: SAP BW 7.4 on HANA, SAP ECC 6.0, SLT

Confidential

SAP BI Consultant

• Purpose of the project is to enhance the General Ledger data and provide the same to downstream systems which used to get data from Insight system. This is called FPP. It includes BPC data from OBW.
• Worked with the ADB (Average Daily Balances) data sources provided by SAP for Bank of America to meet the specific requirements, 3FI GL SI* Data sources for multiple ledgers like US GAAP, IFRS.
• Worked with SAP on enhancing the ADB data sources them using the BADI ZCL IM RSU5 SAPI BADI performance which were exclusively developed for Bank of America i.e. ZADB*.
• Developed separate flows for Daily balances, Monthly balances and transaction level (Line Items).
• Modified the ADB extractors using BADI, Created SPO have to support multiple years of data, created Master data objects, DSOs, Cubes, Multi providers, Virtual providers, Open Hubs.
• Using Open Hubs sending the data to downstream systems as per their requirements and successfully completed the project of providing data from SAP BW by replacing legacy system data transfers.
• Involved in the redesign activities of converting the existing BW data models to new models to suit the 15 min and 30 Min reporting requirements.
• BW - IP/IBPf Planning Area, HANA View, Planning Info providers (Embedded BW), Aggregation Levels, Planning Functions, Filters, Planning Sequence, user exits, BADIs, Data slices

Environment: SAP BW 7.3,IP SAP ECC 6.0

Confidential

SAP BI Consultant

• Monitored Process Chains and resolved load failures based on resolution document.
• Follow up with Autosys to check the dependencies and job schedules.
• Resolved the CR’s & UC’s raised by End Users and Client IT Team in the Support Process.
• Created, modified the queries as per user requirements.
• Worked with the Data sources 0FI AP 4(Vendors: Line Items with Delta Extraction ), 0FI AP 50(Check Register )/ 0FI AP 51(Check Register: Line Items etc.
• Enhanced the data sources using BADI ZCL IM RSU5 SAPI BADI for custom field requirements
• Raising tickets to the functional consultants when the issues related to R/3 and other modules like out balance scenarios due to not running of ADB KFC reports in ECC.
• Involved in KT process for each release from dev Teams.

Environment: SAP BW 7.0/7.3, SAP ECC 6.0

Confidential

SAP BI & BO lead Consultant

• Extensively involved in Offshore-Onsite project execution to get the required information to develop the objects.
• As per the TDD installed the new data source 2LIS 11 VAHDR, 2LIS 11 VAHDR, 2LIS 13 VDHDR, 2LIS 13 VDITM etc..
• BO reporting: Created the Universes & Web i reports.

Environment: SAP BW 7.0, SAP BO, SAP R/3 (Version 4.6C), BO Universe, Web I

Confidential

SAP BW Associate consultant

• Support Daily Data load Operations.
• Dealing with large volume data loads from R/3, Siebel, Flat files.
• Fix the load failures and Root Cause Analysis for determining route cause for repeating problems.
• Solve the user issues like data mismatch, query modifications as per the requirement without missing SLA.
• Performance tuning of the reports to improve the response time.
• Performing enhancements required to solve problems.
• Designing and implementing the enhancements requested by the customer.

Environment: SAP BW 7.0, SAP ECC 5.0, BO 4.0