Ranjith Gomasa
Software Developer
Hyderabad,TG
Summary
SQL/PLSQL Developer with 2 years of experience in hospital management software and healthcare analytics. Demonstrated expertise in SQL and PL/SQL programming, data modeling, and business intelligence solutions using Power BI. Achievements include optimizing queries and automating workflows, leading to enhanced patient care and improved resource allocation. Committed to leveraging technical skills to drive innovative solutions in the healthcare sector.
Overview
2
2
years of professional experience
Work History
Software Developer
Shivam Medisoft Services Pvt. Ltd
Hyderabad
11.2023 - Current
- Designed, tuned, and optimized SQL queries, indexes, stored procedures, and triggers, improving data retrieval speed by 30-40%.
- Built end-to-end Power BI solutions including data modeling, DAX measures, and interactive dashboards for hospital operations, finance, and clinical departments.
- Collaborated with stakeholders (doctors, finance managers, admin teams) to gather requirements and deliver role-based dashboards for admissions, billing, claims, and resource utilization.
- Implemented Row-Level Security (RLS) in Power BI ensuring secure access for different hospital departments.
- Automated recurring MIS and compliance reports using Excel VBA & SQL scripts, reducing reporting time by 50%.
- Designed and maintained ETL pipelines integrating hospital data from multiple sources (patient management, billing, labs).
- Conducted data validation and quality checks ensuring accuracy and reliability of clinical and financial data.
- Created ad-hoc SQL reports for doctors and management, supporting quick decision-making in high-priority cases.
- Documented workflows and trained junior analysts and business users on Power BI dashboards and SQL best practices.
Education
Bachelor of Technology - Electrical And Electronics Engineering
Vignana Bharathi Institute of Technology
Hyderbad08-2023
Skills
- SQL and PL/SQL development
- Data analysis and modeling
- Data Integration & Validation
- Power BI data visualization
- DAX measure development
- Data analytics for healthcare insights
- Advanced Excel proficiency
- ETL pipeline development
- Jasper Reports
- Python
- Unix
- Jira
Key Projects And Achievements
- Hospital Analytics Dashboard - Built Power BI dashboards for patient flow, OP/IP statistics, billing, and revenue analysis, enabling real-time KPI tracking.
- Clinical Resource Utilization Report - Developed SQL queries and Power BI reports for bed occupancy, doctor consultations, and lab usage, improving hospital resource planning.
- Financial & Claims Dashboard - Automated reporting for insurance claims, billing, and outstanding payments in Power BI, enhancing finance team productivity.
- Patient Admission & Discharge Trends - Created predictive Power BI reports to analyze patient inflow/outflow trends, supporting hospital capacity planning.
- Medical Inventory & Pharmacy Dashboard - Designed SQL and Power BI solutions to track medicine stock, usage patterns, and reorder alerts, reducing shortages.
- Doctor & Staff Performance Reports - Built dashboards measuring consultations, case turnaround time, and workload distribution for operational efficiency.
- Self-Service BI Portal - Enabled hospital managers to independently generate reports, boosting analytics adoption by 20%.
- Automation of Data Imports - Automated patient and billing data imports with Excel macros & Unix scripts, saving 12+ hours per week.
Timeline
Software Developer
Shivam Medisoft Services Pvt. Ltd
11.2023 - Current
Bachelor of Technology - Electrical And Electronics Engineering
Vignana Bharathi Institute of Technology
Similar Profiles
B. PRIDHVI RAJB. PRIDHVI RAJ
SENIOR BUSINESS DEVELOPMENT MANAGER/CHANNELPARTNER at Shivam Medisoft Services Pvt LtdSENIOR BUSINESS DEVELOPMENT MANAGER/CHANNELPARTNER at Shivam Medisoft Services Pvt Ltd
BONAM NAVEENBONAM NAVEEN
Deputy General Manager (MARKETING) at SHIVAM MEDISOFT SERVICES PVT LTDDeputy General Manager (MARKETING) at SHIVAM MEDISOFT SERVICES PVT LTD
roopa alakuntaroopa alakunta
Quality Assurance Engineer at Shivam Medisoft Services Pvt Ltd,Quality Assurance Engineer at Shivam Medisoft Services Pvt Ltd,
Keerthi Suman VKeerthi Suman V
Senior Support Engineer at Goldman SachsSenior Support Engineer at Goldman Sachs
NAGAJYOTHI MARAGONINAGAJYOTHI MARAGONI
Senior Associate Technical Support at Tech MahindraSenior Associate Technical Support at Tech Mahindra