Oracle Sql

Yimin Zhang

**** ********* ****

Carmel, IN ***32

Phone: 317-***-****(C)

317-***-****(H)

Email: ********@*******.***

WORK STATUS: Permanent resident of the United States

OBJECTIVE

System Analyst/Software Developer position involving Oracle/XML/Visual

Studio .NET Design, development and maintenance. Expert at Oracle 9i,

Oracle 10g, Oracle 11g, Oracle Forms and Reports (12 Years), Oracle

10g Applications, PL/SQL (14 Years), Stored Procedures, XML, Visual

Studio .NET(2 Years),UNIX Scripting (5 Years), Sybase (6 Years),

Microsoft SQL Server, COBOL(2 Years), Oracle Financial (2 Years)

SKILL SUMMARY

> Oracle 9i,10g,11g: Stored Procedure, SQL, PL/SQL, SQL Performance

Tuning (14 Years)

> Oracle Developer Tools: Oracle Reports 6i/9i/10g, Oracle Forms

6i/9i/10g (12 Years)

> Oracle Application Server 10g

> Oracle Application: Human Resources, Financial (2 Years)

> XML (4 Years)

> Microsoft .NET (2 Years)

> Microsoft SQL Server: Stored Procedure, SQL, PL/SQL and Performance

Tuning (4 Years)

> User interface Design (5 Years)

> Web design, XML, ASP (3 Years), JAVA, HTML

> Sybase 11: Stored Procedure, SQL, PL/SQL and Performance Tuning (6

Years)

> COBOL (2 years)

WORK EXPERIENCE

2007.10 - Present

Application System Analyst Programmer - Specialist

State of Indiana, Department of Revenue

Indianapolis, Indiana

Sr. Oracle Developer (Contract to the State of

Indiana DOR)

Knowledge Services, Inc

Indianapolis, Indiana

Major Responsibilities:

1. Implementation of application functionality, resolution of

user issues, and development of

Oracle forms, reports, PL/SQL procedures, SQL and shell

scripts.

2. Responsible for complex Oracle PL/SQL programming including

writing Stored Procedures,

Functions and Packages.

3. Development, Implementation and Maintenance of Oracle/XML

applications for Indiana

Department of Revenue Fuel Tax Division.

4. Currently developing .NET application for Indiana DOR Intax

upgrade project (.NET, MVC, jQuery).

Major Projects:

1. Indiana Fuel Tax EDI automation system

2. Fuel Tax Special Fuel Tax Crosschecking

3. Fuel Tax Motor Fuel Tax Crosschecking

4. Indiana Individual Tax Processing System

5. Indiana Streamline Sales Tax system

6. Indiana Intax system upgrade

2005.9 - 2007.10

Systems Analyst

Accenture

Indianapolis, Indiana

Major Responsibilities:

1. Implementation of application functionality, resolution of

user issues, and development of

Oracle forms, reports, PL/SQL procedures, SQL

and shell scripts.

2. Responsible for complex Oracle PL/SQL programming including

writing Stored Procedures,

Functions, Database Triggers and Packages.

3. Complete all phases of complex development assignments

including testing and debugging.

4. Identify and resolve coding problems related to systems and

procedures.

5. Analyze & document procedures for existing and new

applications.

6. Database SQL performance tuning.

7. Use TOAD, SQL Navigator to write query and create table,

index and users.

8. COBOL Programming.

Major Projects:

Unified Tax System for Department of Taxation of

Nevada (Oracle 9i, Oracle Forms Builder 9i, Oracle

Reports 9i)

2004.2 - 2005.8

Software Engineer

Computer Task Group

Indianapolis, Indiana

Major Projects:

1. Indiana State Tech Ed System (Oracle 9i, Oracle 10g, Oracle

Forms Builder 6i, Oracle Reports 6i)

2. Indiana State Contract Tracking System (Oracle 9i, Oracle

10g, Oracle Forms Builder 6i, Oracle Reports 6i)

3. Indiana State Agency Clearance System (Oracle 9i, Oracle

10g, Oracle Forms Builder 6i, Oracle Reports 6i)

4. Indiana TAX Clearance Tracking System (Oracle 9i, Oracle

10g, Oracle Forms Builder 6i, Oracle Reports 6i, JAVA)

1997.8 - 2004.2:

Applications Analyst

ITT Educational Services Inc.

Indianapolis, Indiana

Major Responsibilities:

> Requirement analysis, Prototyping, design, coding and testing by

using RAD SDLC

> Work with users to translate requirements into technical solutions.

> Design, Develop and Maintain software for the company. Perform

significant

Enhancements / Additions to existing software.

> Create and execute testing processes

> Analysis, debugging and correction of production issue, using

server logs, ad-hoc SQL queries, etc

> Design and normalization of database schema

> Database SQL performance tuning

> Data Migration between Oracle, SQL Server, Sybase and Mainframe

> Integrate data from multiple resources

> Oracle ERP (Financials 11)

Major Projects:

1. Exeter Student Service System

This system delivers better, efficient information to ITT

headquarter staff and the faculty and recruiters of its 76

technical institutions. From marketing leads, application,

enrollment, class scheduling to financial aid, placement

and alumni services, all information is seamless and real-

time through internet.

(Oracle Forms, Oracle Reports, Oracle 8i, PL/SQL, Java,

XML)

2. CATS student tracking system & Web version

This is the student tracking system to market student

leads, enroll student into classes, provide information

(financial aid, placement, etc.) of the enrolled student

to the management and recruiter.

(Visual Basic, Sybase, HTML, ASP, ActiveX, ODBC, ADO, RDO,

OLE DB)

EDUCATION

Ball State University (1995.8 - 1997.7), Muncie,

Indiana

Master of Science in Computer Science (July, 1997)

Master of Science in Physics

Graduation Date: July 1997

Tsinghua University (1987.8 - 1992.7), Beijing,

China

Bachelor of Engineering in Thermal Engineering

(July, 1992)

Graduate with honor

ORACLE courses

> Intro to Oracle: SQL and PL/SQL (Chicago)

> Develop PL/SQL Program Units I (St.Louis)

> Develop PL/SQL Program Units II (Indianapolis)

> Oracle Developer: Build Forms (Indianapolis)

> Oracle Developer: Build Reports (Indianapolis)

> Oracle Workflow (Indianapolis)

> Oracle Performance Tuning (Indianapolis)

REFERENCES

1. Kevin Gulley

Deputy Director of IT

Department of Revenue

233-1453

2. Jack McCrobie

Supervisor of IT

Department of Revenue

233-5111

3. Jeff Alden

Systems Analyst

Department of Revenue

233-9166

Contact this candidate