Sql Server Analyst

Michael Pedersen

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

Castle Rock, CO 80104

***/***-****

Summary

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

•

Healthcare analysis, data reporting, data conversion, and interfaces

•

Proficient in Oracle PL/SQL, SQL Server, Sybase, and Perl

•

Team lead, analyst, and developer

•

Various reporting tools and programming languages

•

Senior Consultant - The TriZetto Group, Inc. Greenwood Village, CO – Jul, 1998 - Present

Responsibilities

• Senior Consultant for various healthcare payer clients across the country

• Analyze data to determine root cause of complex problems

• Design solutions

• Develop programs to meet requirements for clients

• W ork with teams of developers to create solutions that solve problems

Experience

• W orking knowledge of all subsystems within the healthcare industry including Provider, Groups,

Members, Claims, Authorizations, Accumulators, Brokers, Capitation

• Implemented solutions for large scale healthcare payers including United, Wellpoint, Cigna,

Providence, Presbyterian, Amerigroup, John Muir

• Built multiple data conversions and interfaces between legacy systems

• Analyzed and developed reporting solutions across all subsystems for multiple clients

Prior Experience

Senior Analyst – INFOTRUST, Waukegan, IL – Aug, 1999 – Jul, 2001

Business Analyst – QualMed Inc, Pueblo, CO – May, 1995 – Aug, 1999

Developer – PARTNERS Health Plan, Tucson, AZ – Apr, 1992 – Feb, 1995

Research Analyst - The Fontana Group, Tucson, AZ Dec, 1990 – Apr, 1992

Education

Bachelor of Science in Business Administration

Double Major: Management Information Systems/Operations Management

The University of Arizona, Tucson, Arizona, 1990

Software

Oracle PL/SQL, Microsoft SQL Server, Sybase SQL, Perl

•

HP3000, Suprtool, Quiz, QTP, JCL

•

W indows 2000, Microsoft Office, Microsoft Access, Microsoft Project, Microsoft Visio

•

References Available upon Request

Contact this candidate