Representative projects performed by Griffin Staff in 2007-2009.

Community Health Plan of Washington – Seattle, WA; Recently engaged to provide staff augmentation for Data Mart Development using Microsoft SSIS (Data Transformation Services) and Microsoft SQL Server Report Services.

Secure Health Plans of Macon, GA; Program and deploy a complete data extraction which is sent on a daily basis to vendor Healthx to provide online enrollment and lookup for Secure’s Employer (TPA) clients.

JMH Health Plan – Miami, FL: Developed a custom "Center" Report which will provide revenue, cost and loss ratio information for each of their contracted Primary Care Clinics.

DC Chartered Health Plan – Washington, DC:
Currently providing data out services to send their data to Meddecisions, Managedcare.com and District of Columbia (MAA).
We have written routines to accept data in from the following data sources; Caremark (rx), Logisticare, QPA Dental, Mental Health, Labcorp (Lab) and several others.
Developed a new custom EOB.

Queens Long Island Medical Group: Developed a Fund Status and Out of Network reporting system. Produced Profit and Loss by Center and indentified out of network specialty costs.

Comprehensive "Employer Group Reporting": We have provided turnkey services to deliver a formal reporting package to Fortune 5000 Companies for the following companies:
Palmer & Cay Consulting (now Wachovia), Arnett Health Plan, Carolina Care Plan, and Grand Valley Health Plan.

Physician profiling: We have over 12 years experience working with ETG’s, ACG’s and MEG’s to produce physician profiling and episodes of care analysis.

Custom data extraction and data warehousing: One of our primary services is to build custom data warehouses for clients either hosted by us, or in house. For organizations that already have a “warehouse”, we can provide services to improve an existing warehouse and add missing ancillary data to it (rx, lab, visions, etc.). This could include design techniques to make the warehouse more suitable for reporting and analysis projects.

Data Networks and Servers: We have been contracted in the past to provide high level Database Administration consulting and management. For example, coordinating an upgrade of servers, networks, software and oracle release points for a customer’s data warehouse platform (Carolina Care Plan).

Management reporting: Rick Sigler is often brought in by senior management to provide consulting and reporting for one time high level projects. Some examples include: Cost and Revenue reporting to assist in Rate setting, network development or capitation negotiations. Analysis of claims for a possible plan acquisition. Provide raw data to contracted actuaries for plan design projects.

Conversion of data from various formats: We spend a lot of time helping customers convert incoming and outgoing data into formats that can be used by the various players. Our data experience includes:
DST/MHC, Amisys, powerMHS, Eldorado (healthpac), RIMS, ANSI 837, XML, Oracle, Microsoft SQL Server, Ingenix, Unix, PICK, Universe, EBCIDIC, ASCII, Microsoft Access, Foxpro.

Custom Software Development: We have developed numerous Web Based software applications for clients, including a 24/7 On line Employer Group Proposal system (Carolina Care Plan, Grand Valley Health Plan).

John Schaible – Senior Software Developer
Bachelor of Science in Computer Science degree from Central Michigan University with minors in Psychology and Military Science. Eight years service with the United States Army Reserve as a Combat Telecommunications Specialist. Twenty years experience in programming with expertise in
Microsoft Visual Studio. Ten years database experience with Oracle (7.0 through 10g), Microsoft SQL Server (6.0 through 2005), IBM DB/2. Additional database experience with MySQL and PostgreSQL. Operating System expertise with all Microsoft Operating Systems from DOS 3.0 to Windows XP, Vista and Windows Server 2003. Additional Operating System experience with SCO Unix, Linux (including Red Hat, SUSE and Mandrake distributions), IBM AIX, Mac OS X, andNovell NetWare.

Gary Kozlov – Web Software Developer
Gary is a web/software developer with 11+ years of extensive experience in all phases of project life cycle including analysis, design, development of software systems and web sites, testing, users training, maintenance. Worked in different industries such as Automotive, Financial, Insurance etc. Currently using and proficient in Microsoft and other technologies: ASP.NET, VB.NET, AJAX, Web Services, Java Script, CSS and SQL Server for web and software development. Graduated from Polytechnic University, St. Petersburg, Russia with BS in Computer Science.