SUMMARY

• TEMPHas an extensive experience in implementation and support of SAP R/3, ECC 4.7, 6, EHP 6, 7 and HANA as SAP BASIS Administrator
• Providing architectural direction to BW on HANA, SOLMAN 7.2 upgrade, Successfully worked on 2 full - fledged SAP implementations in a span of 8 years. SAP Hana integration wif Clould(SAP Cloud,AWS)
• Worked on implementing AWS for SAP and integrating services through AWS
• Experience in working on multiple SAP products including ECC, BW, SCM, CRM, Live cache, Optimizer, XI/PI, Portal, SLD, Solution Manager, CUA, GRC, MDM, HANA etc.
• Working knowledge of working in third-party products like Redwood BPA, Transport Express, ChaRM, Rev-Trac,, CPS, HPSM, Remedy, etc.
• Participated in Disaster Recovery solution design and carrying out full exercise twice
• Excellent skills in troubleshooting SAP R/3 system administration issues.
• Handled large databases running into many terabytes including carrying out backup restores and recovery on actual Production Systems multiple times. Experience in Root Cause Analysis
• Lot of experience in doing project planning for complex technical solutions
• A very good understanding of setting up the right technical operation procedures for SAP systems
• Acted as Basis Team Lead for a team of 12 members.
• Carried out training in SAP Basis courses and awareness training for multiple employees
• Build the Basis expertise into existing teams wif less or no experience in dat area
• Winner of consecutive outstanding ratings (stood wifin top 15% of all associates) for 5 times
• Achieved Best Team award twice for the maximum contribution to the team and for grooming the team members as a backup of Team Lead
• HANA Start / stop standalone and scale out Environment.
• SAP HANA User Administration
• SAP HANA Life cycle Manager (HDB LCM)
• SAP HANA System Monitoring from HANA Studio
• SAP HANA Patching and Revision upgrade from 91.7 to 97.2 and 97.3 to 111, 111 to 2.0
• SAP HANA Backup schedule configuration, Backup and Restore HANA database
• Monitoring Alerts - Configuring e-mail Notification for alerts (for individual recipient and also for many, Alerts for specific Checks)
• HANA Packages deployment through HANA studio.
• Managing SAP HANA License - Checking the Current license Type, Installing Permanent.
• HANA Performance Monitoring for HANA system and Generation full system Dump.
• Working on S/4 HANA Migration from ECC6.0 EHP7 SQL server to HANA Database using DMO.
• Installed Tenant HANA DB
• Implemented S&OP 3.0 on HANA including AFL and SFND libraries for S&OP
• Configured HANA Live on 1.0.91
• Successfully upgraded HANA Platform edition 1.0.60 to 1.0.81 and 1.091 to 1.0.00.101 using HDBLCM

TECHNICAL SKILLS

ERP: SAP ECC, Security, EP, BI/BW and SOLUTION MANAGER, S/4 HANA

OS: Windows 2008 Server, Windows 2012 Server, HPUX, Redhat Linux 5.5,7.3,AIX 6.1,7.1

Databases: Hana DB, Oracle 10G,11G,12C, MSSQL 2008,2012

Others(Tools): SAP CPS, BPA - Redwood, BODS, BO, Rev-Trac, Loftware printer setup, Axway Jobs

PROFESSIONAL EXPERIENCE

Confidential, Irvine, CA

Team Lead

Responsibilities:

• Handle and coordinate wif offshore team and work in a offshore-onshore model
• Lead/Manage SAP Basis, SAP Hana and SAP Security Teams
• HANA Start / stop standalone and scale out Environment.
• SAP HANA User Administration
• SAP HANA Life cycle Manager (HDB LCM)
• SAP HANA System Monitoring from HANA Studio
• SAP HANA Patching and Revision upgrade from 91.7 to 97.2 and 97.3 to 111, 111 to 2.0
• SAP HANA Backup schedule configuration, Backup and Restore HANA database
• Design, implement and maintain all AWS infrastructure and services wifin a managed service environment
• Design, Deploy and maintain enterprise class security, network and systems management applications wifin an AWS environment
• Implement process and quality improvements through task automation. Institute infrastructure as code, security automation and automation or routine maintenance tasks
• Perform data migration from on premises environments into AWS
• Support the business development lifecycle (Business Development, Capture, Solution Architect, Pricing and Proposal Development)
• Integrate AWS services wif SAP
• Monitoring Alerts - Configuring e-mail Notification for alerts (for individual recipient and also for many, Alerts for specific Checks)
• HANA Packages deployment through HANA studio.
• Managing SAP HANA License - Checking the Current license Type, Installing Permanent.
• HANA Performance Monitoring for HANA system and Generation full system Dump.
• Working on S/4 HANA Migration from ECC6.0 EHP7 SQL server to HANA Database using DMO.
• Successfully upgraded HANA Platform edition 1.0.60 to 1.0.81 and 1.091 to 1.0.00.101 using HDBLCM
• Installed Tenant HANA DB
• Implemented S&OP 3.0 on HANA including AFL and SFND libraries for S&OP
• Configured HANA Live on 1.0.91
• SAP BW for HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views dat needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script and CESQL scripting. Also trained on XSJS, OData, web services.
• HANA SQL SCRIPTS & CDS CORE DATA SERVICES - Strong experience on Creating SQL, Stored Procedures wif SQL Script and also wif Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like - Tracing, Using the SQL Script Debugger.
• HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges. Hands-on experience on all three modes of transport - Delivery Unit mode, Development mode, as well as on the ‘SAP support mode’, Apt in Direct metadata import - mass import of metadata, selective import of metadata.
• Configured SLT and replicated required tables from ECC to SAP HANA.
• Prepared HANA technical configuration, Data loading, Data modeling.
• Using SAP LT Replication Server (SLT) done the Data Provisioning in to SAP HANA.
• Using SAP HANA Studio performed the modeling for Attribute View, Analytic View, and Calculation View.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Replicated data using SLT and BODS and created models as per requirement.
• Involved in moving Information models to BW as transient provider and created Reports.
• HANA integration wif BO and other tools
• Migrated In memory Cubes and DSOs to Hana studio and modified as per requirement to create Calculated and Analytic views.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Implemented SAP solution manager as per FDA regulations and approved guidelines.
• Perform SAP support package stack update, kernel upgrade, EHP7 upgrade in all environments of the landscape as per business requirement.
• Perform the system refresh from production to non-production environments using the Oracle restore and recovery procedures.
• Oracle database installation, applying patches and Oracle upgrades from 10.2.0.4 to 11.2.0.3
• SAP system client copy, export, import, open and close administration
• Opening and closing SAP OSS connection which enables the SAP support team to connect to its customers SAP systems and provide solution for the bugs or standard issues which cannot be fixed by customers themselves
• SAP printer administration, spool configuration, printer drivers setup, new device types creation, print queue setup and monitoring at OS and troubleshooting the issues
• SAP Database backup, copy, restore and recovery using BRTOOLS
• MDM and Live cache administration and monitoring.
• Scheduling and administration of Background Jobs using SAP CPS(Redwood Cronacle v7.0) for production systems and in SAP directly for non-production systems.
• Tablespace administration, handling additional space requirements by extending tablespaces and monitoring them
• Dropping and rebuilding Index for tablespace on BW databases as part of Database reorganization
• SAP solution manager system support, connecting to satellite systems, installing diagnostic agents, setup monitoring alerts
• Generate the monthly Early Watch Alerts(EWA) for all the production systems, analyze the report and suggest any recommendations to improve system performance
• SAP system upgrades like SAP portal implementation and upgrade from 7.01 to 7.30
• Setting up operation modes for application servers
• NetWeaver Administration (EP, BW/BI, PI) and monitoring of SAP JAVA systems like SAP Enterprise portal.
• Performing transports using Rev-Trac(Similar to ChaRM) implemented in Solution manager and from OS level for legacy systems.
• Integrating the ECC 6.0, EP 7.0, BW 7.0 systems to talk to each other including setting up SSL, SSO, LDAP integration
• Integration wif Active Directory SSO.
• Carried out the source system setup between BW, ECC & CRM systems
• Finalizing the documentations including step by step instructions.

Confidential, Denver, CO

Sr. SAP S/4 Hana Administrator

Responsibilities:

• SAP HANA system Administration, HANA DB start, stop, change parameters, backup, restore, recovery, HANA Studio monitoring.
• 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.
• Worked on S/4 HANA Migration from ECC6.0 EHP7 SQL server to HANA Database using DMO.
• Successfully upgraded HANA Platform edition 1.0.60 to 1.0.81 and 1.091 to 1.0.00.101 using HDBLCM
• HANA security / User administration
• Monitoring and administration of SAP HANA Databases using Solution Manager and DBA cockpit
• HANA Start / stop standalone and scale out Environment.
• SAP HANA Life cycle Manager (HDBLCM)
• SAP HANA System Monitoring from HANA Studio
• SAP HANA Patching and Revision upgrade from 91.7 to 97.2 and 97.3 to 111, 111 to 2.0
• SAP HANA Backup schedule configuration
• HANA Packages deployment through HANA studio.
• Managing SAP HANA License - Checking the Current license Type, Installing Permanent.
• Performed system upgrades such as upgrade of ECC 6.0 system to EHP7/NW 7.4, EHP8/NW7.5 and BW upgrade from 7.0 EHP 2
• Perform SAP support package stack update, kernel upgrade, SAP system upgrade in all environments of the landscape as per business requirement.
• Upgrading OpenText Archive Server from 10.1.1 and Windows Viewer from 10.1.1 to OpenText Archive Center 16
• Scheduling and administration of Background Jobs using SAP CPS (Redwood Cronacle) for production systems and in SAP directly for non-production systems.
• Upgraded SAP(Redwood) CPS 8.0 to BPA 9.0
• SAP system client copy, export, import, open and close administration
• Oracle database installation, applying patches, upgrades on single instance and on RAC and ASM environment
• Processing of users change requests, the SAP Transports in Transport Express after the approval of SQA team’s approval or using STMS for the SAP systems where Transport Express is not implemented.
• Attend weekly Integration meeting wif different SAP functional teams and discuss the scope of SAP BASIS for the business customization and future plans on upgrades and implementations.
• SAP system client copy, export, import, open and close administration
• SAP Database backup, copy, restore and recovery using Oracle RMAN and BRTOOLS
• Installing new/ renewal of SSL certificates and applying licenses in ABAP and Java systems
• RFC Administration - Creating RFC’s and analyzing issues wif RFC connections, monitoring IDOCS, TRFC's and QRFC's queues administration, partner profiles ports, BW source system connections, trusted/trusting connections.
• Batch input sessions(SM35) monitoring(delete, lock and process sessions)
• Opening and closing client in SAP systems for the changes to be made by SAP functional teams.
• Integration wif Active Directory SSO.
• SAP GUI, SNC, SSO implementation and troubleshooting connectivity issues.
• Providing SAP software change access key to the developers from functional teams for the customization as per business needs.
• SAP printer administration, spool configuration and troubleshooting the issues
• Delete the old and inactive batch input sessions twice a year in SAP ERP system which is connected to many legacy SAP or non-SAP systems to has the data at one place for analytics.
• Tablespace administration, handling additional space requirements by extending tablespaces, monitoring them and index rebuilding
• Dropping and rebuilding Index tablespace on BW databases as part of Database reorganization
• Opening OSS connections to SAP system, maintaining access data, saprouter setup and troubleshooting in case of issues
• Generating developer keys, object keys, OSS user administration in SMP
• Monitor the daily backup of all SAP production systems and perform the restore and recovery whenever required.
• Maintenance Activities for SAP systems like Starting and Stopping, Application of BASIS and Application SAP Patches
• SAP solution manager system support, connecting to satellite systems, installing diagnostic agents, setup monitoring alerts and generate EWA reports
• NetWeaver Administration (EP, BW/BI, PI) and monitoring SAP JAVA systems like SAP Enterprise portal and SAP GRC system.
• Application of patches through SDM & JSPM and deployment of par and ear files.
• Content repository and archiving administration using IXOS
• Performing system health checks, analyzing the dumps, system logs, trace files, memory buffers, workload monitor, file system storage, backups, archive logs and troubleshooting if their are any issues.
• Take appropriate action on the received monitoring alerts for the stable system run
• Providing 24/7 on-call SAP BASIS support on rotation.
• Transfer few and daily operational activities to offshore and discuss on questions and further improvement in weekly call.
• Perform the monthly update to Vertex software upon receiving the ticket from SAP finance team, which is used for internal tax calculation
• Connect all SAP systems to SAP solution manager for better monitoring, configure alerts, diagnostics and to generate EWA reports.
• Perform the database upgrade, tune memory, run statistics jobs whenever required to boost the SAP system performance
• Disaster Recovery database setup for SAP systems, maintenance and monitoring

Environment: Linux 5.5, 6.4, Windows 2008, ECC 6.0 EHP5, EHP7, EHP8, NW 7.42 Enterprise Portal 7.0, Oracle 11.2.0.3, Solution Manager 7.0, 7.2, SRM 5.0, BW 7.0 EHP2, SLD, GRC, HANA 1.0 SPS 7, SAP CPS 8.0, SAP BPA 9.0 Transport Express 5.0

Confidential, Broomfield, CO

Sr. SAP Basis & Hana Administrator

Responsibilities:

• SAP BW for HANA and migrating standard SAP Models to In-memory optimized models and Performance testing.
• Native HANA MODELLING - Designing Views (Attribute View, Analytic View, Calculation View), Stacked Calculation Views, Views dat needs multiple table functions, counters, Restricted and Calculated measures, input parameters, filters, transparent filters. Debugging Views. HANA Modeling using SQL Script and CESQL scripting. Also trained on XSJS, OData, web services.
• HANA SQL SCRIPTS & CDS CORE DATA SERVICES - Strong experience on Creating SQL, Stored Procedures wif SQL Script and also wif Calculation Engine (CE) Functions, Debugging SQL Script using various techniques like - Tracing, Using the SQL Script Debugger.
• HANA SECURITY & TRANSPORT- Creating Analytic Privileges, Setup data level authorization and privileges at SAP HANA Database, Creating User, Roles & assigning the respective Privileges. Hands-on experience on all three modes of transport - Delivery Unit mode, Development mode, as well as on the ‘SAP support mode’, Apt in Direct metadata import - mass import of metadata, selective import of metadata.
• Configured SLT and replicated required tables from ECC to SAP HANA.
• Prepared HANA technical configuration, Data loading, Data modeling.
• Using SAP LT Replication Server (SLT) done the Data Provisioning in to SAP HANA.
• Using SAP HANA Studio performed the modeling for Attribute View, Analytic View, and Calculation View.
• Created SAP HANA Information Models using Attribute, Analytic and Calculated Views.
• Replicated data using SLT and BODS and created models as per requirement.
• Involved in moving Information models to BW as transient provider and created Reports.
• HANA integration wif BO and other tools
• Migrated In memory Cubes and DSOs to Hana studio and modified as per requirement to create Calculated and Analytic views.
• Created Decision tables and performed various calculations using best function provided by Hana.
• Implemented SAP solution manager as per FDA regulations and approved guidelines.
• Perform SAP support package stack update, kernel upgrade, EHP7 upgrade in all environments of the landscape as per business requirement.
• Perform the system refresh from production to non-production environments using the Oracle restore and recovery procedures.
• Oracle database installation, applying patches and Oracle upgrades from 10.2.0.4 to 11.2.0.3
• SAP system client copy, export, import, open and close administration
• Opening and closing SAP OSS connection which enables the SAP support team to connect to its customers SAP systems and provide solution for the bugs or standard issues which cannot be fixed by customers themselves
• SAP printer administration, spool configuration, printer drivers setup, new device types creation, print queue setup and monitoring at OS and troubleshooting the issues
• SAP Database backup, copy, restore and recovery using BRTOOLS
• MDM and Live cache administration and monitoring.
• Scheduling and administration of Background Jobs using SAP CPS(Redwood Cronacle v7.0) for production systems and in SAP directly for non-production systems.
• Tablespace administration, handling additional space requirements by extending tablespaces and monitoring them
• Dropping and rebuilding Index for tablespace on BW databases as part of Database reorganization
• SAP solution manager system support, connecting to satellite systems, installing diagnostic agents, setup monitoring alerts
• Generate the monthly Early Watch Alerts(EWA) for all the production systems, analyze the report and suggest any recommendations to improve system performance
• SAP system upgrades like SAP portal implementation and upgrade from 7.01 to 7.30
• Setting up operation modes for application servers
• NetWeaver Administration (EP, BW/BI, PI) and monitoring of SAP JAVA systems like SAP Enterprise portal.
• Performing transports using Rev-Trac(Similar to ChaRM) implemented in Solution manager and from OS level for legacy systems.
• Integrating the ECC 6.0, EP 7.0, BW 7.0 systems to talk to each other including setting up SSL, SSO, LDAP integration
• Integration wif Active Directory SSO.
• Carried out the source system setup between BW, ECC & CRM systems
• Finalizing the documentations including step by step instructions.

Environment: - AIX, ECC 6.0 EHP4, Enterprise Portal 7.0, SAP CRM 7.0, 7.31, SAP BI 7.0, SAP XI 7.3, Solution Manager 7.0, SAP CPS (Redwood Cronacle 7.0), SAP BPA 9.0, Rev-Trac, ChaRM, Oracle 10g, Oracle 11g

Confidential

SAP Basis and Security Administrator

Responsibilities:

• Led the effort to carry out release work activities including system refreshes, transports, landscape design & new system builds
• Providing SAP BASIS Support to the landscapes (ERP, HR, BW, CRM, SRM, LSO, PRM and Solution Manager)
• Handling Release Delivery in which major developments will Go-Live to production system (in five system landscape) along wif parallel patching in systems.
• Patching includes, System refresh and post refresh activities, SAP Kernel Upgrade, applying Support Packages, SPDD/SPAU Procedures and EHP4 Upgrade
• Handling Maintenance Delivery in which major Developments move from project to Production landscape. Transport Buffer preparation according to the SAP IT landscape strategy. Transport lock and unlocking
• Creation of new RFC connections and maintenance of existing ones. Creation of Source System Connections in BW Systems for ECC, CRM, XI and SRM systems. Configuration of Trusted/Trusting relationship for an RFC Connection
• Transports- Creation of new requests, release and import of existing requests via STMS. Transport routes and auto import job monitoring. Troubleshooting imports and tp log monitoring.
• Performing the transports across landscapes using CHaRM.
• SAP security notes implementation as per the recommendations
• Background jobs creation, scheduling, monitoring and troubleshooting.
• SAP web services configuration relevant to few functionalities and activating in SICF.
• Opening and closing client in SAP systems for the changes to be made by SAP functional teams.
• SAP system client copy, export, import, open and close administration
• Performing language translations to fill the language gas in production systems after every major transport releases.
• System health checks including, background Job Monitoring, SAP Lock Management, ABAP Dump Analysis, DB monitoring, System logs
• Monitoring and analyzing performance issues using Workload Monitor ST03N, monitor the system hourly using ST02, DB02 and ST06.
• Batch input sessions monitoring, troubleshooting and monthly deletions.
• Handling Authorization issues like creation of new users (Dialog, Emergency, Communication, Service), roles, profiles, Changes to existing roles/profiles, Suggesting roles/profiles to users based on SU53 Screenshot, Roles/profile assignment, generation of profiles, mass maintenance of users and roles/profiles, maintaining snc details and user master data
• Monthly security parameters check, adapt the recommendations and change in system profiles.
• SAP TMS setup and configuration of transport routes, layers, buffers, virtual systems and domains across the landscape and organization
• Providing SAP GRC Compliant User Provisioning Support
• Creating and Maintaining Workflow
• Request/reject profiles, Approve or reject Compliant User Provisioning (CUP) requests.
• Handling Cost Centre Manager Changes.
• Trouble shooting User Requests for authorizations
• Creating and Maintaining Functional Area
• Maintaining Business Processes/Sub Business Process
• Maintenance of profiles
• Approver Handling
• Mapping Dependent Roles

Environment: - Windows XP/2003, RHEL5 x64, Oracle, MaxDB, GRC 5.3, SAP CRM 7.0, SAP ERP 6.0 wif EHP 6.0/Netweaver 7.31, SAP BI 7.0, SAP XI 7.3, Solution Manager 7.0, CHaRM

Confidential

SAP Basis Administrator

Responsibilities:

• Daily monitoring the three-system landscape and generating weekly dashboard reports.
• Involved wif the team while Applying support packages through SPAM.
• Profile maintenance, defining Operation modes and assigning time intervals.
• Performing Client Copy (Local, Remote and Export/Import)
• Monitoring Backups of SAP systems.
• Involved in Documentation of performed tasks for future reference.
• Configured listeners and TNS entries.
• Kernel patch Upgrades.
• Checking File System alerts when necessary.
• Configured profile parameters for default and instance profile.
• Involved in setting up SAP system for auto log-out.
• Client creation and Performed local client copy.
• Configuration of STMS.
• Worked wif trans directory to transport the requests and analyze the issues of transportation.
• Worked wif end users to configure printers and other issues.
• Configured Operation modes to dynamically switch number of WP.
• Upgrade of SPAM and KERNEL including TP and R/3 Load.
• Establishing connection between Solution Manager and Satellite System in solution manager.
• Creating Solution in Solution Manager.
• Configuration of MOPZ in Solution Manager.
• Applied support packages and patches.
• Applying of ABAP-ADD-ON Kit.

Confidential

SAP Basis Consultant

Responsibilities:

• Daily system health checkup on All SAP Production Systems through Solution Manager.
• Troubleshooting the issues as per the incidents.
• Print Management like set up the printer device and troubleshooting printer issues
• Configured and monitored the Background Processing System.
• Transport Setup and Management
• Download and Applying Support Patches and SAP Notes
• SAP Spool Configuration
• Database Overview
• Configured Operation Modes
• Backup & Database User management in SQL 2008.
• Performing root cause analysis on all production support related issues.
• Daily system health checkup on SAP, DB and OS level.
• Defined and monitored background jobs
• Created RFC connections & transportation of roles wif in landscapes.
• SAP R/3 System Performance Monitoring & Fine tuning through Instance Profile parameters.
• Monitor Backup logs.
• Troubleshooting the authorization related problems.