Hi, I'm Marco!

I wrangle messy datasets, build statistical models, and create interactive vizes.
I studied Economics and Computer Science at Claremont McKenna College and graduated wiith honours in May 2022. In the past, I’ve had the privilege of working in eCommerce, AdTech, and venture capital,. My main focus these days is learning more about financial markets at Knightsbridge.

Analyst @ Knightsbridge

Jul 2023 - Present

Knightsbridge is a boutique asset manager based in Newport Beach with over $700MM AUM. I work on data reporting, investment research, trading, and ad hoc analysis.

Data Scientist @ Chenbro

Dec 2022 - Jul 2023

Chenbro designs and builds datacenter storage solutions for companies like AWS.

  • Build interactive dashboards with Excel, Power BI, and R Shiny for the sales team to monitor product demand
  • Revamp inventory fulfilllment strategy to include historical sales records, open orders, and market trends
  • Write ETL scripts to automate inventory report generation, saving the operations team time repeating manual Excel calculations weekly
  • Construct regression and classification models with Python scikit-learn that predict chassis cost based on hardware specifications to aid product quotation
  • Data Scientist @ Greycroft

    Jan 2021 - May 2021

    Greycroft manages over $2 billion in venture capital invested in 196 companies including Bumble, Bird, and Venmo.

  • Performed data wrangling and exploratory analysis on business data of 5000+ pre series B funded companies to gauge the startup landscape.
  • Constructed regression models with R that indentify attributes influencing later stage growth and funding success, helping investors hone in on important details during due diligence.
  • Data Science Intern @ Apple

    Sep 2020 - Dec 2020

    Apple Ad Platforms works on App Store Search Ads product, helping developers capture attention for their apps on the App Store.

  • Led an archival process that reduced total number of Tableau workbooks by over 30%, reclaiming storage space in preparation for server migration
  • Developed a directory with Tableau to help all Ad Plaftorms teams better navigate the 470+ workbooks
  • Queried App Store search data with SQL and analysed for seasonal trends
  • Marketing Analytics Intern @ Brik+Clik

    Mar 2020 - Aug 2020

    Brik+Clik builds smart stores allowing online-only retailers to open physical spaces with lower construction time and cost.

  • Synthesised key engagement metrics from social media compaigns (Facebook & Instagram) into weekly executive summaries for the CEO.
  • Researched the retail market during the pandemic by gathering online news, scraping product data, and attending virtual conferences.
  • Performed other ad hoc tasks such as website SEO management and customer outreach
  • Media Technology Assistant @ CMC Information Technology Services

    Aug 2019 - May 2022

    Information Technology Services at Claremont McKenna College provides technology support for students, faculty, and staff.

  • Provide technical set up and support for AV equipment for lectures and campus events.
  • Skills and Languages

    Below are some technologies and languages that I've worked with in the past. Always looking to expanding this table!

    Python

    pandas, numpy, scikit-learn, nltk, matplotlib, beautifulsoup, plotly

    R

    tidyverse, flexdashboard

    SQL

    Tableau

    HTML & CSS

    C++

    Mandarin

    Cantonese

    Get in touch

    Reach out!