https://ayavtmt2004.github.io/vutam_portfolio/

tông màu


Rachel Truong Tampa, FL | (813) 927-9285 | racheltrbuu.work@gmail.com | LinkedIn Education University of South Florida Tampa, FL B.S. in Artificial Intelligence & Business Analytics — GPA: 3.87/4.00 Expected May 2028 • Relevant Coursework: AI & Analytics for Organizations, Data Analytics, Python for Business, Statistics I, Calculus I & II, Financial Accounting, Principles of Finance, Basic Marketing, Principles of Risk Management • Programming & Analytics: Python, SQL, Java, Pandas, NumPy, Scikit-learn, Statistical Modeling • BI & Data Engineering: Power BI (DAX, Power Query), Tableau, Excel (Pivot Tables, Power Pivot), Azure Data Factory, Apache Airflow, Databricks, PostgreSQL, SQL Server, MySQL • AI & Automation Tools: ChatGPT, Claude, Gemini, Microsoft Copilot, Microsoft Power Automate, Make.com, Zapier, Git, GitHub • Soft Skills & Languages: Analytical Thinking, Problem-Solving, Innovation, Leadership, Data Storytelling, Stakeholder Communication; Vietnamese (Fluent), English (Fluent), Mandarin (Conversational) Experience Ajinomoto Data Analytics Intern May 2026 – Sep 2026 • Applied Chi-square testing (Python, SciPy) to 1,000+ Tonkatsu consumer responses across 4 age groups, identifying 3 significant associations (p < 0.05) to guide targeted product positioning. • Developed ARIMA demand forecasting models using Python (statsmodels) and 12 months of historical sales data to support regional inventory planning within Ajinomoto’s Seasonings & Foods business, which reported 11.9% YoY sales growth in FY2026 Q1. • Modeled demand-based inventory allocation across 10+ regions using SQL and Excel Solver, targeting 12% lower stockout risk through replenishment and distribution optimization. Pizza 4P’s Apr 2025 – Sep 2025 Business & Sustainability Analysis Intern • Built a Databricks/Python/SQL employee feedback pipeline for 500+ staff across 36 locations, standardizing survey data for HR analysis and supporting initiatives that reduced annual turnover by 37%. • Analyzed 4 whey valorization pathways using Python, SQL, and Power BI, optimizing by-product allocation and supporting annual reuse of ˜290K liters in ricotta and 12K liters in signature beverages. • Built a SQL supplier sustainability model and Power BI scorecard across 165 vendors, integrating procurement and audit data to identify sourcing gaps and track 20.45% sustainable sourcing performance. PROJECTS Sales Analytics & Data Pipeline Project | Azure Data Factory, SQL, Power BI, DAX • Built an end-to-end sales analytics pipeline processing 50K+ records from 5+ sources into a centralized SQL warehouse and Power BI reporting layer, reducing manual data preparation by 80%. • Developed 12+ DAX measures across 6+ dimensions and 4 dashboard views, identifying the 2 lowest performing stores for closure and reallocating capital toward 2 new stores in the highest-revenue area. Merry Metrics Data Pipeline | Apache Airflow, Python, Pandas, PostgreSQL, SQL • Built an Apache Airflow ETL pipeline processing 41K+ Christmas sales records into PostgreSQL, using Python/Pandas for validation and preprocessing to reduce manual preparation by 75%. • Architected a 3-layer PostgreSQL warehouse with 12+ tables and 8+ reusable SQL views, identifying peak revenue time blocks to optimize Christmas staffing and sales planning. Leadership Cho Moi Collective Dec 2025 – Present Co-Founder, Data Analytics Department • Designed and analyzed A/B tests on caption length and cover style using Meta Business Suite and Excel, comparing engagement, reach, and click-through KPIs to identify the highest-performing content strategy. • Built an Excel/Power BI engagement dashboard to segment performance by content type and campaign, identifying photography at 60% engagement versus a 40% page average and helping drive 10K+ first-week views and 10–20% monthly audience growth.