PROFESSIONAL SUMMARY:

• Certified SAP HANA SPS 11 Consultant with over all 5+ years of experience in installing, upgrading, configuring of SAP Databases HANA & ASE, SAP Application Products, S4HANA Installations, Upgrades and Conversions, Implementation & Modelling of HANA Database, Oracle and SQL Server SQL Development.
• Worked on installing, upgrading, configuring and automating the installations of SAP Applications - BW, SolMan, Netweaver, CRM, SCM, SRM and S4HANA on the databases SAP HANA & SAP ASE in Confidential . These automated installation packages will be used in LVM/LaMa to perform thousands of unattended installations across SAP Confidential .
• Worked on new innovative project HANA SPS12 in Confidential (MCD).
• This project mainly includes implementation of HANA multiple database container systems (MDC) in Confidential
• Worked on multiple Database migrations running on custom applications from Microsoft SQL Server to SAP HANA and Oracle to SAP HANA.
• Worked on Near Zero Down time (nZDT) procedure while upgrading HANA Databases in Confidential .
• Worked on Confidential (SDS), HANA Dynamic Tiering, and Auto Host Failover for Dynamic Tiering Hosts.
• Performed Backup and recovery of SAP HANA Database & ASE Database, Trouble-shooting SAP HANA database related issues, Managing licenses and tables.
• Configured HANA Smart Data Access (SDA) to Oracle 12c, Oracle 11g and HANA Database.
• Worked on converting Single Database Container to Multitenant Database Containers (MDC) in SAP HANA and integrating this HANA MDC into different HEC tools.
• Worked on developing bash scripts to perform post installation steps, smoke tests, Upgrade GCC Libraries, HANA data volume encryption, Quality checks, Landscape components comparison etc., in HANA Enterprise Cloud on HANA, ASE databases.
• Worked on fixing the inconsistencies of HDB user store list in hundreds of HANA Databases across MCD Landscape by developing bash scripts.
• Configured Replication Server to replicate data from Oracle 12c to Sybase ASE 15.7.1, Sybase ASE 15.7.1 to SybaseASE15.7.1, Oracle 11g to Oracle 11g and Oracle 11g to SAP HANA
• Worked on SAP HANA network zones to configure encryption in HANA Database. This configuration enables encryption of external communication and internal communication.
• Part of the team in building the project Minotaur which is a set of automation tools to assist the complete Life Cycle of Database Migration (Namely Pre-Migration Assessment, SQL code conversion, Post-Migration Assurance and Fine-Tuning Phases).
• Configured SAP Data Services 4.2 and created jobs to migrate data from Microsoft SQL Server, Oracle and DB2 to SAP HANA.

TECHNICAL SKILLS:

RDBMS: SAP HANA 1.0 SPS 82, SPS 97, SPS 97.01, SPS 102.02, SPS 102.04, SPS 102.05, SPS 112.02, SPS112.04, SPS112.07, SPS 122.02, SPS 122.04, SPS 122.05 SAP HANA 2.0 SPS 00

Sybase: ASE 15.7 SP 135, 15.7 SP 136, 16.02.02, 16.02.03, 16.02.04, Microsoft SQL Server 2012/2008, Oracle 12c/11g

SAP Applications: CRM704, ERP607SR2, ERP608, NW740SR2 (ABAP & JAVA), NW750 (ABAP & JAVA), S4HANA1511 SR1, S4HANA1610, SCM703SR2, SCM704, SolMan721, SRM703SR2, SRM704, Webdispatcher745

ETL Tool & Replication Tools: SAP Data Services 4.2, HANA SDI, System Landscape Transformation (SLT), Sybase Replication Server (Sybase ASE to Sybase ASE), Sybase Replication Server for Oracle and Sybase Replication Server for HANA

Data Modeling: SAP HANA Studio

Programming Languages: PL/SQL, ANSI SQL, T-SQL, Bash/Shell Scripting, Java, Antlr, C++, C

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Technical Consultant

Responsibilities:

• Performed manual installation of SAP Applications, HANA and ASE databases, prepared the installation packages using those parameter files and included them in LVM for every new release/ revision of SAP Applications, HANA and ASE databases to perform thousands of unattended installations from LVM across MCD Landscape.

Technical Environment: Landscape Virtualization Manager (LVM), Bash/Shell Scripting, SAP BASIS, HANA DBA, Sybase DBA.

Confidential

Responsibilities:

• Installed & Configured HANA MDC systems, HANA MDC multi node systems, HANA High Availability (HA) & Disaster Recovery (DR) systems.
• Installed HANA MDC Multi-node Systems and check auto host failover.
• Converted HANA Single Container Systems to HANA Multiple Container Systems (MDC).
• Configured HANA System Synchronous/Asynchronous Replication between primary, secondary and tertiary data centers.
• Checked the consistency of HANA Database using HDB Check tool.
• Performed Backup & Recovery for HANA SystemDB & tenant databases.
• Had setup HANA Aware Failover (1+1) setup to achieve 99.9% availability.
• Performed HANA MDC Database encryption.

Technical Environment: HANA 1.0 SPS 11, HANA 1.0 SPS 12.

Confidential

Responsibilities:

• Download the software HANA Database Server, HANA Client, Smart Data Streaming components.
• Used HANA Database Life Cycle Manager utility to install database, client and streaming components.
• Added additional host for smart data streaming and configure the role as streaming using HANA Database Life Cycle Manager.
• Installed the Smart Data Streaming Plugin manually in the SAP HANA Studio to use visual authorization tools, debugging functionality and other SAP HANA Studio tools for smart data streaming.
• Installed HANA System on single or multiple hosts.
• Installed Dynamic tiering package as an additional component to the HANA Database server using resident HANA Life Cycle Manager.
• Added single or multiple extended storage hosts from HANA host using resident Hdblcm.
• Imported delivery units into the HANA Database for monitoring extended storage configuration from HANA Studio.
• Created and maintain extended storage DB Spaces.
• Created extended table or moved HANA table to Extended Storage Server.
• Granted authorizations for extended storage administration and monitoring tasks.

Technology: HANA 1.0 SPS 11, HANA1.0 SPS12, HANA SDS, HANA DT.

Confidential

Responsibilities:

• Installed/Configured various SAP Applications like NetWeaver, BW, SolMan, SCM, SRM, CRM, ERP, S4HANA and Web dispatcher on HANA Single Container, HANA Multiple Database Container (MDC) Systems and ASE databases in Confidential .
• Worked on provisioning SolMan 7.2 Dual Stack Systems both ABAP and JAVA on HANA Multiple Database container systems.
• Worked on system upgrades, kernel upgrades, support packs and note implementations.
• Worked on trouble shooting of connection issues in HANA user store list between SAP Applications and HANA single, MDC databases.
• Integration of SAP Systems, HANA databases including HANA MDC, Sybase ASE into Solution Manager in HANA Enterprise Cloud.
• Worked on provisioning HANA Single Container and Multiple Database Container (MDC) Multi Node Systems, High Availability & Disaster Recovery Systems.
• Installed / Upgraded HANA & ASE Databases and Performed near zero downtime upgrade to HANA Databases.
• Executed Memory Management Techniques for the column store tables.
• Performed Delta Merge Operation, Table partitioning, Table Replication and Table Placement.
• Activated & analyzed expensive SQL Statements using SQL trace.
• Configured Maximum Memory allocation limit and Statement Memory Limit depending on the customer requirements.
• Had set up HANA System Replication for HA/DR setup.
• Performed Table distribution of Multi-Node HANA Systems.
• Managed Multiple Database Container Systems, Creating and configuring tenant databases.
• Performed various tasks using resident hdblcm like Adding & removing additional hosts, renaming the host, Configuring inter-service communication etc.
• Worked on Enabling / Disabling the auditing, encrypting the Data Volumes.
• Worked Troubleshooting the HANA and Sybase database using trace files.
• Worked on developing bash scripts in MCD to perform certain operations on HANA, ASE databases and at file system level which significantly reduced human efforts and time with improved accuracy.
• Worked on creating Quality Checks bash script on HANA and ASE databases to assess the quality of HANA and ASE Systems delivered in Confidential and achieved 99% of Quality in the systems delivered

Technical Environment: SAP BASIS, HANA 1.0, HANA2.0, Sybase ASE 15.7, Sybase ASE 16.0

Confidential

Responsibilities:

• Installed HANA SPS 09 single container database, executing HANA utilities for converting single container database into multi-tenant database container.
• Configured system database and creating tenant databases.
• Integrated MDC with SolMan to check system availability status, TIC to perform HDB start/stop or rebooting the servers, SISM for backup and recovery, LVM to perform unattended installation.
• Created step-by-step guide to convert HANA single database container to Multi-tenant Database Container (MDC) and the strategy to integrate MDC into different HEC tools.

Technical Environment: HANA1.0, LVM, SolMan 7.1, TIC.

Confidential

Responsibilities:

• Identified HANA systems running on global network in entire Confidential .
• Checked the listeninterface parameter to internal which makes the use of separate internal network for data communication between hosts in multi-host system.
• Changed the parameter sslEnforce to true which makes the all data communication between client and HANA database is encrypted.
• Changed the parameter ssl from false to systemPKI under communication section of global.ini configuration file ensures that only hosts belonging to the same system can communicate with each other and that all data communication between hosts is encrypted.

Technical Environment: HANA 1.0 SPS09.

Confidential

Technical Consultant

Responsibilities:

• Installed and upgraded of SAP HANA database.
• Understanding the customer source database (OLTP) by creating database complexity report, Assessment report and cost estimations.
• Installed and configured SAP Data Services between source and target database. Migrating tables and data by creating jobs using SAP Data Services.
• Understanding the logic of procedures, packages, functions and triggers in source database and creating an equivalent ANSI SQL code in SAP HANA manually.
• Converted the normal views in source database to attribute, analytic and calculation views in the target HANA Database.
• Performed Quality & data assurance check between the source and target databases.
• Performed Performance analysis Check between source and target database.
• Had set up a benchmark by completing 24k LOC MSSQL to SAP HANA migration end to end within 2-3 weeks which is one of the quickest SAP HANA migration projects ever delivered.
• Created a document for comparing data types, system-defined functions from Microsoft SQL Server, Oracle, and DB2 to SAP HANA.

Technical Environment: HANA1.0, SAP Data Services, Oracle 11g, Microsoft SQL Server 2008, PL/SQL, T-SQL, ANSI SQL.

Confidential

Responsibilities:

• Installed Oracle 11g database and HANA database.
• Installed Unix ODBC drivers, Oracle 12 client libraries in Linux server where HANA Database is installed.
• Configured Unix ODBC drivers to connect to Oracle 11g using Oracle 12c Client Libraries.
• Created a remote source in HANA Database for Oracle 11g.
• Performed DDL and DML operations on tables in Oracle 11g database from HANA database.
• Created a White Paper on this successful POC for configuring HANA SDA to Oracle 11g using Oracle 12c client libraries.

Technical Environment: HANA1.0, Oracle 11g, Oracle 12c client, HANA SDA.

Confidential

Responsibilities:

• Installed and upgraded patches of SAP HANA.
• Understanding the customer source database (OLTP), creating database complexity report, Assessment report and cost estimation.
• Installed and configured SAP Data Services between source and target databases, Migrating tables and data using SAP Data Services, Planning Cut off Strategy, converting the normal views in source database to Column Views (Modeling).
• Performed data assurance check and finally performance analysis between source and target databases.

Technical Environment: HANA 1.0, DB2.