WORK EXPERIENCE
Icon Media Direct | Van Nuys, CA
Data Management Analyst Lead | February 2023 - October 2024
Data Management Analyst | April 2021 - February 2023
Developed ETL (Extract, Transform, Load) scripts in Python to reduce daily data processing time by two hours
Tracked thousands of television and digital media advertising metrics including calls, leads, and purchases
Cleaned, validated, and analyzed advertisement airing and response data using SQL, Excel, and Google Sheets
Managed data-related help desk tickets to support daily client services and media pipelines
Processed disparate data from a variety of stakeholders and vendors, including writing Python scripts to access data from REST APIs and GA4 (Google Analytics 4)
Worked with data science team using SAS and Python models to build KPIs and optimize media spend
National General | Irvine, CA
Data Coordinator | February 2019 - March 2021
Built rates, plans, and benefits for health insurance products, including small group, individual and family, short-term health, accident, critical illness and Medicare Supplement plans
Wrote R code to scrape JSON data from carriers’ web services and validated APIs to assist online enrollment
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
EDUCATION
Unversity of California, Irvine | Irvine, CA
B.A. Economics and Political Science
Relevant coursework: statistics, econometrics, economic history; development, education, health, and public economics
SKILLS
Languages: Python, R, SQL
Tableau, Excel (complex formulas, pivot tables), Google Sheets, Snowflake, BigQuery, Power BI, Jira, Zendesk, Salesforce
ETL (extract, transform, load), data cleaning, data visualization, regex (regular expressions), EDA (exploratory data analysis), analyzing disparate data sources, REST APIs, QA (quality assurance), database administration, customer service
OTHER WORK EXPERIENCE
American Campus Communities | Irvine, CA
Bookkeeper (temporary full-time) | May 2018 - October 2018
Community Assistant (temporary part-time) | June 2016 - June 2018
Collected monthly rent payments for approximately 1,480 student residents; handled phone, in-person, email, and physical mail bookkeeping-related correspondence with recurring deadlines and on an ad-hoc basis
Researched unit condition history and processed charges and refunds for apartment turnover sessions
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 (temporary part-time) | August 2015 - June 2016
Led a team of six executive board members in promoting campus leadership and freshmen mentorship
Oversaw event planning and marketing in a community with approximately 1,800 first-year residents
University of California, Irvine Government of Undergraduate Student Housing | Irvine, CA
Advocacy Committee Chair (temporary volunteer) | December 2014 - June 2015
Composed proposal that secured $2,192 grant for two permanent bicycle maintenance stations on campus