Frank Zhu

949-***-**** (cel)

acoumb@r.postjobfree.com

Irvine, California

Database Programmer

A highly dependable, analytical, results-oriented professional with extensive database programing,

administration, report writing experiences in supporting enterprise system like SAP, BAAN, LIMS.

Extensive IT consulting project works in web platform. An Oracle certified Professional DBA with

experience in system integrations, interfacing, documentation and support.

Advanced Skills

Business Systems: SAP ECC, Baan 5, LabVantage Sql*Lims, JResultNet

Application Software: SAGE FAS, ColdFusion, HP Quality Center,

Broadvison, MS IIS

Methodologies: Software Development Life Cycle methodology(SDLC),

Agile Software development methodology,

Object Oriented Analysis & Design

Languages & Tools: CrystalReport, PL/SQL, Oracle SQLDeveloper, Oracle Application Xpress, Oracle Reports

Java Script, SAP ABAP, SQL*PLUS, SAP Solution Manager, SharePoint,

ColdFusion Script, HTML, Visual Basic, MS Excel, Project, Visio

Database-Middleware: Oracle, MS SQL Server, MS Access, ODBC, Informix

Certifications: Oracle 8i Certified Professional DBA.

Ariba Buyer 6.2 Certified Engineer

Professional History

Bio-Rad Laboratories Inc (QSD), Irvine, California

2002 – 2015

A global leader in manufacturing specialty diagnostics and QC kit products

Sr. Business System Analyst (2013-2015)

• Convert Bio-Rad QSD’s ERP from Baan V to SAP (deployment 1 and 2)

Gathered requirements and translated them into technical system requirement for PTP

workstream.

Wrote field mapping and extraction logic part of the IDD document for the PTP workstream.

Played team lead role in converting Baan data into SAP objects using Oracle SQL Developer.

• Bio-Rad new LIMS planning project

Led the team to evaluate new LIMS vendors and provided recommendation to business and

management

Facilitated various project meetings

Managed vendors and outside consultants for Bio-Rad’s LIMS systems.

Led the joint IT & business efforts in the evaluation and planning of new Laboratory

Information System (LIMS)

• Business Systems Operation Support

Monitored and backup Oracle and MS SQL database for two division systems.

Triage Production issues of various business systems and provide resolution according to SLA

Provided functional support to various systems, analyzed and translated business needs into specifications.

Collaborated with other Bio-Rad IT teams in Corporate Office such as shared services,

operations to deploy and deliver new functions to responsible business systems.

Analyzed and made improvement recommendations to business process, application features, master data change to resolve defects

Business System Analyst/System Administrator (2006 –2012)

• Led the implementation of Bio-Rad QSD’s bio-directional lab instrument interfacing project.

Analyzed requirements and designed a solution that supported new and legacy instruments.

Presented the interface architecture to business and got their buy in for the solution.

Implemented bi-directional lab instruments interfacing system using JResultnet and custom

window components.

Wrote all technical project documents which included IT project plan, validation

documentations (IQ, OQ)

Received Bio-Rad’s Spot Light Award for executing the project on time and on budget.

• Led the efforts to upgrade Bio-Rad LIMS system.

Wrote IT project and validation documents (IQ, OQ).

Built/installed the system.

Did extensive troubleshooting to fix all the technical issues

Led the team to execute the validation protocol before go live.

Oracle DBA/System Administrator (2002 – 2006)

• Implemented the Bio-Rad QSD’s LIMS system

• Created custom oracle objects: views, indexes, store procedures, triggers

• Wrote database backup scripts and developed different database backup and recovery strategy

• Developed reports using both Oracle Reports and Crystal Report to support business operations

after system went live.

• Developed Bio-Rad QSD intranet site using ColdFusion and MS SQL server.

Additional Experience

Worked at following IT consulting firms before Bio-Rad,

Deloitte Consulting/Roundarch Inc. US Internetworking, Inc,

Sage IT Partners Inc. (Changed to Xpedior) NexGen SI, Inc.

Following are some IT projects I implemented while work as an IT consultant

Project Name:

Client:

HMSA.com, eBusiness Portal Site Blue Cross &

Blue Shield of Hawaii

Rohm & Haas Corp e-Procurement System Phase I Rohm& Haas

MyMemoryStore.com

Samsung Semiconductor Inc.

Macromall.com

Macromedia Inc.

IDEAS

Memec Electronics Inc

BBO project

Bank of America

Corporate Database Project

Cal PERS

Clinical Information Management System v4.0 Amgen Inc

Contract Admin, Royalty, Licensing (CARL) Project Apple Computer

Education

BS, Electrical & Computer Engineering, University of California, Irvine

Training

SAP Education SCM500: Processes in Procurement

SAP Fundamentals

IT Project Management

Crystal Report Developer

Oracle 8i DBA training courses

Broadvision Training

Contact this candidate