SUMMARY OF QUALIFICATIONS

• 15 years contracting/consulting experience in Healthcare Information Systems
• 18 years of MUMPS/Cach development and database administration Cach v5.02 - v2013, DSM, ISM
• Development experience with Cach Object Script COS Cach Classes, XML, Cach Web Services, Cach SQL, and Cach Server Pages/ZEN
• Additional developing experience with HTML5, JavaScript, JSON, Active Server Pages ASP , Visual Basic 6.0, VB.net, Java, C, Aspect Scripting, JCL, DCL, and Korn shell
• Worked with many GUI and API connections to MUMPS using Web Services/XML, JSON, Cach SQL, KB-SQL,VA RPCBroker, Cach ODBC, and Cach Factory classes
• SQL Report Writing experience using SQL Server, Cognos, Oracle Developer, Crystal Reports, MS ACCESS, and other OLAP tools
• 10 Year of experience with VA VistA system proficient in Fileman, Kernal, APIs, and RPCs
• 15 Years experience with GE/Centricity version IDX9.0 Centricity3.0
• Experience working with EPIC which included system conversions from GE/IDX. Wrote HL7 insurance conversion, Patient Scheduling conversion, and Registration conversions
• Worked with many development tools Cach Studio, MS Visual Studio, Eclipse, SoupUI, SQL Developer, and many others
• Experience scripting job automation providing logging/auditing, FTP/SFTP, print jobs, and report distribution on VMS DCL and Unix operating systems Korn Shell
• In depth knowledge of 4010/5010 HIPAA transaction sets 837 Profession, Intuitional, Dental , 835 Remittance, 276/277, 270/271,997 and NCPDP D.0
• Developed many customized applications to help streamline improvements to Revenue Cycles and payment/remittance reconciliation processes

EXPERIENCE

confidential

Remote Contract VistA Programmer

• As a member of the Cach HDR team we provide a SQL access to VistA data at all 133 VA clinics/Hospitals. Applications like Health eVet benefit from this by providing a SQL connection to all sites. This makes for a more seamless interface to the VistA data for applications written in Java, Web, or any GUI development tool. Also, it provides a means to access data at all 133 sites serving as a data warehouse.
• Developed generic Cache Stored procedure and Web Services that returns data from RPC and API calls. Included security in the Web Security header
• Researched accessing Cache data using JSON JavaScript server side connections
• Create Cach Object Stored procedures that access VistA APIs. This required digging into Lab, Exams, and Orders packages in order provide comprehensive data feeds to java/web based programs
• Generated Cach Persistent classes for all Fileman VistA files using the Fileman To Cach wizard. This provides an ODBC connection to the VistA data so that any third party tool MS Access, Crystal Reports, Excel can write standard SQL to pull data from the VistA application
• Some 7000 Cach classes SQL tables are kept in line with Vista Patches Forum
• Configure/Administered Cach database on Development systems. This includes upgrades for Cach v2010 and v2011
• Created custom columns for persistent classes that accessed Fileman utilities to retrieve data from VistA
• Used Cach Import/Export utilities to drive updates to all 133 VistA sites
• Worked with Oracle SQL developer, Eclipse, and SoapUI to process queries, Cache Objects, and Web Services Accessing VistA data

confidential

System Analyst Employee

• After UPHS moved from IDX to Epic, I migrated the entire IDX system from a costly VMS Alpha Server to a Window Virtual Server. In a sense creating IDX Lite so that they can maintain the system for historical purposes
• Wrote HL7 Insurance interface from IDX to EPIC
• Write reports/extract to migrate Scheduling data to EPIC
• Migrated IDX system from DSM to Window's Cach . Created a IDX Lite version so client could have a read only system used for historical purposes since client now uses Epic
• Perform DSM Digital Standard Mumps Data base maintenance tasks
• Design/developed 835/837 Claim/Remittance tracking system
• Worked with SQL reports from IDX Analyzer product
• Performed monthly Database maintenance tasks
• Wrote custom MUMPS/Extract reports
• Automated production jobs uses DCL and a job management product developed by FCG

Confidential

Contract Cach Engineer/Business Analyst

• Work onsite at the VA Health Administration Center HAC as a HIPAA Ready consultant. Serve as a Cach Lead Architect for all contracts related to the VA HAC Claims Processing Eligibility System CP E . This system uses many of the VISTA file structure and all VISTA development components which include VA fileman, Kernal, Taskman, RPC Broker, and mumps screens. Contract work included the following:
• Modified system to receive Medicare Cross over claims COB for Medicare Part A B and Medicare D
• Helped write proposals that landed contracts for 5010 and ICD 10 implementations
• Providing a GAP Analysis for moving to HIPAA 5010 and ICD 10 in the CP E system
• Provided business/technical analysis for moving from claim level to line item payment process
• Developed framework to move system off of texted based screens to Web. This includes Cach Classes/Objects with a JAVA Seam front end. Generated Cach Object using that projected java classes
• Worked on interfacing EDI inbound 837/NCPDP claim to the CP E
• Developed Cach classes to connect to a rules engine to automate vendor selection Providers for EDI 837, NCPDP, and OCR claims. This process used WSDL objects to connected and send XML data to web services
• Implemented new PBM provider SXC into inbound NCPDP EDI that automated the creation of claims in the CP E system
• Implemented SXC 837 DME claims into CP E
• Implemented new 835 processes for SXC adjudicated claims
• Revamped 835 process to isolate HIPAA out of balance compliance errors
• Did a business/technical analysis for converting Redbook pharmacy coding system to Medispan for the CP E system
• Created Cach persistent classes that are accessed via a Java/Web framework
• Lead Joint Application Design JAD sessions with HAC client to move from Claim level payment to Line level Payment
• Modified Management Reports written in Cach
• Mapped legacy global using CACH mapping tool. Used Fileman to Cach mapping Tool, Ensemble, and ECP technology
• Created new data structures using Fileman

Confidential

Senior Software Engineer IDX Virtual Team

• I worked remotely on a team supporting several clients using GE/IDX medical software FlowCast, CareCast, and ImageCast . Clients include hospitals, academic health systems, physician groups, clinical practices, and facility practices. Systems supported are Hospital and Physician billing, HIPAA transactions, electronic claims/remittance, patient scheduling, patient eligibility, chart tracking and many others. Create custom software in MUMPS/Cach that interfaces with IDX software. Specific duties:
• Support of IDX BAR modules: Registration, Charge Entry, TES, Payment Posting, Batch Maintenance, TES, Claim Form Manager, and E-Commerce
• Supported IDX applications: BAR, HPA, SCHED, and Chart Tracking
• Initiated, designed, and developed a Remittance Reconciliation System. Reconciles 835 payments from what posted and what did not . Tracks all un-posted payments by exchange, by run, by check. Combines unposted payments, reject reasons by check for quick manual resolution. Several Summary and Detailed reports are available to the users
• Initiated, designed, and developed a Claims tracking system. Tracks all EDI claims sent out in an EDI run. Tracks Acknowledgements 997 , 277 Claims Status , and tracks activity for each invoice sent in the file. Provides high level oversight down to the detailed claims where no activity is done. Provides ability to find claims that may have not been received or processed by payers in a more efficient manner
• Developed a tool to automate the posting of patient payments sent to a Lockbox. This AES program allocates payments across multiple BAR Groups, generates an 835 file and runs a script to auto post the file through ARTS payment posting activities
• Developed many interfaces to third party applications such as Stockamp Claims Follow up and AR Workflow , iPayment Front desk patient Collections , and Clientell IVR System .
• Oversight on all production jobs using VMS command scripts. Night jobs, statement production, claims production, 835 posting, reports, DMBS queries, Night Jobs table, templates
• Wrote SQL queries in DBMS tool on IDX Practice Management System
• Proficient in Screen generator, Claim form Generator, EDI Tool Kit, and development of System Variables
• Served as a Database administrator that track database growth, performed integrity checks, and provide system maintenance support. Also implemented archive strategy for all financial, registration, and scheduling applications
• Knowledgeable with IDX'S ARTS Plus - Remittance Advice

Confidential

Independent Contractor

Programmer/Analyst II

• Platform: DEC ALPHA/VMS, Cach V 5.0.3
• I worked nine years for UPI in varying capacities. UPI provides a billing service for over 600 physicians at University hospital and several other clinics.
• Helped migrate to Cach , and move IDX 9.0 to Flowcast 3.0
• Developed many customized application and reports in the AES environment
• Created Cognos Cubes using the Transformer that interfaces IDX data with financial data from the Coda Accounting system
• Technical lead for E-commerce and claim form generator. This included setting up of all paper and electronic submitted claims and development of system variables
• Supported all IDX's applications TES, BAR, MCA, DBMS, PCS, and AES
• Created a claims tracking system to follow the life a claim once it gets sent to a payor
• Created and Tes/Claim Edit Management system. This gets the Edits to the responsible party and results in quicker resolution. Used Cach classes and Cach windows API

Confidential

Programmer/Analyst - VA Employee

Titan Corporation Consultant

• Platform: DEC ALPHA/VMS, Windows NT
• Database: DSM Digital Standard Mumps , SQL Server 2000, KB-SQL, MS Access
• Languages: DSM-Mumps, VB 6.0, ASP, Visual Studio .NET, VB.Net, C ,
• The HAC is a Government payor that provides coverage for beneficiaries of disabled veterans. It includes programs ChampVA, Spina Bifida, Persain Gulf, and Women of Vietnam Vets. The main systems are the Eligibility and Claims Processing/Adjudication System CPS .
• Initially hired for Y2K renovation for their Eligibility and CPS MUMPS systems due to the success of the Y2K project services were extended to 10/2002. Primary duties were to maintain the MUMPS systems and develop new User interfaces and applications using VB 6.0 and .Net.
• Designed the staging of claim payment data for the 835 HIPPA transactions from the Claim Adjudication System
• Designed and developed a Claim Overpayment Recovery system for the Entire VA. System Tracked the recovery effort by a Third party mediator, the collection of the debt and allocation of the funds back to the VA cost centers. System included interfaces with the US Department of Treasury to offset delinquent debts. This system was coded in VB 6.0 and SQL Server
• Created an interface to the Interactive Voice Response IVR system so Beneficiaries and providers could check eligibility and claim payment status. Used an ActiveX API to link into MUMPS
• Created a Mental Health Certification/Authorization system using VB 6.0, SQL Server, and ASP, IntraNet web pages
• Implemented a DMBS product for a MUMPS database that augmented the capability of using OO programming tools, embedded SQL, and dynamic web development
• Developed an interface between the Acorde Imaging system and CPS coded in Visual Basic which makes database connections to SQL Server, and MUMPS
• Serve as a resource for OO programming, SQL, and database connectivity using ODBC

Confidential

Programmer/Analyst III Senior Programmer Analyst

• Platform: RS6000 IAX - Unix, Windows NT
• Analyst for the Electronic Medical Record Epic Software for all outpatient clinics
• Provided support for converting newly acquired clinics to the Epic's Software
• Served as a DBA for the MUMPS database, KB SQL