.Net Developer /w 12+ yrs .Net and SQL

RESUME - Andrew HUANG

Page * of * ****.**.** **:*7:57

Andrew HUANG Microsoft Certified Professional (MCP)

12+ years extensive and diverse experience in .NET and SQL.

Solid skills in requirement definition, analysis, design, coding, testing and implementation.

Highly creative, technically skilled and result-focused team player with excellent analytical and communication skills.

TECHNICAL SKILLS:

Microsoft .Net: 12+ years, C#.NET, VB.NET, ASP.NET/MVC, Workflow, WPF, WCF

Database: 12+ years, SQL, DTS, SSIS and SSAS (MDX). MySQL (1 year)

Report: 7+ years Crystal Report, SSRS

Design: 12+ years SDLC, UML (with Visio), O-O Design

Version Control: SourceSafe, TFS and Mercurial.

Others: VBScript, JavaScript, AngularJS, jQuery, VBA, XML, JSON, API, Codejock, Log4Net, JIRA, Azure.

WORKING EXPERIENCE

SYSPRO Canada, Toronto. May 2012 – Feb 2018

SYSPRO’s Enterprise Resource Planning solution serves a broad range of industries across the disciplines of Manufacturing and Distribution.

As Developer, I’m responsible for Requirement Definition, Details Design, Development, Testing and Deployment, Troubleshooting and Training. I developed 200+ projects (Window form, Web and SYSPRO Customization) for 60+ clients, for example

Purchase Journal: Using C# + WPF, Codejock and Log4Net with SQL (SP, trigger, job) to integrate PO query, supply chain transfer, Vendor and sales by warehouse etc..

Payment: Using C# + WPF, VBScript and JSON to implement Chase, GlobalPay, Moneris and Paypal.

Quote Print: Using ASP.NET/MVC (C#), SQL to export formatted word document.

Import and export: including DTS, SSAS, SSIS, EFT, EDI, CRM, Excel, Xml, CSV etc.

Troubleshooting/Customization: Fixing issues as routine from support team, including all above and VBScript, JavaScript, AngularJS, jQuery, JSON

Genius Solutions, Toronto. Nov 2010 – Mar 2012

GeniusTM Solutions delivers manufacturing and job management solutions for custom, engineer-to-order, make-to-order, assemble-to-order environments and companies engaged in manufacturing improvement strategies like Lean Manufacturing.

Project Genius NG Setup: It is for validation, configuration and installation of all stuff related Genius product – Genius Manufacturing NG. In this project, as Development Analyst, I involved requirement analysis, prototype and development, and more improvement from version 1.0 to 1.4:

.Net Developer

Email: ***********@*******.*** Tel: 647-***-**** RESUME - Andrew HUANG

Page 2 of 3 2018.03.14 10:47:57

Project Genius Repair: It is for repairing Genius products by Genius customer support. Techniques included WPF.

Project Genius Setup Tools: It is for auto releasing new version of Genius Setup. Techniques included WPF, Google translation and DotNetZip etc. Morneau Sobeco, Toronto. July 2007 – August 2008

For more than 40 years, Morneau Sobeco has provided integrated human resource solutions for all types of pension, group benefits, and compensation plans.

As System Development Analyst, completed DC Component Verification Project, SCM Process Guidance Using Microsoft VSTS, Product Release.

TFS (Microsoft Team Foundation System) Backup and Restore Project: This project required a thorough understanding of all steps and scenarios, including setup/config TFS, Visual Studio 2005, SQL Server 2005 and SharePoint 3.0.

N-Dimension Solutions Inc. (NDSI), Toronto June – October 2006 It is owned and operated by employees with extensive industry backgrounds in IT Security, IT Infrastructure, Internetworking, Telecommunications and Software Development.

As Programming Analyst, The project list I completed:

- Data Conversion: from network security log files to XML and then Database - SQL Server/MySQL. Techniques involved were VB.NET+ SQL Server/MySQL.

- Report and Enquiry: Over 60 reports were generated for the log files. Techniques involved were ASP.NET+ VB.NET/C#.NET+ Crystal Report+ JavaScript+ CSS+ SQL Server/MySQL with stored procedures. Both Form-Based and Web-Based versions. Mway Information Technology Ltd. Co., Hong Kong/Beijing, P.R. China May 2001 – August 2005

Mway is a software company which mainly services for Aircraft Engineering.

As Team Leader, participated in HAECO System Migration Project team, I was responsible for Material Control System from Requirement Definition and Analysis, System Design to Coding, Testing and implementation by following SDLC and Change Control. MCS was implemented and running on September, 2004.

Siemens Business Service (SBS) GmbH & Co., Siemens Ltd., Beijing, P.R. China. May 1996 – May 2001

As System Analyst, I was responsible for presale, system design and coding on Civil Aviation area. In SPIA (Shanghai Pudong International Airport) System Integration (Phase I) Project, I participated from bidding to airport opening, included presale, requirement analysis, system design and coding. At the same time, be responsible for the development of IQS (Integration Query System) and ABS

(Aviation Billing System).

Technologies involved in Web page with ASP, Business Rule with Visual Interdev 6.0 and Visual Basic 6.0, Interface with Visual C++ 6.0, Database with Oracle 7i and Designer 2000/Developer 2000, Unix (HP-UX 10.20) on HP 9000.

EDUCATION & TRAINING

Shanghai University, Shanghai, P.R. China

Computer Science - Artificial Intelligence and Expert System. M.S. Nankai University, Tianjin, P.R. China

RESUME - Andrew HUANG

Page 3 of 3 2018.03.14 10:47:57

Mathematics. B.S.

Hobby

Bridge, Go and Sudoku

Contact this candidate