SUMMARY:

• Overall 11 years of experience in administrating SAP applications and Databases as a Senior SAP BASIS Administrator
• SAP Certified Consultant in HANA DBA, OS/DB Migration and SAP NetWeaver BASIS
• Experience includes SAP systems Support, Installations, Implementations and DB Migration
• Administration of both ABAP & Java Stack Systems
• Administration of Databases like Oracle, DB2, MS - SQL, MaxDB and HANA DB
• Administration of Operating Systems like AIX, Unix, Linux and Windows Server
• Working experience on SAP NW and Business Suite Components like ERP ECC, BW, PI, SCM, CRM, SRM, NLS, Portal, Solution Manager, MDG, BIA, TREX, SLT, BODS, BOBJ and S/4 HANA
• Experience in performing a release upgrade, installing enhancement packages, applying support package stacks, installing add-ons and updating single components using SUM tool
• Working experience with ABAP and JAVA systems tools like SPAM,SAINT,SUM,SWPM, SDM, JSPM, NWA, Visual Administrator, Configtool, dpmon jcmon and jsmon
• Experience in installing the SAP HANA on AWS (Amazon Web Services) Cloud
• Having good experience in ITIL Ticketing Process (Incident, Problem & Change Management)
• Providing SAP applications production support for 24x7 shift and on-call basis
• Experience in installations, upgradations and system copies of ABAP and Java stack systems
• Performed the DB migration from Oracle to DB2 for ABAP and Java stack systems
• Performed the Java stack splitting for dual stack ABAP & Java systems
• Performed SAP application and database patches and upgrades
• Performed SAP JVM Installation and Upgrade
• Installation and Administration of Web Dispatcher, TREX, SMD agents, SAP Host Agent and SAP CCMS Agents (SAPCCMSR & SAPCCM4X)
• Administration, monitoring and reorganization of BI Accelerator(BIA)
• Performed the CCMS Alert Configuration and Administration
• Performed kernel upgrades and Patch upgrades
• Administration of XI Channels includes monitoring, Stop and Start using Runtime Work Bench
• Administration of saprouter and saposcol
• Administration of RFC Connections includes Creation, Testing and Troubleshooting
• SAP backup Scheduling, Maintenance and troubleshooting
• Performed SAP client administration(change, create, copy, delete, export and import)
• Transport Administration and managing the transport domain
• Background jobs scheduling, modifying, deleting and analyzing the logs for failed and long running jobs
• Experience in Solution Manager System Preparation, Basic, Managed System Configuration and MOpz, Incident and Change Request Management(ChaRM) usage
• SAP print/spool management and troubleshooting
• Expert in SAP and Database Parameter Administration
• Installation and Administration of Databases like Oracle,DB2,HANA,MS SQL and MaxDB
• Performed System refresh, Database restore activities for Dual and Single stack Systems with PIT recovery for databases like Oracle, DB2, HANA, MS SQL and MaxDB
• Performed Oracle Tablespace reorganization/compression
• Reviewing the Early Watch and DVM Reports and performed necessary changes
• Configured the Early Watch Alerts and Troubleshooting
• Extensively used SAP Market Place for downloading the required Software, reporting the product errors and opening connections to SAP
• SAP OSS messages raising, generating log files using SAP provided tools and uploading
• Perform critical routine health check of SAP systems like work processes, users, system logs, short dumps, locks, traces files, Tablespace, disk space usage and Performance Tuning
• Configured SSO between ABAP and JAVA
• SAP Note download and implementation
• Performed Vertex tax monthly update
• Performed the SAP SPS, EHP and Release upgrades
• Installation and Administration of BOBJ (Business Objects)
• Managed SAP users, roles, profiles and troubleshooting the authorization issues
• Installed G.I.B components on SAP ECC system
• Providing production support for SAP applications on 24x7 shift
• Preparing the SAP Daily, Weekly and Monthly reports of Health Checks, Backups and Database sizes
• Installed the HANA Database, Client, Studio and Lumira server using GUI and Command Line Interface
• Experience in stopping and starting Hana db using Hana studio and HDB CLI in standalone and distributed scenario
• Installed and configured the SLT(SAP Landscape Transformation Replication Server) for real time replication from ERP to HANA
• Modified HANA db parameters when required and to activate HANA services
• Performed the HANA DB revision and patch update using HANA Life Cycle Manager(LCM) with GUI and Command Line Interface option
• Performed SAP HANA DB Backup and Recovery using Studio and Scheduled using DBA cockpit and scripts in hdbsql CLI
• Applied Hana license when it got expired and while performing post steps of DB refresh
• Monitoring Hana db services status, data and log backup status, resource utilization and alerts in the system using HANA studio, HANA cockpit and DBA cockpit
• Activated different types of traces and analyzed them to resolving the issues
• Collected the Full system dump using Python script and upload it to SAP
• Performed the SAP System refresh from Production to Quality using HANA DB backup and recovery method
• HANA DB Monitoring and administration using HANA Studio, DBA Cockpit, HANA Cockpit
• Performed SAP HANA Integration with SAP Solution Manager
• Installed SAP HANA on AWS (Amazon Web Services) Cloud
• Experience in HANA DB Table Administration includes Table creation, Portioning and distribution
• Involved in setting up the DR for HANA DB
• Involved in HANA DB migration from Oracle for ECC and BI environment using classical and DMO migration
• Good knowledge on HANA DXC data provisioning configuration
• Experience in Administration of HANA Scale Out/Distribution Architecture
• Good knowledge on Multi-tenant DB installation and administration
• Good knowledge on HANA SDI(Smart Data Integration) and SDQ(Smart Data Access) implementation
• Installed S/4 HANA Demo21 system for POC(Proof of Concept)
• Good knowledge on Installation and migration of ECC on HANA DB to S/4 HANA SFIN
• Experience in SAP HANA Security including User Management, Roles, and Privileges

TECHNICAL SKILLS:

SAP NW Components: ERP ECC, PI, BW, Solution Manager, SCM, CRM, SRM,MDG NLS, GRC, Portal, S/4 HANA

Operating Systems: AIX, Unix, Linux, Windows Server

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

Applications/Tools: Vertex, TREX, SLD, SMD, Wily, Host Agent, BI Accelerator(BIA)

PROFESSIONAL EXPERIENCE:

Confidential, Cincinnati, OH

Senior SAP BASIS/HANA Administrator

Environment: SAP ECC, PI, BW, SOLMAN,NLS, BOBJ, DS, CRM, SCM, SRM, MDG, Portal, Vertex, Oracle, HANA,MS-SQL, DB2, Windows Server, UNIX, LINUX

Responsibilities:

• Installed the HANA Database and Lumira server
• Installed and performed the SLT data provisioning
• Performed the HANA components, version and patch upgrade
• Performed SAP HANA DB Backup and Recovery
• Monitoring and administration of SAP HANA Databases using Solution Manager DBA cockpit
• Experience in SAP HANA Administration Tools-HANA Studio, DBA Cockpit, HDBSQL CLI Tool
• SAP HANA Parameters configuration
• Performed SAP HANA Integration with SAP Solution Manager
• Daily monitoring and troubleshooting of all SAP Systems logs and proactively fixes errors in
• Installed and configured solution manager 7.1 and performed the basic configuration setup
• Installation and Administration of BOBJ (Business Objects)
• Performed EHP upgrade for ECC systems using latest SUM tool
• Worked on CCMS alert monitoring setup and configured threshold
• Performed Vertex tax rate monthly update
• Analyzed weekly EWA reports and proposed solutions to related Red and Yellow alerts
• Installed G.I.B components on SAP ECC system
• Performed system/DB refresh on HANA, Oracle and MS SQL Databases
• Installed SMD agents on Windows and Unix Servers
• Installed SAP HANA on AWS (Amazon Web Services) Cloud
• Performed Oracle version Upgrade from 10.2.0.4 to 11.2.0.1
• Applied Oracle Patches and parameters according to SAP recommendations
• Installed S/4 HANA Demo21 system for POC(Proof of Concept)

Confidential, San Jose, CA

Senior SAP Basis Administrator

Responsibilities:

• Have done system refresh using Backup and Restore method
• Sync manually DR server from Production system
• Manage database online/offline backups/Incremental backups
• Generations of SAP health checks/system monitoring (Daily, Monthly, Quarterly).
• Performance analysis and workload analysis, identifying the performance bottlenecks.
• Applying Support packages ABAP+JAVA stack systems using SPAM/JSPM tools.
• Setting Transport Management landscape and performing transports on request and troubleshooting the transports issues.
• Performing SAP profile parameter Changes and configuration of Operation modes.
• Performing Client copies between clients and systems.
• Manage the updates, checking the database alert log, OS log and trace files.
• Performing SAP database activities like Backup, Restoration, Recovery, Tablespace administration and rebuild of indexes with BRTOOLS.
• Applied licenses to SAP systems
• Performed Spool Administration - configuration and troubleshoot of printer issues
• Installed and configured SAP systems as per requirements
• SAP HANA DB Installation, administration and monitoring using HANA Studio and OS level
• Performed HANA patch upgrade, parameter changes, Backup and Recovery

Confidential, Fremont, CA

Senior SAP BASIS Consultant

Environment: ECC, XI, BI, SOLMAN, CRM, Portal, Oracle, MS SQL Server, AIX

Responsibilities:

• Day to day monitoring and troubleshooting of all SAP systems in landscape
• Analyzing weekly EWA reports and proposed solutions related Red and Yellow alerts
• Updated JDK/JVM 4.1 in JAVA systems using JVM SWITCH TOOL
• Performed ECC, EP and BW systems refresh from PRD to QAS.
• Worked on CCMS alert monitoring setup, analyzed all the all MTE nodes in Production system and proposed recommended threshold values for effective monitoring
• Performed Kernel and Patch Upgrade
• Monitoring the Tablespace and File system at OS level and Extending them accordingly
• Administration of Background jobs
• Configuration and Administration of Printers
• Performed the Client creation and client copy
• Analyzing the ABAP dumps, System logs, Trace files and DB logs to resolve the issues
• Experienced in all aspects of SAP Security and Authorizations, User Administration, Management, Profile Generator, Auditing, Monitoring, User Tracing, Troubleshooting and resolving Security issues
• Involved in Assigning Roles, User creation, Password resetting, locking & unlock the user in Production and Non-Production Systems.

Confidential

SAP BASIS Consultant

Environment: ECC, PI, BI, SCM, SLD, NLS, GRC, LiveCache, Oracle, DB2, MaxDB, Windows Server, UNIX

Responsibilities:

• SAP systems Database migration performed using export and import method
• Cloned the existing SAP ABAP, Java stack systems to new servers using Backup recovery and export/import methods
• Installed fresh SAP systems on new hardware and migrated data from source system to target system using Homogeneous and Heterogeneous System Copy methods
• Performed end to end pre and post migration activities for all migration projects
• Installed and Configured SOLMAN 7.0
• Planned and implemented SAP Patch updates, OSS notes and upgrading Plug-Ins
• Performed the Database Backup and Restore activities for Oracle, DB2 and MaxDB
• Performed the MaxDB Patch upgrade from 7.8.09.05 to 7.9.07.09
• Adding Data Volumes in MaxDB Database
• Performed the MaxDB Database parameter changes
• Checking Status, Stop and Start of MaxDB Database using DBMCLI
• Effectively troubleshooting and resolving end-user production issues without breaching SLA.

Confidential

SAP BASIS Consultant

Environment: SAP ECC, XI, BW, SOLMAN, TDMS, DB2, MaxDB, AIX

Responsibilities:

• Performed system/DB refresh activity
• Configure & Assigning Operation Modes
• Spool Administration like Defining New printers and Troubleshooting
• Performed kernel upgrades.
• Background jobs scheduling and Monitoring
• Worked on CCMS alert monitoring setup and set threshold values for each monitoring object
• Analyzed the EWA reports and implemented the solutions for resolving the alerts
• Applied SAP NOTES and RTCCTOOL Patches every month based on EWA reports
• Performing Java Parameters changes using Configtool and visual admin tool
• Deploy and undeploy of .sda and .sca files using SDM
• Setup EWA on Solution manager
• Administration of XI Channels includes monitoring, Stop and Start using Runtime Work Bench
• Starting and shutting down all the servers (including Database, Central Instance & App servers) in the Landscape during the maintenance window
• SAP R/3 System Performance Monitoring & Fine tuning through Instance Profile parameters
• Worked on SAP security User and Role Administration
• Performed DB2 database version upgrade from 09.05.0004 to 09.07.0002
• Deployed the DB2 special builds provided by SAP
• Setting DB2 parameters according to SAP recommendations
• Expert in resolving the DB2 Log Over Heating issue
• DB2 administration of checking automatic storage space, DBA logs, Backup overview, Archive log backup using DBACOCKPIT
• Experienced in generating the DB2 log files using the SAP provided Tools for OSS message
• Adding Data Volumes in MaxDB Database
• Performed the MaxDB Database parameter changes
• Checking Status, Stop and Start of MaxDB Database using DBMCLI
• Prepared the weekly and Monthly reports

Confidential

SAP BASIS Consultant

Environment: SAP ECC, XI, BW, SOLMAN, Oracle, AIX

Responsibilities:

• Daily monitoring and troubleshooting of all SAP Systems and Database Level
• Defining jobs in DBA planner and checking the DBA Backup logs
• Monitoring the DB Health and extending the table spaces using BRTOOLS or SAPDBA Tools
• Monitoring O/S level for free system space and deleting core dumps
• Performed SAP R/3 and JAVA system restart and troubleshooting start and stop issues
• Performed profile parameters changes in DB and SAP level as per recommendation
• Performed J2ee admin, SDMUSER resetting, while applying the patches from JSPM and SDM
• Setup and tuning buffers, monitoring roll memory, Paging and External Memory
• Performed daily monitoring of SAP R/3 systems (System Wide Work Process Status, ABAP Short Dumps, Update Errors, Lock Entries, monitoring Active Users and system logs)
• Applied SNOTES and RTCCTOOL every month based on EWA reports
• Implement SAP Patches, SPAM/SAINT updates, OSS notes & upgrading Plug-Ins
• Providing support for applications on 24x7
• Conducted technical s & KT's and Process Documentation

Confidential

SAP BASIS Administrator

Environment: SAP 4.6C, Oracle 9i, Windows Server

Responsibilities:

• Provided the SAP BASIS support for Production and Non-Production systems
• Performed Batch Job Monitoring and Schedule
• Performed the Daily Health checks and prepared the daily Health check reports
• Performed the Kernel Upgrade
• User administration creating, deleting, locking, unlocking and password resetting of users
• SAP parameter changes in Default, Instance profiles
• Preparing Weekly and Monthly SAP and Database reports
• Authorization administration (Roles, Profile maintenance through PFCG)
• Extensively used User Information System(SUIM) to generate reports
• Troubleshooting user authorization issues using SU53 and ST01