SUMMARY

• 18+ years of IT experience of which 14+ years experience in SAP Basis/Net weaver /hana Administration.
• Provided basis support for 8 full lifecycle SAP implementations.
• Experience in SAP R3 46B, 46C,ECC 5.0/6.0,BW 3.5,BI 7.0,EP 7.0,SRM 5.0,SOLUTION MANAGER 4.0,PI systems,CRM 7.0.
• Expertise in SAP systems includes installation, basis configuration, upgrades, performance tuning and leading basis team.
• Proficient in basis/net weaver/hana administration with SAP systems.
• Expertise in database administration with ORACLE 8i/9i/10g/11g databases.
• Proficient in working with hardware systems such as Linux, HP and Sun Solaris and Confidential AIX systems.

TECHNICAL SKILLS

Hardware: HP 9000, RS/6000, SUN, Intel based X86, VAX, MAC, Confidential AIX

Operating Systems: HP UX 9.0/11.0, AIX 4.2/5.1, Sun Solaris 2.3/2.6/2.7, NT Server 4.0, and VAX/VMS, Red hat Linux

Software: SAP ECC 6.0,SM 4.0,EP 7.0,SRM 5.0,R3 46b, 46c, 470,BW 3.50, Oracle 7.x/8i/9i, 10g Oracle Web Applications Server 4.0.8, Oracle Developer Server 6.0, SQL*FORMS 3/4.5, Developer/2000, PL/SQL, PRO*C, SQL*REP 1/2.5, Oracle Financials 10.6, Netscape Web server

Languages: C, PRO*C 8.0.4, Cobol, Unix Shell Scripts, PL/SQL scripts

RDBMS: Oracle 7.X/8.X/9.X, 10g, DB2, MS SQL*Server

Tools: SQL*Loader 7.0, Oracle Enterprise Manager, ERWIN 2.5/3.0/4.1, Platinum Autosys Scheduler 3.41, AIX Scheduler 3.0,Veritas net backup 3.0,Remedy

PROFESSIONAL EXPERIENCE

Confidential

Senior SAP BASIS Specialist

Responsibilities:

• Performed two full lifecycle SAP implementation.
• Performed recurring system copy procedures for ECC and BW systems.
• Implemented SAP backup thru BRTOOLS and Oracle RMAN tool.
• Performed various performance tuning on SAP system landscape.
• Performed both homogenous and heterogeneous migrations for Confidential clients.
• Migrated legacy systems running from Solaris/HP - UX to Confidential AIX/Oracle Linux servers.
• Performed migrations for ABAP and DUAL stack systems.
• Performed migrations using sapinst and migmon.
• Applied advanced migration techniques such as Package splitting, table splitting, parallel export/import, parallel export/ftp to reduce the outage window.
• Installed and configured oracle databases as part of the migrations.
• Built staging systems using oracle cold backup restore and RMAN restore.
• Migrated the following systems
• ECC/ERP 6.0
• PI/XI 7.0
• MDM 5.0/7.0
• APO/SCM 5.0/7.0 (with Livecache running on Maxdb)
• SOLUTION MANAGER 7.0
• BW/BI 7.0
• SRM 7.0
• Experience with migrating very large systems (db size 7-8 TB).
• Performed various post migration steps.
• Performed post go-live support
• Migrated various oracle databases running on versions oracle 9i/10g/11g R2/RAC.

Confidential, New York City

Sr.SAP Basis/Net weaver Administrator

Responsibilities:

• Performed disaster recovery planning for all SAP systems.
• Installed & Configured BI 7.0 systems on Oracle/AIX 5.3 systems.
• Installed & Configured PI 7.0 systems on Oracle/AIX 5.3 systems.
• Installed & Configured PI 7.0 system on Oracle 10g/AIX 6.1 System.
• Performed technical configuration to configure Integration Engine, Adapter Engine.
• Configured Runtime Workbench(RWB)for monitoring
• Performance monitoring in RWB
• Cache Monitoirng
• Messaing monitoring
• Index administration to control and monitor for the index-based message search ALE configuration for IDOC adapter
• Installed and configured JDBC and JMS Adapter
• Configured SOAP Adapter
• Configured Sigle Singn-on and SSL security
• Created the alter categories and alert rules for alert notification
• Installed and configured SLD
• Configured Business Systems and transport targets in SLD
• Configured CTS plus for PI Transport Management System.
• Enabled and Configured Workflow runtime environment
• Configuration for Connecting ERP system as Business system to PI system.
• Importing Process integration content to the Integration Repository
• Configured transport management system (TMS) for BI 7.0 system
• Configured UD connect interface to extract data from external legacy databases.
• Configured federated Portal network between portal and Business Intelligence Systems.
• Designed & developed system copy strategy for BW systems.
• Worked with development team to resolve issues with transports in BI systems
• Worked with development team to tune up info cube design, reports creation in BI system.
• Monitored batch jobs for BI 7.0 system.
• Installed & Configured ECC 6.0 systems with EHP3 on Oracle/ Confidential AIX 5.3 systems.
• Used Profile Generator (PFCG) to create, generate and assign authorization profiles to users.
• Installed & Configured BSI Tax Factory 8.0 for HCM application in ECC 6.0 systems.
• Installed & Configured Solution Manager (4.0) in Suse Linux System.
• Created “Solutions” for each system landscape and configured central CCMS to monitor all SAP systems.
• Configured maintenance optimizer in solution manager to establish the approval process for downloading patches thru solution manager.
• Installed & Configured Enterprise Portal (7.0) on Oracle/Suse Linux systems.
• Performed initial permissions settings in Portal system.
• Configured SSO Logon Tickets between Portal and backend systems (ECC, BI)
• Configured Adobe Document Services in Portal to provide interactive forms support to ECC systems.
• Configured System Landscape Directory (SLD) and provided SLD access to all SAP systems
• Configured enterprise portal to use corporate LDAP for end users logon credentials.
• Installed & Configured Supplier Relationship Management (SRM) server on Oracle/AIX 5.3 systems
• Applied packages, kernel patches, and hot fixes in both ABAP & Java Stacks.
• Provided day to day basis support that includes ABAP dump analysis, monitoring alerts, batch jobs, locked objects, workload analysis, performance tuning.
• Performed system administrative tasks like client refresh, system copy, spool management, transport management, system monitoring
• Scheduled batch jobs to backup SAP systems using BRBACKUP and BRARCHIVE tools and gathered db statistics using BRCONNECT tool.
• Installed & Configured Virsa tool GRC 5.2(Compliance calibrator, acceess enforcer, fire fighter, role expert) in ECC, BI, SRM, Portal systems.

Environment: ECC 6.0,SOLUTION MANAGER 4.0,ENTERPRISE PORTAL 7.0,BI 7.0,PI 7.0,CRM 7.0, SRM 5.0,GRC 5.2,ORACLE 10g,Unix shell script, Confidential AIX 5.3,Suse Linux enterprise server 10

Confidential, Montvale, New Jersey

Sr.SAP Basis/Net weaver Administrator

Responsibilities:

• Installed & Configured BI 7.0 systems in AIX 5.3 systems.
• Installed & Configured PI 7.0 systems in AIX 5.3 systems.
• Configured transport management system (TMS) for BI 7.0 system
• Configured UD connect interface to extract data from external legacy databases.
• Configured federated Portal network between portal and ECC/Business Intelligence Systems (BI) systems.
• Worked with development team to tune up info cube design, reports creation in BI system.
• Monitored batch jobs for BI 7.0 system.
• Provided BASIS administration for multiple projects utilizing ECC 6.0 and oracle database on AIX platforms.
• Performed full lifecycle implementation of ECC, Solution manager, Portal systems.
• Performed multiple system/client copies of current landscape/systems.
• Installed & Configured BSI Tax Factory for HCM application in ECC 6.0 systems.
• Configured and used Transport Management System (TMS) to move changes requests throughout the system.
• Used Profile Generator (PFCG) to create, generate and assign authorization profiles to users.
• Installed & Configured Solution Manager (4.0) in Confidential AIX Systems.
• Created “Solutions” for each system landscape and configured central CCMS to monitor all SAP systems.
• Configured maintenance optimizer in solution manager to establish the approval process for downloading patches thru solution manager.
• Installed & Configured Enterprise Portal (7.0) in Suse Linux and Windows 2003 server systems.
• Performed initial permissions settings in Portal system.
• Configured SSO Logon Tickets between Portal and ECC,BI systems
• Applied packages, kernel patches, hot fixes in both ABAP & Java Stacks.
• Provided day to day basis support that includes ABAP dump analysis, monitoring alerts, batch jobs, locked objects, workload analysis, performance tuning.
• Configured Adobe Document Services in Portal to provide interactive forms support to ECC systems.
• Configured federated Portal network between portal and ECC, BI systems.
• Configured System Landscape Directory (SLD) and provided SLD access to SAP systems
• Configured enterprise portal to use corporate LDAP for end users logon credentials.
• Scheduled batch jobs to backup SAP systems using BRBACKUP and BRARCHIVE tools and gathered db statistics using BRCONNECT tool.
• Recovered data from "data loss" caused by batch job in production system using BRTOOLS.
• Performed disaster recovery planning for all SAP systems.
• Installed & Configured Virsa tool GRC 4.0(Compliance calibrator, acceess enforcer, fire fighter, role expert) in ECC, BI, SRM, Portal systems.

Environment: ECC 5.0,6.0,SOLUTION MANAGER 4.0,ENTERPRISE PORTAL 6.0,BW 3.5,BI 7.0,PI 7.0, ORACLE 10g,Unix shell script, Confidential AIX 5.3,GRC 4.0

Confidential, Houston, TX

SAP Basis Administrator (Implementation & Support)

Responsibilities:

• Provided BASIS administration for SAP R3 46B, 46C, and BW 3.5 systems running with oracle database on AIX platforms.
• Performed full lifecycle implementation of R3, BW systems.
• Refreshed developed and training R3 systems by performing client copy.
• Used Profile Generator (PFCG) to create, generate and assign authorization profiles to users.
• Created RFC connections to integrate R3 systems and monitored inbound and outbound requests
• Installed and configured SAP R3 systems (46B, 46C).
• Configured and used Transport Management System (TMS) to move changes requests throughout the system.
• Configured CCMS in R3 system and monitored various level of R3 system.
• Applied R3 kernel patches, support packages and OSS notes.
• Written RMAN/BRTOOL backup/recovery scripts for production databases.
• Setup Profile generators, roles/authorizations/profiles. Operation modes, user masters
• Monitored R3 system/database performance, scheduled batch jobs, prints requests.
• Scheduled batch jobs to gather statistics for databases.
• Backup R3 system database using SAP tools brbackup, brarchive.
• Installed and configured the Oracle 8i/9i DBs on development, test and production Confidential AIX machines.
• Upgraded oracle database from version oracle 8i to oracle 9i.
• Migrated applications from MS Access/SQL Server to Oracle databases.
• Scheduled backend job to gather optimizer stats for applications data in QA and production databases.
• Configured "stats pack jobs" in QA and production databases.
• Performed disaster recovery from RMAN backup sets for critical databases.
• Primarily responsible for performing DBA tasks in more than 10 databases.
• Written lots of stored procedures/triggers/functions/packages.
• Written complicated queries and validated the result set.
• Coordinated with development team to fix database, SQL PL/SQL issues.
• Coordinating data warehouse team to design and implement physical schema, performance tuning, PL/SQL scripting, table partitioning, writing/fixing complicated queries for ETL/Report teams.
• Implemented star schema design and table partitioning for data ware house applications.
• Designed normalized ER data models and converted them to physical schema models during applications migration.
• Replicated corporate data to all other production databases.
• Thoroughly monitored system usage (disk utilization/ i/o rate, CPU and memory usage.)
• Monitor the SGA usage and resize its structure as per the application needs.
• Implemented hot standby (logical & physical) database using oracle data guard.
• Administered very large databases with data growth range from 10-15 terabytes.
• Replicated corporate data to all other applications.
• Configured centralized OEM repository for the DBA team.
• Installed and created oracle 9i databases in red hat LINUX system.

Environment: SAP R3 46B, 46C,BW 3.5,BRTOOLS, Oracle 8i/9i, Confidential AIX 5.2, REDHAT LINUX, OEM, RAC, Oracle Data Guard, Oracle import/export, Erwin 4.6,Remedy System, Unix shell script and Tivoli monitoring system.

Confidential, NYC

Oracle Database Administrator

Responsibilities:

• Installed and configured the Oracle 8.0.5 DB on development, test and production Sun 2.6 machines on client site.
• Performed disaster recovery from RMAN backup sets for critical databases.
• Configured the database for Yantra application (Both YFS & DCS systems).
• Coordinated with development team to fix database, SQL PL/SQL issues
• Implemented backup/recovery for all databases using oracle RMAN and export/import utilities and used VERITAS net backup 3.0 to store backup files.
• Performed disaster recovery from RMAN backup sets for critical databases.
• Designed normalized entity relationship data models
• Thoroughly monitored system usage (disk utilization/ i/o rate, CPU and memory usage.)
• Primarily responsible for performing DBA tasks in more than 10 databases
• Performed database replication to share data between databases.

Environment: Oracle 8I (8.1.5), SUN 2.6/2.7, Oracle Developer Server 6.0, Oracle Web Applications Server 4.0.8, Server Manager, SQL*Loader, PL/SQL, Export/Import Utilities, PRO*C, Oracle Enterprise Manager, VERITAS net backup 3.0,erwin

Confidential, Miami, FL

Oracle Database Administrator

Responsibilities:

• Performed oracle software installation (8.1.5) on Sun Solaris systems and created databases.
• Implemented the Oracle 8I Hot standby database for some of the clients to avoid performance issues and high availability of databases.
• Tuned up Oracle forms and reports applications
• Performed database replication.
• Written lots of stored procedures/triggers/functions/packages.
• Configured the database, Web Server and Developer Server for the software shipped with the SUN machines to clients.
• Designed normalized data models using Erwin.
• Written Unix scripts to refresh dev/QA databases from production data.
• Installed and configured the billing application and Calling Card application in the Marketing People Laptops (WIN NT) as Stand Alone applications for their marketing activities.
• Thoroughly monitored system usage (disk utilization/ i/o rate, CPU and memory usage.)

Environment: Oracle 8I (8.1.5), SUN 2.6/2.7, Oracle Developer Server 6.0, Oracle Web Applications Server 4.0.8, Server Manager, SQL*Loader, PL/SQL, Export/Import Utilities, PRO*C, Oracle Enterprise Manager, Erwin

Confidential, Ft. Lauderdale, FL

Oracle Database Administrator

Responsibilities:

• Installed and maintained the database.
• Created the database.
• Performed performance tuning.
• Set backup/recovery procedures.
• Performed data migration.
• Performed data replication
• Coded in Pro*C 8.0.4 with PL/SQL procedures and packages.
• Provided production database maintenance and coordinating with the development team.
• Designed data models using Erwin.
• Thoroughly monitored system usage (disk utilization/ I/O rate, CPU and memory usage.)

Environment: Oracle 8.0.4, HP-UX 11.0, Autosys Scheduler 3.41, PL/SQL, PRO*C, Erwin

Confidential, TX

Oracle Database Administrator

Responsibilities:

• This Java-based ERP system enables CDD to streamline and operate all the activity in their medical lab that tests for various diseases. The company processes upwards of 2000 tests daily, for which tests are recorded, reported and invoiced on a daily basis. The system provides a single repository for the entire operation.
• Performed Performance tuning.
• Installed and maintained the database.
• Setup backup/restore procedures.
• Developed Network setup (Intranet Settings).
• Performed data migration.
• Performed data replication.
• Designed and tested stored procedures and triggers using PL/SQL.
• Performed integrating Imaging system.
• Thoroughly monitored system usage (disk utilization/ I/O rate, CPU and memory usage.)

Environment: Oracle 7.3.4,HP-UX 11.0, Windows NT 4.0, PL/SQL, PRO*C 2.3.4

Confidential, CA

Oracle Developer/DBA

Responsibilities:

• Confidential Finance Database (APLFINDB):
• Finance System is an application used by Confidential .
• Migrated the legacy system (DB2/COBOL under VAX) to an Oracle/RS6000 environment using Pro*C.
• Performed database tuning.
• Performed data migration.
• Performed backup/restore procedures.
• Loaded the test data.
• Established interface between legacy system and developed system.
• Coded in Pro*C and shell scripts.
• Wrote reports using SQL Report Writer and Pro*C.
• Tuned the system.
• Wrote SQL*Loader scripts to load the test data.
• Automated the mailing process.
• Coded in Pro*C, shell scripts and SQL*Forms 4.5.
• Confidential Account Database (ACDB): The ACDB is the centerpiece in tracking customer reference information and enabling transactions. The front end of ACDB resides on a Macintosh system communicating in batch mode with the Confidential UNIX system. This project involved migrating the back end from VAX/Ingres to RS6000/Oracle 7.2.3.
• Migrated all converted triggers ESQL/C programs to Oracle Pro*C.
• Converted all Ingres Rules to Oracle Data base Triggers.
• Rebuilt existing Interfaces.
• Setup the job schedule on the AIX Scheduler.
• Tuned up the database.
• Thoroughly monitored system usage (disk utilization/ i/o rate, CPU and memory usage.)

Environment: Oracle 7.3.2, PRO*C 2.3, SQL*Forms 4.5, Confidential AIX, HP-UX 9.0, RS6000, VAX, ESQL, C, SQL*Report writer, Cobol, DB2, Shell Scripts, SQL*Loader

Confidential

Oracle Programmer/DBA

Responsibilities:

• Integrated Materials Management System (IMMS):
• This major system is divided into four subsystems:
• Stores and Accounting Control System (STAC).
• Material Provisioning Accounting Control System (MPAC).
• Order Processing System (ORP).
• Purchase Order Progression System (POPS).
• Stores and Accounting Control System (STAC): STAC system provides on-line service to the various users of stores department. Involved in migrating from COBOL/ HP-UX to Oracle/Sun workstation.
• Resolved performance issues.
• Coded in Pro*C, shell scripts.
• Developed online screens in SQL*Forms 3.0.
• Generated various reports in SQL*Reports 1.1.
• Material Provisioning Accounting Control System (MPAC), Order Processing System (ORP) and Purchase Order Progression System (POPS): MPAC system provides on-line service to the various users of the materials department. ORP system provides on-line service to the entire purchasing and materials department. POPS system provides on-line service to the entire purchasing department.
• Resolved performance issues.
• Coded in Pro*C, shell scripts.
• Developed online screens in SQL*Forms 3.0.
• Generated various reports in SQL*Reports 1.1.

Environment: Oracle 7.1, HP-UX 9000, PRO*C 1.3, SQL*Forms 3.0, SQL*Reports 1.1, Cobol, Sun Workstations