Data Architect

Summary

Over ** years of proven data processing experience, 19 years in Pharmaceutical industry and Supply chain industry, including People Management, Project Management, Logical and Physical OLTP Data Modeling as well as Dimensional Modeling, Systems Integration, Big Data SQL, NOSQL. 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. Dedicated risks and problems mitigation, fire fighter, Also a change agent, be able to quickly adopt and apply new technologies.

Application Data Architect, Solution Architect, Database High availability includes, Oracle RAC, ASM, Oracle replication, Oracle Data Guard, Hardware failed over, Business Continuance Volume (BCV) backup.

Education

M.S., Computer Science, Stevens Institute of Technology, N.J. USA 1986

B.S., Applied Mathematics, Fu-Jen University, Taiwan, 1985

Hardware: AWS, Azure, 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, Solr, 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 – 19c), MongoDB, Teradata, Informix

Professional Experience:

Employee of Johnson and Johnson (12/2021 – 12/2024)

Data Architect lead team of 10 for WMS enhancement, utilize IRWIN to create new addition model for new enhancement based on the functional requirements.

Mentoring / Coaching team members on technical solutions and directions.

Ensure projects on time, o budget delivery.

Conduct Data Mapping, Data Governance, Data Profiling, Data Validation. Document Data Lineage.

Oversee overall technical solution design, integration.

Ensure HIPAA PII compliance

Created architecture diagrams, data flow diagrams for integration.

Provided Stakeholder with charts using MS Excel Pivot tables

Support integration, data mapping for Warehouse Control System utilized Distributed database Method.

Collaborate closely with product owners and stakeholders to prioritize features, manage dependencies.

Redesign and support integration, data mapping, data roadmap, data validation for HR, MDM, SAP Order To Cash, FedEx, UPS and other vendors for JNJ.

Oversee daily fulfill incidents and requests.

Solution Architect for migrating HPUX, WINDOWS, Linux, Oracle, MARC to AWS Cloud environment for proof of concept.

Lead cross functional teams and drive to a solution that addresses the business needs.

Data Architect lead for Digital Contracting project. Implemented 3 Clouds ModelN SaaS solution on JNJ AWS, ModelN AWS and IBM cloud .

Ensure projects on time, o budget delivery.

Collaborate closely with product owners and stakeholders to prioritize features, manage dependencies.

Lead cross functional teams to drive them to a solution that addresses the business needs.

Fully integrated with MDM, USROTC, ICS, CESR(Data Warehouse), Sales Mart, HR AP, FTCC, CCRA.

Redesign and ETL all Contracting related documents from Oracle Blob to MongoDB.

Utilized AGILE methodology, Solution architect for leading ModelN projects, create, maintain user stories and backlogs, host Scrum and Sprints sessions. Write user stories, use cases, prioritized backlogs.

Consultant for Johnson & Johnson (2003 – 2021)

Migrated JNJ Enterprise Data Warehouse to CESR on AZURE cloud.

Data Architect supported 18 Tera Bytes Corporate Enterprise Data Warehouse, Informatica Master Data Management database (MDM) and various Data Marts in Oracle. Dimensional modeling with Star schema and Snow flake using Irwin.

Maintain data model and set ETL/ELT strategy for Data Source, SAP Order To Cash, Government Pricing, Medicare, Medicaid.

Review, integrate new data source to existing EDW with Data Profiling, Data Mapping, Data Validation and Data Modeling.

Expert in Performance tuning on SQL Code design, database, hardware Memory and CPUS capacity.

Data Architect/Solution architect for subscribing data from JNJ Enterprise Hadoop Data Lake and Enterprise Data Grid, In charge of Data Mapping, Data Governance, Data Validation, Cleaning. Set strategies and roadmaps for ETL and ELT.

Utilized Informatica, Python for ETL, and Talend, Qlik, Tableau for visualization.

Utilized Cloudera Navigator for Meta data-management.

Integrate EDW with various JNJ systems.

Follow JNJ SDLC, AGILE standard.

Data Architect/Solution Architect for J&J Pharmaceutical Services, Project Totality (Physician Sunshine Act Spend Tracking and Reporting system)

Responsible all aspect of activities:

Architect application and database platforms solution.

Logical / Physical data model design, data mapping using Erwin. Follow JNJ SDLC standard

Set integration strategies, integrate Totality to various systems, HR, Customers, Suppliers, Purchasing, Accounts Payable, Global Expenses, MDM… etc.

ETL architect.

Business Analysis.

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 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. 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.

Contractor 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.

Contractor 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.

Contact this candidate