SUMMARY

• Over 15 years of exp in IT Industry, in which 9+ years in SAP BASIS & 6 years of Database Admin with an earned reputation for meeting strict deadlines & delivering critical solutions.
• A dynamic SAP and Database Administrator with expertise in: CE 7.1, SCM 5.0, ECC 6.0, BI 7.3, SRM 7.0, EP 7.02, GRC 10 on various RDBMS, Multi - Platforms, Installation & Configuration, Production Support and Team Management.
• Expertise in SAP Upgrades BI 7.0 to BI 7.3, ECC 6.0 EHP4 to EHP6.
• Expertise in working with Datacenter provider Vendor & provide results.
• Played the Basis Lead in assessing the Upgrade Strategy and performing BI 7.0 to 7.3 upgrade & applying support pack upgrades on SRM, ECC, PI, GRC, Vistex, Vertex, EP, Solution Manager.
• Worked on Business Suite on HANA (ECC & CRM on HANA) for in house projects.
• Admin Support to Sabrix, OpenText, TMS, Vertex, Paymetric, Vistex, BSI (HR TUBS).
• Experience in Complex SAP Global Roll out to various countries in a phased manner & there by working in a large team.
• Completed multiple life cycle implementations of CE 7.1, SCM 5.0, ECC 5.0, BW 3.5, and ECC 6.0 with EHP, Solution Manager, and SAP Router.
• Expertise in Performance Tuning of applications, physical Design & monitoring of Database, Designing backup and restore model, automating various DBA activities, evaluating development team requirements and troubleshooting issues.
• Client Copy and Transport Management: Completed Local Client Copies, Remote client copies using RFC connections and client export and import of production client as a part of client refresh.
• Expertise in applying Support packages and bug fixes, implementation of SAP notes. Tuning database and SAP buffers for optimal performance of SAP system.
• Successfully managed the setting up of printers through the SAP spool system administration (SPAD) for network printers.
• Planning and Installation of SAPGUI upgrades and deployment to large user bases (around 8000 users worldwide)
• Exposure in various activities like System Sizing, requirement Analysis, coding scripts for automation and monitoring
• Played the role of Onsite (US) Technical Lead for 6+ years, in an onsite/offshore model of team size 30.
• Strong Leadership qualities & equally active Team member
• Letter of Commendations
• Appreciation letters from the client
• Successful upgrade of SCM environment from 4.0 to 5.0.
• Successful HCM Implementation and support.
• Received in-house best Team award

TECHNICAL SKILLS

ERP: ECC 6.0 EHP4, BI 7.3, SCM 5.0, EP 7.0, SolMan 7.0, SAPConsole, SAP CE 7.1

Operating System: AIX 5.3, Sun Solaris, Linux, OS/390 V2 R10, MVS/ESA, Windows 2008

Languages: C, Shell scripts, SQL, REXX, VS COBOL ll, CICS, JCL.

Database: Oracle 9i/10g/11g, DB2 8.1/9.1, DB2 UDB, Max DB, VSAM

Tools: Vertex, Redwood, Paymetric, Open Text, Sabrix, Delego, Transportation Management System (TMS), KPRO, br toolsNetbackup, TSO, OMEGAMON II, DB2 Connect, Endeavor, CA-7

PROFESSIONAL EXPERIENCE

Confidential, San Francisco

Basis Sr. Consultant/Onsite lead

Responsibilities:

• Production Support of large SAP Systems, covering around 2000 users, spread across the Globe.
• Worked with third party Datacenter Vendor to ensure that the Basis related tasks are executed and availability of the systems is ensured.
• EHP upgrade from ECC 6.0 EHP4 to EHP6, BI from 7.0 and 7.3
• Analyze Performance issue and provide the solutions.
• Perform Transports and Notes that are relevant for the Environment.
• Analyze early watch reports and implement the changes that are required.
• Performed SSO project, which has enabled SSO for Portal and SAPGUI users, this has simplified the process of the end users to login & reduced the user maintenance work for the security team.
• Upgrade BI from 7.0 to 7.3
• Support Pack Upgrade of Various SAP Components (ECC, SRM, PI, EP, Vistex, Vertex)
• Suggested & implemented various Value adds, which was benefit the Client in terms of process simplification and Cost benefit.
• Update SAPGUI Client & Other Software’s to the end user’s desktop across the Globe.
• Analyze the business requirements and perform fit gap Analysis. Propose Solutions for the new business requirements.
• Support Application team during the various projects (Successfactors, GRC ARM project .. etc)
• Prepare Project Plan and track the activities.
• Review Project Status with Senior Management and highlight potential risks and suggest action plan.
• Work on Various proposals & presentations. Worked on Business Suite on HANA for in house projects.

Environment: SAP ECC 6.0, BI 7.3, SRM 7.0, EP 7.02, Vistex 4.0D, Vertex 6.0, GRC 10, PI 7.02, BSI, ESS/MSS.

Confidential, Santa Ana

Basis Sr. Consultant/Onsite lead

Responsibilities:

• Successfully Completed Complex Datacenter move, which include both SAP and non-SAP applications
• Production Support of large SAP Systems, covering around 8000 users, spread across the Globe.
• Analyze Performance issue and provide the solutions.
• Perform Transports, Notes & analyze early watch reports & implement required changes
• Installation and configuration of CE 7.1 in a MSCS Cluster and distributed environment
• Proactive Maintenance of the Systems and provided various Value adds, which was benefit the Client
• Install & Configure bolt-on applications to SAP like SAPConsole, Open text, Delego, Sabrix.
• Design of the SAP Printing Model for a global user base.
• Ensure that Confidential Offices and Warehouses are ready for SAP Roll-out to each country, which include that the network bandwidth is good for SAP Implementation.
• Update SAPGUI Client & Other Software’s to the end user’s desktop across the Globe.
• Analyze the business requirements and perform fit gap Analysis & propose relevant Solutions.
• Co-ordinate with training team and ensure that end user training needs are met for SAP Go live.
• Support Application team during the SAP Roll-out Phase.
• Prepare Project Plan and track the activities.
• Review Project Status with Senior Management and highlight potential risks and suggest action plan.

Environment: SAP ECC 6.0, BI 7.0, SCM 2007, Livecache, CE 7.1, SR....M, XI, GTS, Charm, SAP Console, SAPSprint, GSW Telnet Software, Open Text, Delego, Sabrix, Transport Management System (TMS), RightFax

Confidential

Basis Sr. Consultant

Responsibilities:

• Responsible for System Sizing for Solution Manager, ECC 6.0 and Selecting the Hardware Vendor
• Life Cycle Implementation of ECC 6.0 EHP1, Solution Manager, SAPRouter.
• Database Administration of DB2 9.1 & ensure it runs optimally.
• Analyze and finalize the backup solution for the SAP Environment.
• Creating role based authorizations to the Implementation team and the end users.
• Support Application team during the SAP Implementation Phase.
• Configuration & Installation of SAP GUI Client on the end user’s desktops.
• Prepare Backup and Restore strategy for SAP Systems.
• Prepare Project Plan and track the activities.
• Review Project Status with Senior Management and highlight potential risks and suggest action plan

Environment: SAP ECC 6.0, SAP Solution Manager 7.0, DB2 9.1, Windows Server 2008

Confidential

Basis Sr. Consultant/On-Site

Responsibilities:

• Upgrade Assessment Study for 4.7 to ECC 6.0
• Interdependencies Analysis due to upgrade to external systems & plugging
• Derive Project timelines.
• Analyzed current System health & proposed Performance improvement for critical jobs
• Memory management for the SAP Systems
• Fine tune Oracle parameters for better performance
• Responsible as SAP Security Admin and Transport Admin
• Analyze and Implement EWA Reports & ensure that System is running in an efficient manner.
• Oracle Database Administration, to ensure that Database is running at optimal level.
• Responsible for Adding and Administering Printers on SAP

Environment: SAP R/3 4.7, Oracle 10g, Windows Server 2003

Confidential, Tempe, AZ

Basis Sr. Consultant/On-Site Co-coordinator

Responsibilities:

• Responsible for SCM 5.0 Stack 11 upgrade, Livecache Upgraded to 7.6.03 build 08
• Ramp-up Upgrade SCM 4.0 to SCM 5.0, Livecache Upgrade, Optimizer Installation
• Involved in NW2004s Upgrade (ECC 6.0, BI 7.0, XI, SR....M, Unicode conversion).
• Upgrade R/3 4.7 to ECC 5.0, BW 3.0 to 3.5.
• Apply Support Packages for all components when needed.
• Deployed SAPGUI 620, 640 and 710 for all the 5000 users.
• Memory management for the SAP Systems.
• Installed Solution Manager 4.0 and Configured landscape through SMSY transaction.
• Configured Earlywatch for all the Systems in Landscape through Solution Manager.
• R/3 Plug-in upgrade, Solution-Tools ST-PI, ST-A/PI upgrade.
• Local Client copy of the preconfigured client 001 and other clients as per application groups
• Analyzing and Implementing Early Watch Reports and ensure that System is running in an efficient manner.
• Performed Kernel Upgrades as and when needed by application groups.
• Monitoring the system log and ABAP dumps and take necessary action.
• For Application group integrated testing, Used HCOPY procedures to copy Production System to Test Systems
• DB2 and Oracle Database Administration, to ensure that Database is running at optimal level.
• Responsible for Adding and Administering Printers on SAP.
• Responsible for Installing and maintaining third party products like Image Now, KPRO, SIFT
• Designed and Implemented Backup and Restore Strategy.
• Administer Transport Management & Work Closely with Application teams to fix issues.
• Involved in Disaster Recovery Planning and Testing.
• Project Co-ordination (including ownership of all offshore tasks for Cut-Over and Go Live).
• Conducted Peer Review for Critical Activities.
• Served as Team leader & Mentor. Knowledge Transfer to offshore centers, development of individualized training plans, and component coverage to improve customer service.
• Prepare detailed Cutover Plans to include all Technical, Functional and Project Management tasks.
• Adhere to CMM Level-5 Quality practices.

Environment: ECC 6.0, SCM 5.0, BI 7.0, AIX 5.3, Oracle 10.2.4, DB2 8.1, Image Now, KPRO, SIFT

Confidential, Tempe, AZ

Sr. Database Administrator

Responsibilities:

• Supporting Production databases for continuous availability.
• Tuning the Applications as per developer’s requirements.
• Execute IBM utilities like Unload, Load, Reorg, Runstats, and Dsn1copy etc.
• Execute CA utilities like Quickcopy, RapidReorg, Fastload, and Fastunload.
• Used CA products like RC/Migratory, RC/Update, RC/query, Plan analyzer as part of the DBA activities.
• Scheduling the REORGS and Backups and ensure that they run as expected.
• Monitoring the growth of the tablespaces closely so that they don't run out of space.
• Data refreshes for the Different subsystems with the production data.
• Binding Plan / packages on request.
• Grant the Necessary authorizations for the users.
• Planed and performed DR Testing, by recovering DB2 and IMS Databases.
• Performed the role of Configuration Manager using Endeavor Tool.
• Automated Various DBA related tasks using REXX.
• Creating DB2 objects that are part of Database Physical Design

Environment: DB2 7.1, OS/390, VSAM, IMS-DB, REXX, Endevor, CA-7, Platinum Tools

Confidential

Sr. Database Administrator

Responsibilities:

• Migrated DB2 subsystem from V3-V4-V5 on OS/390.
• Monitoring the Buffer pool activities and Thresholds using Omegamon.
• Upgraded Versions of Platinum and Omegamon Utilities
• Tuning the DB2 System by changing the DSNZPARM values.
• Designed the Backup Model for the database.
• Creating DB2 objects that are part of Database Physical Design.
• Bind/ Rebind the Plan/packages as and when necessary.
• Interact closely with the users for optimizing the SQL Queries.
• Monitor the DB2 system logs to check for any errors.
• Running DB2 utilities like Reorg, Runstats, Copy, Repair, Load, Unload, Recover etc, that are part of the DBA Maintenance activities. Planed for DR Testing.
• Creating, copying, renaming VSAM clusters. Moving Data across the Development and production systems. Run aiding Programs such as DSNJU003, DSN1COPY, DSN1PRNT etc.
• Prepare weekly and monthly status reports using platinum Database Analyzer.
• Ensure that the Database backup is successful.
• Involved in the overall implementation process of Disaster Recovery for both PNB & JPJ projects.
• Generated reports using REXX, to generate other DB2 utilities.
• Implemented and contributing to MS ISO 9001 standards for the Data Center Services Dept.

Environment: DB2 5.0, OS/390, TSO, SQL, VSAM, CICS, REXX, Platinum Tools, Omegemon II for DB2

Confidential

Jr. Database Administrator

Responsibilities:

• Creating DB2 objects Tables, indexes etc.,
• Loading / unloading the Data from DB2 tables.
• Monitor the DASD usage. Calculating the space requirements for the newly created table spaces (segmented and partitioned).
• Running DB2 utilities like Copy, Recover, Repair, Load, Reorg, Runstats etc.,
• Grant/ Revoke privileges to the Users for the Plan and Packages.
• Prepare JCL's for the Backup and recovery for the databases.

Environment: DB2 4.0, MVS, TSO, SQL VSAM, CICS