Technical Support Sql Server

Ningfei (Tony) Zhang

***, ***** *** ***., ****** BC

Mail: ********.****.****@*****.***

Phone: 604-***-****(Cell)

Objective: Database Developer / ETL Engineer / .NET Developer

Summary:

6+ years ETL implementation experiences converted more the 100 databases.

6+ years data reporting and analyzing with large volume of data by using SQL

10+ years of experience in the IT Industry as a Software Developer/Analyst

Proficient and highly skilled in design and development of client/server, Internet/Intranet applications, Crystal reports.

Microsoft certified programmer in .NET with more than 2 years development experience in C#, VB.NET, ASP.NET (MVC 5 with Entity Framework).

Earned extensive experience and Highly skilled in COM/COM+ (ActiveX Components, ActiveX Controls), multi-tier architecture application development.

Highly experienced in SQL Server databases and proficient database programmer in T-SQL.

Capable of delivering optimized, effective and well-documented code, adhering to quality standards and delivery dates

Ability to pick up and adapt to new technologies quickly and deal with an even changing baseline

Education:

Diploma in IT Solutions Developer, Vancouver Central College, Canada

Diploma in Computer Science, Worker’s College of Shanghai, China

Professional Training Certificates:

MCAD Microsoft Certified Application Developer for .NET

OCP Oracle Certified Professional

MCSD Microsoft Certified Solution Developer

MCDBA Microsoft Certified Database Administrator

Technical Skills:

Languages

C#, VB.NET, VB6, VBA, T-SQL, Linq

MS BI

SSIS, SSRS

Reporting

Crystal Reports XI R2, SSRS

Web Technologies

ASP.NET, ASP, Java Script, VB Script, HTML, DHTML, CSS, XML, XSLT, XSD, XPATH, SOAP

Methodologies

XML Web Services

Technologies

COM, COM+, Serviced Component, .NET Remoting,

.NET Framework

Tools

Visual Studio .NET, Visual Studio 6.0, Visual Source Safe

RDBMS

SQL Server 2000,2005,2008, 2012

Entity Framework (DB First, Code First and Model First)

NoSQL DB

Mongo DB (Document Oriented DB)

Professional Experience

Carl Data Solutions Inc. Vancouver, BC

ETL Developer (June, 2015 – June, 2017)

Position Overview

Integration of data from various data sources (db, text data files from FTP, or data from the web api queries into IBM SilverPop Engage System.

Design and develop ETL data flows, jobs, and processes based on requirements with SSIS

Developed stored procedures, T-SQL queries in production database.

Developed ASP.NET Application (C#, SQL, MVC, Web API).

Supported Microsoft Dynamics 365 CRM (Developed data process API with Dynamics 365 SDK, Customized CRM by adding custom fields to entities, creating custom workflows business processes.).

Corix Infrastructure, Richmond, BC

.NET / ETL Consultant (July, 2014 - Oct., 2014)

Position Overview

Developed and upgraded 75 SSIS packages for the Corix Production Web Application.

Maintained Classic ASP application and developed new functions to enhance the application.

Developed stored procedures, T-SQL queries in production database.

Costless Express Corp. Coquitlam, BC Canada

Database Developer (Mar, 2013 – May, 2014)

Position Overview

Develop ETL projects (SSIS, C#) to feed data to the ERP System.

Database Administration, Data reporting. Responsible for the data flow between the ERP (Sage X3) and all other systems (Saleslogix, Magento System).

Accomplishments:

Successfully migrated the data from Goldmine to Saleslogix by using Starfish ETL.

Developed customized reports (crystal reports, SSRS) for Sage X3 and Sage Saleslogix

Performed SQL Server database administration.

MaxHire Solutions Inc. Vancouver, BC Canada

Database Developer (Sep., 2006 – Feb., 2013)

Position Overview

Developed ETL solution to convert data from various kinds of data source to the format which ATS system can understand. Develop reports (Crystal Report) for the Maxhire ATS application. Develop internal applications for Maxhire Develop software interfaces to integrate various accounting software (such as Quick Books, MS Great Plain, PeachTree) to ATS System. Develop Maxhire APIs for clients to effectively use MaxHire ATS.

Accomplishments:

Day to day extensive T-SQL scripting to generate data presentation logic

SQL Server 2005, SQL Server 2008 Administration

Developed internal software applications for Maxhire

Designed report for applications (Crystal Report)

Provided technical support to end users.

Developed Data Conversion Applications

Integrated Accounting Systems to ATS CRM

Developed Sample Code for MaxHire Clients

Environments: C#,VB.NET, VB6, XML Web Service, T-SQL.

Procix, LLC in Memphis, TN USA

Programmer/Analyst (April, 2004 - September, 2006)

Position Overview

Developed quality control software for HVAC (heating, ventilation and air conditioning) equipments manufacturing. Onsite system debugging and technical support.

Accomplishments:

Developed quality control software for HVAC equipment manufacturing

Provided technical support to end users.

Designed reports in .NET applications.

Onsite system debugging and technical support.

Environments: Programming language used: C#, VB.NET, LLC(Ladder Logic Control) language, Opto 22Communication protocols. Databases used: MS SQL Server 2000, MYSQL 4.1, Access 2000 Hardware: PC (Personal Computer), PLC (Programmable Logic Controller), OPTO 22, and various analytical instruments talks to PC through RS232 or RS422 protocol.

Pacific Newspaper Group, Vancouver - Software Engineer (Sep. 1998-Sep. 2001)

References available upon request

Contact this candidate