Maxwell Hu Email & Phone Number

Toronto, Canada Area

Shanghai , China

Achievement:-Delivered 3 Data Warehouse and Business Intelligence Projects. Each project’s value were over $2 million-Designed and developed 2 common modules, Data Quality Score Card and ETL Scripts GeneratorResponsibilities:-Gathered information requirements and needs-Participated in assessment, research and analyzed business and system needs-Designed and developed quality Data Warehouse and ETL solutions that followed best practices-Designed and implemented Enterprise level Conceptual, Logical and Physical data models-Created database objects and multi-dimensional structures-Addressed data integration issues and provided input for potential solutions -Identified data quality issues by creating scripts to verify the quality of data in the operational systems-Defined and documented data mapping and transformation rules. Designed, developed and implemented data extracting, transforming, cleansing, loading and verification jobs and procedures-Designed and developed reporting applications and interfaces with the data warehouse-Captured business and technical metadata for the data warehouse data and processes -Developed, documented and executed unit test, system, integration and user acceptance test-Performed impact analysis to determine the impact of proposed changes to existing ETL processes -Trained newer team members and supported existing data warehouse applicationsProject Experiences-Credit Report Project of China Merchants Bank 2009 - 2010 -Data Warehouse Project of TianJin Bank 2010 - 2011-RWA System Construction Project of SPDB Bank 2011 - 2012-Data Warehouse Project of SPDB Bank 2007 - 2009-Credit Card Data Mart Project of SPDB Bank 2006 - 2007-Decision System of Shanghai International Group 2005 - 2006-SAP BANKING Project Of SPDB Bank 2003 - 2005

M.Sc. In Computer Engineering, Data Warehouse

B.Sc. In Computer Application