PROFESSIONAL SUMMARY:

• Over 10+ years of total IT experience as SAP Basis/NetWeaver Consultant and 3+ years as Hana administrator 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
• Performed Hana installation and post configuration steps
• SAP HANA DB Backup and Recovery using Studio
• SAP BW HANA SPS upgrade 7 to 8, 9 and HANA Client tool upgrade
• Migrated BW and BPC to Hana Database using DMO option in SUM Tool
• EHP upgrade of BW EHP 6 to 8 on HANA DB
• Monitoring SAP HANA systems, CPU utilization, file system, disk space and analyze Top CPU users.
• 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 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 Confidential 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 SP2 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…
• 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

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.0, 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 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:

Confidential, LA

Senior SAP Basis Consultant

Roles & Responsibilities:

• 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
• HANA Smart Data access (SDA) for the Real-time data replication from SAP ECC system to Cassandra database
• Upgrading the HANA Database software using HANA Lifecycle Manager
• Worked on BPC 10.1 support issues like EPM connectivity issues, EMP 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

Confidential, Redmond

Senior SAP Basis Consultant

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:

• SAP HANA planning, sizing, implementation, installation, Upgrade and Migration
• Performed Migration of BW and BPC 7.31 EHP 6 on SQL to HANA database.
• 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
• Migrated BW and BPC to Hana Database using DMO option in SUM Tool
• 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 weekly basis
• Have a good knowledge on S/4 HANA
• Release and refresh activities including support and maintenance activities
• 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
• 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
• Performed support pack upgrades and kernel upgrade
• Worked with different Third-party systems and Integrated to SAP
• 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
• Worked on Always-on concepts like adding DBs to availability groups, Synchronizing DBs, Suspending data movements in inactive and DR nodes during SQL upgrades
• Administration of system transports and change control tool CPM
• 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
• 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
• 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.
• 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
• 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
• Upgraded BODS system from 4.2 SP6 to 4.2 SP8
• Adding the job servers, creating the Local & Central Repositories, SMTP setup, granting the users access to the repositories
• Upgraded SAP Business objects Project and support landscape systems
• 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 Confidential Azure VMs.
• Expert in BODS and Information Steward Administration
• Worked on BPC reporting support issues and EPM performance issues

Confidential

SAP Basis Consultant

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.

Confidential

SAP Basis Support Analyst

Operating System: HP-Unix, Linux

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

Database: Oracle 10/11g

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

Confidential

SAP Basis Support Analyst

Operating System: Windows

RP: ECC, BI & Solman 7.0

Database: Oracle

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

Confidential

SAP Basis Consultant

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.