Janice Lau

**** ********* ****, *******, ** *****

acgg3r@r.postjobfree.com ? 510-***-****

SUMMARY

. Over 10 years of Oracle database development and administration

experience with expertise in data architecture and normalization

strategies, PL/SQL and SQL tuning

. Seasoned developer and technical project manager capable of leading

requirement analysis, technical design and implementation planning

. Certified Oracle DBA with in-depth knowledge of database server

architecture, memory structures, query plans, query rewrites and tuning

parameters

. Extensive experience in object-oriented programming (PowerBuilder) with

knowledge of JAVA

. Exceptional analytical thinker adept at identifying issues and resolving

problems with innovative solutions

EXPERIENCE

Appslogic (Contractor)

Database Architect Dec 2013-

Present

. Review database architect for various JAVA based applications to enhance

data flow

. Identify and tune inefficient SQL and processes

. Develop complex PL/SQL packages, functions, stored procedures and

triggers

. Develop new interfaces to extract and receive data from other

applications with various formats, XML, flat file, etc

Quantitative Medical Systems, Emeryville, CA

Database Architect and Administrator Mar

1998-Dec 2013

. Work with engineering team to architect database designs and application

data

. Develop complex PL/SQL packages, functions, stored procedures and

triggers for billing and clinical applications

. Identify and tune inefficient SQL and processes

. Install, configure and maintain internal and client billing and medical

record Oracle 10g databases

. Develop and implement high-availability and disaster recovery strategies.

Create procedures and implement periodic testing of the strategies;

utilizing standby database, RMAN backup and cold backup

. Proactively monitor database system and SQL performance

. Establish best practices and develop policies and procedures that governs

the use and maintenance of company database assets

ACHIEVEMENTS

. Develop and deploy new feature in medical billing application to satisfy

federal sequestration requirements within 2 months

. Evaluate reporting suite and tune reporting performance to decrease

process time by 50%

. Design new auditing features to compile with CMS HITECH requirement

. Plan, evaluate and test upgrade from Oracle 10g to Oracle 11g

Technical Lead/Engineering Manager

. Develop and execution of project work plans, making ongoing revisions to

meet changing needs

. Direct development team efforts to achieve team and product development

goals, objectives and milestones

. Share database administration responsibilities with the primary DBA.

Install, configure and maintain internal and client Oracle 9i and 10g

databases for billing and medical record. Identify and tune inefficient

SQL and processes

. Enhance billing and clinical applications using PL/SQL packages,

functions, stored procedures and trigger for backend, and Powerbuilder

for frontend

. Analyze new client enhancement requests and regulation requirements from

Center for Medicare/Medicaid Services and collaborated with senior

managers to define product requirements to meet functional client needs

. Review technical feasibility and worked with team to develop timelines

for product development

. Manage direct-reporting engineering team, including software engineers,

network and database administrators

Software Engineer

. Maintain and enhance an integrated billing and clinical application for

the dialysis industry

. Analyze client requirement and designed new features for the applications

. Review new regulations and coded application using PowerBuilder

. Develop the PL/SQL packages, functions, and stored procedures

. Install, configure and maintain internal and client Oracle 8 and 9i

databases for billing and medical record.

EDUCATION

MS Computer Science, 2000

California State University, East Bay (Hayward)

BS Business Administration, 1998

California State University, East Bay (Hayward)

Certified Oracle DBA, 2002

Contact this candidate