Sonali Limbasiya

Oracle APEX Developer with 4+ years of experience building enterprise web applications, migrating Oracle Forms to APEX, and integrating REST/SMS APIs. Currently working as Senior Oracle APEX Developer at BeyonData Solutions, independently leading production applications for GTPL Broadband and Cable TV. Recognised with the Customer Champion Trophy and a Certificate of Appreciation by BeyonData Solutions in June 2026 for outstanding delivery on the GTPL project.

Senior Oracle APEX Developer - BeyonData Solutions Pvt. Ltd. - Ahmedabad

(2023-08)

Project: GTPL Broadband & Cable TV Application. Solely responsible for leading and managing the GTPL Broadband & Cable TV application — the company's most critical client project — handling all new requirements, code reviews, bug fixes, and production releases end to end.

• Designed and developed a multi-module application covering broadband service requests, cable TV subscriptions, customer complaint tracking, and field engineer task management.
• Built department-wise multi-level approval and rejection workflows with role-based access control, ensuring only authorised users can process or escalate requests at each stage.
• Automated email alerts using UTL_SMTP and ORDS so relevant teams receive notifications instantly when a request is raised, approved, rejected, or escalated — reducing manual follow-ups significantly.
• Integrated REST API and SMS API for real-time data exchange with external systems and instant SMS notifications to customers on service updates and complaint resolution.
• Developed a wide range of analytical reports and dashboards — subscription trends, area-wise complaint heatmaps, SLA breach alerts, engineer productivity — giving management clear visibility into operations.
• Used APEX Data Load Definitions to handle bulk data imports (customer records, plan changes, area mappings) with built-in validation rules, error logging, and rollback support.
• Integrated APEX OFFICE PRINT for professional PDF report generation and used Jasper Reports for complex formatted outputs required by the client.
• Worked closely with the GTPL team and BeyonData management to gather requirements, translate business needs into technical solutions, and demo new features — building strong client trust.
• Proactively identified and resolved performance bottlenecks in PL/SQL procedures and SQL queries, improving page load times and report generation speed noticeably.

System Analyst / Oracle APEX Developer - WAY2CIS LLP - Ahmedabad

(2022-05 - 2023-08)

• Project 1: DSP-Explorer (Wienland & Landmark) — Forms Migration. Migrated Oracle Forms 6i / 10g / 11g / 12c to Oracle APEX 22.1 and Oracle Reports to APEX Reports. Redeveloped legacy screens with a modernised UI using Universal Theme; upgraded applications from APEX 19.1 to 22.1.
• Project 2: Purchase & Sales ERP Modules. Developed Purchase Cycle, Sales Cycle, Inventory, and Finance modules within a customised ERP application built on APEX 20.1. Maintained Views, Packages, Procedures; handled live customer bug fixes and delivered new features as per client requirements.
• Project 3: Trinamix Inc – Claims Management (Wonderful Fruit Co.). Built report-with-form pages controlling the full Claim Approval Cycle across multiple workflow statuses. Handled new development, bug fixes, Views, Interfaces, Packages, and Procedures on a live production application.

Oracle APEX Developer (Freelance) - Private Client — Restaurant Industry - Remote

(2023-01 - 2024-12)

• Project: Point-of-Sale (POS) Application for a Restaurant Chain. Designed and built a complete POS application in Oracle APEX independently for a restaurant client, covering order management, table assignments, billing, KOT generation, inventory deduction, and daily sales reports.
• Wrote all backend logic from scratch — packages, procedures, triggers, functions, cursors, and dynamic SQL — handling the full order-to-payment flow with proper transaction control.
• Integrated email notification system using APEX_MAIL for customer order confirmations and client support communication.
• Designed and built the complete dashboard and UI — daily revenue summary, table-wise status board, popular items chart, and shift-end reports — with a clean interface optimised for fast use by restaurant staff.
• Handled everything independently: requirement gathering, database design, development, testing, and final handover to the client.
• Project: Live Server Monitoring Dashboard (Internal Tool — OCI). Designed and built an internal real-time server health monitoring dashboard using Oracle APEX, pulling live data from the Oracle database and ORDS endpoints.
• Dashboard displays: tablespace usage per server, server up/down status, ORDS service status, count of active workspaces, and total number of applications running per workspace — all refreshing automatically.
• Configured instant alert notifications (email + on-screen) that trigger the moment ORDS goes down or a server becomes unreachable, enabling the team to respond before clients are affected.
• Deployed and hosted entirely on an OCI Free Tier account — set up compute instance, ORDS configuration, and APEX workspace from scratch with no additional infrastructure cost.
• This tool is now actively used by the team to monitor all client environments in one place, replacing manual server checks that were being done previously.

BCA - Bachelor of Computer Application - Chimanbhai Patel Institute, Ahmedabad (2022)