SUMMARY

• More than 13 years hands on experience with SAP HANA Native, BWHANA,HANA Modeling S/4 Hana,SDI/SDA,Oracle, RFC,, BODS/BOBJ, SAP R/3 ECC, SLT, Webi, Hana 2.0 XSA, Azure, 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.
• Working knowledge in Azure Development, worked on Azure web application, App services, Azure storage, Azure SQL Database, Virtual machines, Fabric controller, Azure AD, Azure search, and notification hub
• Experience with Hana 2.0(XSA/GIT), SAP HANA Native,HAAS(Hana As A Service), Cloud Foundry, SAP BO, Power BI
• Experience 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.

PROFESSIONAL EXPERIENCE

Confidential, CA

SAP HANA Consultant

Responsibilities:

• SAP HANA SDI setup between master HANA server and Confidential client HANA servers
• Security and Auditing table replication to master HANA server
• Data Modeling with Calculation view and Stored Procedure
• Client onboarding automation in HANA
• Data collection and history preserve automation with stored procedure and XS job scheduler
• Basic usage and security reporting in Power BI.
• HANA performance optimization for Data load and reporting
• Creation of Replication tasks for the replication of Tables from various sources.
• Participated in Business Requirement meetings to understand the requirements and created Technical and functional specification.
• Prepared detailed development work break down structure to delicate work to offshore team.

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

Confidential, CA

SAP HANA Consultant

Responsibilities:

• Automation of MDS Reports in Native Hana with Dynamic join concepts which can handle all LIKE patters data.
• Worked on SAP HANA Web - based development workbench,
• Created RFC Connection set up using Adapters,
• Working in using Editor, Catalog, Security Trace tools of SDI and Replication tasks.
• 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 Business Requirement meetings to understand the requirements and created Technical and functional specification.
• Prepared detailed development work break down structure to delicate work to offshore team.

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:

• Participated in Business Requirement meetings to understand the requirements and created Technical and functional specification.
• Prepared detailed development work break down structure to delicate work to offshore team.
• Coordinated with Tech teams to resolve dependencies and complete tasks as planned.
• Using SLT to replicate data from ECC and loaded in BW HANA
• Created a source column to map to BW Data source to create ADSO for transformation and load frequency will be daily bases so will load full delta.
• Combined data from existing data sets with the new data set created with this flow using Calculation views.
• Using SAP Cloud Analytics integrated Hana view for BI Reporting.
• AO consumes data from these calculation veiws

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 Consultant

Responsibilities:

• 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, Normalized 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

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 Consultant

Responsibilities:

• 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

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

Confidential

SAP HANA Consultant

Responsibilities:

• Designed, implemented and migrated complex Universes and Business Objects Reports and S/4Hana with Lumira, Created classes, subclasses, objects, Cardinalities, Conditions, Contexts, Joins, External Strategies, Prompts and Aliases for resolving Loops and checked the Integrity of the Universes.
• Installation/Upgrade to BIP 4.1 SP2/SP3 and Data Services. Installation with SQL and Oracle Database. Migration from tomcat to SAP NW and providing support for the BOBJ Landscape.
• User/security administration, system refreshes and Client administration (automation of client copies).
• Create and restore data backups.
• Printer or spool configuration and administration.
• Monitor and manage the servers, background jobs, performance of the system.
• Installation, Post Installation, Backup and Recovery, Monitoring and Troubleshooting using SAP HANA
• Migration to SAP HANA using the Database Migration option (DMO) of Software Update Manager (SUM)
• SAP HANA High Availability Scale Out
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Used Information design tool to create connections to SAPHANA databases, Create data foundations, Create Business Layer and publish these connections and layers to the SAP BO repository.
• Designed SAP HANA data models (information Views) and BW Info Cubes /Info Providers for report consumption.

Environment: SAP HANA 1.0/2.0, S/4 Hana, SAP BW 7.4,7.3, ECC 6.0, SAP Business Objects Enterprise 4.2, SAP BODS 4.2, Hana Studio, Oracle

Confidential

SAP HANA Developer

Responsibilities:

• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• Used Information design tool to create connections to SAPHANA databases, Create data foundations, Create Business Layer and publish these connections and layers to the SAP BO repository.
• Designed SAP HANA data models (information Views) and BW Info Cubes /Info Providers for report consumption.
• Worked with exiting BI team to integrate reports using SAP BW/BI/SAP HANA, Webi4 and Dashboard
• Designed and built multiple universes for information model consumption using IDT.
• Integrated SAP BODS with SAP HANA.
• Developed SQL script procedures for complex reusable scenarios in SAP HANA
• Created SAP HANA database users, role, analytical privileges for data and data model security.
• Developed reports on Calculation View/Analytic View using Webi and crystal reports

Environment: SAP HANA 1.0, ECC 6.0, SAP Business Objects Enterprise 4.2, SAP BODS 4.2, Hana Studio, Sql server

Confidential

SAP Hana Consultant

Responsibilities:

• Developed complex calculation view using SQL and CE-Function.
• SAP HANA information model design and build including Attribute View, Analytic View, Calculation View, Analytical Privileges and Schemas.
• Developed the security model, Naming conventions, folder structure for HANA 1.0 and BOBJ 4.0 and established the recommended SAP best practices for developing Universes, reports and dashboards from HANA data sources.
• SAP Business object development in IDT, WEBI, Lumira and Dashboard
• Created advanced modeling using Hierarchies, derived views, restricted calculated column, variable, input parameter.
• Build multiple reports and dashboards using Webi, BO Xcelsius, Crystal Report
• Redesigning stored procedures to accommodate projects for SQL Server 2000 & 2005.
• Design, Test and Implement Disaster Recovery solutions for clients.
• Implemented Layered Saleable Architecture Data Staging and Data Modeling, LSA ++ in conjunction with Graphic Data Modeling
• Post Consolidation ( Run reports & Reconciliation )
• SAP HANA(Native modeling) information model build, test and transport
• SAP HANA Live content deployment for insurance (POC)

Environment: SAP HANA 2.0, SAP BW 7.4,7.3, ECC 6.0, SAP Business Objects Enterprise 4.0, Hana Studio, Information Design Tool, Interactive Analysis, Dashboard Designer, SAP Design Studio, BO Launch Pad, Business Objects Explorer

Confidential

SAP HANA Consultant

Responsibilities:

• Involved in creation of calculated attributes, measures, restricted measures, calculated columns, filters, hierarchies, variables, in-put parameters to satisfy reporting requirements using SAP HANA studio.
• Used Information Design Tool IDT to create Relational Connection, Data Foundation and Business Layer and publish these connections and layers to SAP BO Repository.
• Worked with Business to finalize the reporting and model business and technical requirements
• Develop SLT configuration for real-time data load
• Develop SAP HANA decision table process to manipulate the data
• Design and build Attribute View, Analytical View and non-scripted/scripted Calculation view
• Design and build SAP HANA Model for health insurance premium collection and claims ratio
• Build explorer and Lumira information spaces for data consumption
• Design and architect SAP HANA security using Users, Role and Analytical Privileges

Environment: SAP HANA 1.0, SAP BODS 4.0, Hana Studio, SQL

Confidential

SAP Basis/NetWeaver Security Administrator

Responsibilities:

• Applied support packages and stacks to SAP NetWeaver components.
• Performed Client Administration, Client Copy, User Maintenance, Locking / Unlocking Users.
• Performed stopping and restarting SAP application server(s) and SAP database instance during scheduled and planned maintenance.
• Moved Transports to clients in SAP Landscape (DEV, QAS, PROD & TRNG).
• Monitored and worked to improve overall SAP system performance.
• Performed SAP R/3 upgrade from 4.6 to 4.7 and performing necessary post installation steps.
• Used PFCG transaction code to perform the Role Maintenance.
• Troubleshooting logon, printer and other system issues on day to day bases.
• 24 x 7 production support.
• Monitored and worked to improve overall SAP system performance.
• Performed Operating System Administration: Monitoring disk growth, memory usage and other system resource periodically
• Performed Client Administration, Client Copy, User Maintenance, Locking / Unlocking Users
• Manage the SQL DB2/Oracle databases.
• Monitored and worked to improve overall SAP system performance.

Environment: SAP R3 4.6, ECC 5/6, Net Weaver 04/04s (WAS6.2/6.4), EHP4/5 XI/P13/7, SAP HANA, Solution Manager 4.0/7.0,Window, Lunix