Scroll To View More
Andy Zhang, SQL Developer in Toronto, ON, Canada
Andy Zhang

SQL Developer in Toronto, ON, Canada

Member since July 9, 2017
Andy has 20 years of experience developing applications on the .NET and MS SQL server platform, and developing data warehouse and business intelligence projects on the Microsoft platform. He is highly skilled in OLTP and OLAP data modelling, back-end development, ETL, reporting and business intelligence using Microsoft technologies. He has extensive experience in financial and auto industries and has worked in teams of all sizes.
Andy is now available for hire

Portfolio

Experience

  • SQL, 19 years
  • C#, 14 years
  • Microsoft SQL Server, 14 years
  • SQL Server Reporting Services (SSRS), 10 years
  • SQL Server Integration Services (SSIS), 10 years
  • SQL Server Analysis Services (SSAS), 8 years
  • JavaScript, 5 years
  • ASP.NET MVC, 3 years
Toronto, ON, Canada

Availability

Part-time

Preferred Environment

Microsoft Platform

The most amazing...

...thing I've accomplished is the setup and development of data warehouse/business intelligence for a brand-new auto-leasing business setup by a technology firm.

Employment

  • Data Warehouse and Business Intelligence Consultant

    2009 - 2017
    SCI MarketView
    • Created a new relational and multi-dimensional hybrid data warehouse framework and environment, databases, tables, views, cubes, reports, ETL packages, jobs, scheduling, file receiving and sending, batch processing, and more; from scratch for a new Canadian lead management system and state-of-the-art automobile leasing system.
    • Studied effectively OLTP databases and data flow and modeled a better data warehouses and data marts for business intelligence and reporting.
    • Built highly efficient and scalable ETL solutions using SSIS and SQL for moving data from OLTP databases to a data warehouse.
    • Created online and distributed reports using SSRS and T-SQL.
    • Developed an innovative Windows service program to distribute reports on schedule or ad hoc to receive and send batch files through SFTP.
    • Created cubes using SSAS for business intelligence.
    • Built web applications using ASP.NET MVC business for the dashboard, operation tasks, and online reports.
    • Coded either straightforward or complex-but-effective T-SQL scripts, stored procedures, functions and SSIS packages to handle big data including structured and semi-structured data such as CSV, XML, JSON, etc.
    Technologies: MS SQL Server 2014, SSIS, SSRS, SSAS, ASP.NET MVC
  • Software Consultant

    2007 - 2009
    RBC Financial Group
    • Developed a client source management system for the RBC Wealth Management Group.
    • Programmed major projects for adding new client types—upgrading AML (anti-money laundering) rules, updating KYC (Know-Your-Client) rules, and more.
    • Fixed glitches in the bulk trading tool and commission calculator applications.
    • Troubleshot and investigated production issues.
    • Provided solutions and support for data cleansing.
    Technologies: C#.Net, T-SQL, MS SQL Server, ASP.NET
  • Software Consultant

    2006 - 2007
    SCI MarketView
    • Developed modules for the initial loading of a lot of sales history data into the OLTP databases; daily, weekly, or monthly jobs to load ongoing large amount of sales history data, campaign programs, prospect data, and more into the OLTP databases.
    • Developed a leads import module for importing real-time leads and processing batch files.
    • Built Windows services for scheduling, prioritizing, and processing real-time leads and files.
    • Developed business intelligence reports using SQL Reporting Services.
    • Created SQL Server Integration Services packages to synchronize data across databases/servers.
    Technologies: C#, T-SQL, MS SQL Server, SSIS, SSRS
  • Software Developer

    2003 - 2006
    RBC Financial Group
    • Worked closely with stakeholders such as portfolio managers, regulators, compliance, business analyst, system analyst, and upstream and downstream IT teams to resolve application issues and get ideas, gather requirements, and further to create programs or reports users desire.
    • Developed daily loading, transmission, and reconciliation of client positions and market data from the custodian systems, trading systems, and other systems.
    • Built a web-based investment model communications application for RBC Global Private Banking.
    • Developed a web-based equity transaction summary application for a compliance group.
    • Wrote web-based reports for the back office.
    • Enhanced existing and created new applications for electronic tax filing.
    • Converted all the existing applications that were written in MS-Access and Excel/VBA to web and Windows services applications and jobs—significantly increased efficiency and reduced cost and risks.
    • Built a .NET application development framework, library, and architecture.
    • Coded complex SQL scripts and stored procedures to handle a large amount data.
    Technologies: SQL Server T-SQL, C#.NET, ASP.NET, ADO.NET, XML
  • Software Developer | Team Lead

    1998 - 2003
    Hi-Think Computer Technology Co., Ltd.
    • Led 10 of 40 team players for converting existing client server financial applications to web-based applications.
    • Coded complex SQL scripts and procedures for an Oracle database.
    • Led 10 team players to develop a human resources information management system.
    • Led 4 team players to develop financial applications.
    • Developed a 3-tier architecture health care applications as part of a team.
    Technologies: VB, SQL, Oracle, COBOL, Mainframe

Experience

  • Automobile Lead, Sales, Lease, and Finance Data Warehouse (Development)

    I created the full solution for an automobile lead, sales, lease, and finance data warehouse from data modeling, ETL, reporting, and business intelligence.

    Technologies used include T-SQL, SSIS, SSRS, SSAS, C#, ASP.NET MVC.

  • Wealth Management Client Management System (Development)

    I implemented many change requests and enhancements to the client management system for the RBC wealth management group.

    I fixed glitches in the new bulk trading tool and commission calculating applications.

    Technologies used include ASP.NET, C#, MS SQL Server, and Oracle.

  • Investment Portfolio Management Applications (Development)

    I developed many web and batch investment portfolio management applications including daily loading, transmission, and reconciliation of client positions and market data from various sources for operations, an investment model communications application for RBC Global Private Banking, equity transaction summary applications for compliance group, and more.

    I converted all the existing applications written in MS-Access and Excel/VBA applications to web and Windows services applications and jobs—significantly increasing efficiency and reducing the cost and risks.

    I also coded complex SQL scripts and stored procedures to handle a large amount of financial data.

  • Challenge Solution (Other amazing things)

    In digital marketing, calculating different levels of leads to sales buy rate are key measures. We had coded complex T-SQL scripts to calculate various leads to sales buy rates. But there was a challenge to put these measures in a cube for data analysts and business users to do slice and dice themselves.

    The task fell on me in the end. After intensive thinking and research, I recreated certain data models and redesigned cubes and successfully enabled users to be able to slice and dice to get those key measures themselves. With the new data models, SQL scripts to calculate those measures have also been simplified.

    This methodology used has been applied to all similar cases in other subjects in the company.

  • Significantly Improved the Performance of All Online Reports (Other amazing things)

    Performance is very important to online reports. However many existing reports experienced performance issues when data were becoming bigger and bigger.

    I took the initiative to solve the performance issue by redesigning certain tables, rewriting scripts and building proper indexes etc. All report performances have been improved in the end.

    Some large reports even show up in seconds instead of minutes. In the end, users were very satisfied.

  • Loading and Parsing JSON Data from an OLTP Database Efficiently and Effectively (Other amazing things)

    Some key data was stored as a JSON string in the OLTP database.
    There were also different versions of JSON with the system upgrade as time went by. It was quite a challenge to load and parse the JSON data to the data warehouse.

    I created an innovative way to accomplish this by using SSIS and SQL scripts to load and parse JSON data in different versions.

    The solution saved a lot of time and kept data integrity and completeness in the data warehouse with each system upgrade of OLTP applications.

Skills

  • Languages

    SQL, C#, JavaScript
  • Storage

    SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Microsoft SQL Server
  • Frameworks

    ASP.NET MVC
  • Paradigms

    Functional Programming, Agile Software Development
  • Platforms

    Windows

Education

  • Canadian Securities Course Certificate in Securities
    2003 - 2004
    Canadian Securities Institute - Toronto, Canada
  • Bachelor's degree in Computer Science
    1994 - 1998
    Shandong University - Shandong, China
I really like this profile
Share it with others