Sean Franco-Norris
Healthcare Analyst
Surprise,US
Summary
Dedicated Business Intelligence Analyst with one year of experience and a total of nine years in the healthcare industry. Proficient in Microsoft SQL Server, SQL, Stored Procedures, Nested SQL, Microsoft Excel, Excel VBA, Power BI, and data visualization. Seeking to leverage analytical skills and healthcare expertise in a challenging role within the healthcare industry. Proven track record of cost-saving through data analysis and a solid commitment to continuous skill development. Short-term goals include filling skill gaps through training and taking on new projects. At the same time, long-term aspirations involve pursuing a master's degree in Data Analytics and progressing to a Lead Analyst role.
Overview
9
9
years of professional experience
6
6
years of post-secondary education
Work History
Business Intelligence Analyst
Jewish Family and Children Services
Phoenix, AZ
01.2023 - 10.2023
- Designed and developed customized reports that translated complex data into easily understandable visual formats, enabling informed decision-making.
- Generated ad-hoc reports tailored to specific business requirements, delivering timely insights to support strategic initiatives.
- Created Excel-based tools and dashboards to streamline data extraction and presentation, offering stakeholders clear and concise information for optimal resource allocation.
- Engaged in collaborative requirements meetings to thoroughly grasp and align analytics solutions with evolving business needs.
- Provided technical support to resolve complex analytics and reporting challenges, ensuring the uninterrupted flow of critical data-driven insights.
- Utilized stored procedures and other utilities to devise innovative business solutions, optimizing processes and enhancing operational efficiency.
Coding and Billing Specialist
Stand Together And Recover, Inc
Phoenix, AZ
01.2020 - 01.2023
- Utilized SQL for data manipulation: Developed SQL tables, views, and materialized views to analyze client-employee productivity by merging data from multiple sources, resulting in actionable insights.
- Excel pivot tables for revenue comparison: Created Excel pivot tables to compare revenue across multiple plans, enabling quick decision-making visually.
- Developed data analysis tools: Designed tools for querying and extracting valuable insights from acquired data, enhancing team productivity and accuracy.
- Produced weekly CEO lag report: Generated and delivered weekly lag reports to the CEO, offering timely updates on key performance metrics.
- Maintained expertise in database technologies: Kept up-to-date with the latest database technologies, ensuring efficient data management and reporting.
- Compiled tailored monthly analytics: Gathered and presented customized monthly analytics and reports for senior management using Credible software.
- Ensured data accuracy: Demonstrated meticulous attention to detail, consistently achieving a 98% accuracy rate and reducing departmental error rates by identifying and addressing inconsistencies.
- Proficient in insurance coding: Accurately coded and submitted insurance claims using ICD-10, CPT, and HCPCS codes, guarding against fraud and abuse.
- Resolving payment issues: Proactively identified and resolved payment discrepancies between patients and providers, promoting financial accuracy.
Billing Coordinator
Prologue, Inc
Pikesville, MD
11.2018 - 04.2021
- Prepared and submitted weekly financial reports to CFO: Produced comprehensive reports that provided critical financial insights and data to support decision-making at the executive level.
- Rapid response to inquiries and requests: Demonstrated a prompt and efficient approach to addressing inquiries and requests, ensuring timely resolution of financial matters.
- Accurate processing of payments: Managed and processed various payment types, including cash, checks, and credit cards, with a keen eye for detail in verifying transaction information, available funds, and account balances.
- Precise data entry and payment tracking: Ensured meticulous accuracy when entering payment details into accounts and tracking financial transactions, minimizing errors and discrepancies.
- Financial documentation and reporting: Regularly updated and maintained financial documentation, reports, and spreadsheets with critical financial information, facilitating data analysis and reporting processes.
- Client Social Security income management: Effectively managed the social security income reporting for over 30 clients monthly, ensuring compliance with regulations and optimizing income-related processes.
Quality Assurance Specialist
Stand Together And Recover, Inc
Phoenix, AZ
04.2015 - 11.2018
- Developed comprehensive project documentation: Created design documents, user guides, maintenance documents, and release documents, ensuring clear and organized project records that facilitated efficient problem-solving and decision-making.
- Membership management and data accuracy: Accurately registered new members, regularly updated information for existing members, and meticulously maintained case files to uphold precise and reliable records.
- Insurance eligibility verification: Conducted insurance eligibility verification, demonstrating attention to detail and precision in ensuring members received appropriate benefits and services.
- Record management for a large membership base: Maintained records for a substantial membership base of over 1,000 members, emphasizing the ability to handle large datasets and ensure data accuracy.
- Collaborative problem-solving: Collaborated with the quality team to identify issues, implement corrective actions, and optimize processes, showcasing a proactive approach to quality assurance and analytical thinking.
Education
Bachelor of Science - Data Analytics
Southern New Hampshire University
Hooksett, NH 08.2022 - Current
Associate of Science - Medical Billing And Coding
Community Care College
Tulsa, OK 07.2018 - 03.2020
Bachelor of Science - Applied Information Technology
University of Baltimore
Baltimore, MD 08.2007 - 05.2010
Skills
SQL
Data Visualization
Database Management and Design
Reporting
Microsoft Office Suite
Microsoft Excel
Data Coding and Billing
ICD-10
CPT
HCPCS
Quality Assurance
Documentation
Insurance Eligibility Verification
Data Analysis
Critical Thinking
Problem-Solving
Attention to Detail
Financial Analysis
Record Management
Colaborative Problem-Solving
Rapid Response to Inquiries
Effective Communication with Stakeholders
Team Collaboration
Documentation and Report Preparation
Time Management
Organizational
Proactive
Self-Motivated
Adaptability
Accomplishments
- Significantly reduced costs: Delivered cost savings of over $8,000 by meticulously and efficiently completing member data imports, ensuring data accuracy and operational efficiency.
- Expedited claims clean-up: Played a pivotal role in accelerating claims clean-up processes by collaborating effectively with the claims department, ultimately meeting critical fiscal year-end deadlines and improving overall financial performance.
Timeline
Business Intelligence Analyst
Jewish Family and Children Services
01.2023 - 10.2023
Bachelor of Science - Data Analytics
Southern New Hampshire University
08.2022 - Current
Coding and Billing Specialist
Stand Together And Recover, Inc
01.2020 - 01.2023
Billing Coordinator
Prologue, Inc
11.2018 - 04.2021
Associate of Science - Medical Billing And Coding
Community Care College
07.2018 - 03.2020
Quality Assurance Specialist
Stand Together And Recover, Inc
04.2015 - 11.2018
Bachelor of Science - Applied Information Technology
University of Baltimore
08.2007 - 05.2010