Dhrupa Gurjar

Dhrupa Gurjar

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

نبذة عني

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…

الخبرة

Associate Systems Analyst

Altera Digital Health
Mar 2022 - Jan 2026 · 3 سنوات 10 أشهر

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 سنوات 10 أشهر

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 سنوات 6 أشهر

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 سنوات 5 أشهر

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.

المهارات

لغة C# التوثيق لغة الاستعلامات الهيكلية (SQL) خادم SQL إصلاح الأخطاء مراجعات الشفرة قاعدة البيانات استخراج البيانات هجرة البيانات التحقق من البيانات مؤشر الأداء الرئيسي (KPI) MLM التسوية خدمات تكامل SQL Server خدمات تقارير SQL Server تي إس كيو إل إدارة الدواء ضبط الأداء 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
الإبلاغ عن هذا الملف الشخصي؟