Pingxin Gao

Pingxin Gao

Experienced Data Analyst

Email me

About

Hi there! I'm Pingxin Gao 👋
A curious tech enthusiast with a knack for turning data into solutions and algorithms into action. By day, I automate workflows, build smart chatbots, and craft dashboards that make executives smile. By night, I’m a lifelong learner—juggling Python scripts, experimenting with AI, and occasionally geeking out over hyperspectral image segmentation (yes, it’s as cool as it sounds).

With a dual master’s in Computer Science and Chemistry, I bridge the gap between logic and creativity, whether optimizing financial systems at Spartao Oy or researching how catalysts and code can shape a smarter world. When I’m not coding or analyzing datasets, you’ll find me exploring Finland’s forests or hunting for the perfect cup of coffee. ☕

Let’s connect đŸ€ and turn challenges into opportunities 🚀—or just chat about tech đŸ’»!

Experience

  1. 2023 — Present

    Spartao Oy logo Finance Controller & Analyst · Spartao Oy

    Serving as the main finance controller while administering NetSuite ERP system and maintaining the company's data infrastructure. Responsible for cross-system data synchronization and curating BI reports for all stakeholders. Developed automated financial workflows using Python and built interactive dashboards with Streamlit and SQL to provide performance insights. Continuously implementing innovative solutions to enhance data accessibility and financial visibility across the organization.

    • Python
    • Power BI
    • Streamlit
    • Metabase
    • SQL
    • NetSuite
    • SuiteScript

    Noteworthy Projects:

    • NetSuite ETL

      Automated the extraction and transformation of financial data from NetSuite ERP system to Metabase for real-time reporting and analytics.

    • Account Payable Automation Bot

      Developed automation tools based on Selenium and large language models to automate the AP process, which eliminated 80% of manual work by streamlining invoice processing.

    • Self-hosted Metabase

      Self-hosted Metabase instance for internal organization-wide data analytics.

  2. July 2022

    Designed a multi-page Tkinter application for ENVI image file visualization and analysis. This project enhanced my expertise in GUI design, image processing, and data analytics while giving me hands-on experience in building practical tools for scientific research.

    • Python
    • Tkinter
    • ENVI
    • Image Processing
  3. May 2021

    Leveraged deep learning by implementing the U-Net model for spectral image segmentation. Built a simple yet effective GUI to visualize the segmentation process, making AI-driven image processing more accessible and intuitive.

    • Python
    • U-Net
    • Machine Learning
    • GUI
  4. December 2019

    Dove into the world of data science by mastering RStudio and RMarkdown. Explored open datasets, created insightful visualizations, and built compelling reports that told meaningful data-driven stories.

    • R
    • RStudio
    • RMarkdown
    • Data Science