Projects

3 minute read

Past Industry Projects

Autodesk [2019-2025]

Senior Data Analyst, PSET Analytics - Autodesk Platform Services

2022-Present

Click here for more information

Projects

  • APS Unit Economics:
    • Description: This project involves piloting Developer API pricing and consumption for the Autodesk Platform Services (APS) platform across different customer types, such as Named and Midmarket.
    • Business Impact: Add a new line of revenue for Autodesk in PSET division monetization initiatives affecting 1,500+ customers & partners.
  • APS Cloud Consumption Dashboard:
    • Description: This customer dashboard displays consumed cloud credits for developer API usage.
    • Business Impact: Provide PSET division-associated Token and Sales teams (100+) a gauge on how to educate and inform customers about API overuse, saving customers money and building a better partnership with Autodesk.
  • PSET KPI Dashboard:
    • Description: This is a C-suite analytics dashboard for the PSET organization, including sub drill-down dashboards. Each dashboard is built on Looker, ensuring a robust user experience and thorough requirement gathering.
    • Business Impact: Create one-stop-shop for a quick summary of analytics at the C-suite (20+) and Platform Initiative levels (50+ Product & Technical Managers).
  • Operation Review Process (Exec Summary)
  • Analytics Team
    • Team Lead - FY'26: Leading Analytics team of 5 for 6 months, during Sr. Analytics Manager on Medical Leave
    • Business Intelligence Sprawl
    • AWS & Snowflake Cloud Cost Forecasting
    • GenAI Analytics Integration Coaching
    • Founded Analytics Team Analytics Agile process
  • Platform Initiatives
    • Identity Analytics:
      • Develop V1 Framework for SSO & Authentication Logging Analytics
      • Logging & Observability Dashboard
    • Universal Data Access Analytics:
      • UDA Search Based Integration Analytics
      • Cohort Retention & Adoption Analytics
    • Design & Make Analytics:
      • Cohort Retention & Adoption Analytics
      • AEC, MFG, and M&E Data Model Platform Analytics Dashboards
      • Data Exchange Adoption and Funnel Analytics
      • Power BI Adoption after General Release
  • Analytics Engineering:
    • Mixpanel Product Analytics Instrumentation with Fivetran Snowflake, and dbt Core
    • Identity Product Analytics Instrumentation with Fivetran Snowflake, and dbt Core
    • Hive-based Product Analytics Instrumentation with Presto and dbt Core

Data Analyst, Data Products - Autodesk Construction Solutions

2021-2022

Click here for more information

Projects

  • BIM 360 Build Analysis:
    • Description: ACS Customer Success is determining why BIM 360 Build offering Renewal Rates are decreasing, but usage is increasing.
  • Prospect Accounts:
    • Description: Few ACS business sales leaders requested sample of Autodesk non-ACS customers to cross-sell to
  • Analytic Engineering - External Project Lead Sources:
    • Description: Ingest external data sources from custom APIs Glenigan, Global Data, and BCI Australia & Asia into ACS Snowflake
  • Prodpad Usage
    • Description: Providing 200+ ACS Research & Development and Customer Success users insights on customer feedback data via Prodpad.
  • Feasability Analyses
  • BIM 360 Cost Control Analysis
  • ACS eStore Analytics and reporting

Data Analyst, Data Engineering - Autodesk Construction Solutions

2019-2021

Click here for more information

Projects

  • Founding team for Modern Data Analytics
    • Description: Build the first platform with Snowflake, dbt Cloud, and Fivetran.
  • BIM 360 Data Source Migration
    • Description: Migrated source SFTP file repository from Cleo SFTP to Xinch SFTP
  • dbt Documentation website
    • Description: Setup dbt Documentation deployed on AWS S3, Static Wbsite
  • BIM 360 Database & BI Migration from Domo BI to Snowflake
    • Example: BIM 360 HQ Account & Subscriber Dashboard
  • Building 500+ models, tests, and LookML for ACS data
  • External: Fivetan Presentation:"How Autodesk Achieves Fast, Reliable Data Pipelines with Snowflake and Fivetran"

Google [2018-2019]

Business Data Analyst

Click here for more information

Projects

  • Develop Dashboards and use Google Big Query for System Issues and Program Insights for Sub-Engineering team of ~10 Googlers
  • Contribute Javascript Code Migration for 100+ variables including respective Unit Tests, supporting 3 Engineers
  • Used Python for API calls for backend configuration of system information
  • Streamline team documents & resources using Markdown, HTML, or GSuite applications for 8 System Data Analysts
  • Manage and Resolve escalated issues of several Backend Pipelines

Skills: Python, SQL (BigQuery), Javascript, HTML, BI Dashboards, Dremel, and App Script

MobileIron [2017-2018]

Data Analyst

Click here for more information

Projects

  • Analyze Salesforce Sales related (Quotes, Orders, Billing Schedules, etc.) data for 2,000+ customer accounts
  • Produce Salesforce and Domo reports and dashboards for Sales and Applications teams using MySQL or Salesforce Reporting
  • Perform regression and unit testing for data validation, system updates all under SCRUM and Sprint model
  • Data Wrangling and Transformation for 60%+ Asset information for migration to new system
  • Initiate Sales Department Opportunity Renewal Automation Procedure and post analysis from Q4 2017 to Q4 2018

Personal Projects

In my spare time, I produce data-related projects. The following is a sample of some personal projects I have produced

Click here for more information

APIs and Databases

  • Youtube Data Analysis Project (APIs, Python, SQLALchemy, Flask, SQL
  • Open Street Map Data Wrangling
  • Presentation Slide Decks

  • AB Testing in Python talk @PyData LA 2019]
  • Flask & SQLAlchemy Demo (PyBay 2018)
  • Visualizations

  • Bridge To Prosperity Tableau Dashboard #MakeOverMonday
  • My Strava running mileage per session data, using D3.js & HTML.
  • and more!

  • Github Profile: https://github.com/CloudChaoszero