Engineer Electrical

Bill(Chunshan) Gu

**** ***** ***** **, ****** Rock, AR 72211-4455

Phone: 501-***-**** Email: abhoiq@r.postjobfree.com

OBJECTIVE

To obtain a full-time permanent position as a Senior Oracle Database

Administrator

EDUCATION

( M.S. in Computer Science

May, 1998

Case Western Reserve University, Cleveland, Ohio

GPA 3.72/4.00

( M.S. in Mechanical Engineering

Dec., 1995

University of Missouri - Rolla (UMR), Rolla, Missouri

GPA 3.88/4.00

( M.S. in Electrical & Mechanical Engineering

July 1987

TongJi University, Shanghai, China

GPA 3.75/4.00

( B.S. in Electrical & Mechanical Engineering

July 1984

TongJi University, Shanghai, China

GPA 3.83/4.00

COURSE EMPHASIS IN COMPUTER SCIENCE

( Relational Database Managements ( Data Structures and

File Management

( Object-Oriented Software Development ( Computer Communication

Networks

( Interprocess Communications in Unix ( Unix Network Programming

( Computer Graphics ( Analysis of

Algorithms

( Principles of Operating Systems ( Robust Control

Systems

TRAINIING CERTIFICATES

( Oracle PL/SQL Programming, 1998 ( Oracle8 DB Administrator,

1999

( Enterprise DBA Backup and Recovery, 1999 ( Oracle8i Performance

Tuning, 2000

( Oracle10g DBA Workshop I, 2007 ( Oracle10g DBA I/II

Phase I/II, 2009

COMPUTER SKILLS

( Databases: Oracle11g/10g/9i/8i/8/7.3, Oracle11g/10g/9iAS, Oracle11g

Fusion Middleware,

Oracle10g/9iDS, Oracle11g/10g/9i Forms,

Oracle11g/10g/9i Reports, RAC,

CRS, ASM, RMAN, WebLogic11g/8i, Oracle RDB, Oracle

JDeveloper,

PL/SQL, SQL, Server2008/2005/2000/7, TOAD, T-SQL,

JDBC, ODBC, ADO,

ASP, ERwin, CASEStudio, SQL*Plus, SQLTool, OEM

( Languages: Java-J2EE, J++, C++, C, Visual C++, Visual Basic, PHP,

JavaScript, Perl,

Tcl/Tk, Python, XML, HTML, Pascal, FORTRAN-90/77

( Operating Systems: Sun Solaris, Linux, HP-UX, IBM AIX, Tru64 Unix,

OpenVMS,

MS-DOS, Windows 95/NT/2000/XP/Vista/7

( Platforms: SunBlade, SunSparc, SunUltra, HP-UX/9000, IBM

RISC/6000, DEC Alpha,

DEC Vax, IBM-PC

( Miscellaneous: Apache, IntelliJ, CVS, CSDiff, ANT, MS Office

97/2000/XP, MATLAB

AWARDS

( Certificate of Merit from LTV Corp., 1999, 2000

( Excellent Honor Student from TongJi University, 1980~1987

REFERENCE Available upon request

PROFESSIONAL EXPERIENCE

May 2010 - Present, Oracle DBA, Administrative Office of Courts, Arkansas

Supreme Courts, Little Rock, Arkansas

( Installed and configured Oracle11g Clusterware and RAC on Oracle

Enterprise Linux(OEL)

5.5; And installed and configured Oracle11g Database Server on OEL 5.5;

( Maintained Oracle11g 4-node RAC Database Server systems on Linux 5.3/5.5

servers;

( Installed and configured Oracle10g Application Server on Linux 5.5 for

forms and reports;

Developed a form used to access Oracle Report from an Oracle form without

second login;

( Developed Court Connect Web Login Page for users to login or change

password and redirect to another web server;

March 2006 - Present, Oracle DBA + SCT Banner Security, Department of

Computing Services, University of Arkansas at Little Rock, Arkansas

( Installed and configured and maintained Oracle10g/9i Database

Server systems on Solaris 10/9 servers; Created Oracle10g/9i databases on

Solaris 10; Migrated databases from Oracle 9i to Oracle10g; Tuning database

instances and improving database performance; Rebuilt/compressed indexes;

Configured invalid objects;

( Installed Oracle10g Application Servers on Linux RHEL5/4 servers;

Configured Oracle10g Forms/Reports and Web Applications on RHEL5/4 servers;

( Maintained SCT Banner Security System for MIS system, installed

Banner8/7 on Linux Servers ES 5.0 and upgraded patches; Migrated SCT Banner

Security System from version 7 to version 8;

( Implemented Oracle RDBMS and Databases backups; Refreshed Oracle

databases for testing and development routinely;

( Built Oracle11g/10g/9i Data Guard system on Solaris Server for

Disaster Recovering System and maintained standby database servers;

( Built standby Oracle10g Application Server on Linux Server for

Disaster Recovering System;

( Developed and built Oracle10g/9i LogMiners for recovering and

tracking Oracle10g/9i Database Servers;

( Developed Oracle custom forms for Intelligent Card project; Added

some new functions to

Banner Oracle forms;

( Practiced Oracle RAC on VMware on Windows XP/7;

June 2004 - March 2006 Sr. Database Applications Developer, CBM

Information Systems, Little Rock, Arkansas

( Designed and programmed Oracle PL/SQL stored packages on Oracle9i/10g

Database Server for SONET Java to provide automated transaction and

reporting solutions for regional Bell Operating Companies (RBOC). Tuned

and debugged PL/SQL code packages; Setup Oracle8i/9i/10g database

instances and development environment for SONET Java; Migrated data from

older database servers to newer database servers based on Sun Solaris9/10;

( Programmed and implemented independently GUI(Graphical User Interface)

SONET Java applications using Java Swing/AWT and J2EE/JDBC to provide a

reliable, easy to use interfaces for navigating RBOC synchronous inventory

records. SONET Java contains SCID Tree diagram to give high level view of

nodes (ADMs), regens, fiber cross connects, carrier mountings, and cables.

The GUI application has easy navigation with left-click to drill-down in

place and right-click to open a new window with details. Developed table

windows for various reports with print, save, copy, etc. functions. More

than thirty table reports can be displayed by simply selecting report item

in place.

( Implemented Disaster Recovery System (DRS) Java reports using

J2EE/Java, PL/SQL, JDBC to provide critical information of over fifty

reports on facilities, customers, cables, rerouting and FCC priority

circuit issues.

( Developed and programmed customized InstallShield installation

interfaces based on Java to install SONET Java and DRS for Windows end

users;

May 2003 - May 2004 System Analyst, CBM Information System, Inc., Little

Rock, Arkansas

( Developed and implemented three-tier applications based on Oracle9i

DB Server and Oracle9i Forms using PL/SQL, Applet, Servlet, EJB and

J2EE/JDBC. The applications take input parameters from Oracle Forms and

pop-ups applets with graphical drawings which data comes from Oracle9i

RDBMS.

March, 2002 - May 2003 EDI(Electronic Data Interchange) Engineer,

Benefitfocus.Com, Charleston, South Carolina

( Designed and developed EDI creation packages for Oracle8i/WebLogic6-

based, multi-tier database application used for Benefit Open/Current

Enrollment, COBRA and Open Enrollment to Current Enrollment migration using

Oracle PL/SQL, J2EE, TOAD, Perl DBI. The product is currently used for

Blue Cross and Blue Shield of South Carolina, Blue Cross and Blue Shield of

North Carolina, Blue Cross and Blue Shield of Kansas City. The project

started from developing and implementing triggers, functions, procedures,

packages and views, which automatically audited any changes to base tables,

built up transaction histories and if necessary, compared current

transaction with extracted histories. Any changes made to base tables

could be recorded and extracted to health carriers by some utilities such

as extractors, EZRead developed by Java, JDBC, Perl, etc.

( Designed and developed an EDI creation package for

Oracle8i/WebLogic6-based, multi-tier database application used for Payroll

using Oracle PL/SQL and JAVA and TOAD. The product is currently combined

with Benefit Enrollment for some employers from South Carolina, North

Carolina. The project used triggers, functions, procedures, packages and

views, which automatically audited any changes to payroll tables. Any

changes made to payroll tables could be recorded and extracted to clients

by some utilities developed by Java.

( Designed and developed an EDI creation testing system using PERL

DBI, PL/SQL. More than 40 scenarios were developed and used to

automatically create and test some reason codes created by EDI Creation

based on changes made to base.

Jun. 98 - Dec. 01 Programmer Analyst / Database Developer, Computer

Process Control (CPC) and Networking Department, LTV Corporation,

Cleveland, Ohio

( Modeled, designed and implemented Oracle Data Warehouse databases

with distributed transactions in ERwin, PL/SQL, SQL*Net, C/C++ and FORTRAN

on Windows, Unix and OpenVMS computers, which were used to collect and

store products information. Developed application codes in VB6, VC++ to

retrieve and manipulate data, based on ODBC.

( Modeled and designed and developed an EPA (Environmental Protection

Agency)

Distributed Database implemented in SQL, C/C++ and FORTRAN on Alpha Server,

which remotely collected data about EPA into Oracle RDB database server

from several locations by TCP/IP and DEC Message Queue. Programmed some

codes used to calculate and process statistic data hourly and daily.

( Modeled, designed and developed 2-tiered, 3-tiered Oracle8i

DataMart databases used to record quality data about products, using

PL/SQL, JDeveloper, ERwin, Java, J++, JDBC, Perl on Windows and Unix

machines.

( Maintained and performed tuning on Iron Producing and Blast Furnace

databases of Oracle8i DataMart and coil finishing databases of Oracle RDB

Data Warehouse. Adjusted some parameters in the file init.ora and

generated tracing files for diagnostic purposes for the databases.

( Developed and implemented a Predictive Pacing Database on Oracle

RDB server in ERwin, PL/SQL, C and FORTRAN on Windows and OpenVMS computers

to collect products data from several locations. The data was calculated

and converted into daily and three-turn summary tables respectively.

Predictive Pacing and delay summary reports were updated and posted on web

every hour.

( Developed and implemented a products tracking system using Java,

JDBC, JavaScript and XML, which was used to track coil products on line and

display graphs and charts on web.

( Developed and implemented "Foundry Switch Baseline Utilization"

using VB6, VC++, Transact-SQL and ODBC. The project was used to collect

and calculate Layer Two switches' utilization data port by port, remotely

send all calculated statistic data to SQL Server. XML and HTML codes were

programmed and installed on a web server in order to remotely review the

utilization data or charts for any port of a switch by web browser or MS

Excel/Access.

( Developed a package of utilities using VB6, Perl, Tcl/Tk and SNMP

techniques, which consisted of "Monitoring Bay Router Status", "Monitoring

Foundry NetIron Router and FastIron Switch Status", "Monitoring 3Com Hub

Status", "Getting interface information", "Getting hub MAC addresses",

"Discovering Devices by SNMP", "Ping Fails Summary", etc.

( Developed applications communication between HP-UX/9000 and DEC

VAX/Alpha machines using C, C++, Fortran, TCP/IP and DEC Message Queue.

Jan. 96 - Dec. 96 Software Engineer, Charles Birnstiel Consulting

Engineer P.C., New York

( Teamwork: "Dynamic Analysis of Structure Deformations",

programming, debugging and testing in C++/OOD/OOP.

Aug. 93 - Dec. 95 Research Assistant, Department of Mechanical & Aerospace

Engineering & Engineering Mechanics, University of Missouri - Rolla

( Thesis: Control of Highly-Deformable Shell Structure with Embedded

Smart Materials

( Developed and programmed Nonlinear Finite Element Analysis codes to

analyze shell dynamic deformation in Fortran-77 and C.

Jul. 87 - Aug. 92 Electrical Engineer, Dept. of Subway Car, Shanghai

Metro Corporation

( Designed and analyzed the Circuit Control System & Brake Control

System of Subway Car

OTHER ACCOMPLISHMENTS

( Designed and developed an Intranet Monitoring System in Perl,

Tcl/Tk, VB6, SNMP and MIBs on Windows NT machines, which was used to detect

all critical IT machines like routers, switches, hubs, servers in Cleveland

Works, LTV. The system utilized "ping" and "tracert" to collect

continuously information about all remote monitored IT nodes, and decided

every subnet's status after logical calculation based on a complex diagram.

Every subnet's variable GUI status was updated and shown on a screen on

time.

( Developed and programmed "Distributed Talk WhiteBoard with Drawing

and Search Supports" (Server and Client in JAVA). The code package was

developed in java.net, java.lang.Thread, java.io, java.AWT/Swing,

java.Beans, java.util, java.applet, etc. packages.

( Implemented and programmed "Three-dimensional Transforms and

Viewing Pipeline of Graphics" in C/C++ on Sun Solaris machine.

( Developed an "Internet Shell with Server and Client using Sockets"

in C/C++. The operation of the code was broken down into several main

sections: Parsing; Performing socket redirection; Dealing with signals;

Background processing; Executing built-in commands, pipelines, sequence of

commands.

( Developed a multi-user chat software in JAVA with Graphical User

Interface.

( Teamwork: Developed a "Distance Online Learning Tool" in Java on

demand to provide the desired functionality, which included use of video,

audio feeds, a document viewer, a shared whiteboard and a chat area. The

program helped faculties conduct classroom activities in remote locations.

The video allowed a instructor to transmit his images to students via a PC

based video capture card; The audio transmitted the instructor's speech to

students; The viewer allowed the instructor to transmit multimedia

presentation through an Adobe PDF document viewer; The shared whiteboard

allowed the instructor and students to sketch out their ideas; The chat

area allowed the students to exchange questions and comments with the

instructor.

( Developed a multi-player game over the X-windows in C/C++, which

could be played on remote locations.

( Designed a travel ticket system in O2 C and O2 DBMS, which included

seat reservations, prices depending on the distance and departure date,

discount and surcharge depending on the speed. Programmed classes and

interfaces and their methods corresponding to each kind of ticket. Queries

in O2 SQL were executed in O2 OODBMS.

Contact this candidate