Jackie Huang Email & Phone Number

Toronto, Ontario, Canada

• Analyzed business requirements and validated data integrity before ETL processes. • Developed SSIS ETL packages with data mapping by using SSDT to load data (Excel, Access, SQL DB). • Processed data validation, transformation and loading processes to data warehouse and data marts. • Utilized SQL server management Studio (SSMS) for the daily filtered loading and SSIS with data-based objects (tables, views, stored procedures) based on T-SQL scripting. • Modified dimensions… Show more • Analyzed business requirements and validated data integrity before ETL processes. • Developed SSIS ETL packages with data mapping by using SSDT to load data (Excel, Access, SQL DB). • Processed data validation, transformation and loading processes to data warehouse and data marts. • Utilized SQL server management Studio (SSMS) for the daily filtered loading and SSIS with data-based objects (tables, views, stored procedures) based on T-SQL scripting. • Modified dimensions, measures(facts) and cubes in SSAS; reports and web applications using SSRS. • Optimized reports (data modeling, query design, R, DAX, visualization) in Power BI. Show less

Toronto, Ontario, Canada

• Managed ad-hoc SQL queries and developed stored procedures to extract and integrate data from multiple database sources (Excel, Access, SQL server)• Designed and developed SSIS ETL packages to achieve data extraction, validation, transformation and loading processes from staging area to data warehouse and data marts.• Planned jobs and scheduled packages using SQL server management Studio (SSMS) for the daily filtered loading.• Projected centralized SSIS solutions with relevant… Show more • Managed ad-hoc SQL queries and developed stored procedures to extract and integrate data from multiple database sources (Excel, Access, SQL server)• Designed and developed SSIS ETL packages to achieve data extraction, validation, transformation and loading processes from staging area to data warehouse and data marts.• Planned jobs and scheduled packages using SQL server management Studio (SSMS) for the daily filtered loading.• Projected centralized SSIS solutions with relevant data-based objects (tables, views, stored procedures) based on T-SQL scripting to achieve process optimization and automation.• Customized and modified dimensions, measures(facts) and cubes in SSAS according to the business specifications.• Gathered data presentation requirements; Designed, developed and deployed tailored reports using MS BI tool SSRS reports; Customized suitable outputs and layouts such as reports, graphs and pivot tables based on detailed user data requirements.• Created and assessed a web application using SSRS reports to allow authorized users to perform needed configurations via the configuration report.• Managed data loading processes from different resources (Excel, Access, SQL server Database) and implemented data integrity validation using Microsoft Power BI.• Customized and developed reports with multiple data visualization using Microsoft Power BI. Show less

Toronto, Canada Area

• Analyzed sale reports from POS system to predict sales target and forecasting. • Initiated data analysis Excel reports to facilitate inventory control and cost management. • Collected customer data and reports from online social media channels and generated final reports. • Designed service feedback tracking reports and utilized online data to improve overall operation.

• Directed energy auditing process for 32 industrial clients including collecting data from Management Information System(MIS) and validating data accuracy. • Calculated energy consumption and Performed data analysis based on Excel (Advanced Formulas, Macro). • Gathered and analyzed the data of urban development index from 2010 to 2014 in the perspective of sustainability. • Computed principal component scores for four subsystems (economic, social, low-carbon and sustainable) using… Show more • Directed energy auditing process for 32 industrial clients including collecting data from Management Information System(MIS) and validating data accuracy. • Calculated energy consumption and Performed data analysis based on Excel (Advanced Formulas, Macro). • Gathered and analyzed the data of urban development index from 2010 to 2014 in the perspective of sustainability. • Computed principal component scores for four subsystems (economic, social, low-carbon and sustainable) using principal component analysis method based on SPSS Statistics. Show less

Master Of Engineering (Meng), Engineering Design

Activities and Societies: • School Project 1- The Impact of Natural Disasters on the Performance of U.S. Banks. (SAS Analytics) • School.

Master Of Engineering (Meng) (Honors), Power Engineering (Co2 Capture ,Storage And Utilization)

Research Experience - CO2 fertilization system integrated with a low-cost direct air capture technology (Sep, 20s. 13 – Mar, 2016).

Bachelor Of Engineering (Be), Energy And Environment System Engineering