SUMMARY:

• Over 9+ years of total IT experience as SAP Basis/NetWeaver Consultant 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, EP, SCM, SRM, SLD, Solution Manager, Wily Introscope and NWA
• Proficient in EHP Upgrades and Support pack upgrades on ABAP stack and Java stack
• Performed Hana installation and post configuration steps
• Installed and Upgraded the HANA Database, Client, Studio using GUI and CLI
• SAP HANA DB Backup and Recovery using Studio
• Performed HANA migration in CRM (SQL Database) system using DMO method.
• HANA security / User administration
• Monitoring and administration of SAP HANA Databases using Solution Manager and DBA cockpit
• SAP BODS 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.
• SAP BOBJ 4.1/4.0 and SAP BO 3.x Administration
• 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 SAP R/3, BW Homogeneous System Copies of Oracle, MSSQL & DB2
• Performed Database upgrades which includes Oracle from 10g to 11g , Oracle patch set upgrades Hardware migrations from windows 2008 R2 cluster to 2012 cluster
• 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 4.0/7.0/7.1 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
• End to End Implementation of Solution manager 7.1 with E2E root cause analysis and monitoring EP (Enterprise portal 7.0/7.01/7.3 ) 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
• Setup Technical Monitoring for SAP Products like ECC, CRM, PI, SLD, Web dispatcher, BW.
• Participated in Disaster Recovery exercises
• Excellent knowledge on Databases (Oracle, MSSQL Server, DB2) and operating systems (UNIX, Windows, IBM AIX, I Series)
• 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
• Performed SNC activation and installing CCMS agents
• 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
• 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…
• Ensure ITIL processes and Client standard procedures are implemented, utilized and supported end to end

TECHNICAL SKILLS:

ERP Applications: SAP R/3 4.7, SAP ERP 2004, SAP ERP 6.0 EHP6/7, SAP NW 7.3/7.4

Business Objects: SAP BO 4.1, SAP BO 4.0, BODS 4.2/4.1

SAP Modules: SAP BI 7.4, BW 3.5, SCM 7.0, CRM 7.0, MDM 7.1

Operating System: UNIX, LINUX, Windows, IBM - AIX, IBM I Series AS/400

Database : Oracle 12c/11g/10g/9i,SQL Server 2014/2012/2008 R2, DB2 V9/V8,Sybase15.7,HANA

IXOS : Open Text Archiving 9.6, 10.5

Tools : UC4, RedWood, Libbelle, CISM, ClearQuest, HPSM, Control-M

PROFESSIONAL EXPERIENCE:

Senior SAP Basis Consultant

Operating System : Windows

Database : MS-SQL 2014/2016

Tools : Service Now, Tidal, Vertex, Biztalk

Roles & Responsibilities:

• Handled the Business objects migration project as a technical lead
• Created Documentation and provided KT to offshore team on Business objects support and migration activities
• Installed SAP Business objects Project and support landscape systems
• Performed BW system upgrade from NW 7.3 to NW 7.4 using SUM 1.0 SP16
• Performed SQL upgrade from SQL 2012 to SQL 2014 SP2 CU2 and 2016 CU1
• Performed EHP upgrades for ECC and CRM systems
• Worked with ABAP and Functional teams for SPAU/SPDD corrections and for functional validations
• Performed ECC and BW systems refresh activities including the post refresh steps
• Performance monitoring, fine tuning, load testing
• Providing production support, customer issues and request resolutions
• Expert in Always on concepts like adding DBs to availability groups, Synchronizing DBs, Suspending data movements in inactive and DR nodes during SQL upgrades
• Performed Disaster Recovery exercise from primary to secondary data center
• Setup Technical Monitoring for SAP Products like ECC, CRM, PI, SLD, Web dispatcher, BW.
• Setup Technical Monitoring for SAP Partner products like BODS, BOBJ and CPS.
• Implemented PI 7.30 landscape which includes planning, sizing, installation, configuration, integration, performance tuning and monitoring
• Configured Central services registry on PI 7.30 and published web services from all the child systems
• Configured Advanced Adapter engine on PI 7.30
• Migration of old PI system components of ID and ESR to new PI
• PI configuration for SLD that includes registering the system in SLD, Data Supplier configuration, creating the business systems and mapping the BS for transports
• Setup SAP Early Watch Alert Report for all satellite systems
• Administration of system transports and change control
• Experience performing OS, 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
• Troubleshooting Connectivity issues between SAP and BIZTALK applications on IDOC data flow issues
• Good experience in 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.
• Installation of Data Services 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 upgrades during quarterly maintenance window
• Troubleshooting SAP Basis problems, applied SAP notes and created customer messages in SAP Service marketplace

SAP Basis Consultant

Operating System : Windows, Linux

ERP : ECC, CRM, BI, PI,EP, Solman

Database : MS-SQL, Sybase, Hana

Roles & Responsibilities:

• Installed and Upgraded the HANA Database, Client, Studio using GUI and CLI
• Stopping and starting Hana db using Hana studio and HDB CLI in standalone and distributed scenario
• SAP HANA DB Backup and Recovery using Studio
• Performed SLT configuration from Source to SLT to HANA system.
• Built migration landscape for all ECC systems using homogenous system copies
• Performed ECC 6 EhP7 SPS11 update and HANA 1.0 SPS11 migration using DMO (Suite on HANA)
• Installed and configured SAP HANA 1.0 SPS11 with BW standalone
• Upgraded HANA database using HANA Lifecycle manager. Performed HANA Components Patch upgrade
• Monitoring and administration of SAP HANA Databases using Solution Manager and DBA cockpit
• Configured Mail alerts in HANA for memory consumption
• Performance analysis and troubleshooting of SAP HANA systems
• Used SAP HANA Administration Tools - HANA Studio, DBA Cockpit, and HDBSQL CLI Tool
• Supported Scale-out HANA landscape
• SAP HANA Parameters Configuration Experience with SAP HANA data provisioning using SLT
• HANA security / User administration
• Performed Enterprise portal version upgrade from NETWEAVER 7.0 to 7.3 using SUM
• 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 the System Refresh and post restore steps, configurations and making sure that all the steps have done successfully
• Installed CRM 7.0 EHP1 and performed all the CRM specific post steps such as WEB IC configuration, Replication setup b/w ECC &CRM, registering the queues, web-ic SSO setup and transaction launcher setup
• Trouble shooting CRM WEB-IC issues, working with call center people to understand the issues and working towards fixing the issue
• Performed post Installation Setup of SAP Components: Initial System Backup, Configure SAPs Transport Management System, Request / Set-up SAP Developer Keys, Setup SAPROUTER connection to SAP, Install support packages, Client Copy, Install OSS notes, Configure SAP Note Assistant, Tuning / Modification of SAP and instance parameter files, Configuration of the SAPLOGON entries for the newly installed system, and setup of printers
• Performed Kernel upgrades for ABAP stacks
• SSO setup on SAP Portal by creating iView’s to all the backend systems and rolled out SSO to all the project people
• PI configuration for SLD that includes registering the system in SLD, Data Supplier configuration, creating the business systems and mapping the BS for transports
• 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
• Worked on SAP Web AS Java with various tools like Config tool, visual admin tool, SDM, JSPM
• 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.

Confidential

SAP Basis Support Analyst

Operating System : HP-Unix, Linux

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

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
• Printers 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

Confidential

SAP Basis Support Analyst

Operating System : HP-Unix

RP : ECC, BI & Solman 7.0

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
• 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

Confidential

SAP Basis Consultant

Operating System : HP-Unix

ERP : SAP R/3, BW

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.