
Emily Liao
@emilyliao
I build practical AI and data solutions that turn complex workflows into measurable efficiency gains.
What I'm looking for
I've built AI-driven workflow solutions across Cathay Century Insurance, National Chengchi University, and IBM. At Cathay, I developed an end-to-end RAG system for insurance claim summaries that reduced report-writing time from over 60 minutes to under 10.
At IBM, I migrated schemas across 33 tables and built a Python test auto-generator that cut verification time by about 10 minutes per table. I'm currently a Surface PM Intern at Microsoft and a fourth-year National Chengchi University student focused on data analytics, applied AI, and international business.
Experience
Work history, roles, and key accomplishments
Worked as Surface PM Intern at 微軟公司.
* Migrated legacy schemas to target models across 33 tables; enforced keys, constraints, and referential integrity for downstream compatibility.
* Translated business rules into optimized SQL for repeatable transformations on raw, time‑series transactional data.
* Ran versioned SQL transformations on the team’s data platform with change‑tracking and backtest validation for reproducible, auditable
* Developed an automatic journalism system using multi-agent collaboration and Retrieval-Augmented Generation (RAG) to generate ESG-related articles from both structured and unstructured company data, reducing production time from 3 hours to just 3 minutes and significantly boosting content generation efficiency.
* Designed prompt-based pipelines with prompt engineering to guide LLM behavior, inc
* Designed and built an end-to-end AI system to generate insurance claim summaries, covering data preprocessing, Retrieval-Augmented Generation (RAG), prompt engineering, and both human and automated evaluation. The solution reduced report writing time from over 60 minutes to under 10, significantly improving operational efficiency.
* Translated business problems into AI-driven solutions using la
* During my internship at Transcosmos, I supported the e-commerce marketing team by recruiting and coordinating with over 17 group-buying KOLs through persuasive email outreach and form-driven onboarding strategies.
* I conducted influencer research using KOL Radar, analyzed audience data, and facilitated proposals and contract execution with several food brands. I managed backend tasks on Shopli
Worked as Research Assistant at SAGES Advisory Inc..
Education
Degrees, certifications, and relevant coursework
National Chengchi University
學士, International College of Innovation
2022 - 2027
Double Major in Bachelor Program in Applied Artificial Intelligence, Minor in International Business
McKinsey & Company
2025 McKinsey Next Generation Women Leader
Issued May 2025
Microsoft
Data Analysis and Visualization with Power BI
Issued Apr 2025
Introduction to Generative AI
Issued May 2025
Microsoft
Harnessing the Power of Data with Power BI
Issued Apr 2025
Microsoft
Data Modeling in Power BI
Issued Apr 2025
University of California, Davis
SQL for Data Science Capstone Project
Issued Apr 2025
Microsoft
Extract, Transform and Load Data in Power BI
Issued Apr 2025
University of California, Davis
SQL for Data Science
Issued Apr 2025
Microsoft
Preparing Data for Analysis with Microsoft Excel
Issued Apr 2025
University of California, Davis
SQL Problem Solving
Issued Apr 2025
Taipei First Girls High School
High School Diploma, 普通班
2019 - 2022
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Salary expectations
Social media
Job categories
Skills
Interested in hiring Emily?
You can contact Emily and 90k+ other talented remote workers on Himalayas.
Message EmilyGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
