John W. Milano

** ******** *****

Sicklerville, NJ 08081

Phone 856-***-****

Cell Phone 609-***-****

E-mail: a4ck08@r.postjobfree.com

Website: www.protekinc.com

Objective

Seeking a contractor position, with the goal of advancing further and contributing through my extensive experience to a progressive organization .

Education 1991 – 1996 Rowan University Glassboro, NJ

Bachelor’s Degree in Computer Science

1989 -- 1991 Gloucester County College Sewell, NJ

Associate’s Degree in Business Administration

Professional experience Career Experience:

15 Years Experience as SAP Basis Architect

12 years Experience as Database Administrator (Oracle, DB2)

Feb 2007 – Present Wyeth Pharmaceuticals Malvern, Pa

Senior SAP Basis Administrator

Responsible for the installation and maintenance of the following systems:

BW 7.0 and BI Portals 7.0, ECC 5.0, (APO) SCM 5.0, Warehouse Management 4.7, SAP HR 4.7, SAP Workplace 6.0, SRM 5.5, and Solution Manager 4.0, SLD setup and Configuration.

All instances are running Oracle 10g on HP-UX/HP-IA64 on HP Superdomes.

Most systems are FDA Validated according to GxP Standards.

My tasks included:

The installation of the central instances and application servers, application of support packs and CRT’s, application of OSS notes, application of kernel patches, configuration and setup of Solution manager monitoring, system refreshes of QA from the Production system, SAP archiving, reorgs and conversion of SAP tablespaces to LMTS, repartitioning of infocubes in BW, performance tuning in all areas of BW and ECC 5.0, implementation of HTTP load balancing, backup and recovery using Tivoli Storage Manager, setting up HP Service guard cluster for BW and high availability testing, moving transports throughout the SAP landscapes, handling the SAP related problem tickets with Service Desk, troubleshooting and solving all types of issues that would arise in any of the systems, writing SAP related validation documentation. Performed many Unicode Conversions and Upgrades on the following systems: ECC5.0, SAP BI 7.0, SAP SCM 7.0, SAP HR and SRM 5.5 using Distribution Monitor 1.8.1 and all the SAP Suite of Tools. Also assisted in knowledge transfer to the Wyeth Staff, and supporting the project team on a daily basis.

August 2006 – Feb 2007 Novartis Pharmaceuticals East Hanover, NJ

Senior SAP Basis Administrator

Responsible for the installation and maintenance of 7 SAP R/3 4.6C instances, 5 BW 3.1C instances ,6 SAP CPPC instances and 4 SAP APO 3.10 instances running on Oracle 9i on Sun Solaris ,HP-UX, IBM AIX platforms. All systems are FDA Validated according to GxP Standards. My duties included: the installation of the central instances and application servers, application of support packs and CRT’s, application of OSS notes, application of kernel patches, system refreshes of QA from the Production system, applying updates to the Vertex Tax Software, performance tuning of all the systems including BW, R3, and APO, setting up the systems for backup and recovery, assisted in the Service guard cluster for High Availability using the Hitachi disk arrays, troubleshooting problems that arise in all systems, handled everyday R3, BW, and APO SAP security issues and requests for the project teams, using the Security Audit Log in SAP and Approva Bizrights Web Application for audit control and SOD, doing daily transports to all systems in the landscape, handled everyday SAP Helpdesk tickets, writing SAP related validation documentation, performing knowledge transfer to the Novartis staff and supporting the project team on a daily basis.

May 2004 – August 06 American Reinsurance Princeton, NJ

Senior SAP Basis Administrator

I am responsible for the installation and maintenance of all SAP instances.

The SAP Instances include : 4 SAP HR systems (version 4.7 ext 110), 4 Enterprise Portal (version 6.0 SP2) (running Manager Self Service – MSS), 20 SAP R/3 systems (version 4.7 ext 110) running SAP Basis 6.40. 4 SAP BW systems version 3.5 (Netweaver 04 & Netweaver 04s) with BW content 3.5. 2 Solution Manager instances version 3.1 and 4.0, 4 SAP ITS servers (version 6.20 running Employee Self Service- ESS)

All instances are running Oracle 9.2.0.6 or Oracle 10G on HP UX 11.11.

My tasks included: Installation of SAP software, application of support packages and kernel patches, application of OSS notes, SAP system copies, application of Business packages for EP6, j2ee, Portal and Content Management Patches for EP6, installation of j2ee startup framework, configured Single Signon, EP6 Content Administration and User role mapping, importing the transports into all systems using RealTech Transport Manager, BCV split mirror backup setup for the HR Production system, backup and recovery for all other SAP instances, installation of BSI Taxfactory 7.0 and applying all tax updates to all SAP HR systems. Assisted in the implementation of SAP HR Production security strategy as well as I setup and administered security for the project team. Setup and monitored the Security Audit Log in SAP. Setup Central System Monitoring, Earlywatch and Service Level reporting and Business Process Monitoring on Solution Manager 4.0. Assisted in the disaster recovery planning and testing for our SAP HR production system.

January 2003 – May 2004 Novartis Pharmaceutical Parsippany, NJ

Lead SAP Basis/BW/APO Administrator

Responsible for the installation and maintenance of 9 SAP R/3 4.6C/4.7 instances, 4 APO 3.10 instances and 4 BW 3.0B/3.1C instances running Oracle 8i & 9i on Sun Solaris ,HP-UX, IBM AIX and Windows 2000 platforms. All systems are FDA Validated according to GxP Standards. Migrated 15 SAP instances from Sun Solaris to HP-UX 11.11. My duties included: the installation of the central instances and application servers, application of support packs and CRT’s, application of OSS notes, application of kernel patches, system refreshes of QA from the Production system, performance tuning of all the systems including BW as well as the APO livecache, installation of IGS and ITS servers, setting up the systems for backup and recovery, assisted in the Service guard cluster for High Availability using the Hitachi disk arrays, troubleshooting problems that arise in all systems, assisted in designing a 46C Security strategy, doing daily transports to all systems in the landscape, writing SAP related validation documentation, performing knowledge transfer to the Novartis staff and supporting the project team on a daily basis.

August 2002 – January 2003 Siemens Medical Solutions Iselin, NJ

SAP Basis Administrator

Responsible for the daily maintenance of 2 Production landscapes. These SAP 4.6C systems are on Windows NT and IBM AIX 4, running Oracle 7.3.2 and Informix 7.3.1 databases. This also included maintenance of 5 ITS servers version 6.1. My daily activities included: performance tuning and troubleshooting of problems, applying support packages and CRTS, applying OSS notes, applying kernel and sapgui patches, performing

system refreshes to Development and Q/A from copies of Production, doing daily transports to all systems in the landscape, writing SAP related documentation , doing knowledge transfer to the Siemens staff, and supporting the project team in all related activities. Helped package the SAPGUI 620 via MS SMS , including all testing of sapgui patches.

February 2002 – June 2002 Amerada Hess Corp Woodbridge, NJ

SAP Basis Administrator

Performed the SAP R/3 3.1H to 4.6C Upgrade on a IBM AIX platform. This included upgrading from Oracle 7.3.4 32 bit to Oracle 8.1.7 64-bit and it also included upgrading from IS-OIL 2.0 to IS-OIL 46C &CA-JVA 4.62. My main duties included the setup of the AIX 4.3.2 environment, upgrading Oracle and SAP, applying Support Packages and CRTS to the systems, doing client copies to setup the new 46C environment, setting up the transport system, the setup of the IS-OIL template client, the setup of the IS-OIL calculations, applying new Kernel and kernel patches to the environment. Setup and implementation of a 46C Security Plan to change from a profile based security system to a role based security system using the profile generator. This included the maintenance of Unix (AIX) security , network security as well as Oracle database security. This also included training the Hess staff on using the 46C tools for security. Performance tuning of all upgraded systems, troubleshooting and analysis of all SAP problems, backup and recovery of all SAP systems, and knowledge transfer of all related activities to the Amerada Hess Staff.

October 2001 – February 2002 Colgate-Palmolive New Brunswick, NJ

SAP Basis Admin/BW Admin/APO Admin

Responsible for monitoring over 65 instances of SAP, which included R/3 46.C, BW 2.1 and APO 3.0. Performed the hardware migration from SUN to AIX on most of the SAP systems. Included the planning and execution of all hardware migrations. Daily duties included: monitoring SAP and Oracle for performance issues, working with the development teams and functional teams on performance enhancements to programs, tuning the R/3, BW and APO systems, performing upgrades to Oracle and SAP, monitoring and maintenance of the Dazel software server for printing in SAP and Unix, performing Oracle database copies and restores, doing knowledge transfer to the Colgate staff. Worked with MS SMS in testing of all SAPgui patches for APO and BW. Designed all file systems for the EMC disk arrays.

August 2000 – August 2001 State of Delaware Newark, DE

SAP Basis Team Leader/Senior SAP Basis/BW Admin

Responsible for building the SAP landscape using SAP version 46.C on a Sun/Solaris and HP platforms. Setup SAP BW 2.1 , including the installation of the extractors, related patches and business content as well as creation of custom infocubes for all modules. Also scheduled all data loads into the BW system from SAP R/3 using the Administrator Workbench. Responsible for Stress Testing the Production Environment using Mercury Loadrunner and Winrunner on Windows NT. I also setup an ITS server for use with the R/3 system and assisted in the setup of Workplace, Advanced Planning and Optimizing systems (APO), SEM, IDES, CRM and Knowledge Warehouse on Windows NT. Also installed Informatica (PowerMart) using Oracle as well as Crystal Reporting. I am mainly responsible for the daily monitoring and tuning of 4 SAP instances. My daily tasks included all aspects of 46C Security maintenance, this includes using the Profile Generator to create and maintain roles for the user community, creating and maintaining R/3 and BW users, and troubleshooting any security issues. This also included the maintenance of Novell network security, Sun Solaris security, Windows NT security and Oracle database security. Further daily responsibilities included: Oracle DB maintenance, SAP Correction and Transport, SAP Hot Packages and Kernel Patches, Performance Tuning and troubleshooting as well as R/3 Installations and Upgrades. Setup of the SAP Help Facility and OSS connections, Setup of Logon Groups and Operation Modes, Local and Remote Client Copies, RFC destinations, R/3 Language Installs, Setup of R/3 Front-end and TCP/IP Printing and the Setup and maintenance of SAP Backup and Recovery.

Feb 2000 – Aug 2000 Discovery Communications Bethesda ,MD

SAP BW/Basis Engineer

Responsible for the implementation of the SAP BW system version 2.0A.

Installed BW version 2.0A on Compaq TRU64 version 4.0F. Migrated 3 SAP Systems from HPUX to COMPAQ TRU64. This included the planning and execution of all migrations. Setup the RFC connections and installed all the extractors on the SAP 46.B machines. Scheduled data loads into the BW System from SAP version 46.B using the BW Administrator Workbench.

Assisted in the upgrade from SAP 4.0B to 46.B on four SAP environments.

Designed the Security profiles using the Profile Generator, Applied necessary patches and CRT’s (Conflict resolution transports) to the upgraded systems. Assisted in the rollout of the SAPGUI version 46.B to all current SAP users. Assisted in Discovery’s International Implementation of SAP 4.6B in Singapore and England. Assisted in the implementation of SAP products ESS and ITS on Windows NT. Helped in Performance Tuning and troubleshooting of all R/3 Basis and BW problems.

Aug 1999 – Dec 1999 MCIWorldcom Arlington, VA / London, England

Senior SAP Basis Administrator

Responsible for the daily maintenance of 5 SAP instances using version SAP 4.0B running on the SunOS version 5.6. Daily tasks include Oracle DB maintenance , all aspects of SAP security including the design and creation of authorization profiles. This also included Windows NT security, Sun Solaris Security and Oracle database security. SAP Correction and Transport, SAP Hot Packages and Kernel Patches, Performance Tuning and troubleshooting as well as R/3 Installations and Upgrades. Additionally responsible for Stress Testing the Production Environment using Mercury Loadrunner and Winrunner on Windows NT. Setup of the SAP Help Facility and OSS connections, Setup of Logon Groups and Operation Modes, Local and Remote Client Copies, RFC destinations, R/3 Language Installs, Setup of R/3 Front-end and TCP/IP Printing and the Setup and maintenance of SAP Backup and Recovery.

June 1998 – Aug 1999 The World Bank Washington, DC

SAP Basis Team Leader/Senior Basis/BW/DBA Consultant

Team Leader for the Bank implementing SAP 3.1H and SAP 4.0B systems as well as the SAP BW(Business Warehouse). Leading a team of 12 people responsible for all aspects of SAP Basis, including the design of the SAP hardware architecture for the entire implementation. My team is responsible for SAP security, upgrades, installs, Oracle database maintenance, Unix administration, Disaster Recovery, Backup and Recovery, OSS access and Note application, correction and transports, client copies, stress testing and troubleshooting. We designed and implemented all SAP and Oracle database security for all SAP systems. We also designed and implemented many internal guidelines including Correction and Transport, Backup and Recovery and Disaster Recovery policies.

- Installed SAP 4.0B on AIX ver 4.3.2

- Installed SAP 3.1H on AIX ver 4.3.2

- Installed BW 1.2B on AIX ver 4.3.2

- Upgraded three systems from SAP 3.1H to SAP 4.0B, after going live.

- Installed the BW Kernel Extractors version 1.2B onto the SAP systems

- Responsible for all system maintenance and performance tuning

on the SAP and BW machines.

- Implemented the EMC High Availability solution using BCV

- Setup SAP R/3 on IBM 390 using DB2 ver 5.2 to do some performance testing and prototyping.

- Responsible for all Oracle and DB2 maintenance including all database

import/exports, Reorganizations, Table maintenance, management of

redo logs, management of rollback segments and temporary segments

as well as all Oracle performance tuning.

- Setup and maintenance of the SQLNET environment

- Configured the Correction and Transport system for SAP 3.1H and 4.0B

- Designed the Hardware Infrastructure according to SAP standards

- Stress Tested the hardware using the CATT tool in SAP

Feb 1997 – June 1998 Bristol-Myers Squibb Princeton, NJ

SAP DBA/ Basis Engineer

 Project Leader:

SAP Disaster Recovery

- Have led 2 successful Disaster Recovery tests at Sungard.

SAP Database Archiving

Database archiving using transaction SARA, where we setup and archived many documents using the ADK(Archive Development Kit) and Archive link and stored these files on disk, on tape and also on a IXOS storage system. Documents archived were mostly sales related documents.

- PRD Database is currently 160GB in size and growing

SAP Backup and Recovery

- Responsible for Backup and Recovery of 17 systems including

10 SAP and 7 standalone Oracle databases

SAP Basis Abilities Ver 2.2 , 3.0C , 3.1H

 SAP Basis Administration

 System and Performance monitoring

- SAP PRD system has 11,500 named users and

700 Concurrent Users as of 3/1/98. The PRD system will have

1,500 Concurrent Users as of 7/1/98.

- Currently running 14 PRD application servers with dual instances

on each server.

 Process and resource monitoring

 System error analysis and troubleshooting

 Technical Architecture configuration

 Computer Center Management System (CCMS) including

SAP Profile parameters, Operation Modes and Logon Load Balancing

 SAP Data Dictionary- definition and maintenance of tables, views, indexes

fields, domains and data elements.

- Responsible for over 20,000 tables and indexes in the PRD system

 Client Management – client copies, client exports and imports and use of R3trans and tp utilities.

 Background job definition and maintenance

 Correction and transport – implementation of repairs and corrections

 SAP 3.0/3.1 Memory Management

 Batch data input using BDC sessions

 Use of SAPDBA utilities

 Use of brbackup, brarchive, brconnect and brtools

 R/3 Installations and Upgrades

- Integral part of the 3.0C and 3.1H upgrades in which we upgraded

10 different SAP systems.

Oracle and DB2 DBA Abilities Ver 7.1.6, 7.2.3, 7.3.3, 7.3.4

 Database monitoring

 Database creation

 Prototyped SAP R/3 on IBM 390 using DB2 ver 5.0, including all setup and maintenance and performance testing.

 Control of database resources

- SAP Database server has 448GB of space configured for data.

 Database tuning

- Lead DBA on all database tuning for each SAP implementation

 Database recovery

- Have led numerous successful SAP database recoveries

 Table and tablespace creation and management

 Database reorganization

 Management of database access and privileges

 Management of database backups and redo logs

 Setup and maintenance of SQL *Net

 Implementation of import and export utilities

 Managing Rollback segments and temporary segments

 Managing Free Space

 Managing Shared memory and memory contention

 Efficient Resource management

 Cursor management Using PL/SQL

 Session Control (Restricting access, Using profiles)

 Proper table and Index Sizing

 Worked with the setup and maintenance of Oracle Forms

- Responsible for sizing tables and indexes for all SAP data loads.

Unix Abilities (HP ver 10.x)

- SAP Database server is HP T600 12 CPU with 4GB of memory.

- SAP Application servers are HP K460’s with 3.75GB of memory.

 SAM (System Administration Manager)

 System startup and shutdown

 Unix scripting

 Logical Volume Manager (LVM)

 Network File Systems (NFS)

 Tar Utility

 Setup and maintenance of Dazel Software used for SAP printing. Included setup and maintenance of printers in SAP and Unix as well as troubleshooting any issues related to Dazel and SAP.

 File management

 GPM and Glance

 Ioscan and device addressing

 TCP/IP functionality

 Backup and recovery using Netbackup and Omniback

Application Experience

 ABAP/4 – development of BDC’s and online programs

- Integral part of the Stress test team for each SAP implementation

in which 2000 users were simulated on a single SAP system.

 C

 PL/SQL

 Unix Shell script (C, Korn, Bourne)

Nov 1995 – Feb 1997 Elf Atochem N.A Philadelphia, Pa

SAP DBA Specialist

Primary Responsibilities

 Monitor and tune the Oracle 7.1.6 database

 Installation and maintenance of Dazel Software for printing including setup of printers in SAP and Unix.

 Tablespace maintenance

 Tablespace reorganization

 SAP Backup and recovery

 Profile maintenance

 R/3 Data Dictionary

 R/3 Installations and Upgrades

 Communication and data Interfaces

 Control of database resources

 Database import/export

 Use of SAPDBA utility

 Correction and Transport Utility

 System error analysis and troubleshooting

Nov 1992 – Nov 1995 Elf Atochem N.A Philadelphia , Pa

SAP Security Administrator

Primary security officer for SAP software, including security profile

creation and maintenance for all SAP modules.

References Available upon request

Contact this candidate