Sql Server Developer New York Data .Net Experience

LEI SHENG

abmquq@r.postjobfree.com **** Quentin Road Brooklyn, NY 11229

(Willing to Relocate) 718-***-****

SUMMARY

I am a

Database Developer with 3+ years of experience in MS SQL Server

Database Development and Microsoft .NET technologies Application

Development. I am also a Microsoft Certified Professional in MCP,

MCTS, and MCITP backed with a degree in Master of Science in

Electrical & Computer Engineering at NYU.

TECHNICAL SKILLS

Operating Systems MS Windows 98/2000/XP/Vista/NT/2003 Server

Database Development MS SQL Server 2000/2005/2008, Oracle8i/9i/10g, MySQL 5.0.

Data Transformation MS SQL Server 2000/2005/2008 SSIS, DTS.

Data Analysis MS SQL Server 2005/2008 SSAS, OLAP, Data Warehousing,

Data Modeling.

Report Writing MS SQL Server 2005/2008 SSRS, Crystal Report, MS Access,

Excel.

Web Development ASP.NET 2.0/3.5, VB 6.0, Visual C#, Visual Web 2008, PHP

5.3, XML/HTML.

Network Management TCP/IP Protocols, Wire Shark, ethereal.

TECHNICAL CERTIFICATIONS

. Microsoft Certified Technology Specialist (MCTS): SQL Server 2005

. Microsoft Certified IT Professional (MCITP): Database Developer

. Microsoft Certified IT Professional (MCITP): Database

Administrator

[pic] [pic] [pic]

WORK EXPERIENCE

Hisun Optoelectronics CO., LTD, New York, NY

Mar.2009 Present

Position: Database Developer

Responsibilities:

. Designed and developed database schemas and diagrams in SQL Server

2005/2008.

. Hands on Experience in installing, configuring, monitoring and

troubleshooting SQL Server 2005.

. Generated SSIS packages to automate the procedures of data

Extraction, Transformation and Loading from various data sources:

SQL Server 2005, Access, Excel, Oracle, XML, Text, etc.

. Wrote stored procedure, triggers, and user-defined functions using

T-SQL queries upon application needs.

. Actively monitored the performance of query using SQL Profiler.

. Created indexed views, and appropriate indexes to cut the complex

query time. Implemented new indexing system reduced report

processing time.

. Generated web-based parameterized reports using SSRS in Visual

Studio 2005 based on clients' requirements.

. Performed database backup, restore, tuning and optimization in SQL

Server 2005.

. Experience in managing Alerts and Jobs through SQL Server Agent.

. Designed and developed presentation and data layers using ASP.NET,

VB or C#.

. Participated and strongly understand the SDLC of the projects.

Technology: SQL Server 2005, SSRS, SSIS, Access 2007, ASP.NET 2.0, VB,

C#, Visual Studio 2005, Visual Web Developer 2008, XML, HTML,

Photoshop.

New York University, New York, NY

Oct.2007 Feb.2009

Position: Graduate Assistant

Responsibilities:

. Assisted ECE Department Head Jonathan Chao in NYU's Academic

Ranking Project. Conducted data collection, database creation,

report generation and data analysis work with MS Excel, VBA and MS

Access.

. Assisted ECE Department Advisor Professor X.K. Chen in students'

document management work using People Soft database administration

system.

Projects Experiences:

Online Course Registration System, NYU.Poly, NY

Jan.2009 Apr.2009

The system allows students to register for classes online and check

grades. Also it allows professors to get useful information about

their students and then assign grades to them.

Technology: SQL Server 2005, Visual C#, ASP.NET, HTML.

Web-based System for a Book Club, NYU.Poly, NY

Sep.2008 Dec.2008

The system allows members to subscribe to topics of interest and

comments and allowed members to participate in on-line discussions

about those topics.

Technology: MySQL, PHP 5.3, WAMP 2.0, HTML.

Responsibilities:

Designed database schemas, data modeling and data integrity.

Developed web application and insured its interaction with database

system.

Lenovo & Wuhan Speed Net Integration Ltd. Corporation, China

Mar.2004 Jul.2007

Position: Database Developer/Technical Consultant

Responsibilities:

. Designed and optimized the database system in MS SQL Server

2000/2005, MS Access.

. Generated DTS/SSIS packages to automate the procedures of data

migration and merging from various data sources: SQL Server

2000/2005, Access, Excel, Text, etc.

. Wrote stored procedure, triggers, and user-defined functions using

T-SQL queries.

. Generated web-based parameterized reports using SSRS in Visual

Studio 2005 based on clients' requirements.

. Configuration the SSIS packet and scheduled in SQL Server Agent.

. Web test and maintained application functionalities using VB.NET.

. Designed and developed database schemas, data entry forms, static

and dynamic reports in MS Access, MS Excel, VBA, and MS SQL Server

2000.

Technology: SQL Server 2000/2005, DTS, SSIS, SSRS, T-SQL, Visual

Studio 2005, ASP.NET 2.0, Visual Basic, Access, Excel, VBA.

EDUCATION BACKGROUND

. MS, Major in Computer Engineering

Sep.2007 May.2009

New York University, New York, NY

. BS, Major in Electrical Engineering

Sep.2000

Jun.2004

Wuhan University of Technology, Wuhan, China

Contact this candidate