Data Project

Puiyee Tong

(Java and Oracle Developer)

****@*******.***

Home: **** ***** ******, *** #***, Berkeley, CA 94704 ? 917-***-**** ? US

Citizen

OBJECTIVE

Seeking a position as an application developer.

EXPERIENCE

Assistant Vice President, Global Markets Equity, Deutsche Bank, June 2007-

July 2010.

?Built a compliance report engine in Java to generate daily Order Audit

Trail System (OATS) reports and improved the performance of codes. Worked

with the business analysis team to test business scenarios and investigate

data quality issues. The project provided high quality compliance reports

to the NYSE and replaced legacy systems, thereby helping the firm to avoid

monetary loss due to financial penalties.

?Built the reference data infrastructure for a data warehouse project. Set

up a framework with Perl and Oracle to load reference data in real-time or

batch mode. Implemented a set of reusable codes for loading and processing

various types of reference data to allow for quick deployment.

?Used Informatica to extract and manipulate reference data during the

initial phase of the project. Migrated some of all the Extract, Transform,

and Load (ETL) jobs out of Informatica to Java/Perl/Oracle-based solution,

resulting in shorter development cycles and higher stability.

?Enhanced the data warehouse's robustness, stability and performance by

improving the error detection, data checking and logging mechanisms. Set up

alerting processes to capture production job failure via Control-M and Perl

scripts. Implemented data quality checks in the reference data loading

codes to catch data quality issues from upstream data providers.

?Migrated existing jobs and processes to new production and database

servers. Oversaw the database migration project and planned all the

necessary actions.

? Mentored a college intern to implement a data quality monitoring tool for

the compliance reports that are sent to the NYSE. Trained new team members

in the infrastructure of the data warehouse project and ensured high

quality work from them.

Skills utilized: Java 5.0, Perl, Eclipse, SQL, Oracle 10g/11g, Informatica,

Unix, Control-M, FIX and Tortoise SVN.

Associate, Equity IT, Morgan Stanley, June 2006 - May 2007.

? Designed, developed and maintained a Java-based proprietary trade

enrichment application in Equity that processes an average daily volume of

20 million messages using Java 1.5 and IBM WebSphere MQ for message

delivery. Worked in a global team environment and had regular interaction

with team members from other regions.

? Created queries and stored procedures in SQL to manipulate data in

Sybase. Built a Java program that interacts with an internal metadata

management system to bulk load data into Sybase via soap service call.

? Wrote Perl scripts to generate and distribute daily volume reports to

management and scheduled jobs using Autosys.

? Responsible for several components of the team's main application.

Performed impact analysis on proposed changes and created training

documents for the owned components to ensure integrity and accuracy.

? Gathered business requirements from the business unit and gave technical

design recommendations to bring new business flow into the system.

? Provided technical support and worked with the support team to minimize

client impact on major production issues.

? Participated in inter-team meetings and took notice of any changes in

other applications that may impact the system. Performed impact analysis

and carried out testing with the teams involved.

Skills utilized: Java 1.5, Perl, Eclipse, SQL, Sybase, IBM WebSphere MQ,

Unix, Emacs, Autosys, FIX and Perforce.

Software Developer, Capital IQ, a division of Standard and Poor's, July

2005 - April 2006.

? Developed software components to process real-time news feed.

? Wrote Java programs to FTP news files from a remote site, store news data

in the database, map news items to their corresponding companies, and

categorize news items based on their industry types. Used design patterns

and multithreads in the project.

? Used JDom to parse news files in the form of XML. Applied a text search

engine library Lucene, to output news items as Lucene index documents to

optimize keyword searching.

? Wrote stored procedures for storing and viewing news data in SQL Server.

Created database jobs to maintain the news data in database.

? Maintained and developed ASPX pages to display news articles using Visual

Basic, HTML, JavaScript, and ASPX.

? Maintained the core application and the bug track system of the company

using Visual Basic, HTML, JavaScript, and ASPX.

Skills utilized: Java 1.5, Visual Basic, SQL, Microsoft Visual

Studio/SourceSafe/SQL Server, JavaScript, JDom and Lucene.

COMPUTER SKILLS

Languages: Core Java, Perl, C#, Visual Basic, C, XML, FIX, SQL, JSP, ASPX,

HTML, JavaScript.

Platforms/SDK/API: Eclipse, Unix, Emacs, Microsoft Visual Studio 6.0/.NET,

Borland JBuilder, Lucene, JDom.

Databases: Microsoft SQL Server, Sybase, Oracle.

EDUCATION

Cornell University, New York

Master of Engineering, Computer Science, August 2004 - May 2005

GPA: 3.60/4.00

Stony Brook University, New York

Bachelor of Science, Computer Science, August 2001 - August 2004

GPA: 3.80/4.00

Contact this candidate