Erik Pineda
Irvine,USA
Overview
7
7
years of professional experience
Work History
Evaluation and Data Analyst
Prospect Medical Group Holdings, LLC – CRC
Irvine, CA
10.2023 - Current
- Administer and resolve medical Data integrity of East and Pacific Coast patients through supplemental data utilizing SQL queries and Python to improve the accuracy of documented transactions, producing over $8 million in revenue
- Identify fields of insight to doctors and specialists by summarizing claims and utilizing aggregate performance reports using excel macros and pivot tables
- Engage in weekly meetings and utilize internal ticketing systems to communicate and resolve developments of Tableau Dashboards, monthly reports, and weekly tasks requested by clients and doctors
Evaluation and Data Analyst
The Priority Center
Irvine, CA
03.2021 - 10.2023
- Evaluate and resolve Data system issues related to Electronic Health Record Software, email authenticity and Administrative Access to client’s and clinician’/therapist’s accounts
- Administer and perform Data Cloud System Analytics on operations and performance on the entire organization, integrating the use of Python and SQL Syntax and attend meetings on solutions
- Utilize & document knowledge of forecasting and statistics, including T-test and ANOVA analytics, with Python to submit monthly/year -end forecasts and performance reports to the County for continued funding
- Proactively troubleshoot any issues or missing data to ensure monitoring reports target a client’s requests
Expense and Billing Analyst Intern
Society for Automotive Engineers
Fullerton, CA
10.2018 - 05.2020
- Recorded expenses for a Seasonal Engineering project to purchase raw materials for a Formula-One vehicle in a cross functional Database using MS Access and Open sourced software
- Used Excel functions such as V-Lookup, Pivot Tables, Data Filtering to ensure and recommend alterations for accurate material expense reports and material data tracking
- Oversaw over 30 project road-maps and analyzed fundraising operations using statistical reporting methods such as goal seek, data table, and regression forecasting in Excel, building over $5k plus in fundraising
- Performed a collective attempt in implementing an MS Access Database of all purchased objects using knowledge of SQL queries and data maintenance
Education
BS - Business Administration – Information Systems
California State University-Fullerton
Fullerton, CA06.2020
Skills
- Skills: Spanish (Fluent), Data Entry, Automation, Revenue modeling and forecasting, Strategic planning, PPT presentation, Basic networking knowledge
- Software: Excel, PowerPoint, Access, Python, html, SQL, Office365/Azure, Outlook, Sisense, Jira, Net
- Interests: Technology, Business, Economics, Music, Software Development, Community Service, Space
Timeline
Evaluation and Data Analyst
Prospect Medical Group Holdings, LLC – CRC
10.2023 - Current
Evaluation and Data Analyst
The Priority Center
03.2021 - 10.2023
Expense and Billing Analyst Intern
Society for Automotive Engineers
10.2018 - 05.2020
BS - Business Administration – Information Systems
California State University-Fullerton
Similar Profiles
PATRICIA FERROPATRICIA FERRO
Certified Registered Nurse Practitioner at Prospect Medical Holdings IncCertified Registered Nurse Practitioner at Prospect Medical Holdings Inc
Tammy HowieTammy Howie
Central Scheduler at Prospect Medical Holdings/Med-MetrixCentral Scheduler at Prospect Medical Holdings/Med-Metrix
Tammy HowieTammy Howie
Central Scheduler(Patient Service Center) at Prospect Medical HoldingsCentral Scheduler(Patient Service Center) at Prospect Medical Holdings
Bing ZuoBing Zuo
Universal Banker at CitibankUniversal Banker at Citibank
Louie VasquezLouie Vasquez
Production Technician at BaltProduction Technician at Balt