Abhishek Panwar
SAP Consultant
Bangalore,India
Summary
Self-sufficient SAP Basis Consultant with over 6.5 years deftly handling SAP and third party products for multi-scale customers. Manages all phases of product lifecycles, from initial installation, through patching and maintenance to end-of-life measures. Provides hands-on technical support and works effectively with other teams to resolve the cross- functional issues. Eager to learn new skills and contribute to team success through smart work, excellent organizational and communication skills to guarantee flawless operations and customer satisfaction.
Overview
6
6
years of professional experience
4
4
years of post-secondary education
6
6
Certifications
Work History
SAP Basis Administrator
Deloitte
Bangalore, Karnataka
04.2021 - Current
- Built and configured multiple SAP systems (S4, Gateway, EWM, PO and MII) according to the client requirement.
- Performed multiple system copy for ABAP and Java (export-import) systems (Linux and Windows platform).
- Deployed third party java components using telnet
- Installed kernel upgrades per technical documentation guidelines, adhering to SAP's best practices.
- Maintained java system parameter using the configtool, according to the client's need.
- Integrated third-party software into SAP-based solutions and installations, verifying compatibility and interoperability.
- Coordinated with third-party vendors for addons compatibility, availability for the upgrade.
- Prepared the upgrade stack, strategy and the cutover plan for the upgrade.
- Built SI checks framework, ran checks, and remediated the issues by coordinating with other teams.
- Optimized the SDMI migration (during and post upgrade run) by coordinating with SAP.
- Lead and completed S/4HANA upgrade cutover (Go-live) from 1809 to 2021 successfully, within the client's stipulated time window.
- Upgraded SAP Gateway (from FIORI for S4HANA 1809 to 2021) and SAP MII (version 15.1 to 15.4).
- Setup STMS for retrofit and ChaRM.
- Troubleshooted ChaRM, retrofit and transport request issues.
- Performed HA-DR testing for SIOS cluster in Linux.
- Setup and configured StreamServe printer.
- Strategized and put together the standalone to embedded gateway migration options, and roadmap.
- Performed standalone to embedded gateway migration.
- Activated BC set and BF for new addons, and functionality according to the client's need.
- Configured Fiori (rapid content activation, ICF and OData services activation, alias creation and mapping, etc.), also setup ESH (Enterprise Search).
- Troubleshot Fiori launchpad and apps. related issues.
- Setup SSO, OAUTH and SAML2 for gateway systems.
- Created VM instance in Azure and set it up according to the client's demand (AAD, NSG, LB, Policy, AZ(s), HA, Storage, etc.).
- Setup cloud connector and configured system connection(s) in CC and BTP.
- Performed OpenText xECM and ADA upgrade.
- Setup and configured integrated and standalone web-dispatcher setup, and also troubleshot the issues.
- Performed S4 HANA 2021 beta upgrade, and post-upgrade SDMI migration manually.
- Provided the solution methodology to minimize the downtime for single and mass customer migration from on-premises to hyperscalers (Azure, AWS and GCP).
- Performed the payroll system(s) migration (lift and shift) POC, put together the final cutover plan and step-by-step cookbook for on-premise to hyperscaler migration.
- Coordinated with teams for ports opening, network issues, and VPN setup between the on-premises and CSP (Azure and GCP) DC.
- Aided in setup of IBM Aspera tool to transfer the data to the Azure storage.
- Created VM instances on Azure and provisioned SAP systems on it.
- Created the recovery template and performed MaxDB Backup-Restore.
- Troubleshot MaxDB issues
- Setup replicated for MaxDB using DB copy with synchronous log shipping and automatic log backup import at the standby node
SAP Basis Consultant
Wipro
Bangalore, Karnataka
06.2016 - 04.2021
- Aided in problem resolution tasks via in-person and on-call availability, maintaining resolution rate of 100%
- Installed kernel upgrades, implemented SAP OSS notes as per technical documentation guidelines, adhering to SAP's best practices
- Planned and implemented Technical (EhP6 (initial shipment) to EhP8 SP12) SAP system upgrade including SPAU and SPDD adjustments, which fixed many ongoing issues and introduced new functionalities for some SAP areas
- Calculated the resources and space requirement, and built an SAP NetWeaver system (ECC) from the backup of an existing system with the minimum resources possible
- Analyzed the HANA OOM issues and troubleshot the issues by finding the root cause
- Configured SLD, Business Process Monitoring and other mandatory configurations in Solution Manager
- Performed HANA DB and MaxDB installations, upgrades and patching
- Troubleshot various HANA DB issues related to expensive statements, threads, high memory usage by the HANA services and rapid DB growth
- Defragmented the HANA DB data and log volume, and did the regular housekeeping to avoid running out of space on the server
- Coordinated with function teams and integrated third party tools like Winshuttle, Informatica, GL Wand and Concur with ECC system
- Performed homogenous system copies and rename using SWPM
- Setup HANA system replication and tested the failover and takeover
- Created HANA DB triggers for standard SAP tables
- Installed and configured Precalculation server for SAP BW systems
- Installed, upgraded and configured SAP content server
- Performed HANA DB and MaxDB database backup and recovery
- Aided functional and infra teams in resolving cross-functional issues
- Analyzed the system dumps and runtime traces to resolve the issues affecting the system performance, to keep the system in it's best possible state
- Created HANA DB users, custom roles and provisioned them according to SAP practice
- Administered and managed HANA DB, MaxDB and SQL Anywhere DB through various tools and command line
- Troubleshot various issues like, dead locks, memory allocation failure, printer problems, connectivity issues, performance issues, object locking, OpenText issues, IDoc issues etc.
- Created MaxDB backup template and scheduled backups, and also troubleshot on log area and disk full issues
- Applied log backups to the MaxDB on the DR server using command line and MaxDB Studio
- Troubleshot MaxDB upgrade and post upgrade issues related to the DB Admin user and tables loading while starting the DB and ODBC error while accessing the DB in SQL mode
- Created new repositories in MaxDB through MaxDB Studio and SQL interface, and configured the same in SAP system
- Administered the MaxDB using Studio and command line, added disk and log volumes if required, monitored the sessions, blocked transactions, backups and adjusted the MaxDB parameters
Education
B Tech. - Electrical, Electronics And Communications Engineering
Graphic Era University
Uttarakhand, India 05.2012 - 05.2016
Skills
SAP ERP
SAP S4HANA
SAP Netweaver AS ABAP and Java
SAP HANA
SAP Implementation
Servers Expertise (AIX Linux/Unix and Windows)
Database Management (HANA, MaxDb and SQL)
Azure Administrator
Accomplishments
- Collaborated with SAP and successfully executed the EhP upgrade, which brought in a lot of new functionalities and also helped in fixing a lot of ongoing persistent issues, meeting the client's expectations
- Provided the optimal solution methodology, cutover plan, and also performed a POC for on-premise to hyperscaler system migration, which only required less than 4 hours of business downtime as per the client's requirement, which was then used for mass migration of all the client's payroll systems to hyperscalers (Azure, GCP and AWS).
- Supervised team of 6 members, lead, planned and executed the S4HANA, SAP Gateway and SAP MII upgrade for a client landscape according to client's requirements successfully, which was then used as a reference to upgrade all the other client landscapes.
Certification
Microsoft Certified: Azure Administrator Associate
Timeline
Microsoft Certified: Azure Administrator Associate
09-2022
Microsoft Certified: Azure Fundamentals
08-2022
SAP Certified Technology Specialist - SAP S/4HANA Conversion and SAP System Upgrade 2022
08-2022
SAP Certified Technology Associate - OS/DB Migration for SAP NetWeaver 7.52
07-2022
SAP Basis Administrator
Deloitte
04.2021 - Current
SAP Certified Technology Specialist - SAP S/4HANA Conversion and SAP System Upgrade 2019
11-2019
SAP Certified Technology Associate - SAP HANA 2.0 (SP03)
08-2019
SAP Basis Consultant
Wipro
06.2016 - 04.2021
B Tech. - Electrical, Electronics And Communications Engineering
Graphic Era University
05.2012 - 05.2016