Yuting Weng Email & Phone Number

Taipei, Taipei City, Taiwan

• Collaborate with cross-functional teams to develop and optimize data-driven dashboards using Power BI and Tableau
• Streamline ETL processes and data integration from ERP systems and Oracle databases into BI tools, managing data pipelines, refresh schedules, and access controls to ensure efficient, secure reporting

Chicago, Illinois, United States

• (Client: Anti Human-Trafficking Intelligence Initiative)
• Collaborated with the scraping team to identify specific data to be stored for each scraper, and designed and maintained robust MySQL database schema using phpMyAdmin
• 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

Chicago, Illinois, United States

• (Client: Hope Chicago)
• Collaborated with a team of 10 to evaluate summer school scholarship program, providing valuable insights and policy suggestions for program effectiveness and student support strategies
• Performed extensive data cleaning, addressing missing and inconsistent data types and expressions
• Conducted statistical analysis and applied data visualization techniques to investigate correlations between post-summer school questionnaire responses and subsequent academic performance, focusing on academic progress.

Chicago, Illinois, United States

• (Client: WBEZ Chicago)
• 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.

Chicago, Illinois, United States

• (TA for "Statistics for Data Analysis", and "International Trade, Banking and Capital Markets")
• 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.

Taipei, Taipei City, Taiwan

• 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.
• Guided and empowered vendors to enhance operational efficiency, encouraged establishment of electronic businesses, and assisted over 90% of stalls in adopting online payment methods
• Mediated government-vendor communication, coordinated meetings with public officials, elected representatives, and private stakeholders, and successfully reignited the Hebin Market reconstruction project after a.
• Awarded for outstanding contributions in mitigating the COVID-19 outbreak by swiftly establishing robust contact tracing system and assisting markets in achieving a 98% full vaccination rate within a remarkably brief.

Master'S Degree, Public Policy

• Certifications: "Data Analytics" and "Finance and Policy" • Relevant Coursework: a. Statistics for Data Analysis b. Python Programming.

Bachelor Of Arts - Ba, Economics

Coursework include: Macroeconomics, Microeconomics, Statistics and Econometrics, Public Finance, Money and Banking, Corporate Finance.

Bachelor Of Arts - Ba, Foreign Languages And Literatures, General

Coursework include: English Composition (I) & (II), Translation

Exchange, Humanities And Social Sciences