SUMMARY:

• Over 30 years of proven data processing experience, 19 years in Pharmaceutical industry and Supply chain industry, including People Management, Project Management, Logical and Physical database design, Systems Integration, Supply Chain design and support.
• SAP ERP implementation, upgrade, Database Administration, UNIX system administration, validation and programming.
• Self motivated with excellent communication skill. Capacity planning, Performance tuning
• Architected High availability includes, Oracle RAC, ASM, Oracle replication, Oracle Data Guard, Hardware failed over, Business Continuance Volume (BCV) backup.

TECHNICAL SKILLS:

Hardware: RED HAT Linux, Sun(SunOS, Solaris), HP(HP - UX 9, 10, 11,11i), DEC Alpha, Mips, Vax(OSF, Ultrix, VMS),IBM AIX, Silicon Graphics, Windows.

Software: Teradata, VMWare, Oracle APEX, SAP NW, Oracle Financial 11i, Documentum, UNIX, Linux Shell, VMS DCL, PC-DOS, X-Windows, C, COBOL, FORTRAN, PASCAL, SQL, PLSQL, OEM, Oracle Tools(Developer 2000, Designer 2000), Toad, Oracle CASE, Erwin, S-Designer, MicroSoft Project, Veritas, Netbackup, Tivali, Maestro, HTML, Java Script, Informatica, Data Stage

Databases: Oracle(4 - 12c), Informix, Sybase, Total

PROFESSIONAL EXPERIENCE:

Partner

Confidential

Responsibilities:

• Migrate Oracle from HPUX to VMWare RED HAT Linux, built Oracle Software as a Service(SaaS) using DataPump for 1 TeraByte Databases, Golden Gate, Rman plus conversion for databases larger than 1 TeraBytes
• Upgrade Oracle 10g, 11g to Oracle 12c.
• Supported all software development and production in HCS.
• Supported J&J USROTC supply change on SAP and Warehouse management system(WMS).
• Supported Corporate Data Warehouse in Oracle.
• Installed and Built OEM 13c, Oracle Grid Infrastructure Oracle 12c Rac using Oracle ASM.
• Supported 11g Oracle Rac with ASM cluster environment.
• Production 7/24 support. SAP consultant for Global Confidential and Confidential
• Responsible for managing, leading BASISs, DBAs, install, upgrade, migrate SAP systems for the entire Confidential and Confidential landscape. Architected, High availability includes, Oracle Data Guard, Hardware failed over, Business Continuance Volume (BCV) backup. Participated Disaster recovery exercises
• Provide Global support services. Regions include, US, Europe, Asia Pacific and Latin America.
• Conduct technical solutions review with clients.
• Harmonize and leverage services infrastructure groups from different regions.
• Managing and leading Oracle DBAs and SAP BASISs support, upgrade and migrate to SAP NetWeaver from mainframe DB2 to HP Itanium Oracle for SAP/R3 and BW.
• Implement and Provide guide line of Information Asset Protection Policies(IAPP) and Sarbanes Oxley (SOX) standard.
• Conduct remediation for post-auditing.
• Implemented Oracle Data Guard for a failed over solution. Write Standard operating procedures.
• Support client copy, and misc. data load activities.
• Key leader for J&J Pharmaceutical Services, Project Totality
• Responsible all aspect of activities:
• Architect database platform solution.
• Logical / Physical data model design, data mapping using Erwin.
• Set integration strategies, integrate Totality to various systems, Employee, Customers, Suppliers, Purchasing, Accounts Payable, Global Expenses… etc.

ETL architect

Confidential

Responsibilities:

• Installed 10G GRID, Installed Oracle 10g RAC, create and manage databases. Tuning, monitoring etc…
• Harmonized and leveraged services from infrastructure groups and Accenture consultants.
• Production and development support:
• Upgraded all Oracle 8I databases to 9I on HP-UX environment, RED HAT Linux 9.
• Trouble shoot all 9i upgrade related performance problems.
• Planed, installed, configured, set up Oracle Internet Directory (OID) for replacing Tnsnames and Oracle Names. Wrote utilities scripts to manipulate OID. Presented in JJOUG.
• Built multi master replication 4 nodes to house OID.
• Tested on Oracle Change Data Capture for Data Warehouse environment.
• Supported various data warehouse/mart.
• Database performance tuning for various applications.
• Validated databases install for various applications to satisfy FDA requirements.
• Project managed to apply Oracle security patches for all databases.
• Addressed globalization Oracle character sets issue. Propose solutions for global applications.
• Supported Oracle Financial Services Applications 11i, (General Ledger).
• Supported upgrade and performance tuning for ARIBA (Purchasing).
• Supported APIS(accounts payable) daily, upgrade and performance tuning.
• Supported E-Advantage development platform which utilize Documentum, ATG, Iplanet(SUN ONE), WebLogic and WebMethod.
• Supported ETL(Informatica) and Reporting (Cognos) environment.

Consultant

Confidential

Responsibilities:

• Provided and implemented E-Archiving solution to satisfied FDA requirement, reverse engineering data model, DDL scripts on all projects ready to be retired.
• Production support, consolidated scripts to be portable for SUN, HP and DEC, lead SCCS source code control project.
• Involved in globalization of Oracle servers. Implemented RMAN on Tivoli TSM, Veritas Netbackup.
• Consultant for GlaxoSmith Kline (1 year assignment)
• Participated Data Model design and provided Data load solution for Health Information Factory(HIF).
• Application, Database tuning for the HIF DataWarehose and DataMart.
• Utilized Data-Stage as the ETL tool, Micro-Strategy and DSS agent as front-end reporting tool. RMAN set up for backup with Tivali ADSM.
• Utilized Veritas File system, Vol. Mgr. and Quick IO on Sun E10K, Sun storage Raid 1+0..
• Install Oracle 8.1.7.2 and create databases for PIER (1400G Documentum System) on Sun-Fire with Compaq storage on Raid 1+0 together with Tivali ADSM, TSM plus RMAN for backup.
• Production support for all Replicated databases on High-Availability Compaq True64 Unix servers between UK and US.
• Production support for all US non-replicated databases on SUN, WinNT and Win2000 environment. Provide pager coverage for emergency support.
• Utilized OEM for basic DBA functions and monitor databases.

Consultant

Confidential

Responsibilities:

• Set up jobs(Data load, Export), events(Alert File, Tablespaces, Free Space … etc) on Oracle Enterprise Manager (OEM) using Management Server on HP, NT environment.
• Data Model design and Data load for Sales Forecast system.
• Upgraded Documentum and Completed all Validation documents for Documentum.
• Support Beckman LIMS system…
• Installed and created Oracle databases for Manugistic and perform IQ/OQ/PQ for VALIDATION.

Confidential

Project Manager

Responsibilities:

• Oracle DBA service for OSS project, responsible for integration of DSET, SUN System and Oracle Administration.
• Support and Trouble shooting the whole entire B2B E-Commerce environment(EDI, Perl, HTML, FireWall, JAVA, Oracle… etc).
• Setup and utilized Veritas Netbackup with Oracle RMAN hot backup.
• Utilized OEM for basic DBA functions and monitor databases.