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
• Modified dimensions, measures(facts) and cubes in SSAS; reports and web applications using SSRS.

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
• 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.

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
• 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