SAP BASIS CONSULTANT (Client Certified)
N Yanala
Email : ****.******@*****.*** 516-***-****
PROFESSIONAL SUMMARY:
Having overall 10+ Years of experience in SAP includes SAP Installations, Maintenance and Security.
Performed Hana installations, upgrade, version update, Hana Replication and DR test.
Performed Hana restore/recovery methods using third party tools commvault, also with using file backups at os level.
Experience in networking, Oracle, Hana, MS SQL & Live Cache administration.
Excellent expertise in Windows, UNIX based OS particularly AIX and also good at handling different type database.
Installation of SAP R/3 4.7EE, ECC 5.0, 6.0.
Involved in Oracle up-gradation 10g to 11g, 11g to 12c and SAP up-gradation ECC 6.0 to EHP4, EHP5 & EHP7.
Involved in One End to end implementation.
DR configured on high availability servers and checking the archive sync daily with PRD servers.
Good working knowledge on ERP, BI, BO, BW, PI, XI, MM, SD, HR modules.
Good working knowledge in Solution Manager 7.1& also involved in 7.2.
Experience in SAP HA Cluster environment.
Good client facing skills, Problem management and Incident management.
Extensive experience in analysing and solving day-to-day Production issues with client facing skills.
Excellent communication skills, interpersonal skills, adaptive and self-learner
Performed pre/post installation activities after refresh activities.
Analysing the Daily Monitoring and performance tuning.
Troubleshooting SAP start-up problems.
SAP Profile Parameter Maintenance.
Performed Client administration like client creation, client copy (Local &Remote)
Client Export and import and assigning logical system to client.
Troubleshooting, Scheduling, Monitoring and Execution of Background jobs.
Experience in Active Control tool, Transport Management System (TMS) and troubleshooting the issues related to transports.
Creating and maintaining RFC destinations for system monitoring.
Performed user maintenance tasks, User creation, deletion, locking, unlocking the users, Password management tasks.
Performed Roles creation, generation, SOD, IAM and Saviynt.
Troubleshooting with user missing authorizations, analysing and providing them authorisations upon approvals.
Applying Support Packages, Add-ons, SPAM/SAINT.
Experience on performing system copy and DB refresh.
Taking backups from db13 and OS level using BRTOOLS.
Experience in Hana Database administration user creation, roles creation, migrating tables/views from one system to another system, taking backups, restoration, recovery and version upgrade of Hana.
Hana HA, DR performed and testing done during audit of landscape.
Proficient in online/offline Backups, Restore/Recovery on different databases on Oracle, Hana, Live Cache and MS Sql
WEB AS JAVA & ENTERPRISE PORTAL
Configuring Memory Parameters Using Config Tool & Visual Admin Tool.
Creating RFC Connections Using JCO RFC Provider.
Configuring SSO Settings R/3 and Portal to Connect the Backend Systems.
Troubleshooting Enterprise Portal issues.
Creating mass employee user id’s in PORTAL and locking, unlocking, deleting portal ids.
TECHNICAL SKILLS:
ERP : ECC 5.0, ECC 6.0 EHP7, EHP6, EHP5, SR3.
Operating System : Windows/2000/2003/2008, XP/ NT, Linux, AIX 6.1
Database: Oracle 9i, 10g, 11g and 12c, Hana, MS SQL &Live Cache
PROJECTS:
Sr. SAP BASIS Consultant Sept 2021 to till now
Clients : SC JOHNSON Employer: Srivin Info Systems INC DBA Mahima, New York
Work location : SC Johnson Head Quarters, Racine, Wisconsin
Roles & Responsibilities:
Working as SAP Basis Lead at customer side.
Scheduling meetings with stake holders upon client requirement discussions for the upcoming changes, making sure to aligning with functional team for validation and completing activities on-time.
Planning activities for Kernel Upgrade, System Refresh, Patch activities with checking system checks.
Performing Database refresh activities Hana, Oracle, Live cache.
Using Lama performing refresh activities of present client landscape.
Working on BDLS as part of Refresh activities, analyzing large tables and working for indexing for respective tables to reduce BDLS time for the system.
Doing daily operation reviews at client side, providing them latest updates on issue resolutions.
SAP S4Rise support working with SAP.
Analyzing problems like Startup, Background jobs, Updates, System status, Work processes, System logs, ABAP Dumps, Memory issues.
Defining Background Jobs, monitoring it, Modifying, Deleting and analyzing the cancelled jobs, studying job log and analyzing the job status.
Transport Management system and troubleshooting.
Client copy activities i.e. Client Export/Import, Remote Client, Local Client copy.
Worked on backup management, taking backups when it is necessary, checking backup catalog and clearing catalog when it is required.
Restored database backup to point time recovery, analysing the log backups and taking actions when logs reaching thresholds.
Catalog, views, packages & table migrations performing on daily basis with customer requests.
SAP HANA Security activities like User Management, Assigning Roles to users and Managing Analytical Privileges to enable course gained and fine-grained access control.
Sr. SAP BASIS Consultant July 2019 to July 2021
Clients : ISUZU
Roles & Responsibilities:
Worked as Sr. Consultant support on 24x7 basis and attending calls whenever there are priority tickets.
Database refresh performed for Oracle, MS SQL, Live Cache and Hana.
Moving transport requests with using Active Control tool, STMS, providing on time support to client with changes over weekends.
Client refresh activities, local client copy, remote client copy and client export/import.
Application level support, performing health checks, checking dumps, analysing system logs, providing traces.
Profile parameters maintenance, Op mode and Logon group’s maintenance.
Checking for swaps, identifying the performance bottlenecks and providing resolution with notes.
Performance analysis and Workload analysis.
System refresh / Client refresh and performed post refresh activities.
Kernel upgrades, Applying SNOTES.
Applying support packs and add-on installations and upgrades.
Troubleshooting problems like resetting passwords, clearing Lock Entries, unlocking users.
Monitoring and controlling active users.
Configured TMS during system refresh activities.
Configured Logon load balancing by using SMLG.
Scheduled and monitored the batch jobs and job performance.
Client Administration: Client Creation, Client Copy.
Creating background jobs, scheduling and monitoring during the BI loads.
Starting and stopping SAP applications during windows/Unix level patching activity.
Performing Pre & Post System Refresh activities during DB refresh.
Generating SSCR Keys, Downloading of support packages, Raising OSS message, Opening of OSS connections when required and various other activities are performed using SAP Service Market Place
Setting up of Operation Modes & maintaining for a better performance of the systems.
Starting and stopping of SCM Live cache.
Scheduled PI specific housekeeping jobs and reprocessing of QRFCs of inbound queue and outbound queue
Monitoring DB performance, checking of last successful backup, modifying of DB parameters based on EWA Report
Certificate renewals for all systems
SAP Environment: Bobj, ECC 6.0 EHP7 & HANA
Database: Oracle 12C, Live Cache, MS Sql & HANA
OS: UNIX, AIX, Windows servers
Sr. SAP BASIS Consultant April 2017 to June 2019
Clients : Tyco Electronics
Roles & Responsibilities:
Daily Health Check reports performed
Attending calls with customer along with BI, Abap, SD, HR & MM consultants, understanding the requirements to implement the necessary changes.
Worked on backup management, taking backups when it is necessary, checking backup catalog and clearing catalog when it is required.
Restored database backup to point time recovery, analysing the log backups and taking actions when logs reaching thresholds.
Catalog, views, packages & table migrations performing on daily basis with customer requests.
SAP HANA Security activities like User Management, Assigning Roles to users and Managing Analytical Privileges to enable course gained and fine-grained access control.
Created a high-level and detailed HANA implementation and migration plan and develop a training plan for the current development resources
Transported HANA content from development, testing environment to Production environment using delivery units.
Migration of views, tables from across non prod to prod systems.
Hana Refresh activity on every quarter, upon client requests.
Live Cache Refresh performed.
Hana patching, revision upgrade performed.
Hana DR test performed and tested during client scheduled testing period.
Performed Hana installations, upgrade, version update, Hana Replication and DR test.
Performed Hana restore/recovery methods using third party tools commvault, also with using file backups at os level.
SAP Environment: ECC 6.0 EHP7
Database: Live Cache & HANA
OS: UNIX, AIX, Windows servers
SAP BASIS Consultant Sept 2016 to April 2017
Clients: Epson
Roles & Responsibilities:
Leading clients for all L1 support team including regular activities on 24x7 Basis.
Troubleshooting SAP start-up problems (ABAP+JAVA), Transport Management System (TMS).
Background Job management includes monitoring background jobs and troubleshooting.
Spool administration and Printer setup in SAP, Daily and Weekly print queue monitoring and solving end user printing problems.
Monitoring and extending table spaces via Brtools.
Opening OSS Service Connection.
Creating and Troubleshooting the RFC connections.
Working with Visual admin tool and Config tool.
Providing Access Key to Developers from SAP Marketplace
Responsible for looking after lock entries, dump analysis, system logs and process overview.
Working on Problem tickets and preparing RCA in order to discuss in the weekly meeting with Problem Management Team.
Solving Incident and Service request as per Ticketing tool.
SCOT Configuration, On call Support, Kernel upgrade, support packs &add-ons.
Client copies like Local client copy, Remote client copy and Export & Import method.
Systems refresh activities every 2 months for individual clients.
Oracle upgrade from 10g to 11g,
Database refresh from PRD to QTY.
MS SQL database backup, restore & DR system built, MS SQL DR Test performed, with the PRD data.
LSCopy and LSRestore enable and disable for logs shipping and recovering with PRD logs.
Implementing SAP HANA for major clients in USA.
SAP Environment: ECC 6.0 EHP 4, EHP6 & EHP7
Database: Oracle 10g, 11g & MS SQL
OS: UNIX, AIX, Windows servers
SAP BASIS Consultant Oct 2015 to Sept 2016
Clients : NYPD
Roles & Responsibilities:
Daily System health checks on response time, memory utilization, space utilization and dialog process utilization, background process utilization, Monitoring expensive programs, reports, transactions and users, monitoring updates.
Performed Daily monitoring of SAP system (Check List).
System Refresh Activities, JAVA Schema Export & Import.
Trouble shooting and monitoring with printers and system hardware.
Analyzing ABAP dumps and monitored the performance at R/3level, Operating System level & Database level.
Work load and performance monitoring through work process, tune summary, OS monitoring.
Analyzing Lock entries which are locked for long time and finding the update records.
Configuring Operation Modes according to requirement of work.
Import of profiles and setting the parameters
Background jobs Scheduling and daily Monitoring.
Configured RFC communications between Clients and Systems.
System wide Locking of critical Transactions.
Daily Checks on Consistency of TMS and Spool.
Scheduling the Backups in DB Calendar.
Daily generating the STAD Report for Knowing the User activities.
Applied support packages through SPAM and OSS notes.
Performed kernel patch up gradation.
Worked with the security team for creating roles and maintaining the security and integrity of the SAP production systems.
Created roles and maintained authorization for role’s based on user responsibility.
Database Administration using BR*Tools.
SAP Environment: ECC 6.0 EHP 4 & EHP6.
Database: Oracle 10g, 11g & MS SQL
OS: UNIX, AIX &Windows servers
SAP BASIS Consultant June 2013 to Sept 2015
Client : Sterling & Wilsons Groups
Roles & Responsibilities:
Working in Online SAP Basis support and provided 24x7 supports, performing entire SAP Basis Activities as a consultant.
Analyzing problems like Startup, Background jobs, Updates, System status, Work processes, System logs, ABAP Dumps, Memory issues.
Defining Background Jobs, Monitoring it, Modifying, Deleting and analyzing the cancelled jobs, studying job log and analyzing the job status.
Transport Management system and troubleshooting.
Client copy activities i.e. Client Export/Import, Remote Client, Local Client copy.
Kernel upgrades, support patches and add-ons.
DB refreshes activities every three months and post installation activities.
Restore and recovery method used during cluster failover in IBM LPAR’s.
Database issues troubleshooting.
Dash board monitoring and taking the backups of CMS files and storing in secure data locations.
Enterprise Portal monitoring and creating, locking & unlocking the portal users upon management approvals.
Creating mass users in portal for HR team.
Performing the backups on entire landscape servers and troubleshooting backup fail overs.
Increasing the table size in landscape through BRTOOLS.
Scheduling data load activities during BI activities.
Changing the logical system names using BDLS after refresh activities.
Oracle upgrade and patch upgrade.
Configured EWA for all PRD servers and maintaining up to date patches on kernels/support packs if recommended by SAP.
Implemented SOLMAN 7.1 for all servers in client locations.
Created MOPZ configuration.
SAP Router configured and certification renewal for every year.
RAM sizes increased on IBM LPAR’s during Upgrades and installations.
Performed auditing in SAP.
Complete 3 system landscape provided for one of the new client in current organization.
DR server has configured for major client and synchronizing will be monitoring every day.
BI/BO, BW dashboard monitoring, troubleshooting and daily backups.
GRC migration
Support patch upgrading through SPAM and added GRC add-ons through SAINT.
Database Activities like backups via DB13/BRTOOLS.
Troubleshooting the database activities. & Transport management system.
SAP Environment: ECC 6.0 EHP 4, EHP 5, EHP7 & NW 7.0, BI & BO
Database: Oracle 10g & Oracle 11g
OS: RHEL, AIX 6.1 & Windows 2008
SAP BASIS Consultant Feb 2013 to June 2013
Client : BHP Billiton
Roles & Responsibilities:
Worked in Online SAP Basis support and provided 24x7 support, performed entire SAP Basis Activities as a consultant.
SAP Daily monitoring for all SAP system landscapes & generate status reports.
DB Monitoring, Backups & Restores for all landscapes and documenting status reports.
Applying latest Support packages, Plug-Inn’s & Add-On’s.
Kernel Upgrades, Setting Operation modes.
Adding Data Files, Monitoring Max no of Extents & Next Extent size using Brtools.
Configuring the printers using various access methods and trouble shooting.
Individual tables/index monitoring and taking necessary actions for better response times.
Trouble shoots on Background processing, System performance, Logon Load Balancing.
Performance Management & Monitoring - provide overall response times. Ensure SAP servers are monitored, system performance trends are identified and, where appropriate, system tuning or recommendations for corrective action made as required.
Created Printers through PAL Configuration for entire PRD landscape environment.
Tracking the incidents in Remedy Ticketing tool and resolved in timely manner.
SAP Environment: ECC 6.0 EHP 4
Database: Oracle 11.2.0.2, DB2 & MS SQL
OS: RHEL, AIX 6.1
Associate Consultant Mar 2010 to Nov 2012
Client : IT Vertical groups, London, UK.
Roles & Responsibilities:
Performed daily system monitoring check lists for all production systems.
Experience in user administration 7x24 on call production support, quick turnaround for end user requests, and Helpdesk support for user administration.
User master maintenance like user creation, locking and unlocking users and role assignment.
SAP user’s classification through USMM and submitting the user measurement to SAP.
Adding/creating single & composite roles and adding to users upon approvals.
Transporting the roles which including authorization objects, classes and internal field values.
Checking the user authorizations troubleshooting through su24 and taking the confirmation from management to add those on the same.
Worked with instance profile to set some required parameters.
Client administration and Performing Client Copies like Local Client Copy, Remote Client Copy &Client Export and Import.
Analysis & Monitoring – System Logs, Background Jobs, ABAP/4 Dump Analysis, Work Process Overview, Lock Entries, Update Errors.
Creating and maintaining RFC Destination.
Performed Kernel Up gradation.
Applied Support Packages, add-ons and Languages.
Working with database housekeeping standard jobs.
Table space management and database monitoring including maintaining of backups and restore.
Performing and monitoring Backups.
Taking backups from db13 and OS level.
Worked on System copy based on backup and Restore Method.
Performing Post Installation Activities.
Worked with STMS, performing transports, scheduled background jobs, spool administration.
Troubleshoot existing TMS, SAP, database, and operating system issues.
Involved in team for oracle up-gradation.
RCA providing on P1 incidents to clients.
SAP Environment: ECC 6.0 EHP 4
Database: Oracle 10.2.0.4 & 11g
OS: RHEL, AIX, Windows servers.
EDUCATIONAL QUALIFICATIONS:
MS in Computing and Information Technology from Liverpool John Moore’s University.
Bachelors in Electronics and Communication Engineering from KU.