Developer Business Management Project .Net Application

SIMON SUN

***-** ****** ******* ****. Scarborough, Ontario M1V 1R2

Phone: 416-***-**** Email: abqcrx@r.postjobfree.com

OBJECTIVE .NET Developer

SUMMARY OF QUALIFICATIONS10 years of software development experience5 years of .NET framework and SDLC experience8 years of database development and maintain experience Excellent knowledge of OOADExcellent knowledge of structure C/S and B/SExcellent knowledge of design pattern of N-Tier and MVCStrong understanding of SOA and distributed structure Strong analysis and troubleshooting skills

TECHNICAL EXPERTISE

C#, JavaScript, JSON, JQuery, CSS, XML, HTML, LINQ, SQL

ASP.NET2.0/3.5/4.0, ADO.NET, Entity Framework, AJAX.NET

Web Application, Windows Application, Windows Service, Web Service, WCF

Visual Studio2005/2008/2010, TFS, VSS, IIS

SQL Server 2000/2005/2008R2 (including SSRS and SSIS), Access

CERTIFICATIONSMCTS ( 2.0 Web Applications) 2007MCDBA(SQLServer7.0) 2001MCSE (Windows2000 ) 2001

PROFESSIONAL EXPERIENCE

.NET Developer Feb. 2008 - Feb. 2012

Sentry Metrics Inc. Toronto, Ontario

Project: Policy Manager: Management of documents and users for intranet with features of multi-language, full log, customizable setting, distributed structure and synchronized data. Worked alongside members to discuss business requirements, analyze environment, completed technical and functional designDesigned database in SQL2005 and moved to SQL2008R2, including tables, queries, stored procedures, triggers and viewsModularized application to admin and user sides, which runs in main server and sub servers, respectively, and modularized admin part to sub modules Policy, Quiz, FlowDesigned admin side web application with N-Tire pattern in VS2008, created DAL, BLL and UI by using multiple .net featuresBuilt generic connection for different data providers to allow application to easily change databaseDesigned windows service application running in back-end to collect AD users info, synchronize files, and send e-mails Created SSRS report for user compliance records by using SQL2008 Reporting ServicePerformed unit test, integration test and debugCreated replication in SQL2008R2 for synchronizing main server database and sub server databasesDeployed product to main and sub servers, troubleshot, updated and enhanced functionalityWrote and updated user guide and updated log documents

Project: TheSentry: An enterprise security dashboard, which accesses information about customer’s current security posture and creates and analyzes meaningful reports. Analyzed business requirements, both development and product environment, updated technical and functional designDesigned ticketing module, a web application which interacts with customers through web services Designed URL log module, which tracks user’s visiting activity by collecting and transferring data from client database Designed device vulnerability module, a windows service application which processes data transferred from client serverDesigned account management module, which automatically generates Excel files for stale account to notify managers, set statuses, send email Created agent jobs in SQL Server agent to maintain database, performing daily or weekly tasks to create tickets automatically based on Excel file specification, clean/reset data, and backup database Built SSRS report center with web applicationWorked with operators and analysts to maintain and troubleshoot TheSentry product server based on data records and report results Improved application performance and functionality by modifying page and class coding structures Optimized database by using SQL Server tools, changing query structures, and adding indexes Tested, Released product, wrote user guide and updates documents

.NET Developer Nov. 2007 - Jan. 2008

AJC & Associates Inc. Markham, Ontario

Client: Doxim Inc. Markham, Ontario

Project: Cheque Return Management: An automatic financial cheque processing application which parses cheque associated files generated from bank machines into database, and provides with user’s UI for processing and reporting. Discussed and analyzed business requirements, design for web application and databaseDesigned and updated database tables structure in Visio, and moved to SQL Server2005Designed UI in VS2005, worked with team in TFS development environmentCreated components which centralize business rules to parse fixed length files into database and XML files, and generate report filesCreated DAL components by using ADO.NET to encapsulate CRUD methods manipulating underlying dataDesigned statement report functionalities using Crystal Report in .NET 2.0Performed unit test by creating unit test projects and integration test On call application support, worked with business analysts, operators, and QA

.NET Developer Aug. 2007 - Nov. 2007

AJC & Associates Inc. Markham, Ontario

Client: Nightingale Informatix Corporation. Markham, Ontario

Project: EHR (Electronic Health Record)Analyzed and updated technical and functional design for modules of Billing, Enterprise and PatientCreated UI for data presentation, input, edit, and query by using Web server and HTML controlsDesigned reusable classes and user controls for common part of pagesDesigned Customizing and Personalizing Web Application by using Themes and CSSDeveloped BLL components to centralize business rules, perform validation confirmation and process dataCreated DAL by using ADO.NET to encapsulate SQL CRUD methods manipulating underlying dataCreated tables and stored procedures, and views in SQL server2005Performed unit tests and worked with other members in development and QA team, finishing integrated test and application system test

Developer Aug. 2003 - Aug. 2006

Yaqi Software Engineering Company, Dalian, China

Project: Pharmacy Manufacture Management is an application for Pharmacy industry management, similar as functionality of ERPAnalyzed, coded, tested and deployed HR, sales, and procurement modules Developed windows application UI for login and data entry in VS2003 Developed business logical classes in projects, such as Employee, Product, Customer, and ProviderDeveloped data access class, ADO.NET to encapsulate methods manipulating underlying dataCreated database tables, queries, stored procedures, triggers and views in Oracle8iPerformed unit test, integration test, created installation, and wrote user guide documents

Project: Prophylactic Distribution Management: Allows government to manage distribution of free prophylactic to communitiesAnalyzed, programmed, tested and deployed User and Stock modulesCreated ASP.NET web pages and user control with server controls, CSS and JavaScriptDeveloped business logical and data access components Created tables, stored procedure, triggers and views, and established relations between tables in SQLserver2000Performed unit test and integration test, released to production server

Developer May. 2002 - Jul. 2003

Gonglian Information Engineering LTD, Dalian, China

Project: In Out Stock System: Warehouse management systemDeveloped windows application by using VB in Visual Studio 6.0 development environmentCreated UI, modeled business logic classes, database access classes Created tables, queries, triggers and views in SQL server2000Performed unit test and integration test, and released application

ASP Developer Mar. 2001- May 2002

Shuoshitong Technical Development LTD, Dalian, ChinaDeveloped web page application by using ASP, HTML, VBScript, JavaScript and SQL Server7.0Modeled business data and created database componentsWrote installation and operation document of applicationProvided technical support to users

IT technical support 1994 – 2001

Dalian Infrared LTD, Dalian, China

EDUCATIONMountains Institute of Technology Canada, Markham, Ontario Dec.2006 - Jul. 2007 Beijing Institute of Technology, Beijing, China 1990 - 1994

B. Sc. in Computer Engineering

References available upon request

Contact this candidate