Over ** 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. Big Data NOSQL
M.S., Computer Science, Stevens Institute of Technology, N.J. USA 1986
B.S., Applied Mathematics, Fu-Jen University, Taiwan, 1985
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: Python, VMWare, Oracle APEX, SAP NW, Qlik, Tableau, Cognos, 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), Teradata, Redshift, HBase, Informix, Sybase, Total
Partner for Johnson & Johnson (2003 – current)
Supported 18 Tera Bytes Corporate Enterprise Data Warehouse(EDW ODS), Master Data database (MDM) and various Data Marts in Oracle. Dimensional modeling with Star schema and Snow flake using Irwin. Set ETL strategy.
Perform Data Mapping, Data Governance, Data Modeling, Performance tuning on SQL Code design, Memory and CPUS capacity.
Architect on Schema-on-Read Enterprise Data Lake, Big Data project, data architect design, install Cloudera on Apache ECO System with full software stack such as Python, Sqoop, HUE, Impala, MapReduce, Hive, Pig, with YARN on HDFS (Hadoop File System), Teradata, Oracle, Amazon Redshift Cloud Data Warehouse. NOSQL Hbase.
Together with Talend, Informatica for ETL, and Qlik, Tableau for visualization. Utilized Cloudera Navigator for Meta-management.
Coverting Informatica and WebMethod jobs to work on Hadoop, created tables in HIVE.
Follow JNJ SDLC standard.
Implement and Provide guide line of Information Asset Protection Policies(IAPP) and Sarbanes Oxley (SOX) standard.
Implement and Provide Guide line of FDA validation.
Conduct remediation for post-auditing.
Migrate Oracle from HPUX to VMWare RED HAT Linux Johnson and Johnson Cloud, built Oracle Software as a Service(SaaS) using DataPump for 1 TeraByte Databases, Golden Gate, Rman plus conversion for databases larger than 1 TeraBytes
Responsible for managing, leading BASISs, DBAs, install, upgrade, migrate SAP systems for the entire Johnson and Johnson 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.
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.
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 (Physician Sunshine Act Tracking and Reporting system)
Responsible all aspect of activities:
Architect database platform solution.
Logical / Physical data model design, data mapping using Erwin. Follow JNJ SDLC standard
Set integration strategies, integrate Totality to various systems, Employee, Customers, Suppliers, Purchasing, Accounts Payable, Global Expenses… etc.
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 for AstraZeneca. (4 months assignment)
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 DataWarehouse 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 126.96.36.199 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. Follow GSK SDLC standard.
Consultant for McNeil Healthcare (Johnson & Johnson) (2 years on/off assignment)
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.
Consultant for Commonwealth Telephone (6 months assignment).
Project Manager for conducting various version of Oracle upgrade to Oracle 8, Oracle 8I on HP, SUN, Digital Alpha utilized Export/Import, Oracle migration tool.
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.
Partner for Wyeth-Ayerst Laboratories (2 years assignment).
Project Manager for Year 2K project, Responsibilities at Wyeth-Ayerst Laboratories:
Established Y2K lab, Established Y2K certification standard. In charge of Y2K compliant for all Oracle databases and its applications on Sun(Solaris), HP(HPUX 9,10), Alpha(OSF), VAX(VMS).
Outlined tasks, methodologies, scheduling, budgeting and resource control. Developed Testing strategies and procedures. Technical lead for all Y2K programmers, performed integration for all applications. Y2K Oracle testing includes Backup/Recovery, Export/Import, Replication, Date manipulation, SQLLOADER data load, PLSQL & SQL scripts, Upgrade of Oracle 7 to Oracle 8.
Harmonized and leveraged services from infrastructure groups.
Hired and Managed Oracle, SQL Server DBAs for Y2K team
Coached, Mentored, Motivated, and Directed team members.
Partner for Computer Sciences Corp.(3 years assignment).
Database manager, Responsibilities at CSC JCALS center:
Joint team with CSC to Create and scope content in response to RFP’s, Proposals and SOW’s to Government sectors.
Architect system integration solution.
Architect database platform solution.
Built Oracle DBA team.
Hired Oracle DBAs, training and distribute work load.
Wrote DBA Standard operating procedures, Service Level Agreement.
Coached, Mentored, Motivated, and Directed team members.
Harmonized and Provided services to Data Architect, Application, Integration teams and General Users.
Member of the proposal team, responsible for all Database related area, including pricing, technical direction evaluation and prototype implementation. Daily Database support, maintenance, installation, performance tuning, database creation, data loading, Data conversion, backup and recovery to support. Built Heterogeneous Distributed Databases system utilized Oracle V7.
DoD Clients relationship management. Follow DoD SDLC standard
Consultant for Unisys/HTI(4/92 – 8/93) Software Engineer
Burlington Coat Factory Warehouse, Inc.(8/88 – 4/92) DBA/Software Developer
Design develop Supply chain solution for distribution center/
ComInfo Inc.(2/88 – 8/88) Software Engineer
Office of the Future, Inc.(5/86 – 1/88) Programmer
Reference available upon request.