Swapnil SAP

  • Senior SAP Basis/HANA Administrator
  • Glendale, CA
  • Member Since May 10, 2023

Candidates About

 

Swapnil

Senior SAP Basis/HANA Administrator

PROFESSIONAL SUMMARY:

Ø  Overall 8+ years of experience as a SAP Basis consultant with hands on R/3, ERP, BOBJ,SCM,SRM,MDM,Net Weaver, implementation, upgrade system enhancements, OSDB Migrations, systems refresh and production support responsibilities on HANA,DB2,Oracle, Oracle11g RAC,Sybase, Max-DB and MS-SQL server databases.

Ø  Experience in Installing the ECC 6.0,NW 7.0, NW 7.1,7.3,7.4,BOBJ 4.1, ECC 5.0,SCM 7.0, 7.1 and 7.3 with Live Cache on Windows 2003,2008, AIX 5.1, 6.0,Suse Linux 11.0 SP1 and HP-UX platform.

Ø  Experience on installing HANA DB on production landscape and SPS upgrades SPS06,SPS08,SPS09 and SPS10

Ø  Performed EHP1, EHP2, EHP4, EHP5, EHP6 and EHP7 upgrades in ECC, SCM and Net weaver (BW7.3, XI, EP) environment.

Ø  Working experience on BW 7.3, EP 7.0, 7.1, 7.3& 7.4, SCM,PI 7.3 &7.4,CRM – TREX. integration  and  Business Objects 4.0&4.1.

Ø  Migration progress on  ECC systems using DMO option also HANA TDI included

Ø  Installed Solution Manager 7.1 and performed the basic configuration (LMDB, managed systems configuration, work center configuration,EEM setup)

Ø  Installed and configured BOBJ  4.1 on Sybase and oracle

Ø  Worked with Support IT management, business analysts, application developers, architecture team, and infrastructure teams with technical consultation and support.

Ø  Having experience and  knowledge on TDMS

Ø  SAP fiory  installation and SAPUI5 add on installation on ECC EHP6 systems

Ø  Worked on OS DB and Hardware Migration projects in all SAP components (ECC, EP, XI, CRM, TREX, BW/BI and Content server) on Oracle, Sybase, Max-DB, MS-SQL 2008 and DB2 database

Ø  Performed Unicode migration for SCM systems (SCM 4.1 to SCM 7.1)

Ø  Performed SPS upgrades for ECC,PI,CRM,HR,SRM and SCM systems using latest SUM tool

Ø  JVM4.1 updated replacement of JDK using JVM SWITCHTOOL

Ø  Configured SSO in portal systems

Ø  Knowledge on SAP Charm

Ø  Worked on SAP distribution model

Ø  Knowledge of SAP WebDynpro ABAP/Java applications integration with SAP Portal.

Ø  Having experience and knowledge on TDMS

Ø  CCMS monitoring setup for ECC landscape and proposed monitoring threshold values in site scope

Ø  Good Knowledge in  DB2,HANA, Oracle 11g RAC,12c, MS-SQL 2005,MS-SQL 2008,SYBASE and Max-DB Administration

Ø  Knowledge of SAP NetWeaver Portal 7.3 and new releases and ability to monitor system performance, memory consumption, Java threading and monitor end user experience on various Operating Systems.

Ø  Worked on HANA Database administration as well as Performance, memory tuning and trouble shooting

Ø  Worked on converged CS900 and CS500 systems

Ø  Performed HANA systems sync and async replication on CS900 and CS500 systems

Ø  Performed DAS checks on customer checks to validate all installed packages on SAP HANA systems

Ø  Worked on HA clustering and SG for SAP configuration

Ø  Performed BW PRD to BW QAS refresh on HANA database using backup and recovery method

Ø  Performed HLM patches for HANA systems in Production systems landscape

Ø  Performed HANA system refresh from PROD to QA system using the backup and restore method

Ø  Worked on SLT tool

Ø  Installed SAP Fiory add-on on ECC 6.0 EHP6

Ø  Embodied  model fiory implementation on ECC 6.0 and EHP6

Ø  Knowledge on SAP HANA modeling

Ø  Knowledge on BO reporting on top of SAP HANA

Ø  Knowledge on Performed HANA LIVE  security setup

Ø  Knowledge on SAP HANA security

Ø  Installed and configured Vertex systems and updating patches on monthly basis

Ø  Installed and configured new SAP GTS server on NW ABAP system.

Ø  Worked on SOX Compliance and security audit.

Ø  Worked on IBM OS monitoring tools NSM, TNG and Ganglia

Ø  Extensive Production support experience in ECC, NW 7.0, 7.1, 7.3 and 7.4, XI/PI, BI, SRM, CRM, SCM, Content Server, MDM,TREX,BOBJ 4.0, 4.2 and SAP GTS

Ø  Extensive production support experience in Oracle10g,11g& 11g RAC, 12c, DB2 v9.5, v9.7, 10.1, MS-SQL Server 2005, 2008, Max-DB 7.5, 7.6, 7.7 and Sybase

Ø  Expertise in applying Support Packs, Add-on’s, Kernel Upgrade and OSS Notes

Ø  Client Administration including– Local, Client Export and Import

Ø  Thorough experience in File system handling/Disk space Problems

Ø  Performed online table re-organization large growth tables weekly basis on oracle database

Ø  DB2 Administration of Checking space, table growth, backup logs  and parameter tuning from OS level as well as using  DBACOCKPIT

Ø  Worked on Oracle, DB2, MS-SQL server 2005, 2008  system copies  using backup and restore methods for ABAP and Java systems

Ø  Having excellent problem-solving and critical-thinking skills.

Ø  Performed Oracle,DB2 and Max-DB version upgrades and patch updates

Ø  Involved in Security Auditing (Internal and External) with Auditors

Ø  Worked on Config tool, Visual admin,NWA,EHPI installer,SWPMand SUM tools

Ø  Worked with Audit teams Resolved security issues and provided best practices for the security related policies and procedures for the applications

Ø  Performed Basis activities in Solution Manager 7.0/7.1and Reporting EWA on scheduled time frames

Ø  Responded to end-user requests according to Service Level Agreements (SLAs) and enforced Security practices and procedures consistently

Ø  Good Knowledge on BW Administration

 

 

Technical Skills:

 

OS                   :AIX, HP-UX, Linux, Windows Server 2003

ERP                 : SAP R/3 4.7EE, ECC 5.0, ECC 6.0,NW 2004s,NW 7.0,7.3-BI/BW , NW 7.1-PI,SCM,SRM,MDM

Database          :Oracle 10g,11g, DB2 v9.7,v10.1, MS-SQL 2005, Max-DB, HANA SPS08,SPS09&SPS10, Sybase

GUI                  :SAP GUI 620, 640, 710,720,740

Ticketing Tool  :HP-Open View, Remedy, solution manager, SNOW

Tools               :Putty, WinSCP, XManager,Xming, NSM,TNG,site scope

 

 

Professional Experience:

 

Nestle, Glendale, California                                                          January 2014 to Till Date

Role: Senior SAP Basis/HANA Administrator

Project: Implementation, Migration and Production Support

 

Roles and Responsibilities:

·         Day to day monitoring and troubleshooting  of all SAP Servers (ECC, BI, EP,PI and BO) logs and proactively fix error conditions in SAP and HANA , Oracle Database Level

·         Distribute, manage and monitor workload of the SAP landscape.

·         Maintain SAP performance by planning and executing SAP tuning activities

  • Effectively doing Oracle Database proactive monitoring analyzed log area and indexes Log size and proposed parameters in DB level.

·         Effectively trouble shooting the high memory growth tables as well as high database response time tables in all systems and proposed for online table re-organization in weekly basis.

·         Performed SAP migration for all production landscape systems on HP-UX and Oracle to new Oracle RAC cluster on HP-UX

·         Planning and implementation of SAP system upgrades

·         Performed SAP migration all production landscape Windows systems into new HA MS-SQL 2008, Windows 2008 cluster

·         Migrated SAP ECC, BW,CRM and SRM systems into Oracle RAC cluster

·         Migrated SCM and PI systems to two node Windows cluster

·         Performed ECC upgrade from EHP5 to  EHP7  using SUM tool

·         Performed BI upgrade from BI7.1 to BI 7.3 using SUM tool

·         Performed PI  upgrade from PI 7.1 to PI 7.3 using SUM tool

·         Performed SCM upgrade from SCM 4.1 to SCM 7.1 using SUM tool with Unicode conversion

·         Installed and configured new solution manager 7.1 and performed the basic configuration setup

·         Installed new portal system EP 7.4 and imported the source system java data to new system

·         Installed and configured new BOBJ system on Sybase and oracle databases

·         Performed end to end pre and post migration activities for all migration projects

·         Worked with Support IT management, business analysts, application developers, architecture team, and infrastructure teams with technical consultation and support.

·         Worked on CCMS alert monitoring setup and proposed threshold values for each monitoring object.

·         Analyzed weekly EWA reports and proposed solutions related Red and Yellow alerts

·         Installed new HANA Database on all Primary and standby systems in Production landscape and set the standard parameters in global.ini file

·         Enabled the Sync replication process and performed the HANA  replication on CS900 ECC PRD primary to CS900 ECC PRD standby

·         Enabled the Sync replication process and performed  HANA system replication on   CS900 Non PROD SAP primary to CS900 non PROD SAP standby

·         Performed HDB upgrade from SPS09 to SPS10

·         Worked  on SAP HANA ECC migration using DMO tool

·         Fiory implementation with NetWeaver gateway

·         Installed quorum server on windows operating system

·         Installed and Configured HP SG for SAP with HP vendor

·         Installed and configured HA clustering with HP vendor

·         Installed  and configured SAP GTS 9.0 on NW ABAP system

·         Performed system refresh BI Production to BI quality on HANA Database

 

Environment: SAP ECC 6.0 EHP7, PI 7.3, BOBJ 4.1 SP2, Solman 7.1, BI 7.3, CRM 7.1, SCM 7.1, SRM 7.1, Windows server 2008, BODS, Oracle 11g RAC, MS-SQL server 2008,HP-UX, Suse Linux SP12 and HANA1.0 SP08 & SP09

 

 

Los Angeles Community College District, Los Angeles, CA                           Nov 2011 to Jan 2014

Sr. SAP Basis Consultant

Project:Production Support, system refresh, DB upgrade,EHP version Upgradesand SPS upgrades

 

Roles and Responsibilities:

·         Day to day monitoring and troubleshooting of all SAP Servers in Production landscape

·         AS per Monthly EWA reports , effectively providing the solution on the alerts and moving the proposed solution changes to weekend maintenance window after CAB approval

·         DB2 administration of checking automatic storage space, DBA logs, Backup overview, Archive log backup using DBACOCKPIT

·         Trouble shooting the backup issues in TSM also fixing the problems in time.

·         Effectively doing DB2 Database proactive monitoring analyzed log area and indexes Log size and proposed parameters in DB level.

·         Updated JDK/JVM 4.1 in JAVA systems using JVM SWITCH TOOL

·         Performed ECC, EP and BW systems refresh from PRD to QAS.

·         Performed EHP4 to EHP5 upgrade for ECC systems usinglatest SUM tool

·         Performed Portal system upgrade from EP 7.1 to EP 7.3 using SUM tool

·         Performed solution manager upgrade from solman 7.0 to 7.1

·         Configured SAP charm for production client in solution manager 7.1

·         Worked on CCMS alert monitoring setup, analyzed all the all MTE nodes in Production system and proposed recommended threshold values for effective monitoring

·         Performed DB2 fix pack upgrade from v9.7 to 10.1

·         Involved in Assigning roles, User creation, password resetting, locking & unlock the user in production and non-production systems

·         Monitor the user Ticket queue for production issues relate to SAP security

·         Risk Analysis and Remediation (RAR) to resolve all security issues.

·         Work closely with the ETRM Team to insure proper SAP security and eliminate vulnerabilities

·         SAP OSS Connections to be maintained and activities in Service market place like generating SSCR Keys and posting Messages to SAP and coordinating with them.

·         Effectively resolving the printer, scanner and Fax related issues without breaching SLA’s

·         SAP system trouble shooting and problem resolution working in conjunction with the help desk and process teams using HP Open Service Center.

 

Environment: SAP ECC 6.0 EHP5, PI 7.3, Solution manager 7.1, BI 7.1, EP 7.1, BO 4.0, DB2 v9.7, DB2 10.1, AIX 6.0

 

 

HP Enterprise Private Ltd. – Bangalore, India                                                          May 2010 to  Sep 2011

Client: AUTOZONE

Role: Senior SAP Basis Administrator

Project: Migration and support

 

Roles and Responsibilities:

·         DEV and QAS systems migration successfully completed using parallel export and import method

·         PRD system migration successfully completed using parallel export and import method

·         Installed and configured new solman 7.0

·         Performed end to end pre and post migration activities

·         Worked on CCMS alert monitoring setup and proposed threshold values for each monitoring object.

·         Designed the proposed support plan for the customer 

·         Performed Vertex tax update  for Production systems landscape monthly basis

·         Given 24/7 support proactively until stabilized the all production systems

·         Updated CCMS threshold values in site scope and designed the alert monitors successfully.

·         Created MTE nodes for mail server SOST and SCOT from CCMS alert monitor setup

·         Analyzed weekly EWA reports and proposed solutions related Red and Yellow alerts

·         Applied RSECNOTES and RTCCTOOL every month based on EWA reports

·         Plan, co-ordinate and implement SAP Patches, SPAM/SAINT updates, OSS notes and upgrading Plug-In’s

·         Effectively troubleshooting and resolving end-user production issues without breaching SLA.

 

Environment: SAP ECC 6.0 EHP4, RHL 6.6 and DB2 v9.7, DB2 v10.1

 

 

                                                                                                                              July 2009 to May 2010

Client: HONDA AMS   

Role: SAP Basis Administrator

Project: Migration, Upgrade and Production support

 

Roles and Responsibilities:

·         Installed new R/3 system on new hardware and migrated data from source system to target system

·         Installed new SCM system in new hardware and migrated data from source system to target system and live cache restored from source to target database

·         Installed new BW system in new hardware and migrated data from source system to target system

·         Performed SAP version Upgrade from SAP R/3 4.6c to ECC EHP4

·         Performed SAP Version upgrade from APO 3.0 to SCM 7.0

·         Performed SAP version Upgradefrom BW 3.0 to BW 7.1

·         Performed Unicode migration for all systems(ECC,SCM and BW)

·<span style="font: