* Design Oracle databases on various UNIX OS environments* Develop back end database functions* Design/Implement various data warehouse projects* Data Architect* Cloud Computing AWS Architect

-- Production DBA-- Development DBA-- Data Architect-- Data Modeler-- SQL Performance Tuning-- PL/SQL Developer

Database Architect, AWS Cloud Architect

- Led the project of converting multiple applications from Oracle OAS server to Oracle 9iAS server (WIN2000, SUN Solaris 2.8)- Designed the architecture of proxy server/application server/database server based on Oracle 9iAS technology by using Apache, Jserv, Reports, Forms, and PL/SQL Gateway- Installed and configured Oracle 9iAS on development, testing, staging, and production environment

- Used Erwin for data modeling to replace existing Ingres database - Developed all DML for production release - Performed Database upgrade and applied patches (download from Metalink) - Designed data conversion tools from Ingres to Oracle by using Sqlldr, Oracle/Ingres Gateway, Java, and database link - Helped production DBA with tuning of PL/SQL and SQL code based on Oracle 8i (TKPROF, EXPLAIN_PLAN) - Developed Java Stored Procedure by using Oracle 8i JVM on Sun OS 5.6 - Designed the architecture of authentication from Oracle to Netscape LDAP - Developed multiple classes by using Oracle JPublisher

- Lead a team of 5 developers- Managed to deliver the project on time and met the design specification- Managed the whole life cycle of eBusiness project from design, QA, integration to production release- Wrote function and design specification- Implemented a new search engine using Oracle 8i, PL/SQL, Java, and Verity API- Designed the queuing mechanism for the data synchronization between Oracle tables and search collections- Designed 3-tier architecture for the search engine- Wrote shell scripts to maintain the data between Oracle and search collections - Helped DBA with SQL performance and tuning

- Implemented Enterprise-wide information system based on PSDI MAXIMO software which contains OE, INV, Work Order, Maintenance Tracking, Planning, Scheduling modules - Wrote interface programs between Oracle 7.2 in AIX and JDEdwards in AS/400 - Wrote stored procedures and triggers in Oracle to handle interface between MAXIMO (Oracle in UNIX) and JDEdwards (AS/400) - Wrote shell scripts to synchronize data between Oracle (AIX) and JDEdwards (AS/400) - Installed Oracle 7.X on multiple IBM PowerPC AIX 4.x servers - Administrated Oracle multiple Database Servers (Oracle 7.X) and IBM AIX 4.x - Converted data from multiple PC databases into Oracle Databases - As an Oracle DBA supporting multiple production Oracle Databases

- Implemented Enterprise-wide information system based on Avalon 9.x software which contains AR, AP, OE, PUR, MRP, SF, GL, INV - Conducted data conversion from UNISYS into Oracle database - Designed client/server architecture based on MS Windows and X-Window environment - Installed Oracle 7.1.4 and helped FSI DBA with Oracle administration - Helped HP-UNIX system administration with UNIX/Database server related administrative task - Helped system analyst with business process re-engineering - Developed a catalog system to help Oracle DBA managing more than 1000 Oracle tables, 4000 triggers and 5000 stored procedures - Tuned Database based on record size and database parameters - Converted more than one million records from UNISYS COBOL environment into 1000 Oracle Tables- Designed Internet/Intranet Architecture

- Designed and implemented Time Card system based on Paradox 3.5/4.0,which keep track of various Implementation Projects, Development Projects and Miscellaneous Projects; Time Card system also used for billing, software capitalization, tax credit tasks management tool for each department