TUYEN (HAILEE) TRAN PORTFOLIO

Project Portfolio in PDF

A portfolio consists of work examples of the company's project and personal projects with description and explanation. A PDF of a PowerPoint shared via Dropbox.

Project Portfolio in PDF

Financial Reporting and Analysis with Power BI

Developed a comprehensive financial reporting solution by extracting General Ledger data from an accounting software/ERP system. Leveraged Power BI to perform in-depth data analysis and create dynamic dashboards for financial performance monitoring. Utilized Data Analysis Expressions (DAX) to accurately calculate key financial metrics, including Gross Profit, EBITDA, and Net Profit, providing actionable insights for strategic decision-making.

View Projects on GitHub

SQL PROJECTS

These projects demonstrate proficiency in SQL for various applications, including inventory management, retail sales analysis, solar system data analysis, and a comprehensive Hospital Information Management System (HIMS).

View Projects on GitHub

Hospital Information Management System (HIMS)

Designed and implemented a comprehensive database system using MS SQL for managing hospital data, including patient records (OPD, IPD), Billing, Nursing, Staff, and Administration.

Inventory Management

Utilized SQL for extracting, cleaning, and analyzing data from diverse sources to facilitate efficient inventory management processes.

Retail Sales and Inventory Management

Applied SQL techniques to support retail operations by effectively managing sales data and inventory levels.

Solar System Analysis

Utilized SQL to analyze data related to the solar system, providing insights into various astronomical phenomena.

House Prices Advanced Regression Techniques

Leveraged regression analysis to develop a predictive model for forecasting house prices in the Iowa area. Visualized data correlations with seaborn, aiding investment decisions.

View Project

Tech Industry Mental Health Data Manipulation

Conducted statistical analysis and used Python’s matplotlib to visualize survey data for different genders. Analyzed U.S. mental health issue survey using Python’s Panda and Seaborn.

View Project

C++ Projects

Developed various applications using C++ to enhance my programming skills and understanding of object-oriented design.

View Project

View Project 2

Marketing Dashboard using Tableau

View Dashboard

Monster Energy - Corona, CA

Data Analyst (June 2024 – Present)

• Support forecasting by analyzing volume trends, performance drivers, and anomalies across key accounts.
• Build and maintain Power BI dashboards for 800+ chains to monitor performance and data quality..
• Automate large-scale audits using Python, reducing manual workload by 90% and increasing reporting consistency.
• Write and optimize SQL queries for daily data validation, reconciliation, and ad-hoc analysis.
• Conduct root-cause analysis on volume variances and present findings to stakeholders to prevent recurring discrepancies.
• Communicate with internal teams and external partners to resolve data discrepancies and align reporting across systems.
• Oversee data integrity for 100+ call points, enabling performance tracking and early trend detection.
• Validate 100,000+ store records to ensure accuracy across sales, finance, and merchandising reporting workflows.

GARRETT - Torrance, CA

Project Analyst Intern (Aug 2024 – Jan 2025)

• Reconciled financial data sets using Excel VBA macros, improving data accuracy by 20%.
• Automated ETL pipelines using Python and Power Automate, reducing manual work by 80%.
• Developed SQL queries with query folding, cutting data load time by 40%.
• Built end-to-end Power BI dashboards to track project KPIs and financial variances in real-time.
• Used DAX to create forecast vs. actual reports, improving budget tracking by 30%.
• Collaborated with finance and PMO teams to align KPI reporting and root cause analysis.
• Spearheaded a centralized order tracking automation, reducing communication gaps by 60%.
• Delivered ad-hoc reports to stakeholders to support time-sensitive decision-making.
• Developed slide decks in PowerPoint to document workflows and present findings to cross-functional teams.
• Analyzed financial trends with Python and cost metrics to support budgeting and forecasting accuracy by 30%.

Trung Nguyen Eco - Santa Ana, CA

Business Analyst (Part-time) (Nov 2023 - Nov 2024)

• Audited and reconciled invoice records, reducing payment discrepancies by 99%.
• Forecasted product and purchase trends using Excel modeling with 90%+ accuracy.
• Created Excel-based macros to automate vendor data cleanup and reporting.
• Produced BI dashboards and ad-hoc reports for Sales, Admin, and HR.
• Collaborated with finance to flag and report spending irregularities and vendor risks.
• Worked closely with cross-functional teams to define data standards and improve reporting logic.

The Sourcing Co. - Irvine, CA

Database Admin (Oct 2022 - Aug 2024)

• Forecasted product trends using Excel models with 90%+ accuracy.
• Audited vendor records, eliminating 99% of invoice data errors.
• Generated ad-hoc cost analysis reports for Sales, Admin, and Finance teams.
• Created 10 Tableau dashboards to track purchasing KPIs and flag cost overruns.
• Automated workflows with cross-functional teams, increasing efficiency by 30%.
• Analyzed 3 years of purchase data in Python, boosting customer satisfaction by 15%.

48 Bistro - Brea, CA

Assistant Manager (Jun 2020 - Jun 2022)

• Spearheaded administrative duties focused on enhancing customer service, contributing to a 25% increase in customer satisfaction ratings.
• Managed 10 employees to organize over 20 successful events, boosting the restaurant’s reputation and event-based revenue by 10%.

Hui Lau Shan Food Manufacturing Co Ltd - Westminster, CA

Shift Lead (May 2021 - Jun 2022)

• Led a team of 15 employees, enhancing teamwork and communication which increased production efficiency by 25%.
• Managed multiple tasks simultaneously, ensuring all production goals were met consistently while maintaining high-quality standards.
• Utilized leadership skills to train and mentor new staff, reducing onboarding time by 20% and increasing team productivity by 18%.

Databases and SQL for Data Science with Python

Received: June 2024

View Certificate

IBM Python Project for Data Science

Received: August 2024

View Certificate

Text

This is bold and this is strong. This is italic and this is emphasized. This is ^superscript text and this is _subscript text. This is underlined and this is code: for (;;) { ... }. Finally, this is a link.

Heading Level 2

Heading Level 3

Heading Level 4

Heading Level 5

Heading Level 6

Blockquote

Fringilla nisl. Donec accumsan interdum nisi, quis tincidunt felis sagittis eget tempus euismod. Vestibulum ante ipsum primis in faucibus vestibulum. Blandit adipiscing eu felis iaculis volutpat ac adipiscing accumsan faucibus. Vestibulum ante ipsum primis in faucibus lorem ipsum dolor sit amet nullam adipiscing eu felis.

Preformatted

i = 0;

while (!deck.isInOrder()) {
    print 'Iteration ' + i;
    deck.shuffle();
    i++;
}

print 'It took ' + i + ' iterations to sort the deck.';

Lists

Unordered

• Dolor pulvinar etiam.
• Sagittis adipiscing.
• Felis enim feugiat.

Alternate

• Dolor pulvinar etiam.
• Sagittis adipiscing.
• Felis enim feugiat.

Ordered

1. Dolor pulvinar etiam.
2. Etiam vel felis viverra.
3. Felis enim feugiat.
4. Dolor pulvinar etiam.
5. Etiam vel felis lorem.
6. Felis enim et feugiat.

Icons

• Twitter
• Facebook
• Instagram
• Github

Actions

• Default
• Default

• Default
• Default

Table

Default

Alternate

Buttons

• Primary
• Default

• Default
• Small

• Icon
• Icon

• Disabled
• Disabled

Form