Davis Wei, Developer in Montreal, QC, Canada
Davis is available for hire
Hire Davis

Davis Wei

Verified Expert  in Engineering

BI and Database Developer

Location
Montreal, QC, Canada
Toptal Member Since
February 24, 2021

Davis is a seasoned engineer with a decade of experience in data engineering and analysis. He had led several data projects involving the transformation of on-premises databases to cloud-based data lakes using AWS and Azure. He has a wealth of experience designing and developing data visualizations to present complex data models to stakeholders at all levels. He holds an MBA and has experience with data mining and machine learning.

Portfolio

Saint Laurent Consulting
Tableau, Tableau Server, Amazon QuickSight, Amazon Web Services (AWS)...
Amazon.com
SQL, Tableau, Amazon Web Services (AWS), Amazon QuickSight, Redshift Spectrum...
Morgan Stanley
SQL, Tableau, SAP Business One, IBM Db2, Microsoft Power BI, MySQL Workbench...

Experience

Availability

Part-time

Preferred Environment

SQL, Tableau, Amazon QuickSight, Amazon Web Services (AWS), Azure, APIs, Azure SQL Databases, Business Intelligence (BI), Data Analysis, Dashboards

The most amazing...

...product I launched was an Amazon Prime Video One Catalog allowing US and EU viewers to choose multiple subtitles and audio tracks in different languages

Work Experience

Data and Business Intelligence Director

2019 - PRESENT
Saint Laurent Consulting
  • Architected and implemented the data lake and business intelligence platform for clients. Scoped requirements with clients to provide end-to-end solutions to clients.
  • Provided systematic training to clients on AWS, Tableau, Power BI, and data analysis-related tools.
  • Launched a few milestones for clients to improve the operational and data analytics works.
Technologies: Tableau, Tableau Server, Amazon QuickSight, Amazon Web Services (AWS), Microsoft Power BI, Looker, Analytics, Amazon Athena, T-SQL (Transact-SQL), Microsoft SQL Server, SQL DML, Dimensional Modeling, MySQL, Redshift, ETL, Business Intelligence (BI)

Senior Business Intelligence Engineer

2020 - 2022
Amazon.com
  • Architected and implemented data lake and BI using native AWS services for the Amazon Pharmacy project.
  • Onboarded the data source and designed KPIs and dashboards for Amazon internal teams to track COVID-19 tests for global employees.
  • Launched Amazon Prime Video One Catalog, allowing US and EU customers to view multiple subtitles and choose audio tracks in different languages within a single video.
  • Supported Amazon Prime Video's worldwide content operation team by providing insightful analyses to improve digital supply chain efficiency.
Technologies: SQL, Tableau, Amazon Web Services (AWS), Amazon QuickSight, Redshift Spectrum, AWS Glue, Amazon S3 (AWS S3), Redshift, Dashboards, Business Intelligence (BI), Python, Dimensional Modeling, MySQL, ETL, User Experience (UX)

Senior Business Intelligence Engineer

2013 - 2020
Morgan Stanley
  • Spearheaded multiple business intelligence initiatives in collaboration with key internal stakeholders, including equity trading, fixed income, and legal and compliance, to support critical business and strategic decisions.
  • Improved data lake and BI platform operational models by analyzing and summarizing information on gaps, trends, and areas of concern using data visualization and statistical models.
  • Translated complex technical jargon in simple language for business users and reiterated business requirements for technology teams. Provided regular training to users on analytical tools, trading flows, and business models.
Technologies: SQL, Tableau, SAP Business One, IBM Db2, Microsoft Power BI, MySQL Workbench, Azure SQL Databases, ETL, Microsoft SQL Server, SQL DML, Data Queries, SQL Performance, Performance Tuning, T-SQL (Transact-SQL), Dimensional Modeling, MySQL, Business Intelligence (BI), User Interface (UI), SAP

Amazon.com

http://www.primevideo.com
Amazon Prime Video has multiple videos with different languages for the same title. For example, "Frozen II" has over ten different versions with various languages in numerous regions. I was part of the team that launched the One Catalog program enabling customers to view a single title with a single video clip, with extended options to choose multiple languages and audio tracks within the same video clip.

Tableau Server Migration for a Non-profit Organization

Architected and implemented Tableau Online for a nonprofit organization. Gathered information from stakeholders and contributed to the technology design with web developers. Embedded Tableau with the client's existing portal.

Architect Tableau Platform for a Nonprofit Organization

Built end-to-end Tableau solutions for a nonprofit organization and the API and data pipeline to automate the data and process. Provided user best practices and training to end users. Helped the user find out the bottleneck during the process.

Languages

SQL, SQL DML, T-SQL (Transact-SQL), Python

Tools

Tableau, Amazon Athena, MySQL Workbench, Amazon QuickSight, Microsoft Power BI, GitHub, Amazon SageMaker, Redshift Spectrum, AWS Glue, Looker, Tableau Desktop Pro

Paradigms

Business Intelligence (BI), ETL, Data Science, Dimensional Modeling

Platforms

QlikView, Amazon Web Services (AWS), Azure

Storage

IBM Db2, Redshift, Microsoft SQL Server, SQL Performance, MySQL, Azure SQL Databases, Azure Cosmos DB, Azure SQL, Data Lakes, Amazon S3 (AWS S3), PostgreSQL, SQL Architecture

Other

SAP Business One, Data Visualization, Analytics, Data Analytics, Dashboards, Data Queries, Performance Tuning, User Experience (UX), SAP, Data Analysis, Statistics, User Interface (UI), Machine Learning, Strategy, Business Technology, Tableau Server, APIs, Web UI, User Authentication, Data Build Tool (dbt)

2015 - 2018

Master's Degree in Business Administration (MBA)

Carnegie Mellon University - Pittsburgh, Pennsylvania, USA

MAY 2015 - PRESENT

Graduate Certificate in Data Mining and Machine Learning

Stanford University