Projects designed, developed, and implemented for the Massachusetts General Physicians Organization (MGPO) Finance Systems Department, Partners Healthcare:
The Cash Control application was developed with SQL Server 2005 and is used daily by the Revenue Control Department to enter payment batches, record IDX billing system posted/unposted payments and bank deposits, and monitor payment processing. A related application, the Cash Reconciliation application, was developed to provide tools for reconciling the IDX payment data to bank statement data.
The Professional Billing Office Standard Reports application was developed with an Access front end and SQL Server database, and updated with data from the IDX billing system. It was used by all billing managers to provide monthly reporting packages to practices and senior leadership for 4 years (at which time most of the reports were transitioned to Cognos). Reports included actual volume/ charge/ payment performance against monthly budget, payment collection over time matched to charges, accounts receivable performance, write-off and free care, copayment collection, and service mix breakdown -- by division (department), billing area, care facility, and physician.
The Chargemaster application was developed as reference tool for Professional Billing Office staff to view the hospital master fee schedule by CPT procedure code and modifiers, with the corresponding allowables for contracted payers. Included reports of volume and charges by codes billed by division, billing area, and care facility.
The Dermatology Charge Capture application was developed for the Coding Department to enter dermatology charges, track coding discrepancies, manage quality assurance activity, and batch completed charges for automated submission to IDX.
The Professional Billing Office Rejections application was developed for the Group Practice Management and Third Party departments to obtain monthly data (from the IDX billing system) for monitoring claim rejections and insuring that rejected charges are resubmitted for payment.
The PatientKeeper™ Reporting application was developed with SQL Server to provide daily reports of charges submitted via the PatientKeeper™ web application for monitoring provider lag, coder lag, and submission to billing via the electronic charge entry system. A related application was created for the web application implementation team to schedule training sessions with physicians, distribute confirmation notices with training details via email, and track implementation progress.
The MGH/MGPO Process Adherence application was developed for an institution wide initiative to insure referrals are obtained for patient visits to meet billing requirements. MGPO billing managers and MGH practice staff use the application to obtain reports of patient arrivals, patient transfer to the hospital referral center to resolve incomplete registration information, and staff performance statistics for practices participating in the program.
|
 |
| Massachusetts General Hospital |
|
|
University of California, San Francisco
Real Estate Services Property Management Database Application
Designed, developed and implemented application for managing properties owned and leased by the University, including property compliance, property taxes, agreements of various types, accounts receivable, and project management. Features include reports by interactive filter; a Mail Generator for selecting property managers, landlords and tenants by various criteria and sending email notices; and a Send Email Notifications interface to control email reminders sent by the database application to the Real Estate Services Department's project managers when critical dates are approaching, such as lease expiration, rent increase, and agreement option dates.
Image Displayed: Main Menu
|
|
Scios Inc. (Johnson & Johnson)
Adhere Clinical Registry and Contract Management Application
Designed, developed and implemented application for managing clinical registries including hospital site contracts and site profiles, product sales, and sales representative and internal employee site responsibility and call log. Features include a Data Exchange interface to retrieve data from the company's Oracle database and update related data in the database, and workgroup security for users. Prepared training materials and provided customized user training session at implementation.
Image Displayed: Application Opening Menu and Main Menu
| |
Business for Social Responsibility
Media Monitoring Application
Designed and developed application for monitoring media coverage of a proposed mining project in Esquel, Argentina. Features include graphs of media spin and Report Distribution dialog for selecting contacts and distributing selected reports via email attachment.
Image Displayed: Main Menu and Report Distribution Dialog
| |
Business for Social Responsibility
Stakeholder Mapping Application
Furthered development of an existing application for tracking project stakeholder organizations and contacts. Added data tables, revised structure, established relationships/ referential integrity, and created forms and reports. Implemented the AddFlow V4.2 ActiveX component from Lassalle Technologies to provide users with the ability to generate interactive relationship diagrams of stakeholders and contacts from the data. The nodes representing organizations and contacts are placed in one of four quadrants and color coded based on data criteria. Users can edit and save the automatically generated diagrams, and have the option to create a new diagram by adding nodes and links manually.
Image Displayed: Relationship Diagram Form with AddFlow V4.2 ActiveX Component
| |
LeapFrog SchoolHouse
LeapTrack Software Application Development Projects Designed and implemented database structure for state education standards used in the LeapTrack software application and created custom database applications for correlating product data to state education standards and managing product content. Participated in weekly LeapTrack software design meeting and provided written reports at the direction of the Engineering Director. Met project deadlines and technical standards required by the LeapTrack application product launch and release schedule.
Image Displayed: Content Database Correlation Form for correlating LeapFrog proprietary learning standards to educational diagnostics and activity books
| |
LeapFrog Product to State Standard Correlation Application
and Update Tool
Designed and developed State Correlation Editor application as a solution for LeapFrog education specialists' need to correlate the company's education products to state standards and provide data ready to be incorporated in the LeapTrack application database. As the project required state data to be maintained in separate databases, developed an application Update Tool to automate the process of updating multiple database applications (49 state correlation editors) with new components and data. The Correlation Editor became the primary tool used by LeapFrog's correlation group for correlating products to state educational standards and analyzing product performance.
Images Displayed: Correlation Editor Main Menu and Update Tool for updating multiple database applications
| |
LeapFrog SchoolHouse
Testing Tool and Database Preparation for LeapTrack Software
Application Release 1.6
Prepared state databases for incorporation into LeapTrack software release 1.6. Designed and built Testing Tool for running a series of data tests on multiple state databases as part of the QA process. Created database build schedule in Microsoft Project for tracking progress and input from the product development team. LeapFrog SchoolHouse
Data Conversion/Importing/Exporting
Extensive data migration of state standard data for 49 states. Developed process to extract specific data from Oracle generated csv files provided by MediaSeek, Inc. and import the data into the normalized database structure for state databases. Provided training and support to staff for importing and formatting state standard data using queries and functions.
| |
Kenney and Associates
Sales and Marketing Application
Designed, developed and implemented application for sales and marketing. Features include Promotion Generator for sending email promotions to selected contacts. Required data migration from Excel and ACT.
Image Displayed: Promotion Generator for selecting contacts and sending mailings
|
|
|
