Case Study

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.

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.

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