Lucia Zhanchu Quan

Pittsburgh, PA • ad3r24@r.postjobfree.com • 412-***-**** • LinkedIn

EDUCATION

CARNEGIE MELLON UNIVERSITY United States

Master of Information Systems Management (GPA: 3.33/4.00) Expected Dec 2024 Coursework: Data Science and Big Data, Machine Learning, Database Management (SQL), Data Focused Python, Object Oriented Programming – Java GEORGIA INSTITUTE OF TECHNOLOGY United States

Bachelor of Science in Quantitative Economics and Econometrics (GPA: 3.75/4.00, Highest Honors) Aug 2020 – May 2023 Coursework: Advanced Microeconomics, Advanced Macroeconomics, Econometric Analysis, Money and Capital Markets, Industrial Organization, Economics of Strategy and Information, Marketing Management, Calculus, Linear Algebra, Statistics, Computing (C++, Python, HTML) PENNSYLVANIA STATE UNIVERSITY United States

Studied Statistics (GPA: 3.97/4.00) Aug 2018 – May 2020 SKILLS/PUBLICATIONS

Skills: Python(Pandas, NumPy, BeautifulSoup, and Scrapy), SQL(CTE, Window Function), EDA, ETL, Linear / Logistics Regression, decision tree modeling; Data visualizations with Tableau, Power BI, and Excel VBA Publications: The Analysis of the Effect of Women's Employment Rate on Fertility Across States in United States, 2022 Languages: English, Mandarin, Cantonese

PROFESSIONAL EXPERIENCES

SEEKING RETURNS China

Data Analyst Intern Jan 2022 – May 2022

● Utilized Python to accurately compile and maintain an extensive database of over 2,500 university degree programs, enhancing company's educational market data resources. Analyzed and presented data on past 10-year trends of international student populations in China, providing quantitative insights for market forecasting and competitive benchmarking.

● Improved data processing efficiency by 15% through implementation of streamlined data cleaning and transposition techniques.

● Produced detailed analytical reports, incorporating data visualization tools to depict user growth and market share predictions, influencing strategic marketing decisions.

E-commerce Analyst Intern

● Conducted comparative analytics between Shopee and Amazon to predict product demand and meticulously examine customer reviews for quality feedback. Employed Python and SQL to analyze customer purchase data and market trends, identifying over 50 prospective bestsellers for Shopee marketplace.

● Developed financial models to estimate initial investment, purchase costs, logistics expenses, and payment cycles, contributing to a cost-efficient procurement strategy and better cash flow management.

● Supporting digital marketing campaigns creation by analyzing performance data from similar past campaigns, helping to optimize advertising spend and targeting strategies.

GLOBAL ETRADE SERVICES (GeTS) Singapore

Business Analyst Intern/ Fintech Aug 2021 – Dec 2021

● Managed and streamlined 12 credit lending cases by applying machine learning models for credit scoring and risk assessment, enhancing accuracy based on companies' financial data.

● Utilized predictive modeling to inform loan amount and duration decisions, contributing to a more efficient loan approval process and a higher repayment rate.

● Conducted a thorough analysis of loan approval workflow, identified bottlenecks, and recommended improvements, resulting in a 15% increase in operational efficiency.

HEWLETT-PACKARD (HP) TECH VENTURES United States

Business Analyst Extern/ Venture Capital Dec 2020 – Feb 2021

● Conducted in-depth market research on over 2,000+ companies, utilizing 31 metrics to guide strategic focus towards viable investment opportunities in virtual reality sector.

● Applied analytics using Excel and SQL to derive product differentiation and strategies, sourcing 50 startups that met HP’s stringent investment criteria.

● Distilled insights from complex data using Tableau visualizations, contributing to an investment deck that successfully influenced managing partner’s due diligence decisions.

PROJECTS

Anti-Fraud App Prototype Development Sep 2023 – Oct 2023

● Designed an anti-fraud app prototype featuring five key functions tailored to user needs identified from market research.

● Led "Discover Your Cluster" feature, handling data collection, cleaning, and clustering analysis to deliver personalized fraud risk assessments.

● Collaborated on integrating a Random Forest model, achieving 80% accuracy with over 80K training data points for scam prediction, coupled with a Multinomial Naïve Bayes for email scam detection and an API for real-time fraudulent phone number updates.

● Contributed to data-driven visualizations and robust testing of models to ensure prototype's reliability before stakeholder demonstrations. Marriott Booking Cancellation Prediction June 2023 – July 2023

● Analyzed Marriott's hotel booking data with 31 features, utilizing CatBoost and XGBoost to predict cancellation patterns with high precision. Achieved accuracy of 99.61% in CatBoost model, significantly enhancing predictive capabilities.

● Cleansed and preprocessed dataset systematically and addressed missing values and outliers, ensuring reliability of predictive models. Employed feature engineering to incorporate variables (e.g. hotel type, customer demographics, etc), improving model performance and predictive accuracy.

● Ledge to actionable insights that informed strategic decisions, resulting in improved guest satisfaction and operational efficiency at Marriott hotels. Iowa Real Estate Pricing Prediction May 2023 – June 2023

● Leveraged feature engineering methods on high-dimensional dataset with 79 variables to improve prediction accuracy of residential home prices.

● Built Machine Learning models, including Random Forest and Gradient Boosting, refining performance through advanced hyperparameter tuning

(random search, grid search, and cross-validation).

● Optimized preprocessing and management of complex, high-dimensional data using Python (Pandas, NumPy) and SQL, ensuring seamless integration for machine learning applications.

● Delivered data-driven insights in dynamic, results-oriented environment, demonstrating proficiency in analytical problem solving and project execution.

Contact this candidate