Jun Li Email & Phone Number

Ottawa, Ontario, Canada

TBS ensures tax dollars are spent wisely and effectively for Canadians. It oversee and provide guidance to the Treasury Board of Ministers on how government is managed and how it regulates. It leads on digital transformation and employ a diverse and inclusive public service. Project 1 TBSQuestionnaire Web API and UI ComponentsSenior Solution ArchitectOctober 2023 – April 2024Task Performed• Being a senior solution architect and lead a team to go through the… Show more TBS ensures tax dollars are spent wisely and effectively for Canadians. It oversee and provide guidance to the Treasury Board of Ministers on how government is managed and how it regulates. It leads on digital transformation and employ a diverse and inclusive public service. Project 1 TBSQuestionnaire Web API and UI ComponentsSenior Solution ArchitectOctober 2023 – April 2024Task Performed• Being a senior solution architect and lead a team to go through the Architecture Design phase with deliverables of Questionnaire Web API Architecture Design documentation, one Proof-of-Concept ASP.NET CORE Web API project and one Angular based SPA UI project • Followed Agile Practice to collect business requirements, provide architectural overview and design project components• Design and implement tree data structure based generic questionnaire database• Developed hands-on Proof-of-Concept RESTful Web API using .NET Core 6.0, Entity Framework Core 6.0 and Swagger 6.5 following Open API 3.0 specification• Create dynamic rule engines and validators using expression tree to make application declarative rather than imperative• Followed Open API 3.0 specification and provided Web API version control• Created and published NuGet packages for reusability• Developed hands-on Agular front-end JavaScript-based User Interface to demonstrate the reusability and extendibility• Use NgRx framework for Angular front-end state management to make application Reactive and Responsive• Provided suggestion to deploy the Proof-of-Concept applications to cloud using Azure App Service and Azure functions• Completed deliverables ahead of time and exceeded expectation Show less

Ottawa, Ontario, Canada

Gemini Project DescriptionGemini is an in-house build of Line of Business Suite for Risk Management for Insurance or Loan applicants. It is a SPA – React JS and .NET Core based Single Page Application.Tasks Performed• Attended daily Scrum Huddle and worked closely with a big team with more than 30 members• Went through Technical Impact Analysis before any bug fixing and new Change Request in order to limit the change scope and reduce the regression testing• Used Azure DevOps… Show more Gemini Project DescriptionGemini is an in-house build of Line of Business Suite for Risk Management for Insurance or Loan applicants. It is a SPA – React JS and .NET Core based Single Page Application.Tasks Performed• Attended daily Scrum Huddle and worked closely with a big team with more than 30 members• Went through Technical Impact Analysis before any bug fixing and new Change Request in order to limit the change scope and reduce the regression testing• Used Azure DevOps to do project management, source control and CICD build and release pipelines• Followed MVC and MVVM (Model - View - View Model) design pattern• Used ReactJS, TypeScript, JavaScript, CSS for front end development, created React Modules, component, reactive forms for input entry validations and Observables/Subscription to pass objects and messages among parts of the application. Authentication and Authorization using JWT based secured Web API call to form submission to the backend.• Used .NET Core and C# for backend business layer, created ASP.NET Core Web APIs (RESTful) secured by SSL, single sign on (SSO) and authenticated by SAML, authorized by OAuth 2.0 with JSON Web Token (JWT)• Used MS SQL 2019 for database layer backend and use Event Source Pattern to store transaction data• Used T-SQL to program Stored Procedures and Functions and LINQ-SQL ADO.NET to access database• Saved complicated business rules into database and used .NET Core Expression Tree to implement Business Rules Engine (BRE)• Designed event driven Azure Functions to handle email notifications and daily scheduled data processing tasks at the background• Used Jasmine framework for unit test and Cypress for E2E Integration test• Used Python and Selenium platform to test system robust and security• Used Azure DevOps for project management, source control and CICD pipelines for build and release to Azure App Service Azure Functions Show less

Ottawa, Ontario, Canada

Project DescriptionInvoice is the 3rd module of EDC’s P2P Financial System and manages all the organization’s incoming invoices for Accounts Payable.Tasks Performed• Team Leader of 3 Developers• Used Share Point 2013 Team Site for daily Agile huddle and project management• Used MS Team Foundation Server 2017 for source control, build and release• Used T-SQL for Queries, Stored Procedures and Functions in Microsoft SQL Server• Used Microsoft SQL Reporting Services to… Show more Project DescriptionInvoice is the 3rd module of EDC’s P2P Financial System and manages all the organization’s incoming invoices for Accounts Payable.Tasks Performed• Team Leader of 3 Developers• Used Share Point 2013 Team Site for daily Agile huddle and project management• Used MS Team Foundation Server 2017 for source control, build and release• Used T-SQL for Queries, Stored Procedures and Functions in Microsoft SQL Server• Used Microsoft SQL Reporting Services to generate reports for business analysis• Used Visual Studio 2017, JavaScript, jQuery, ASP.NET Core MVC, Entity Framework 6, LINQ, jQuery, ASP.NET Web API and Web Experience Toolkit (WET) to make application accessibility WCAG 2.1 AA level compatible• Customized Human workflow engine using BPMN (business Process Modeling Notation) and Commercial Off the Shelf (COTS) by AgilePoint• Created Human workflow to manage Invoice Approval process• Used .NET Core Expression Tree to dynamically create and configure Business Rule Engine (BRE)• Integrated ASP.NET API with third party SOA management suite by Akana• Provided and Consumed SOA web services through XML, ESB to integrate with PeopleSoft and IBM Main Frame• Went through Technical Impact Analysis before any bug fixing and new Change Request, took advantage of Object-Oriented Design’s Encapsulation, Abstraction, Inheritance and Polymorphism to limit the change scope and reduce the regression testing Show less

Ottawa, Ontario, Canada

Project DescriptionExpense Reimbursement is the 2nd module of EDC’s P2P Financial System and manages all the organization’s expense reimbursements for Accounts Payable.Tasks Performed• Team Leader of 4 Developers• Used T-SQL for programming Queries, Stored Procedures and Functions in Microsoft SQL Server 2012 and Microsoft SQL Reporting Services• Visual Studio 2010, JavaScript, jQuery, .NET framework 4.8, ASP.NET MVC 2, Entity Framework 4, jQuery and Web Experience Toolkit… Show more Project DescriptionExpense Reimbursement is the 2nd module of EDC’s P2P Financial System and manages all the organization’s expense reimbursements for Accounts Payable.Tasks Performed• Team Leader of 4 Developers• Used T-SQL for programming Queries, Stored Procedures and Functions in Microsoft SQL Server 2012 and Microsoft SQL Reporting Services• Visual Studio 2010, JavaScript, jQuery, .NET framework 4.8, ASP.NET MVC 2, Entity Framework 4, jQuery and Web Experience Toolkit (WET) to make application accessibility WCAG 2.1 AA level compatible• Used Expression Tree to dynamically create and configure Business Rule Engine (BRE)• Customized Human workflow engine using BPMN (business Process Modeling Notation) and Commercial Off the Shelf (COTS) by AgilePoint• Created Human workflow to manage Invoice Approval process• Integrated ASP.NET Web API with third party SOA management suite by Akana• Provided and Consumed SOA web services through XML, ESB to integrate with PeopleSoft and IBM Main Frame• Went through Technical Impact Analysis before any bug fixing and new Change Request, took advantage of Interface based Object-Oriented Design to limit the change scope and reduce the regression testing Show less

Ottawa, Ontario, Canada

Project DescriptionProcurement to Pay is the 1st module of EDC’s P2P Financial System and manages all the organization’s procurement orders.Tasks Performed• Team Leader of 4 Developers• T-SQL in Microsoft SQL Server 2008, MS SQL Reporting Services• Visual Studio 2010, JavaScript, Ajax, .NET framework 4.5, ASP.NET MVC 2, Entity Framework 4, jQuery and Web Experience Toolkit (WET) to make application accessibility WCAG 2.1 AA level compatible• Customized Human workflow… Show more Project DescriptionProcurement to Pay is the 1st module of EDC’s P2P Financial System and manages all the organization’s procurement orders.Tasks Performed• Team Leader of 4 Developers• T-SQL in Microsoft SQL Server 2008, MS SQL Reporting Services• Visual Studio 2010, JavaScript, Ajax, .NET framework 4.5, ASP.NET MVC 2, Entity Framework 4, jQuery and Web Experience Toolkit (WET) to make application accessibility WCAG 2.1 AA level compatible• Customized Human workflow engine using BPMN (business Process Modeling Notation) and database• Integrated ASP.NET Web API with third party SOA management suite by Akana• Provided and Consumed SOA web services through XML, ESB to integrate with PeopleSoft and IBM Main Frame• Went through Software Change Impact Analysis before any bug fixing and new Change Request, took advantage of Interface based Object-Oriented Design in order to limit the change scope and reduce the regression testing Show less

Ottawa, Ontario, Canada

Project DescriptionHouse of Commons is a component of the Parliament of Canada.Project 6a): PRISM Migration: PRISM application was a legacy VB6/COM/COM+ and ASP 3.0 web application running for almost 10 years and needed to be migrated and re-factored to the new .NET 3.5 application framework. Project 6b): TIMS (Telecommunications Information Management System): TIMS is a Windows Smart Client application running on .NET 3.5, CSLA.NET and Microsoft Composite Application Block… Show more Project DescriptionHouse of Commons is a component of the Parliament of Canada.Project 6a): PRISM Migration: PRISM application was a legacy VB6/COM/COM+ and ASP 3.0 web application running for almost 10 years and needed to be migrated and re-factored to the new .NET 3.5 application framework. Project 6b): TIMS (Telecommunications Information Management System): TIMS is a Windows Smart Client application running on .NET 3.5, CSLA.NET and Microsoft Composite Application Block framework for tracking and managing Organization’s Telecommunication Devices and Services. Project 6c): Smart Book: Smart Book was an ASP.NET 3.5 web-based content management system allowing users to manage and publish contents to internal and external websites. Tasks Performed• Followed Object-Oriented Design paradigm and created UML architectural diagrams• Wrote PL/SQL Stored Procedures, Functions in Oracle Database 11g• Used Visual Studio 2008, VB.NET, .NET 3.5, CSLA.NET Business Objects, 3rd party Infragistics controls, Crystal Reporting Services• Used Microsoft TFS (Team Foundation Server) 2008 for source control, bug tracking, task management and continuous integration Show less

Ottawa, Ontario, Canada

Project DescriptionCanada Deposit Insurance Corporation (CDIC) is a Federal Crown Corporation. CDIC insures Canadians’ savings in case their bank or other CDIC member institution fails or goes bankrupt.Project 7a) Data Warehouse Interface: Data Warehouse Interface project was a Windows Desktop Application extracting data from different sources into CDIC’s backend data warehouse.Project 7b) E-Filing: E-Filing was a J2EE web application allowing CDIC member institutions to submit… Show more Project DescriptionCanada Deposit Insurance Corporation (CDIC) is a Federal Crown Corporation. CDIC insures Canadians’ savings in case their bank or other CDIC member institution fails or goes bankrupt.Project 7a) Data Warehouse Interface: Data Warehouse Interface project was a Windows Desktop Application extracting data from different sources into CDIC’s backend data warehouse.Project 7b) E-Filing: E-Filing was a J2EE web application allowing CDIC member institutions to submit their annual financial reports as secured electronic forms at the end of each fiscal year using encrypted Internet connections.Tasks Performed• ETL (Extract, Transform and Load) on MS SQL 2005 from Oracle, DB2, MS-Access, XML and flat file etc.• Create data analysis reports using T-SQL and Crystal Report• JBOSS application server, J2EE, JSP and Java servlets • PL/SQL in Oracle database server Show less

Ottawa, Ontario, Canada

Project DescriptionExport Development Canada (EDC) is a Federal Crown corporation providing financial and risk management services, including insurance and bonding, to Canadian companies exporting goods and services or investing in other countries.Project 8a) Online Declaration: Online Declaration was an ASP.NET 2.0 web application allowing Canadian exporters to register and declare their exports and calculate the insurance premium based on the exporting items, destinations, risk… Show more Project DescriptionExport Development Canada (EDC) is a Federal Crown corporation providing financial and risk management services, including insurance and bonding, to Canadian companies exporting goods and services or investing in other countries.Project 8a) Online Declaration: Online Declaration was an ASP.NET 2.0 web application allowing Canadian exporters to register and declare their exports and calculate the insurance premium based on the exporting items, destinations, risk factors and credit histories. This application was designed to replace the old paper process with online forms to make communication channels between policy holders and underwriters more open and efficient.Project 8b) Express Claims: Express Claims was an ASP.NET 2.0 web application allowing EDC’s customers to file their claims online. Tasks Performed• Followed OOD (Object Oriented Design) and design patterns and 3-tier Web Application• .NET 2.0, C#, ASP.NET 2.0, HTML, JavaScript, Web Services Enhancements 2.0, Adobe Live cycle, Microsoft Enterprise Libraries 2.0 and Crystal Reports 8.5• T-SQL for Microsoft SQL Server 2000• Canadian Government's Common Look and Feel 2.0 to make application compatible to WCAG2.0 AA• Used Royal Bank Moneris POS COTS system• Code integration and testing using NAnt, NUnit, NCover Show less

Ottawa, Ontario, Canada

Project DescriptionWorkstream Inc. is a Human Resource Software industrial leader listed in NASDAQ (Symbol: WSTM). Project 9a) Performance: Performance was an ASP.NET 1.1 Web Application running on SQL 2000 database backend to evaluate employees' performance in an organization.Project 9b) Online Survey: Online Survey was an ASP.NET 1.1 Web Application running on SQL 2000 database backend to provide online survey services.Tasks Performed• .NET 1.1 Framework, ASP.NET 1.1… Show more Project DescriptionWorkstream Inc. is a Human Resource Software industrial leader listed in NASDAQ (Symbol: WSTM). Project 9a) Performance: Performance was an ASP.NET 1.1 Web Application running on SQL 2000 database backend to evaluate employees' performance in an organization.Project 9b) Online Survey: Online Survey was an ASP.NET 1.1 Web Application running on SQL 2000 database backend to provide online survey services.Tasks Performed• .NET 1.1 Framework, ASP.NET 1.1, HTML, JavaScript, VB.NET, ADO.NET and Crystal Reports 8.5• T-SQL and MS SQL 2000. Show less

Ottawa, Ontario, Canada

Project DescriptionMarch Networks is an industrial leader in Video over IP technology listed in Toronto Exchange (Symbol: MN.TO).Tele-Health was a web based healthcare product allowing high-quality video conference and real-time vital sign gathering between patients and their caregivers, with all the administration and billing processing electronically done simultaneously through the Internet. Tasks Performed• 3-tier web application• ASP 3.0, ActiveX controls, COM/COM+, IIS… Show more Project DescriptionMarch Networks is an industrial leader in Video over IP technology listed in Toronto Exchange (Symbol: MN.TO).Tele-Health was a web based healthcare product allowing high-quality video conference and real-time vital sign gathering between patients and their caregivers, with all the administration and billing processing electronically done simultaneously through the Internet. Tasks Performed• 3-tier web application• ASP 3.0, ActiveX controls, COM/COM+, IIS 5.0, Crystal Report 8.5 and MS SQL 2000• .NET framework 1.1, ASP.NET 1.1, C# and C++ ActiveX controls • T-SQL and Microsoft SQL Server 2000 Show less

Ottawa, Ontario, Canada

Project DescriptionE-Cruiter 3.0 was an ASP based Web human resource management system evolving from version 1.0, 2.0 to 3.0Tasks Performed• 3-tier web based application using Cold Fusion 4.0• T-SQL for Microsoft SQL Server 7