L

Leila Xu

About

Detail

Data Scientist | University of Chicago Capstone at HERE Technologies
Chicago, Illinois, United States

Timeline


work
Job
school
Education
flag
Award

Résumé


Jobs verified_user 0% verified
  • Voya Financial
    Data Engineer
    Voya Financial
    Jun 2025 - Current (1 year 2 months)
    - Automated headcount analytics by migrating multi-step Excel/Power Query workflows into Microsoft Fabric (PySpark), producing month-over-month change classifications (Joiner, Leaver, Transfer, Reclass) across ~20K+ employees and improving HR/Finance reporting accuracy by eliminating 95% of manual reconciliation. - Engineered 3 Fabric Lakehouse pipelines ingesting data from SharePoint Gen2 and other sources, creating 6 unified, clean output tables that cut data preparation time by 30% and enabled faster reporting across Travel & Entertainment (TE) and Headcount initiatives. - Designed semantic models using DAX and developed Power BI dashboards for TE spend and revenue/expense alignment, supporting executive planning and quarterly forecast
  • HERE Technologies
    Data Scientist | University of Chicago Capstone
    HERE Technologies
    Mar 2025 - Current (1 year 5 months)
    - Parsed and normalized multi-source geospatial data (Places, Cartography, and Road Network in GeoJSON format), enriching POI records with accessibility flags and trajectory-aware features. - Designed and deployed a scalable framework for discovering parent-child POI hierarchies, supporting future use in context-aware routing, trip planning, and location personalization. - Built a modular geospatial data pipeline to identify implicit relationships between POIs using semantic similarity, spatial clustering, and road network constraints. - Integrated Large Language Models (LLMs) and custom rule-based logic to mimic human reasoning around functional groupings (e.g., university facilities, truck stops, museum campuses). - Conducted social i
  • Delta Air Lines
    Data Engineer
    Delta Air Lines
    Nov 2021 - Feb 2024 (2 years 4 months)
    - Actively supported and maintained activities in Skywise such as identifying and fixing ingestions or pipeline failures with SQL or Python within the day of the failure to minimize business impacts. - Uploaded over 900 on-premises datasets into Skywise through in-app SQL transcript following traditional ETL process to provide data such as part tracking numbers for field engineers and part-cost data for the finance team. - Researched JDBC and Teradata data sources, and previous OMS file transformations to improve the process flow that brings flat files to Skywise to reduce data latency to near real-time. - Mastered and used in-app pipeline builder and data lineage tool to build pipelines to clean and process thousands of raw datasets across
  • Chowbus
    Business Analyst & Operation Manager
    Chowbus
    Sep 2019 - Oct 2021 (2 years 2 months)
    - Launched the Chowbus delivery services in Minneapolis in 2019, a food delivery business/app designed and founded in Chicago and designed Chowbus POS machine in 2021 after a full-course SWOT analysis. - Documented feedback on test operating POS machines from users in Excel, created CSAT Score Survey Chart in Tableau, and communicated product analysis results, such as defects, back to product designers for product improvement. - Analyzed quarterly customer data such as average order placement and satisfaction rate using R, successfully precast business trends and customer preferences with Time Series Analysis to identify new markets and target audience groups. - Improved local gross margin to $3.65 from below break-even point and continued
  • Hyde Park Alpha
    Investment Consulting Analyst
    Hyde Park Alpha
    Jul 2019 - Aug 2019 (2 months)
    - Completed comprehensive equity research for two mid-cap and three small-cap companies for targeting the potential acquisition in the industries of technology, media, and healthcare. - Retrieved data from Quandl and other databases using Python to complete economic data visualization and linear regressions for sell-side firms. - Performed a complete correlation analysis independently using RStudio to find the correlation between market cap and other fundamental variables for three small-cap healthcare companies.
  • G
    English Proficiency Tests Supervisor & Oral Communication Lecturer
    Global Education Technology CoLtd
    Jun 2018 - Aug 2018 (3 months)
    - Enhanced student and parent communication to create positive relationships at a private educational institution chain in China which has more than 292 schools. - Administered practice proficiency tests and answered questions to ensure academic compliance. - Provided coaching, test preparation, and advice to students in order to improve their performance on the English Proficiency test. - Taught a class of 14 high school graduates with passion, and built their interests and created positive learning attitudes.
  • C
    Relationship Cooperator & Lecturer
    Carey English
    Jun 2017 - Aug 2017 (3 months)
    - Reached out to 4 new families and built a long-term relationship. - Encouraged 6 new students to embrace a new culture. - Communicated with parents and children to cultivate trust and a positive perspective on multi-culture.
Education verified_user 0% verified
  • University of Chicago
    Master of Science - MS, Applied Data Science
    University of Chicago
    Jan 2024 - Dec 2025 (2 years)
  • University of Minnesota  Carlson School of Management
    Bachelor of Science in Business - BSB, Management Information System
    University of Minnesota Carlson School of Management
    Jan 2018 - Dec 2020 (3 years)
    COURSES: Data Analysis & Modeling | Enterprise System | Data Engineering | Interactive Data Vis for Bus Anyl | Descrip & Predict Analytics | Analytical Tools | Business Strategy & Statistic Analytics | Financial Modeling | Accounting | Financial Accounting | Supply Chain Management | Marketing| Psychology
  • University of WisconsinStevens Point
    Bachelor of Science in Business and Bachelor of Science in Liberal Science, Finance, General
    University of WisconsinStevens Point
    Jan 2016 - Dec 2018 (3 years)
Awards verified_user 0% verified
  • C
    Certificate of Achievement of Highest Honors
    Jan 2018
  • D
    Dean’s Distinguished Achievement Award
    Jan 2017
  • G
    Global Recruitment Scholarship
    Jan 2016