Project Data

MARK J. SHAHAN

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

Antelope, CA 95843

916-***-**** **********@***.***

BUSINESS ANALYST

Data Modeling System Development Healthcare Contracts Process Documentation

System testing & load balancing. Monitor vendor contracts and SLAs. Prepare requirements,

specifications, business processes and recommendations. Create graphical data design representations

illustrating data flow and extractions. Excellent interpersonal, problem solving, and persuasive skills.

Deliver informative, well-organized presentations.

Additional strengths in Database Analysis, Software Project Coordination, Technical Writing, Finance

Reports, and Customer Relations.

• •

• HIPAA MS-Visio

Analyze Data

• •

• ICD-9 NIST

CMS 1450/1500

• •

• Medi-Cal Prepare Reports

CPT Level I & II

• •

• Medicare Project Proposals

Crystal Reports

• •

• MS-Access Revenue Codes

Data Modeling

• •

• MS-Excel Tech & Business Writing

Finance Reports

• •

• MS-Power Point VBA

Healthy Families

• •

• MS-Word Workers Comp

Health Kids

HEALTHCARE BUSINESS ANALYST & IT MGR 4/21/2003 to 6/30/2009

RIVER CITY MEDICAL GROUP; SACRAMENTO, CA

Created RFPs for all IT projects. Responsible for feasibility and cost/benefit analysis. Responsible for creating BCP,

DR, SLA, training booklets, data processing procedures at the user and admin level, and vendor req & spec docs.

Responsible for analyzing business processes and making improvements. Analyzed & implemented multiple

healthcare contract changes with short deadlines. Responsible for sys analysis and maint of MS Sever environment.

Responsible for testing all data loading procedures related to EDI transactions. Coordinate with cross-functional teams

in different depts for quality data and analysis. Coordinate with several healthcare orgs for send/receive data

requirements based on data & contractual requirements. Responsible for loading and maintaining monthly Healthy

Families, Healthy Kids, and Medi-Cal membership enrollment data. Responsible for claims encounter data and

reports for contract incentive revenue. Used Crystal Reports, Access & Excel to create custom reports and graphs for

monthly Board of Directors meetings. Analyzed, designed, & converted membership enrollment data loading process

from 2 weeks to 3 days. Used PowerPoint for presentations. Completed 3-yr project to migrate legacy healthcare

system to modern SQL Server-based system with 128 rewritten reports in Crystal Reports and Access. Completed 2-yr

project to migrated company’s server-based healthcare application to a secure web-based HIPAA EDI compliant

version to include enrollment (834), and claims (837) transactions. Used MS T-SQL to create SQL scripts for office

automation. Used ClarEDI to verify EDI claims/encounter (837) transactions.

BUSINESS ANALYST & IS MGR 12/1/1998 to 11/1/2002

INTERPLAN CORPORATION, INC. ; STOCKTON, CA

Perform requirements & design analysis. Develop & conduct app testing efforts. Manages resources in accordance

with project schedule. Responsible for healthcare application development and testing. Develop functional

specifications and system design specifications for client engagements. Coordinated with cross-functional teams in

different locations for quality data and analysis. Applied waterfall SDLC (Agile XP) methods. Applied Enterprise

Architecture & Use Cases methods for software development. Completed 4-year project to create Visual Basic secure

applications for a Physician, a Dental, and an Optometry healthcare network. Designed a modernized Claims System

to replace existing legacy system. Created ERDs & DFDs for newly designed SQL Server database applications.

__________________________

EDUCATION

BS Computer Science, California State University, Sacramento

Contact this candidate