SUMMARY:

• Over 10 years of extensive experience in SAP implementation and support projects including data modeling, extraction and report creation.
• Expertise in SAP HANA, SAP BW and SAP BW on HANA
• Worked on multiple projects with involvement in all phases of software development life cycle - Gathering Requirements, Coordinating Design efforts, developing, handling Interdependencies, Unit Testing and Documenting.

KEY FUNCTIONAL AREAS:

• Hands on experience in HANA modeling. Experience in creating Attribute views, analytical vie Configuring and Extracting data from SAP ECC, SAP CRM and SAP BW on HANA Data Base using SLT, BODS and DXC methods of Data provisioning.
• Optimization of the modeling using Calculation Engine (CE) operators in SQL Script.
• Application of HANA In-memory concepts.
• Experience on trouble shoot and Performance improvements using HANA Database.
• Creating Technical Specifications.
• Working with HANA Security by creation of users, roles, creation of analytic privileges.
• Comparing Object Versions and validated information models.
• Transport SAP HANA content with Enhanced CTS (CTS+).
• Experience in sizing and scaling of SAP HANA
• Experience with integration of HANA with BO Components. ws and calculated views.
• Create HANA optimized Data Store Object and HANA - optimized Info Cube for faster reporting to accelerate data loads, simplify data modelling and to allow faster remodeling of structural changes.
• Create Virtual, Transient Infoproviders and Composite providers in BW on top of HANA Model, created DB Connect to load data from HANA to DW.
• Work on Layered Scalable Architecture plus plus (LSA++) with SAP HANA Data Modeling with BW 7.3:
• Design & Maintain Customized Info Objects, Info Cubes, DSO Objects, Multi providers, Infosets, Data Marts, SPO s, Hybrid, Transient and composite Infoproviders.
• Experience with SAP BW 7.3 on HANA, SAP BW 7.4 on HANA migration.
• Perform functional upgrades /Migration of BW 3.5 data flow to BW 7.0.
• Working on SAP BW Accelerator, Real Time Data Acquisition, Currency and Unit Conversion
• Create ABAP Routines in transformations and maintained Process Chains.
• Great Working knowledge on Graphical Data Modelling.
• Data Extraction to BW 7.3:
• Data extraction from BW content extractors and customer generated extractors) and cross application specific extractors (generic extractors), flat file.
• Maintenance & enhancements of data sources at SAP OLTP source system.
• Work on Aggregates, Indexes, partitioning and Compression/collapse.
• Experience with Installation/upgrading/maintenance of SAP Business Objects 4.x components.
• Experience with SAP BO Launch Pad and creation of interactive reports using Webi.
• Create BO Reports on top on BEX Queries using BICS Connection.
• Develop dashboards using Dashboards 4.1 /4.0/ Xcelsius 2008.
• Create reports in Lumira to handle huge volume of data in real time.
• Work on SAP BI 4.0 Mobility for usage of BO reports with iOS/Android Devices.
• Create Semantic Layer (Universe) using IDT,
• Create Crystal Reports and Business Explorer reports for search and exploration.
• Experience with SAP BO Design Studio.
• Develop reports in front-end involving Calculated key figures, Restricted key figures, Structures, Variables, Conditions, Exceptions, Cell Editor, Formulas, RRI’s.
• Create customized Workbooks.
• Create web reports using Web Application Designer formatted reports using report designer.
• Work on Information Broadcasting for distribution of BI Data through different channels and in different formats.
• Work on integration of BW Reports to Enterprise Portal.

TECHNICAL SKILLS:

Data Modeling Tools: SAP HANA, SAP NetWeaver BW 7.4, SAP BW 7.3 and SAP BW 7.0, SAP ECC

Ticketing Tools: Service now, JIRA, Agile Methodology

PROFESSIONAL EXPERIENCE:

Confidential

SAP HANA Lead Consultant

Responsibilities:

• Responsible for gathering requirements from Super Users, Functional team and provided the design options to meet the requirements.
• Worked extensively on Data Modeling design like developing HANA Objects.
• Created AMDP Program to execute Store Procedures.
• Worked on HANA migration, impact analysis, pre-migration and post migration activities.
• Created self-service HANA Models which satisfies multiple business requirements and can be used on different reporting tools like Tableau, Thingworx.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Migrated HANA content from development, testing environment to Production environment using Life Cycle Management and delivery units.
• Performed data modeling and developed Analytical views, Attribute views and calculation views.
• Worked with Database admin to tune SQL scripts and improve the Performance of the
• System by using EXPLAIN PLAN, SQL TRACE.
• Worked on data and system integration testing to ensure data is populated as per logic.
• Worked on the Life Cycle Management to transport delivery unit and HANA views

Confidential, OKC

SAP HANA Consultant

Responsibilities:

• Worked on Graphical Data Modelling, created and maintained Process Chains.
• Created SAP HANA data modeling with SAP HANA Studio for creation of Attribute View, Analytic View, and Calculation View.
• Transfer data from different source systems to HANA using SLT and SAP Data Services tools.
• Created users, roles, creation and assignment of analytic privileges.
• Developed Virtual Infoproviders in BW on top of HANA Model.
• Involved data replication from SAP ECC to SAP HANA via SAP Landscape Transformation (SLT) had created HANA-optimized Data Store Object.
• Created Virtual Infoproviders in BW on top of BW and HANA Model, transient Infoproviders for SAP BW OLAP Functions to report on SAP HANA Analytic and Calculation Views.
• Configured SLT, created new SLT schema, replicated the data from SAP ECC and non-SAP data, modified the SLT transformation filtered, and added new fields with logic before data loading.
• Design and monitor process chains for interdependent processes with tasks like Data loading, aggregate rollups, Cube Compression, Index maintenance, Master data & DSO activation in achieving the best possible performance & data integrity for various data flows.

Confidential, St. Louis, MO

SAP HANA Consultant

Responsibilities:

• Created Calculation view using SQL scripting.
• Performed Query Performance Tuning by analyzing and applying aggregates, line item dimensions, data compression, and indices.
• Analyzing and working on Performance tuning for HANA objects by using indexes on base tables, Pagination, Splitting the HANA Views based on volume of data being consumed.
• Worked on Graphical Data Modelling, created and maintained Process Chains.
• Extraction data using SAP Landscape Transformation (SLT) as data provisioning to HANA.
• Configured SLT, BODS (ETL), DXC to connect SAP HANA with SAP systems (SAP ECC & SAP BW source systems) and extracted tables, performed metadata import, schema mapping.
• Worked on extraction of data from Excel, External data base, SAP BW, SAP ECC, and SAP Landscape Transformation (SLT) to HANA Data Base.
• Created HANA-optimized Info Cube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes.
• Created Crystal Reports on top of BW and HANA for enterprise reporting.
• Developed data models for SD, MM and FICO tables in HANA.
• Migrated HANA content using delivery units.
• Worked on graphical Data modelling.

Confidential, Moline, IL

SAPBW/HANA Consultant

Responsibilities:

• Created BW Objects for Gross Reporting.
• Created HANA-optimized Data Store Object and Info Cube for faster reporting, to accelerate data loads, simplify data modeling and to allow faster remodeling of structural changes.
• Loading data from different source systems to HANA using SLT and SAP Data Services tools.
• Implemented and developed various scenarios in SAP HANA system related to modeling (Creating Attribute views, Analytical views and Calculation View), Data provisioning (Thru SAP SLT method), Authorization and Import /export etc.
• Involved in Data Provisioning from SAP ECC, SAP BW and non-SAP sources via SLT, BODS and DXC, HANA security including User Management, Roles and Analytic Privileges.
• Designed advanced Infoproviders like SPO, Hybrid, Transient and composite Infoproviders.
• Worked on SAP HANA Data Provisioning and used SAP LT Replication Server (SLT).
• Created ABAP Routines in transformations for lookup, imperative logic and for performance Improvement.
• Involved in Performance tuning and structural fix for repeated issue.
• Worked on creation of workbooks, web reports and scheduled Webi Reports.
• Created Daily Gross Sales, Daily Department Sales and Product lookup by SKU, Product Lookup by Style and Color, Mid-Week Analysis Reports using Webi Tool.
• Trained resources on hot skills like SAP HANA, SAP BW 7.3 and SAP BO.

Confidential, Stamford, CT

SAPBW/HANA Consultant

Responsibilities:

• Involved in creation of Graphical Data Modelling and calculation views using SQL Scripting.
• Creation of users, roles, creation and assignment of analytic privileges.
• Compared Object Versions and validated information models in HANA.
• Involved data replication from SAP ECC to SAP HANA via SAP Landscape Transformation (SLT) had created HANA-optimized Data Store Object.
• Worked on creation of BW Objects in CRM for Activities, Leads and Opportunities.
• Designed advanced Info providers like SPO, Hybrid, Transient and composite Infoproviders.
• Extensively work BW/BOBJ front end reporting this include new developments, modification, trouble shooting and performance tuning.
• Created ABAP Routines in transformations.
• Monitor and optimize of the replication process in SLT.
• Designed queries using restricted and calculated key figures, Variables, Filter, Free Characteristics.
• Prepared technical design documents, Back-up and recovery.
• Involved in design and development of Opportunity Pipeline, Service Order Closure, Service Order Lead Time dashboards.
• Created reports using Webi for interactive analysis, formatted reports using Crystal Reports.
• Created reports using SAP BO Analysis using MS and OLAP tools.

Confidential

SAP BI/HANA Consultant

Responsibilities:

• Created reports using webi for interactive analysis, formatted reports for enterprise reporting using crystal Reports.
• Created Business Explorer reports for search and exploration.
• Developed dashboards using Dashboards 4.0/ Xcelsius 2008.
• Involved in SLT configuration and replication of tables by using various replication techniques.
• Involved in performance tuning activities such as query stripping, purge in webi. Experience with SAP BO Info Views.
• Design and Maintenance of Customized Info Objects, Info Cubes, DSO Objects, Multiproviders and Info sets in SAP NetWeaver BW 7.3
• Worked on creation of workbooks and web reports.
• Performance and size tuning- Optimizing data loads, index management, defining Info Cubes aggregates, query optimization.
• Performed query performance tuning by analyzing and applying, aggregates, line item dimensions and data compression.
• Experience in preparing technical design documents.
• Involved in creating procedures and calculation views using SQL Scripting.
• Solve tickets raised by the users within the SLA Periods.

Confidential

SAP Consultant

Responsibilities:

• Design & Maintenance of Customized Info Objects, Info Cubes, ODS Objects, Multiproviders, Infosets in SAP NetWeaver 2004’s (SAP-BI 7.0).
• Worked on Real Time Data Acquisition, Currency and Unit Conversion.
• Worked on data archiving, functional upgrade / migration of BW 3.5 data flow to BI 7.0.
• Business Content Installation and data loads to installed objects.
• Design queries using restricted key figures, calculated key figures, Variables, Filter, Free Characteristics, Exceptions, Conditions and Cell Editor.
• Worked on creation of workbooks and web reports.
• Evaluated statistical performance using BW Statistics. Extensively worked with performance issues using Aggregates, compression of data, Indexes.
• Developed dashboards using Xcelsius 2008.
• Created dashboards for SAP Cash Management.
• Created dashboards for Balance Sheet, Income Statement and Cash Flow Statement data.
• Solve tickets raised by the users within the SLA Periods.