Jayan Gorla SAP BASIS and HANA Administrator
********@*****.***
Professional Summary:
12+ years of experience as a SAP BASIS/Net Weaver Systems Administrator
Experience in various SAP implementations, designing the architecture and building the SAP landscapes
Hands on experience in installation, configuration, upgrade, migration and support of ERP applications SAP R/3 4.6C, 4.7 EE, ECC 5.0/6.0, Enterprise Portal, Netweaver2004/2004s, Solution Manager 4.0/7.0/7.1, BI/BW, XI/PI, GRC.SRM, CRM, SCM MDM, GTSAPO,HPQC, Every angle, CLM
Performed very complex Data Centre Migrations
Worked in discrete Energy, Pharmaceuticals. Chemical, retail sector, electronics, mining, Servicing and Manufacturing industries
Extensive working experience on SAP ECC 6.0 EHP7, Net weaver (BW 7.3/7.4, Portal 7.1, PI 7.1),SAP BOBJ (BI) 4.2, CRM, GTS11.0, GRC 5.3 modules and OS platforms: Solaris 11, AIX 7.1, HP-UNIX, Windows and Databases: Oracle, SQL Server
Worked in the full project lifecycle of SAP implementations which included the following modules - FI/CO, MM, SD, WM, PM, PP HR and QM modules, BW, BOBJ, PI, Portal CRM .SRM APO.MDM.AII, E-recruiting,E-Learning
Has Performed Installations of SAP Net Weaver 7.1 (ECC 6.0, WEBAS ABAP, JAVA, SAP Portal 7.1, SAP BW 7.3, PI 7.1) on UNIX and NT environments
Performed System copies and system refreshes of SAP Net Weaver 7.x (ECC 6.0, WEBAS 700, Enterprise Portal 7.1, SAP BW 7.3, PI 7.1 Installations)
Experienced in performing Enhancement pack upgrade using SUM tool
Experienced in Migrations on ECC, CRM, BW systems
Exposure to working with Solution Manager 7.1 Work Centers, Maintenance optimizer,
Managed System setup, LMDB, Technical Monitoring
Experienced in SAP BOBI 4.1 and Data Services 4.0 Installation administration and support
Experienced in Supporting PLM 701, TREX 7.1, Content Server and Seal Systems
Proficient in using SAP Computer Center Management System (CCMS), Change and Transport System (CTS), SAPGUI, Profile and Authorization Administration, Brbackup/Brarchive
Knowledge on SAP HANA and S4 administration activities
HANA Studio setup, HANA, HANA Backup and Recovery, Performance monitoring
Knowledge on BW 7.3 on Oracle 11 to BW 7.4 on HANA migration with DMO (Database Migration option of SUM)
Pro-active monitoring, trouble-shooting and tuning of the systems at the SAP and database and Operating System levels
Strong interpersonal skills with verbal and written communications maintaining a high level of working relationship with all levels of personnel.
Experience in SAP J2EE administration (VA, Config Tool and SDM)
Hands on experience on SAP Portal Security and Basis.
Experience on SAP Security and CUA (Central User Administration) Configuration
Experienced in handling large & complex SAP production environment & work involves 24*7 system support and monitoring systems.
Technical Environments:
SAPComponents: ECC,EPSRMSCM,GRC,PI,BI,CRM,MDM,EP,BI.,SM,TREX.HANA
Databases: Oracle, SQL Server 2005, 2008. MaxDB, DB2, Sybase
Operating Systems: AIX 5.3, HP/UX 11.23, Solaris, NT WIN2003, 2008, 2012
Reporting tools: SAP BO, Crystal Reports, HANA, and Every angle
Communication: MS offices, Outlook express, Lotus notes,
Ticking tools: Remedy, SAMPARK Siebel ticketing tool
Professional Experience:
Sports endeavors Inc – Hillsborough, NC (SAP America, PA) May 2016 – June 2016
Sr SAP Basis and Security Consultant
Project: SAP Systems Performance Review
Prepared SAP ECC system Performance Review and System Health Check report
Prepared SAP CRM system Performance Review and System Health Check report
Prepared SAP IPC system Performance Review and System Health Check report
Prepared SAP Systems Performance recommendations report Monitoring of system loads, enhancement of reports/queries and other ongoing support tasks
Applied support package ECC system
Applied support package CRM system
Applied kernel patches ECC and CRM system
Analyze SAP Early Watch reports and suggest all open issues and fix them.
Analyze the performance of production system and identify what issues are causing performance issues.
Check production system logs and pin point issues to their causes.
Check tables that are growing rapidly and identify which programs and processes are causing those.
Provide deep expertise and best practices to setup the system parameters and settings to run SAP smoothly
Expertise in setting up and tuning production SAP system.
Analyzing SAP Early Watch reports and implementing suggestions.
Deep knowledge in running SAP standard reports & notes for performance tuning and implementing them
Deep knowledge in fixing issues reported in memory dumps, system logs and other performance intensive areas.
Environment: ECC 6.0 /EP/ CRM7.0/IPC 7.0/ PI 7 / SM
QVC studioPark, West Chester, PA Feb 2015 – May 2016
Sr SAP Basis and Security Consultant
Project: SAP Production support
Installation configuration of ERP 6.0, GRC, Net Weaver 7.3 servers
Production Support providing all landscape servers
Performed system copy and refresh activates
Applied Support packages,Add-on's and SAP Note implementation
Prepared monthly early watch analysis report.
Opening OSS connection to SAP Create the developer key and object key
Performing Client Copies and Post check activities
Performed ECC, BW, BOBJ system security activities
Creating Users based on request and assigning additional roles to the existing users,Resetting Passwords for users and intimating password policy.
Created Base Roles and Company Specific Roles based upon request and Created Composite roles based upon request.
Addition, Removal of Transaction Codes, authorizations, authorization objects by modifying existing roles based upon change request. Performed Transportation of newly created roles/ modified roles.
Performed User comparison in PFCG,Analyzing missing authorizations based on screen shot sent by the user
Worked on SAP ABAP and JAVA systems
Optimizing the authorization checks by utilizing the SU53 and system traces and CUA and SU25-Profile up gradation
Created System Administrator, Security, and developer roles in BI 7.0 and EP 7.0
Troubleshot EP 7.0 and BI reporting issues including setup and landscape connectivity, BI integration with EP7.0
Client Administration: Client Creation, Client copy, client export, Performing remote client copy, Client deletion
System Up gradation: Upgrading the system by applying latest Enhancement Packs, support packs, Add-ons & Plug-ins.
Performance Tuning: Performance Tuning of R/3 System, Database and OS. Basis Administration of NetWeaver 7.x systems, J2EE Administration, Enterprise Portal, PI and BI Administration Java components administration Standard Basis Tools + J2EE admin tools (Visual Admin, Config Tool, SDM, Log Viewer)
Installed HANA Studio and HANA client.
involved in HANA monitoring and administration tasks
Created Schemas, table definitions, Attributes, Measures & Hierarchies in HANA. Involved SAP HANA security including user management, roles and privileges.
Worked as a HANA Lead on HANA Side Car scenario for Financial Reporting Project. Maintain high level of support by meeting with clients to discuss and determine system issues or areas for improvement
Customer interaction and recommendation in the competitive environment.
Expertise in setting up and tuning production SAP system.
Analyzing SAP Early Watch reports and implementing suggestions.
Deep knowledge in running SAP standard reports & notes for performance tuning and implementing them
Deep knowledge in fixing issues reported in memory dumps, system logs and other performance intensive areas.
Environment: ECC 6.0, HANA.SLT /EP/ BI / PI / SM/APO/GTS /SRM/SCM/EWM
Cargill Group (Cargill completed the acquisition of Provimi) June 2013 – Jan 2015
Sr SAP BASIS Consultant
Project: SAP Production support and Enhancement
Production Support Team Lead providing daily and weekly updates to customer and coordination of tasks to support team members.
Sabrix tool implementation with in landscape
Performed System refresh and system copy activates
Applied Add-on's and SAP Note implementation
Prepared monthly early watch analysis report.
Opening OSS connection to SAP Create the developer key and object key
Performing Client Copies and Post check activities
Performed SAP HANA Security activities
Every angle tool implementation and monitoring
Worked on SAP ABAP and JAVA systems
Performed in installation of SAP HANA system and configuration
Adding SAP HANA System in SAP HANA Studio, Stopping, Starting and restarting SAP HANA Services.
Adding user to SAP HANA System, Exporting/ Importing SAP HANA System.
Managing SAP HANA License, Managing SAP HANA users and monitoring system.
Managing Table in SAP HANA, Scaling SAP HANA
Backing up and recovering SAP HANA Database
Experience with Production support, On call rotation and Offshore Global Delivery model.
Configure Data Replication with SAP Data Services
Monitoring and Troubleshoot SAP HANA
Monitoring with SAP HANA Studio
Monitoring with DBACOCKPIT
SAP Enhancement Pack Upgrade from EHP6 to EHP7and EHP4 to EHP5.
SAP Upgradation from ECC 7 to ECC 6.0 and Support Pack upgrades through SUM tool.
Customer interaction and recommendation in the competitive environment.
BASIS Production Support Team to find out root cause of the issues and resolve the issues.
List out the issues and reporting to onsite team to get the approvals to resolve the critical issues.
Provide BASIS expertise in identifying issues in the system and possible ways to fix them.
Analyze SAP Early Watch reports and suggest all open issues and fix them.
Analyze the performance of production system and identify what issues are causing performance issues.
Check production system logs and pin point issues to their causes.
Check tables that are growing rapidly and identify which programs and processes are causing those.
Provide deep expertise and best practices to setup the system parameters and settings to run SAP smoothly
Expertise in setting up and tuning production SAP system.
Analyzing SAP Early Watch reports and implementing suggestions.
Deep knowledge in running SAP standard reports & notes for performance tuning and implementing them
Deep knowledge in fixing issues reported in memory dumps, system logs and other performance intensive areas.
Environment: ECC, SRM, MDM.GRC .SCM, CRM, BI,EWM OER,APO,GTS.EP,HANA.Every angle
Devon Energy Corporation, Oklahoma, OH Jan 2013 – June 2013
Lead SAP Basis consultant
Project: SAP Implementation and go-live Support
Installed in production ECC 6.0,GRC and BI
Installed in production EP 7.3 Ehp1 servers in distrusting database server.
Performed SAP System post installation activity
Languages Import and Supplementation
SLD Configuration and adding ABAP and Java Systems into SLD
Applied license for ABAP & JAVA and Maintenance certificate
Opening OSS connection to SAP Create the developer key and object key
Applied IS_PRA support patches
Create Bg RFCs connections
Configure DN Launcher
Installed PRA Enhancement 1.0
Integration with SAP PRA to XI and EP systems
Applied support packages and Kernel upgrade
Applied Add-on's and SAP Note implementation
Worked on SAP ABAP and JAVA systems
Prepared re-usable documents
Installed in production ECC 6.0 Ehp5 sever
Installed in production EP 7.3 Ehp1 servers in distrusting database server
Applied support packages and Kernel upgrade
Applied Add-on's and SAP Note implementation
Prepared re-usable documents
SAP System performance tanning
Analyze any production support tickets raised, determine what the issue is and resolve this in a timely manner.
User Administration and Role Administration
User Administration using SU01,SU10
Creation of Users and Roles and maintain Authorization Groups
Created Single, Derived and Composite Roles in R/3
Creating roles and generating profiles using PFCG. Assigning roles to users
Checking missing authorizations using SU53
Working on visual administration and config tool
Maintenance of R/3 profiles parameters, monitor short dumps and system logs.
Environment: ECC 6.0, SRM, MDM, HP HANA,EWM OER,APO,GTS BI.EP.PRA BOBJ
Brisbane city Council, Brisbane June 2012 – Jan 2013
SAP BASIS Team Lead
Project: SAP Implementation and Go-live Support
Installed in SRM 7.0 Ehp2, MDM servers in distrusting database server
Installed in EP 7.3 Ehp1 servers in distrusting database server
Installed in MDM 7.0 Ehp2 servers in distrusting database server
Performed SAP System post installation activity
SAP System kernel and support package upgrade.
Languages Import and Supplementation
Applied support packages and Kernel upgrade
Prepared re-usable documents
SAP Business packages implementation
Tuning the performance of SAP systems
Worked on SAP ABAP and JAVA systems
SSO and SLD Configuration for EP and R/3 systems.
Worked on Config tool and visual admin tool
SAP R/3 User maintenance and security administration
Applying SAP support packs, add-ons, implementing OSS notes as and when required
Maintaining service connections in service market place.
Reorganization of SAP housekeeping jobs
Maintaining portal roles/authorizations monitoring the portal security area and liaising with Basis and Security teams. Responsible for checking portal authorizations for users.
Content Federation of other portals like BI, CRM and SRM and maintaining the KM content of the portal for storing documents.
My Role was of a techno functional consultant and to managing a team size of 10 functional consultants in different areas of SAP. Monitoring and mentoring the team in their daily activities.
Understanding and assessing the issue resolution strategies of the team
Helping the team in meeting the SLA and thereby increasing the customer satisfaction.
Helping the team in understanding the client policies and processes for a smooth running
Tracking and publishing the statistics of incident resolution on a periodic basis to the teams and client for trend analysis.
Environment: ECC 6.0, SRM, MDM, HP HANA, OER, BI.EP.PRA BOBJ,APO,GTS
Talisman Energy Inc, Calgary Jan 2011 – Mar 2012
SAP Basis Implementation and Support Lead
Project: SAP Implementation and Go-live Support
. Installed in ECC, BI, PI, EP, SRM, GRC servers in HA
System copy ECC, SRM, BI.EP.PI servers.
Performed SAP systems Data Centre Migrations.
Languages Import and Supplementation
Applied support packages and Kernel upgrade
Applied Add-on's and SAP Note implementation
SAP ECC Ehp6 installation
SAP System kernel and support package upgrade.
SAP note implementations
SLD Configuration and adding ABAP and Java Systems into SLD
Applied license for ABAP & JAVA and Maintenance certificate
Oracle database patch upgrade using Mo patch tool.
Worked on SAP ABAP and JAVA systems
Open OSS connection to SAP creates the developer key and object key.
Applied IS_PRA support patches
Create Bg RFCs connections
Configure DN Launcher
Installed PRA Enhancement 1.0
Integration with SAP PRA to XI and EP systems
Team Lead for the Enhancement Process, where I lead the complete Enhancement process wherein I coordinate the multiple teams to make sure the enhancements are delivered efficiently and as per the agreed Quarter timelines and also make sure that this release doesn’t impact the ongoing activities/projects thereby ensuring the no escalation and issues.
Understand the responsibilities of the various teams (Portal, Support, Basis, R/3 team, Third party team, external teams etc.) and route tickets to the correct point of contact for each of the portal developments / objects in order to quickly resolve issues
Administer and manage the support process for the portal team ensuring compliance with ISDC processes and systems
Track progress and provide weekly status reports of the Support area, providing clear visibility to leadership
Environment: ECC, SRM, MDM, HP QC, BI.EP APO
Xstrata Nickel, Toronto June 2010 – Jan 2011
Lead SAP Basis and Security consultant
Project: SAP HCM and ECC roll out
System copy in SAP ECC server and HCM systems
Post system Refresh activates in ECC server
Applied support packages ECC 6.0 server, EP 7.0 server and Add-on's in SAP.
Creation of users and Assigning request Roles to the Users in EP
Performed support packages and business packages using JSPM & SDM
ADS configuration
Worked on SAP ABAP and JAVA systems
Set up the complete Production portal, was the only Portal Consultant in the project.
Worked with the System Administration, Content Administration and the UME Roles of the portal.
Configured the Single Sign On between Portal and the R/3 system.
Created a template that could be used for Mass users creation and Role assignment for the Production portal as we had 1500 users that were to be added to the Production Portal for Go Live
Transported the roles that were created in Quality to Production portal.
Integration of the BOBJ system i.e. BI system
Resolve all the portal related issue to avoid any delay in the Go Live.
Environment: ECC 6.0, PI, HCM EP 7.0, BI. MS MQL
Posti (Itella) Corporation, Oulu Jan 2010 – June 2010
Lead SAP Basis and Security consultant
Project: SAP Systems applying support packages
Post system Refresh activates in SAP ECC server
Post system Refresh activates in SAP CRM server
Applied support packages ECC 6.0 server, CRM 5.0 server, EP 7.0 server
Applied Add-on's in SAP ECC server,SAP CRM server and SAP IPC server
Prepared re-usable Support packages document
Setting up the Portal, Creating the users and roles as per the portal requirements
Creating all the necessary PCD Folder structures for holding the PCD Objects
Customizing the themes and Portal Desktops and frameworks to suit the client needs
Configuring the Anonymous portal for login free pages for users including the anonymous access to the Webdynpro Objects
Worked on SAP ABAP and JAVA systems
Creating model based applications in Visual Composer and deploying them to the Portal Creating
Webdynpro java based applications using NWDS and deploying them via NWDI.
Creating Design and Transport request documents
Creating and maintaining portal roles and authorizations for portal users thus acting as a portal security consultant
Environment: ECC 6.0, CRM 7.0, EP 7.0 IPC 7.0, Oracle
SOLAR 8000, Kolding June 2009 – Jan 2010
Sr .SAP Basis and Security consultant
Project: SAP Implementation
Installed and configured E-Recruiting Production (SAP ECC 6.0) server.
Installed and configured ECC 6.0 Production server.
Installed & configured SAP Enterprise Portal (EP) 7.0.
Installation and configured SAP MDM 7.1 Server
Configured satellite system through SOLMAN System,
Installed SAP Enhancement Package 4 for SAP ERP 6.0,
Worked on SAP ABAP and JAVA systems
Performed kernel upgrade and Applied Support Packages
SSO and SLD Configuration for EP and R/3 system.
Worked on Config tool and visual admin tool
Creation of users and Assigning request Roles to the Users in EP
Performed support packages and business packages using JSPM & SDM
Environment: ECC-6.0, SRM, GRC, PI, EP 7.0, SAP E-Recruiting, MDM 7.0 DB2
Vedanta group, Tuticorin Dec 2008 – June 2009
Sr .SAP Basis and Security consultant
Project: SAPAII Implementation
Installed and configured Auto ID Infrastructure (SAP AIII) server
Installed and configured content sever 6.30 versions
Installed and configured DMS sever
Installed and configured NW 2004S (Net Weaver-based products like Portal, XI, ECC
Setting and monitoring system availability in Solution Manager
Worked on SAP ABAP and JAVA systems
JAVA administration Activities
PI 7.0 system installation and Performed post installation activities
Languages import through SMLT
Installed and configured MS SQL 2005 sp2
Installed MS SQL native client
Apply support packs and kernel patch upgrade
User Administration and Role Administration
User Administration using SU01,SU10
Creation of Users and Roles and maintain Authorization Groups
Created Single, Derived and Composite Roles in R/3
Creating roles and generating profiles using PFCG. Assigning roles to users
Checking missing authorizations using SU53
Working on visual administration and config tool
Experience with Java stack installation, configuration and setup with NW2004S.
MS SQL 2005 Backup of Offline and online backup and transactional backup
Apply Add-on through SAINT
Working on visual administration and config. tool
Apply java license through visual administrator
Configuration of Enhancement 3 Package for ECC Systems
Maintenance of R/3 profiles parameters, monitor short dumps and system logs.
Creation of operation modes for changing user requirements
Monitoring system performance
Testing and deployment of the application into the Server.
Environment: ECC 6.0, RFID 5.1 PI 7.0 EP7.0, DMS Server, SQL server Installed and configured
Mylan Pharmaceuticals Inc, Canonsburg, PA June 2008 – Dec 2008
Sr .SAP Basis and Security consultant
Project – SAP BO and Crystal report implementation
Installed and configured system of Business Objects Edge Series server
Installed and configured crystal report server
Integration with Business object and SAP servers
Integration with crystal report 11 and SAP servers
Installed and configured Business Objects Live Office XI R2
Installed and configured Business Objects Xcelsius Enterprise 4.5
Installed and configured Business Objects XI R2 Polestar
Installed and configured Voyager XI R2
Crystal Reports Enterprise XI R2 Professional Edition
Environment: ECC 6.0, BO BI EP, Crystal Report
SAP - Labs, India June 2007 – June 2008
SAP Basis and Security consultant
Project – SAP Product testing validation
Installed and configured Net weaver 2004 and Net weaver 2004s systems
SAP Upgrade from SAP R/3 4.6C to ECC 6.0 (ERP 2005)
Applying support packages and kernel upgrade
Install add-on components through SAINT
PI 7.0 system installation and post installation.
Hands on configuration Languages import through SMLT
MS SQL 2005 Backup of Offline and online backup and transactional backup
Experience with Java stack installation, configuration and setup with other NW2004S systems Working with Visual Administrator
SAP Upgrade from SAP R/3 4.6C to ECC 6.0 and Unicode conversion
Worked on SAP ABAP and JAVA systems
SAP CRM 5.0 to SAP CRM 7.0 Upgrade
SAP and java system License applied through (SLICEENCE) and Visual administration
Configuration of Enhancement 3 Package for ERP 2005 Systems.
Monthly refreshes from production to quality and prod to Dev boxes.
Maintain Background Job maintenance and monitoring
MS SQL Database upgrade from 2000 to 2005 for the ECC landscape
Resolving day to day issues and keep track of it using tool CSN
SAP Performance management
Generation of developer's key and also applying license information during refreshes
Environment: SAP ECC, SAP Net weaver 2004, 2004s, SAP PI, SQL-2000 and 2005
Free Scale Semiconductor Inc, Austin March 2006 – June 2007
Associate SAP consultant
Project – SAP R/3 support (IBM AOD)
Monitoring the system on daily basis.
ABAP suite installation
Applying OSS notes
Analyzing System errors & ABAP Dumps
Scheduling Background jobs
Analyzing the background jobs errors.
Monitoring the system on daily basis.
Transports (OS level and SAP level)
Preparing monthly reports as per customers requested
User administration including creation, locking/unlocking, changing password
Spool jobs monitoring and analyzing spool jobs problems.
Database Monitoring and performances
Schedule the update statistics and check database at SAP level
Working operation mode, Reset the trace files.
SAP Kernel Upgrades / Support Packages. DB Upgrade patches
Setting up of operation mode timetable.
Table space administration, add to data files, resize database table space
Monitoring the Buffers and swap space at ST02.
OS - Unix level file system management
Creating Siebel SR's
Profile maintained and Monitoring CCMS alerts logs
SAP database Reorganization
Creating SAP security implementation using profile generator and Roles enhancements / maintenance
Environment: SAP R/3 systems
Fresh Direct, Long Island City, NY Apr 2005 – Mar 2006
Associate SAP consultant
Project – SAP R/3 support (IBM AOD)
Monitoring the system on daily basis.
Analyzing System errors & ABAP Dumps
Scheduling Background jobs and Analyzing the background jobs errors.
Preparing monthly reports as per customers requested
User administration including creation, locking/unlocking, changing password
Spool jobs monitoring and analyzing spool jobs problems.
Database Monitoring and performances and DB patch upgrade
SAP Kernel Upgrades / Support Packages and SAP note implementation
Table space administration, add to data files, resize database table space
Environment: SAP R/3 systems