Trinity Ortiz Email & Phone Number

San Diego, Ca, Us

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 87.5%. • 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 on-campus lab supplies provider, Core Bio Services, ensuring accurate invoicing based on PO information.• 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 techniques.• 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 communication skills while empowering colleagues to leverage data effectively.• 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 adjustments.