jason ji

IT Professional with 16+ years of hands-on and demonstrated experience in BizTalk Server 2013 R2/2016/2020 Development/Administration and Cloud-based solutions in various industry segments including Ontario government, Health Care Organizations, Financial Institutions, and logistic corporations based on Azure IaaS, PaaS and SaaS, .NET Framework, .NET Core, Microsoft SharePoint/MOSS, Microsoft Dynamic CRM, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Analysis Service (SSAS), IBM IMS/CICS, and Oracle 11g.

BizTalk Technical Expert– Alectra, Toronto ON                                                            (1/2022 – Present)

Project: Alectra Middleware Solution Assessment

• Evaluated and assessed the multi-server High Available Middleware production environment. 
• Analyzed upcoming real-time customer experience integration requirements.
• Provided system capacity evaluation reports to accommodate API integration requests.
• Checked and validated the system scalability across multiple tiers.
• Analyzed Nutanix Disaster Recovery solution with Backups and restoration consideration.
• Provided final recommendations for the design, implementation, architecture, configuration, software, guidance, use case and costs for production and test environments for the current and future customer experience platform integration requirements.

Environment:  BizTalk 20016/2020, Oracle CC&B, Web Services, .NET, SQL AlwaysOn Availability Group, SQL AlwaysOn FCI, SQL Server 2016/2019, Nutanix, Azure Site Recovery, Nutanix Disaster Recovery, Visio

BizTalk Technical Expert – PwC Canada, Toronto ON                                                       (3/2021 – 12/2022)

Project: PwC Human Resources Service Delivery System

• Architected and developed cloud integration solution with .NET core and Azure PaaS.
• Implemented and orchestrated multiple Azure resources to address integration needful.
• Designed and developed Azure functions to address the custom integration logic.
• Integrated HTTP-triggered Azure functions with Azure API management service.
• Developed and deployed logic App and ADF to integrate data from heterogeneous sources.
• Optimized the Azure logic apps and function apps with the best practices and design patterns.
• Diagnosed, troubleshoot and resolved the throttling problem on logic app workflows.
• Created and configured CI/CD pipelines to automate continuous integration and delivery.

Environment:  Azure Storage, SQL Server 2019, Azure API Management, Azure Logic App, Azure Service Bus, Azure Functions, Azure Data Factory, Azure DevOps, Azure Key Vault, Azure ARM, Azure CLI

Project: PwC Sightline Resource Management Portal 

• Architected and designed system integration through Web API. 
• Designed and developed Azure Functions to address data integration with remote APIs.
• Exposed function endpoints through API gateway by enforcing JWT Token check.
• Created and scheduled Logic App to address report generation tasks. 
• Implemented function error handling through service bus poison queue and azure alerts.
• Created, configured, and maintained CI/CD pipelines on continuous integration and delivery.
• Troubleshoot, diagnosed, and instrumented function apps through Application Insights.
• Throttled Azure Functions to safeguard the overall Function Apps environment. 
• Monitored and maintained Function App through Azure Alerts and Application Insight metrics.

Environment:  Azure App Insight, Azure Storage, SQL Server 2019, Azure API Management, Azure Logic App, Azure Service Bus, Azure Functions, Azure Data Factory, Azure DevOps, Azure Key Vault, Azure ARM

Project: PwC Middleware Migration from BizTalk to Cloud

• Architected and designed BizTalk to Cloud migration plan in Azure IaaS environment. 
• Implemented seamless hybrid operation based on on-premises Active Directory Domain Services, Federated single sign-on (SSO), and Active Directory Federation Services (AD FS).
• Configured and validated integration infrastructure environment based on Azure. 
• Migrated Middleware applications from BizTalk 2013 R2 to BizTalk 2020 environment.
• Estimated, evaluated, and designed cloud-based BizTalk architecture based on Azure IaaS. 
• Developed and built BizTalk Artifacts such as schema, maps, orchestrations and pipelines.
• Implemented BizTalk LOB system integration and communication via MS adapter Pack.
• Evaluated Disaster Recovery Plan for SQL Server in the highly available environment.
• Installed and configured BizTalk 2020 and deployed BizTalk applications to BizTalk 2020 servers.

Environment:  BizTalk 2020, SQL Server 2019, SQL Server AlwaysOn HA, Azure CLI, PowerShell, HTTP/HTTPS, SFTP/FTP, TSQL, Map, Schema, Orchestration, Adapters, IIS, SSL, TLS, WCF/WCF-Web HTTP, SOAP, SOAPUI

BizTalk Technical Expert– Agricorp, Guelph ON                                                                    (6/2020 – 2/2021)

Project: Agricorp ESB Integration Solution Upgrade and Migration

• Migrated the custom ESB solution from BizTalk 2013 to BizTalk 2016 environment.
• Upgraded and deployed .NET applications into a cloud-based hosting service. 
• Migrated SharePoint 2010 to SharePoint 365 Online, built and deployed SharePoint Power Apps.
• Created and configure CI/CD pipelines to automate continuous integration and delivery.
• Developed and deployed Logic App and Azure Data Factory to address data integration Troubleshoot and diagnose application issues via Event logs, IIS logs, SQL query, and SQL trace.
• Leveraged Management Pack to manage and monitor BizTalk Servers and Integration apps.  

Environment:  Azure, BizTalk 2016 Management Pack, Azure API Management, Azure Logic App, Azure SQL Database, Azure Data Factory, Siebel, Guidewire, WCF, SharePoint 365, Azure CLI, SSMS, Power Shell

BizTalk Technical Expert – BGIS, Toronto ON                                                                            (3/2020 – 6/2020)

Project: Contact Manager Solution  

• Designed and built data-driven Web-based app portal with responsive, interactive features based on Bootstrap Material UI, ASP.NET Web API.
• Developed and tested web pages that meet accessibility and web browser standards. 
• Applied and automated CI/CD pipelines for multiple layers in multi-environments.
• Involved in and practiced Agile (SCRUM) project management with sprint and backlog planning. 
• Participated in Daily Standups, Sprint retro, Sprint Demos, Story Grooming and Release planning. 

Environment:  Azure DevOps, C#, PowerShell, Azure PaaS, Azure IaaS, Web API, ASPNET Core, ACI, AKS,  Azure CLI 2.0, Docker for Windows, Kubernetes CLI, Azure SQL, Git, Angular 7, Oracle, PLSQL 

BizTalk Technical Expert – PwC, Toronto ON                                                                           (6/2019 – 3/2020)

Project: MyMetrics PwC CMS website

• Designed and built a data-driven web sites with responsive, interactive features based on React, Redux, Bootstrap Material UI, ASP.NET Web API and Jest.
• Developed and tested the Web site that meets accessibility and web browser standard.
• Applied and automated CI/CD pipelines for multiple layers and in multi-environments in VSTS.
• Configured and executed CI/CD deployment activities across environments. 

Environment:  Azure DevOps, Azure Data Factory, Azure Function, C#, Web API, React.js, Redux, JSX, TSQL, JavaScript, SASS, JSON, Bootstrap, jQuery, HTML5, XML, Agile, Scrum, CI/CD, Git

Project:  PwC Assurance Risk and Quality web portal

• Designed and developed the user experience interface UI/UX strategy, and UI requirements.
• Built Angular application, implemented and secured Web API endpoints as a part of a high-profile customer-facing portal that provided critical connectivity channels for distributed functionalities.
• Configured CORS in ASP.NET core to address authentication and authorization via OAuth 2.

Environment:  Azure DevOps, Azure Key Vault, Azure RBAC, Azure Key Vault, Angular 6, C#, Rest, ASPNET Core , Bootstrap, jQuery, TSQL, HTML5, JavaScript, SASS, JSON, Agile, Scrum, TLS, HTTPS

BizTalk Technical Expert – PwC, Toronto ON                                                                         (9/2018 – 3/2019)

Project: PwC Middleware Integration Solution 

• Architected integration solution to connect PwC Cloud-base Workday service to SunLife system.
• Designed and implemented integration solution by using BizTalk as an integration engine with full crosscutting functionalities and features such as logging, archiving, ESB error handling
• Analyzed Web Services, and designed Interface schema, Flat File Schema, and Property Schema to address the contract requirements between systems. 
• Designed and created database schemas, and structures to facilitate the integration process.

Environment:  Azure, BizTalk 2013/2016, Power Shell, nSoftware Adapters, WCF, Azure Logic App, Power App, nHibernate, Restful Web API, ASP.NET Core, Visual Studio 2010/2016, SOAP, VSTS, Scrum, Agile, BTDF

BizTalk Technical Expert – Agricorp, Guelph ON                                                                   (5/2018 – 8/2018)

Project: Agricorp ESB Integration Solution 

• Analyzed current, high-level design, of the system capabilities and/or integration points and provide best practice recommendations for the existing solution.
• Improved integration solution to solve outstanding integration hurdles existing in production. 
• Provided training and guidance to developers to build proper integration solutions to address each integration scenario.
• Designed the system integration between BizTalk servers and Agricorp legacy systems. 

Environment:  BizTalk 2010/2016, Power Shell, Siebel, Guidewire, WCF, SharePoint 2013, Entity Framework, Visual Studio 2010/2016, SOAP, SCOM, TFS 2010

BizTalk Technical Expert – Dapasoft Inc., Toronto ON                                                          (5/2015 – 5/2018)

Project: Dapasoft Health Care BizTalk Solution in Cloud 

• Built a Cloud-based clinical data integration engine based on Microsoft Logic Apps, Azure service bus, and Microservice architecture patterns to provide a highly reliable, scalable, and available integration solution within the IM/IT environment.
• Applied Logic Apps Enterprise Integration Tools to BizTalk 2016 to generate maps and XSLTs.
• Integrated BizTalk 2016 to Azure Logic Apps via Logic App adapter to address communication between on-premises integration system to cloud-based SaaS providers.
• Built and developed storage access component based on Azure storages (i.e. blob, queue, and table) and Redis cache to handle resource-intensive tasks with high availability.

Environment:  Azure Logic Apps, Azure App Service, Azure Service Bus, Azure Storage, Azure IAM, Azure SQL, C#, SOA, SOAP/REST, C#, Schema, Orchestrations, Maps, Pipelines, XSLT, XML, XSD 

Project: NEODIN Health Integration Solution

• Developed an n-tier integration engine for eHealth Ontario CDR Integration service to collect and centralize EHR records, working within the eHealth Ontario IM/IT environment.
• Evaluated overall ESB solution and provided high-level architectural integration design.
• Reviewed and provided recommendations for BizTalk Host Topology & Optimization.
• Implemented the integration engine using .NET to build BizTalk 2013 artifacts via defining interface XML schema, constructing the pipeline and pipeline components, and providing message transformation mapping. 
• Used .NET and BizTalk 2013 development stacks in order to implement requirements for facilitating the business process, non-functional features such as logging, error-handling, encoding and etc.
• Implemented interface interoperability by working with C-CDA and HL7 standards.

Environment:  BizTalk 2016, HL7 V2/V3, BTDF, SOA, SOAP/REST, C#, Schema, Orchestrations, Maps, Pipeline Components, Pipelines, XSLT, XML, XSD, WCF SQL Adapter, SQL, TSQL, Scrum, DDL, DML, VSTS

Project: CAA Microsoft Dynamic Online Integration Solution 

• Designed Dynamic 365 integration POC via WCF-based organization service.
• Built integration application to address batch/de-batch process, tracking, and error handling.
• Created and configured WCF LOB adapter with message exchange customization.
• Automated BTS application deployment and configuration process with BTDF and PowerShell.

Environment:  BizTalk 2016, HL7 V2/V3, BTDF, SOA, SOAP/REST, C#, Schema, Orchestrations, Maps, Pipeline Components, Pipelines, XSLT, XML, XSD, WCF SQL Adapter, SQL, TSQL, Scrum, DDL, DML

BizTalk Technical Expert  – Altus group, Toronto ON                                                           (5/2016 – 9/2016)

Project: National Tax System

• Developed n-tier architected web portal based on ASP.NET API and Restful web services.
• Analyzed requirements and system specifications for enhancing features and new functionality.
• Created use case diagrams and activity diagrams to verify business processes with clients.
• Developed message-oriented middleware based on MSMQ to address scalability and reliability.
• Applied Dependency Injection to accomplish ApiController creation through the HTTP pipeline.
• Built logic data model and physical data model in ER diagrams.
• Constructed entity data model to reverse engineer database model based on Entity Framework.

Environment:  .NET Web API, AngularJS, MVC, WCF, Salesforce CRM, Autofac, Github, Marvel/Elastic Search, Entity Framework, Node.JS, JSON.NET, MVVM/MVC, JIRA, Confluence, Slack, MongoDB

BizTalk Technical Expert – Dapasoft Inc., Toronto ON                                                        (5/2015 – 4/2016)

Project: Service New Brunswick Integration Engine Evaluation and Enhancement

• Reviewed BTS Health check report and performance logs of underlying system and database.
• Provided recommendations for solution improvement, and solutions to current issues.
• Provided strategic integration and interoperability architecture support.
• Provided best practices around development strategies, code management and setup of environments including build book to be used within Service New Brunswick’s IM/IT environment.

Environment:  BizTalk 2010, PAL, SQL Server, BizTalk Health Monitor, BTS Terminator, SOA, SOAP/REST 

Project: RBC Insurance Call Storage Solution 

• Architected, designed, developed, and implemented an n-tier integration solution to save RBC insurance telemarketing call records to RBC enterprise content management system used within RBC’s IM/IT environment.
• Developed and built the BizTalk application by creating BizTalk artifacts and components (i.e. schema, orchestration, maps, and pipelines) and custom pipeline components, including Service Oriented Architectures using WCF to provide loosely coupled service layers.
• Automated migration from BizTalk 2009 to BizTalk 2013 with PowerShell Toolkit.

Environment:  BizTalk 2013, SQL Server, PowerShell Toolkit for BTS, BizTalk Deployment Framework, C#, Schema, SOAP/REST, Orchestration, Maps, Pipelines, XSLT/XSD, XML, TSQL, JSON, SOAP/WSDL, WCF SQL 

Project: My Health Direct 

• Designed and implemented Microsoft IaaS to support a Health Care Solution by provisioning a virtualized environment based on Azure.
• Built BizTalk VM Servers with clustered SQL Servers in a single Azure VNet.
• Automated Azure VM provision using resource manager and PowerShell DSC.
• Designed and developed Azure Service, Azure websites, and related web jobs. 

Environment:  .NET, Microsoft Cloud/Azure, BTS, SQL Server, jQuery, HTML5, XHTML, DOM, ASP.NET API, C#, TSQL, XML/XSLT, WCF, JavaScript, Ajax, Scrum

Project: VitalAire IBM AS400 and MS CRM Integration

• Reviewed and analyzed architectural design, and provided architectural enhancement assessment as part of enhancing integration and interface solution between Dynamics CRM and BTS CRM adapter within VitalAire’s BizTalk IM/IT environment to integrate patient, doctor, and health care member information between AS400 and MS Dynamic CRM.
• Extended complex BizTalk SQL Server interfaces and Web Service interfaces to address the application development needs by building SQL Server Adapters and WCF LOB adapters.
• Deployed, configured, and maintained the BizTalk solution in various environments.

Environment:  MS CRM 2015, WCF LOB Adapter, AngularJS, .NET, IIS, XHTML, Restful API, SOAP Web Service, C#, JSON, WSDL, SOAP, Bootstrap, Ajax, XSD, TSQL, XML/XSLT, SQL Server, TFS, Scrum

Project: Service New Brunswick Integration Engine Upgrade

• Reviewed and verified BTS Health check report and system performance logs.
• Provided strategic integration and interoperability architecture support.
• Evaluated overall ESB solution and provided high-level architectural integration design.
• Reviewed and provided recommendations for BizTalk Host Topology & Optimization.
• Provided recommendations for solution improvement and solutions to current issues. 
• Reviewed and provided best practices around development strategies, code management, and setup of environments including build book.

Environment:  BizTalk 2010, PAL, SQL Server 2008, BizTalk Health Monitor, BTS Terminator, SOA, SOAP/REST 

DOM, Restful API, ASP.NET, C#, TSQL, XML/XSLT, WCF, JavaScript, Ajax, Scrum

Senior Programmer Analyst – Ministry of Transportation, Toronto ON                                   (7/2013 – 4/2015)

Project: Judiciary Electronic Scheduling Program Initiative 

• Designed and implemented a single-page application using AngularJS to build a responsive web portal with rich UX within the Ministry of Justice’s IM/IT environment. 
• Participated in the solution design and architecture planning including developing service-oriented architectures using WCF targeting scalable and loosely coupled service layers.
• Built business data storage with high integrity, security, and transaction by using MS SQL Server.
• Used .NET development stacks in order to implement requirements for building the business logic layer and data layer in the n-tier architected web portal.

Environment:  AngularJS, C#, .NET, ASP.NET Web API, MVC, IIS, WCF, XHTML, WSDL, HTML5, JavaScript, jQuery, Ajax, XSLT/XML, Restful API, Bootstrap, OData, TFS, Oracle, UML, SQL Server, SOAP

Project: Scope Crown Case Scheduling and Management Application

• Designed and developed an n-tier architected application to fulfill clients’ requirements for scheduling and tracking courtroom arrangements in a specific court for logged-in users.
• Utilized .NET framework to build business process layer, data access layer, and presentation layer with MVVM/MVC pattern.
• Built Restful web service as a service layer using ASP.NET web API.
• Conducted AODA Assessment and provided and implemented refinements.

Environment:  .NET, C#, AngularJS, ASP.NET Web API, MVC, TFS, Crystal Report, IIS, HTML5, jQuery

Project: Employment Standards Integration System Migration, Maintenance, and support

• Developed n-tier architected web application by replacing the existing system with migrated database, enhanced features, and functionalities.
• Provided enhancement assessment and defined application readiness for transitioning support.
• Conducted AODA Assessment and provided and implemented refinements.
• Converted objects from Oracle to SQL Server by using the SQL Server Migration Assistance tool.
• Analyzed, qualified, and classified ESIS application components subjected to migration and enhancement with consideration of application functionality, availability, and performance.  

Environment: ESB, BizTalk 2009, SSIS, SQL Server, .NET, HTML5, XHMTL, XSLT, XML, CSS, Oracle, PL/SQL,  C#, Enterprise Library, WCF, WPF, TSQL, TFS, Crystal Report Enterprise 

Senior Programmer Analyst – Ministry of Government Service, Toronto ON                 (10/2012 – 5/2013)

Project: Broader Public Sector Labour Market Information Tracking and Analysis System 

• Accomplished architectural design, system integration analysis, and evaluation for the web-based application by following OPS Enterprise Architecture standards.
• Translated requirements and technical specifications into working n-tier web-based applications.
• Implemented n-tier Web-based application hosted in Ontario IM/IT environment.
• Automated system deployment and production release with scripting.

Environment:  .NET, C#, ASP.NET, MVC, IIS, WCF, XHTML, HTML5, JavaScript, Bootstrap,  jQuery, Ajax, XSLT, XML, OData, Restful API, SQL Server, WPF, LINQ, CSS, UML, MVC,  XSLT,  TSQL, Entity Framework, SOAP

Senior Programmer Analyst – PwC, Toronto ON                                                              (01/2012 – 10/2012)

Project:  PwC Middleware Maintenance and Enhancement

• Maintained and supported PwC middleware environment in BizTalk 2009.
• Leveraged ESB exception management framework to provide a standardized exception handling mechanism and automate reaction to application exceptions.
• Migrated and developed components for the n-tier ESB monitor and management portal as part of the migration from BizTalk 2006 to BizTalk 2009 environment.

Environment: BizTalk 2006/2009, ESB Toolkit, WCF, .NET, C#, ASP.NET, Restful Web API, BTS, MVC, IIS, jQuery, XSLT, XSD,  SQL Server, TSQL, TFS, Ajax, XML, Agile, Bootstrap, SOAP, Web Service, WSDL

Senior Developer – Morneau Shepell, Markham ON                                                    (08/2011 – 12/2011)

Project:  Ariel BPM Workflow BizTalk Solution

• Planned, designed, and implemented loosely-coupled mediated services to address business process management requirements by leveraging BizTalk infrastructure and technologies.
• Identified and analyzed new business requirements and provided feasible integration solutions.
• Designed and built service façades to expose the business process services based on WCF.
• Applied ESB Resolver Framework and Exception Management Framework to achieve dynamic routing, service customization, and a unified error-handling mechanism.

Environment: BizTalk 2009, .NET, C#, ASP.NET, Bootstrap, MVC, IIS, WCF, XHTML, HTML5, JavaScript, jQuery, Ajax, XSLT, XML, ESB Toolkit, SQL 2K5, .NET 3.5, XSD Schema, WSDL, Web Service, SOAP

MS in Computer Science, University of Bridgeport, CT   USA                                          (09/2000 - 06/2002)

BS in Computer Science, Nan Jing University, Nan Jing CHINA                                     (09/1992 - 07/1996)