Customized Projects developed and Implemented for KLES Dr. Prabhakar Kore Hospital & MRC Belgaum

Project #1: Online PO Tracking, Authorization and Mailing Systems

Environment: Microsoft Technologies VB, VB.net, SQL Server
Reporting Tool: Seagate Crystal Report
Team Member: 4 nos
Project Roll Out: 90 days
Project Initiation & Planning: Initiated by CFO KLE Hospital. Sofscript ERP Implemented since 2007 but there no authorization checking levels in the system.We studied the scope and accepted for roll out the project.
Project Description:
PO Tracking Systems helps to analyze the items purchase history to the authorizing authorities by supplier wise if any variations will be highlighted in color code. Along with this show current stock and 3 months consumption pattern. Soon after authorization a mail and SMS will trigger to the authorized supplier along with Authorized PO attachment.

Project #2: Management Information System and BIS mobile Interfaced

Environment: Microsoft Technologies VB.net#, VB6, SQL Server
Reporting Tool: Seagate Crystal Report, ASP Dynamic pages
Domain Team Member: MD & CEO, Finance Experts, Health Care specialist, Audit Committee, Inventory Holders.
Development Members: 6
Project Roll Out: 90 days
Project Initiation & Planning: Initiated by Medical Director & CEO KLE Hospital. Sofscript ERP Implemented since 2007 but there no authorization checking levels in the system. We studied the scope and accepted for roll out the project.
Project Description:
MIS is the backbone for decision-makers in an ERP system. MIS is grouped under various sections like Financial decision-making reports, Patient Inflow Trend Chart includes OP & IP Occupancy specialty wise, Inventory Management, Medical Record Department, HR Management, Laboratory Information, Radiology Information system, OT Management, Ambulance Tracking Tool.

Project #3: NABH Software for implementation of 10 Chapters of NABH quality indicators and NABL

Environment: Microsoft Technologies VB.net#, VB 6, SQL Server
Reporting Tool: Seagate Crystal Report, ASP Dynamic pages
Domain Team Member: Administrator Clinical Services, HIC Team, Quality Cell Headed by Clinical Administrator

Implementation of NABH and NABL quality indicators are observed as major challenges in the treachery care hospital which are in a large number of bed sizes like above 1000 Beds with employee strength of 2000+ nos, we have understood the scope to design electronic NABH and NABL Software.
Development Members: 3
Project Roll Out: 90 days
Project Description:
NABH Software for implementation of 10 Chapters of NABH quality indicators
The software helps to enter online quality indicators and also a click of the button makes the analysis of the entered data from various wards, ICUs, and OPD blocks etc..
SSI: Tracking of Surgical Site Infection Software for TIME MANAGEMENT Calculations of Turn Around Time (TAT) while providing services to the patients in the following areas. Which will help the management to improve the services Turn Around Time (TAT)
Patient analysis TAT: OPD Recording of time right from patient entering into the hospital to till 1st analysis of the doctor. TAT ward: First visit of a doctor in the ward are in case of IPD. Approvals TAT in case of Credit company patients 4. TAT Time is taken from discharge advice to till exit of the patient. LAB report TAT: Which will calculate time automatically.

Project #4 Hospital Drug Formulary with E-Prescription

Environment: Microsoft Technologies VB.net #, VB 6, SQL Server
Reporting Tool: Seagate Crystal Report, ASP Dynamic pages
Domain Team Member: Sr. Consultant Microbiologist Department
Development Members: 3
Project Roll Out: 90 days
Project Initiated:
Hospital Administration as hospital policy keeps 3 brands of drugs generic wise.
Project Description:
The software is designed based on the input given by Microbiologist. Based on composition with generic drug formulary has been designed with E-Prescription. Consultant based on specialty login drug formulary use to filter the drugs and prescribe. The prescription is then populated to the pharmacy for dispensing the drugs.

Project #5 Assest Management Software

Environment: Microsoft Technologies VB.net#, VB 6, SQL Server
Reporting Tool: Seagate Crystal Report, ASP Dynamic pages
Domain Team Member: Sr. Consultant Microbiologist Department
Development Members: 3
Project Roll Out: 90 days
Project Description:
Asset Management helps the organization manage valuable assets efficiently and affordable. The main purpose of Asset Management helps in the development of infrastructure assets towards optimal benefits and minimal cost.

The life cycle of the Asset starts with purchase, AMC, Preventive maintenance, Repair, depreciation, and condemnation of asset. Depreciation as per standard accounting system. Asset Management allows to instantly locate any asset, eliminating wasted time spent searching for missing items and unnecessary expenditures to replace lost assets.

Client DM Aster Aadhar Hospitals

Project #6 E Vendor Analysis Software

Environment: Microsoft Technologies VB.net #, VB 6, SQL Server
Reporting Tool: Seagate Crystal Report
Domain Team Member: Sr. Consultant Microbiologist Department
Development Members: 3
Project Roll Out: 45 days
Project Initiation: By CFO
Hospital authorities decided to freeze the prices of medical consumables for the upcoming financial year. It was a tedious to make vendor analysis like nomenclature of items were different vendor wise and interstate wise. Taxation part was different, supplier lead time.
Project Description:
Considering the above functionality a software used to generate an item master file with securities lock like Brand, Item Code, Item Name and Packing style.File is generated in Excel format which will be published on the website for download to the supplier. The necessary instruction was given in the file for filling and sending the file as an attachment or in media format. The system uses to import all the excel files received from each supplier and generate automatic comparison statement considering the taxation of state.

The analysis was done for 4 states for 6 branches of the hospital.

Client Pavitram Prabha Clinic

Project #7 Electronic Medical Record and finance and Billing module with SMS Solution

Environment: Microsoft Technologies VB 6, MS Access
Reporting Tool: Seagate Crystal Report
Development Members: 3
Project Roll Out: 30 days
Project Initiation: Dr. Porwal Consultant Cardiologist & Interventionist
Project Description:
Pavitram Prabha Clinic is specialties in Cardiology and ophthalmology. A comprehensive electronic medical record to trace the patient review for each episode. Billing module is used to generate an invoice for service availed by the patients for both the specialties. Generating Cash statement, Auditors reporting tool.

Dr. Karishetti Clinic

Project #8 Electronic Medical Record and finance and Billing module with SMS Solution

Environment: Microsoft Technologies VB 6, MS Access
Reporting Tool: Seagate Crystal Report
Development Members: 3
Project Roll Out: 30 days
Project Initiation: Dr. Karishetti Nephrologist
Project Description:
For nephrology patients, it is very much essential to have proper reminders for dialysis procedure as part of EMR SMS alert configuration settings prior 3 days of dialysis procedure date. Billing module is used to generate an invoice for service availed by the patients. Generating Cash statement, Auditors reporting tool.

Dr. Shetty’s Medical & Aesthetic Skin Solutions Pvt Ltd

Environment: Microsoft Technologies VB.net #, VB 6, SQL Server
Reporting Tool: Seagate Crystal Report
Domain Team Member:
Development Members: 3
Project Roll Out: 45 days
Billing with Inventory Management is a software product developed purposely for small and medium industries. Billing Software is designed and customized exclusively for the Indian market which requires such software to better manage their internal processes. The product enables temporary registration management including the facility to make service level billing for product along with VAT integration, store to electronically manage requisitions, issues, and inventory