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 (PFCG), 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

Confidential

SAP DATA MIGRATION ANALYST

Responsibilities:

• Performed & participated in HR/HCM Data Migration process. Worked in Benefits Area (For China, Hong Kong, and TIAWAN)) Extract Data from Legacy system, APMS, DB2 using Hyperion. Cleansing of data, According to Data maps, In Excel to Load into SAP Performed data validation, Defect using (rational Software). Make sure all required Fields Extract 100% Also performed Data validation In SAP client Project is still under completion.

Confidential (Concord NC)

Application Support / Analyst

Responsibilities:

• Support CCA Application (J2EE Bases) - Main application which utilize creating of a new account (Online & through Sales Agent), Calling plan, Support Interact (.net application) Manage, maintain, and path (update) CCA (J2EE based application) management software. Work closely with User & other business users to provide in-depth technical support for Vonage applications
• Manage open issues queue on a daily basis. This involves the ability to quickly diagnose the root cause of the issue and development of the appropriate fix for the problem with company prescribed SLAs. Creation of User Account, Assigned appropriate authorization, using oracle 10g Follow appropriate change management procedures to manage and document changes to production systems Usage of Remedy for ticketing system Work closely peers at other geographic centers in the US Ensure that the change/upgrade management procedures are followed. Develop technical system support documentation

Confidential (Charlotte, NC)

SAP Basis Admin

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

Confidential

JUNIOR ORACLE DBA

Responsibilities:

• 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