Work

Innovate Analytics Corp.
|

Data Analyst

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.

Global Tech Solutions
|

Junior Data Analyst

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.

Alex Chen

Data Analyst
Los Angeles, US.

Education

University of California, Berkeley
Berkeley, CA, United States of America

Master of Information and Data Science (MIDS)

Data Science

Courses

Statistical Modeling for Data Science

Machine Learning at Scale

Data Visualization and Communication

Research Design and Applications for Data and Analytics

University of California, Los Angeles (UCLA)
Los Angeles, CA, United States of America

Bachelor of Science (B.S.)

Statistics

Grade: 3.8/4.0

Courses

Probability and Statistics

Linear Algebra

Multivariate Analysis

Statistical Computing with R

Database Management Systems

Languages

English
Mandarin

Certificates

Microsoft Certified: Data Analyst Associate

Issued By

Microsoft

Google Data Analytics Professional Certificate

Issued By

Coursera

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.

Projects

E-commerce Sales Performance Dashboard

Summary

Developed a comprehensive interactive dashboard to monitor and analyze e-commerce sales performance, customer segments, and product trends.

Customer Churn Prediction Model

Summary

Developed a machine learning model to predict customer churn for a subscription-based service, aiming to improve retention strategies.