Post Job Free

Resume

Sign in

Data Analyst Customer Service

Location:
Los Angeles, CA
Posted:
October 06, 2020

Contact this candidate

Resume:

XAVIER BEJARANO

**** ********** ***, *******, ** 94531 · 925-***-****

adgqcb@r.postjobfree.com

adgqcb@r.postjobfree.com

Graduate student looking to become an asset as a Data Analyst

Self-taught in SQL, SAS, Python, R, VBA, Microsoft Office

EXPERIENCE

MARCH 2018 - PRESENT

PATIENT FINANCIAL ADVISOR, KAISER PERMANENTE, SAN RAFAEL

-Assist members with understanding their benefits when a cost-shared is owed

-Determine eligibility for private, federal, state and county program coverage for patients.

-Obtain treatment authorizations, if needed

-Advise patients of their financial responsibilities and arranging and/or collecting payments when appropriate

-Assist patients for applying for medical financial assistance

-Interview patients regarding possible workers compensation coverage, coordination of benefits and/or third-party liability

-Spearhead audits to determine the accuracy and completeness of the data collected in the admitting and registration process

-Work collaboratively with hospital, clinic, emergency department and member services personnel to create a customer friendly environment

-Analyze and audit spreadsheets using Visual Basic for Applications (VBA) and Macros from Microsoft Excel to determine patterns in effective workflows regarding copay collections, OSHPD and admission accuracy, and metrics within the World Class Scorecard

-Consult management and Senior Leadership of the Revenue Cycle with analyzed data regarding current workflows and if any updates are necessary

NOVEMBER 2016 – MARCH 2018

LEAD ADMITTING REPRESENTATIVE, kaiser permanente, san rafael

-Liaison between management and the admitting team

-Provide support for the management team

-Order supplies

-Assign daily tasks to the admitting team

-Train new hires and current employees in daily admitting workflow

-Lead morning/afternoon huddles

-Audit results of certain admitting workflows

-Run and analyze discharge report using Visual Basic for Application (VBA) and Macros on Excel to calculate copay collections from previous day

AUGUST 2017 – PRESENT

UBT CO-LEAD, KAISER PERMANENTE, SAN RAFAEL

-Voted on by my peers

-Work through consensus with management and admitting colleagues about improving/changing workflows for the better of the department as well as our members

-Monitor test-of-changes

-Jointly reach consensus between changes of workflows between admitting department and management/upper leadership

-Ensure - management and colleagues - have an equal voice during the UBT meetings

-Maintain department is in scope on workflows

-Audit certain workflows and metrics from the World Class Scorecard to determine if any updates are necessary

-Orchestrate meeting dates and times with management

-Spearhead employee incentives for success of achieved World Class Scorecard metrics

AUGUST 2011 – NOVEMBER 2016

ADMITTING REPRESENTATIVE, kaiser permanente, san rafael

-Provide customer service

-Admit patients

-Collect patient copays from hospitalizations

-Clean hospital census

-Pend future patient’ appointments/procedures

-Assist other hospital departments

-Insurance verification

EDUCATION

IN PROGRESS – CLASS OF 2021

MASTER OF SCIENCE IN HEALTHCARE ADMINISTRATION, california STATE UNIVERSITY – east bay

DECEMBER 2017

BACHELOR’S DEGREE IN FOREIGN LANGUAGES, arizona state university

JUNE 2008

HIGH SCHOOL DIPOLOMA, deer valley high school

SKILLS

Self-taught in Python, Microsoft Excel and Word, VBA, SQL since 2016

Leader

Love to learn

Effective collaborator

Great handler of pressure

Bi-lingual (Spanish)

Committed to providing excellent customer service

Strong work ethic

Critical thinker

Adaptive

Punctual

Effective communicator

ACTIVITIES

-Received a Certificate of Participation from the Emerging Leaders Development Program at Kaiser Permanente from September 2018 – December 2018

-Currently in the Lean Six Sigma Certification Program through the American Society for Quality (ASQ). Class of 2020.

-Analyze spreadsheets to determine patterns in effectiveness of current workflows regarding copay collections, OSHPD and admission accuracy, and metrics within the World Class Scorecard



Contact this candidate