Ping Li Email & Phone Number

Ontario, Canada

Ontario, Canada

Toronto, On, Ca

● Designed and implemented a dashboard to show integration statistics in Delta table, message bus status, Oracle table statistics, log statistics in Log Analytics using Streamlit.● Migrated outbound integrations into Databricks using Notebook, took advantage of CDF in Databricks. Created data validation library in Databricks.● Designed and implemented RESTful API to tables in Database using FastAPI. Created a VBA to generate Python API code, Bicep APIM code, and Oracle Table DDL etc. in Microsoft Excel.● Designed and implemented Award Cloud outbound to SIS integration framework using Azure Function App, Azure Service Bus, and Azure Data Lake etc. Implemented feedback loop using Timmer triggered function app. Implemented Change Data Capture using Pandas.● Created more than 10 Award Cloud inbound integrations. Implemented ETL using Pandas.● Developed a GitHub template repository for Azure Function Application, integrating GitHub CI/CD workflows that automate the creation of a Docker image, push the image to Azure Container Registry, and trigger the deployment through a Webhook.● Developed a Infrastructure as Code (IaC) framework to deploy Azure Function Application, including Azure Service Plan, Azure Storage Account, Private Endpoint, private DNS zone Key Vault, Azure subnet of a virtual network using Bicep code. Automated the deployment utilizing GitHub workflow.● Developed a deployment framework for APIM, utilizing the "Azure API Management DevOps Resource Kit" extractor to extract API definitions as ARM templates. Effectively resolved the issue of the "az deployment" command requiring public containers for deploying linked templates.● Developed an Azure DevOps release pipeline for deploying ADF project and subsequently migrated to GitHub workflow. Resolved the issue of Azure cloud login by utilizing a system-assigned identity for the "PrePostDeploymentScript.Ver2.ps1" scripts from Azure Community which is running in self-hosted GitHub runner.

Toronto, On, Ca

● Implemented New Fees Framework Restful Web Services (REST API) using Java EE and rewrote it using Spring Boot Microservices.● Exposed RPC of the traditional C++ Servers as Restful Web Services (REST API) using Java EE. Designed a framework on top of jQuery at client side to access the API. Generated source code using meta data of the traditional C++ Servers.● Maintained the C++ servers and the C++ clients. Rewrote libociutil to upgrade Oracle OCI from 7.3 to 9i/11g. Migrated the C++ Servers from Solaris to Ubuntu.● Developed and maintained plenty of Java Web Apps; Oracle Database procedures, functions; couple Python and Perl Web Apps.● Created a Course Enrollment Chatbot. Implemented in three environments: Google Dialogflow, Amazon Alexa, and IBM Watson. Using Webhook which is deployed in IBM Cloud as backend.● Implemented dialog flows in Watson Assistant for York Student Virtual Assistant, and worked as an administrator of IBM Cloud.● Developed and maintained automated test for Web Apps and C++ Servers using JMeter, Selenium, PowerShell UIAutomation, Python● Built a Kafka Cluster. Created secure cluster with three nodes to support communication between SIS Apps.● Built server to server OAuth2 Authentication & Authorization structure, using open source identity and access management solution – Keycloak.● Maintained Fisheye which is connecting to internal CVS, SVN, and GIT repositories.● Implemented an automation tool to convert GUI of Classic applications to JSF pages. First of all, convert GUI definition files to xml files which include size, position, and type of components. Second, convert xml files to JSF files and CSS files. CSS were used to define the style of components in JSF pages. Third, generate backing beans which use CDI to support Express Language in JSF pages. Forth, generate Entities (JPA), Session Beans (EJB) from ERwin report.

● Demo: https://youtu.be/0vaz7U5_tjU● Raspberry Pi, EV3, BBC micro:bit, ESP8266, IBM cloud, Alexa, AWS, Water Sensor, Ultrasonic Sensor, IR Sensor, Camera● Recognizing and calculating the number of cars in parking lot using OpenCV● Data collected from Sensors were sent to the MQTT server on the Smart-City Center● Events sent to Web browser through WebSocket on Smart-City Center ● Smart-City Center Web Server were deployed on Raspberry Pi● Two Wi-Fi dongles were installed on Smart-City center Raspberry Pi, one is providing hot spot, another is connecting to Internet● The events were posted to IBM cloud and kept the events in Cloudant NoSQL Database● User could check Smart-City status dashboard through Web Server on IBM Cloud from Internet● Most apps were implemented in Golang● Voice controlled Lego train was implemented using Amazon Alexa and AWS Lambda

Ca

● Developing Online Shipping System

● Developing Recruiting System

Inner Mongolia, Cn

● Taught Courses: C, C++, VB, Java, Database Application Design, Software Engineering, Computer Graphics● Research Areas: Natural Language Processing, Machine Translation, Workflow Management, Coding Automation

● Developing applications for bank, government etc. As Manager and Application Architect

● Designing Workflow Management System.

● Traditional Mongolian Language Processing.

Master'S Degree, Applied Mathematics

Bachelor'S Degree, Computer Science

Studying For Doctor Of Philosophy - Phd, Robotics & Ai