Brief: I supported and enhanced an operator-grade OTA (over-the-air) platform that manages customers’ SIM/eSIM life cycle, handles SIM and number changes, delivers APN settings to devices, updates SIM menu items and services, and sends targeted pop-up notifications. The work combined hands-on technical support with ongoing development, plus day-to-day operations on Linux servers and database use.

The platform centralizes key subscriber operations: new SIM provisioning and activation, routing and validation during SIM swaps and number (MSISDN) changes, secure delivery of APN configuration to devices, remote updates to SIM Toolkit menus and lightweight services, and pop-up/flash messaging for important announcements. My role covered both the operational side (keeping the system healthy, measurable, and predictable) and product side (making flows simpler and more reliable).

SIM Provisioning: Activate new SIM/eSIMs, map subscriber identifiers, and apply service flags as part of the life-cycle.

SIM Swap & Number Change: Detect and route SIM or number changes, re-associate dependent services, and keep systems in sync.

APN Settings Delivery: Send the correct APN/Proxy/MMS settings to devices using standardized templates; fallbacks for different device types.

SIM Menu & Service Management: Update or toggle SIM menu entries and short services remotely to reflect new offers or rules.

Pop-Up / Flash Messaging: Deliver targeted informational pop-ups with frequency and audience controls.

Linux server care: service checks, log rotation, backups, planned updates, and basic hardening.

Bash scripting: automation for daily jobs, health checks, simple reports, and recurring operational tasks.

Database usage: MySQL and Oracle for maintenance and reporting—index checks, performance sanity checks, and data archiving policies.

KPIs & reporting: track job success rate, queue load, average delivery time, and system availability; simple dashboards and weekly summaries.

Back end: Java services for core flows and scheduled jobs.

Front end: Angular-based admin interface for campaigns, menus, APN templates, and monitoring.

Infrastructure: Linux servers, lightweight automation with Bash, basic versioning and CI.

Databases: MySQL & Oracle for history, subscriber/SIM relations, and configuration templates.

Partnered with the customer’s operations team for issue investigation and root-cause analysis, then automated repetitive steps with Bash scripts.

Simplified and stabilized Java workflows; delivered small UI improvements in Angular to make daily tasks easier.

Wrote ad-hoc reporting queries and minor optimizations on MySQL/Oracle; introduced practical KPI tracking so teams could see progress at a glance.

Clarified runbooks and internal notes to reduce hand-offs and speed up incident handling.

More consistent outcomes in provisioning and change scenarios, with fewer manual interventions.

Faster, centrally controlled updates for APN settings, menus, and pop-ups.

Time saved in daily operations through scripting and clearer visibility via basic metrics.

Confidentiality: Client identities and data are anonymized; details are generalized per NDA and policy.