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
-
2023 â Present 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.
-
-
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
-
-
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
-
-
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
-