Sql Server Engineer Software Developer .Net Management

Haiyan Kong

**** *********, #***

Houston, Texas 77081

713-***-**** ******@*******.***

SUMMARY

Over 10 years of professional experience in developing web-based, winform and database

applications using Microsoft technologies including .NET, C# and SQL Server.

TECHNICAL SKILLS

Languages: ASP.NET, C#, VB.NET, SQL, T-SQL, HTML, XML, JavaScript, AJAX, CSS, MDX

and PHP.

Databases: SQL Server, Oracle, Access, MySQL.

Tools/Packages: Visual Studio.NET, Visual Studio, Crystal Report, SSRS, MTS, COM, SSIS, DTS,

Stored Procedures, Wise Installer, VSS, Team Foundation System, MS-Office, OLAP, SSAS,

WebService.

EXPERIENCE

Software Engineer, 12/2007 – 05/2009, Heritage Health System, Inc., Houston, Texas; Universal

America Corporation, Lake Mary, Florida

• Participate in developing web-based applications by using VS 2008.NET, AJAX, SQL Server

2005 and XML Web Service.

• Create the database warehouse (Pay for Performance – P4P) and generated the efficient

reports based on calculations from P4P. Utilize the analysis delivery tools: OLAP, Cubes,

Dimensions, SSAS, complex stored procedures.

• Design and develop SQL server reports on HIMS web (Company Information Management

Intranet), which dramatically increase departments’ productivities. Deliver web solutions using

VS 2005, C#, VB.NET, ASP.NET 2.0, SQL Server 2005, XML Web Service and IIS.

• Develop and implement various data in loads and extracts for multiple vendors and agents to

communicate with company internal database. As the first one to create the ETL process with

SSIS, I also mentor other developers to do the similar tasks.

Software Engineer, 02/2007 – 11/2007, Agar Corporation, Inc., Houston, Texas

• Responsible for enhancement and support of web portal tools. Gathered and analyzed

requirements from business units. Designed and developed web solutions using VS 2005, C#,

VB.NET, ASP.NET 2.0, SQL Server 2000/2005 and XML.

• Integrated wok processes of SQL Sever, Email Server and File Server. Created work flow

documentation which specified step-by-step action for actual integration and implementation.

Haiyan Kong 713-***-**** Page 2

MIS Software Engineer, 02/2002 – 02/2007, Piping Technology & Products, Inc., Houston, Texas

• Developed and deployed web-based and n-tier client-server applications based on the

gathering, analyzing and defining of business requirements; and implemented software

processes to automate them. Led problem-solving efforts and determined the design and

system specifications. Frequently used tools are: OOP, .NET Framework, C#, VB.NET,

ASP.NET, SQL Server, Apache, PHP and Crystal Report.

• Extended and maintained the back end and core code of the company intranet and

Internet.

• DBA for SQL Server – Planed and implemented operational support activities: installations,

upgrades, security, maintenance, backup, recovery and databases tunning.

System Consultant, 10/2000 – 02/2002, Compaq Computer Corporation, Houston, Texas

(Jefferson Associates, Inc.)

• Developed, enhanced and supported the mission critical software (Life Cycle Management)

that is used to forecast computer prices by worldwide users in Compaq. The development tools

included VB, SQL Server, Excel, XML, ASP, JavaScript, COM, MTS, and Visual Source Safe.

Senior Analyst, Developer 11/1998 – 10/2000, Houston Fire Department, Houston, Texas

(Jefferson Associates, Inc.)

• Migrated HFD Personnel Information System from Mainframe to Window environment and

redesigned the whole system by using VB, Access, SQL Server, and Crystal Report;

meanwhile solved Y2K problem.

Application Developer, Software Engineer, 06/1990 - 09/1996, CAD/CAM Computer Center,

JFMT Works, Jinan, China

• Evaluated and customized database systems for machine tools' management; debugged

and rewrote existing programs in C/C++ to improve performance. (YIBAO Software Company,

Singapore)

• Involved in the design and development of manufacturing management system; used C as

front-end, wrote stored procedures and triggers for Oracle 7.0 on UNIX.

• Developed and improved GUI for CAD system, primarily coded in C, Motif. Ported software

from Fortran to C.

EDUCATION

Ph.D in Industrial Engineering, University of Houston, Texas.

M.S. in Industrial Engineering, University of Houston, Texas.

B.S. in Mechanical Engineering, Shandong University, China.

Contact this candidate