Brian Jin, Data Visualization Developer in Toronto, ON, Canada
Brian Jin

Data Visualization Developer in Toronto, ON, Canada

Member since January 6, 2020
Brian has a decade of substantial experience in data integration, data architecting, and data modeling in various industries such as government, banking, investment, and so on. The way Brian works is by designing the most optimized, scalable, and robust solution based on requirements. Brian's curiosity is what drives him to learn about new business areas, tackle new challenges, and embrace new technologies.
Brian is now available for hire

Portfolio

Experience

Location

Toronto, ON, Canada

Availability

Part-time

Preferred Environment

Azure, SQL Server, Python, Data Lake, Power BI

The most amazing...

...project I've led and completed was an Azure IoT project and subsequently won Microsoft IMPACT Award in 2015.

Employment

  • Azure Data Architect

    2018 - PRESENT
    Toronto Public Library
    • Successfully delivered an enterprise data warehouse design and implementation for a government agency using the Azure platform (ADF v2, Azure SQL, databricks, data lakes, logic apps, automation runbooks, Power BI, and so on).
    • Contributed to procurement, policy review, and other business-related meetings to provide data governance advice.
    • Converted a lot of manual process to automated fashion and improved staff productivity.
    • Trained the staff to use the database and to write queries using SQL and Python.
    • Gathered business requirements with the business and advised on improvements where necessary.
    Technologies: Azure, Databrick, SQL, Python, Recommendation Engine, Power BI, SSRS Report Automation
  • Azure Data Consultant

    2018 - 2018
    ObjectSharp Consulting
    • Worked with the Microsoft technical sales team to create side-by-side feature comparisons between Azure SQL managed instances and SQL Server 2008 R2 on premise.
    • Worked on detailed features including indexes, replications, SSRS, SSIS, SSAS, job agent, and so on.
    • Successfully signed a migration project from a financing firm.
    Technologies: Azure SQL Managed Instance, SQL Server 2008 R2
  • Database Consultant

    2018 - 2018
    Gluskin Sheff Associates
    • Migrated a financial database for a trading analyst from MySQL to SQL Server 2016.
    • Converted 20+ Excel applications written in VB and Python to use SQL Server 2016 due to syntax changes.
    • Refined and optimized some applications and the new SQL Server to achieve a high performance.
    • Provided technical training to business analysts on SQL Server.
    • Advised and designed the future proven Azure database platform as an enterprise data strategy.
    Technologies: MySQL, SQL Server 2016, Python, Visual Basic
  • Business Intelligence Consultant

    2017 - 2018
    TD Bank Technology Solution
    • Implemented transnational replication to support OLTP transactions and real-time reporting.
    • Created a dimensional data model using star schema for data analytics.
    • Implemented Power BI for performance scorecards and SSRS reports for scheduled reporting.
    • Trained junior team members and participated in performance reviews.
    Technologies: SQL Server 2012, SSRS, SSIS, Power BI, Dimensional Modeling, Transnational Replication
  • Business Intelligence Consultant

    2010 - 2017
    Various Full-time Positions
    • Developed various datamart and database solutions for financial institutions, REIT, and software companies.
    • Gathered the initial requirements by managing stakeholder meetings.
    • Led several projects including a highly sensitive fraud database project.
    Technologies: Azure, SQL, Python, Power BI, Tableau, SSIS, SSRS, SSAS, C#, Dimensional Modeling, MySQL, Oracle

Experience

  • Design and Implementation of an Enterprise Data Warehouse for a Government Agency (Development)

    As an Azure data architect, I successfully delivered an enterprise data warehouse design and implementation for a government agency using the Azure platform (ADF v2, Azure SQL, databricks, data lake, logic apps, automation runbooks, Power BI, and so on).

    I participated in procurement, policy review, and other business-related meetings to provide data governance advice. I also converted several manual processes to automated ones and improved staff productivity.

  • Azure IoT Hub for a Mining Company (Development)

    I created an IoT hub pipeline that transferred data from IoT sensors deployed to train cabins. I stored the data using Azure Blob Storage and designed a Python application to clean up the data. Then I loaded it to the Azure SQL database for the daily dashboard to visualize the overall quality metrics. I collaborated with a team of data scientists and explored potential ML models to benefit quality control.

  • Consumer Segmentation for a Startup (Development)

    I led and designed a consumer segmentation data model using massive firewall log data in collaboration with other members. I utilized many types of open-source software to minimize technology expenses during the proof-of-concept stage and built the transition plan for production deployment.

  • Data Integration Project for an Advertising Agency (Development)

    I created a data pipeline to consolidate more than ten data sources on Azure platforms by using Azure Data Factory v1 and a Windows service application on Azure VM. The data included the Google Analytics API, Facebook Page API, Twitter API, Bing Ads API, Nielson viewership data, and more. I also created a data model for campaign analysis on Azure SQL and designed Power BI dashboards for daily campaign metrics.

Skills

  • Languages

    SQL, Python, C#, Java, JavaScript, Octave
  • Paradigms

    Dimensional Modeling, Agile Software Development
  • Platforms

    Azure, Amazon Web Services (AWS)
  • Storage

    SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SSAS Tabular, SQL Server 2014
  • Other

    Data Modeling, Data Visualization, Streaming Data, Source Control Management, AWS
  • Tools

    Microsoft Power BI, Tableau

Education

  • Bachelor's degree in Computer Science
    2005 - 2009
    University of Waterloo - Waterloo, Ontario, Canada

Certifications

  • MCSA SQL Server 2012
    DECEMBER 2015 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others