SAP BASIS admin

Sandeep Kumar

SAP Basis and Hana Admin

Phone: +1-206-***-****

E-mail: *****************@*****.***

Professional Summary:

Over 12+ years of total IT experience as SAP Basis/NetWeaver Consultant and 4+ years of progressive SAP HANA implementation experience with core strength in all aspects of SAP systems, databases administration in implementation, production and upgrade phases of a project

Expert in SAP Implementation, BASIS support, SAP Upgrades, system refreshes and maintenance activities

Experienced in Production Support and Maintenance of database Systems in SAP ECC, SAP R/3 environment as a SAP BASIS consultant

SAP system administration: ECC, BI, BODS, PI/PO, EP, SCM, SRM, FIORI, Solution Manager and NWA

Worked on the Back up strategies, performance (storage and Instance), Cost optimization of SAP Systems on Azure platforms

Installed and configured the SAP Cloud Connector (version 2.11.0.3) to securely connect applications on SAP Cloud Platform with the on-premise systems

SAP SLT installation and setup. Data loads and replication from Source SAP Business Suite to HANA and non-HANA target databases using SLT

Experienced SAP HANA installation and Migrations using DMO option

Experienced on HANA planning, hardware sizing, builds strategies, High Availability setup, DR setup with HANA replication, Backup and Restore, Revision updates, performance monitoring and day-to-day support activities

Proficient in EHP Upgrades and Support pack upgrades on ABAP stack and Java stack

Performed Open Text 16.2 Installation and Onboarding SAP systems to use Open Text archiving

SAP BODS and Information Steward Planning, Installation, Configuration and Support

Performed BODS and Information Steward upgrade from 4.2 SP3 to 4.2 SP6, 4.2 SP7 and 4.2 SP8

Performed SAP BODS systems migration from on premise to Microsoft Azure VMs.

Installation and configuration of SAP PO 7.5 and export/import of ICO configurations to PO

Experienced in SAP Gateway Fiori system landscape and architecture, installation, configuration and the deployment of SAP Fiori Apps.

Configured SAP Cloud connector and integrated it with Fiori system

Experienced with BSI tax factory application includes install, update from 10 to 11c and support activities

Performed Hana Multinode installation and post configuration steps

Worked on HANA Cockpit installation and post configuration setup

Performed SAP HANA DB Backup Restore strategies, Fallback Snapshots, and Upgrade

Worked on S4 HANA Readiness check 2.0 assessment

Installed Central check system Abap Test cockpit (ATC) system for Custom code analysis part of the S4 Migration Analysis

Configure Note Assistant Tool(SNOTE) For Digitally Signed SAP Notes

Configured Hana System Replication Setup

Worked on SLT system installation and post configuration steps also worked on SDI configurations

Worked on Hana Maintenance and performance issues, Monitoring SAP HANA systems, CPU utilization, file system, disk space and analyze Top CPU users.

Implemented SNC Kerberos based Single Sign On 3.0 and SAML 2.0 configuration in ECC and Fiori Gateway systems

Performed BW system non-Unicode to Unicode conversion along with version upgrade

Experienced SAP HANA installation and Database Migration using DMO option

Performed all system refresh activities including source system database backup and restore on target system with the modified control file. Performed all post refresh activities.

Expertise in ECC, BW Homogeneous System Copies of Oracle, MSSQL & DB2

Performed SQL DB upgrades which includes SQL from 2012 to 2014SP2 and 2016 CU1.

Strategy Documents: Client Strategy, Backup and Recovery, Transport Strategy, AIX High Availability

Experienced in setting up Solution Manager for Solution Monitoring, Generating Product Keys, and Maintenance Optimizer, including the satellite systems by creating the system, RFCs, Logical Components, assigning the system to solution landscape and configured End to end root cause analysis

Implemented Solution Manager’s Change Request Management Functionality (ChaRM) and the Retrofit process. Configured Solution Manager availability monitoring for all the systems throughout the landscape and sending the email notifications

End to End Implementation of Solution manager 7.1 with E2E root cause analysis and monitoring EP Enterprise portal through Wily Introscope, Solution Manager Diagnostics (SMD) and Host Agent.

Configured auto email alerts and central system monitoring by using CCMS and Early watch alerts

Participated in Disaster Recovery exercises

Excellent knowledge on Databases (Oracle, MSSQL Server, DB2) and operating systems (UNIX, Windows, IBM AIX, I Series)

SAP BOBJ 4.2/4.1/4.0 and SAP BO 3.x Administration

Implemented PI 7.30 landscape which includes planning, sizing, installation, configuration, integration, changing the Master client, verifying the values in exchange Profile and making sure that it is pointing to the right integration server, performance tuning and monitoring and etc

Oracle Database/tablespace reorganization, compression, import and export

Performed the system copies on MSSQL server, using backup & restore and attaching & detaching the database methods

Experienced in TREX installation, Upgrading the TREX patch, Configuring ECC and Portal systems in TREX server, Creating and Re-Indexing the Indexes

Experienced in installing portal, maintaining system definitions with the backend systems, Knowledge on portal federation, single sign on (SSO) configurations and SSL configurations

Expert in SLD configuration. Creating the technical systems, business systems, creating the SLD specific RFCs in J2EE and in ABAP as well

Experienced in Kernel upgrades on Windows/UNIX/Linux

Working with OS team, Database and Network teams during the designing phase of a project

Performed Database upgrades which includes Oracle from 11g to 12c, Oracle patch set upgrades Hardware migrations from windows 2008 R2 cluster to 2012 cluster

Expert in Client Administration. Creating the client and done the various client copies which includes local & remote client copy and client export and troubleshooting the client copy issues

Have done the performance monitoring which includes monitoring the background jobs, work process overview, workload analysis, checking the table size, missing indexes, database growth and the file system available space, Checking the lock entries, failure updates and etc…

Participate in CAB meetings to discuss release scope and roadblocks if any

Oracle Database/tablespace reorganization, compression, import and export

Ensure ITIL processes and Client standard procedures are implemented, utilized and supported end to end

Educational Qualification: Bachelor’s Degree from J.N.T.U, India in April 2008.

Certifications: Certified in SAP Certified Technology Associate - SAP HANA 2.0

Professional Experience:

Roles & Responsibilities:

Client: OGE (Oklahoma City)

Duration: May 2019 to till now

Role: Sr Basis Admin

Roles & Responsibilities:

Implemented SNC Kerberos based Single Sign On 3.0 for ECC systems. Part of this, worked with ADFS team to have Active directory user ids and SPN Registration, Enabling SNC parameters, SPNEGO configuration, Adding SNC Canonical name to all SAP users using SNC1, worked with Desktop team for rolling out secure login client to all the End user workstations

Performed SAML SSO Configuration. Part of this worked closely with ADFS team on onboarding SAP Local provider metadata file in ADFS

Performed Application logs cleanup by deleting expired logs and reorganizing the BALDAT and BALHDR tables

HANA: Designed server architecture and performed sizing to define the hardware required for the BW Linux/HANA landscape

Have performed the ECC/BW HANA migrations for the entire landscapes

Responsible for BW HANA Migration from Oracle

Have successfully migrated ECC/BW landscapes to HANA Database

Implemented EWA and SAP Max attention recommendations for the HANA systems

Performed the new system builds on Linux/HANA platforms, working with the infrastructure team for sizing and architecture designs

Performed the HANA installations for both scale-up and scale-out environments

Designed and Implemented HANA High Availability, Disaster Recovery setup using the HANA replication

Setting up the HANA backups using file system and net backup options, testing the backups and restores

Setting up the database alerts from HANA studio and monitoring the alerts, resource utilization and DR replication status

HANA logging and tracing, Activating and analyzing the expensive SQL traces

HANA day-to-day operational support activities

Upgrading the HANA Database software using HANA Lifecycle Manager

Worked on creating HANA Fallback Snapshots and resetting them in 2.0 SP3

Worked on Hana System Replication configuration

Evaluated the option HANA Smart Data access (SDI) for the Real-time data replication from SAP ECC system to HANA DB

BODS Upgrade and OS Migration: planning and upgrade of BODS 4.0 SP8 to 4.0 SP11 which also includes the upgrade of Data Services, IPS, Information Steward. Used this opportunity to migration the application from Windows 2008 R2 to 2012 R2

S4 readiness check: Performed S4 Readiness check 2.0 and worked with SAP on S4 assessment

Installed NW 7.52 system and configured Central ATC (Abap Test Cockpit) for custom code analysis

Performed integration of ATC with ECC landscape, configured and scheduled run series in ATC system

Worked on Note Assistant Tool (SNOTE) configuration For Digitally Signed SAP Notes

PI 7.1 to PO 7.5 side by side upgrade: Installation and configuration of SAP PO 7.5 and export/import of ICO configurations to PO

Validating the Business and Technical systems, SLD, setting up CTS+, validation of Communication channels and the connectivity part

Database Migration (DMO): Migrated BW system database oracle to Hana using SUM DMO approach

Along with Database migration performed BW upgrade from 7.0 to 7.4 and also Non Unicode to Unicode conversion using SUM DMO

BSI 10 to 11 Upgrade: Performed BSI Tax Factory version Upgrade from 10 to 11c, updated Tax factory client and worked with HR team on the BSI dataset backup restores, Cyclic, Regulatory Bulletin updates and BSI Support issues

SLT: Performed SLT system installation and post configuration steps

Worked on SLT configurations like DMIS Installation, Creating RFC Connection and DB Connection between source and Target system

Experienced in SLT tables replication setup, apply transformation for custom tables using advance replication setup, monitoring and support issues

Worked on BPC support issues like EPM connectivity issues, EPM upgrade issues in end user machines

BPC reports performance issues, report refresh issues, Cache refreshes, Data load performance issues

Applying Patches (SPAM), Add-ons (SAINT), SAP Notes (SNOTE), SSO Configuration, SAP Host Agent Install & Upgrade, Job scheduling, Parameter changes, Operation mode settings, etc.

Scheduling BPC Dimensions backup using transaction UJBR to Backup BPC related Application Master data, meta data

Performed system refresh activities

Performed Production support activities like CAB meetings, Weekly status calls, monthly maintence activities,

Transport management, troubleshooting performance issues, assiting SAP users on the access issues, Printer issues, Cleaning up Application logs SLG1, Long running batch job issues

Configured Early watch alerts, Technical Monitoring setup for ECC, BW and Hana DB in Solman 7.2 SP8 system

Addressing client technical questions and concerns

Helping with the critical daily support activities when needed

Documentation of the activities and transitioning it to the client team

Solman: Solution Manager 7.2 install, Update to SPS10 for both ABAP and JAVA, Perform Mandatory System Configuration, Managed System configurations for SAP application, HANA and MaxDB databases, Technical System Monitoring, SLD setup, ADS setup, Setting up the custom monitoring templates, enabling Alert Notifications, EWA setup, CCLM setup

ADS setup on Solution Manager Java and setting up the ADS connectivity on all backend systems

HANA database upgrade from 2.0 SPS 03 revision 37 to 2.0 SPS04 revision 48

Troubleshooting HANA replication issues between Primary -> HA -> DR

SAP DR exercise planning and execution of DR activities

Upgraded BODS FROM 4.2 SP8 to SP9 and worked on BODS support activities

Rolled out SAP GUI 760 version to all SAP end user’s workstations successfully.

Worked on Kernel upgrade, Java patches update using JSPM

Worked on Printers setup and support issues

Client: Microsoft, Redmond

Duration: Sep 2015 to April 2019

Role: Senior SAP Basis Admin

Project : Run-Maintain Support and Enhancement

Operating System : Windows, Linux

ERP : ECC, BI, BODS, CRM, MDG,SCM,OER,OPEN TEXT & Solution Manager

Database : MS-SQL 2014/2016, Hana

Tools : Service Now, Tidal, Vertex

Roles & Responsibilities:

Performed OER systems upgrade from NW 7.1 to NW 7.4 using SUM 1.0 SP16

Part of preparation activities - downloaded the stack file, kernel, created CPM change requests, deployed SUM dependent notes and making sure all preparation steps have done successfully

Worked on Always-on concepts like adding DBs to availability groups, Synchronizing DBs, Suspending data movements in inactive and DR nodes during SQL upgrades

Experience in performing OS patches, DB, Kernel upgrades and implementation of required support packages.

Performed the System Refresh and post restore steps, configurations and making sure that all the steps have done successfully

Performed Open Text 16.2 Installation which includes Tomcat Installation on Archive Nodes and Content server nodes

OTDS Installation and Integrate OTDS with Archive server and Integrate Content server with OTDS

Install Directory service on Arch Center node, Install License for open text and SSL configuration for Open Text

Worked on Onboarding SAP systems to use Open Text archiving. Verifying the ILM Store setting in transaction SARA, Create User in OTDS (Open Text Directory Service) to be used in RFC

Created RFC from SAP system to point to Enterprise Library of Open text system

Created application (SID) on enterprise Library, assign permission to enterprise library volume in Content Server and Perform ILM Verification test from any archive server node

Installation of Data Services and Information Steward in standalone and distributed environments

Adding the job servers, creating the Local & Central Repositories, SMTP setup, granting the users access to the repositories

Setting up the data-stores for source and target systems

Installed Information Steward on top of Data services and integrated with Data Services

Setting up Connections and Creating Projects in Information Steward

Moving the objects to Central Repositories and deploying objects to the Local Repository

Upgraded BODS and Information steward from 4.2 SP3 to 4.2 SP6 and 4.2 SP7 and completed all post upgrade steps like upgrading Local/Central/Profiler repositories using repository Manager, replacing Conf files

Performed setting up a dedicated server for Designer client tool to access the repositories

Migrated BODS and Information steward systems from On Premise to Microsoft Azure VMs.

Expert in BODS and Information Steward Administration

Performed support pack upgrades and kernel upgrade

Trouble shooting SAP start and Stop issues and planning maintenance

Supporting all SAP deliveries as per SLA

Installed the HANA Database, Client, Studio using GUI and CLI

Performed SQL upgrade from SQL 2012 to SQL 2014 SP2 CU2 and 2016 CU1

Worked with ABAP and Functional teams for SPAU/SPDD corrections and for functional validation

Worked as L4 Escalation point of contact and handled the incidents

Performed BI systems refresh activities including the post refresh steps

Performance monitoring, fine tuning, load testing

Providing production support, customer issues and request resolutions

Administration of system transports and change control tool CPM

SAP HANA planning, sizing, implementation, installation, Upgrade and Migration

Performed SAP HANA system Backup, Restore and system BI/BPC system refreshes

SAP HANA SPS upgraded 10 to 12

Installed BW 731 on SAP HANA and integration with ECC

Managing SAP HANA License, Managing SAP HANA users and monitoring system.

Managing SAP HANA Cluster, Scale up and Scale out appliance, Database fine-tuning

Experienced in Implementing Backup and Recovery, System Copy, Upgrade of the SAP HANA database, Performance Tuning etc.

Experienced in administration and troubleshooting of SAP HANA database using SAP HANA studio and DBA Cockpit and Starting / Stopping of SAP HANA

Windows security patches and Azure maintenance activities

Solution Manager Support and Maintenance activities including Technical Monitoring, EWA, BPM and RCA.

Trouble shooting webservice, Vertex systems as well as upstream, downstream systems

Assisted functional folks during the implementation phase and addressed issues reported by them

Release and refresh activities including support and maintenance activities

Establishing connections between SAP and BIZTALK systems and troubleshooting Connectivity issues between SAP and BIZTALK applications

Troubleshooting IDOC hung issues in MS systems

Worked on MDG workflow issues, ADS and Gateway issues

Worked on Web service integration, connectivity issues and worked on Business function activations

Worked on Single sign on (SSO) configuration and SAML configurations

Expertise in Configuration of TRFC, trusted RFC, ALE/IDOC and HTTP RFC on various SAP servers and satellite server connection.

SCOT configuration, STMS, printer configurations and troubleshooting printers, troubleshooting spool servers & resolving printer issues.

Performed support pack upgrades and kernel upgrades during quarterly maintenance window

Created Documentation and provided KT to offshore team on Business objects support and migration activities

Troubleshooting SAP Basis problems and created customer messages in SAP Service marketplace

Upgraded BODS system from 4.2 SP6 to 4.2 SP8

Upgraded SAP Business objects Project and support landscape systems

Worked on BPC reporting support issues and EPM performance issues

Worked on BODS upgrade, support issues and maintenance activities

Client: ITT Corporation

Company: Cap Gemini, Hyderabad

Duration: Sep 2014 to Aug 2015

Role: SAP Basis Admin

Operating System : Windows, IBM I series OS400

ERP : ECC, BI, Solman

Database : MS-SQL, Sybase, DB4

Roles & Responsibilities:

Performed Support package stack installation from SP-5 to SP-14 using SUM 1.0 SP12 tool in ECC 6.0 EHP 6

Installed Solution Manager 7.1 and did the configurations which includes creating systems, RFCS, logical components for satellite systems, creating projects, uploading blue print documents in solman system, MOPZ settings, Downloading the stack

Configured Solution Manager availability monitoring for all the systems throughout the landscape and sending the email notifications

Experienced in configuring the CCMS for both ABAP and JAVA satellite systems in Solution Manager for global monitoring and configured the systems in DBA cockpit.

Performed Kernel upgrades for ABAP stacks

Configured SSL setup, staging the ICM parameters and applying SSL certificate

Configured Early watch alerts in Solution Manager system

Router and SAP OSS maintenance including maintaining system data, request license

BW transports, Source system creation for sap and monitoring the data loads during the data extractions coming from the backend systems

Creating & deleting Clients, performing Client Exports/Imports and local Client copies

Monitor overall production systems performance and raise alarms to avoid production downtime

Performed Sybase database tables extension using alter commands

Performed Sybase master passwords recovery (SA,SAPSA and SAPSSO)

Documenting all the major activities including installations, Upgrading and configurations for future reference.

Worked on IBM I series OS400 environment and did Kernel upgrades, system refresh activities

Performed Sybase database tables extension using alter commands

Performed Sybase master passwords recovery (SA,SAPSA and SAPSSO)

Documenting all the major activities including installations, Upgrading and configurations for future reference.

Client: Johnson and Johnson

Company: LNT Infotech

Duration: Feb 2012 – Sep 2014

Role: SAP Basis Admin

Location: Bengaluru, INDIA

Operating System : HP-Unix, Linux

ERP : SAP R/3, ECC, BI, PI,EP, SCM,Solman

Database : Oracle 10/11g

Johnson & Johnson is an American multinational medical device, pharmaceutical and consumer packaged goods manufacturer founded in 1886.Johnson & Johnson is headquartered in New Brunswick, New Jersey, the consumer division being located in Skillman, New Jersey

Roles & Responsibilities:

Planning & Analysis phase for EHP upgrade from ECC 6.0 Ehp4 to Ehp5

PI Integration with backend ECC systems, registering the queues, proxy setup, SXMB_ADM, configurations and etc.

Support Pack and patch updates to NetWeaver J2EE Engine using JSPM

Installation & configuration of Host Agent & Solution Manager Diagnostics

SAP Solution Tools upgrade for better extraction of monitoring data from satellite systems to SAP Solution Manager.

SDCCN administration and Early Watch Alert (EWA) generation to get alerts into e-mail for problem solving and problem analysis

Performed system refreshes in ECC, BI and SCM systems.

Live Cache Administration like start, stopping, monitoring, Restore & Recovery of database

Configuring Outbound mail (SMTP) and troubleshooting using SCOT/SOST

Worked on SAP Web AS Java with various tools like Config tool, visual admin tool, SDM, JSPM

Perform Language installation by providing supplementation language

Refreshing XI cache memory and performing XI transports

Good knowledge on Database architecture, adding data files using BRTOOLS, scheduling database calendar, monitoring database buffers, monitor Database locks

Performing Transports on daily basis using STMS and CHARM

Performed SLD configuration. Creating the technical systems, business systems, creating the SLD specific RFCs in J2EE and in ABAP as well

Printer’s administration, registering print queues at OS level, creating printers at SAP and troubleshooting printer issues.

Maintaining saprouttab entries in router and doing maintenance of router on monthly basis

Performed import of XI transports. tpz files

Performing IDOC archiving in ECC system using tx code SARA on monthly basis

Performed detaching and attaching application servers as part of maintenance activity

Performing Transports in EP systems. Importing ear, sda, par, and epa files by using Archive Uploader, SDM into the Portal System

Performing Client copies (Local, client export and Remote Client Copy) and client deletion using Parallel Processing

PI Integration with backend ECC systems, registering the queues, proxy setup, SXMB_ADM, configurations and etc.

Installed BI and configuration of Bex-Web by integrating with portal & SSO-configuration

Oracle database upgrade from 9i to 10g.

Oracle patch installation using OPATCH & MOPATCH

Configured Early watch alerts in Solution Manager system

Router and SAP OSS maintenance including maintaining system data, request license

BW transports, Source system creation for sap and monitoring the data loads during the data extractions coming from the backend systems

Creating & deleting Clients, performing Client Exports/Imports and local Client copies

Worked on SAP Web AS Java with various tools like Config tool, visual admin tool, SDM, JSPM

Worked on SAP Data management SAP data archiving, Data aging, NLS, DART, OPEN TEXT Doculink, ILM

Client: Nordea Live and Pension, Denmark

Company: LNT Infotech

Duration: June 2011 – Jan 2012

Role: SAP Basis Admin

Location – Copenhagen, Denmark

Operating System : Windows

RP : ECC, BI & Solman 7.0

Database : Oracle

Nordea Liv & Pension provides life and pension insurance services. Nordea Liv & Pension was incorporated in 1991 and is based in Ballerup, Denmark.

Roles & Responsibilities:

Performed the System Refresh and System copy methods and post restore steps, configurations and making sure that all the steps have done successfully

Investigate, resolve the Oracle database problems and performed Opatch, Mopatch for oracle database, and Monitoring & health checks in oracle, OS/Linux & windows

SAP Database table space administration, monitoring table space,new table space creation, resize table space, extending table,new data file creation & reorganization & Implementation of Database Patches, database password management,update optimizer statistics

Monitoring all the Table spaces & Database Growth Day, weekly, monthly and yearly and prepare the KPI reports, Monitoring Archive logs and handling Archiving log OFF & ON using BRtools.

Client Administration. Creating the client and done the various client copies which includes local &remote client copy and client export and troubleshooting the client copy issues Changing the Profile Parameters for tuning the Performance of the System

Configured STMS domain controller, including the child systems in the domain, created transport layers for different objects, configured routes b/w the systems, configured target groups and automatic transports and performed the transports in quality & production systems

Installed Solution Manager and have done the configurations which includes Maintenance Optimizer, including the satellite systems by creating the system, RFCs, Logical Components and assigning the system to solution landscape

Configured Early watch alerts and in Solution Manager system

Performed stack upgrade in solution manager 7.0 from SP14 to SP27 using SPAM and JSPM

Adding new systems ip address in SAPROUTTAB file

Applying the correction instructions as per the SAP notes using SNOTE

Configuring the Logon Load Balancing

Checking .trc file in SAP trace directory for block corruption on daily basis

Working with UME, Jcmon, Visual administration and Config tool

Monitoring the landscape centrally using the solution manager system

Good knowledge on Database architecture, adding data files using BRTOOLS, scheduling database calendar, monitoring database buffers, monitor Database locks

Basic System Monitoring and perform System Management tasks

Monitor Fast growing tables and recommend Index/Table Reorganization

Have done the security activities including creating the users, roles, user groups, mass user creation, assigning roles to users, user comparison, role transport

Company: Zenith Soft

Role: SAP Basis Admin

Duration: Aug 2008 to May 2011

Location :Bangalore, INDIA

Operating System : HP-Unix

ERP : SAP R/3, BW

Database : Oracle

Tools : Remedy

Roles & Responsibilities:

Transportation between the landscape and from different landscapes.

Mass transports, Importing the Requests in R/3 and in OS level

Clearing the buffer, Copying the buffer

Applying the correction instructions as per the SAP notes using SNOTE

System Health Check and System Status Reporting

Spool Configuration and Administration

Monitoring SAP Background Jobs, ABAP dumps

Setting Operation modes

Enabling and disabling Archive log mode.

Adding data files to Table spaces

Checking that daily backup are executed without errors

Basic User Administration & Authorizations

Managing and Maintaining File Systems

Configuring and Managing Printer services, Mail configuration and Managing Printer services

Background Job management: Defined Background job, Monitoring the Background job Status and restarting the terminated jobs, Scheduled jobs to delete Old Background Jobs

Creating and Submission of Weekly Reports on System Performance, database growth.

Contact this candidate