Verified Expert in Engineering
Cloud Architect, DevOps Engineer, and Developer
Lu has amassed over two decades of experience in the IT industry, with six years specializing as a Cloud Architect and SRE. His expertise spans Cloud Architecture Design, IaC, CI/CD, VPC and IAM management, Security, Reliability Engineering, Performance Optimization, Cost Management, Compliance and Governance, and Disaster Recovery Planning. He boasts extensive experience across various domains, encompassing Government E-services, Law Enforcement and Justice, Finance, and Healthcare Industry.
Google Cloud Platform (GCP), BigQuery, Google Kubernetes Engine (GKE), Jenkins, Infrastructure as Code (IaC), DevOps, Terraform, CI/CD Pipelines, TFS, Git
The most amazing...
...Saved $26,000 (20%) annually by optimizing data transfers of 11TB/day through streamlined ELT/ETL processes and resource allocation for BigQuery and FiveTran.
SRE | Cloud Architect
CloudMinds Solutions INC.
- Google Certified - Cloud Architect | Cloud DevOps Engineer | Cloud Network Engineer.
- Utilized Infrastructure as Code (IaC) principles with Terraform to fully automate AWS and GCP infrastructure management. Established and managed robust CI/CD pipelines for seamless automation of ETL/ELT workflow deployments.
- Instituted cost control strategies, conducted cost analyses, and produced budget reports. Saved $26,000 (20%) annually by optimizing data transfers of 11TB/day through streamlined ELT/ETL processes and resource allocation for BigQuery and FiveTran.
- Designed and implemented a set of GCP-based cost/usage metrics for FiveTran and DBT, facilitating real-time anomaly detection in high-volume data streams, thereby elevating system reliability and availability.
- Implemented comprehensive infrastructure management, including VPC, IAM, and data governance protocols, to enforce secure access controls and protect critical data.
Google Cloud Architect | SRE
City of Edmonton, AB
- Designed and implemented a seamless GCP integration for the City of Edmonton, enabling smooth web application migration and enhancing data engineering efficiency within hybrid network environments.
- Utilized Infrastructure as Code (IaC) principles with Terraform to fully automate GCP infrastructure management.
- Successfully implemented cross-cloud Continuous Integration and Continuous Delivery (CI/CD) pipelines on Azure and Google Cloud Platform (GCP) to streamline software development and deployment workflows.
- Led the development of a proof of concept and architectural plan for migrating and reengineering the City of Edmonton Tax Reporting system, transitioning it from on-premises infrastructure to Google Cloud utilizing Google Kubernetes Engine.
- Effectively bolstered security and thwarted DoS attacks across multiple legacy web systems through seamless integration of reCAPTCHA.
Senior System Analyst
Edmonton Police Service
- Led the analysis of integration requirements for the Hexagon Computer-Aided Dispatch (CAD) system and Niche record management system (RMS), conducted technology research, and oversaw prototype design and evaluation.
- Designed a CI/CD pipeline using PowerShell, enabling seamless automation of CAD system updates and optimizing infrastructure maintenance and patching processes.
- Successfully managed the implementation of the Enterprise System Bus (ESB) component within the computer-aided dispatching system.
- Provided continuous 24/7 on-call technical support and assistance for the 911 emergency communication center.
Government of Alberta
- Established and maintained end-to-end CI/CD pipelines using Windows Build Server to automate the complete deployment process for the Alberta Land Title System across various environments.
- Automated procedures for creating and maintaining testing and production environments, streamlining processes for efficiency and reliability.
- Managed TFS Server and MS Build Server, with a focus on branch management and the administration of CI/CD pipelines.
- Skillfully facilitated communication and coordination among the development team, testing team, technical support team, and business users. Ensured smooth deployment procedures with minimal impact on each team.
- Led the analysis of system integration requirements, conducted architecture and technology requirement research, and oversaw prototype design and evaluation for the Alberta Land Title Registry System.
Senior Integration Engineer
Servus Credit Union
- Led the comprehensive analysis, architecture design, technology research, prototype development, and evaluation for a $12 million Servus Core Banking system integration project.
- Oversaw the design and implementation of the Servus E-transfer B2B gateway, including infrastructure setup and the creation of a proof of concept (POC).
- Spearheaded the creation of a Proof of Concept (POC) and architecture for integrating an Interactive Voice Response (IVR) system on the cloud with the core banking system through the B2B gateway.
- Devised and managed a robust plan for migrating extensive historical data using SSIS.
- Translated and managed web service schemas, enabling cross-agency utilization and concurrent system development through the implementation of a robust unit test harness.
- Provided round-the-clock support for Servus Core Bank systems.
Senior System Analyst
Government of Alberta
- Led the technology analysis, planning, architecture, and implementation for the Alberta Land Title Documentation Submission System.
- Reengineered the deployment package build engine. Smoothly and seamlessly deployed the system to each environment.
- Managed and migrated source code and documentation using the TFS server and SharePoint portal.
- Provided technical Help Desk support for the Alberta Land Title Management System.
Enterprise System Analyst
- Performed technology analysis, planning, architecture, and implementation for the exam scan and synchronization system.
- Produced and managed business and function use case documentation.
- Devised and managed a massive data migration plan and migrated massive historical data.
- Created and managed an SQL database, including tables, views, store procedures, functions, and triggers.
- Designed test cases and performed unit, integrated, and performance testing.
- Developed a system deployment package and deployed the system to the UAT and production environments.
- Investigated and fixed system errors with data- and code-based hotfixes.
- Provided system support, customer training, and technical help desk services.
Senior Software Engineer
Epocal Inc. (acquired by Siemens Healthineers)
- Led system requirement specification creation, requirement analysis, end-to-end system architecture design, and data structure design.
- Created and maintained system design documentation.
- Designed the database structure and used Microsoft Enterprise Library to streamline configurations and the process between the front end, middle tier, and database.
- Built n-tier web applications using Visual Studio .NET 2005, VB.NET, C#, ASP.NET, ADO.NET, XML, Ajax, SQL Server 2005, Java Script, NUnit, Infragistics 6.5, CodeSmith, and Crystal Reports 10.
- Developed the test plan, created test cases, and performed unit, integrated, and system testing.
- Implemented web servers and Windows services and applications.
Senior System Analyst
- Created the chip data source management system to automate the procedure for managing semiconductor chips.
- Implemented the analysis report management and searching system for managing and indexing analysis reports.
- Provided network and intranet application technical support and end user training.
- Developed and implemented the resume index search engine.
- Designed and implemented the HR contract management system.
- Provided technical support and training for end users.
IES Group Inc.
- Developed n-tier web and Windows applications and services using Visual Basic 6, Visual Studio .NET, VB.NET, C#, ASP.NET, ADO.NET, XML, SQL Server, and Crystal Reports 9.1, 9.5, 10, and 11.
- Created documentation for user requirements, function design, and technical design.
- Maintained the SQL and Crystal Reports servers and created and updated SQL database objects and Crystal Reports.
- Designed the database structure and used Microsoft Enterprise Library to streamline configurations and processes between the middle tier and SQL Server.
- Conducted unit, integration, system, and performance testing.
- Performed application support and administration and database replication and backup.
- Provided end user training and 24/7 technical support.
City of Edmonton | My Property Systemhttps://myproperty.edmonton.ca/
Service Alberta Land Title Registry Systemhttps://www.alberta.ca/land-titles.aspx
Service Alberta Apprenticeship, Trade, and Occupation Management System (ATOMS)https://www.alberta.ca/apprenticeship-industry-training.aspx
Windows PowerShell, JSON Web Tokens (JWT), .NET, Windows Workflow Foundation, AppFabric, ASP.NET, Django
Visual Studio, Terraform, Google Compute Engine (GCE), Google Kubernetes Engine (GKE), GitHub, Informatica ETL, TFS, NuGet, NGINX, Jenkins, Crystal Reports, Microsoft Access, SoapUI, Jira, BigQuery, Looker, Subversion (SVN), Git
DevOps, Continuous Integration (CI), Microservices, Microservices Architecture, Test Automation, DDoS, Automated Testing, Test-driven Development (TDD)
Google Cloud Platform (GCP), Windows, Kubernetes, Azure, Docker, SharePoint, Windows Server, Linux, Amazon Web Services (AWS)
Google Cloud Storage, Google Cloud, Cloud Environments, Google Cloud SQL, Database Performance, XML Schema, SQL Server Reporting Services (SSRS), MySQL
Networking, Cloud Architecture, Load Balancers, Cloud, Site Reliability Engineering (SRE), Web Development, Monitoring, Pub/Sub, Google Cloud/Suite, Infrastructure as Code (IaC), Infrastructure, Cloud Engineering, Identity & Access Management (IAM), Google, CI/CD Pipelines, Leadership, Project Design & Management, Data Engineering, SSH, Remote Desktop, Content Delivery Networks (CDN), Cloud Security, Networks, Google Cloud Functions, Back-end Performance, System Administration, IT Project Management, Computer Science, Software Engineering, Civil Engineering, Microsoft Build Server, Integration, Windows Communication Foundation (WCF), IIS, Microsoft Data Transformation Services (now SSIS), Bluetooth, Microsoft Build, SSIS Custom Components, PDF, SaaS, Machine Learning
Security, IT Security
Bachelor's Degree in Computer Science with Software Engineering Specialization
University of Western Ontario - London, Ontario, Canada
Bachelor's Degree in Civil Engineering
Yantai University - Yantai Shandong, China
GCP Professional Cloud Network Engineer
GCP Professional Cloud Architect
GCP Professional Cloud DevOps Engineer
BetterCloud Certified Administrator
Microsoft Certified Azure AI Fundamentals
Data Integration Developer
Microsoft Certified Solution Developer
Kennedy College of Technology