Ranjith Gomasa
SQL / PL SQL Developer | Data Analyst
Hyderabad,TG
Summary
Oracle SQL & PL/SQL Developer with 2.5+ years of hands-on experience in developing, enhancing, and supporting enterprise Hospital Management Systems. Specialized in SQL performance tuning, PL/SQL programming, reporting, dashboards, and live production support. Proven ability to deliver scalable solutions across multiple healthcare modules.
Overview
2
2
years of professional experience
Work History
Software Developer
Shivam Medisoft Services Pvt. Ltd
Hyderabad
11.2023 - Current
- Developed and optimized complex SQL queries to meet client and business reporting requirements.
- Built PL/SQL business logic using procedures and functions for billing, financial calculations, and operational workflows.
- Implemented high-volume DML operations (insert/update/delete) using Bulk Collect and FORALL to improve performance.
- Designed audit and backup triggers to maintain data integrity and compliance.
- Performed data migration and validation, ensuring accurate source-to-target reconciliation.
- Created daily, monthly, and bulk reports using SQL, PL/SQL, Jasper Reports, and Excel.
- Designed and delivered operational and management Reception, Billing, Ward Nurse, Purchase, Pharmacy, Financial dashboards.
- Scheduled background jobs and implemented SMS, Email, and WhatsApp notifications.
- Provided production support, debugging live issues and delivering quick resolutions with minimal downtime.
- Implemented data validations and custom error handling using PL/SQL.
- Collaborated with cross-functional teams using Jira in Agile environments.
Education
Bachelor of Technology - Electrical And Electronics Engineering
08-2023
Skills
- SQL and PL/SQL development
- Data analysis and modeling
- Data Integration & Validation
- Data analytics for healthcare insights
- ETL pipeline development
- Power BI
- SAS
- Unix
- Python
- Pandas
- Numpy
- UI Architect
- Advanced Excel proficiency
- Jasper Reports
- Postman
- Jira
Key Projects And Achievements
- Played a key role in the implementation and support of a centralized Hospital Management System across multiple hospitals, supporting clinical, operational, and financial workflows.
- Owned backend development for critical modules including Reception, OP, IP, Lab, Pharmacy, Purchase, Doctor Pay, and Accounts, ensuring smooth end-to-end data flow.
- Successfully optimized high-volume batch jobs by redesigning PL/SQL logic using Bulk Collect and FORALL, improving execution performance and system stability.
- Designed and implemented audit logging and backup mechanisms to ensure compliance and traceability of transactional data.
- Led data migration and onboarding activities for new hospital clients, including data validation, reconciliation, and issue resolution.
- Delivered role-based dashboards for operational teams and management, improving visibility into billing, pharmacy, ward, and financial operations.
- Supported live production environments, resolving critical issues with minimal downtime and ensuring uninterrupted hospital operations.
- Contributed to successful go-live and ongoing support for hospitals such as Sahyadri Super Speciality Hospitals, Bhagawan Mahaveer Cancer Hospital, Breach Candy Hospital, and Ujala Cygnus Hospitals.
Timeline
Software Developer - Shivam Medisoft Services Pvt. Ltd
11.2023 - Current
Vignana Bharathi Institute of Technology - Bachelor of Technology, Electrical And Electronics Engineering