Objective
A Database Administrator, Database Developer and Database Architect position utilizing my skills in:
Highlights of Qualification
Major Achievements:
-
8+ years of practical experience in designing, implementing, and managing mid to large-scale client/server solutions and projects.
-
Well experienced in technical breadths that include Database Design and Architecture (SQL Server, Oracle, Sybase, Legacy Systems), and application development (VB, MTS).
-
Some experience in Internet/Intranet Application Development (IIS, VBscript, XML).
-
Lead Database Architect and Developer from October 2001 to March 2006 at City of Hope Medical Center, Duarte, California.
-
DBA Consultant from May 2000 to October 2001 at California Medical Association, San Francisco, California.
-
Lead DBA and Developer from November 1997 to April 2000 at NextOffice.com, San Francisco, California.
-
Programmer/Analyst from 1997 to October 1997 at Genentech, Inc., South San Francisco, California.
-
Programmer/Analyst (IS Office of the Chancellor as part time) from February 1994 to May 1996 at University of California at Berkeley.
-
Junior Database Developer from August 1991 to September 1993 at Hikari Tsushin Co.,Ltd. Tokyo, Japan.
-
Analytical and practical experience in database architecture, application development and cross-platform environments.
-
Tools: C++, VB , Oracle 8i, MSQL, XML, VHDL, P-Spice, constantly improving relational database skills.
-
Speaking and writing ability in French, Spanish, and Japanese; currently learning Chinese (Mandarin)
-
Member of IEEE for 8 years.
Accomplishments:
Lead Database Architect and Developer(October 2001 to March 2006)
manage a 12-member team of DBA and developers
work closely with System Analysts
ensure lifecycle of multi-platform projects
ensure high availability and scalability of databases
DBA Consultant(May 2000 to October 2001)
-
Designed backend architecture and developed security modules for a third party healthcare company (cv writing service) that provides identification and authentication solutions to medical professionals and organization, allowing them to conduct business on the internet.
-
Involvement in implementation (along with VeriSign Developers) of an environment that assigns (using IIS and Web based applications) digital certificates as a source universal electronic ID for licensed healthcare professionals. The final product allows them to send and receive encrypted e-mail, digitally sign contracts, prescriptions, and clinical documents, and access restricted web sites.
Lead DBA and Developer (November 1997 to April 2000)
-
Supervised a small group of developers and designed/implemented a B2B web site that specializes in the sale of high-end home and office furniture.
-
Involvement included designed of database architecture, development of in-house tools and strategies for cross platform environment.
-
Has designed and implemented (with the help of DB administration) dB schema, store producers, dB error checking, normalization and automation of data export/import from legacy systems for dB architecture.
-
Has designed in-house tools that allow users to manually enter and edit data onto database using a web browser or a stand-alone application.
-
Has contributed to all development aspects (front-end and back-end) of the website (nextoffice.com) from the ground up.
Programmer/Analyst
Genentech, Inc. (March 1997 to October 1997)
-
Has implemented a cross-platform environment for data analysis, data input/output and Web access capabilities.
-
Main tasks of project included: redeveloped store procedures for Oracle dB (from R-Basic), designed dB architecture and developed applications with embedded error checking to minimize intervention.
University of California (February 1994 to May 1996)
-
Has implemented a data warehouse environment to serve the information needs of the University of California.
-
Main tasks included upgrading database (from legacy system to Sybase dB) for Budget and planning department, database for student records and implementation of cross platform environment to meet the needs of the various departments within the Chancellor’s office.
-
Cross platform included Mac OS, Windows, OS2 and Unix.
-
Has involved in selecting various third party tools (brio Tools, Paradox, MS Access and FoxPro) for data querying.
Junior Database Developer (August 1991 to September 1993)
Experience:
Lead Database Architect and Developer –October 2001 to March 2006
City of Hope Medical Center, Duarte, California
-
Tuning, Normalization, Architecture (Physical and Logical Modeling), Replication.
-
Maintain large databases; up to 800 Gb of data
-
Back up and Recovery strategies.
-
Data Warehousing (Architecture, OLTP, OLAP, and ETL)
-
Metadata Repository Services
-
Development (DTS, ADO, OLE, ODBC, and SQL-DMO API,)
-
Developed databases for analytical processing of various cancer and diabetes related diseases.
-
Designed back end architecture for Microsoft SQL, Oracle and Sybase databases (including normalization, triggering, modeling and error checking procedures)
-
Developed in-house tools to extract and import data from/to MSQL, Oracle, Sybase and legacy databases.
-
Created data Repository environment and Metadata Services
Tools: MS SQL Server (main DB environment), Sybase, Oracle 8i (PL/SQL and SQL Plus), SDK v 1.3.0, XML, VB, Access 2000, ASP, ADO, etc
DBA Consultant--May 2000 to October 2001
California Medical Association, San Francisco, California
-
Designed Database Architecture (SQL Server)
-
Developed modules in C that extract/import and encrypt client’s digital signature using VeriSign certificates
-
Implemented and developed Database triggers, store procedures and normalization
Tools: SQL Server, IIS, C, ASP, Vbscript and HTML
Lead DBA and Developer ---November 1997 to April 2000
NextOffice.com, San Francisco, California
-
Developed real-time database application for data entry purpose. Database was used simultaneously in three different states and for telecommuting purposes.
-
Designed back end architecture for Microsoft SQL and Oracle databases (including normalization, triggering and error checking procedures, back-up strategies and scalability)
-
Developed in-house tools to extract and import data from/to MSQl and Oracle databases.
Tools:SQL Server (6.5 & 7.0), Oracle 8i(PL/SQL and SQL Plus), SDK v 1.3.0, XML, VB, Access 2000, ASP.
Programmer/Analyst -- March 1997 to October 1997
Genentech, Inc., South San Francisco, California.
-
Developed filters that allow the transfer of data from an HR-1 server to an Oracle server
-
Created graphical interface for system
-
Automated various task to enable users to view data in different formats
Tools: R-Basic, Perl, C-shell, Oracle 7 (PL-SQL SQL*Plus), MSQL 6.5, ASP, VB
Programmer/Analyst (IS Office of the Chancellor)— Part Time Position, February 1994 to May 1996 University of California at Berkeley
-
Implemented cross-platform client/server environment
-
Developed in-house tools for data retrieval and analysis (mainly for statistical and budgeting purposes)
-
Developed applications for client and host machines.
Tools:Sybase, c-shell, ISQL, C, VB, Brio Tools, Fox Pro
Junior Database Developer —August 1991 to September 1993
Hikari Tsushin Co., Ltd. Tokyo, Japan
-
Developed database applications for 4th Dimension, MSQL and Oracle environments
-
Co-wrote software for a business-card-reader device; includes software and hardware design
-
Researched new client/server technology and negotiated distribution contracts with foreign vendors.
Tools:C, Assembly, MSQL, Oracle, 4th Dimension, MS Access
Education
University of California, B.S. in EECS. May 1996.
UC Berkeley Extension, various computer related courses (Java, Oracle)
Employment History
City of Hope Medical Center, Duarte, California (2001-2006)Lead Database Architect and Developer
California Medical Association, San Francisco, California (2000-2001) DBA Consultant
NextOffice.com, San Francisco, California (1997-2000) Lead DBA and Developer
Genentech, Inc., South San Francisco, California (March 1997-October 1997) programmer/Analyst
University of California at Berkeley (1994-1996) Programmer/Analyst
Hikari Tsushin Co., Ltd. Tokyo, Japan (1991-1993) Junior Database Developer