SAP BW/HANA Lead Consultant, SAP BW Consultant, SAP BW Consultant

* Worked with customer team to define and convert business requirements, processes and designs
into comprehensive, robust, efficient, scalable and stable BW/4HANA Solutions.
* Built End-to-End solution with SAP HANA models using HANA Studio and generated Reports using
Business Objects (BO) Web Intelligence & SAP Lumira
* Worked on end-to-end SAP BW data modelling, data Staging & reporting activities with relevant
Object -Oriented ABAP .
* Experienced in Technical Specifications based on Functional Documents in both SAP BW and SAP
HANA areas.
* Used Integration Planning(SAP IP) for product level planning.
* Experienced as Subject Matter Expert (SME) and Trainer in SAB BW/HANA areas for End Users .
* Installed in extracting Business Content with respect to SAP Sales & Distributions, Material
Management, Finance & Inventory Management functional areas and developed End to End solution
in SAP BW /HANA.
* Extensively worked on SAP Controlling & Profitability (COPA) and SAP Project Systems (SAP PS)
extractions & reports
* Extensively worked on Data Warehouse Workbench - Advanced DSO, Composite Providers, Open ODS
Views, Info Cubes, DSO, Info Objects, DTP, Info packages, Data sources in SAP BW
* Worked on Agile/Scrum software development in SAP implementation projects.
* Worked with Data Provisioning methods using SAP LT Replication Server (SLT), Smart Data
Quality (SDQ), Smart Data Integration (SDI) and Data Services 4.2 (SAP BODS) to replicate the
data from SAP and NON-SAP applications like BigData/Hadoop, MySQL
* Coded stored procedures in SQL Script for matching the business requirements in HANA
* Worked extensively in support projects and involved in fixing defects, involved in Change
Requests and Enhancements.
* Worked with catalog and Information views (Attribute view, Analytical view, Calculated viewgraphical
and Scripted) in SAP HANA Studio.
* Involves in Extracting data from ECC and flat file using different extractor-LO Cockpit,
Generic Extractor, Operational Data Provisioning (ODP) data sources and involved in Data
Source Enhancement at ECC side for meeting the client's business requirement.

* Created Calculation Views using BW Composite Providers.
* Created calculated measures, restricted measures and columns, input parameters to satisfy
reporting requirements.
* Involved in creation of calculated attributes, measures, restricted measures, calculated
columns, filters, hierarchies, variables, in-put parameters to satisfy reporting requirements
using SAP HANA studio.
* Created SQL script for calculation views in order to address complex business requirements of
extracting purchase orders information with respect to invoiced amounts, delivered amounts
based on the PO history category type and debit/credit indicator.
* Involved in data loading using BODS from flat files to SAP HANA DB.
* Used Information Design Tool IDT to create Relational Connection, Data Foundation and Business
Layer and publish these connections and layers to SAP BO Repository.
* Involved in Accessing Analytic and calculation views from Business Objects Analysis via ODBC
connection BOBJ Integration.
* Accessed HANA data as Pivot tables in Microsoft Excel through via MDX provider.
* Imported data through flat files into SAP HANA and created schema and required tables.
* Used Information design tool to create connections to SAPHANA databases, Create data
foundations, Create Business Layer and publish these connections and layers to the SAP BO
repository

* Worked with the users to get the requirements, performed gap analysis, created functional,
architectural designs, reviewed
* Data Modeling designs with functional team Participating and finalizing the functional
requirements from the business users
* Responsible in converting the functional requirements to technical designs
* Successfully implemented SD, MM and FI/CO modules Developed custom function module extractors,
used ABAP routines in transformations
* Providing project work load and timelines to the business users Responsible for defining
technical strategy and tactical plan for implementing data and information delivery solutions
Participated in design reviews, spec reviews, code reviews, test plan reviews
* Worked with various standard as well as custom BI/BW objects for FI, CO, SD, and MM of ECC.