Post Job Free
Sign in

Data Analyst / Business Analyst / Coordinator

Location:
Chicago, IL
Salary:
Negotiable
Posted:
May 30, 2025

Contact this candidate

Resume:

Liling (Lilyann) Shen

Chicago, Illinois 773-***-**** ************@*****.*** LinkedIn Willing to relocate nationwide EDUCATION

University of Chicago Chicago, IL

Master of Public Policy (STEM), Data Analytics Track, with Honors GPA: 3.9 Expected: Jun 2025 Relevant Coursework: Financial Accounting, Marketing, Python Programming, Statistics, Microeconomics, Analytical Politics Zhejiang University Hangzhou, CHN

Bachelor of Law, minor in Finance, with Honors GPA: 3.9 Jul 2023 Relevant Coursework: Finance, Python Programming, Statistics, Advanced Mathematics, Commercialand Corporation Law TECHNICAL SKILLS

Data Analysis & Modeling: Python (pandas, scikit-learn, NumPy, matplotlib), R (tidyverse, ggplot2, statsmodels, caret), SQL Viusalization & Tools: Tableau, Power BI, MS Excel, LaTeX, D3, ArcGIS, HTML/CSS, MongoDB, Photoshop Business Analysis: Market Research, Predictive Analytics, Financial Modeling, Strategic Reporting, Stakeholder Communication Software & Collaboration: Azure, Outlook, Google Suite, JavaScript, Canva, MS Word, MS Powerpoint, Asana PROFESSIONAL EXPERIENCE

Global AI New York, NY

Data Analyst Intern, Data Science Team Feb 2025 - Apr 2025

• Spearheaded preprocessing and modeling of 5.6M-row, 95-variable financial sentiment dataset, designing scalable ETL pipelines and applying imputation (e.g. EWMA, sector-level smoothing) to cut sparsity by 82%; enabled deployment of high- quality datasets that enhanced ML model training speed by 35% and reduced sparsity-related errors across business analytics

• Collaborated with senior analysts and stakeholders to deliver data-driven reports with visualizations and modeling trade-off evaluations, achieving an 82% improvement in accuracy and enabling more precise sector-level ESG risk assessments

• Developed comparative time series forecasting using supervised ML models (Random Forest, SVM, Gradient Boosting), boosting forecast accuracy by 21% via dimensionality reduction and rolling window validation

• Engineered robust, reusable scrapers to extract and normalize structured compliance data from deeply nested federal web portals, enabling risk analytics teams to develop compliance monitoring models and enhance regulatory reporting accuracy Harris School of Public Policy Chicago, IL

Teaching Assistant, Student Curricular Support Team Sep 2024 - Mar 2025

• Delivered academic and logistical support for 3 core courses (500+ students each), including statistics and microeconomics

• Facilitated in-person and Zoom-based instruction support, including proctoring, review sessions, monthly office hours, and daily Ed Discussion responses to ensure timely, personalized, and accessible student engagement across platforms

• Identified common student concerns across sections, proposed clarifications to instructors, and analyzed engagement trends via Canvas and Ed Discussion to inform weekly team meetings and adjust instruction pacing based on real-time needs

• Collaborated closely with faculty and fellow TAs to streamline instructional delivery and provide proactive, solutions- oriented support across grading tasks and content; received 100% positive student feedback in end-of-course evaluations World Bank DIME & Harris Policy Lab Chicago, IL

Research Assistant, Uganda Childcare Impact Project Sep 2024 - Dec 2024

• Conducted attrition analysis on 26 variables using Lee Bounds & robustness checks to minimize selection bias

• Designed and implemented fixed-effects and ANCOVA models in RStudio to quantify the causal impact of childcare support on 8 economic indicators; incorporated employment-based heterogeneity into analysis

• Standardized results across 15 key models, and generated 12 visualizations, including Forest Plots and Time Series Plots, to enhance analytical clarity and interpretability. Designed and implemented a data pipeline

• Built reproducible data pipeline and standardized outputs from 15 models; visualized key results with forest and time series plots, and authored well-formatted analytical reports using LaTeX, enhancing clarity for stakeholders East West Alliance for Education and Health Seattle, WA Program Coordinator, Applied Math for Global Health Education Program Jul 2024 - Sep 2024

• Matched 30+ mentor-mentee pairs across time zones and streamlined communications using Google Suite and spreadsheets

• Co-authored the grant proposal and created professional pitch decks for TAL Education Group to explore China expansion

• Supported program operations by managing timelines, documenting workflows, and analyzing participation data; generated reports and presented insights that informed standardized enrollment and contributed to a 60% planned program scale-up

• Designed and standardized 200+ mentor scripts, student templates, session formats, and promotional materials to enhance professionalism; fostered a multicultural mentor-student-parent community via Microsoft Teams and Google Workspace Global Health Research Group – University of Washington Seattle, WA Research Assistant, Malawi Ultrasound Functionality Project Jun 2024 - Aug 2024

• Built robust data preprocessing pipeline in R, effectively reducing data missingness rate by 70%

• Applied logistic regression to identify drivers of ultrasound functionality across 1052 healthcare facilities

• Used ggplot2 and Power BI to visualize policy insights, generating eight visualizations (e.g., choropleth maps, heatmaps) that revealed system-level bottlenecks and guided cross-functional healthcare improvement strategies

• Collaborated with principal investigators, writing specialists, and research assistants to align analysis with project goals, ensure data reliability, and communicate results clearly in team meetings and written summaries for seminar participants IQVIA Shanghai, CHN

Consulting Intern, Management Team May 2023 - Jul 2023

• Predicted probability of product approval and launch rates, and evaluated competitive products using time-to-approval estimation models and competitive landscape analysis frameworks to inform strategic planning and portfolio optimization

• Produced 40+ client-facing PowerPoint deliverables synthesizing pipeline tracking, competitive intelligence, and market dynamics, and briefed project leadership to align strategic reports with client priorities and evolving market dynamics

• Maintained and optimized a clinical trial database covering 110+ diseases for products in development within five years

• Structured and analyzed datasets encompassing 290K+ data points via SQL to enable data-driven market research Fengqiao Digital Law Lab Hangzhou, CHN

Research Assistant, Data Analysis Team Jan 2023 – Jun 2023

• Developed a searchable digital database of legal documents using Python to facilitate public access to judicial information

• Engineered 67 quantitative indicators from surveys and interviews to evaluate legal awareness levels

• Applied classification models in Python to analyze user interests and optimize content, boosting satisfaction by 72%

• Visualized analytical results using Seaborn and Tableau to support targeted content strategy improvements AllBright Law Offices Hangzhou, CHN

Legal Compliance Intern, Capital Markets (IPO) Team Apr 2022 – Aug 2022

• Created comprehensive equity structure charts to visualize shareholder relationships and ownership distribution

• Conducted due diligence on 20+ suppliers and distributors, identifying potential regulatory risks across the supply chain

• Analyzed and cross-verified large volumes of bank transaction data to identify anomalies, using advanced Excel functions

(PivotTables, VLOOKUP, Conditional Formatting); synthesized findings into clear dashboards for compliance reporting

• Actively coordinated with accountants, underwriters, and corporate executives to facilitate document collection, clarify compliance requirements, and ensure smooth cross-functional collaboration during the IPO process



Contact this candidate