Developer Software Sql Server .Net Customer Service

Ricky Zhang

*** * *** **

Calgary, AB T*P *T*

Tel: 403-***-****

Email: *******@*******.***

HIGHLIGHTS OF QUALIFICATIONS

. Design and implement Management Information Systems (MIS) and

databases

. Development experience using Visual Basic, VB.Net, PeopleSoft, SQL

Server,

TECHNICAL SKILLS

. Languages: PL/SQL, VB, VB.NET, C#, PHP, ASP, C++, HTML, JavaScript

. Operating Systems: Windows NT, Windows 2000/XP

. Databases: SQL Server, MS Access

. Reporting: SQL, Crystal Reports, SSRS report, PeopleSoft SQR

. Qualification: MCDBA certificate

WORK EXPERIENCE

IT support,software developer

Respiratory Homecare Solution Inc 2012 April-2012 Nov

Customer service, Hardware maintenance, router /switch configuration,

network maintenance, Web maintenance,Software development?

Built SQL to retrieve data from database according to client's

requirements.

Created crystal report and ssrs report.

Imported and exported data between excel file and access and sql server

VB.net code modified.

Cell phone maintenance, router and switch configuration.

Set up Exchange server and outlook.

SSRS reporting, VB.net developer .

Calgary Flames 2010 August -2012 March

Create Access database, Vb.net development, Access management, Crystal

Report, data analysis.

interface design and database design.

Created field, record, Imported data from txt file to SQL server.

Imported data from excel file to SQL server.

Gathered internal clients requirements.

Troubleshooting of PC's, printers, and other related hardware

Database programmer (SQL),PeopleSoft developer

TELUS Sourcing Solutions, Calgary 2007 Nov.-2010 August

. Built SQL to retrieve data from database according to client's

requirements, make it a report.

. Web maintenance, ASP.net,PHP/MySQL, HTML

. designed PeopleCode .

. Created PeopleSoft interface/component/menu

. Used PS Application Engine, PS Query, Crystal Reports

.Net programmer and PHP/MySql developer

Southern Alberta Institute of Technology, Calgary Mar. 2007 - Aug. 2007

. Developed a software application using VB.Net and ASP.Net

. Designed, implemented and tested the database structure

. Designed website using PHP/MySql developer.

VB programmer

Qinhuangdao Port, Qinhuangdao, China Jan. 2001 - Nov. 2005

. Project: Railcar Scale Data Process software

o Created database tables, and the relationships between these tables

o Coded SQL statement to retrieve data from SQL Server database

o Wrote stored procedures which can be called in VB.NET program

o Exported data from SQL Server to xml files, txt files and Excel

files

o Imported data into SQL Server from other data sources

. Evaluated software application packages for possible purchase

. Maintained systems

. Trained clients on system use and data entry

VB programmer

Qinhuangdao City Construction Company, Qinhuangdao, China Jan. 1998 -

Jan. 2001

. Project: Business Management Software

o Designed solutions with VB, Visual FoxPro, SQL Server, MS Access

o Tested and debugged new software and application systems

FoxPro programmer

Qinhuangdao Machinery Company, Qinhuangdao, China July 1991 - Dec. 1998

. Project: Payroll Management Software

o System design, interface design and database design

o Developed software packages with Visual FoxPro, SQL Server

o Gathered clients requirements

EDUCATION

Certificate in Object Oriented Software Development

Southern Alberta Institute of Technology, Calgary Mar. 2007 - Aug. 2007

. Developed a software application using VB.Net and ASP.Net

. Designed, implemented and tested the database structure

Certificate as Microsoft Certified Database Administrator (MCDBA)

Beijing, China 2005

BE in Computer Science

Wuhan Transportation University, China Aug. 1987 - Aug. 1991

Contact this candidate