OBJECTIVES

Seek a senior data engineer/developer role to leverage my extensive experience on end-to-end data solution design, development, implementation and operational support

EXPERIENCE

Brookfield Renewable, Gatineau — Sr System Analyst Aug 2024 – present

Developed data insight solutions by modeling, data warehousing & reporting to integrate corporate data from all aspects including Power Station time series, trade & settlement, system management data, vendor APIs etc.
Built Alteryx & Databricks & ADF pipelines to ingest, integrate data sourced from Oracle, SQLServer, Azure Blob storage, flat file etc
Created complex SQL queries, built Power BI dashboards for business and IT uses
Used Purview, admin REST APIs to support audits, compliance and data governance
Tools include Microsoft Fabric, Notebook, PySpark, Python, Databricks, Power BI, Alteryx, ADF, SQL server, Oracle, Microsoft Graph, Power BI, Fabric APIs & etc, PowerShell script

HOOPP, Toronto — Contractor, Solution Architect Jun 2014 – Dec 2016 Jul 2017 – Apr 2024

Led building a near real-time investment data warehouse to provide ‘single version of truth’, based on SimCorp Dimensions data and integrated Eagle PACE, vendor’s flat file/XML/Excel market/reference/price data
Provisioned data & built reports for front/middle/back offices, trading apps, risk management, compliance groups
Built ETL solutions to load data from Oracle and SQL Server, vendors flat files and REST APIs
Built customized batch process Windows Service using dot net & C#; built workflow in Automc UC4 to schedule overnight processes and involved in on-call rotation support
Migrated historical data into data platforms of SAP HANA, Snowflake for historical analytics
Modeled & built data by HANA calculation views, tuned performance of the views & queries
Established best practices on ETL, HANA modeling and database development, coached team members and users to adopt the practices
Collaborated among multiple delivery teams and business teams’ data needs on daily basis; Assisted in collecting and analyzing business and technical requirements
Created CI/CD pipelines on Azure DevOps, performed deployment and monitored the pipelines
Created custom data lineage tool to help better Data Governance, data quality check and master data management (reduced manual work by 95%);
Developed strategy and migrated legacy reporting systems (SSRS, SAP BOBJ/WEBI reports)

Apotex, North York — BI Developer Jan 2017 - June 2017

Modelled data for reporting in Qlikview
Created ETL using SAP BODS to load product data in text and SAP ECC data into SQL Server

Systemgroup Inc (now BDO Canada), Mississauga — Senior Consultant Aug 2012 - May 2014

Built Mining Operational Reporting System for Barrick, Hudbay Minerals, Inmet, and Kinross.
Managed change requests, ensuring controlled implementation
Tools include Visual Studio, Visio, ASP.Net, IIS, C#, VB.Net, SQL Server, SSIS, SSRS

Dapasoft Inc, Toronto — Senior Consultant Aug 2011 - Aug 2012

Led building Biomedical Knowledge Portal for the Health Ministry of Ontario, in collaboration with Durham College, Ontario.
Migrated legacy hospital asset data through a robust database replication process.
Created ETL processes, KPI Scorecards, and Reports the Hospital for Sick Kids, Ontario.
Built the Sunnybrook Drug Repository at Sunnybrook Hospital, Ontario.

Manitoba eHealth, Winnipeg — Senior Report Developer Jun 2011 - Aug 2011

Consulted the Winnipeg Community ADT project to standardize Electronic Patient Records (EPR) across all Acute Care hospitals within the Winnipeg Health Region.
Drafted report technical standard, establishing good reporting practices.
Created, new & migrated legacy SSRS reports, ensuring accuracy and reliability.

Syncada(PowerTrack, US Bank), Toronto — Sr Software Engineer July 2005 - Jun 2011

Built databases, migrated legacy data, supported the product development efficiency
Built an Outbound data mart to facilitate Electronic Data Interchange (EDI) processes

EarthTech Canada (now AECOM), Markham — Database Developer May 2001 - Jun 2005

Created solution for cross-reference checking of 20,000+ SCADA tags to support the South PEEL Water Wastewater SCADA system
Implemented a public water quality report for Peel, Durham, Toronto, and Sudbury, to be complied with the Drinking Water Act 2002 and Ontario Regulation 170/03

Zhejiang Provincial Institute of Computing Technology, China — Senior Software

Engineer/Consultant July 1994 - Mar 2001

Built MIS for Hangzhou Channel Gas Company. using PowerBuilder and Sybase
Built solution for the Vehicle Attached Tax system for Transportation Ministry of China
Implemented and coached all local branches of the ministry across China

SKILLS

Database Design, implementation & administration, Data Modelling, Performance tuning, Data

Analytical Reporting, ETL, Metadata Extraction/Management, Data Dictionary, Data Lineage and Impact Analysis, System integration & Data integration, System Automation, SDLC & Agile

Methodology, Unit/Regression/UAT/Product smoke testing, Investment Data Management and more

LANGUAGES / TOOLS

T-SQL PL/SQL, XML, JSON, MS SQL Server, Oracle, SAP HANA, SAP BOBJ, BODS, SSIS, Crystal Reports, QlikView, SSRS, Power BI, Sybase Replication Server, HVR replication tool, Atomic UC4, ASP.Net, C#, JavaScript, PowerShell, PowerBuilder, Power Designer, MS Office, Visio, Python,

Visual Studio, Simcorp Dimension, Eagle PACE

EDUCATION

Bachelor of Computer Engineering - Huazhong U. of Science & Technology, Wuhan China 1994

CERTIFICATES & TRAINING

Microsoft Fabric Analytical Engineer Associate – 2024, 2025

Microsoft Certified: Azure AI Fundamentals - 2024

CFA Level I passed – 2022

Snowflake: Hands On Essentials - Data Warehouse - 2021

SAP HANA Application Association Certificate - 2016

Microsoft® Certified Solutions Expert: Data Management and Analytics Charter Member - 2016

MongoDB for DBAs (Ver 3.2) MongoDB for Node.js Developers (Ver 3.2) - 2014

Microsoft, MCSE: Data Platform/BI- 2013

Microsoft, MCSD.Net – 2005

Microsoft, MCDBA – 1997