a
aeronjasonmarti

Aeron Martin

@aeronjasonmarti

Excel and Power BI Data Specialist

Filippijnen
Engels, Tagalog
Sommige informatie wordt in het Engels weergegeven.
Over mij
I am a Data Specialist and Analyst with over 13 years of experience managing complex operations datasets, specializing in turning messy, unorganized data into clean, actionable business insights. My core expertise lies in advanced MS Excel, Power Query automation, and interactive Power BI dashboard development. Whether you need massive datasets cleaned, automated data workflows built, or visually compelling reports designed to track your key metrics, I deliver scalable and accurate results. Let's streamline your data and build reports that make decision-making effortless!... Lees meer

Skills

a
aeronjasonmarti
Aeron Martin
offline • 

Bekijk mijn diensten

Gegevens opschonen
I will clean messy data and deliver automated excel dashboards
Data dashboards
I will clean messy data and create interactive power bi dashboards

Portfolio

Werkervaring

Abbott

Abbott

Fulltime • 17 yrs

Healthcare Data & Reporting Analyst (Verification of Benefits Specialist)

Jun 2013 - Present13 yrs

Abbott Philippines – Heart Failure Division (Acelis Connected Health) | 2019 – Present Healthcare Data & Reporting Analyst (Verification of Benefits Specialist) • Core VOB Operations & Policy Analysis: Manage end-to-end Verification of Benefits (VOB) and RCM workflows—handling prior authorizations, referrals, order shipments, and claims—while analyzing complex insurance policies to ensure accurate patient coverage and minimize billing errors. • Departmental Data Cleaning & Reporting: Act as the department's primary data resource, utilizing Power Query and advanced MS Excel to clean, organize, and process extensive operational and patient datasets for weekly reports. • Process Improvement: Analyzed internal workflow and handle-time data to identify operational bottlenecks; developed a data-driven solution that slashed verification average handle time (AHT) from 5 minutes to 1 minute. • Operational Dashboarding: Designed and maintained functional Excel dashboards that transform raw departmental insurance, tracking, and claims data into clear visual trends, providing leadership with actionable insights on operational patterns.

AP/AR Specialist

Dec 2016 - Dec 20182 yrs

Abbott Philippines – Toxicology Division | 2017 – 2019 AP/AR Data Specialist • Invoice & Billing Processing: Managed the end-to-end processing, verification, and matching of high-volume vendor invoices, purchase orders, and customer billing statements to ensure timely and accurate payments. • Account Reconciliation & Ledger Maintenance: Monitored and reconciled accounts payable and receivable ledgers, identifying and resolving financial discrepancies to maintain precise financial records.

Insurance Verification Specialist

Dec 2014 - Dec 20162 yrs

Abbott Philippines – Arriva Medical Division | 2015 – 2017 Insurance Verification Specialist • Eligibility & Benefits Verification: Conducted comprehensive verifications of patient insurance eligibility, coverage details, and policy benefits directly with insurance providers to secure accurate healthcare funding. • Authorization & Documentation Management: Managed the submission and tracking of prior authorization requests and medical referrals, ensuring all documentation complied with payer guidelines to prevent claim denials.