M

Michael Bi

About

Detail

Texas, United States

Contact Michael regarding: 
work
Full-time jobs

Timeline


work
Job

Résumé


Jobs verified_user 0% verified
  • Take-Two Interactive Software, Inc.
    Product Manager
    Take-Two Interactive Software, Inc.
    Oct 2020 - Dec 2021 (1 year 3 months)
    • Executes ad-hoc data request tasks with SQL in Snowflake, Redshift, and AWS Spectrum; assists data engineering team with error identification in ETL pipelines • Used PySpark to explode and flatten nested JSON data via AWS Glue, Step Functions, and S3 for ingestion into Redshift and visualization in Tableau; used CloudWatch, Lambda, and DynamoDB to record logs and Glue job metadata • Architected the migration of more than 50 DAGs, 30 custom plugins, and 30 stored procedures from Astronomer to MWAA / Airflow + Redshift • Builds ETL and ELT pipelines using Python, Jupyter Notebook, and Databricks for custom views in Snowflake • Worked with data engineering and business stakeholders to conduct email database migration of staging and prod
  • A
    Consulting Analyst
    Altman Solon
    Sep 2019 - Oct 2020 (1 year 2 months)
    • Collaborated with analytics, research, and management to solve client problems (market entry, product launch go/no go, investment decisions, fiber swaps) across fibercos, towercos, telcos, cablecos, and investors • Built financial and opportunity sizing models, market simulations, and user survey logic using Tableau, Power BI, VBA, HTML/CSS/JS, Perl, and jQuery • Used Python and PySpark to analyze fiber routing and construction cost data to determine optimal fiber routing path for telco and cableco clients • Used PowerPoint to leverage data-driven storytelling to drive client solutions • Led junior analyst to assess poor marketability for a client's streaming product with a 10K+ participant user study • Conducted 50+ expert and user
  • 3
    Owner, AWS Data Engineer
    309 Group, LLC
    Jan 2018 - Sep 2019 (1 year 9 months)
    • Constructed end-to-end ETL pipeline with AWS (S3, Redshift), Airflow, and Tableau to display pricing data for products within the client's Amazon product niches; data was mined using Beautiful Soup, a Python library • Refactored client ETL processes by optimizing SQL queries, implementing proper sort and dist keys, refreshing table statistics, optimizing compression techniques, and precalculating KPIs within the ETL pipeline, improving ETL performance by 60% • Assisted with creation of semantic data layer by coordinating requirements from business stakeholders with the construction of the data model with data engineering • Collaborated with data engineering to optimize OLTP and OLAP data warehouses by modeling fact and dimension field
Education verified_user 0% verified
  • Dartmouth College
    B.A. in
    Dartmouth College
This is a community-created genome.