Marathoner Hiker Travel
Alan Norberto Salazar
Jeffersonville,USA
Summary
I am a data focused professional with experience analyzing healthcare claims data, auditing to identify issues, and improving operational workflows. Skilled in SQL, Excel, Tableau, and R for data analysis, reporting, and visualization. Proven ability to improve accuracy, streamline processes, and consistently exceed performance expectations in a remote environment. Driven, disciplined, and coachable with a strong desire to continue to grow in data analytics.
Overview
6
6
years of professional experience
1
1
Certification
Work History
Pharmacy Care Coordinator
Optum
Jeffersonville, IN
10.2023 - Current
- Utilized Excel functions (PivotTables, VLOOKUP, IF statements) to organize, filter, clean, and present patient claim data for team decision making.
- Maintained compliance with HIPAA and regulatory guidelines while managing large datasets, proving strong attention to detail and data integrity.
- Analyzed and verified 100+ medication claims per week to identify issues, ensuring data accuracy, and reducing processing errors by 20%.
- Collaborated with pharmacists, providers, and insurance teams to optimize prior authorization workflows, resulting in a 30% improvement in turnaround time.
Pharmacy Care Coordinator
BriovaRx
Jeffersonville, IN
12.2019 - 10.2023
- Performed trend analysis on medication adherence and authorization outcomes, delivering insights that led to higher approval rates and improved patient support.
- Designed and led training on data accuracy and reporting protocols, resulting in a 25% reduction in documentation and input errors across the team.
- Tracked KPIs related to medication fulfillment and team productivity, presenting findings in weekly reports to higher ups.
Education
High School Diploma -
Jeffersonville High School
Jeffersonville05-2013
Skills
- R (RStudio Cloud, tidyverse, ggplot2, R Markdown, statistical exploration)
- SQL (PostgreSQL, MySQL, Data Extraction, Data Exploration, Data Cleaning, Relational Databases, Filtering)
- Tableau (Data Visualization, Dashboards)
- Excel (Pivot Tables, VLookup, Conditional Formatting, Data Cleaning)
- C#
- Strong attention to detail
- Data Entry
- Bilingual
- Team Collaboration
- Remote experience
- Data Aggregation & Reporting
- Data Cleaning & Data Validation
- Dashboard Development
- Data Quality Assessment
- Trend Analysis & KPI Monitoring
- Experience with Healthcare Systems
- Claims Analyzing
- HIPAA familiarity
- Independent Problem Solving
- Experience with large datasets
Certification
- Coursera Google Data Analytics
- Code Bootcamp Louisville
- Excel Beginner to Advanced UDEMY
- Tableau A-Z: Hands-On Training for Data Science UDEMY
- Khan Academy SQL Completion
PORTFOLIO LINKS
- GitHub | https://github.com/al1jair
- Tableau Public | https://public.tableau.com/app/profile/alan.norberto/vizzes
- LinkedIn | https://www.linkedin.com/in/alannorbertosalazar1/
Interests
Timeline
Pharmacy Care Coordinator
Optum
10.2023 - Current
Pharmacy Care Coordinator
BriovaRx
12.2019 - 10.2023
High School Diploma -
Jeffersonville High School