Our client is a respected hospital accreditation consultancy in the United States. Their consultants evaluate medical institutions — hospitals and emergency care facilities — to surface potential risks and priorities, then deliver a detailed report of their findings so facility staff can correct shortcomings before The Joint Commission’s official visit.
The Problem
When the client first contacted us, they were heavily dependent on Microsoft Excel — spreadsheets were their primary tool for both data collection and reporting. What they needed was a way for multiple users to input and manage data at the same time. Their in-field consultants run fast-paced audits and have to document findings quickly; at the end of each day, those findings must be consolidated into a client-friendly report. The Excel-based approach was limiting their ability to do any of this efficiently.
The client originally set out to find a Microsoft Access developer to build a program modeled on their spreadsheets, but it turned out that Access simply wasn’t powerful enough for what they needed.
The Solution
Techlancer delivered a custom web-based software application that lets the client capture, organize, and share their data efficiently — and eliminate redundant, superfluous tasks along the way.
A web portal gives medical facility representatives direct access to their mock survey results, including:
- historical analysis,
- charts and graphs, and
- an auto-generated executive summary report.
The user interface was designed for immediate visibility: survey results, historical trends, and how those results compare against other organizations in their space. Graphic representations of the data provide a quick summary, while detailed information remains just a click away when it’s needed.
Results and Outcomes
- Business process improvement — we sat down with the client to learn their workflow and identified the best ways to optimize their process.
- Recommended and added features that revolutionized the client’s services.
- Multi-user simultaneous data entry — consultants can submit findings and maintain notes at the same time during a facility evaluation.
- Labor reduction — the data transcription and review process was minimized.
- New surveys can be created quickly from pre-defined templates.
- Faster results — the system aggregates findings into a report that is presented to the facility.
Capabilities Demonstrated
- Business Process Improvement
- Business Process Improvement Assessment
- Web app development
- User interface design
- Cloud-based application development
Features
- Secure web-based login
- Intuitive user interface
- Integrated sorting and filtering
- Custom reporting
- Audit trail
- Client portal
- Microsoft Surface support
- Handwriting recognition
Technologies
- Microsoft SQL Server
- IIS Server
- VB.NET, MVC, Entity Framework
- HTML, CSS, JavaScript, Bootstrap
- GoDaddy Virtual Machine (cloud)
- Open XML SDK