Azure Data Architect2018 - PRESENTToronto Public Library
Technologies: Azure, Databrick, SQL, Python, Recommendation Engine, Power BI, SSRS Report Automation
- 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.
Azure Data Consultant2018 - 2018ObjectSharp Consulting
Technologies: Azure SQL Managed Instance, SQL Server 2008 R2
- 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.
Database Consultant2018 - 2018Gluskin Sheff Associates
Technologies: MySQL, SQL Server 2016, Python, Visual Basic
- 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.
Business Intelligence Consultant2017 - 2018TD Bank Technology Solution
Technologies: SQL Server 2012, SSRS, SSIS, Power BI, Dimensional Modeling, Transnational Replication
- 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.
Business Intelligence Consultant2010 - 2017Various Full-time Positions
Technologies: Azure, SQL, Python, Power BI, Tableau, SSIS, SSRS, SSAS, C#, Dimensional Modeling, MySQL, Oracle
- 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.