Senior Sap Basis - Hana Administrator Resume
Schaumburg, IL
SUMMARY:
- 9 years of IT experience in Designing, Implementation, Administration, Upgradation and Support of SAP/Oracle Systems on Linux, Sun Solaris & Windows.
- Extensive experience in SAP R/3 BASIS Administration, Installation, configuration, EHP Upgrades, System Refresh, Kernel Upgrades, and Support Pack upgrades, SNC configuration, DB Refresh, Database Backup/Recovery, DR maintenance & Support.
- Implemented 2 Full Life Cycles and extensive experience in Upgradation of SAP Servers, OS/ DB Migration and Implementation of New Projects.
- A seasoned SAP Security and GRC consultant with proven expertise in SAP SECURITY & GRC (AC - EAM, ARA, BRM, ARM) & (SOX - SOD) in User Authorizations, Roles, Profiles and CUA also with SOX /SOD audit experience.
- Extensive experience in Administration, installation, configuration and troubleshooting HANA Database - SAP HANA studio, SAP S4 HANA, Solution Manager , SAP Enterprise Portal.
- Extensive experience in Linux/ Unix Shell Scripting - Automation of day to day activities. Good Knowledge in administering Oracle / HANA/ MS SQLDB Servers and SQL, PL/SQL Queries.
- ITIL Certified - Good at Business process consulting/ Incident Management, Problem Management, Project Management & Leading the projects.
- Ability to prioritize and deliver tasks against agreed timeline. Excellent analytical, problem solving, decision making, strong influencing, collaboration and relationship building skills.
- Strong assessment and decision-making skills, outstanding ability to influence and build relationships both within the organization and with external sources - Customer Focus.
- Building a vision for IT and continuously developed Plan & roadmap for activities to support systems. Extensive experience in Production and Application Support - Activities, Management & Leading. Handled and supported Mission Critical and Business Critical Production Systems.
- Supported a variety of SAP application environments by maintaining and supporting the entire SAP landscape (Sandbox, Dev, QA, Training & Production). Worked on server Vulnerabilities and remediated them .
- Experience in reviewing, analyzing, troubleshooting, documenting and following-up on issues. Performed (RCA) root cause analysis of issues and communicate appropriately to customers.
- Ability to learn and adopt new technologies on a fly and capable of setting Priorities and goals.
- Tech savvy with winning horse attitude - Ability to think broad & out of box and to work on several projects in parallel and meet target timelines. Flexible in working off hours and weekends.
- Managed projects involving complex SAP ERP and J2EE Web applications operating at high traffic levels in a clustered environment.
TECHNICAL SKILLS:
Primary Skills: SAP ECC, SCM, HANA, SRM/ CRM/ SAP BI/BODS/ BOBJ, SAP Portal - Enterprise Portal, MDM, Solman, PI, SAP Security & GRC 10.0(AC) APO, SAP Live Cache, GRC 5.3 & 5.2, IDM, SAP NetWeaver/BASIS Administration, WebLogic Server Administration and Production Support.
SAP: ECC 6.0, SRM 7.0, CRM 7.0, SAP GRC 10.0 & 10.1, ECC 6.0, EHP7, EHP6, SAP Solution Manager, Fiori, MDM, Business Intelligence 7.0, SRM 4.0, XI & PI 5.0, SCM 6.0, ECC 6.0.
Middleware: WebLogic & WebSphere Application Servers, MQ series & Oracle Fusion, TIBCO
Webservers: Oracle HTTP Server, IBM HTTP Server, IIS & Apache.
Utilities & Schedulers: CA Siteminder, Ticketing Tools (CMIS, RTS & IPM) - Cron, ESPX, SAP Scheduler & Autosys.
Programming Languages: Shell Scripting, Python, Knowledge in JAVA & .NET 3.5
Database: Oracle SQL/ PLSQL (Knowledge in DBA) & MS SQL Server, HANA, MySQL
Testing & Reporting: Manual Testing - BO/BI & OBIEE
Web Technologies & ETL: HTML & CSS - SAP BODS, ODI
Hardware & Networking: Hardware & Networking Installation & Troubleshooting
PROFESSIONAL SUMMARY:
Confidential, Schaumburg, IL
Senior SAP Basis - Hana Administrator
Responsibilities :
- Participated in Business Requirements and Hardware requirements finalization.
- Involved in Plan areas (Sizing, Scoping, Client/Landscape Strategy, High Availability/Disaster Recovery Strategy etc.) of Implementation projects.
- Installed SAP R/3 ECC 6.0 on Linux OS and performed Pre - Post Validation steps in Sand Box/ DEV/ QA & PROD by working with Linux and DBA teams.
- Installed and configured ECC/ SRM/ CRM/ Portal. Also, Installed NWBC, Unicode, NetWeaver, NetWeaver components, Solution Manager, BI/SBOP BI Platform Server.
- Supported JAVA Stack and ABAP Stack and Dual stack (JAVA + ABAP) Stack.
- SAP Basis Support for Various systems of the Landscape like ECC, APO, SRM, CRM, BI, BO, and PI.
- SAP BASIS Support included SAP system health checks and working on tickets raised by CMIS tool, OSS Administration, SAP Marketplace, Transports, printer Administration, File system clean ups, tablespace extension.
- Performed new system build Activities, System refreshes - ECC/BW/CRM/HANA.
- Installed Oracle software using binary.
- Applied Oracle PSU patches.
- Performed Password reset for expired user accounts.
- Added table spaces and administered them.
- Time based and event based Scheduling of background jobs and monitoring them.
- Client Administration including client copy / export / import.
- Support RAC database and worked on database patch upgrade, monitoring and creating GRID backups for the RAC systems.
- Performed Kernel upgrades and Support pack upgrades.
- Implementing Oracle PSU patches in RAC & Non RAC environment.
- Implementing AMR alert monitoring for newly built systems.
- Transport setup and management.
- Download and applying Support Patches and SAP Notes.
- Monitoring the performance of data loads for BI/APO/BODs systems.
- Applying logs in DR.
- Generated stack from Solution Manager for Upgradations.
- Upgraded EHP to latest versions (EHP 6 to EHP 7).
- Used SUM & SWPM for System Upgrades.
- Configured SAP Backup and administered Spool.
- Worked on Solution Manager Configuration and configured Early Watch Alert.
- SAP SCM Live cache administration like backup/Restore using Database Manager GUI, monitoring.
- Recycling of ABAP /JAVA servers (STOP - START) during weekly maintenance and whenever required.
- Performed releasing/Importing of transports between DEV, QA and PROD systems and Troubleshooting of System performance or Potential system installation issues.
- ABAP Java Integration activities and Java Administration for Portal SIDs.
- Administered Live Cache - Stop/Start.
- Installed SAP HANA DB.
- Monitoring of SAP HANA DB using HANA studio and Sql commands.
- Upgraded SRM from 7.3 to 7.4 version and to EHP 3.
- Configured SRM and connected with Enterprise Portal EP.
- Installed Enterprise Portal (EP) - Configuration and troubleshooting.
- Performed Portal transports and performed log analysis for trouble shooting.
- Stop - Started the servers when required (Recycle during Maintenance).
- Integrated with ECC with NetWeaver systems.
- Monitored the data loads in BI and APO whenever required.
- Configured and monitored Trfc & qRFC queues and monitored those including CIF jobs.
- Created RFC’s for connection establishment.
- Installed, Upgraded, Configured Solution Manager 7.1 to Solution Manager 7.2
- Knowledge in - SAP Solution Manager including Change Request Management (ChaRM) and Service Desk Management global implementations and Early watch integration.
- Implemented DR system for each PROD system in Landscape and Always maintained DR system with PROD configuration and use to implement whatever change performed in PROD.
- Synced logs between PROD and DR.
- Recovered PROD servers by pulling the logs from DR when any issues arise.
- Performed Disaster Recovery (DR Activity) every year.
- Prepared an execution plan for DR activity and documentation for the same.
- Tested DR by stopping PROD and completed the task by routing the load to DR servers.
- Integrated ECC with PI and transferred data to SAFE server and to staging external server.
- Participated in calls - Related to New project proposals, Enhancements, Migrations and Weekly Maintenance supports. Worked on server Vulnerabilities and remediated them.
- Monitor and manage the Application Servers, Background jobs, Performance of the system.
- Configured SAP GUI at client/end user computers.
- Should have through understanding of IP address configurations and pinging concept.
- He must able to troubleshoot any client or server problems.
- Install and Configure TSM Client across all platforms (Windows, UNIX).
- Install and Configure LAN free Backup.
- Implementing the Industry best standards for Backup & Recovery.
- Configured and monitored TREX Service in SRM and ECC.
- Maintained Vertex server - Stop/Start services.
- Used to updated and deploy TAXWARE update monthly.
- Experience in Business Intelligence with SAP BODS.
- Having SAP BO infrastructure setup experience which includes setup a new BO environment, upgrading the existing system and maintaining the existing environments.
- Experience in Installation/Administration of BO application, Scaling the BO Architecture,
- Involved in User Administration and SSO Implementation / SNC across the landscape. Expertise in BO system Administration including Software deployment, Installation,
- Support and troubleshoot production systems as required, optimizing performance, and resolving production problems
- Experience with setting up with BODS repositories, Job servers, and BODS Admin activities
- Hands on experience in using SAP BODS (Business Objects Data Services) to extract structured/unstructured data from different source systems (Oracle, MS SQL Server, SAP ECC, Flat Files etc into HANA.
- Scheduling BO Reports, handling issues.
- Mapped SAP HANA System in SAP HANA Studio and performed Stopping, Starting and restarting SAP HANA Services.
- Monitoring of SAP HANA DB using HANA studio and Sal commands.
- SAP HANA Database Backup, Restore. Resolved performance issues by changing parameters.
- Alert monitoring, Configuration and parameter changes using HANA Studio.
- Supported pre and post GO LIVE.
- Managed SAP HANA License, Managing SAP HANA users and monitoring system.
- SAP HANA Security including User Management, Roles, and Privileges.
- Integrated Hana with BI and Solution Manager. Performed tuning of SAP Hana Applications & DB.
- Experience with troubleshooting the technical and performance issues during and after go-live.
- Duly Applied Patches & upgrade to support application/reporting and performance requirements.
- Installed and supported third party tools.
- SAP technical expert - handled customers, given technical training & KT to new team members.
Environment : ECC, Solman, AP0, SRM, BI/BOBJ, BODS, CRM, BW, EP Enterprise Portal, Linux, Oracle, Live Cache, HANA, PI/XI, GRC 10.0.
Confidential, Basking Ridge, NJ
Senior SAP Basis Administrator
Responsibilities :
- Involved in all stages of Migration from setting up new environment to application Go-live.
- Installation of SAP R/3 ECC 6.0 with oracle 10g on windows 2003, (32 and 64 bit environment).
- SAP System landscape setup - 3 system landscape (Development, Quality and Production) Using homogeneous system copy and Client Copy.
- Regular Kernel patch up gradation and SPAM updates.
- Application of OSS notes to resolve the issues
- Applying license and maintenance certificates.
- Applying Add-on & Plug-ins using SAINT, support packages using SPAM in the entire 3 system landscape.
- Configure TMS between Development, Quality and Production systems of R/3 using STMS.
- Profile maintenance - Start, Instance and Default Profile.
- Client Administration - Client copy, export & imports, Deletion.
- User Administration - User creation, Deletion, User copy, Password Activation, Authorization and Profile maintenance.
- Creating Roles (Parent and Child Roles) and Authorization, assigning roles to users.
- Configuration of SAP Router and RFC connectivity for OSS and remote access.
- VERITAS backup configuration for SAP system in windows server.
- Printers Set-up and reconfigure for the Sap R/3 system through SPAD.
- Monitoring Spool status.
- Moved data and configuration between SAP systems utilizing Test Data Migration Server (TDMS) or client copies.
- Monitored the data loads in BI and APO whenever required.
- Perform system copies and dual stack split.
- Used SUM & SWPM for System Upgrades.
- Configured and monitored Trfc & qRFC queues and monitored those including CIF jobs.
- Created RFC’s for connection establishment.
- Maintained J2EE software stacks - monitoring, debugging and troubleshooting issues related to the Java stack.
- Maintain SAP portal environment. Configuring backend services called by the portal, know how to create, change, and update SSL certificate
- Planning for SAP Installations, system sizing (capacity planning), and disk/storage/server layout and system installation plans.
- Monitor database growth and activity. Monitor database performance and adjust database resources as required. Monitor database storage and add storage space as required.
- Table and index maintenance. Reorganize database tables and rebuild database indexes as required.
- SAP integration to other SAP and non-SAP systems.
- Backup and Restore Management using BRBACKUP/BRRESTORE.
- Regular Transport Management in 3 System Landscape.
- Performance Monitoring of SAP R/3, Database, Operating system.
- Scheduling background jobs and monitoring.
- Analysis of System Logs, Short Dump, Update Error & Deadlocks.
- Raising OSS messages and seeing through the resolution and apply SAP support OSS notes.
- Use SAP online OSS support to research and report problems, schedule and provide solutions.
- Installation and configuration of Business Objects, Data Services and Information Steward
- Implemented DR system for each PROD system in Landscape.
- Always maintained DR system with PROD configuration and maintained is configurations similar to PROD.
- Synced logs between PROD and DR.
- Recovered PROD servers by pulling the logs from DR when any issues arise.
- Performed Disaster Recovery (DR Activity) every year.
- Prepared an execution plan for DR activity and documentation for the same.
- Tested DR by stopping PROD and completed the task by routing the load to DR servers.
- Configured CCMS, Alert configuration and monitoring.
- Installed Enterprise Portal (EP) - Configuration and troubleshooting.
- Performed Portal transports, log analysis for trouble shooting.
- Stop - Started the servers when required (Recycle during Maintenance).
- Integrated with ECC/SRM systems.
- Installed, Upgraded, Configured Solution Manager.
- Configured all aspects of Solman preparation, Managed Systems Config, Basis Config.
- Solution maintenance SOLAR01, SOLAR02 roadmaps
- Configured Charm and Service Desk integration.
- Configured BI Monitoring, PI Monitoring, iDocs Monitoring
- Configured and integration of Business Process Monitoring and analytics BPMon
- Configured Root Cause Analysis RCA.
Environment: ECC, GRC, Oracle, RHEL, BO/BI, AP0, SRM, BODS, BOBJ, MDM, SBOP, GTS, CRM, Portal, PI, GRC, SolMan, NWDI, SLD, Linux/Windows.
Confidential, Basking Ridge, NJ
SAP Basis Consultant
Responsibilities:
- Involved in all stages of Migration from setting up new environment to application Go-live.
- Installation of SAP R/3 ECC 6.0 with oracle 10g on windows 2003, (32 and 64 bit environment).
- SAP System landscape setup - 3 system landscape (Development, Quality and Production) Using homogeneous systems copying and Client Copying
- Regular Kernel patch up gradation and SPAM updates.
- Application of OSS notes to resolve the issues
- Applying license and maintenance certificates.
- Applying Add-on & Plug-ins using SAINT, support packages using SPAM in the entire 3 system landscape.
- Configure TMS between Development, Quality and Production systems of R/3 using STMS.
- Profile maintenance - Start, Instance and Default Profile.
- Client Administration - Client copy, export & imports, Deletion.
- User Administration - User creation, Deletion, User copy, Password Activation, Authorization and Profile maintenance.
- Creating Roles (Parent and Child Roles) and Authorization, assigning roles to users.
- Configuration of SAP Router and RFC connectivity for OSS and remote access.
- VERITAS backup configuration for SAP system in windows server.
- Printers Set-up and reconfigure for the Sap R/3 system through SPAD.
- Managing print and spooling functions. Configure and maintained approximately 340 remote printers.
- Backup and Restore Management using BRBACKUP/BRRESTORE.
- Regular Transport Management in 3 System Landscape.
- Performance Monitoring of SAP R/3, Database, Operating system.
- Scheduling background jobs and monitoring.
- Analysis of System Logs, Short Dump, Update Error & Deadlocks.
- Maintained MDM services.
Environment: ECC 6.0, BI, APO, MDM, Oracle Linux, GRC 10.0, ECC 6.0, BI, FI & Oracle DB.
Confidential, Temple Terrace, Florida
SAP Security & GRC Consultant
Responsibilities :
- Participated in Business Requirements and Hardware requirements finalization.
- User Administration using SU01 and SU10 and their Roles
- Added and Modified the Role to the End User as per Management Guideline.
- Responsible for day-to-day user administration tasks.
- Created Authorizations and Profiles based on the Job Profiles.
- Good Working Knowledge of AGR* and USR* Tables.
- Resolved many missing authorization issues by analyzing the SU53 screen shots.
- Effectively analyzed trace files and tracked missed authorizations for user's access problems and inserted missing authorizations manually.
- Execute appropriate Reports or Programs to check user access to SAP Systems as per given criteria at the time of Audits (SA38).
- Create roles using different methods like transactions, direct objects, missing authorizations, restrictions etc.
- Performed SAP License Audit.
- Defined Back ground Jobs like PFCG TIME DEPENDENCY using SM36.
- Restricting Table Access using Authorization Objects S TABU DIS for maintaining Table Security.
- Setup and administration of User IDs via Central User Administration (CUA).
- Monitoring the critical T-Codes and ensure that they are not assigned to the concerned users.
- Create FF ID’s, FF Owners, FF Controllers, and FF Administrators for FF ID’s and map them to FFID’s.
- Assign EAM roles.
- Adding FF ID’s to Fire Fighter using EAM.
- Mitigation and Remediation of users using User Analysis in ARA.
- Having experience in SAP security for various environments like ECC, HR, FI, BI & (GRC).
- Experienced in the areas of User administration, Role management, development, and troubleshooting, Testing and reports generation in Security environment.
- Very good knowledge at SAP Authorization Concept.
- User Administration - Includes user creation, deletion, changing user access for different systems and environments, Mass user administration.
- Managed and created new users, groups for easy administration.
- Role maintenance as creating, modifying roles and assigning additional roles to the existing users based on user change requests form.
- Massively user comparison by running job in back ground.
- Experienced extensively in using PFCG - profile generator in creating and modifying Single, Composite and Derived roles.
- Working on role changes as per the business requirement.
- Maintenance of Derived roles based on the Organizational Values differentiation.
- Maintenance of authorization objects for transactions.
- Effectively analyzed trace files and tracked missing authorizations for user’s access problems.
- Proficient knowledge on USR* & AGR* tables.
- Creation of authorization groups as per the business requirement
- Having Good knowledge in SOD and SOX.
- Create roles using different methods like transactions, direct objects, missing authorizations, restrictions etc.
- Mass user maintenance through SU10 and handling user issues through SU53, SU56 and System Trace ST01.
- Extensively used SUIM transaction code for security analysis
- Central User Administration (CUA) experience to create users, assign roles, and maintenance.
- Emergency Access Management (EAM) - Access Risk Analysis (ARA) - Business Role Management.
Environment : GRC, ECC, Oracle Linux, Oracle DB.
