Sql Server Developer

Wei Wu

** ******* *****, *******, *******

Tel.: 905-***-****

E-Mail: ********@*****.***

OBJECTIVE

Position as a SQL Server BI/.Net developer

SKILLS HIGHLIGHT

•SQL server Developer with more than Ten Years of Experience.

•Experience in writing complex SQL queries involving multiple tables inner and outer joins.

•Experience in optimizing the queries by creating various clustered, non-clustered index

•Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL statements for various applications.

•Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.

•Working with BizTalk 2013/2009/2006

Sr. MS Visual Studio Developer

Sr. Visual Basic Developer

Microsoft Certificated SQL Server Developer and Administrator

PROFESSIONAL EXPERIENCE

Capco (2015-June to 2015-September) (SQL Server BI Developer)

Responsibilities

Description:

Joined with group of finance experts and BI/DW Solution Architects

Developers to provide Enterprise Data Warehouse for banking industry with FIS Company.

Sharing our experiences and developing huge data warehouse for banking industry.

Use Subversion(SVN) to maintain current and historical version/document

Technical environment:

Visual Studio 2012, SSIS, SSRS, SQL Server 2012

Element Financial Corp (2011-Jul to 2015-Apr) (SQL Server/.Net Developer)

Responsibilities:

Description:

Worked on moving TLS data into PHH data center. Created SSIS packages for application that would transfer data among servers.

Created packages using Integration Services (SSIS 2008), Sybase adapter to transfer data from SQL Server to Sybase.

Developed and supported web based fleet management and reporting tool for fleet clients and drivers based on Microsoft .NET framework 4.0 using ASP.NET, C#.NET, CSS, Crystal Reports, SSRS

Developed and maintained SQL Script for pulling data from one environment to another without manual intervention upon promotion

Use the systems development life cycle (SDLC)

Use Subversion(SVN) to maintain current and historical version/document

Technical environment:

ASP .Net 4.0, C# .Net 4.0, JQuery, CSS, Visual Studio 2010, HTML, SSRS, SQL Server 2008 R2, Telerik Rad Controls, IIS 6.0

Crystal Reports, Entity Framework

Scotia Bank/TransportAction (2009-Jul to 2011-Jul) (SQL Server/.Net Developer)

Responsibilities:

Designed and developed the .NET assemblies, classes, functions, business components

Designed and implemented a multi levels data structure for our client data using Recursive query and CTEs

Developed and maintained MS .Net web services for Fleet Quote Application

Troubleshooting of production issues and suggesting the most efficient solution to the development team and implementing the solution to the production

Developed and maintained SQL Server database Table, View, Function, Trigger, Stored Procedure and fine tuning them for performance optimizations using T-SQL

Use the systems development life cycle (SDLC)

Use Subversion(SVN) to maintain current and historical version/document

Technical environment:

ASP .Net 4.0, C# .Net 4.0, JQuery, CSS, Visual Studio 2008, HTML, SSIS, SSRS, SQL Server 2008 R2

TransportAction (1998-Jul to 2009-Jul) (SQL Server/.Net Developer)

Responsibilities:

Performed in SSIS to transform data from various legacy systems

Created packages using Integration Services (SSIS) for data extraction from Flat Files,

Excel Files

Gone through existing code written in Classic ASP 3.0, Visual Basic 6.0 (VB 6)

Design SSAS cubes with multiple fact measures groups and multiple dimension hierarchies

and Developed MDX queries based on the OLAP reporting needs.

Configured web.config file for ASP.Net web forms and the entire Web Application and also implemented error and exception handling using Try, Catch and Finally

Upgraded BizTalk 2006 environment by migrating BizTalk 2009

Processed Maintenance data using Biztalk mapping and orchestration

Developed and maintained Ad hoc Reports using SSRS, Crystal report and excel

Use Subversion(SVN) to maintain current and historical version/document

Use the systems development life cycle (SDLC)

Technical environment:

ASP .Net 2.0, C# .Net 2.0 CSS, Visual Studio 2005,

SSIS, SQL Server 2005, SSIS,Visual Basic 6.0

EDUCATION:

Ph.D. in Physics, 1996 Tübingen University, Tübingen Germany

Contact this candidate