Sql Server Project Manager
Resume:
Tel: 647-889-
7869
*************@*******.***
OBJECTIVE
To be a key player on highly motivated, productive and innovative software
development team and apply for my extensive experience and knowledge in
Microsoft technologies.
SUMMARY
o Over 10 years experience for software development based on N-tier
Enterprise Architecture of .NET Framework
o Expert knowledge in .NET technologies (.Net 4.5, 4.0, Visual Studio 2013,
2010, C#.NET, ASP.NET, Entity Framework, ADO.NET, MVC, WCF/Restful, WPF,
Windows Services)
o Great experience with Service Oriented Architecture and SOAP, Restful Web
service development
o Deeply involved in software development life cycle (SDLC), and fully
applied for different methodologies like Waterfall, Agile (Scrum,
Extreme); strong experienced with UML, MS Visio, XML, XSLT
Solid experience in designing and implementing Relational Database on
Microsoft SQL Server, Oracle.
Hands on experience with JQuery, AngularJS, Knokout, HTML5, CSS and JSON
client side programming
Extensive experience in Windows Form desktop development and WPF
development
o Skilled in Test Driven Development experience on Microsoft Visual Studio
Team Suite and NUnit, familiar with MVC/MVP/MVVM design pattern.
Strong knowledge of Crystal Reports and SQL Server Reporting Service
Working experience with Mirth product and HL7 standards
Excellent communication skills; ability to work both individually and in a
team.
o Certificated Microsoft Certified Technology Specialist (MCTS) for Web
Application.
WORK EXPERIENCE
OACCAC Toronto Canada
6/2012 --- Present
Senior .Net Developer
OACCAC is a government agency and provides business and IT services to all
14 CCACs crossing province of Ontario. OACCAC are participating in the
integration with e-health, Connecting GTA etc. to provide better service to
residents of Ontario.
Responsibilities:
. Worked closely with upper management, BA and senior architecture team,
participated in system design, data modeling for new products and
features
. Helped project manager to conduct the project plan (work breakdown,
estimate, prioritizing and allocating resources)
. Designed, documented and implemented ED Notification integration
between Hospitals, CCACs and Primary Cares (using Mirth 2.3, HL7
standards)
. Developed CHRIS Admin tool by using WPF and Testing harness by using
MVC 4
. Worked on CHRIS project to extend functionality and built rich user
experience UI
. Research and provide technical consultation and input to development
team
. Lead team development including mentoring junior developers
Environment: MS Visual Studio 2013/10, Net 4.5/4.0, C#.Net, ASP.Net, MVC 4,
WPF, JQuery, Knockout, AngularJs, LINQ, Entity Framework, MS SQL Server
2008 R2, Mirth 2.3
BPS Resolver Inc. Toronto Canada
6/2010 --- Present
Senior .Net Developer
BPS Resolver is a global leader in risk management, compliance,
sustainability and audit software. GRC Cloud integrates Risk management,
Survey, SOX etc and meets all the GRC requirements.
Responsibilities:
. Performed application architecting, design, development, data
modeling, data migration, application integration and deployment
activities
. Designed, documented and implemented dynamic workflow project by using
NHibernate on backend
. Worked on mobile web voting application by using MVC 3 with Entity
Framework
. Implemented several controllers with many views and some helper
methods as well
. Participated in Classic Asp to Asp.net integration project
. Developed new features based on customer requirement and worked with
QA to ensure the quality.
. Coded Ajax enabled WCF services used by client side
. Maintained existing application and performed performance tuning and
bug fixing.
. Mentored junior developers to resolve more complex issues
Environment: MS Visual Studio 2010, Net 4.0, C#.Net, ASP.Net, MVC 3,
JQuery, LINQ, NHibernate, ADO.Net. MS SQL Server 2008, IIS 7, Visual Studio
Team Foundation Server, Jira
Compliance Associates Toronto Canada
7/2007 --- 6/2010
Senior Software Engineer
Compliance Associates-- Computer System Validation Technology provides
practical and economic solution to life science Industries.
CA-Validator is a software solution for computerized system validation
needs and compliance requirements widely applied on pharmaceutical
industries which dramatically speeds up the validating document
preparation, creation and approval processing and also is highly
configurable for SQL Server or Oracle database and Windows or Forms
authentication.
CA-TRM is training resource management software to help client to increase
efficiencies and reduce redundancies through maintaining and tracking
employee training record, providing training course and instructions either
in class or online
.
Responsibilities:
. Designed and implemented service-oriented architecture (SOA) suitable
for secure, reliable and high-performance deployment.
. Communicated with clients to collect and analysis the business
requirements and produce the functional and design specifications.
. Developed highly interactive and richer user interface by using
ASP.Net Ajax and Telerik RAD Control, as well as created many Customer
Web User Controls
. Coded SOAP web service and created project deliverable tree structure
by using XML/XSD/XSLT
. Implemented Data Access Layer by using Microsoft Enterprise Library
Data Access Block
. Modified and created variety crystal reports upon requirements
. Created window service to implement Validator Task Management module
(including auto email notification, scheduling etc)
. Involved system integration test and user acceptance test.
Communicated with QA team to ensure quality.
Environment: MS Visual Studio 2008, Net 3.5, C#.Net, ASP.Net, Ajax, LINQ,
ADO.Net. MS SQL Server 2005/2008, Oracle 10g, Windows Server 2003, IIS 6,
Source Safe 6.0, Crystal Report, Telerik RadControl
SSQ Technology Company Toronto Canada
9/2006 --- 7/2007
.Net Developer
SSQ Technology Ltd is an international software and IT solutions company
based in Toronto, Canada, with offices in Sydney, Australia, and Shanghai,
China.
V-CMS provides user friendly College Management System to capture key
information in electronic format, automate core daily operations, provide
analytical report to improve students satisfactions.
Responsibilities:
. Participated in system analysis and design by using class diagram
. Involved in the development of the database by using Microsoft SQL
Server 2005
. Architected and developed XML web services for the student tuition fee
updating and tracking purpose including online payment
. Implemented and tested student management module, classes, stored
procedures, and Web Forms/Pages to achieve the application
functionalities
. Create variety customer search user control widely used in whole
application
. Developed Newsletter Notification Windows Service to send students
updated news daily and weekly
. Designed and developed kinds of reports and forms by using Crystal
Report
Environment: MS Visual Studio 2005 Team Suite, Team Foundation Server .Net
2.0, C#.Net, ASP.Net, ADO.Net. MS SQL Server 2005, Windows Server 2003, IIS
6, UML
Emerson & Associates Inc. Toronto Canada
06/2003 - 8/2006
Software Developer
Emerson & Associates provides Business Consulting, Accounting Service,
Architectural & Engineering, and IT Solution / Services for Business
Management.
EPMS (Payroll Management System) provides web based time sheet management
functionalities based on both project and employee. With this application,
office (indoor) employees can enter daily-based hour log while other
employees are weekly-based. Financial department can produce payroll and
reports by the tracked hours.
EBMS (Engineering Budget Planning System) is a windows application to help
the Construction and Architecture Company to plan, design and prepare
engineering budget quickly, accurately and also modified accordingly. This
software also provides variety of report and chart for analysis and
management.
Responsibilities:
. Interviewed accounting clerks and employees, and identified sources of
data to provide both user requirements and system analysis
documentations
. Defined specific access rights at the user level, produced variety
Crystal reporting services utilized by incorporation management
. Developed XML Web Service Layer components, writing the web service
method interfaces between Data Process components and business
components
. Designed Payroll database on SQL Server 2000; performed Data Modeling
using ER diagrams and Normalization
Environment: Visual Studio 2003/2005, Net 1.1/Net 2.0, Asp.net, SQL Server
2000/2005, VB.net, Windows 2003, Source Safe
Maple Leaf Consulting Toronto Canada
9/2002 - 05/2003
Web Developer
Maple Leaf Consulting Inc. provided Software Application and Implementation
Services for small businesses
Main projects: web sites for small business
TECHNICAL SKILLS
Programming: Microsoft C#.NET, VB.NET, ADO.NET, ASP.NET, MVC, Visual
Basic, JavaScript, VBScript, MS ASP, HTML, DHTML, T-SQL,
ADO, OLEDB, ODBC, XPATH, XSLFO, CRYSTAL REPORT, Entity
Framework, HL7
Web HTTP, HTTPS, TCP/IP, FTP, HTML, DHTML, ASP, XML/XSL,
Technologies: VBScript, JavaScript, Web Service (UDDI, WSDL, SOAP), Ajax,
JQuery, Knockout JS
Database: Microsoft SQL Server 2000/2005/2008, Oracle 10g, Access
2000, T-SQL and PL/SQL
Tools: UML, MS Visio, Rational Rose, CRYSTAL REPORT, XMLSPY2005,
LiquidXML, SOAPUI, Mirth Connect
EDUCATION & CERTIFICATIONS
. Certification for Project Management for Software Development
2013
. MCTS for Web Application
2007
. Diploma of Computer Programming, Seneca College
2000-2002
. Bachelor of Engineering Shanghai Tongji University
1987-1991
Roger Yuan
Contact this candidate