EXPERIENCE SUMMARY:

• 9 years of specialization in SAP Basis/Security with Upgrades & Production Support
• 9 years of Total IT experience in SAP R/3 Basis and Security Administration, SAP HANA Installation & Administration
• My expertise includes administration, installations and DB Migration of SAP servers, ABAP and security administration and Networking.
• Transport Management (TMS), SAP Support Packages, applying as per OSS Notes/SNOTE
• HR, Financial, Manufacturing, AFS, Oil & Gas domains
• SAP HANA certified consultant.
• Installation and Working Knowledge in SAP R/3 4.7, ECC 5.0/6.0, BI/BW/HANA 3.5/7.0, EP 6.0/7.0, upgrading from SAP BW & Portals 7.0 to release 7.31, 7.4 and NW7.0 to 7.5, SAP HANA Installation & Administration Business Objects, Administration, User maintenance and SAP performance and BPC on HANA.
• Installing BOBJ on AWS
• Experience in SAP HANA 1.0. Data Provisioning, Data Replication, Modelling, administration, backup recovery.
• Knowledge on SAP BO web intelligence and Excel Analysis for Office 1.4 for reporting
• Strong experience in SAP Basis / Net weaver Administration and excelled in all phases of SAP implementation from design, installation, implementation, development, go live, cutovers, hyper care, production support, upgrades, onsite - offsite-offshore projects.
• User creations and assigning privileges on HANA database.
• Object level authorizations and role assignments.
• Defined R3 security roles according to restriction requirements for the following business areas: core finance (FI) and HR (Payroll).
• Implemented SOX and GRC audit compliance processes and best-practices.
• Provided timely support and solutions to complicated security issues in all business areas.
• Worked on creating Master, Derived roles and Composite roles
• Strong experience on HANA SP 08 and SP 09, 10,11 and 12
• Worked on HANA installations and upgrades from SP08 rev 82 to SP 09 rev 97, sp10.2 to sp12.06
• Extensive experience on SAP installations, SAP Integration & Configuration, SAP Upgrade &Unicode projects, OSDB Migrations, SAP System refresh projects.
• Oracle upgrades (from 10g to 11g)
• Applying support patches in ECC and Enterprise Portal System.
• Client Administration including Client Copies - Local, Client Export and Import.
• Security, role administration in ECC, CRM, BI, EP and Business Objects.
• SMD agent installations.
• Experienced in Transport management systems (OS level as well as in SAP level)., background job administration, Spool administration .
• Kernel Patches Application.
• System copy using different methods like export/import and using backup files(online/offline)
• Database administration activities like table space Administration, Monitoring table spaces, critical objects, Missing indexes,
• Database administration and Re-organization using SAPDBA and BRTOOLS.
• Analysis of update failures, performance issues and High CPU utilizations on HANA database in day to day operations
• Demonstrated a positive service attitude, exercise good judgment have problem solving skills and have desired to learn and ask questions in order to grow in scope of knowledge.
• Worked with various teams like web team, network team, print team, technical and functional team to troubleshoot specific application errors and performance issues.
• Having Good interpersonal skills, self-motivated ability to provide after-hours support for global customers in differing time zones.

TECHNOLOGY PROFICIENCY:

• SAP BW/BI 7.3/7.0/3.5, SAP ECC (SD, MM, PP, HCM, FICO), SAP HANA Studio,
• Business Objects, Web intelligence and AO 1.4
• HANA DB 1.0, Oracle 11g/10g, SQL Server 2008, MySQL, Microsoft Office Suit / Word, Excel, PowerPoint, OneNote, MS Project, MS SharePoint.
• Unix, Linux, Windows 2003 / 2008 Server, Windows 95/98/XP/7/8

WORK EXPERIENCE:

SAP BPC on HANA admin

Confidential, Portland OR

Environment: - BW/BPC on HANA NW 7.4, BPC 10.1, EPM front end.

OS: Linux

Database: HANA 1.0, SP 10 and SP 12.

Responsibilities-

• End to end basis resource for the complete implementation project
• Installed NW 7.4 to support BPC product
• Installed HANA SP 10 platform edition 1.0
• Installed and configured BPC 10.0
• Built production support environment for weekly and monthly releases.
• Worked on HANA table partitioning methods to redistribute the tables reaching the critical threshold limit set by SAP.
• Worked on HANA system refreshes as and when required.
• Implemented EPM distribution model by working along with functional teams.
• Worked on source systems connections setup
• Worked on NW 7.4 sp13 to NW 7.5 sp05 upgrade.
• Worked on HANA 1.0 SP 10.2 to SP12.06 upgrade.
• BPC10.0 is upgraded to 10.1.
• Implementation of SAP HANA DBCC and cockpit.

SAP HANA DBA

Confidential, Portland OR

Environment: SAP ECC 6.0, SAP BW NetWeaver 7.4 sp11, BOBJ 4.1 sp05, Confidential DMIS 2011 SP08.

OS: Linux

Database: HANA 1.0 sp08 rev 82 and sp09 rev 97, Oracle 11g.

Responsibilities:

• Configuration of SAP HANA 1.0(SPS 7) and HANA DB studio for Administration
• Installation and configuration of SAP Confidential system.
• EHP 7 upgrade from EHP 6 on ECC systems.
• Upgrade of HANA SP08 to SP09 rev 97
• Implementation of SAP HANA DBCC and cockpit.
• Confidential DMIS upgrade from 2011 1 731 0007 to 0008
• SAP NetWeaver upgrade from 7.4 sp5 to 7.4 sp11
• BOBJ upgrade from 4.1 SP0 to 4.1 SP5 Patch 5.
• Used Confidential system as integrator to connect source systems SAP ECC and target database as HANA.
• Day-to-day maintenance and support of HANA systems.
• System copy/refresh of BW running on HANA
• Building parallel sandbox and Production support systems.
• Creating cronjobs for daily backup of HANA systems.

SAP Basis/Security Technical Consultant

Confidential

Environment: SAP ECC 6.0, SAP R/3 4.7 EE, PI 7.0 / 7.31, Solution Manager 7.0/7.1SAP BW 3.5/ 7.0, SAP IDM, SAP HANA 1.0.17, TREX

OS: Linux, UNIX

Database: Oracle 11g, SAP HANA 1.0 (SP-7)

Responsibilities:

• Post Installation of SAP HANA 1.0(SPS 7) and HANA DB studio for Administration
• Installation and configuration of SAP Confidential system.
• Used Confidential system as integrator to connect source systems SAP BI/SAP ECC and target database as HANA.
• Used Confidential system as integrator to connect Non SAP source Oracle Database and target database as HANA.
• Installation and configuration of Lumira Server.
• User creations and assigning privileges on HANA database.
• Object level authorizations and role assignments.
• Performing grants on users based on read/write/drop privileges on HANA database.
• Worked on information security validations and quarterly and annual security audits.
• Worked on security role designs and creating master, derived and composite roles.
• Played a key role in Kernel upgrade activities on multiple environments like ECC, BI, PI and portal systems
• Worked extensively on Support Stack upgrades on Portal, ECC, BI systems.
• Configured EWA alerts for ABAP & JAVA instances
• Installed SMD agents
• HRSP Upgrades.
• Portal, ECC, BI System Builds & System Refreshes
• Played a key role in Handling SLD related issues.
• Played a key role in Handling Front-End (SAPGUI) Issues
• Troubleshooting Performance Issues from SAP, Oracle & UNIX level.
• Use Oracle flashback to fix user related errors
• Configuring STMS and releasing transport requests or workbench requests from quality to production.
• Troubleshooting archive file system issues (or arch) and file system clean up issues.
• Worked on exclusive HR related tax update bulletins (HRSP TUBS).
• Applied Confidential recommendations and implemented RSECNOTE tool to identify the Security notes In order to avoid the security flaws in the system.
• Table space Management & Using BRTOOLS for other DB related activities (Rebuild Indexes, Extent Management, Oracle user password changes).
• Client Administration & Client Copies
• Involved in the Daily monitoring of the SAP system landscape ABAP dumps(ST22), System logs(SM21), System Locks(SM12), Updates, Background jobs(SM37), Work processes(SM50) and Spool data(SPAD).
• Applied SAP OSS Note using SNOTE and capturing the OSS Note in the transport request and move the note to various systems in the landscape.
• Configuring Technical, Business systems in SLD.
• Upgrade from oracle 10g to 11g on Sandbox, DEV, QA and Production systems
• Role and User Management
• Performed imports using STMS and troubleshoot on transport errors at OS level and re-imported the transports after fixing the issues.

SAP Basis/Security Administrator

Confidential

Environment: 4.7EE Support

OS: UNIX, Linux

Database: Oracle

Responsibilities:

• Applying latest support packages.
• User administration and spool administration.
• Setting and Creating Users and Profiles and giving Authorizations depending on the roles.
• Created RFC destinations and source systems using transactions SM59 & RSA1 respectively.
• Scheduled housekeeping jobs using transaction ‘SM37’.
• Scheduled Offline/ Online Backups and checking logs thru transaction ‘DB12’
• Performed system copies using R3COPY for ABAP system.
• Applying ABAP Support packages using SPAM.
• Password management by setting profile parameters.
• Tracked Users, Roles, Profiles, Authorizations, and Transactions by different selections criteria using SUIM.
• Monitoring Error Log Files and Checking of System Logs.
• Handling User tickets and failed batch jobs
• Maintenance of RFC and monitoring the database and system locks.
• Client Administration and moving transport requests.
• Logon load balancing and Implementing Notes.
• Creating users and groups assigning authorizations through profile generator, User Maintenance / Unlock the users / monitoring users, Adding the Roles, Profiles to the user, Role maintenance.
• Error determinations Abap Dumps, Logs, Trace Files.
• Tuning system parameters for smooth performance of the system.