Welcome To My Personal Website!
About Me Experience

Taipei, Taiwan

Yuting Weng

• Automate Data Workflows with Power BI, Python & SQL | Improve Data Reliability | Explore LLM Solutions for Smarter Business Intelligence
• Master of Public Policy, University of Chicago | Data Analytics Track (STEM)
• BA in Economics, National Taiwan University

Hi, I’m Yuting! I’m a BI Developer at Sintrones Technology, designing Power BI dashboards and building Python-based data pipelines that integrate and transform data from ERP systems, Oracle, Excel, and other sources. My work automates reporting, resolves data discrepancies, and improves data reliability while streamlining workflows and delivering actionable insights across teams. I’m also conducting early-stage LLM implementation research to explore AI-assisted solutions for R&D workflow and technical document retrieval.
I hold a Master’s in Public Policy from the University of Chicago, specializing in data analytics, and I’m passionate about leveraging diverse data to drive smarter decisions and innovation! 😎


👉 Download CV

Professional Experience

  • Sintrones Technology Corporation

    Business Intelligence Developer
    September 2024 - Present

    • Designed and automated Power BI dashboards and semantic models integrating Oracle and Tiptop ERP data, delivering standardized, governance-aligned business metrics through SQL-based views while reserving analytical calculations for DAX to support decision-making for 30+ users

    • Developed and customized ERP functionality and data logic, including SQL modification and validation, field and UI additions/removals, and database write-back to align transactional data with defined business rules

    • Performed root-cause analysis to resolve data discrepancies across ERP and reporting layers, and built Python-based web scraping and ETL pipelines to standardize data inputs and streamline reporting workflows

    • Led applied LLM research and prototyping to support R&D workflows by exploring intelligent document retrieval and question-answering solutions to improve access to technical knowledge


    Skills: #Power BI #Python #SQL #Tiptop ERP #LLM

  • Anti Human-Trafficking Intelligence Initiative

    Pro Bono Data Analyst
    March 2024 - June 2024

    • Collaborated with the scraping team to define data storage requirements for each scraper and designed a robust MySQL schema

    • Developed Python scripts to build efficient data pipelines, ensuring seamless SQL database connections, enhancing data integrity, and enabling real-time data logging and querying for further analysis


    Skills: #Python #MySQL #Database Management

  • University of Chicago Data Science Institute

    Data Analyst Intern - Client: WBEZ Chicago
    January 2024 - March 2024

    • Executed data cleaning and preprocessing on a large-scale 12GB SQLite database, querying and extracting key features for advanced analysis

    • Collaborated with a team of four and stakeholders to develop and deploy two interactive and user-friendly web applications, using Dash for webpages and Streamlit for dashboard

    • Leveraged advanced data visualization techniques, including GeoPandas for mapping county-level data and Plotly for interactive charts, to highlight traffic stop patterns across demographics, aiming to enhance public awareness of racial disparities


    Skills: #Python #SQL

  • University of Chicago Harris School of Public Policy

    Teaching Assistant - Statistics for Data Analysis, and International Trade
    September 2023 - December 2023

    • Evaluated assignments for 400+ students, provided tailored feedback to enhance comprehension of international trade principles, statistical methodologies, and proficiency in R coding, and impacted over 10% of the student body through dedicated office hours


    Skills: #R

  • Taipei City Government

    Section Assistant - Taipei City Market Administration Office
    November 2020 - August 2022

    • Supervised operation of 3 public markets with a total of 424 stalls, orchestrated strategic modernization planning, involving facility upgrades and promotion of food hygiene practices, and secured prestigious 4-star market award for Shuiyuan Market

    • Mediated government-vendor communication, coordinated meetings with public officials, elected representatives, and private stakeholders, and successfully reignited the Hebin Market reconstruction project after a 6-month standstill

    • Mitigated COVID-19 outbreak by establishing contact tracing system and assisted markets in achieving 98% full vaccination rate


    Skills: #Project Management