Resume 16

OBJECTIVES:

A senior level Oracle developer / programmer analyst position permanent / contract on corp.-to-corp., independent or employment base in software, financial or manufacturing sectors with database, inter-/intra- net, e-commerce development or application. Willing to take part of Oracle DBA duty.

PROFILES

Highly innovative Oracle developer with DBA skill with over 10 years IT working experience in software, manufacture, R&D, academic environments, including:

• 6+ years Oracle programming / analysis / database design experiences using Developer 2000 / Developer 6/6i, Designer 2000 and PL/SQL developing large system in software environment aiming tour operation industries, warehouse management system WMS in manufacturing environment and ADP / PeopleSoft human resources applications.

• Profound understanding of entity relationship ER design and Oracle Database both from system and application sides .

• Oracle Certified Professionals OCP for both Developers and DBA.

• More than 5 years experience in modeling, architecture, designing, coding, debugging and testing instrument driver/interface and other application in manufacturing, R&D environment across various platforms.

• Familiar with the strategy, logistics and methodology for the life cycle of software development. Fair to good understanding of business processes in accounting, marketing, inventorying, manufacturing, human resource and financial.

• Good verbal and excellent written communication skills, able to relay technical information to non-technical staff and fellow developer.

• Effective team player and quick learner.

COMPUTER SKILLS

• Oracle / Database: Fluent in RDBMS, Oracle 7.x/8.0.5/8i, SQL*Plus, PL/SQL, Developer/2000 2.0/2.1/6i, Form 4.0/4.5/5.0/6, Report 2.0/2.5/3.0/6, SQL*ReportWriter1.1, PB 1.5, SQL Loader, Report Server, Stored Procedure, Graphics 2.5 and ProC, Oracle Enterprise Manager, DBA Studio, Designer 2000, Discover 3/4, ERWin 3.5, Toad v.5-7 Quest software , SQR v 4.3 , 9iAS. Knowledge of Oracle Applications and Peoplesoft

• Language: C, Java, Visual Basic 4/5 , Basic, Fortran and Assembly, Cobol, FoxPro 2.5 , Some C++

• Platforms: MacOS 7.0-9.0 , Windows NT, 2K, 9x, 3.x /DOS, Sun Solaris 2.5,2.6 , SunOS 3.5,4.0 , Citrix MetaFrame, RedHat Linux 6

• Web/Net: HTML, ASP, InterDev, JavaScript, Web Authoring, Web Server Construction, Netscape Suite / IE, Telnet, Ftp/fetch, Gopher, Internet Conferencing

EXPERIENCE:

• Creating new Warehouse Management System WMS using Developer 6i From & Report 6i in client/server and web mode on Oracle 8i databases. Designing, implementing and testing security control in various levels database, application and fine grain access control
• Participating WMS data modeling, prototype design, document preparation; Creating form templates, object libraries and generic package/stored procedures for standardization of the WMS application. Developing stored procedure based forms to integrate with legacy system.
• Designing, creating or modifying payroll, benefit and human resource applications based on Automatic Data Processing ADP / Horizon Corp s ERP application Platinum Human Resource Management System HRMS / Payroll using SQR, SQL languages in a Citrix MetaFrame environment with Oracle database and PeopleSoft backend.
• Modifying, tuning and trouble-shooting current STONE inventory and process control system with Oracle Developer 1.2 Form 4.5 and Report 2.0 and current Stash agriculture management system with Oracle Developer 6 Form 6 and Report 6 .
• Installing Oracle 9iAS middle-tier and configuring Form Server for internet deployment of current OLTP / DSS applications.
• Converting current applications total over 300 modules to version 6i in client/server and web-centralized mode. Participating architecture design and migration of enterprise wide multi-tier system with different version Oracle server backend.
• Creating Oracle databases for development and repository on IBM AIX and PC NT 4 based machines and configuring instance parameters, storage layouts, rollback segments, database links and Net8 architecture with Oracle Enterprise Manager OEM , DBA Studio and Toad; Importing and mapping data from current systems including EDI legacy system with various tools such as SQL Loader and Import / Export utilities.
• Tuning and optimizing current and new applications utilizing SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuild of indexes and creation of views.
• Assisting Senior DBA with configuring Oracle Name server, load balance and fine-tuning production database parameters and providing assistance for database related errors from individual plants across North America. Also cooperating with DBAs and production personals for annual database purge and rollover.
• Creating and implementing ad hoc reports using SQL and SQR for various users in different environments. Also providing technical supports to end users in different locations.
• Installing, configuring and administering Visual SourceSafe 6.0 for the version control of various applications

• Participated the system design business analysis, ER, and table definition of the comprehensive and complicated Centre Reservation System CRS software consisting of more than 900 modules and 300 tables, developed with Oracle developing tools in the front-end and run on Oracle databases in the back-end targeting leisure and international travel suppliers, with major subsystems including Booking, Financial, Product, Management, Costing, GDS, Sales and Operations.
• Responsible for designing, coding, modifying and debugging TourTek s Financial subsystem AP, commission, contract, GL, insurance, disbursement, recovery, supplier check ; Most of AR subprogram pricing, sales, invoice, cash receipt, refund, check printing ; Part of Inventory Management; Most of Costing section and part of Reservation, using PL/SQL, SQL* plus, Form, Report, graphics, ProC and PVCS version control tool. Have developed and modified more than 300 forms, reports, procedures/functions and libraries.
• Coded and tuned large PL/SQL stored procedures more than 20 thousand lines of codes for Payable subsystem and enhanced the performance through the fine-tune of queries and creation of appropriate indexes, tablespaces and rollback segments.
• Worked closely with QA s/testers and business analysts for development, modification and implementation of new and existing modules.
• Integrated TourTek application with VSI Fax server, report server and InterOffice to provide automatic or background process.
• Integrated Microsoft Office products Word, Excel with application program.
• Written server and client side PL/SQL procedure and scheduled the execution of large batch transaction process and massive reports through background job process and report server.
• Prepared specification and documented results for the design and development database objects; Instructed and lead new or junior Oracle developers in business rules, programming analysis, coding standards and preliminary test method.
• Helped Installation of Oracle database 8 and 8i and developer tools on server and client machines in Window NT, 9x and Unix DEC environments and configuring the Net setting. Assisted configuration and modification of database storage structures and allocation.
• Created and altered database tables, defined user roles for developing environment of 10G data size using Oracle Enterprise Manager.
• Interacted with clients through remote database connection and internet for demonstration, debug of the application in a production environment.
• Involved conversion / upgrade / regeneration of application modules from lower versions to higher ones.
• Worked on Translation Builder and compilation of resource files for the future use of TourTek application in multiple language environments under client/server or multi-tier architecture.

• Modeled, designed and programmed and debugged program for color formulation database and processing optimization software ColorMaster, SolutionOne using Access, Oracle 7.x, VB, Crystal Report and C for high end office furniture company s project.
• Converted and imported Company s unique color information database from various source access, excel and DB2 to Oracle 7.x.
• Developed new formulation using optimization software and spectrophotometer and fine-tuned the pigment/dye ingredients to match client request using drawdown and trial and error method; Input the final formulations into color database.
• Setup and integrated Colorimeter and other testing device with PCs for automatic in-line motoring of processes and products,
• Documented standard operation procedure and trained new tech members and production staff for the use of these instruments.
• Developed system maintenance utilities and automated test tools using script to improve efficiency.
• Created unit test and integrity test plans and test cases, executed test cases and documented the test results.
• Implemented existing programs by making modifications as required.

• Participated in a cooperative project of polyamines s biological function and responsible for development and implementation of the hardware and software for highly sensitive chromatographic and chemiluninescence detector.
• Set-up procedure and standard for the comparison in their sensitivity of various analytical detector and dialogistic method.
• Participated in modeling, designing and developing application software that tracks and simulates the revolution tree of living species based on their polyamine content.
• Helped setup and maintenance of the lab s Macintosh computer network through AppleTalk protocol and Ethernet card, and connected to Bitnet. Configured SCSI and SCSI-2 and other device or peripheral, as well as maintenance of IBM PC s 386,486.
• Performed weekly backup of whole research lab s data with backup tape and Retrospect.

• Designed and developed driver for automatic analytical instruments using C, Fortran and Assembly;
• Designed chromatographic and mass spectrum database for information analysis Fingerprinting using FoxBASE 2.0, 2.1 , DOS FoxPro 2.5, FoxPro 2.6 for Window, Microsoft Access.
• Instructed senior / graduate courses: the application of microprocessor in the analytical instrument

CERTIFICATIONS OCP

Oracle Certified Professional - Internet Application Developer 6/6i.
Oracle Certified Professional - Oracle Application Developer Rel. 1 and Rel. 2 .
Oracle Certified Professional - Oracle 8 DBA
Oracle Certified Professional - Oracle 8i DBA in preparation

EDUCATION AND TRAINING

Oracle Application 11i Introduction, Oracle Corporation, USA
Certificate, Oracle 8i Database Administration, Mountains College, Canada
Certificate, Java Programming, Seneca College, Canada
Certificate, Marketing, Harvard University, USA

M. S. chemistry , Michigan Tech. University, USA
B. S. computer science , Fuzhou University, China
B. S. chemistry , Fuzhou University, China

INTERESTS