SUMMARY

• More than 13 years hands on experience with SAP HANA Native, BWHANA,HANA Modeling S/4 Hana,SDI/SDA,Oracle, SAP MM, ,BODS/BOBJ, SAP R/3 ECC, SLT, Webi, Crystal Report implementation and Post Implementation, Production support, administration and consulting activities with overall IT experience on a wide range of business applications.
• 7 years of SAP HANA Design, Modeling, BO,BI/BW HANA experience and Knowledge of Analytics Cloud Reporting.
• Experience with Hana 2.0(XSA/GIT), SAP HANA Native,HAAS(Hana As A Service), Cloud Foundry, SAP BO, Power BI
• Expereince in Designing, Building, Testing and Deploying a HANA Native solutions using Calc Views, Table Functions, SQL Scripts and Function Modules.
• Experience with Smart Data Access, SLT; virtual data modeling, HANA Studio, Hana Live / Core Data Services; Lumira visualization tool; Smart Business Modeler KPI configuration through SAP Fiori
• Experience in creating SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script based methods, using SQL, SQL Script, and CE Functions as needed.
• Experience in Importing meta data, Table definitions, performing initial load and Replication, Resuming and Suspending data loads using SAP HANA studio
• Experience in Configuring and Consuming SAP HANA models in BI clients such as SAP Business Object Explorer and MS Excel.
• Excellent professional experience in Software Development Life Cycle that includes requirement gathering, design, project implementation, system test and implementation, user support and training.
• Experience with Business analysis capabilities (ability to interact directly with business user to establish requirement knowledge of SAP Enterprise Resource Planning (ERP) Central Component (ECC) and Suite on HANA, SAP Business Warehouse (B/W) Suite and B/W on HANA.
• Experience with data warehouse architecture and methodologies preferred.
• Hands on experience in SAP HANA Data provisioning using SAP BO Data Services 4.0. and have knowledge SLT Replication server. Gained experience with DATA Extraction Transfer Loading ETL for loading data from SAP ECC System to SAP HANA System. Having good knowledge on SAP HANA Architecture. Well versed with importing Meta data, table definitions, performing initial load and replication, resuming and suspending data loads using SAP HANA studio.
• Ability to interface with all levels in customers and strong abstract thinking with problem solving skills.
• Experience in data modeling (SAP BW and HANA) on enterprise data and its utilization.
• SAP BI business requirement and blue printing
• SAP BI functional and technical requirement gathering
• Team lead and mentoring
• Knowledge transfer
• Data Report and Data visualization
• Cutover activates
• SAP modules business process and table knowledge
• KPI and Dashboard build
• SAP ECC 6, SAP ECC 5, SAP ECC 4.7
• BI BW,BOBJ,BODS, HANA, SAP BW/ 4 HANA: SAP HANA Design Studio, SQLScript, CE Functions, PL/SQL,FICO, EWM
• HANA 2, S/4 Hana Oracle 11g/10g/9i/8i/8.0, MS SQL Server 2000/7.0, MS Access, Mongo DB
• SAP BW 7.0,7.3,7.3(HANA Powered),7.4, BOBJ 4.2/4.0, SAP ECC 4.7,5.0,6.0, SAP HANA 1.0/2.0, SAP Net weaver 2004S, BODS, BO,Lumira,Webi
• Programming, problem solving, Design patterns, Research and development, Mentoring/Training, Testing

PROFESSIONAL EXPERIENCE

Confidential

SAP HANA Lead

Responsibilities:

• Working on Digital Finance Transformation(DFT) project using Hana 2.0(XSA/GIT), SAP HANA Native,HAAS(Hana As A Service), Cloud Foundry, SAP BO, Power BI
• Automation of MDS Reports in Native Hana with Dynamic join concepts which can handle all LIKE patters data.
• Redesign of Qlikview Dash Boards into Native Hana with Power BI Dash Boards.
• Creation of FINBI Dash boards to measure various KPIs like Active Subscriptions, Renewal Subscriptions, Expired subscriptions, Subscription seats and Renew QTD/YTD/MTD etc.
• Creation of Materialized views to handle huge volumes of data by loading the data into physical tables using Procedures.
• Created Spendmart Datamart to know the Spend Analysis of various Products like Auto CAD, CAM, MAYA..etc.
• Creation of Replication tasks for the replication of Tables from various sources.
• Participated in Buinsess Requiremnet metings to understand the reqirements and created Tecnical and functional speciication.
• Prepared detailed development work break down structure to deligate work to offshore team.

Technical Environment: Hana Native, Hana 2.0(XSA/GIT), HAAS(Hana As A Service), Cloud Foundry, SAP BO, Power BI, S/4 .

Confidential, Bolingbrook, IL

SAP HANA Consultant

Responsibilities:

• Working on Vendor Management System for Supply Chain Analytics project using SAP HANA Native 2.0, BW HANA 7.5, BODS, Sap Cloud Analytics, SLT,SAP Business Objects
• Participated in Buinsess Requiremnet metings to understand the reqirements and created Tecnical and functional speciication.
• Prepared detailed development work break down structure to deligate work to offshore team.
• Coordinated with Tech teams to resolve dependencies and complete tasks as planned.
• Using SLT to repleacte data from ECC and loaded in BW HANA
• Created a source column to map to BW Data source to create ADSO for transformtion and load frequencey will be daily bases so will load full delta.
• Combined data from eixsting data sets with the new data set created with this flow using Calculation views.
• Using SAP Cloud Analytics integrated Hana view for BI Reprting.
• AO consumes data from these calculation veiws

Technical Environment: SAP HANA 2.0, S/4 HANA,SAP ECC 6.0, SAP BODS 4.2, Hana Studio,BO,PL/SQL,ETL,SDI/SDA,Hana Modeling

Confidential

SAP HANA Architect

Responsibilities:

• Working on IFRS project (FICO) for Mobility (Three layers Landing, NDB(Normalization Database, RAI (Revenue Accounting Items) using SAP HANA Native 2.0, S/4 Hana, SAP Hana Studio, BW,BODS,SLT,SAP Business Objects, BOBJ
• Involved in business and blueprint gathering discussion.
• 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.
• Utilized standard basic SAP S/4HANA CDS views consisting of master data for various consumption CDS query views, Maintained standard runtime hierarchies for profit center, cost center and financial statement versions,Created table functions in case of complex database functions where CDS has limitations in ansi sql
• Designed and implemented SAP HANA modeling using Attribute View, Analytic View, Calculation View and CE - Function
• Developed universes using IDT and reports using Web Intelligence.
• Worked closely with business users to define reporting requirements and documenting the requirements in order to design, develop and maintain Business Objects, Web Intelligence.
• Developed WEBI reports by using advanced functionalities like Optional prompts, Data tracking, Merge function, Custom SQL at Report level.
• Used Business Objects Web Intelligence client as the primary reporting tool obtaining Business Data into its interactive query and analysis capabilities
• Analysed the error data using ETL Tool - SAP HANA database and provide solution to the teams to fix the issue occurred in ETL Process
• Involved in writing SQL queries to verify data quality, data count and data type in the normalization of ETL Process
• Analysed the data in Landing, Normalised Database and RAI stages in ETL Process by using the ETL tool - SAP BODS
• Analysis of the error code and performing reverse engineering to find the cause of error using SAP HANA Studio in Calculation view, store procedure
• Prepared technical documentation containing all required where about of the assigned error for

Technical Environment: SAP HANA 2.0, S/4 HANA,SAP ECC 6.0, SAP BODS 4.2, Hana Studio,BO,PL/SQL,ETL.,IFRS(FICO), SLT,SDI

Confidential

SAP HANA Lead

Responsibilities:

• Created Technical specifications and standard modeling documents for HANA.
• Experience with configuration of SAP Logistics, SAP Materials Management, SAP Procurement
• Involved in business and blueprint gathering discussion.
• SAP Procurement
• 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 complex calculation view using SQL and CE-Function.
• Ability to develop and maintain effective relationships with business partners\
• Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
• Worked extensively in Virtual Data Model (VDM) development in Core Data Services (CDS) in S/4HANA.
• Developed complex calculation view using SQL and CE-Function.
• Designed and implemented SAP HANA modeling using Attribute View, Analytic View, Calculation View and CE- Function
• Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
• Created web services for querying HANA database from external end user report portal using real time jobs in data services 4.0 designer.
• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool .
• Involved in developing test scripts and assisted UAT on SAP net weaver portal using Test ID's for super users, and end users.
• Integrated BOBJ 4.0 and BODS 4.0 with SAP HANA1.0.
• Ability to lead, coach and motivate individuals and develop teams

Technical Environment: SAP HANA 2.0, SAP BW 7.4,7.3, ECC 6.0, SAP Business Objects Enterprise 4.2, SAP BODS 4.2, Hana Studio, Information Design Tool, Interactive Analysis, Dashboard Designer, SAP Design Studio, Advanced Analysis for OLAP and BO Launch Pad, Business Objects Explorer,SLT,SDI,SDA