Mei Tong
PH.D
Maple,ON
Summary
Enthusiastic data engineer eager to contribute to team success through hard work, attention to detail and crucial critical thinking. Over 10 years of working experience in SQL scripts and program developing using Python and Java. Strong data modeling, analyzing and ETL skills. Hands on experience working with Teradata and Azure Data Warehouse. Motivated to learn, grow and excel in Meta.
Overview
21
21
years of professional experience
10
10
years of post-secondary education
8
8
Certificates
Work History
Senior Technical System Analyst of Data & Analytics BI
Royal Bank of Canada
Toronto
10.2015 - Current
- I am responsible for providing stable, high performance, accurate business reporting systems, by ingesting, processing, analyzing and sharing data to different LoBs, and collaborating with business users, business analysts and other technical teams
- Enabled 3 lines of BI analytics systems based on OBIEE, SQL OLAP and Reporting Server respectively, served 20+ servers, hundreds of applications and thousands of business users in production environment
- Collaborated with stakeholders in collecting requirements, modeling data, developing, testing and implementing improvements into production, created OLAP cubes and OLTP reports for 3 major business departments, extended business insights and shorten the data refresh time from monthly to daily
- Troubleshot issues caused by missing/inconsistent data, software defects, insufficient privilege, business logic evolving, environment mismatching etc., fixed dozens of minor report bugs for different business users, improving efficiency for business sales and services
- Developed a report logging system by embedding tracking codes into front-end ASP pages of a complex, aged system, combined with Javascript, to provide BUs with a filter-level audit when time and technical aids are limited.
Technical Lead
Shanghai DS Company
Shanghai
01.2009 - 11.2012
- This role focused on meeting business goals with advanced technologies/methodologies, leading the R&D of new techs and tools in software production and promoting them to BUs together with sales teams
- Blueprinted a cutting-edge Rescue Dispatch System for the Fire Department in Shanghai and the project was admitted and funded by the government with a total investment of more than $2 million, 2011
- Led the requirements analysis, system structuring, software developing and implementation of the FIRST Resources Management and Dispatch System for the Joint Emergency Management and Comprehensive Urban Management Call Centre in Shanghai, with an investment of around $1.6 million, 2010
- Applied for and received over $2 million of funds from the government
- Applied for and received authorization for 7 patents in R&D products
Business System Analyst / Model developer
Tongji University
Shanghai
09.2004 - 12.2008
- As a Ph.D candidate, applied theories of computational science into traffic management, performed experiments to validate models with practical applications
- Researched and outlined a computational experiment system in traffic management, 2 of 5 published papers were collected by core journals
- Led the research team as business system analysts, collaborated with transportation departments and research teams from other universities, proposed, modeled and developed data prediction model as APIs deployed in an experimental cloud computing environment, using 20,000 real-time GPS data, coding with Java and Oracle SQL
- The project received second place for Science and Technology Prize in Shanghai.
Software Engineer
Shanghai DS Company
Shanghai
07.1998 - 08.2004
- Cooperated with business users on-site, developed the first automatic fire dispatch and command system for the Fire Department in Wuxi, China, coded with PowerBuilder, SQL server, oracle, crystal report
- The system was highly praised by the head of the department and promoted in whole province as a model system
- Improved the Fire Dispatch and Command System by collecting feedbacks from BUs and promoted the solution to almost half of the cities in China.
Education
Ph.D - Intelligent Traffic Systems
Tongji University
09.2004 - 07.2008
Master - Computer Science
Sun Yat-sen University
09.1995 - 07.1998
BSc - Computer Engineering and Telecommunication
Tongji University
09.1991 - 07.1995
Skills
Systems and software programs
Certification
Completion of Azure Databricks 3-part training series
Timeline
Completion of Azure Databricks 3-part training series
03-2022
Completion of Foundation of Data Governance
02-2022
Certificate of Database Architecture, Scale, and NoSQL with Elasticsearch Cousera
02-2022
Certificate of Introduction to Big Data with Spark and Hadoop, Cousera
02-2022
Certificate of Getting Started with SAS Programming Cousera
02-2022
Certificate of Structured Query Language (SQL) using SAS, Cousera
02-2021
Certificate of Getting Started with SAS Programming Cousera
02-2021
Senior Technical System Analyst of Data & Analytics BI
Royal Bank of Canada
10.2015 - Current
Completion of Data anaysis specialization
07-2015
Technical Lead
Shanghai DS Company
01.2009 - 11.2012
Business System Analyst / Model developer
Tongji University
09.2004 - 12.2008
Ph.D - Intelligent Traffic Systems
Tongji University
09.2004 - 07.2008
Software Engineer
Shanghai DS Company
07.1998 - 08.2004
Master - Computer Science
Sun Yat-sen University
09.1995 - 07.1998
BSc - Computer Engineering and Telecommunication
Tongji University
09.1991 - 07.1995
Similar Profiles
ANIRBAN BASUANIRBAN BASU
QA Manager at TCS CANADA (Client - Royal Bank Of Canada)QA Manager at TCS CANADA (Client - Royal Bank Of Canada)
Ashok Kumar PeddinaAshok Kumar Peddina
Senior Consultant at Capgemini, Canada, Royal Bank of CanadaSenior Consultant at Capgemini, Canada, Royal Bank of Canada
PARMEET KAURPARMEET KAUR
Collections Officer at Royal Bank of Canada, RBCCollections Officer at Royal Bank of Canada, RBC
Kelly ClarkeKelly Clarke
Cash Cage Associate at Royal Bank of Canada, RBCCash Cage Associate at Royal Bank of Canada, RBC
Zohar GavrilovZohar Gavrilov
Server at Montanas Cookhouse BBQ & BarServer at Montanas Cookhouse BBQ & Bar