Developer .Net Software Sql Server Business Service

GUOSHENG ZHANG, B.Sc.

MCP, MCAD.NET

**** **** ***** **.

416-***-**** 647-***-****(cell)

Toronto, ON M3A 1X8

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

PROFILE

. Solid working experience both in developing new applications

through the process pattern and

providing assistance and enhancements for existing applications

. Experienced with the Software Development Life Cycle (SDLC)

. Strong knowledge of Object Oriented concepts and programming

. Practical experience with .NET Framework class library and CLR

environment

. Highly skills in C#/VB.NET, ASP.NET, ADO.NET, VB6 and MS SQL

programming with

both Windows-based and Web-based applications

. Experienced in programming with Classic ASP, XML/XSL, HTML, CSS,

Java/VB Script and AJAX

. Excellent knowledge of relational databases, hands-on database

development experience

with MS SQL Server, MS Access, SQL query analyzer, complex

stored procedures, triggers,

views and tasks

. Working experience with Crystal report, Active report and VBA/Excel

report

. Analytical, thorough, logical, detail-oriented and learning technology

quickly on own

. Working within a team or individually, providing team support,

motivating team and promoting team spirit

. Troubleshooting and resolving complex development and test issues with

logic

. Canadian citizen

TECHNICAL SKILLS

Software Tools: C#/VB.NET, ASP.NET, ADO.NET, XML Web Service,

WCF,MS SQL T-SQL/DTS, PL/SQL,

SMTP, ActiveX, VB6, VBA/MS Access/Excel, MS SQ, Classic ASP,

HTML, CSS, JavaScript/jQuery,

VB Script, XML/XSLT, AJAX, Active Report, Crystal Report,

VBA/Excel report,

Visual Studio 2008 Team Foundation, Visual Source Safe, Visio

and Python

Operation Systems: MS WINDOWS 2000/2003/XP, WINDOWS CE, MS SQL

Server 2000/2005/2008,

IIS5/II6, ORACLE

PROFESSIONAL EXPERIENCE

RBC. TORONTO, ON (2010/04 - 2011/02)

(A leading financial institute in Canada)

Senior Technical Analyst

. Enhanced Internal web-based applications (Orange Sheet, Green Sheet,

Internal Training and Billing) using C#,NET Framework 2.0/3.0/3.5,

Classic ASP, ASP.NET, WCF, COM+, HTML,

JavaScript/jQuery, XML/XSLT, Visual Studio 2005 and SQL Server

2005/2008, SSIS

. Worked closely with technical specialists and project managers in keeping

match up between tech implementation and business requirement

. Provided technical supports for systems maintenance

M&T Bank BUFFALO, NY (2010/01 - 2010/03)

(A leading lender of small businesses in west New York)

Senior Systems Analyst

. Updated Messaging APIs using VB6, VB.NET, WCF, NET Framework 3.5, Classic

ASP, ASP.NET, XML, ActiveX, COM, IBM Websphere MQ, Visual Studio 2008

Team Foundation

. Broadly defined as the creation or refinement of software programming

required by the company and its clients, Collaborated with other banks

. Performed testing to ensure continuity, quality and complete integration

in deliverables

SCI INC. TORONTO, ON (2009/03 - 2009/12)

(A leading provider of driving automotive sales revolution)

Senior Software Developer

. Enhanced ASP.NET web applications including framework enhancements,

function implementation, test and deployment by coding in C#, WCF, NET

Framework 3.5, Classic ASP, ASP.NET, ActiveX, COM+, Ajax, Java Script,

XML/XSLT, iBATIS entity framework, Visual Studio 2008 Team Foundation

. Created ETL processes for single or multiple-source data acquisition,

transformation, cleansing and loading to create data warehouses and

analytic data stores using SQL Server 2008, SSIS

. Worked closely with BA and QA in implementing application features and

bug fixes in a variety of automotive -related requirements

GUESTLOGIX INC. TORONTO, ON (2008/06 - 2009/02)

(A leading provider of on-board retail technology and solutions)

Senior Software Developer

. Maintained and developed POS E-commerce retail windows mobile

applications including compact framework enhancements, function

implementation, test and deployment by coding in C#,ASP.NET, Java/VB

Script, XML, Crystal Report/ Excel report, Visual Source Safe, Windows CE

and SQL Server 2005

. Broadly defined as the creation or refinement of software programming

required by the company and its clients

. Developed new custom applications and enhanced existing software

GRAND & TOY INC. TORONTO, ON (2007/11 - 2008/05)

(The largest commercial supplier of office products in Canada)

Senior Programmer/Analyst

. Maintained GrandandToy.com E-commerce POS retails Web Site including web

page design, implementation, test and deployment by coding in Classic

ASP, XML/XSL, HTML, CSS, Java/VB Script, AJAX, C#, ASP.NET, VB.NET,

ActiveX, COM, SQL Server 2005, PL/SQL, Oracle 8i

. Experienced under SourceSafe and Integrator tools of code and version

control within multi development environment

. Delivered assignments within specified time frames, adhere to all

established standards and guidelines individually and as a member of a

project team

BELL SYSTEMS & TECHNOLOGY TORONTO, ON (2006/9 - 2007/10)

(Division of Bell Canada providing telecommunication solutions and

services)

.NET Developer

. Integrated WFAS workforce appointment Web Service including design,

implementation, test and deployment. Coding in C#, ASP.NET,ADO.NET, COM+,

SMTP server/Email, SQL 2005 and IIS6 environment with WSDL, XSD, XML and

XSLT dealing with the interoperability between platforms

. Performed functionality testing in different developing phases with

creating test tools and using Mercury Quality Center and other automation

tools to ensure codes are running error-free and results are busyness

required, Worked in Python for testing, Active Report and VBA/Excel

report

. Worked closely with technical specialists and project managers in keeping

match up between tech implementation and business requirement

. Provided technical direction to application developers, assisted, guided

and mentored junior staffs.

. Worked with team on netmeeting, self-motivated and independently.

THE SALVATION ARMY TORONTO, ON (2005/6 - 2006/8)

(Territorial Headquarters for Canada and Bermuda)

.NET Developer

. Worked in developing Directory of Services in Web-based application

including location mapping, Location distance calculation (attitude and

latitude) using C#,VB.NET, ASP.NET, ADO.NET, MS MapPoint Web Service,

VB6, Crystal Report, Classic ASP, ActiveX, HTML, XML/XSLT, JavaScript,

MS SQL2000 and Infragistics NetAdvantage

. Worked with VBA/MS Access/Excel

. Developed stored procedures, triggers and user defined functions to

implement complicated busyness requirements

. Enhanced an existing systems called SAMIS and Created reports both in PDF

and Excel format using Crystal Reports and MS Excel based on client

requirements

BELL CONFERENCING INC. ETOBICOKE, ON (2000/3 - 2005/5)

(Division of Bell Canada providing teleconferencing solutions and services)

Software Developer

Worked in migrating RES/CRM teleconference reservation WinForm and

WebForm applications

to .NET environment using C#/VB.NET, ASP.NET, ADO.NET, VB6, COM/DCOM,MS SQ,SQL

Server 2000 and MS Windows 2000 Client/Server

. Developed new functions or enhanced the existing functionalities to

implement applications

using VB6/VB.NET, ADO.NET, XML, COM+, Web Service, NET Remoting, MS

Message

Queue and SQL stored procedures according to the business cases or

design documents.

Translated design requirements and specifications into robust

software implementations

. Worked with business analysts and test analysts in the detailed

design, programming,

testing and implementation phases of application development and

maintenance including

RES system, bridge data processing system and bridge data

download system using

VB6.0, VB Script, ACCESS, VBA/Excel report, MS SQL Server 2000,

ADO/OLEDB, COM/DCOM,

Grid7, Active Reports, VBA/Excel report

. T-SQL coding in stored procedures, triggers, views and DTS Package

programming

. Defined and executed appropriate tests to guarantee stable software

construction that meets the business specification needs

. Delivered quality software within specified deadlines and supported the

delivery of these solutions to customers

ACADEMIC TECHNOLOGIES INC. MISSISSAUGA, ON (1999/6 - 2000/2)

(Academic Technologies provides technical solutions and develops software

applications for the telecommunications industry)

Programmer/Analyst

. Provided maintenance for existing applications by making modifications as

required, identified and communicated technical problems, processes and

solutions

. Integrated, migrated, upgraded and implemented OSS teleconference systems

and Billing system from VB5/MS ACCESS to VB6/MS SQL server 6.5 using

VB5.0/6.0, VBA, SQL Server 6.5, T-SQL/DTS, DAO, RDO, COM, Grid5, Active

Reports based on customer requirements

. Supported performance tuning, update, troubleshooting and enhancement to

existing applications with end-users and provided technical support to

production systems to ensure they are running error-free

. Prepared reports and documentation on the status, operation and

maintenance of applications

. Performed database administration duties and provided daily support to

ensure consistency, availability and integrity of the data. Entailed

migrating Access databases to SQL 2000, with converting manual to

automated processes. Formulated policies, procedures and standards

relating to database management

EDUCATION

MCP, MCAD.NET

Bachelor's Degree in Computer Science and Engineering. B.Sc.

.NET training in Royal College of Technology Canada

Contact this candidate