Dhrupa Gurjar

Dhrupa Gurjar

Data Analyst with 4+ years of experience in SQL Server and large-scale
India
Gujarati, Hindi, English

About Me

Senior Data Analyst with 4+ years of experience working on healthcare IT systems, focused on SQL Server–based reporting, analytics, and clinical decision support. Strong expertise in SSRS and Power BI, advanced SQL devel…

Experience

Associate Systems Analyst

Altera Digital Health
Mar 2022 - Jan 2026 · 3 years 10 months

Built and supported 150+ SSRS reports across clinical and operational workflows used by end users, managers, and directors.
Wrote and maintained complex SQL Server stored procedures and queries supporting reporting and analytics on large healthcare datasets.
Reduced report execution time by 30–40% through query restructuring, indexing updates, and execution plan review.
Led 8-member reporting team, handling task planning, review, and delivery, with 100% on-time delivery across multiple release cycles.
Developed 10+ Power BI dashboards for KPI tracking, compliance monitoring, and operational reporting.
Worked extensively with Sunrise Clinical Manager modules including Orders, Clinical Documentation, and Medication Administration.
Designed and maintained advanced Arden Syntax (MLM) logic for clinical validations and alerts, including newborn screening and immunization use cases.
Regularly joined calls with US-based directors, managers, clinicians, and QA teams to review requirements, clarify logic, and walk through reporting outputs.
Performed data validation and reconciliation across multiple systems to confirm accuracy before release.
Supported production issues related to reports, SQL logic, and data mismatches, ensuring minimal disruption to users.

Associate Systems Analyst

Altera Digital Health
Mar 2022 - Jan 2026 · 3 years 10 months

Built and supported 150+ SSRS reports across clinical and operational workflows used by end users, managers, and directors., Wrote and maintained complex SQL Server stored procedures and queries supporting reporting and analytics on large healthcare datasets., Reduced report execution time by 30–40% through query restructuring, indexing updates, and execution plan review., Led 8-member reporting team, handling task planning, review, and delivery, with 100% on-time delivery across multiple release cycles., Developed 10+ Power BI dashboards for KPI tracking, compliance monitoring, and operational reporting., Worked extensively with Sunrise Clinical Manager modules including Orders, Clinical Documentation, and Medication Administration., Designed and maintained advanced Arden Syntax (MLM) logic for clinical validations and alerts, including newborn screening and immunization use cases., Regularly joined calls with US-based directors, managers, clinicians, and QA teams to review requirements, clarify logic, and walk through reporting outputs., Performed data validation and reconciliation across multiple systems to confirm accuracy before release., Supported production issues related to reports, SQL logic, and data mismatches, ensuring minimal disruption to users

Software Engineer

I-Engineering Software Pvt. Ltd.
Sep 2019 - Mar 2022 · 2 years 6 months

Developed backend business logic and Web API integrations for a US insurance rating middleware platform.
Worked on SQL query writing, optimization, and data migration tasks supporting backend performance and data accuracy.
Assisted with production support, investigating application and database issues in live environments.
Participated in code reviews and fixes to improve stability and maintainability.

Software Engineer

I-Engineering Software Pvt. Ltd.
Sep 2019 - Mar 2022 · 2 years 5 months

Developed backend business logic and Web API integrations for a US insurance rating middleware platform., Worked on SQL query writing, optimization, and data migration tasks supporting backend performance and data accuracy., Assisted with production support, investigating application and database issues in live environments., Participated in code reviews and fixes to improve stability and maintainability.

Skills

C# Documentation Structured Query Language (SQL) SQL Server Bug Fixes Code Reviews Database Data Extraction Data Migration Data Validation Key Performance Indicator (KPI) MLM Reconciliation SQL Server Integration Services (SSIS) SQL Server Reporting Services (SSRS) T-SQL Medication Administration Performance Tuning Stored Procedures Query Optimization Indexing Execution Plan Review Large Healthcare Datasets RDL Sub-Reports Drill-Through Parameters Subscriptions Power BI Dashboards Operational Reporting Data Transformation Backend Data Analysis Production Data Support Arden Syntax Rule-Based Validations Clinical Alerts Decision Support Logic Immunization Reminders Clinical Workflows Sunrise Clinical Manager Orders Regulated Healthcare Data Direct Communication with US Directors & Managers Requirement Discussions Reporting Walkthroughs Status Updates Cross-Team Coordination API Integration Support Power BI Dashboards KPI Reporting Data Reconciliation Arden Syntax (MLM) API Integration
Report this Profile?