Business Analyst Data

Work: 916-***-****

Bryan Bedwell

**** *********** **

Mobile: 916-***-****

Sacramento, CA 95822

E-mail: *************@*****.***

SUMMARY

Multi-talented Data Analyst II currently working in Corporate PDE with a wide range of healthcare

industry experience. Ability to analyze and interpret internal and external customer needs. Extreme

attention to detail, capable of working in a team environment or independently.

Skills:

PowerBl

Microstrategy Development & Production

PowerPoint

Word

Visio

Advanced Excel: writing functions, pivot tables, etc.

t-SQL, MS SQL Server, PL/SQL, vS Data Tools 2017

ODW, EDW, RDB

Objective

Seeking a Business Analyst position

Experience

Centene/Health Net, Inc. California

9/2023-Present

DA Il for Corporate PDE

Employing SQL Server and Visual Studio Data tools to create SSRS and Powerbl reports to support the

PDĖ Market Team and Healthplans.

.

Designing Sharepoint site for PTO tracking

.

Creating Reports to automate updates in Portico

Designing Reports in Powerbl

.

Creating SSRS

Utilizing Visual Studio to refresh data for Powerb

Centene/Health Net, Inc. California

9/2019-9/2023

Business System Analyst

Employing SQL Server and Visual Studio Data tools to support Cal-Mediconnect and Delegation Oversight

for reporting and data analyst needs.

Designing a Sharepoint site for the Cen Vet EIG

Analysis of Cal-Mediconnect monthly trends

Creating Report Automation with SQL Management Studio

Designing Reports in Powerbl

Providing data support for Delegation Oversight

Centene/Health Net, Inc. California

12/2017-8/2019

Business Analyst IlI

Analyzing HealthNet California business trends in Claims, Emergency Services and Call Center Data by

developing dashboards using MicroStrategy, Advanced Excel (Pivots, Formulas, etc.) and PowerPoint in

order to present the analysis to upper Management.

Managed Healthcare Network (MHN/Health Net)

4/2006-11/2017

Business Analyst

This position is responsible for coordinating with Health Net, Inc. and other Medical carriers to correct the

Out of Pocket of MHN members.

Coordinating with IT to fix 837P and 837I file errors.

Creating Out of Pocket MS Excel Spreadsheets

Analyzing Cross Data Accumulations issues

Conducting Meetings

Assisting Recovery with Overpayments

Testing/Test scripts/Working with Business System Analysts

Includes all the responsibilities of the Sr. Research & Review position.

Sr. Research & Review

This position is responsible for researching previously paid claims, identifying overpayments and

underpayments, observing trends, and adjusting claims. The department receives approximately 500

research requests per month. Each representative is responsible for independently managing their own

workloads.

Manage multiple Lines of Business including Duals, Commercial, Medicare and Medi-Cal

.

Assisting with system testing

Subject Matter Ěxpert for Offsite employees

Subject Matter Expert for Provider/Member Claim Issues

Analyze and interpret customer needs

Observe and report system trends

Assist management and peers with written policy and procedural improvements

Consult with business analysts regarding system issues identified through research and review

.

Process between 20 and 40 research cases daily

.

Consistently maintain accuracy level of 99%

Sr. Claims Examiner

This position is a leadership role within the claims department. Iwas responsible for assisting examiners

with more technical complicated claim scenarios in addition to processing my own workload of claims.

Also responsible for high visible performance group claims achieving expected turn around time and

quality guarantees.

.

Consistently exceeded quality standards of 99% accuracy and better

Consistently exceeded department productivity standards

Assist management and peers with written policy and procedural improvements

.

Advising examiners on Policies and Procedures

Additional projects as assigned

Nationwide Health Plans; Sacramento, CA

2/2004-4/2006

PPO Health Insurance Company

Claims Examiner

Responsible for processing claims.

Maintain production standards and quality

Provider Maintenance Input Technician

Responsible for inputting data and fixing provider records, fee schedules.

Working as team

Relaying feedback to fellow team members

.

Maintain a 98% and above audit

Position has a direct financial impact on company's daily business

.

Assisting other departments regarding provider information

.

Contacting provider to update database

.

Passed Medical Terminology Class

Customer Service Representative

Provide quality customer service to providers and members.

.

Achieved 100% on customer service final test

.

Completed five week training

.

Completed coding

April Employee of the Month

Associated Press AdVantage; Sacramento, CA

2001-2003

A Placement Service offering a one-stop shop for advertising agencies.

Placement Specialist/Tearsheet Specialist

acted as a liaison between clients and newspapers nationwide coordinating advertising schedules.

.

Worked with clients to meet deadlines set by newspapers

Placed ads to satisfy client expectations

Initiated contact with 1500 newspapers to collect and review placed ads against client

requirements, which enabled accurate accounting

Achieved 100% zero outstanding tearsheet quota for the first time in history of the company

.

Revolutionize the process of tearsheet collection

.

Tested new Tearsheet Management System program

2000-2001

Sargent Controls Aerospace & Engineering; Tucson, AZ

The company is responsible for designing and manufacturing aerospace and military vehicle parts.

Document Control Specialist

supplied current drawings and procedures to employees and responsible for keeping drawings and

procedures at current revision.

Responsible for distribution of all current company documents to their respective departments, which ensured satisfactory production of all parts.

Maintained document control room for 3 months without outside assistance.

1998-2000

Convergys Corp.; Tucson, AZ

Call center outsourcing over 500 employees to multiple vendors.

AT&T PIC Supervisor

Oversaw 25 AT&T on-line representatives meet their goal of converting customers to AT&T service.

Responsible for employees' level of performance, resulting in increase number of customer conversions

Maintained employee payroll that allowed employees to be paid in an accurate and timely manner

FedEx Powership Technical Support

performed over-the-phone technical support assisting customers with hardware and software issues.

Solved difficult issues over-the-phone, reducing volume of technician visits, which resulted in increased customer confidence

Achieved Employee of the Month

Over 90% adherence to schedule

Handled 60-100 calls per day

Education

Tucson AZ

University of Phoenix,

September 2001

Bachelor of Science in Business Information Systems

Specializing in Computer Networks

Tucson AZ

University of Arizona,

May 1996

Bachelor of Arts in Media Arts

Minor in History

1991-1993

Suisun, CA

Solano Community College,

50 Transferable credits towards a Bachelor of Arts

Contact this candidate