SUMMARY:

• Proficient in Installations of SAP R/3 (4.6B, 4.6C, 4.7E. ECC 6.0), Upgrades, Database Administration, Performance Tuning, Kernel Upgrade, User Administration, Spool Administration, Client Administration and having good troubleshooting skills.
• Perform SAP installation, upgrades in SAP Enterprise Portal, BW and SAP Net Weaver.
• Performance Tuning of SAP servers by using some transaction codes such as ST01, ST03, ST03N, SM50, SM12, DB01, ST05, STAD, ST22, SM21, DB02 and other related codes and procedures if needed.
• Performance management and tuning of application and database management
• Collaborate with other technical resources (Hardware, OS, development and functional) for support, production issues, and problem resolution.
• Expertise in the area of User management across different product offerings from SAP.
• Expert in Transport Management System (TMS) - Complete setup of Correction & Transport System (CTS) using STMS. Creating Transports using workbench organizer, Transport Organizer, importing Transports through STMS, creation of transport routes and monitoring Transports, troubleshooting Transports import problems.
• Client Administration - Client Creation, Client copy, Client export, Remote Client Copy, Client Deletion, Securing Clients, Assigning Logical System to client.
• Expert in Performance Tuning - Performance Tuning at R/3 System level, Database level and OS-level.
• Proficient in Database refresh, Kernel Upgrade.
• Experienced in Spool Administration.
• Excellent in monitoring Batch/Background Jobs-Checking the status of Background Jobs, Deleting Batch Record, Generating Batch Record, Scheduling Background Jobs.
• Experienced in applying OSS notes, support packages
• Security Administration: Managing SAP Security like creating users, deleting users, creating profiles using profile generator ( Confidential ), creating roles, assigning profiles, creating authorizations, assigning roles, using SAP default templates for users, monitoring user logins, user sessions, restricting default logins in instance parameter file, trouble shooting user level problems to properly access the servers and maintaining security throughout the SAP landscapes.
• ORACLE DBA: Have good experience with PL/SQL in creating database triggers and stored procedures. Creations of Database using SQL, PLSQL, troubleshooting.
• Tuning and optimizing SQL Queries./ Experience with Installation, configuration and maintenance of ASM, Oracle 10g RAC for high availability databases.
• Practical knowledge in database backups and Recovery strategies using RMAN , User Managed and Export/Import .
• Knowledge of Tuning SQLs using AUTOTRACE, EXPLAIN PLAN, SQL Trace, TKPROF and SQL Tuning Advisor .
• Experience in Microsoft server 2003 Environment Administration
• Competent skills in system support and administration, network, OS Installation and Hardware Troubleshooting
• Ability with Unix Shell (perl) scripts to automate tasks that includes administration, backup, monitor and troubleshoot database issues
• Database Performance tuning via V$/GV$ views , OEM , Grid Control, STATSPACK, AWR, ADDM for 8i/ 9i/10g/10g RAC.
• Experience in 24 x 7 Production and Development environments.

TECHNICAL SKILLS:

Database: Oracle 9i,10g,11g, SQL Server

Operating System: AIX, Unix/Linux, Redhat. Windows, Server 2003

Languages: SQL, PL/Sql *Plus, Java, C++, HTML

Database Tools: OEM, SRVRMGRL, Import, Export, SQL*Loader, SQL*Plus, Toad, SQL Developer, RMAN and Net8.

ERP: SAP Basis Admin

PROFESSIONAL EXPERIENCE:

Confidential, Annapolis, MD

SAP Basis Administrator

Responsibilities:

• Manage / Monitor 5 production systems over 25TB size, Complete task in daily checklist, which include, SM12 & SM13 (Log & Update), SM21 & DB01 (logs and dead locks), RFC connection, CIF inbound/outbound Queues.
• Monitoring file systems and coordinated with UNIX administrators to add file systems when it reaches 65% capacity. Used BTROOLS to Add space on ORACLE TABLESPACE
• Perform daily Backup on Evening shift (using Symantec VERITAS Netback)
• Clean up unix file system related to sap
• Worked on system monitoring for error logs and ABAP dumps, Analysis of DUMPS and report.
• Configured and tested SAP security profiles besides troubleshooting of performance issues and adjustment of SAP System profiles.
• User management activities like creation/deletion/lock/activation, Profile generator, Authorization traces and Password management, besides setting of new authorization objects and values.
• Created profiles, users, granted authorizations and monitored batch jobs. Ran and analyzed trace for missing authorization and initiated corrective action.
• Performance Tuning of SAP servers by using some transaction codes such as ST01, ST03, ST03N, SM50, SM12, DB01, ST05, ST22, SM21, DB02 and other related codes and procedures if needed.
• Managing TMS like setting up TMS, Including systems to domains, importing Transports from development to Quality Acceptance and then on to production
• Client maintenance, client copies, client exports, system refreshes, applying support packages, OSS notes, SPAM updates and upgrade R/3 kernel patches. Schedule SAP Early-watch sessions, review and analyze Early-watch reports and implement SAP recommendations.
• Spool Administration like configuring printers and trouble shooting spool request, deleting old spool jobs, working with TemSe objects.
• Configuring Operation Modes, Managing Instance Profile, managing Logon Groups for load balancing.
• Resolve user issue with WEB, SAP portal / connection issue using HEAT ticketing system.

Environment: ECC 6.0, EP 7.0, BI 7.0/BW 3.5, PI 7.0, SCM, NetWeaver, Wiley interscope

Database: Oracle 11G, MaxDB, Solaris 10 - Tools: TOAD (Qwest Software)

Virtualization: VMWARE, ESX Server

Confidential

SAP DATA MIGRATION ANALYST

Responsibilities:

• Assigning Profile & Roles to users as per SOX standard.
• Managing SAP Security like Creating User, Deleting, creating profile using profile generator, Create roles, Authorizations, roles using Default templates for users. Monitoring user logins, user sessions, restricting default logins in instance parameters file, troubleshooting user level problems to properly access the servers & maintaining security throughout SAP landscape
• Managing TMS like Setting up TMS, including systems to domains, Importing TPs from Development to Quality Acceptance to Production.
• Monitoring Background jobs, re-scheduling, canceling long running jobs
• File system monitoring - Database monitoring
• Short dump analysis(ST22), managing lock entries, lock/unlock transaction codes, displaying and monitoring of Database and Application servers, managing user sessions
• Monitoring application servers up and running
• Configured Operation Modes (RZ04, SM63), Profile parameters maintenance
• Set up Central User Administration (CUA) to manage multiple systems/clients
• Spool Administration, Configuring Printer & Troubleshooting spool request, deleting old spool jobs, working with TemSe objects.
• Contribute to the documentation for the various tasks that we perform for daily monitoring
• Missing Authorizations to the users & More
• Installation, maintenance of Oracle databases 9i,10g/Oracle Applications
• Creations of Database, wring PL/SQL script to Automate Administration.
• Database backup and recovery (Hot and Cold Backups)& RMAN utility
• User and tablespace management, creating and granting roles
• Performed upgrading Oracle 9i to 10g. Application and database cloning, patching. Troubleshooting ORA errors. Applying patches.
• Performing Health checks - Application user creation.
• Monitoring tablespace size, resizing tablespace, alert log, trace files
• Tracking invalid object, compiling & validating the invalid objects
• Monitoring alert logs for errors
• Resolved the view log /out files issues of concurrent request
• Managing backups of the Apps instances

Environment: ECC 5.0/6.0, CRM3.1/4.0, EP 7.0, BI 7.0/BW 3.5, PI 7.0

Database: Oracle 10G, OS: Redhat 4, AIX 5 - Tools: TOAD (Qwest Software)

Virtualization: VMWARE, ESX Server