Ann Nguyen
Data Analyst
With 2 years of experience on a large-scale Vietnam–Japan project at Hitachi, Ltd., I transitioned into data analytics—combining a strong math foundation with business insight and data tools to solve real problems.
Who I Am
About Me
I'm a Data Analyst with a strong foundation in mathematics and a background in business administration, supported by post-baccalaureate coursework from Dallas College. I specialize in using SQL, Python, and Excel to analyze data, identify trends, and generate actionable insights.
My work includes customer analytics, cohort retention analysis, and RFM segmentation—helping businesses understand user behavior, evaluate performance, and make data-driven decisions.
I don't just analyze numbers—I focus on the "why," translating complex data into clear, practical insights that help stakeholders answer questions and make better decisions.
Core Skills
SQL & Databases
CTEs, window functions, MySQL, PostgreSQL
Python Tools
Pandas, NumPy, Matplotlib, Seaborn
Analysis
Cohort, RFM, KPI tracking, trend analysis
BI Tools
Excel (advanced formulas, PivotTables, DAX), Power BI
Background
Education
Hoa Sen University
Bachelor of Management
2016 – 2021
Dallas College
Post-Baccalaureate Coursework (Graduate Prerequisites)
GPA: 4.02024 – 2026
University of North Texas
Graduate Certificate
Expected 2027
Academic Honors
Mu Alpha Theta Honor Society
Recognized for academic excellence and collaboration in Math.
Senior Vice Provost's Recognition
In acknowledgment of outstanding academic achievements.
Career
Work Experience
Project Administrative
Hitachi, Ltd. · Urban Railway Line 1 Project Office
- ›Delivered 100% on-time reports to stakeholders by tracking project progress, coordinating weekly team meetings, and supporting structured status updates.
- ›Maintained Excel-based tracking reports by consolidating project data, ensuring accuracy, and producing weekly and monthly documentation for cross-department communication.
Guest Experience Expert
The Westin Las Colinas
- ›Performed accurate data entry and documentation, ensuring integrity in registration.
- ›Managed cross-team coordination to support events and administrative tasks, ensuring smooth operations.
Math Tutor
Girl Discovery Math Club
- ›Supported first-year college students, especially Latinx and first-generation students, by providing tutoring in Math, including College Algebra, Statistics, and Calculus.
Work
Featured Projects
SQL & Excel
Electricity Payment Performance & Customer Analytics
Evaluated promotion effectiveness for electricity bill payments using advanced SQL (CTEs, window functions, aggregations) and Excel PivotTables to uncover monthly trends and promotion impact.
Generated customer insights through cohort retention analysis and RFM segmentation to assess acquisition quality and identify high-value users.
Python
Movie Ticket Sales & Customer Insights
Analyzed and visualized movie ticket data using Pandas and Matplotlib to identify outliers, distributions, and customer segments—highlighting heavy purchasers and promotion-only users.
Answered business questions around transaction success rates, promotion-dependent behavior, and one-time promotion users.
Excel
Retail Store Sale Analysis with Excel
Conducted end-to-end sales data analysis by cleaning, processing, and validating raw data, then applying PivotTables, KPI calculations, and DAX measures.
Built an interactive dashboard to visualize key sales metrics and insights, enabling clear reporting and data-driven decision-making.