Work
Los Angeles, CA, US
→
Summary
Analyzed complex datasets to identify key trends and provide actionable insights, supporting business intelligence and strategic decision-making across various departments.
Highlights
Developed and maintained SQL queries and Python scripts to extract, transform, and load (ETL) data from disparate sources, reducing manual data preparation time by 25%.
Created interactive dashboards using Tableau and Power BI, visualizing key performance indicators (KPIs) that enabled stakeholders to monitor progress and identify opportunities, leading to a 15% improvement in reporting efficiency.
Performed statistical analysis on customer behavior data, identifying segments with high churn risk and contributing to a targeted retention strategy that reduced customer attrition by 10%.
Collaborated with product and marketing teams to define data requirements and implement tracking mechanisms for new features, improving data accuracy by 20% for campaign performance metrics.
Automated weekly reporting processes using Python and Excel, saving approximately 8 hours per week for the business operations team and ensuring timely access to critical business insights.
San Francisco, CA, US
→
Summary
Supported senior analysts in data collection, cleaning, and preliminary analysis, contributing to various reporting and insight generation projects.
Highlights
Assisted in cleaning and validating large datasets using SQL and Excel, ensuring data integrity for critical business reports and reducing data error rates by 18%.
Generated ad-hoc reports and presentations for internal stakeholders, providing data-backed answers to specific business questions and facilitating informed discussions.
Contributed to the development of a new data dictionary, standardizing definitions for key metrics across the organization and improving data literacy among non-technical teams.
Participated in A/B testing analysis for website optimizations, helping to identify changes that increased user engagement by 7% on key landing pages.
Learned and applied basic machine learning concepts to assist in predictive modeling projects, enhancing understanding of future trends and potential business impacts.
About
Highly analytical and results-driven Data Analyst with 3+ years of experience transforming complex datasets into actionable insights to drive strategic business decisions. Proficient in SQL, Python, R, and advanced Excel, specializing in data modeling, statistical analysis, and compelling data visualization. Eager to leverage strong problem-solving skills and a passion for data-driven optimization to contribute to innovative projects and achieve organizational goals in a dynamic environment.
Education
Languages
English
Mandarin
Skills
Programming Languages
Python (Pandas, NumPy, SciPy, Scikit-learn), R (ggplot2, dplyr), SQL (PostgreSQL, MySQL, MS SQL Server).
Data Visualization
Tableau, Power BI, Matplotlib, Seaborn, Plotly, Looker.
Database Management
SQL, NoSQL (MongoDB), Data Warehousing, ETL, Database Design.
Statistical Analysis
Hypothesis Testing, Regression Analysis, A/B Testing, Predictive Modeling, Descriptive Statistics.
Tools & Platforms
Microsoft Excel (Advanced), Google Sheets, Jupyter Notebooks, Git, Cloud Platforms (AWS S3, Google Cloud BigQuery), Microsoft Office Suite.
Business Intelligence
KPI Development, Dashboarding, Reporting, Market Research, Data Storytelling, Requirements Gathering.
Soft Skills
Problem-Solving, Critical Thinking, Communication, Collaboration, Attention to Detail, Adaptability.