SUMMARY

• Around 9 years of IT experience with 3 full life cycle implementations in SAP HANA/Native HANA and 3 implementations in SAP ABAP with a strong focus on reporting, database modeling, SAP integration, customer relation and business user support processes.
• Expert in understanding of the complete Architecture (Data loading, Data modeling & Reporting); Working Knowledge on SDI (Smart Data Integration)
• Worked on SAP HANA Data provisioning technology including SAP LT, Data Services, DXC; Received Data from Multiple modules - FICO,MM,SD
• Hands on modeling experience with SAP HANA Modeling using HANA Studio (created Attribute View, Analytic View, Calculation Views - Graphical / SQL Script, Stored Procedures).
• Worked on extracting data from SAP ECC, SAP CRM, MS SQL Server and SAP APO to BW and then also worked on improving reporting performance.
• Experience in Data Provisioning Technique Direct Extractor Connection- created Data Sources and transferring data models to HANA Via SAP BW.
• Created Infocubes, DSO, Transient, Virtual Providers and published HANA model in BW; Import BW model to HANA as Analytical Views.
• Experience in Trigger-Based data Provisioning using SAP LT Replication Server (SLT).
• Extensive experience in SAP ECC (FICO/SD/MM), BW/BI and HANA security in all stages of Project Development.
• Migrated data from different sources (delimited, csv, text, fixed width files) to SQL Server databases using SQL Server Integration Services (SSIS).
• Worked on DSO's, Transformations & DTP in BI 7.3
• Extensively worked in Business Information Warehouse Info Cubes, ODS Objects, Info sources, Info objects, Transfer rules, Update rules, Extractors, Info packages, Info object Catalogs, Data sources, Data Extraction, Business Content and Process Chains.
• Worked on designing SAP BW data Flows (DSOs, Transformation, and DTPs) on the BW on HANA database Scenarios and imported them to the HANA studio tool.
• Strong understanding of Data Warehouse concepts, ETL, OLAP, Star Schema.
• Transported objects from DEV to QA content objects using delivery unit mode.
• Created multiple Worksheets and Dashboards in Tableau while doing data blending.
• Worked on SharePoint to publish Tableau dashboards and WebI detailed reports.
• Extensive experience in the Modules of SD, MM, HR, FI /CO.
• Expertise in development of Reports (Classical, Interactive and ALV).
• Extensively worked on ABAP Data Dictionary objects.
• Experience with Enhancements using User Exits, BADI and Enhancement Spots/Points.
• Data Conversions and mass data upload from legacy systems to SAP R/3 systems using LSMW and BDC (Batch Input session and Call Transaction Method).
• Worked on Interfacing using BAPI’s and RFCs .
• Experienced in the development of graphical user interface by Dialog Programming using Screen Painter, flow logic - with PBO, PAI, subroutines and menu painter.
• Hands on experience in SAP WORKFLOWS.
• Object Oriented ABAP Programming.
• Developed Technical Specifications based on Functional Specifications
• Well experienced in Production Support trouble shooting, tracking, Debugging, monitoring batch jobs and Performance Tuning for Standard and Custom Reports.
• Expertise in performance analysis and tuning using debugging tools like run time analysis and SQL trace.
• Well versed with SDLC, Waterfall, Agile implementation methodology.
• Understanding of all phases of software development lifecycle including scoping, design, construction and testing of the reports.
• Experienced in successfully establishing, leading and maintaining onshore and offshore development teams.
• Expertise in conducting meetings, interviews and surveys to gather requirements and partner with customers to assess gaps and define scope of projects.
• Skilled Team player with good logical reasoning ability, coordination and interpersonal skills.
• Expert in writing testing scenarios and test scripts.
• Excellent verbal and written communication skills.

TECHNICAL SKILLS

ERP: SAP HANA 2.0, (EHP 7.0,ECC 6.0, R/3 4.6C, R/3 4.7)

Languages: SQL,ABAP/4, C,C++

Data Base: SAP HANA,Sybase, MS SQL

Operating Systems: Windows-95/98/NT/2000.

Reporting Tools: WEBI,IDT,SAP Lumira

Cross Apps: Workflow, ALE, IDoc, EDI, RFC, BADI

PROFESSIONAL EXPERIENCE

Confidential - Warsaw, IN

SAP HANA Developer

Responsibilities:

• Worked on BW on HANA and native HANA environment.
• Created/Modified Table Function and Table types as per the user requirement, to be used as source in the Calculation Views.
• Designs, develops, codes, and tests complex programs using SQL programming language in SAP HANA.
• Created new Data Sources, Transformations, DTPs, ADSOs;
• Loaded data into PSA, ADSOs and activated them.
• Validated the count with ETL team; Validated the date formats, changed the data types, lengths
• Created DIM-Calculation Views and Star Cube-Calculation Views.
• Created Calculation Views using Table functions and ADSOs as source.
• Created Calculated columns/ filters in Calculation Views.
• Created Procedures to insert data into the new/existing tables; Used different in built functions like Row Number(Partition By—Order By), To Char for date format etc.
• Generated External views from ADSOs in SAP HANA- DIM for Master Data and Fact for transaction Data.
• Transported HANA objects to QA and to Prod environment.
• Created Calculation views to develop reports in Tableau-used variables and input parameters in the view to improve the performance in Tableau level.
• Set up source tables for both IBP and Sybase(old process) for the purpose of Demand Planning.
• Created AMDP Program to execute Store Procedures.
• Worked with Database admin to tune SQL scripts and improve the Performance of the system by using EXPLAIN PLAN, SQL TRACE .
• Worked on transforming ABAP routines

Confidential - Farmington Hills, MI

SAP HANA Developer

Environment: Implementation, SAP HANA 2.0, HANA Design studio, FICO, MM, SD.

Responsibilities:

• Performed data modeling and developed Analytical views, Attribute views and calculation views
• Worked on HANA Stored Procedures, Script based Calculation views.
• Migrated HANA content from development to subsequent environments till production after successful testing in each stage and signoff from stakeholders.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards.
• Loaded master/transactional data from flat file as well as from R/3 system using SLT for real time replication.
• Interacted with business users and business analysts for understanding requirements to build universes/ reports for users.
• Created WEBI reports, Advanced OLAP analysis for Web reports.
• Involved in Project planning, maintaining different phases of the projects.
• Extensively worked on end-user requirements, business data requirements, analysis and study and efficient in testing SQL queries .
• Created, maintained, and updated several universes using Universe Design tool.
• Provided end user training about basic functionalities of using reports, such as 'opening reports, using prompts, saving reports in different formats, scheduling reports, etc

Confidential, Oklahoma City, OK

SAP HANA Modeler

Environment: Implementation, SAP HANA 1.0, HANA Design studio, FICO, MM, SD.

Responsibilities:

• Worked with the business analyst to understand and document the functional requirements.
• Participated in all phases of the process including Analysis, Design and support.
• Performed modeling exercise to address the functional specifications .
• Created several calculation view, analytical view and stored procedures to support the functional requirements.
• Developed the calculation views using graphical and SQL Script mode.
• Developed analytical views to integrate different tables.
• Enabling attribute, analytical, calculation views for reporting through Analytical privileges.
• Worked with the SAP Basis team to setup the SLT replication for SAP source data.
• Worked on Information Design Tool and Web Intelligence which has been used for reporting from Hana.
• Worked on the Life Cycle Management to transport delivery unit.
• Involved in performance tuning and optimization on Business objects reports and Universes.

Confidential

Senior SAP Technical Consultant

Environment: - Support, SAP HANA 1.0, HANA Design studio, SD, MM, FICO

Responsibilities:

• Created Technical specifications and standard modeling documents for HANA .
• Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.
• Developed data models for SD, MM and FICO tables in HANA .
• Migrated HANA content from development, testing environment to Production environment using delivery units.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool.
• Bugs fixing based on user requirement.
• Involved in developing test scripts and assisted UAT on SAP net weaver portal using Test ID's for super users, and end users.