FlowCV Logo
Profile

Aspiring data analyst/scientist at UNC Chapel Hill with experience in Excel, SQL, Python, and BI tools like Tableau and PowerBI. Skilled in extracting insights to drive decisions and solve complex problems. Passionate about applying data analysis, machine learning, and information systems to challenges in finance, health, and tech.

Education
University of North Carolina at Chapel Hill

Bachelors in Data Science & Information Science

Colonel John H. Robinson Scholar

Aug 2021 – May 2025Chapel Hill, NC
Skills
Programming - Python (Pandas, NumPy, Scikit-learn), SQL, HTML, CSS, JavaScript, JQuery

Tools - Tableau, PowerBI, Excel (advanced functions, pivot table, A/B Testing), MySQL Workbench, VSCode
Language - Chinese(Mandarin and Fuzhounese)
Soft Skills - Data Storytelling, Problem Solving, Time Management, Curiosity, Critical Thinking, Detailed Oriented, Cross Functional Collaboration
Professional Experience
Excel & Tableau Trainee/Intern, Global Career Accelerator: Data Analytics
  • •Streamlined data processing workflows using Excel (pivot tables, advanced functions) and Python to enhance analysis efficiency and identify key performance indicators.
  • •Designed Tableau dashboards to compare energy efficiency recommendations, including renewable energy trends, optimizing sustainable data center locations for Intel.
    • May 2024 – Aug 2024Chapel Hill, NC
  • •Conducted hypothesis testing and statistical analysis, identifying insights that reduced website bounce rates by 10% and increased mobile engagement by 15%.
  • •Delivered actionable visualizations adhering to data storytelling best practices, driving optimization strategies across multiple industries.
    • Assistant Manager, Jin Jin Restaurant
  • •Optimizing POS and CRM systems ensured 100% order accuracy for 50+ transactions per hour.
  • •Boosted customer satisfaction during high-demand periods by optimizing service processes, and efficiently managing 150+ customers per shift to ensure timely and quality service.
    • Jun 2017 – Aug 2021Stantonsburg, NC
  • •Resolved operational challenges using keen attention to detail and problem-solving skills to generate business reports.
    • Projects
    Global Socio-Economic Predictive Analysis, STOR 320
  • •Investigated global socio-economic factors affecting living conditions and export performance to empower policymakers with data-driven insights, enhancing living standards, trade resilience, and economic progress across 190+ countries.
  • •Achieved an R² of 0.85 in predicting living conditions and a mean absolute error (MAE) of <10% for export forecasts, using machine learning models and over 100 global indicators.
    • May 2024 – Aug 2024
  • •Analyzed datasets with 10,000+ records to uncover actionable insights focusing on education, governance, and investment conditions.
    • Portfolio Project, Grammy Website Engagement Analysis
  • •Reduced bounce rates by 10% and increased mobile engagement by 15%.
  • •Analyzed session duration (90–100 secs) and page views (25K+ daily).
    • May 2024 – Aug 2024
    Porfolio Project, Intel Sustainability Dashboard
  • •Created dashboards highlighting NW (41.92%) as a top renewable energy producer.
  • •Recommended data center sites based on regional energy surpluses (Mid Atlantic, July: 82.6M).
    • May 2024 – Aug 2024
    Awards and Certificates
    Recording Academy

    Website Audience Analysis: Delivered data-driven growth strategies using statistical analysis and visualization.

    Intel Project Certification

    Data Analysis for Sustainability Project: Analyzed energy consumption to recommend sustainable data center locations.

    University of North Carolina at Chapel Hill - Data Analytics Certification

    Certified in Data Analytics: Excel (Advanced Functions, PivotTables), Tableau (Data Blending, Dashboards). Completed advanced data analysis projects, leveraging Excel for statistical modeling and Tableau for dynamic dashboards and data storytelling.

    Related Concepts

    Concepts: Data analysis, Excel, SQL, Python, Tableau, data pipelines, V-LOOKUPs, A/B testing, Data Structures, Data Abstraction, Data Modeling, Data Organization, Sorting Algorithms, Searching Algorithms, Big Data, Data Clustering, Machine Learning, Feature Engineering, AI Model Prompting, Database Querying, Data Cleaning and Preparation, Large Language Models, Visualization Tools, Matplotlib, Relational Database, Semantic Modeling, Normalization Techniques, ER Diagrams, Schema Design, Ethical Frameworks, Fairness in AI, Bias Mitigation, Generative AI Applications, Time-Series Analysis