Yonggang (Gary) Tan

Mississauga, ON, CANADA

647-***-**** § aczx65@r.postjobfree.com § ca.linkedin.com/pub/gary-tan/23/1b6/640/

PROFILE

A versatile data engineering professional with substantial experience designing and executing solutions for complex business problems involving large scale data warehousing, ETL, real-time analytics and reporting solutions, helps organizations effectively analyze and process structured and unstructured data. Possesses a strong sense of ownership and accountability, attention to details, and works well both independently and as a member of a dynamic team. A passion for extracting key information out of complex big data to help meet business objectives. Key qualifications include:

Built ingestion process to Enterprise Data Lake using Spark-based ingestion framework, transform raw data from landing zone to consumer zone Hive database, demonstrate data visulization and analytics in Tableau to business clients.

10+ years development and production database administration experiences around SQL Server, with many years focusing on OLAP/BI area (SSIS,SSAS,SSRS,etc), strong database performance tuning and optimization, as well as T-SQL skills.

Sharp logical mind with long-term OOP practices helps on sound logical and physical data model design and development, on both star-schema and 3NF designs.

Proficient in various ETL/Data warehouse development and maintenance, as well as data processes automation with strong .Net or script programming skills.

Superior front-end data presentation abilities using MS SSRS, Excel, Cognos Query/Report Studio, etc.

Skillful in developing ASP.NET Web Application, WinFrom Application, Windows Service and WCF/Web Service with Multi-Tier/SOA Architecture, using VB.NET, C#.

Extensive experience in full Software Development Life Cycle, including business requirements analysis, domain model design, front/back end coding, debugging, integration, testing and documentation. Good analytical skills for complex, objective problem solving.

TECHNICAL SKILLS

O.S

Linux, HDFS, HDP, Windows Desktop and Servers

Languages

Java, Scala, BASH, C#, VB.NET, VBScript, Powershell, C++

Databases

Hive, HBase, MySQL, MS SQL Server, Oracle, DB2, MS Access, Excel

BI Tools

Tableau, SSIS/SSRS/SSAS, Cognos PowerPlay Transformer, Framework Manager, Report Studio, BO Data Services, BO Universe, Crystal Report

Web

HTML, CSS, Javascript, XML/XSLT, ASP and ASP.NET, MVC, Ajax, JQuery and IIS, etc.

Web Services

ASMX, WCF, WSDL

Software

Microsoft Visual Studio, Visual Source Safe, JDeveloper, SVN, Jira, etc

Specialization

EDW/ETL development, data process automation, Agile methodology, etc

PROFESSIONAL EXPERIENCE

ECMS, SCOTIABANK 2015-NOW

Programmer Analyst Senior (SQL, SSIS, SSRS, .net, Hadoop developer)

Technical Environment: SQL Server 2005 - 2012, SSIS, SSRS, T-SQL, C#, ASP.NET, JQuery, Moody’s RiskFrontier; Linux, HDFS, HDP, Shell scripting, Hive, Pig, Sqoop, Flume, Spark, Scala, Ambari, Hue, DataStage, Tidal, Tableau, and Agile development practices.

Attributed Capital Project - Automate business line return on equity (ROE) reporting based on attribution of capital according to regulatory requirements, replace attribution of capital based on economic capital;

Lead EDL Oboard POC Project – Ingest and transform CAPITAL COMPUTATION AND REPORTING (CCaR) data, along with Attributed Capital parameters and Scaled RWA into EDL Hive database, facilitate Economic Capital Reporting & Analysis team to do Ad-hoc queries, Trend Analysis of historical data;

ECMS, SCOTIABANK 2014-2015

external contractor (SQL, SSIS, SSRS, .net developer)

Technical Environment: SQL Server 2005 - 2012, SSIS, SSRS, T-SQL, C#, ASP.NET, JQuery, Moody’s RiskFrontier

Economic Capital Automation Project - Communicate with business clients and Project Leads, to collect, analyze and document business requirements; Develop SSIS packages to integrate data from Finance, EGL, International Data Repository, EDW, RiskFrontier, etc; Calculate and allocate economic capital to different business lines, based on the modified Basel II formula; Provide type 1,2,3 adjustment functionalities to further fine tune EC/RC calculation and allocation;

Provide complete, timely and accurate Economic Capital calculation and allocation reports for business line and corporate decision making; Ensure capital adequacy efficiency, regulatory compliance;

RiskFrontier Q2 Deliverables – Apply Secured Nettingset LGD logic to derivative exposures; Obtain LC fronting calculated undrawn amount from ER; EC override for IG 99, etc;

RiskFrontier Q3 Deliverables – Integrate Debt Security transactions into RiskFrontier risk analysis engine; Employ user-defined model parameters, such as PD, LGD, UGD, to idendtify each exposure/portfolio’s potential risk factor and capital repuirement;

SWC (RiskFrontier software currency upgrade) Project – review and setup RiskFrontier application new environments (windows and SQL server 2012); Upgrade and re-configure SSIS packages from 2005 to 2012.

DAVIS + HENDERSON 2011-2014

Data Warehouse/ETL Developer

Technical Environment: SQL Server, SSIS/SSRS/SSAS, T-SQL, C#/VB.NET, Excel, Oracle, PL/SQL, Java, BO Data Services, Universe, Crystal Report, Cognos v7 and v10, PowerPlay, Report Studio, Informatica, MicroStrategy.

Communicate with business clients and Project Managers, to collect, analyze and document business story and requirements. As well as communicate with OLTP systems and technical staff; analyze data mapping, and draft TDD (Technical Design Document) before development.

Design star Schema, multi-Dimensional data model, and data marts

Develop and automate various ETL process using SSIS, C#/VB.NET, Java, Powershell, BO DI tools, etc. And upgrade SQL Server 2000 DTS packages to SSIS 2012

Develop reports using SSRS, Cognos Framework Manager and Report Studio.

Maintain various legacy data process and pulish data in customized formats, like supporting and building legacy Cognos 7 powercubes through PowerPlay Transformer, for self-BI.

Refactor and conform existing ETL environments, according to the best industry practices and ETL framework.

Initiate database performance tuning and optimization changes, respond to various data related alerts, issue/incidents, requests, to ensure data high-availability within SLA.

Share on call pager rotation in DBA Team to perform production database monitoring and outages troubleshooting

Perform pre-QA unit testing and colaorate with QA team through QA/UAT test, up to verification after production deployment.

Draft SOP (Standard Operating Procedures) documents for knowledge transfer to future production support.

Informatica and MicroStrategy training and sandbox play.

KEYORA INC. 2010-2011

Senior SQL Developer

Technical Environment: Window 2008/2003/XP, SQL Server 2000/2005/2008, T-SQL, XQuery, SSIS, ASP.NET 2.0/3.5, C#/VB.NET, asmx, WCF, HTML. CSS, JQuery, IIS, Excel, Selenium testing framework, and

Agile methodology.

Develop and support e-Business solutions on Webfoot (Integrated ASP.Net/SQL Server web application for Microsoft Dynamics AX and Dynamics GP), PCI DSS.

Data integration with Microsoft Dynamics AX/GP.

Database performance tuning and optimization, and troubleshooting various data related issues.

Develop various web services to exchange data with CyberSource, Moneris, and UPS, etc.

Upgrade SQL Server 2000 DTS packages to SSIS 2008.

Draft solution design document before development starts;

Perform full testing cycle during development, QA, and post-production implementation.

R&D on Facebook API.

CANAM SOLUTIONS INC. 2007-2010

SQL Server DBA/Developer and Web Developer

Technical Environment: Window 2003/2008/XP, SQL Server 2005/2008, DB2/AS400, T-SQL, XQuery, SSIS, VBScript, Power Shell, ASP, ASP.NET 1.1/2.0/3.5, C#/VB.NET, MVC, WCF, XML, Javascript, JQuery, VM Ware, Visual Source Safe 2005, Red Gate tools, SQLexecMS, excel.

Administrate/maintain production databases, test and deploy changes from developers as a gatekeeper. Also manage all databases in testing and dev environments (Installation, configuration, monitor and maintainance). Apply database performance tuning and optimization, and troubleshoot various database related issues

Daily ETL from DBS/CODA/SAP: Develop and maintain SQL jobs, to ETL core data (customers, products, inventory sales, financial) from DB2/SQL into data warehouse. Involved technology: VBScript, ADO, IBM iSeries Access for Windows ODBC driver, etc

System Integration: Create daily jobs to extract Quipware equipment rental data from IBM Informix data source, translate, and feed into SalesLink web CRM applications. Involved technology: VBScript, ADO, Informix

Web Services Integration: Create daily jobs to sync data from web services (Caterpillar products data), feed into http://www.pattencat.com/. Involved technology: SSIS, C#, WCF, xmlserializer, XQuery, OpenXML

Various data Imports: Develop various SSIS packages to ETL UCC dbf data file, InspHire equipment rental data from SQL Server, used parts data from BOSS Sybase, picture files, integrating into SalesLink application. Involved technology: SSIS, C#, ADO.NET, T-SQL, XQuery, Sybase, SQL Anywhere, Power Shell

Various data manipulations: Help customer consolidate master data from different systems/sources. Involved technology: T-SQL

Data Massage for Demosite in Canam Portal: Get real data from several customer databases, merge, consolidate and scramble the data, and then feed all our applications in the public demosite in Canam Portal http://www.canamsolutionsinc.com, avoid using all dummy data or real customer data. Involved technology: T-SQL

Trusted Responsibility and Ownership: Work as a gatekeeper, review and white-box test all developers’ code changes (ASP, ASP.NET, SQL), merge into Dealerbase (Canam’s live source code repository), and then create versioned release for customer site deployments.

Web application Development: Develop various Web CRM applications (SalesLink, SalesLink Mobile) and equipment inventory management (Pipeline, EMT, etc) for Caterpillar dealerships. Involved technology: ASP, ADO/ADO.NET, .NET 1.1, .NET 3.5, C#, MVC1.0, Ajax, JQuery, Google Maps Javascript API Version 3.

CANAM SOFTWARE LABS 2007

ASP.NET Developer

Technical Environment: Window 2003/XP, SQL Server 2005, T_SQL, ASP.NET 2.0, C#/ VB.NET, Office 2003/2007.

Developed a web based CRM management and issue tracking application, using .Net 2.0, VB.Net, SQL 2005

Outlook Automation: Created a windows service component to automatically check/parse email info from Microsoft Office Outlook and POP3 server, store and query from SQL Server, using Outlook Object Model, Outlook Redemption, and Net.Sockets.

HENGTONG CENTURY SCIENCE AND TECHNOLOGY CO., LTD 1998-2005

SQL Server/Delphi Developer and SQL Server DBA with Accounting Softwares

CVIC SOFTWARE ENGINEERING CO. 1992-1998

Product Support Save/Deposit and Accounting Softwares in Unix, for Credit Union, Post Office Saving Services

EDUCATION

Diploma of Computer Science, Shandong University, China (Sep 1985 – Jul 1989)

CERTIFICATIONS

Microsoft Certified Database Developer (2006)

Microsoft Certified Database Administrator (2006)

Microsoft Certified Web Developer (2006)

Contact this candidate