PROFESSIONAL SUMMARY:

• Technical professional with over 15 years of Information Technology experience.
• Over Six years of experience as a Sr. SAP HANA DBA and Seven years as SAP Basis NetWeaver in Manufacturing, Retail, Automation, Electrical, etc. demonstrated history of success in Implementation, support and SAP.
• Extensive Experience in SAP HANA Database Administration and support using Studio and Cockpit 2.0.
• Working knowledge on SAP HANA Database, Native HANA and apps running like SAP BW, ECC and Success factors LMS, BizX and WFA.
• SAP HANA Two full lifecycle and SAP Basis - Three full cycles SAP Implementations, Security, Upgrade, Migration and 24x7 Production / Project & Development Support.
• Planned, Design, Sized and implemented SAP HANA database version 1.0 - 2.0, & ERP.
• Lead SAP teams outsource and on site/ off Shore for day to day activities and daily reports.
• Managed global 5 teams as a Service Delivery manager for HANA support.
• Excellent communication, interpersonal and leadership skills, documentation and troubleshooting skills, flexible and ability to work in a fast-paced team environment.
• Strong analytical and monitoring skills in systems performance tuning, identify performance bottlenecks, workload analysis, and memory management.
• Expertise in root-cause-analysis, issues solving.
• Extensive experience in Installation, Upgrade, Configuration, Connectivity and post support.
• Ensure and automate daily full, differential and incremental backups, file and third-party backups.
• Troubleshooting availability and performance issues, restore and recover system to perfect working condition.
• Perform SAP HANA System Replication, Disaster Recovery drills, and bounce systems.
• Analyze Diagnosis files, Analyze and Configure Trace.
• Table distribution, Dynamic Tiering & Split large tables.
• Extensive experience in installation & configuration of SAP ECC 6.0, BI 7.01, EP 7.0.etc.
• Worked in various SAP Releases R/3, ECC6.0, BW, BI 7.0, PI 7.1, EP, PI, Solution manager 7.0 ehp1, NW 7.01/7.3.
• Extensive Experience in SAP System refresh, Support packages application Add-on’s, OSS, S-Notes, System Copy of Homogenous systems and performed Kernel upgrades on the SAP Systems.
• Extensive co-ordination experience with Functional and Technical SAP Development Teams
• Has worked on Operating Systems like Red Hat, AIX, Suse, Linux, Unix, HP-UX, Solaris and Windows NT / 2003/2008/2012 R2 server editions.
• Extensive Experience in with Daily Monitoring / Maintenance and Administration of SAP Systems.
• SAP Basis NetWeaver ECC, BW, BI, EP, PI ABAP/Java administration and support.
• Installation, upgrade, configuration Applied the software packages, installation and upgrading add-ons/bolt-ones, system refresh (both ABAP +JAVA engine), client refresh, data archiving, RFC connections, system refresh, client refresh and maintain connections to external databases, SAP web-dispatcher, J2EE stack administration using visual admin, config tool, SDM, JSPM, NWA, Logviewer, JCMON.Configured JCo connections to backend ECC systems. Enabling HTTP trace stacks trace, application trace. SLD, RFC configuration, Message archiving, performance tuning, dump analysis and resolution, NWA. Solution Manager Administration Installed, upgrade, configured solution manager 7.1 and 7.2 7.3, ChaRM, Early-watch alerts (EWA) set up, system monitoring, maintenance optimizer, DBA Cockpit.

TECHNICAL SKILLS:

SAP: SAP HANA 1.0 Rev 62 thru 122.13 & HANA 2.0 SPS0-SPS3 Rev-10,20,24,30,33 Oracle 9\10\11.

SAP HANA: SAP HANA Studio, SAP HANA Cockpit 1.0/2.0, DBA Cockpit, HDBLCM, HDBSQL, JDBC, ODBC, SAP Host Agent, HANA clients, etc.

Tools: Netweaver 04\2004s\7\7.3, SAP R/3 (4.6C,4.7E), ECC5\6, SAP CRM, SAP BW3.x\BI7, SRM, BPC, Business Objects XI 3.0\Platform 4, SCM, MDM5.5\7.1, BI Accelerator Appliance, HANA, Solution Manager, XI\PI 7.1\7.3, EP6\7\7.3, CLM, GTS, IDM, GRC, EWM, SNC, SLD, TREX.

Operating System: Windows NT/ 2000/2003/2008- R2/2012-R2, Unix, Linux, Solaris, SUSE Linux, Red Hat, AIX, Linux.

RDBMS: MS SQL Server 7.0/2000/2005/2008/2012, DB2.

PROFESSIONAL EXPERIENCE:

Confidential, Lombard, IL

Sr Consultant - SAP HANA Database Administrator / SAP Solution Architect / Service Delivery Manager

Responsibilities:

• Administered SAP HANA database Landscape consist of BW, ECC, Native HANA, BizX, LMS, WFA based applications, versions 1.0 rev-102.02 - 2.0 SPS 2 rev-20.
• Supported SAP HANA systems 24x7 and troubleshooted business critical issues.
• Monitored HANA Landscape using ManageX (ServiceNow) inhouse monitoring tool called “Alert Perl”.
• Strong knowledge of SAP HANA database architecture.
• Provided leadership to Confidential ’s SAP team and overall practice, in my capacity as a hands-on L3 resource & as a Service Delivery Manager.
• Coordinated support activities with On-shore, Off-shore teams as a L3 lead resource.
• Planned, sized and implemented SAP HANA database version 1.0 rev 92- 122.13. & version 2.0 SPS0, 1, 2 & 3, Revision 10, 20/24 and 30/33. Supported go live activities.
• Installed SAP HANA database in scale-up & scale-out environment for high availability, configured auto host failover HA.
• Managed high availability systems running in a Cluster environment using HP Service Guard.
• Configured and supported HANA System Replication in clustered environments like HP Service Guard auto failover.
• Installed DR site and configured SAP HANA System replication in a multi-tier environment.
• Performed failover and disaster recovery practice and bounced systems for DR testing.
• Performed DR unit testing exercise to test takeover from Primary SAP HANA site to DR Site in a multi-tier environment.
• Perform HANA health checks using SAP Mini-check and custom scripts, and automated tasks.
• Performed HANA upgrades for almost all revisions and provided post go-live s upport.
• Installed and configured SAP HANA Studio SAP HANA Cockpit 1.0/2.0. SAP Router, SAP hostagent and SAP HANA client etc.
• Configured SAP HANA landscape using HANA Studio, SAP HANA Cockpit 1.0/2.
• Added new host for scale-out and redistributed tables data between hosts.
• Designed, architected and customized SAP Hana database monitoring tool. Identified and added support for monitoring 50 KPI’s.
• Installed and configured custom monitoring tool to proactively monitor SAP HANA database using “Alert Perl” ( Confidential ’s inhouse tool for automated monitoring).
• Designed and architected SAP Hana statistics repository and reporting application within Confidential ’s ITSM tool.
• Managed ticketing tools like, Service Now (ManageX), SAP SF Service Now (SNOW), SPC, Jira, OSS, BCP, & Legacy tool InsightSD, Monitored SAP HANA Database 24/7.
• Created standard operational procedures and templates for HANA resolution steps.
• Create SOP’s to minimize downtime strategy in SAP System Replication.
• Installed SAP HANA support patches and implemented SAP Notes on HANA Database to fix the Index server issues.
• Analyzed HANA system for bugs using Bugzilla for bug tracker and testing, created OSS tickets.
• Designed and implemented Backup and recovery strategies. Created OS Script for daily backups, full file, incremental and differential and automatic log backup with 15 minutes intervals and perform housekeeping jobs.
• Configured SDA (Smart Data Access), configured connections between SAP HANA legacy system Databases, for Table replication and Data provisioning.
• Performed performance tuning activities at SAP HANA DB level and split big tables into several partitions as recommended by SAP using Hash, Range and Round-robin methodology.
• Installed, Configured and Supported Dynamic Tiering for HANA Landscape.
• Performed loading and offloading moved data/tables b/w hot/warm/cold storages.
• Configured SAP HANA Alerts, adjusted check thresholds and configured email functions.
• Analyzed SAP HANA Alerts, traces, logs and dumps to troubleshoot SAP HANA DB issues.
• Worked with Apps/OS/Infrastructure/Network teams to perform SAP HANA OS support activities.
• Applied corrections and SAP NOTES according to SAP Support suggestions.
• Performed workload analysis for HANA.
• SAP BASIS activities, Installation, upgrade, Patches, support, monitoring and performance tuning SAP Systems etc.

Environment: WFA, BizX, LMS Native HANA based HANA 1.x and 2.x, BOBJ, SUSE 11.4, 12.x, HANA Rev 102.02 - SAP HANA Platf.Ed.1.0 SPS12 DSP (SAP HANA DB 1.00.122.13 ), SAP HANA Platform Edition 2.0 SPS03 rev30- rev33 Linux x86 64.

Confidential, Lombard, IL.

Sr SAP Basis Administrator

Responsibilities:

• Administration and Support for SAP System landscape consists of ECC 6.0, BW 7.3, EP 7.3, ADS, Solution Manager 7.0, GRC 5.3 on Oracle 11.2.x.
• Responsible to manage company’s SAP team as a Service Delivery Manager.
• Mentor and Train Client’s SAP Basis team.
• Support SAP systems 24x7 for any critical Production issues.
• Managing overseas team for continue support.
• Manage and support SAP systems for all SAP Basis/Security related activities.

Environment: SAP ECC 6.0 EHP-5, Solution Manager 7.0, BW 7.3, EP 7.3 + ADS, GRC, SAP Netweaver7.x, Suse SLES 11.x 12.x, Red Hat Linux 6.x 7.x, Oracle 11.2.x.

Confidential, St Paul, MN

Sr SAP Basis/Net Weaver HANA Administrator

Responsibilities:

• Administration and Support for one of the largest and most complex SAP Implementation consisting of ECC, CRM, PI, FICO, AR, AP, SOL-MAN, MM, BW, EP, BOBJ, TM, FI & CO, AC, CLM, GTS, GRC, HCM, EWM, SCM, SNC, CLM, SLD, IDM, ARIBA and TREX. SAP HANA DB.
• Supported SAP systems 24x7 for any critical Production issues and managing overseas team for continue support.
• Managed ITSM queue for ticketing tool and distributed work to on & off Shore teams.
• Performed System Copies, homogeneous and heterogeneous migrations for various environments.
• Managed Systems running in a Cluster environment for high availability.
• Performed Failover and disaster recovery practice and bounced systems for 0 downtime strategy.
• Install configure SAP router, SAP WTS and R3 connections.
• Assisted in Setup and configure SAP Fiori.
• Planned, sized, and implemented Suite on HANA with hands on migration experience.
• Migration and upgrading SAP HANA on ERP and BW.
• Created project plan for existing SAP BW landscape for upgrade and migration to SAP HANA.
• Participated in hardware sizing activity for existing SAP BW system. Upgraded and migrated to SAP HANA SPS08 rev 83.
• Performed test upgrade of SAP BW and ERP test system (Prod copy) and migrated to SAP HANA using DMO option.
• Installed SAP HANA database in scale-out environment for high availability and configured auto host failover.
• Installed DR site and configured system replication between 2 sites (Primary and Secondary).
• Performed actual SAP upgrade for DEV, Consolidation, QA and Performance servers.
• Performed Production System upgrade of SAP BW NetWeaver 7.0 EHP3 on oracle to SAP BW NetWeaver 7.4 on SAP HANA SPS08 Database with DMO on IBM X6 hardware.
• Configured SAP HANA landscape in SAP Solution Manager and DBA Cockpit.
• Provided post upgrade and go live support for SAP BW on HANA landscape.
• Upgraded SAP HANA Client to Rev 85 on SAP BW Application Servers to solve some system dumps.
• Installed SAP HANA support patches and implemented SAP notes at SAP BW application and SAP HANA Database level to fix the issues which we were raised on daily basis.
• Configured SAP HANA Database with external backup tool (Symantec Net backup).
• Configured RFC Connection between SAP BW on HANA and SAP Business Object Data Service.
• Migrated SAP HANA Statistics server to Embedded Statistics Server (ESS).
• Upgrade SAP BW Application kernel to latest available PL.
• Performed performance tuning activities at SAP HANA DB level, split large tables into several partitions as recommended by SAP, moved load/off-load Tables between in-memory and disk as needed.
• Performed DR unit testing exercise to test takeover from Primary SAP BW on HANA site to DR Site.
• Analyzed SAP HANA traces, logs and dumps to troubleshoot SAP HANA DB issues.
• Worked with OS team to perform various activities on HANA System.
• Installed SAP SLT and configured it with SAP HANA Database.
• Installation and configuration of SAP BPC and Fiori (MRP Cockpit) on HANA environment.
• Assisted to Infrastructure team to Setup F5 Load balancer & Web Dispatcher, Setup Apache’s & reverses proxies over DMZ for load balancing for external portals.
• Assisted Moving SLD from local to central SLD in PI as well as other Sap systems. Resolving SLD related problems.
• Assisted in configuration and publish web services in PI. Importing XI content in PI systems. CTS+ configuration for PI systems.
• PI 7.3 Administration including installation, configuration, readiness checks, troubleshooting.
• PI SLD setups, IDOC monitoring, Java and ABAP Tuning, IR/ID imports.
• Maintenance of system landscape with SMSY and SLD configuration with bridge on PI 7.3.
• Daily Monitoring of ECC 6.0, BI 7.0 and CRM 7.0 on Production systems and Creation of daily checklist for monitoring the overall system activities.
• Upgrading Solution Manager 7.0 to EHP1 (SP-19), both ABAP and Java stack (using SDM/JSPM).
• Implementation of End to End root cause analysis with solution manager diagnostics and wily Introscope in solution manger EHP1.
• Solution manager implementation for EWA, SSO reports, Central system administration as per standard.
• Setup the Solution Manager System Monitoring, Solution Manager Service Desk, Charms, Business Process Monitoring.
• Patched SAP with latest Patch levels and Kernel upgrades.
• Administered and configured LDAP and SSO for Enterprise portal 7.0.
• Installation and configuration of BOBJ 4.0, Perform and Disclosure Management
• Involved in System Landscape Design and Client Instance Strategy
• Applied corrections and OSS NOTES according to EWA report suggestions.
• Connecting ABAP/J2EE systems to SLD, Troubleshooting SLD connection problems, UME configuration.
• Performed installation and technical administration, tuning, and monitoring of the SAP ECC application and supported the Development and functional teams.
• Workload analysis, BASIS activities, monitoring and performance tuning SAP Systems.

Environment: SAP ECC 6.0 EHP-6, Solution Manager 7.1, SRM 7.0 EHP 2, SCM 7.3, FI & CO, CRM 4.0, BW 7.4, PI 7.3, EP 7.3, FICO, AR, AP, CLM, EWM, TM, GTS, PLM, HCM, SCM, EM, GRC, GTS, SNC, SAP Netweaver.3, SUSE 10, Red Hat Linux 6, HANA SP-8, DB2, Oracle 11G.

Confidential, Madison, Wisconsin

SAP Basis/NetWeaver HANA Consultant

Responsibilities:

• Administration of SAP System (ECC, CRM, PI, SOL-MAN, BW, EP, BOBJ) on HP-UX 11.x and Oracle 11g
• Homogenous System Refreshes using Backup / Restore Method on ECC and BW systems.
• Oracle DBA Activities like Table Reorganization, SGA Tuning, and Table space Management, BRTOOLS activities.
• Planned, sized, and implemented Suite on HANA with hands on migration experience.
• Migration and upgrading SAP HANA on BW.
• Created project plan for existing SAP BW landscape for upgrade and migration to SAP HANA.
• Participated in hardware sizing activity for existing SAP BW system. Upgraded and migrated to SAP HANA SPS7.
• Performed Sandbox upgrade of SAP BW using test system (Prod copy) and migrated from Oracle 10g to SAP HANA using SWPM and SUM-DMO
• Administration and post support for SAP HANA related activities and resize tables for better performance.
• Patched SAP with latest Patch levels and Kernel upgrades.
• Administered and configured LDAP and SSO for Enterprise portal 7.0.
• Source System Connectivity between BW and ECC systems
• Installation and configuration of BOBJ 4.0, Perform and Disclosure Management
• Involved in System Landscape Design and Client Instance Strategy.
• Performed Client Administration activities (Client Copy Strategies and System Refreshes) including Client
• Creation, Local Client Copy (Within a system), Remote Client Copy (Across systems), Client Export & Import
• Applied corrections and OSS NOTES according to EWA report suggestions.
• Supported systems 24x7 for any critical issues and managing overseas team for continue support.
• Connecting ABAP/J2EE systems to SLD, Troubleshooting SLD connection problems, UME configuration.
• Performed installation and technical administration, tuning, and monitoring of the SAP ECC application and supported the functional teams.
• Configured SMTP, transport management system, support packs, spool administration, performance issues,
• Configuring printers, workload analysis and all day to day BASIS activities including monitoring and performance tuning.
• Configured STMS CTS+, Performed import of transport requests using (STMS), monitored transports and maintained transport logs and troubleshoot various TR related issues.
• Designed and created documents for the clients SAP ECC6.0 monitoring, implementation, supporting strategies.

Environment: SAP ECC 6.0, Solution Manager 7.3, CRM, SRM 7.0 EHP 2, SCM 7.3, CRM 4.0, BW 7.0, PI 7.1, EPP, SAP NetWeaver 7.4 Oracle 11.2.0.3, SUSE 10, Red Hat Linux 6

Confidential, Fort Lauderdale, FL

SAP Basis Administrator

Responsibilities:

• Administration of SAP Basis System (ECC, CRM, PI, SOL-MAN, BW, EP,) on HP-UX 11.x and Oracle 11g.
• SAP Basis Administration and support on Linux, Unix and Windows.
• Installation, upgrade and configure various SAP Sandbox environments.
• Install SAP instance on Virtual Machines.
• Performed EHP, kernel upgrade, applied support packs and SNOTEs.
• Responsible for logon load balancing.
• Created OSS message to SAP issues
• Setup of Maintenance Optimizer in Solution Manager 7.0 to facilitate downloads and distribution of patches.
• Setup and configure Solution Manager’s Change and Request Management (ChaRM) to control and distribute development and configuration changes throughout the system landscape.
• Configure Solution Manger to enable Central User Administration (CUA) for user and authorizations distribution across the landscape.
• Responsible for Transport Administration TMS, configuring STMS and Transport objects.
• Performed Clients Administration I.e. Local / Remote Import/Export Client Copy.
• Perform system Refresh and system copy for various requirements.
• Printer/Spool Admin. Using, SPAD & Spool Administration.
• Instance Profile Maintenance.
• Analysis of ABAP dump and corrective action.
• Monitoring of the System trace/logs and lock entries.
• Documented SAP administration standards, policies and procedures.
• System Maintenance Strategy.
• Posting System Messages.
• Administered and maintained of Lock Entries.
• Checked System Logs and failed Update Records.
• Analyzed and troubleshoot ABAP Short dumps.
• Performance tuning - Health checkup of SAP Systems.
• Configured/Created printers in SPAD.
• Responsible for Monitoring and Troubleshooting problems with printers.
• Created the documentation for the various tasks that were performed for daily monitoring and checklist
• Worked with Configtool and Visual Admin

Environment: NW 04S, ECC 6, BI 7.01, EP 6.0, CRM 7.0 Solution Manager 7.0 EHP1, SCM 7.0, Solution manager 7.0, NetWeaver components 7.0 (Enterprise portal EP, Business intelligence BI, Process integration PI), Oracle 9, 10g, Suse 11.

Confidential, Carol Stream, IL

System Administrator & Desktop Support

Responsibilities:

• System Administration and user support for NT 4.0 and Windows 2000 Network.
• Installation, upgrade, Configuration and maintained windows NT4.0/2000 Server & WS and connect to the network.
• Install, configure, Repair and upgrade various hardware platforms like blade-servers, servers, WS desktop Pc’s, Laptop’s, WS and various network devices.
• Performed Windows 2000 migration/deployment, Backup/restore install applications, app data.
• Install, configure, Repair and upgrade various hardware platforms like blade-servers, servers, WS desktop Pc’s, Laptop’s, WS and various network devices.