Developer Service

Bill Zheng

** ***** ***. ******* ** L*C *W*

647-***-**** Email: ******@*******.***

OBJECTIVE

.Net and SQL Developer

SUMMARY:

1) M.S. in Computer Science

2) 25 years of full lifecycle software development experience and 15 years in .Net,

3) Hands-on experience with ASP.Net, VB, C#, MVC, WCF, WPF, XML, HTML, ADO.NET, Web Service, Web API, Web Socket, CSS, JQuery, Ajax, JavaScript, Typescript, Jeditable.js, Notify.js, Razor, Angular, Dapper, LINQ, SignalR, Entity, Crystal Report, SSRS, SSIS, SQL Server, Oracle, T-SQL, Postman…

4) Excellent knowledge in .Net Framework, .Net Core, Micro Service, Azure, AWS, Agile, CI/CD, GitHub,Bootstrap,ReactJS, SSO,OO, SOLID,TFS, MongoDB, OAuth, JWT,SaaS,CRM,ERP, RabbitMQ …

5) Strong experience in PowerBuilder, Visual Basic, C/C

6)Focused, self-motivated, effective team player and quick learner

EXPERIENCES

Knowledge First Financial ( Mississauga )

Time: 03/01/2018 – 02/28/2021

Position: Sr. Net & SQL Server developer

For over 50 years, Knowledge First Financial has been dedicated to helping Canadian families with Registered Education Savings Plans (RESP). Since 1965, the company has paid $3.6 billion to customers and students, and today manages $3.62 billion in assets on behalf of more than 250,000 customers.

I am a primary developer for the following projects based on Visual Studio 2017, SQL Server 2015 and Azure:

Stars_Trade (Web API, SinalR, WebSocket, Dapper,Postman)

This is a Web Form App for our invest department to trade the future and stock by the Web API from Interactive Brokers®.

.

1)Market Price (ask price, bid price) will be gotten by WebSocket and push to the client side based on SinalR.

2)Plan Order (Conditional Order) will be submitted only when the market price is same with the price of Plan Order.

3)Live Order can be update or delete based on the different status

4)Trade Position (Trade Policy) is separated by the different traders even we only have three accounts in Interactive Brokers®.

5)Trade History and Report

Stars_Direct (MVC, Razor, Dapper)

This is a MVC App rebuilt by ASP.NET, keep the same functions with before and change the data access layer form CRM to Entity Framework.

1)Client Profile Page

2)Agreement Page

3)User Account and Permission Page

4)Commission View Page

5)Advanced Search Page

Stars (WPF, Entity Framework)

This is a WPF App for our finical staffs to manage the RESP.

1)Bank Deposit

2)Bank Stop Payment

3)Financial Transfer

4)Financial Transactions detail

5)Advanced search for agreement, student, subscriber

Integration Service (SSDT, SSIS, SSRS)

Knowledge First Financial created many service packages based on the SSIS and also transferred the all reports from Crystal Report to SSRS.

1)Send the invoice documents by email attachment(SSIS,SSRS)

2)Play video for Happy new year, Christmas and Birth Day by email

3)Loyalty Bonus Allocate

4)Bank File Stop Payment

5)Commission and interest Collecting

6)a batch of DTL packages and SSRS Reports

Great Exposure Inc. ( Toronto downtown )

Time: 04/30/2008 – 02/28/2018

Position: Sr. Net & SQL Server developer

Great Exposure Inc. presents a Canada’s largest education directory: CampusLogin.com. includes 2 models: lead center and student center.

I am a primary developer for the following projects based on Visual Studio 2008,2012,2015, SQL Server 2008,2012,2015 and TFS:

VoIP Integration (MVC, WCF, SignalR, Cisco, Twilio)

VoIP Integration is to merge the different type of web phone into CampusLogin.

I designed and developed the following features .

1)Create the web phone based on the different types (Cisco, Twilio).

2)Pop up the contact sheet when the phone comes in based on the phone number.

3)Call out from the contact sheet when click the button of phone call.

4)Save the note and log when the call is ended.

Admin Tool ( Angular 2, Restful Web Service)

Admin Tool is for the project managers to manage the school ..

1)Modify the school configuration.

2)Modify the school policy.

3)Modify the school template.

4)Collect the school fee.

5)Create the ticket from school.

eBill ( SSIS, SSRS)

eBill is designed to send the invoices to the customers by email based on the schedule. I created the configurable functions for the system.

6)Email configuration: receive email, subject, title, Cc, Bcc, failed email.

7)Schedule configuration: daily, weekly, monthly and yearly.

8)Generate invoice as attached document by SSRS.

9)Send email based the schedule by SSIS.

10)Report: successful records, failed records, error messages and resend.

Data Upload Tool ( Web Form, Entity Framework)

I designed and implemented the workflow of dynamic data upload based on profile template.

1)Universal Field mapping: transfer the third party fields into Campuslogin based on the profile template.

2)Data ID mapping: program ID, course ID, country ID, province ID…

3)Data validation: data type, max length, format based on the database schema.

4)Report: successful records, failed records, error messages.

Database performance improvement (SSDT,SSIS, SSRS)

Re-engineering legacy database system:

1)Analyzing requirements, technical design and development.

2)One database server was separated into 2 servers: Canada and America.

3)Separated one database into 20 databases based on school ID.

4)Separated one table into 2 tables: active table and backend table based on the policy.

5)Transfer the records from the active table into backend table at night based on policy (SSIS, SSRS).

Guangzhou Commercial Bank, China

Time : 07/1997 – 06/2007

Position : Team leader, designer and developer

Bank Online Service ( .Net, Oracle 9i and Crystal Report)

This project is designed to provide the bank’s customers to open,edit and view the accounts in online banking system. I was a team leader, designer and developer in this project:

1)Analyzed requirements, designed the data models and work flows.

2)Designed and implemented Customer information registration/retrieving.

3)Designed and implemented the rule of access permission.

4)Designed and implemented the view transactions page.

5)Designed and implemented the money transfer function.

6)Designed the daily, monthly, period reports.

Retail Banking System(VB6, Oracle 8i and Crystal Report )

This project is designed to provide the bank’s staffs to open,edit and manage the client accounts. I was a team leader, designer and developer in this project:

1)Analyzed requirements, designed the data models and work flows.

2)Assigned the tasks based on their skill sets.

3)Designed and Implemented the money transfer function

4)Designed and Implemented the menu of bill edit function

5)Designed and implemented the schedule bill payment function

EDUCATION:

M.S. in Computer Science 09/1994 - 07/1997

South China University of Technology, Guangzhou, CHINA

B.S. in Computer Science 09/1990 –07/1994

South China University of Technology, Guangzhou, CHINA

Contact this candidate