Rani Balina
Pittsburgh
Summary
Accomplished SQL Developer at Highmark Health with expertise in optimizing complex queries and enhancing database efficiency. Proficient in SQL and performance tuning, I excel in delivering accurate, auditable datasets for regulatory reporting. A collaborative team player, I effectively translate business requirements into impactful data solutions, ensuring high data integrity and compliance.
Overview
7
7
years of professional experience
Work History
SQL Developer
Highmark Health
Pittsburgh
10.2023 - Current
- Designed, developed, and optimized complex SQL queries, views, and stored procedures to support healthcare analytics, reporting, and operational use cases across claims, members, and provider data.
- Worked extensively with large healthcare datasets (claims, eligibility, enrollment, provider, and clinical reference data), ensuring high data accuracy and consistency for downstream reporting and analytics.
- Built and maintained SQL-based data extraction and transformation logic, enhancing reporting capabilities and ensuring compliance with requirements.
- Performed query performance tuning using indexing strategies, execution plan analysis, and query refactoring, reducing report run times and improving overall database efficiency.
- Developed data validation and reconciliation queries, ensuring data integrity across source systems and proactively resolving discrepancies.
- Collaborated closely with business analysts, data analysts, and reporting teams to translate healthcare business requirements into efficient SQL solutions.
- Supported regulatory and compliance reporting by delivering accurate, auditable datasets aligned with healthcare standards and internal governance policies.
SAS Programmer
BioPlus Life Sciences
Bangalore
11.2018 - 12.2021
- Annotating CRF based on SDTM mapping as a part of SDTM Submission.
- Develop SDTM data mapping and create SDTM datasets as per CDISC standards for FDA.
- Developed the SDTM datasets like Demographics (DM), Comments (CO), Adverse Events (AE), Subject Elements (SE), Subject Visits (SV), Exposure (EX), Laboratory Test Results (LB), Medical History (MH), Vital Signs (VS), Disposition (DS).
- Performed ADaM datasets (ADSL, ADAE, ADLB, ADVS, ADDS and ADEX) from SDTM data sets according to CDISC ADaM guidelines.
- Prepared Safety Tables, Listings and Graphs (TLG) for Clinical Trial Report and associated Analysis Datasets.
- Developed, modified, validated and implemented SAS programming tasks per Statistical Analysis Plan (SAP).
- Performed data analysis and statistical analysis, generating reports, listings, and graphs using SAS/BASE, SAS/MACRO, SAS/GRAPH, and SAS/SQL.
- Create SAS output report to RTF, PDF format using Output Delivery System (ODS).
Education
Master’s - information assurance
WILMINGTON UNIVERSITY
DE, USA01.2023
M.Pharmacy -
SIR. C.R.R COLLEGE OF PHARMACY
India01.2018
B. Pharmacy -
SIR. C.R.R COLLEGE OF PHARMACY
India01.2016
Skills
- SQL
- T-SQL
- Stored Procedures
- Views
- CTEs
- Performance Tuning
- Query Optimization
- Data Governance
- ETL Processes
- Data Integration
- Data Quality
- DAX
- Power Query M
- Data Modeling
- Data Reporting
- Data Visualization
- Business Intelligence
- Automated Reporting
- Dynamic Reporting
- Dashboard Development
- Python
- Git
- Postman
- Scrum Methodology
- Statistical Analysis
- Software Development
- Scrum Methodology
- Software Development
Languages
- Python
- SQL
- DAX
- Power Query M
- Git
- Postman
Locations
- Pittsburgh, PA
- Bangalore, Karnataka
- Wilmington, DE
Websites
Timeline
SQL Developer
Highmark Health
10.2023 - Current
SAS Programmer
BioPlus Life Sciences
11.2018 - 12.2021
Master’s - information assurance
WILMINGTON UNIVERSITY
M.Pharmacy -
SIR. C.R.R COLLEGE OF PHARMACY
B. Pharmacy -
SIR. C.R.R COLLEGE OF PHARMACY