Charter Global developed an asynchronous batch jobs framework with ETL design principles using Hangfire. This configuration driven framework allowed for the configuration of the source system (SQL Server), target system (PostgreSQL), job execution time (cron expressions), and necessary transformers needed. This framework helped the client consolidate all the operational items spread across various source schemas to the target PostgreSQL database. To ensure high availability, Charter Global suggested docker deployments and assisted the client in doing CI/CD deployments using TeamCity and Jenkins. After the data consolidation, Charter Global developed an Angular-based frontend web tool that was integrated into the
client's system using SSO. To enable quick navigation to necessary operational tasks, Charter Global suggested an IFrame solution approach. The entire solution was developed and tested for WCAG 2.1 AAA standards.