The Client
The client company maintains a sick leave tracking app that monitors sickness absences at workplaces. Organizations using this app can track, update, and obtain employee sickness reports from a single dashboard. The app also aligns employees with corporate health service providers for medical checkups, ensuring faster return to work and improved productivity.
Industry
SaaS
Tech Stack
Laravel, MySQL, JavaScript, jQuery, Bootstrap, WebSocket, AWS
Country
Sweden
The Challenges
There’s no denying that a centralized sick leave management app is critical to viewing team availability across organizations. A unified view helps keep track of everything in one place. However, relying on emails, spreadsheets, and SharePoint to manage sick leaves can lead to poor tracking and endless inaccuracies.
The client company used mail threads, spreadsheets, and MS SharePoint to record employee sick leaves across multiple organizations. The result? Massive chaos and endless human errors. While SharePoint is a great tool for document storage, it isn’t fit for sick leave management. Long email threads also led to inaccuracies. Such hurdles led to delays and miscommunications across organizations.
![the challenges](/images/case-studies-details/case-study-162/cs162-challenge.png)
Using SharePoint and spreadsheets for sick leave tracking was like forcing a square peg into a round hole. Moving away from spreadsheets and SharePoint was the need of the hour. Moreover, as employees grew, manual errors in sick leave management increased.
The client realized these gaps and approached Capital Numbers to help them with an alternative solution. They requested our team to help them build a robust sick leave management software app and wanted us to focus on two key aspects as a priority.
Firstly, they wanted us to iron out their issues with spreadsheets and SharePoint. Secondly, they wanted us to develop a multi-user web app that could report on sick leave absences at a massive scale, accommodating 10k+ absence requests without a lag.
Solutions We Offered
Capital Numbers noted the requirements and began the work by eliminating the use of spreadsheets and SharePoint. Using MySQL middleware, our team systematically migrated data from SharePoint and spreadsheets to a Laravel environment.
As part of this migration process, we first exported all data from SharePoint and spreadsheets to an Excel format. We then set up the MySQL middleware to import all data from Excel into the Laravel environment.
Using the MySQL middleware, we could migrate all data from the dated systems to the Laravel ecosystem. The MySQL middleware helped us with data validation, transformation, and security, converting data into a format suitable for the Laravel application’s database schema.
![solutions](/images/case-studies-details/case-study-162/cs162-solutions.png)
Our team used CRON jobs during the data migration to ensure data imports continued automatically at regular intervals. While working on the data migration and storage, we also tapped into Laravel’s advanced capabilities for data reporting.
Next, we built a responsive frontend by leveraging JavaScript’s dynamic capabilities, jQuery’s ease of DOM manipulation, and Bootstrap’s sleek design framework. We also equipped the app with functions that could allow thousands of employees to submit sick leave requests, adding features to track sick leaves in real-time.
Next, we created notifications using WebSocket technology. WebSockets enable instant, bi-directional communication between the server and client. This ensures that organizations receive immediate updates on leave requests, approvals, and return-to-work dates without constant refreshing or manual checks. Finally, we hosted the app using AWS to ensure the system functions flawlessly even when user groups grow 5000+ or 10000+.
Screenshots
Results
Within a few months of our skilled implementations, we could roll out a highly scalable employee sick leave management app and satisfy our client. Currently catering to 500+ organizations and 10,500+ employees, the app has witnessed a massive adoption that has only deepened our client’s trust in Capital Numbers.
Here’s what our sick leave management app offers its users:
Simplified Leave Logistics
Detailed sick leave reports give organizations 360° visibility into employee absenteeism.
Customizations
Custom workflows help set up leave approval workflows based on organizational hierarchy.
Unified Organizational Visibility
A unified view of all sick leaves across hierarchies helps organizations identify compliances.
Real-time Leave Updates
Real-time leave updates help organizations eliminate delays in decisions or validations.
Document Management
Secure uploads of medical documents or prescriptions further help with sick leave validation.
Integration with Health Services
Integration with clinical teams aids in immediate health checkups for those who need it urgently.
![the Result](/images/case-studies-details/case-study-162/cs162-results.png)
Automated Alerts and Reminders
Automated alerts and reminders on upcoming health checkups reduce missed appointments.
Insightful Absence Information
Information on upcoming/completed checkups allows organizations to track workforce health.
Health and Wellness Tracking
Reliable health checkups allow organizations to focus on employee well-being and recovery.
Return-to-Work Planning
An organized view of completed health checkups helps organizations plan return-to-work dates.
Reduced Disruptions
Systematic return-to-work planning minimizes disruptions to workforce productivity.
Efficient Leave Management
Effective leave management, updating leaves on time, every time, leads to zero mess and stress.
Explore More Case Studies
High-level Road Traffic Management App to Monitor Roads and Reduce Congestion
Technology Stack : Angular, Bing Maps, Kendo UI, TypeScript, Azure DevOps
Learn MoreBuilding Maintenance Ticketing Software to Accelerate Resolution Time
Technology Stack : .NET Core, ASP.NET Razor Views, SQL, MS Azure, Power BI
Learn MoreRFID/Barcode Tracking App to Monitor High-value Assets in Real-time
Technology Stack : Node.js, React.js, MongoDB, AWS, React Native
Learn MoreMulti-tenancy Architecture to Streamline Shopping Mall Management
Technology Stack : ASP.NET Core, JavaScript, HTML, AWS, SQL Server Reporting Services (SSRS)
Learn MoreParking Revenue Management Software to Enforce Accountability
Technology Stack : Laravel, HTML, jQuery, MySQL, Amazon EC2
Learn MoreSaaS-based ERP Application Enhancements and Upgrades
Technology Stack : .NET Core, Angular, Syncfusion, Docker Compose, Kubernetes, MSSQL, MongoDB, MS Azure
Learn More
300+ Glowing Customer Reviews
97 out of 100 Clients Have Given Us a Five Star Rating on Google & Clutch
Get Custom Solutions, Recommendations, Resumes, or, Estimates. Confidentiality & Same Day Response Guaranteed!
Fill Out the Form and We Will Contact You.
What’s Next?
Our Consultants Will Reply Back to You Within 8 Hours or Less
Or, Email Us Your Needs At [email protected]
Expert Guidance You Can Trust. No Pitch, Just Expert Solutions.
+25 More Awards in Past Decade
Frequently Asked Questions
Based on the information provided about Capital Numbers, here arefive frequently asked questions (FAQs) and their answers
We offer a wide range of services, including:
- Digital Engineering: Custom software development, enterprise systems, automation tools.
- Web Development: Dynamic websites, e-commerce platforms, CMS solutions.
- Mobile App Development: iOS & Android apps, cross-platform solutions, app maintenance.
- QA (Quality Assurance): Automated and manual testing for error-free software.
- Cloud Engineering: Cloud migration, cloud infrastructure management.
- Data Engineering & Analytics: Data integration, data warehousing, data visualization, predictive analytics.
- AI/ML/GenAI: AI-driven analytics, machine learning solutions, generative AI applications.
- UI/UX Design: User interface design, prototyping & wireframing.
- Emerging Tech: AR/VR development, blockchain development.
We offer two distinct engagement models:
- Project-Based Development: Tailored solutions for defined goals, ideal for short-term projects.
- Dedicated Development Teams: Seamless integration, scalable solutions for long-term partnerships.
We have clients in various countries, including:
- USA
- UK
- Canada
- Australia
- Ireland
- Switzerland
- Saudi Arabia
- Indonesia
- UAE
- Israel
- Italy
We have received numerous awards, including:
- Clutch Top 1000 B2B Companies
- Financial Times High-Growth Companies
- The Economic Times India's Growth Champions
- Dun & Bradstreet Leading SMEs of India
- Manifest Global Awards
- Clutch Global Leaders
- Clutch Champion Awards
- GoodFirms: Trusted Choice Awards
- GoodFirms: Best Company to Work With
We were founded in 2012.
We are ISO 9001 and ISO 27001 certified, demonstrating quality and data security standards.
We create dynamic websites, e-commerce platforms, and manage content with user-friendly solutions.
We develop iOS & Android apps, cross-platform solutions, and provide ongoing maintenance.
We offer data integration, warehousing, visualization, and predictive analytics for data-driven decisions.
We offer AI-driven analytics, machine learning solutions, and generative AI applications for various needs.
Innovation, quality, client satisfaction, integrity, and teamwork are core values that guide our operations.
We aim to become a global leader in digital solutions, continuously innovating and empowering businesses with cutting-edge technology.