The client is a leading developer of Canadian healthcare management software. For over a decade, they have provided healthcare professionals with the software tools and support they need to better manage their customer organizations.
The client’s enterprise management solution (EMS) integrates human resources and payroll software systems. It enables users to work more efficiently, reduce costs, and produce the quality information required by the complex demands of the healthcare industry. The challenge, however, was that the EMS interacted with various databases and did not provide a comprehensive reporting system for customers.
Our goal was to extract, transform and load (ETL) the data from different sources to develop a centralized data warehouse that would support an improved and integrated reporting tool for customers. Also build a data warehouse and develop a dashboard using AngularJS with flexibility to edit, drag and drop and a security token for application authentication. A separate project involved the creation of workflow rules engine for time management module. We used agile methodologies with iterative development in collaboration with the client’s subject matter experts.
- Visual Studio 2013
- C#, WWF, AngularJS
- SQL Server Integration Services
- SQL Server Reporting Services
- Designed data warehouse
- Developed and implemented data extraction patterns for the ETL process. This was a key advantage for the client with 30 percent reduction in development time by extending to other ETL processes.
- Created the reporting tools for the client. This included the development of complex reports related to time, schedule, utilization, payment, allowances, financial, audit, insurance and other areas.