SUMMARY

• Senior professional with 10 years of industry working experience in technologies including SAP HANA, SAP Business Intelligence (BI), BW, BW/4 HANA and Business Objects tools.
• Possess superior and commanding experience in SAP BI solutions architecture, design and implementation based on and Native HANA, BW/4HANA and S/4HANA development platforms for EDW/ODW/EDH.
• Working experience in full development life cycle which includes end - to-end implementation/support/development/enhancement projects in all phases of requirement gathering, design/blue print, development, testing, transportation, go live, post go live support, knowledge transfer and documentation.
• Well acquainted and experienced with SDLC activities including business requirements gathering, analysis of requirements/gap-analysis, designing, development, testing, deployment and production support
• Experience working with onsite and off-shore models of project development
• Possess strong experience in modelling and creation of HANA Information Models, BW Info Providers, Business Objects Universes for specific to business requirements for analytical solutions
• Possess very good interpersonal skills, a very good team player, can work as consultant with individual responsibilities within project team, comfortable interacting with technical and non-technical audiences, possess exceptional analytical & problem-solving skills, excellent communicator to project stake holders

TECHNICAL SKILLS

SAP Environment: SAP HANA, SAP SLT, SAP ECC 6.0, S/4HANA, SAP BW/BI, BW/4HANA, HANA Studio, Web IDE (SDI and SDA), SAP Data Services, SAP Business Objects

ERP Functional: SAP ECC and S/4 HANA: SD,FI,MM,PP expertise

Databases: SAP HANA, MS SQL Server, Oracle, IBM DB2

Project Management & Other Tools: MS Project, MS Visio and MS Office Tool, MS Share Point (CMS), HP ALM, HP QC, BMC Remedy, HP Service Center, SAP Service Now, Stone Branch

PROFESSIONAL EXPERIENCE

Team Lead

Confidential, Atlanta

Technical Environment: SAP HANA, SAP SLT, SAP S/4, SAP ERP, SAP BW 7.5 on HANA, SAP Business Object tools, StoneBranch, HP ALM and SAP Service Now

Responsibilities:

• Project scope is to integrate the following systems S/4, SAP ECC and SAP BW source systems with SAP enterprise HANA for organizational wide reporting. Team lead for the OTC (Order to Cash) along with sub tasks of handling RTR (Record to Report) and PTP (Procure to Pay) modules.
• SAP S/4 and ECC: Working experience with Sales and Distribution, Finance, Material Management, Purchasing modules.
• Involved in requirements gathering, design, modeling, data provisioning, reporting, transportation and cut over activities of the different phases of the project
• Involved in preparation of the technical architecture for ETL process and prepare the architectural diagrams, technical specifications and data mappings
• HANA: Involved in design, development and maintenance of following objects as part of project requirements:
• Attribute, Analytical and Calculation Views (graphical and scripted views) Migration of Attribute, Analytical to Calculation views Standard, Virtual and Custom tables Calculated and Restricted Columns, Input Parameters and Variables Currency and Unit Conversions Aggregation, Union, Join, Projection, Star Join, Decision tables, Table Functions, Stored Procedures, Ranks and Transposing of tables(Column Headers to Rows)
• SLT: Configurations, Table replication and maintenance, Performance, Data filtration and addition of new columns
• Transports: Import/Export, Delivery Units and Application Life Cycle Management
• Business Objects: Web Intelligence and Analysis for Excel
• BW 7.5 on HANA: Open Hubs, Composite Providers for the data integration with S/4
• Support: HP ALM and SAP Service Now
• Performance: Table partitioning and Optimization of views
• Stone Branch: Scheduling of the procedures and flat file loads
• Cut Over Activities with respect to system availability for ITC and UAT readiness
• Documentation and knowledge transfer.

Team Lead

Confidential, Atlanta/United States

Technical Environment: SAP HANA SPS 12, SAP SLT, SAP ERP 6.0, SAP Business Object tools, SAP BW 7.5 on HANA and Business Explorer.

Responsibilities:

• Involved in requirements gathering, design, modeling, data provisioning and reporting and transportation activities of HANA artifacts which includes tables, views, procedures, triggers.
• Loading data into SAP HANA database using SLT, Import/Export and BW interfaces.
• Enhancement of ECC tables standard logic/fields as per the business requirements using LTRS.
• Involved in writing procedures and triggers.
• Creation and migration of HANA catalog and content objects.
• Integrating HANA views with reporting tools SAP Lumira, WEBI and Analysis for Office.
• Design and Develop solution by staging the S4/HANA Data Sources (replication), design and development of Advanced Data Store Object (ADSO)s, Open ODS Views, Composite Providers, Transformations and Data Transfer Process (DTPs) and data flows design
• Partitioning & Performance Tuning of Advanced Data Store Object (ADSO) persistent tables to improve the BW/4HANA Queries response time
• Troubleshooting the performance issues.
• Transportation of objects via Delivery Units and Import/Export.
• Documentation and knowledge transfer.

Team Lead

Confidential

Responsibilities:

• Integration of JD Edwards ERP and SAP ERP with existing SAP BW/BI landscape for Global Reporting.
• POC on SAP BW 7.5 features which was guideline for all future developments.
• Migrating standard SAP models to In-memory optimized models and performance testing.
• Involved in end-to-end activities of the project in all phases of requirement gathering, design/blue print creation, development, testing, transportation go-live and post go live support.
• Worked with all Modeling, Extraction and Reporting areas of SAP BW/BI, HANA and LUMIRA.
• Data Modelling/Extraction/Reporting with SAP HANA studio
• Worked on Data Modeling, Data Provisioning, Reporting, and Security and Authorization aspects. Experience working on HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges
• Advanced DSO’s and Composite Provider
• Data Modelling/Extraction/Reporting with SAP BW/BI on HANA, LUMIRA, FIORI, Design Studio and ABAP:
• Requirements gathering, design/blueprint, development, testing, migration of transports across landscape, go live activities and hyper care support.
• Worked with Integration of FI(GL/AP/AR),MM, Procurement modules of both SAP and JD Edwards
• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes. Experience in Importing BW models Info Cube, DSO in HANA as Analytical view. Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA
• Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis Business Objects Explorer MS Excel.
• Worked with SAP ABAP in the areas of Data Dictionary i.e. creation and maintenance of tables, structures, views, data elements, domains, function modules, programs and reports. Was involved in writing all types of Routines for data transformations.

Team Lead

Confidential

Responsibilities:

• Working experience and good knowledge in Modeling, Extraction and Reporting areas of SAP BW and Qlikview.
• Responsible for supporting day-to-day activities like data loads monitoring, handling user change requests, loading of adhoc file requests and other activities.
• Worked in different phases of the project which includes requirements gathering, design/blueprint, and development, testing and moving transports to other systems of new and enhance developments.
• Working experience with different source systems like SAP ECC, SAP BODS and flat files.
• Designed and developed generic extractors based on tables and views to load data from SAP ECC to SAP BW system.
• Generating BI Support and Performance Metrics Reports monthly which gives information on Daily, Weekly and Monthly Trend Analysis of Process Chains.
• Having good knowledge in SAP ABAP in the areas of Data Dictionary i.e. creation and maintenance of tables, structures, views, data elements, domains, function modules, programs and reports. Was involved in writing all types of Routines for data transformations.
• Worked with Business Explorer Query Designer and Analyzer creating numerous reports.
• Worked with Basis team when there are System Outages, Moving of Transports and other activities.
• Designed APD’s for different user business requirements.
• Worked with different performance improvement techniques like Indexes, DB Statistics, Aggregations, and Compression etc.
• Was an active team member in implementing Qlikview as a reporting tool with SAP BW as source system.
• Experience in utilizing Qlikview to implement complex analytical solutions which access data from multiple sources.

Technical Environment: SAP BW 7.0/7.3, SAP ECC 6.0, Business Explorer, Oracle, Qlikview.