Trinity Ortiz Email & Phone Number

San Diego, CA, US

La Jolla, California, United States

• Developed an Oracle BI Publisher report and data model using SQL (case statements, joins, CTEs, ranking) to summarize workflow details and detect fraudulent approvals for 8000+ invoices, reducing invoice audit time by.
• Crafted a complex SQL query joining 9+ tables, searching over 10 million records, and utilizing CTEs and subqueries to efficiently summarize invoices linked to purchase orders from the last fiscal year for the.
• Designed and implemented 5 interactive Tableau dashboards, including RFM and market share analyses, delivering actionable insights on customer trends, sales performance, and top customer segmentation.
• Created a Python script utilizing Pandas, NumPy, and the FuzzyWuzzy library to standardize 1,000+ records for customer departments, enhancing data quality and consistency through effective data wrangling and cleaning.
• Facilitated an organization-wide workshop for 52 participants on extracting insights from data visualizations, drawing on insights gained from interviewing 6 team managers, showcasing strong presentation and.
• Awarded the 2024 STAR Award for outstanding efforts in Work Success, recognized by senior leadership for exceptional contributions to the Vice Chancellor-CFO and the University.

• Recipient of the 2023 Grace Hopper Scholarship
• Successfully launched and led the first WIC DEI committee, recruiting and assembling a dedicated team of 16 WIC members committed to promoting diversity, equity, and inclusion.
• Led and orchestrated biweekly WIC DEI committee meetings, securing meeting rooms, monitoring attendance, and facilitating insightful discussions.

San Diego

• Trained 4 new baristas with positive reinforcement and respectful, encouraging coaching.

• Accurately managed cash flow operations in a drive-through setting, totaling $1,000 to $3,000 per shift.
• Delivered exceptional customer service to an average 250+ customers per day by prioritizing customer needsand fostering connections with each customer.

• Trained beginner through advanced-level classes of up to 55 students ages 3-65 on 20+ self-defense sequences and 50+ kicking, blocking, and striking techniques by varying vocal style, mirroring movements, and hands-on.