Gordon Lee

About Gordon Lee

Experience data analyst responsible for clearing and analyzing data, building model, creating visualization for monitor and forecasting report.

Experience

1. Data Analyst

   Microsoft

   May 2020 — Present · Redmond, WA, US

   Successfully transfer the Report to Power BI from the Avocado service before the service deprecated.Created the data connection between Cosmos DB, azure data explorer (Kusto), and Power BI through Lens explorer.Built the orchestrate job for the daily scheduled extracting of the aggregated Cosmos DB data into the azure data explorer.Built the Power BI report to display the Tenants and service for Mis-provisioned using power query and DAX.Analyzed the Subscription dataset and extract the information for the detailed report.Built the data model and dynamic connection to interact between the Tenant\'s report with the details report.Built the Power BI app and set up the security access control to share the report with other users.Discovered a problem causing 90% of the Mis-provisioned Tenants can not be detected for years.Fixed the problem resulting 10 times more of Mis-Provisioned Tenants showing on the report and creates a plan to correct for the MIs-Provisioned Tenants.

Education

• Udacity

  Self-Driving Car Engineer

  2016 — 2017

• Udacity

  Data Analyst Nanodegree

  2016 — 2017

• WorldQuant University

  Master's degree, Financial Engineering

  2019

• San Francisco State University

  Bachelor's degree, Accounting

  2011 — 2013

• WorldQuant University

  Data Science

  2019 — 2020

Skills

• Python
• Amazon Web Services (Aws)
• Tensorflow
• Accounts Payable
• Microsoft Office
• Leadership
• Databases
• Management
• Html
• Accounting
• C++
• Machine Learning
• Auditing
• Ros
• Scikit-Learn
• Data Analysis
• Tax
• Accounts Receivable
• Research
• Deep Learning
• Account Reconciliation
• Microsoft Excel
• Powerpoint
• Microsoft Word
• Computer Vision
• Visual Basic for Applications (Vba)
• R