Summary
Overview
Work History
Education
Skills
Timeline
Generic

Pushpdant Goswami

Ahmedabad

Summary

SQL Developer with 2+ years of hands-on experience in SQL Server database optimization, complex query development, SSRS reporting, and ETL processes. Strong background in healthcare EHR/RCM data, data validation, and performance tuning in production environments. Proven ability to translate business requirements into efficient, reliable database and reporting solutions.

Overview

3
3
years of professional experience

Work History

SQL Developer /Administrator

OmniMD Healthcare IT solution
ahmedabad
06.2023 - Current
  • Optimized SQL Server database performance using indexing, query tuning, and execution plan analysis, reducing query response times in production environments.
  • Designed and executed complex SQL queries and stored procedures to extract and transform data across multiple databases.
  • Worked closely with stakeholders to analyze data and reporting requirements, converting business needs into efficient database solutions.
  • Implemented and supported ETL processes, including data cleansing, transformation, and loading into internal databases.
  • Performed data quality checks and validation to ensure accuracy, integrity, and consistency of production datasets.
  • Provided production database support, troubleshooting query failures, performance issues, and data inconsistencies.
  • Developed and maintained complex SSRS parameterized reports as per client and internal business requirements.
  • Enhanced existing SSRS reports by optimizing queries and layouts to improve performance and usability.
  • Ensured report accuracy and reliability through rigorous data validation and reconciliation checks.

Education

Bachelor of Engineering - CSE

Kalol Institute of Technology And Research Center
Gandhinagar
07-2023

Skills

TECHNICAL SKILLS

Database & SQL Server

  • SQL Server (Query Optimization, Indexing, Execution Plans)
  • Stored Procedures, Functions, Triggers
  • Backup & Restore (Full, Diff, Log)
  • HA/DR (Replication, Log Shipping – working knowledge)

Reporting & ETL

  • SSRS (Parameterized Reports, Tabular & Summary Reports)
  • Data Migration & ETL (Data Cleansing, Validation, Transformation)
  • Production Data Validation

Administration

  • User Roles & Security Management
  • Daily Server Monitoring (Space, Performance, Jobs)
  • Windows to Linux Server Migration (Database-level support)

Domain Knowledge

  • Healthcare EHR / RCM
  • Healthcare IT(patients, appointments, medication,provider Etc data)
  • Payments, Copay, Adjustments, Claims Logic

Timeline

SQL Developer /Administrator

OmniMD Healthcare IT solution
06.2023 - Current

Bachelor of Engineering - CSE

Kalol Institute of Technology And Research Center
Pushpdant Goswami