HARRISON (HONGZHI) SUN

***** ***** **** ** 973-***-**** (c)

Alpharetta GA 30022 acguk5@r.postjobfree.com

SUMMARY:

Many years of programming experience; highly skilled in programming;

expertise in database and web application design, development and

maintenance. Motivated in problem solving. PhD. Degree in Mathematics.

Certified Professional of Microsoft and Oracle products. Positive

working attitude. Willing to learn new technologies.

IMMIGRATION STATUS: US citizen.

COMPUTER LITERACY:

Database: Microsoft SQL Server 2012/2008/2005/2000/6.5, Microsoft

Access, Oracle, Sybase

Programming Languages: SQL Server Reporting Services (SSRS), SQL

Server Integration Services (SSIS), MDX for SSAS, Microsoft .NET

3.5/2.0/1.1, Visual Studio 2008 Team/2005/2003, ASP.NET, C#,

Classic ASP, Visual Basic, COM+/MTS, XML/XSLT/XML-FO, Ext JS,

JavaScript, VBScript, Dynamic HTML, Excel VBA

Operating System: Windows 2007/Vista/2000/XP/NT4.

COMPUTER CERTIFICATES:

Certified in Microsoft:

Microsoft MCAD.net (Web App, Window App, Web Services, .Net

security)

Certified in ORACLE:

Introduction to Oracle: SQL and PL/SQL;

Oracle8: Database Administration.

JOB TITLE:

Senior SQL server database developer/DBA.

PROFESSIONAL EXPERIENCE:

Ista North America (April. 2012 - now)

Senior SQL server database developer/DBA

Play key role in all the following projects:

. KPI (key performance indicator) project for our client FourChange.

Using SSIS package to collect various transaction performance data

and then using stored procedure to calculate the performance and

generate reports.

. Database migration for Ista client TaxPo. Using SSIS package,

stored procedure to migrate data from our client's database to

Ista database. Customer base: 50K active customers and 30K

inactive customers.

. SSRS report development for Ista B2B sites. Developing SSRS

reports that can be shared among Ista Clients.

. KPI projects for Ista client HudsonEnergy and Spark.

. Data migration for Ista client Spark. Using stored procedures for

the migration. Customer base: 200K active customers and 200K

inactive customers.

. Stored procedure performance tuning. Using query execution plan

and SQL dynamic management views to find low performance stored

procedures. Then improve stored procedure performances by re-

constructing stored procedures or by creating/modifying indexes.

. Production stored procedure bug fix, database snapshot and

replication creation and some routine DBA work such as User

Security management.

. Lead a Off-shore database developer team with 2 to 3 members.

Major Technologies: SQL Server DMVs, SQL Server Profiler, SQL

Source Control,

SSRS, SSIS, stored procedure.

Ignition One (Aug. 2011-April. 2012)

Senior SQL server database developer/DBA

. Design tables and implement stored procedures for many modules for

the digital marketing application. The emphasis is on how to

carefully design tables that will hold large volume data and how

to code good performance stored procedures that use these tables.

. Performance tuning for queries that hit large volume of data.

. Develop SSIS packages to collect data from various data sources

(such as Google or other clients of Ignition One).

. Production database on call to fix bugs of stored procedures/SSIS

packages or handle stored procedure performance issues.

Major Technologies: SQL Server DMVs, SQL Server Profiler, SQL

Source Control,

SSIS, stored procedure.

MFG.com (Feb. 2010 - Aug. 2011)

SQL server Database Developer/DBA

. Responsible for all SSRS report developments using stored

procedures.

. Administrate the SSRS report site (user security, report

scheduling, report upload, etc.).

. Administrate MFG clustered database servers (routine DBA on call,

emergency production bug fix, database size growth planning,

administration scripts development, index/performance tuning).

. Using MS Build and SVN version control built a continuous

integration tool for MFG.com

Major Technologies: SQL Server Profiler, SVN Source Control, SSRS,

stored procedures.

CodeReady Solutions, Inc (Sept. 2007 - Feb 2010)

Senior Developer

. Implemented CRM system data migration processes. Data was migrated

from a third party database schema to the company's own database

schema. The processes dealt with problems such as mismatched

data, bad data, database schema conflictions, etc.

. Designed and implemented front-end of Event Setup module of CRM

system using Ext JS. The module has WinForm look-and-feel. It is

the most complicated, yet the most stable module of CRM system so

far.

. Developed EmailSniper system that works with Port25 email

software. EmailSniper system is used to send campaign emails and

transactional emails, to track the status of sent emails, to

generate statistics reports and status reports of the emails. The

system handles up to 100,000 emails per hour without noticeable

impact on database performance.

. Designed and implemented Virtual Call Center Scheduling

application using ASP.NET 2.0, SQL Server 2005, XML/XSLT and

DHTML. Call center agents anywhere can use the application to

schedule working hours. The web application was implemented with

the capability of displaying suitable information cross the time

zones and to take the daylight saving time into consideration.

The application also includes an agent number forecast using

Erlang C formula which made the schedule forecast more efficient.

. Installed SQL Server 2005 reporting services (SRSS). Developed and

deployed reports.

. Implemented part of Call Center Registration Web Application.

Asp.net page cache is used to make faster response.

Major Technologies: ASP.NET 3.5/2.0/1.1, C#, Ext JS3.0/2.1, Ajax,

Linq, Web Services, Windows Services, XML/XSL, JavaScript/DHTML and

SQL Server Reporting Services (SRSS), SQL Server 2008/2005 stored

procedures, Port25.

Credit Suisse (Dec 2002 - Aug 2007)

Tech lead

. Lead a seven-person team to create INVESTRAN-DS2-PRIME integration

system. The system establishes data workflow from INVESTRAN system

to DS2 system, and DS2 system to PRIME system; developed the core

component of the system, a Windows Service that retrieves data from

INVESTRAN, consolidates the data, feeds data to DS2, and sends to

PRIME. Also managed task assignment and provided technical

assistance.

. Production support of Firm Reporting Layer (FRL) application.

Utilized SQL2000 ad-hoc queries, stored procedures, SQL Server DTS

to help identify data issues as well as application issues. Worked

with users to fix complicated and related data sets from back-end

in order to produce correct reports within tight time frames.

. FinCast (expense/budget/revenue forecast strategy) and FRL project.

Responsibilities include design, setting coding standards, code

review, deciding technical solutions for FinCast, maintaining and

preparing FRL project migration from Classic ASP to ASP.Net. Coded

two kernel modules of FinCast and designed all the tables for the

FinCast application. The team had 7 members including 4 offshore

developers.

Senior developer

. Developed more than half of the kernel modules for FRL project,

which is one of the most widely used application at Alternative

Investment Department. About 30 fund accountants, financial

controllers use this system daily.

. Lead contributor of Deal System (DS2), which was considered a

milestone and the user-friendliest application of Alternative

Investment Department. Used by about 100 fund accountants at Credit

Suisse.

Major Technologies: ASP.NET, C#, Web Services, Windows Services,

Classic ASP, SQL Server 2000 stored procedures, XML/XSL, Excel,

XMLHTTP, JavaScript/DHTML and Crystal Report.

PlatinumMD (Jan. 2002 - Dec. 2002)

Lead Developer

. Designed and Implemented electronic medical record web applications

targeting cardiac patients.

Major Technologies: ASP/ASP.NET with C#, VB6 COM with COM+,

XML/XSLT/XML-FO (Formatted Object), stored procedures and triggers

in SQL Server 2000 and a java application FOP.

Merrill Lynch, Jersey City, NJ (Mar. 2000 - Jan. 2002)

Lead Developer

. Portfolio Management: Proposed and implemented a reporting solution

using Java, Formatting Object (FO), and VB COM to produce PDF

reports dynamically. VB COM is used to generate XML data, to load

XSL file to transfer XML into XML-FO file and then use Windows API

to start a Java application FOP to convert XML-FO file into PDF

file.

. Axiom: Web service Application using VB COM, Sybase stored

procedure, Microsoft SOAP technology to provide Web Services to

other internal applications at Merrill Lynch. According to the

manager, this is the first SOAP application used at Merrill Lynch.

. Order Entry: web application using ASP, VB COM with MTS, Remote

Scripting, XML/XSLT and IBM MQ series for placing, viewing,

modifying and printing orders.

. Financial Planning: Web Application using VB COM with MTS, ASP,

DHTML, XML/XSLT and Sybase stored procedures to help clients make

financial plans and generate complex financial reports.

Senior Developer

. Asset Allocation: Web Application using VB COM with MTS, XML/XSLT,

DHTML, ASP and stored procedures.

. Excel VBA Application to convert ILX symbols to REUTERS symbols.

TD WaterHouse, Jersey City, NJ (Aug. 1999-Mar. 2000)

Senior Programmer

. Developed Intranet online trading applications (Account

Administration and Account Maintenance) for brokers using ASP, VB

COM, MTS, JavaScript and IE 4 dynamic HTML. Create Oracle PL/SQL

triggers, stored procedures and packages for security checking,

data validation and account management.

. Oracle performance tuning including creating indexes, identifying

performance problems and modifying query statements to enhance

throughput.

. Created scheduled jobs using PL/SQL stored procedures and DBMS_JOB

package.

. Administrated the deployment of Web applications.

Communication Billing Technology, Inc, New York, NY (May. 1998-Aug.,

1999)

Program Analyst

. Tbill Browser: Developed the Web applications for Morgan Stanley

Dean Witter and Bear Stearns to handle phone billing automatically

using Classic ASP and PHP.

. TelephoneTracker (Client/Server application): Using VB 6.0

(including ActiveX Controls, DataEnvironment Designer, ADO, Data

Report Designer, Data Repeater components) to build front-end;

Coded Oracle PL/SQL stored procedures, stored functions and

packages to implement complex business rules.

. MarketTracker (Client/Server application): Using Microsoft Access

to build front-end; writing Oracle PL/SQL packages for the back-

end; Visual Basic programming using third party product Rumba to

build the interface between Windows NT and mainframe computers.

. Manhattan Fruitier: Develop data transfer engine between databases

using C++.

American Bureau of Shipping, Two World Trade Center, NY (Oct.1997-

May.1998)

RHI Consultant

. ABS/LASH Desktop application: VB5 program that help the container

lash design.

. High Speed Craft 97: use Excel 95 with VBA to develop High Speed

Craft design rules.

. Rudder Rule 1998: Use VB 5.0 and Microsoft Access to develop rudder

design rules.

Dept. of Chemistry, Baker Laboratory, Cornell University, NY (Oct.

1995-Oct.1997)

NIH granted research scientist with Dr. Harold Scheraga

Designing, programming and testing software for protein-ligand

docking processes; developing global optimization algorithms;

comparing simulation results of different Monte Carlo algorithms

(written in C++ and FORTRAN on IBM SP2 super computer in Cornell

National Super Computer Center).

Graduate Fellow (1991-1995)

Mount Sinai Medical Center, City University of New York, NY

. Computer simulation of strand separation transition of superhelical

DNA (written in C and FORTRAN on Dec Alpha Machine and Convex mini-

supercomputer).

. Computer simulation of membrane phase transition (written in C on

Silicon Graphics Machine).

Software Engineer (1985-1989)

Computer Center of the Institute of Petroleum Exploration and

Development of China

Developed software for petroleum engineers using C and FORTRAN with

Convex mini-super computer, performed numerical simulation using

parallel computational methods.

EDUCATION:

Ph.D in Biomathematics

Mount Sinai School of Medicine, City University of New York, NY

B.S. in Mathematics

Beijing University, China (Honored student)

HONORS:

Oct, 1995-May, 1997 National Institutes of Health (NIH) research

fellow award.

Contact this candidate