SUMMARY

• 12 years of experience with SAP data warehousing including SAP BW/ 4 Hana, Native Hana, BW/HANA, BW, BI, BPC/IP and 6+ years of experience in Finance Domain.
• Redesigned HANA Calculation Views, and HANA Analytical Views for Sales Stats Extractor Loads and called them using the Open ODS (Using Database Tables/ Views) in SAP HANA Studio for SAP BW/4 HANA.
• Worked extensively on Open hub, APD tools to download data to the Third - Party Tools from BW/4.
• SAP BW/4 HANA Modelling for ADSO and Open ODS, Extraction and loading of data from Sales Stats (0UC SALES STATS 02) and Mass Extraction Activity for FI-CA: BP Items, Payments and Payments Lot, Promise to Pay, Installment Plans, Settlement Documents, Returns and Checks.
• Establishing connectivity between the SAP BW 4 objects with Tableau 9 and designing Tableau queries for the end users.
• Proficient with planning, Gap analysis, design implementation, trouble shooting, performance tuning, production support and user training of SAP BW/HANA, BI and HANA applications.
• Work closely with client to model the BW / Hana objects and views for the reports and dashboards based on their requirements
• HANA modelling and scripting including write complex stored procedures and HANA views using SQL.
• Administer data models in SAP HANA, including setting of information validation rules, managing schemas, the importing/exporting and transporting of data models using DUs or CTS.
• Apply advanced data modelling techniques, including currency conversion, variables and input parameters. Implement decision automation using business rules.
• Monitor, investigate and optimize data models and reporting performance on SAP HANA. Advise on modelling approach and tools to achieve optimum performance.
• Evaluate the impact of different implementation options such as table joins, aggregation, or filters. Understand the implication on performance of the various reporting tools and connection types

TECHNICAL SKILLS

• SAP BW / HANA: SAP HANA 2.0, SAP BW 7.5 on HANA, SAP BW 7.4 on HANA, SAP BW 7.0, SAP BW 3.X, HANA Studio, BW Modeling tools
• SAP BPC / IP: SAP BPC 10.1, BW IP, SAP BPS, SAP R3 ECC 6.0, PPM
• Programming Languages: ABAP, HANA SQL
• Reporting Tools: BEx Query Designer, Analysis for office, WebI, SAP Lumira, Fiori.

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/HANA Native Developer

Responsibilities:

• This Project details the high level solution design for the Demand Planning process in the E2E Supply Chain Transformation project.
• Analyze business user needs and SAP reporting requirements to determine estimate and feasibility of SAP BW models design within time and cost constraints.
• Work with SAP functional and subject matter experts to obtain the information to design the SAP BW Hana models and SAP Business Objects reports according to the user desired outputs.
• Modify existing SAP BW models according to the requirements to optimize it to run it on the new SAP HANA platform and to improve its performance according to the best industry standards.
• Develop program specification and unit test plans for SAP BW Hana models and programs by studying the application architecture and convert the assigned functionalities into algorithm and test cases.
• Perform all sorts of testing (Unit, Integration, Regression, Functional, System) as per the defined guidelines to ensure the correct result of the end SAP product, identify and resolve defects, if any.
• Integrate non-SAP reporting tools such as Tableau or Qlik with SAP BI Hana platform to provide end user reporting. Develop complex SAP Hana models using SAP Hana studio.
• Creation of schemas, tables - columns/row, SQL Script Procedures, loading data into table.
• Develop Attribute Views, Analytical Views and Calculation Views (Graphical and SQL Script) - views based on CE Functions for some of the report requirements.

Confidential, MI

SAP BW/NATIVE HANA/BPC Embedded Consultant

Responsibilities:

• Identifying and documenting the gaps between existing implemented HANA solutions on SPS05 and SPS11.
• Providing the effort and cost estimations for migrating existing Attribute and Analytical views in calculation views.
• SAP HANA Data Provisioning and Data replication using SLT(SAP Landscape Transformation) and BODS.
• Worked with other BW backend objects like ADSO, Composite providers, transformations, Data Transfer Process(DTPs), Process chains and BW Integrated Planning tools etc.
• Developing complex SAP HANA calculation views pertaining to PPM module Projects, Task allocations, Time entries like WBS Elements Customer G/L line items model for Labor and Non Labor Actual Modelling, Models for calculating YTD, MTD key figures etc. using Graphical modelling tools and SQL procedures.
• Migrating existing SAP BW infocubes into SAP HANA system using HANA Studio.
• Migrating HANA content from development, testing environment to Production environment using delivery units.
• Creating Calculated attributes, measures, Restricted measures, Calculated columns, filters, hierarchies, variables, input parameters to satisfy reporting requirements using SAP HANA STUDIO.
• Writing verification / validation test procedures using SQL.
• Analyzing scope for performance optimization in existing SAP HANA solutions.
• Created Planning Aggregation level, Filters, Planning sequences.
• Developed multiple BO Analysis report using Bex Queries as a Data source
• Creation of Input ready queries for enabling input plan data.
• Automated the Month end process using planning sequences and developed process chains to automate the process for client.

Environment: SAP BW 7.5 on HANA, BPC 10.1 Embedded, ECC 6, PPM, FIORI, ABAP/4, BEx query designer, BW modeling tools, Analysis office

Confidential, California

SAP BW/BPS/HANA(Native) Developer

Responsibilities:

• Active participation in requirement gathering, provided optimal solutions for designing and developed HANA views as per the requirement as a part of Native HANA modeling.
• Involved in HANA native development using HANA native framework which includes XSJS, O data services, server side and client-side java scripts, SAP UI5, HTML5.
• Experienced in admin activities like implementing security on HANA models, assigning roles
• Involved in configuring Production HANA systems with high-availability by adding standby host
• Responsible for Native HANA development, created HANA modeling scenarios - creation of schemas, tables - columns/row, SQL Script Procedures, loading data into table, developed Attribute Views, Analytical Views and Calculation Views (Graphical and SQL Script) - views based on CE Functions for some of the report requirements to improve the performance of the queries
• Followed LSA++ architecture for modelling of BW powered by HANA.
• Worked on various Business Objects reporting functionalities such as Drill down, Filters, Ranking, Sections, Graphs, Variables and Breaks.
• Worked extensively on SQL scripting and Relational Database modeling.
• Migrated Universe/reports/folders/groups/Users using Import Wizard across platforms.
• Involved in creating Information spaces for BO explorer by connecting to universes both (Unv and .Unx) and scheduled the caching of data.
• Worked on redeveloping Visual Composer reports to Design studio with a different User Interface using different customized cascaded style sheets (CSS).
• Implemented SQL scripting through Stored procedures to achieve complex business logics.
• Involved in implementing complex ABAP code for creating generic extractors based on function module, customer exit variables and data source enhancement’s.
• Created transactional operational data store (ODS), ADSO’s and used as target to load the data in APD (Analysis Process Design).

Environment: SAP BW 7.4 on HANA, ABAP/4, BEx query designer, BW modeling tools, ECC 6.0, Power BI, Informatica

Confidential

SAP BW Lead Developer

Responsibilities:

• Requirement gathering and blue printing after analyzing scope of improvement in existing applications for FI, SD and HR modules.
• Participating in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Preparing high level and low level design documents by following Confidential BW 7.4 powered by HANA design principles.
• Participating in brain storming sessions for optimal use of BW7.4 HANA features in existing HANA application.
• Leading all the phases of the projects like planning, requirement gathering, development, System Integration Testing, Business acceptance testing and Parallel Run testing, Handover, Hypercare etc.
• Performing lead reviews for identified modules against defined standards and templates.
• Extensively worked on LO Extraction Cockpit to extract Logistics data from Source System( R/3).
• Developing ‘Safety & Max Stock’ Logistics Module using SAP FM based generic extractors, Info cubes, ADSOs, Transformation with Expert Routines, DTPs, Info packages and process chains.
• Worked on creation of all objects as per the design documentation. Created transformations.
• SPO’S, ADSO’s, DTPs in data warehouse layer, second level of DSO’s, DTP’s, transformations in consolidation layer and Info cubes, mutlicubes in reporting layer as per architecture.
• Handled Testing and validations.
• Worked with cross functional consultants for the short and long term reporting requirements and Analysis.
• Worked with the Power Users and SAP BI technical consultants in providing technical Specification support to enhance the Forecast and Orders ADSO and Info cubes.
• Created and modified Variables, Virtual Characteristic, Virtual Key Figure, Roles, Queries for users.
• Worked in BEx query designing and the same is created as workbooks to meet as per policy reference reports.
• Designed and built Multiproviders, Infosets, DSO (Data Store Objects), Info cubes ADSO’s related to the Sales, Accounts Receivable and Account payments.

Environment: SAP BW 7.4 on HANA, ABAP/4, BW 7.0, BEx query designer, BW modeling tools, SAP ECC