Andy Zhang, Software Developer in Toronto, ON, Canada
Andy Zhang

Software Developer in Toronto, ON, Canada

Member since August 14, 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 modeling, back-end development, ETL, reporting, and business intelligence using Microsoft technologies. Andy also has extensive experience in financial and auto industries and has worked in teams of all sizes.
Andy is now available for hire

Portfolio

  • SCI MarketView
    ASP.NET, C#.NET, T-SQL, Agile Software Development, JavaScript...
  • RBC Financial Group
    Agile Software Development, JavaScript, ASP.NET, Microsoft SQL Server, T-SQL...
  • SCI MarketView
    ASP.NET, C#.NET, Agile Software Development, SSRS...

Location

Toronto, ON, Canada

Availability

Part-time

Preferred Environment

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 - 2020
    SCI MarketView
    • Responsible for architecting and building relational and multi-dimensional hybrid data warehouse framework and environment, databases, tables, views, cubes, reports, ETL packages, jobs, scheduling, file exchanging, batch processing, and more.
    • Modeled successful data warehouse 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 multi-dimensional cubes using SSAS for business intelligence.
    • Built web applications using ASP.NET MVC business for the dashboard, operation tasks, and online reports.
    • Writing T-SQL scripts, stored procedures, functions and SSIS packages with performance always in mind to handle big data including structured and semi-structured data such as CSV, XML, JSON, etc.
    • Migrated data from in-house and third party system to a new third party system for a vehicle leasing system.
    Technologies: ASP.NET, C#.NET, T-SQL, Agile Software Development, JavaScript, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SQL Server 2014, ASP.NET MVC, SSAS, SSRS, SQL Server Integration Services (SSIS), Microsoft SQL Server
  • 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: Agile Software Development, JavaScript, ASP.NET, Microsoft SQL Server, T-SQL, C#.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: ASP.NET, C#.NET, Agile Software Development, SSRS, SQL Server Integration Services (SSIS), Microsoft SQL Server, T-SQL, C#
  • 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: JavaScript, Transact-SQL, XML, ADO.NET, ASP.NET, C#.NET, Microsoft SQL Server, T-SQL
  • Software Developer | Team Lead

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

Experience

  • Automobile Leads, Sales, Lease, Finance, eCommerce Data Warehouse

    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

    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

    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

    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

    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

    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, VB, T-SQL, C#.NET, XML, Transact-SQL
  • Storage

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

    ASP.NET MVC, ASP.NET
  • Paradigms

    Functional Programming, Agile Software Development
  • Tools

    SSRS, SSAS, Microsoft Power BI
  • Platforms

    Oracle, Azure

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

To view more profiles

Join Toptal
Share it with others