Portfolio | ErTab Solution

Portfolio Details

Client: UNDP India
Project year: 2023
Project URL: www.sdg.finhry.gov.in
Description: Designed and developed a data visualization SDG monitoring dashboard, presenting information graphically and in tabular form for easy comprehension. Managed data collection, transformation, and integration into a decision support system. Provided financial and physical performance metrics down to the district level. Developed quick indices to measure and compare SDG performance across districts and departments. Offered a comprehensive overview of state performance on SDGs compared to other Indian states. Integrated APIs for efficient data synchronization across servers.

Client: Vital Pharma
Project year: 2018
Project URL: www.nddtc.in
Description: Designed and developed a data visualized dashboard, presenting information graphically and in tabular form for easy comprehension. Data collection, management and transform into decision support system. Implemented digital printing capabilities for generating invoices related to patient treatment. Hosted the system on a dedicated cloud server, optimizing application and database performance for seamless functionality. Integrated APIs to synchronize data across servers for efficient data management. Ensured ongoing maintenance of the website/portal, allowing for real-time updates and optimal uptime to provide uninterrupted services.

Client: Department of Health and Family Welfare, Government of Punjab
Project year: 2014 - 2021
Project URL: www.pddrc.in
Description: Supported website maintenance by overseeing backups, ensuring uptime, optimizing databases, and debugging application errors. Hosted the application on a dedicated server with load balancing and unlimited bandwidth to effectively manage a user base exceeding 20,000. Regularly updated source code, scripts, and conducted vulnerability assessments to ensure the portal's functionality and security. Developed interactive dashboards for the data analysis, monitoring and planning purpose.

Client: Amardeep Singh Cheema
Project year: 2023
Project URL: www.amardeepsinghcheema.in
Description: Designed and developed a dynamic, responsive website based on a Content Management System (CMS) for political leader Amardeep Singh Cheema. Hosted the website on a dedicated cloud server, optimizing application and database performance for enhanced efficiency. Integrated comprehensive modules to enable interaction with people and incorporated a dynamic alert mechanism for timely communication. Implemented real-time poll posts and result analytics for engaging the audience and gathering insights. Ensured ongoing maintenance of the website, allowing for real-time updates and maintaining optimal uptime for uninterrupted access to the website and its services.

Client: National Health Mission, Government of Punjab
Project year: 2018 - 19
Project URL: www.covid19punjab.in
Description: Developed interactive data driven dashboard for the tracking of patient care, health infrastructure utilization, real-time basis monitoring of oxygen and ventilators, flue corner reports in graphical and tabular form. Supported website maintenance, encompassing tasks such as backups, ensuring uptime, optimizing databases, and debugging application errors. Managed application hosting on a dedicated server, employing load balancing and unlimited bandwidth to effectively handle a user base exceeding 40,000. Regularly updated source code, scripts, and conducted vulnerability assessments to ensure the portal's functionality and security.

Client: State Health Agency, Government of Punjab
Project year: 2019 - 21
Project URL: www.shapunjab.in
Description: Designed and developed a dynamic, responsive website for the State Health Agency of Punjab. Developed an interactive dashboard with data visualisation on beneficiary enrolment, hospital empanelment and treatment cum claim generation. Hosted the website on a dedicated cloud infrastructure, optimizing both application and database performance. Created an advanced beneficiary search module to facilitate eligibility searches. Integrated the beneficiary search module via API with the m-Seva App of the Government of Punjab. Ensured ongoing maintenance of the website, making real-time updates and ensuring uninterrupted uptime of the website and its services.

Client: Guru Nanak Clinical Lab
Project year: 2022
Description: Designed and developed a dynamic, responsive website based on a Content Management System (CMS) for Guru Nanak Clinic Lab. Implemented a comprehensive system for tracking and managing patient lab diagnostics, including printed lab results. Hosted the website on a Virtual Private Server (VPS), optimizing both application and database performance. Integrated comprehensive modules for efficient management of patient registration, billing, stock, lab results, commission, and related functionalities. Ensured ongoing maintenance of the website, allowing for real-time updates and maintaining optimal uptime for uninterrupted access to the website and its services.

Client: Amba Exports
Project year: 2014 - 21
Description: Supported website maintenance, including tasks such as backups, ensuring uptime, optimizing the database, and debugging application errors. Hosted the application on a dedicated server, employing load balancing and unlimited bandwidth to effectively manage the user load.