Nicholas Tang Email & Phone Number

Toronto, ON, CA

Global Wealth And Asset Management Data Office

- Managed a full team (Business Analyst, Data Modeler, Data Engineers, Quality Engineers, Scrum Master) to onboard fund and fund performance data to enterprise data warehouse (Hortonworks and SQL Server). Scope of work included ingesting XML files up to 10 GB in size, modelling star schema and denormalized tables, ETL and corresponding performance.

Group Functions Data Office

- Served as SME for the migration of entire GL reporting solution from Oracle to Hadoop (Hortonworks platform). Responsibilities included managing the conversion of ETL jobs from Informatica PowerCenter to Informatica BDM, driving issue resolution, and coordinating vendor, platform and project teams- Scoped and delivered a BI caching/semantic layer.

US Telecommunications Company

- Used Hive on HDP (Hortonworks platform) to develop analytical record and consumption layer for MicroStrategy to enable viewership analytics and insights- Responsible for operationalizing jobs by optimizing performance, implementing delta load functionality and automating job execution- Designed and developed data profiling and validation tool using Spark

Large US Financial Services Company

- Led a team of onshore and offshore resources to deliver a custom framework leveraging Sqoop, AWS EMR, Lambda and CloudFormation to migrate 10 years of historical data from an on-premise Oracle data warehouse to the Cloud- Developed data ingestion, transformation and validation framework functionality- Used Presto to replace existing data warehouse.

Canadian Public Transportation Company

- Used Spark and Hive on CDH (Cloudera platform) to automate operational delay and performance report generation and enable customer segment analysis by migrating ETL pipeline from MySQL- Developed ingestion, processing and historical data load scripts- Designed, developed and supported test harness script enabling row-to-row comparisons between datasets.

Canadian Telecommunications Company

- Coordinated activities for both onshore and offshore Conversion teams as part of an IFRS implementation- Performed Conversion release planning and drove the resolution of Conversion issues and defects- Responsible for ensuring accuracy of and publishing KPI’s detailing Conversion progress to Leadership

Canadian Integrated Energy Company

- Worked on project involving replacement of legacy pricing system with packaged software- Defined interface functional requirements, created interface Functional Test and SIT scripts and supported test execution through all test cycles- Served as SME for defect triage, interface cutover and transition to Operations

Large Canadian Retailer And Bank

- Led a team of onshore, offshore and contractor resources to deliver an infrastructure monitoring platform for the client’s integration stack (SCAPM)- Performed estimation, solution design and drove implementation, issue resolution and team adoption- Delivered functionality included real-time infrastructure status and performance monitoring, proactive.

Large Canadian Retailer And Bank

- Worked on multiple projects spanning 3+ years including an ERP implementation, loyalty program and acquisition- Designed/developed interfaces and project framework functionality using IBM integration suite, Java and MQ- Supported delivery from testing to go-live and performed cutover planning