Gavin Chen Email & Phone Number

Surrey, British Columbia, Canada

Developed and implemented application systems for Facility Dimensions Mapping, Hospitalists Workload, Measure/KPI Loading, Outliers Detection/Forecasting, and Time Periodicity Dimensions Integration. Instrumental in optimizing the department's master data management, contributing to enhanced efficiency and effectiveness.Developed and managed processes and documentation for data governance, privacy, and security. Ensured our department met privacy and security requirements through the implementation of effective measures. Contributed to enhancing data protection and maintaining regulatory compliance.

Shenzhen, Guangdong, China

Steered the team through a data architecture overhaul, operational processing optimization, data model updates, and control of operational risks. Managed the operation of 96 application systems on 600 virtual servers. Provided support for corrective data and transaction promotion.Successfully spearheaded a 3 million Chinese Yuan budget data center relocation, completing the move within a tight 4-month timeframe. Oversaw the transition of 96 application systems, 50 terabytes of data, and 600 servers on VMWARE virtual platforms.

Guangzhou, Guangdong, China

Directed the transition of e-commerce business requirements from various departments such as customers, suppliers, merchandises, orders, operation performance, before-sales service, after-sales service, warehouse, and logistics to technical artificial intelligence requirements. Established and built a dedicated BI team specifically tailored for AI requirements. Organized the design and testing of the technical architecture, incorporating technologies such as Hadoop, Tableau, SAS, R, and SQL Server.

Zhenjiang China

Facilitated the Enterprise Resource Planning (ERP) acceptance testing and played a pivotal role in the initial go-live phase of master data management, overseeing the creation, updating, and monitoring of master data. Took charge of business analysis responsibilities, extracting essential data for visualization purposes and aiding in informed decision-making processes.

Surrey, British Columbia, Canada

Collaborated with a team of 5 colleagues to extract data from MEDITECH and other application systems. Transformed the data in alignment with transactions and Key Performance Indicators (KPIs), utilizing tools such as Access queries, Excel Macros, pivots, charts, and VBA scripting. Loaded the processed data into a centralized database and distributed insights to various team groups across 12 hospitals through charts, sheets, pivots, slides, PDF files, scorecards, and dashboards.

Calgary, Canada Area

Oversaw a 3-month project to boost performance across 5 Oracle databases (versions 9i, 10g, and 11g) by refining backup/recovery strategies and optimizing resource utilization. Created automated scripts for cold and hot backups using OS commands, SQL PLUS, and RMAN. Implemented a database space cleanup initiative, leading to substantial resource savings.

Guangzhou, Guangdong, China

As a team leader of a bank data center, provided 7X24 on call supporting for 35 bank business systems on Oracle 9i, Sybase and Microsoft SQL Server 2005; Made and implemented the capacity planning; Communicated with internal and external clients, transferred the business requirements to technical requirements. Scoped projects and evaluated its’ budget; provide consulting on data structure designing, availability, data security, resource planning, test planning, quality assurance planning and SLA defining.

Guangzhou, Guangdong, China

In my role as a project manager, I spearheaded the design and implementation of a crucial data encrypting and decrypting application system based on PKI. This application stands as a cornerstone for data encryption/decryption in banking applications and has been widely accepted as a standard model in the banking sector. Additionally, I led the design of an area-net bank card transaction exchanging system on DB2, utilizing RPG and SQL. I took charge of writing user training documentation and successfully conducted user training sessions. Furthermore, as the head of the Project Management Office (PMO), I diligently monitored the cost, milestones, and documentation for all projects, ensuring their successful execution.

Master'S Degree, Applied Mathematics

This is a three-year course. Main classes are Optimal Methods, Statistics and Data Analysis

Education record

Eight-month learning program in Southern Alberta Institute of Technology Polytechnic, Calgary Canada. The purpose of this position was.

Bachelor'S Degree, Computational Mathematics And Application Software, 4.0

Mathematics method, program language and project design