MVNO Hub Renewal

A public-service renewal project that delivered telecom order integration APIs, order-status Kakao AlimTalk notifications, and a 32x Oracle query improvement.

Contracted by an external client, built to their requirements, and delivered through acceptance.

Visit Product

Project Overview

MVNO Hub is a public-facing service for comparing and applying for MVNO plans. As a freelance PL, the project covered live service renewal, user and seller flow improvements, telecom operator order integration APIs, order-status Kakao AlimTalk notifications, and Oracle performance tuning that reduced a critical query from 13 seconds to 0.4 seconds.

Product screens

Archived user home for browsing MVNO plans and starting an online application

Plan search screen for narrowing MVNO plans by data, voice, SMS, and network criteria

Key Challenges

Improving a live public service without destabilizing existing user and seller flows
Resolving inconsistent plan pricing across screens
Reducing a slow Oracle query that increased peak-time server load
Designing real-time order integration APIs for telecom operators

Key Outcomes

Delivered real-time order integration APIs for external telecom operators
Mapped order statuses to Kakao AlimTalk templates with duplicate-send protection
Improved a critical Oracle query from 13 seconds to 0.4 seconds
Handled roughly 150 bug fixes, feature improvements, tests, and delivery tasks

Technologies

JavaSpringOracleRESTful APIKakao AlimTalkGit