Sql Quality Assurance

Charles Dong

Address: ** ****** **., **********, ** 08536

Telephone: 732-***-****

E-mail: *********@*****.***

IT Skill Summary:

. 10 years of hands on experience in design, develop client server business

applications using ORACLE, SYBASE, SQL, PL/SQL and Powerbuilder

(including PFC).

. Over 7 years of Technical support/Production Support experience.

. Excellent written and verbal communication skills.

. Involved in full software development life cycle (SDLC) including

analysis, architect, design, development, testing, and deployment

. Experience in Financial Service, Insurance, Pharmaceutical, Energy

Trading and Construction Information systems

Skills:

. PL/SQL(Oracle 7 to 10 and Sybase 10/11), Powerbuilder version 5.0 to 9.0

(including PFC), isql, HTML, PVCS (version 6 and 8), Microsoft Visual

Safe, SQL-Station, Rapid-SQL V7.3, PL/SQL Developer, CodeWright 7.0, VBA,

Perl

. Access, JSP, e-doc, JavaScript, XML, Excel

. Windows95/98, Windows2000, Windows XP, Windows 7, Windows NT, Unix

Experience:

. Energy Exchange Direct, New York, NY Jul. 2010 to Present

Consultant Independent

Business analysis: Communicate with end user; Analysis and documentation.

System upgrade for an existing energy trading platform by using

Powerbuilder 9 as frontend and Oracle 10 as backend;

Making corresponding database changes including packages, store

procedures, tables and triggers. Doing performance tuning for PL/SQL

codes.

Provide adhoc report by using SQL query to support user request.

Technologies: Oracle 10, Powerbuilder 9.0 with PFC, SQL, PL/SQL, XML

. Satyam Computer Services, Hightstown, NJ Oct. 2006 to Mar.

2009

Full time employee. Senior Analyst/Programmer

Provide 24/7 Production support for McGraw-Hill Company Construction

business. Support DodgeNet, ScanScope,

PNL_Auto/Custom_PNL_Auto/PNL_Admin, ScanEdit/ScanFTP/AutoFTP

applications.

Documentation: Prepare documentation of understanding for Satyam Computer

Services through extensive analysis; Prepare transfer documents etc.

Working closely with BA, business manager and other team members;

accurately capture business need into functional spec.

Enhanced of the existing version; perform unit test and system test for

the new release. Release Management: Lead the new version release;

quickly resolve support issues; Monitor the dataflow and scheduled jobs.

Develop and implement Oracle PL/SQL stored procedures to support the

frontend application and batch jobs.

Lead the project in successfully migrate the applications from PB 5/6.5

to PB 9.0.

Provide adhoc report by using SQL query to support user request.

Introduce source code management system and put all Powerbuilder

Objects/Store Procedures/triggers into Microsoft Visual Safe.

Technologies: Oracle 8, 9, Powerbuilder 5, 6.5, 9 with PFC; SQL, PL/SQL,

UNIX, Microsoft Visual Safe, Perl Script.

. PJS Capital, New York, NY Aug. 2005 to Oct. 2006

Consultant Independent

Design a powerbuilder platform for energy trading; Business analysis;

Communicate with end user; Design the system from scratch; Analysis and

documentation.

Database modeling including architect, design. Created all database

objects like Oracle packages/procedures/functions/triggers; Data

normalization. Doing performance tuning for PL/SQL codes. This database

is capable of process large volume of transaction by using data warehouse

structure.

Design Java routine to communicate with PJM data source.

Provide adhoc report by using SQL query to support user request

System upgrade: Upgrade front-end/back-end and Java routine to

accommodate PJM data feed changes.

Technologies: Oracle 9i, Powerbuilder 7.0, 9.0 with PFC, JSP, IBM

Rational RAD, SQL, PL/SQL, XML

. Keystone Computer Associates, Inc. Fort Washington, PA Mar. 2005 to

July. 2005

Consultant

Maintain/Migrate Corp-system CRS, MBRS, BRS, RRS for Independence Blue

Cross (Philadelphia, PA); Product Support/Defect correction;

Wrote/implemented backend logic (Oracle package/ procedure

/function/trigger) to support front-end applications.

Provide adhoc report by using SQL query to support user request.

Implement VBA for Microsoft Excel spreadsheet.

Technologies: Oracle 9, Powerbuilder 8.0 with PFC, SQL, PL/SQL

. ING, West Chester, PA Nov. 2000 to Dec. 2004

Full time employee. Senior Software Developer.

Developing financial Corp-system GARWin I and GARWin in

Powerbuilder/Sybase;

Deliver software engineering designs and programming for system fixes &

enhancements to the GARWin retail annuity management system, an

internally developed application built on the

PowerBuilder/EAServer/Sybase SQL platform.

Work with end users, business analysts and the Quality Assurance team to

resolve application defects and implement enhancements to existing

applications. Understand business requirements, create

functional/technical specifications, implement code changes, perform unit

testing and support QA in resolving defects. Identify data needs,

including access, security, quality and maintenance requirements.

Provide practical, expert knowledge of technical design alternatives and

the implications of each approach, participating software development

cycle. Influence and clearly relate technical alternatives to business

objectives, using effective communications with customers and

stakeholders. Recommends design alternatives, considering benefits and

limitations to users based on in-depth understanding of business needs.

Identify business value and cost for business and IT partners.

Provide technical direction and coaching to software developers and

associate software developers in application development activities. Keep

current on best practices in technology, and market place trends.

Wrote/implemented complex stored procedure using PL/SQL; wrote script to

create table, index; doing performance tuning for PL/SQL codes; Provide

adhoc report by using adhoc PL/SQL store procedure and SQL query to

support user request.

Provide production support for nightly production run.

Lead the project in successfully migrate the applications from PB 6.5 to

PB 9.0.

Convert legacy system: convert clipper program to Powerbuilder/Sybase

store procedure and incorporate it into Garwin I and Garwin II.

Technologies: Sybase 11, Powerbuilder 6.5, 8.0, 9.0 with PFC, SQL,

PL/SQL, VBA, Clipper, Microsoft Access, PVCS.

. Devon Consulting, Malvern, PA Oct., 1999 to Oct., 2000

Consultant

Developing Customer Contract Management (CCM) system for Merck

Pharmaceutical (West Point, PA).

Involved in analysis, design, prototype, develop the Gencord OLTP program

(primarily in product/product group maintenance, customer maintenance,

file I/O and submission areas); Enhanced of the existing version/newer

version of the program; Created/implemented complex backend logic (Oracle

package/ procedure /function) to support front-end OLTP.

Product Support/Defect correction;

Provide adhoc report by using SQL query to support user request.

Documentation: Working closely with BA, CCM team (end users) and other

team members; accurately capture business need into functional spec.

Technologies: Oracle 8.0, Powerbuilder 6.5 with PFC and Cornerstone

library, SQL, PL/SQL.

. Genesis Consulting, Upper Darby, PA May 1999 to Sept.,

1999

Consultant Independent

Developed a new user-friendly application. It was meant to be an

automated tool which assists AFX personnel with the inquiry, maintenance

and storage of subject data for its clients, as well as maintaining and

reporting on all of the data recorded by AFX.

Technologies: Oracle 7.0, Powerbuilder 5.0 with PFC, SQL.

Education:

Ph.D. Biochemistry, Columbia University. May, 1996

M.S. Biochemistry, Columbia University. May, 1991

B.S. Biochemistry, Fudan University, Shanghai, P.R. China. July, 1987

Contact this candidate