Introduction

A leading Canadian telecommunications provider (the Client) faced significant challenges maintaining accurate and up-to-date customer address and location data. This hindered efficient order processing and customer service. MJBTech partnered with the Client to implement a comprehensive address management solution in three phases, improving data accuracy, streamlining processes, and enabling future growth.

Phase 1: Falcon Premise Management System & Location PDS (1.5 Years, 7 Resources)

• Challenge:Maintaining accurate and up-to-date customer address and location information across Canada.
• Solution:Developed a centralized address management system using Oracle 11g and PL/SQL.
• Activities:
  • Processed premise count data for various Canadian communities.
  • Designed and implemented PL/SQL scripts for data management tasks.
  • Automated support processes, reducing manual effort and errors.
• Outcome:Established a central repository for accurate location data accessible by various Client applications.

Phase 2: Address Management Suite Version 1-AMS V1 (3 Years, 7 Resources)

• Challenge:Deliver a new solution to manage addresses efficiently and meet diverse stakeholder needs.
• Solution:Developed AMS V1, a suite of RESTful APIs using Java/j2EE, Spring Boot, MyBatis, and Tomcat.
• Activities:
• Integrated AMS V1 with various downstream systems using RESTful APIs.
• Ensured consistent and accurate address data across Client systems.
• Outcome:Achieved seamless integration with downstream systems, enabling consistent address data management. Developed 30 APIs.

Phase 3: Address Management Suite Version 2-AMS V2 (2 Years, 7 Resources)

• Challenge:Migrate AMS V1 to a cloud-based platform for improved scalability and performance.
• Solution:Migrated AMS V1 to Google Cloud Platform (GCP) using Node.js, Express.js, and PostgreSQL.
• Activities:
• Upgraded the system to use cloud-based location services.
• Expanded and adjusted the GIS database for the transition to GCP.
• Migrated AMS-V1 Java APIs to Node.js applications.
• Outcome:Successfully migrated AMS V1 to GCP, optimizing performance and scalability for future growth. Migrated 40 APIs to the cloud.

Additional Project: CLLI Automation Solution (1 Year, 5 Resources)

• Challenge:Manual CLLI (Canadian Location Level Identifier) creation process in a core system.
• Solution:Developed a front-end application to capture CLLI requests and automate their creation within the system. Also exposed APIs for external systems.
• Activities:
• Built a front-end app to capture CLLI requests.
• Automated CLLI creation process within the core system.
• Developed APIs for external systems to create CLLI entries.
• Outcome:Streamlined CLLI creation process, eliminating manual tasks and enabling automated creation from external systems. Developed 30 APIs and 25 UI screens.

MJBTech's collaboration with the Client resulted in a robust address management solution. This solution improved data accuracy, streamlined workflows, and facilitated future growth for the Client. The project showcases MJBTech's expertise in developing scalable, cloud-based solutions that address critical business challenges in the telecommunications industry.