EXPERIENCE

Icon Media Direct | Sherman Oaks, CA

Data Analyst Lead | Feb 2023 - Oct 2024

• Developed data validation & ETL Python code that automated ~15 hours of manual data processing per week
• Resolved data quality issues by writing SQL queries, reducing and proactively preventing report discrepancies
• Built interactive dashboards using Tableau and Power BI, improving stakeholder visibility into KPIs
• Streamlined data integration efforts and ensured a smooth, timely flow of critical data for analysis
• Translated business requirements from client services, media, and traffic teams into effective, scalable solutions

Data Analyst | Apr 2021 - Feb 2023

• Performed meticulous data cleaning and transformation, validating data quality for in-depth analysis
• Implemented real-time KPI monitoring, allowing for rapid identification of campaign trends & optimization
• Managed disparate data from many stakeholders, ensuring accurate data across KPIs & critical business reports
• Updated data documentation and ensured readily accessible and understandable standard operating procedure

National General | Irvine, CA

Plan Maintenance Data Analyst | February 2019 - March 2021

• Identified health and ancillary insurance products’ benefits and rates for a quote comparison tool
• Supported online enrollment processes by developing R code for API validation and JSON data web scraping
• Reviewed team members’ builds for quality assurance and escalated customer support help desk tickets
• Communicated with carriers and development teams to accommodate business rules and project deadlines

SEASONAL & TEMPORARY EXPERIENCE

American Campus Communities | Irvine, CA

Bookkeeper | May 2018 - Oct 2024

• Collected rent for ~1500 residents; handled handled phone, in-person, email, and physical mail correspondence
• Researched unit condition history and processed charges and refunds for biannual apartment turnover sessions

Community Assistant | Jun 2016 - Jun 2018

• Administered customer service for leasing, bookkeeping, residence life, and maintenance departments
• Planned community events independently and in small groups, typically attaining between 15 and 75 attendees

University of California, Irvine Student Housing | Irvine, CA

Community Council President | Aug 2015 - Jun 2016

• Oversaw the planning and marketing of events for a dormitory community of ~1800 first-year residents

Advocacy Committee Chair | Dec 2014 - Jun 2015

• Wrote proposal that secured ~$2200 grant for two permanent bicycle maintenance stations on campus