Ian Luna
Data Analyst
La Mirada,CA
Summary
Enthusiastic and persistent data analyst experienced working in direct response advertising. Proficient in advertising strategy; campaign performance and data analysis; excellent and diplomatic communication skills; extensive non-profit experience; and a hardworking team player with a strong work ethic. Experienced in Radio, TV, and Digital in many industries including Healthcare, Education, Financial and more!
Overview
6
6
years of post-secondary education
9
9
years of professional experience
Work History
Media Data Analyst
Converze Media
Huntington Beach, CA
02.2019 - Current
- Performed data analysis and verification of data to improve campaigns and marketing efficiency.
- Developed and performed programming solutions for workflow, data analysis, SQL querying, and ad-hoc reporting.
- Utilized Google Analytics, LeadsRX, TVSquared, and Tablueau for dashboarding, attribution modeling, performance tracking, and reporting.
- Coordinate with account managers and clients in achieving marketing efficiency through CPMs/CPCs for over 30 clients.
- Generates regular reports to identify and present trends and quantitative data to management.
Financial Coordinator
Filipino Cultural School
Norwalk, CA
08.2013 - 08.2018
- Helped organization apply and secure 501(c)(3), non-profit status in the State of California.
- Slashed administration costs and expenses by 20% by negotiating pricing and fees while securing donations from the community.
- Launched multiple online, crowdfunding campaigns and fundraisers to raise over $10,000 in funding.
- Maximized revenue through increased registration fees and other streams of revenue, while increasing annual profit by 2-5% every year.
- Managed budgets, assets, portfolios, accounts payable and receivable and general financial reporting procedures.
Data Processing Coordinator
Select Data, Inc.
Anaheim, CA
09.2016 - 01.2018
- Collaborated with clinicians and medical coders in processing over 14,000 records a year and increased productivity by 44% in first year.
- Aggregated and collated medical documentation for coding in accordance with HIPAA.
- Maintained data entry requirements by following data program techniques and procedures.
- Reviewed, corrected, deleted and re-entered data to eliminate duplication of data and maintain data integrity.
Education
Bachelor of Science - Management Information Systems
California State University, Long Beach
Long Beach, CA 08.2016 - 08.2019
Certification - Non-Profit/Organizational Management
Gianneschi Summer School For Nonprofits Conference
Fullerton, CA 06.2017 - 08.2017
Associate of Science - Business Administration
Cypress College
Cypress, CA 08.2013 - 08.2016
Skills
Data Analytics, Google Analytics, Dashboards, TVSquared, and LeadsRX
Media Campaign Strategy and Optimization
Excel, V/XLOOKUP, Pivot Tables, Macros, and VBA Scripting
Outlook, Visio, Access Database, Powerpoint, and Visual Studio
SQL, MySQL, and SQLPlus
Python, JavaScript, Angular, Bootstrap, HTML, and CSS
Timeline
Media Data Analyst
Converze Media
02.2019 - Current
Certification - Non-Profit/Organizational Management
Gianneschi Summer School For Nonprofits Conference
06.2017 - 08.2017
Data Processing Coordinator
Select Data, Inc.
09.2016 - 01.2018
Bachelor of Science - Management Information Systems
California State University, Long Beach
08.2016 - 08.2019
Financial Coordinator
Filipino Cultural School
08.2013 - 08.2018
Associate of Science - Business Administration
Cypress College
08.2013 - 08.2016