Analyst Data

RHONDA COVENTRY

Cell: 248-***-**** Email: abmgqp@r.postjobfree.com

CAREER SUMMARY

A Data Analyst professional with a multidisciplinary background which spans

Finance, Information Systems, Life and Health, Underwriting, and HMO.

Expertise in integrating data from multiple platforms. Formal training in

systems analysis and design. Extensive background in programming, testing,

debugging and implementing programs. A consistent achiever with strong

skills in data analysis.

SQL Access EDI Cognos

PL / SQL Excel HTML SAS

Oracle VBA FTP SPSS

UNIX PowerPoint SQL*Loader HIPAA

LINUX Visual Basic JCL COBOL

PROFESSIONAL EXPERIENCE

Five Brothers Mortgage Servicing and Securing, Inc., Warren, MI

2010-current

Clerk

. Analysis of open work orders and closing of completed orders.

Community Bowling Centers, Livonia, MI

2009-current

Telemarketing Analyst

. Eliminated backlog of incorrect, disconnected, and do not call

telephone number updates to telemarketing database within days of hire

which improved quality and reduced liability.

. Produced telemarketing telephone lists for users using Access and

Excel.

Conestoga-Rovers & Associates ( CRA ), Waterloo, ON 2007-2009

A Worldwide Construction, Environmental, Engineering and IT Services

company

Database Analyst, Plymouth, MI

. Loaded environmental laboratory data into database using SQL, Access,

and Excel.

. Created reports of environmental contaminants and effectiveness of

remediation treatments.

VERIGENT, Mooreseville, NC 2007

A Staffing Firm.

Data Collector, Farmington Hills, MI

. Drive testing for Alcatel - Lucent on AT&T - Cingular cellular towers

using LDAT ( Lucent Data Analysis Tool ) and Agilent, as well as

DeLorme Street Atlas.

BLUE CARE NETWORK ( BCN ), Southfield, MI 2002-2005

An HMO provider.

Senior Medical Data Analyst

. Received an award for "Outstanding Professional Support" from

Southeastern Michigan Childhood Immunization Registry ( MCIR ) for

audit programs that improved data quality submissions.

. Updated and maintained an Access database of childhood immunization

records that led to an excellent rating from HEDIS for quality.

. Loaded membership, provider, and benefit package data from various

platforms using SQL*Loader into an Oracle database enabling a more

efficient departmental reporting.

. Using SQL identified prospective members from medical claims for

chronic, progressive disease management program with the goal of

improving the patient's quality of life.

SYNTEL, Troy, MI 1999-2000

An Information Technology Consulting Firm.

Systems Analyst, Financial Services Consultant, Minneapolis, MN

. Conducted feasibility study on disparate pricing systems that

determined whether it was cost effective to consolidate.

. Performed systems analysis to migrate old insurance products to a

newer program and modified the programs allowing the business to

improve efficiencies and reduce maintenance cost.

. Developed software program documentation for easier maintenance by

programmers.

Rhonda Coventry Page 2

HEALTH ALLIANCE PLAN ( HAP ), Detroit, MI 1987-1999

An HMO provider.

Programmer Analyst 1998-1999

. Realized $300,000 annual savings by identifying additional claims that

were eligible for Coordination of Benefits ( COB ) .

. Developed programs in Access and SQL to achieve and maintain external

quality review approval.

. Created programs to analyze and identify high cost providers that

allowed negotiation of better contracts, identification of over

utilization, and redirection of care to more cost effective providers.

. Identified under utilization using procedure and diagnosis codes to

improve patient care.

. Implemented and supported Lotus 123 programs using complex macros to

transfer data between the mainframe and the network to reduce clerical

time to correct incomplete data.

Operations Systems Analyst 1994-1998

. Analyzed workflow and created programs to accelerate resolution of

coding errors by 200-400%.

. Supported the system deployment of HPR / HBOC CodeReview that

evaluates claims for inaccurate coding by integrating data between

different platforms ( PC, mainframe ) resulting in significant cost

containment.

. Developed programs to track Medicare & Medicaid participants to ensure

that all legal requirements were met and to coordinate insurance among

providers.

. Created adjudication programs to identify inpatient and outpatient

claims for supervisor review.

Programmer / Programmer Trainee 1991-1994

. Conducted training seminar for staff on BETTER / LOUIS which improved

program testing.

. Performed program maintenance using full software development life

cycle that included testing and debugging which kept the business

efficiently functioning at the highest level.

Financial Systems Analyst 1989-1991

. Created various claims payment audit programs to check for compliance

with contractual agreements to ensure proper payment to providers.

. Developed pharmacy drug programs to identify rebate possibilities

using mainframe and PC to summarize the data.

Underwriting & Rating Analyst I / II 1987-1989

. Achieved a 1300% increase in rate notice productivity while reducing

clerical errors by automation.

. Automated production of address database resulting in more accurate

and assessable information.

FEDERAL HOME LIFE INSURANCE COMPANY, Battle Creek, MI 1983-1987

Life & Health Insurer ( currently located in Orlando, FL ).

Actuarial Trainee 1984-1987

. Automated process of rate notice generation using Lotus123, improving

quality and efficiency.

. Increased revenue stream by filing for state premium rate increases

using Easytrieve and COBOL.

Structured Annuity Specialist 1983-1984

. Calculated annuity quotes for agents that developed prospective

business.

. Developed a mortality study of the structured annuity line to enable

more aggressive pricing.

EDUCATION

BA, Mathematics, Cedarville University, Cedarville, OH 1983

PROFESSIONAL DEVELOPMENT COURSES

. Internet & Web Design using Dreamweaver and Fireworks

. PC Graphics Concepts using Fireworks and Flash

. Mastering Visual Basic Fundamentals, VBA Foundations for Microsoft Office

( Levels I & II )

. Systems Analysis and Design

Contact this candidate