Davis Wei, BI and Database Developer in Montreal, QC, Canada
Davis Wei

BI and Database Developer in Montreal, QC, Canada

Member since February 24, 2021
Davis is a seasoned business intelligence engineer lead with ten years of experience leveraging data to drive business decision-making processes. He is well-versed in designing and developing data visualizations to present complex data models to stakeholders of different levels. Davis launched Amazon Prime Video One Catalog allowing US and EU customers to view multiple subtitles and audio tracks in different languages within a single video. He has an MBA with a background in data mining and ML.
Davis is now available for hire

Portfolio

  • Saint Laurent Consulting
    Tableau, Tableau Server, Amazon QuickSight, AWS, Microsoft Power BI, Looker...
  • Amazon.com
    SQL, Tableau, AWS, Amazon QuickSight, Redshift Spectrum, AWS Glue...
  • Morgan Stanley
    SQL, Tableau, SAP Business One, IBM Db2, Mainframe, Microsoft Power BI...

Experience

Location

Montreal, QC, Canada

Availability

Part-time

Preferred Environment

MacOS, Windows, SQL, Tableau, Amazon QuickSight, AWS, Azure, Azure Cosmos DB, Azure SQL

The most amazing...

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

Employment

  • Data and Business Intelligence Director

    2019 - PRESENT
    Saint Laurent Consulting
    • Performed daily operation of data and BI functions. Worked with clients to provide end-to-end solutions to clients.
    • Conducted training for junior professionals on Tableau, Power BI, and data analysis.
    • Provided Tableau training and consulting to onboard to Tableau platform.
    Technologies: Tableau, Tableau Server, Amazon QuickSight, AWS, Microsoft Power BI, Looker, Analytics, Amazon Athena, Transact-SQL, Microsoft SQL Server, SQL DML, Dimensional Modeling, MySQL, Redshift, ETL, Business Intelligence (BI)
  • Senior Business Intelligence Engineer

    2020 - 2022
    Amazon.com
    • 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.
    • Onboarded the data source and designed KPIs and dashboards for Amazon internal teams to track COVID-19 tests for global employees.
    • Supported the Amazon Prime Video worldwide content operation team by providing insightful analyses to improve the digital supply chain efficiency.
    Technologies: SQL, Tableau, AWS, Amazon QuickSight, Redshift Spectrum, AWS Glue, Amazon S3 (AWS S3), Redshift, Dashboards, Business Intelligence (BI), Python, Dimensional Modeling, MySQL, ETL, 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, Mainframe, Microsoft Power BI, Alteryx, MySQL Workbench, Azure SQL Databases, ETL, Transact-SQL, Microsoft SQL Server, SQL DML, Data Queries, SQL Performance, Performance Tuning, T-SQL, Dimensional Modeling, MySQL, Business Intelligence (BI), UI, SAP

Experience

  • 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.

Skills

  • Languages

    SQL, Transact-SQL, SQL DML, T-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, Data Analyst, Dashboards, Data Queries, Performance Tuning, UX, SAP, AWS, Data Analysis, Statistics, UI, Machine Learning, Strategy, Business Technology, Tableau Server, APIs, Web UI, User Authentication, DBT

Education

  • Master's Degree in Business Administration (MBA)
    2015 - 2018
    Carnegie Mellon University - Pittsburgh, Pennsylvania, USA

Certifications

  • Graduate Certificate in Data Mining and Machine Learning
    MAY 2015 - PRESENT
    Stanford University

To view more profiles

Join Toptal
Share it with others