SQL & BI Developer for Enterprise Analytics

SQL DEVELOPER BUSINESS INTELLIGENCE DEVELOPER

Healthcare & Financial Data Warehousing SQL Server SSIS Power BI Yaswanth B

New Haven, CT

Phone: 203-***-**** Email: *****************@*****.*** PROFESSIONAL SUMMARY

• Results-driven SQL Developer and Business Intelligence Developer with nearly 5 years of experience building enterprise data warehouse, ETL, and reporting solutions in healthcare and banking domains.

• Strong expertise in SQL Server (2016–2019), advanced T-SQL programming, query optimization, and performance tuning in high-volume production environments processing millions of records.

• Designed and deployed 20+ Power BI and SSRS dashboards supporting 100+ business users across Finance, Clinical Operations, Compliance, and Executive leadership teams.

• Hands-on experience developing scalable SSIS ETL pipelines with incremental load strategies and designing dimensional data models (star and snowflake schema) to support enterprise analytics and executive-level reporting.

• Improved query performance by 35%+ and enhanced data reliability achieving 99%+ reporting accuracy through validation and reconciliation processes.

• Experienced working in HIPAA-compliant healthcare data environments with strict governance and security standards.

• Strong collaborator in Agile environments, supporting cross-functional business, analytics, and infrastructure teams.

• Trusted resource for delivering data-driven insights supporting executive decision-making and operational strategy.

TECHNICAL SKILLS

Databases Microsoft SQL Server 2016/2017/2019, Azure SQL Database, Oracle 11g/12c SQL & Development T-SQL (Stored Procedures, Views, Functions, Triggers), Query Optimization, Indexing Strategies, Execution Plan Analysis, Performance Tuning ETL & Data

Integration

SSIS (Control Flow, Data Flow, Script Task, Event Handlers), Incremental Loads, Data Validation, Logging Frameworks, Batch Processing Business Intelligence

& Reporting

Power BI (Desktop & Service), DAX, Row-Level Security (RLS), SSRS, Tableau Data Modeling Dimensional Modeling, Star Schema, Snowflake Schema, Data Mart Architecture

Tools & Platforms SSMS, Visual Studio, SSDT, Azure DevOps, Git, TFS Concepts Enterprise Data Warehousing (EDW), OLTP/OLAP, Healthcare Claims Analytics, Regulatory Reporting, Production Support PROFESSIONAL EXPERIENCE

BlueCross BlueShield, Catonsville, MD

SQL Developer Business Intelligence Developer Jan 2025 – Present Project: Enterprise Healthcare Claims & Finance Reporting (EDW Environment)

• Design, maintain, and enhance enterprise data warehouse (EDW) solutions supporting mission- critical healthcare reporting.

• Develop complex T-SQL stored procedures and optimized queries handling 5M+ healthcare claim records daily.

• Improve report performance by 35%+ through index tuning, query refactoring, and execution plan optimization.

• Build and maintain scalable SSIS ETL pipelines integrating data from SQL Server, Oracle, and Azure environments.

• Implement incremental load strategies reducing ETL batch processing time by 25%.

• Develop and deploy 15+ interactive Power BI dashboards used by Finance, Clinical Operations, Compliance, and executive leadership.

• Create advanced DAX measures, KPIs, drill-through reports, and row-level security (RLS) models.

• Automate dataset refreshes using Power BI Gateway and manage secure role-based access controls.

• Develop SSRS reports supporting regulatory and operational reporting requirements.

• Perform data reconciliation between source claims systems and EDW ensuring 99%+ reporting accuracy.

• Support UAT, production deployments, and issue resolution in a HIPAA-compliant healthcare environment.

Environment: SQL Server 2019, SSIS, SSRS, Power BI, Azure SQL, Oracle 12c, DAX, Azure DevOps Tata Consultancy Services (TCS), Stamford, CT

SQL ETL Developer Jul 2024 – Dec 2024

Project: Healthcare Data Warehouse Stabilization & ETL Optimization

• Enhanced and optimized SSIS ETL workflows supporting enterprise healthcare reporting systems.

• Reduced ETL batch runtime by 20% through improved indexing strategies and optimized join logic.

• Designed staging and data mart layers using dimensional modeling best practices.

• Developed SQL validation and reconciliation scripts to identify and resolve data discrepancies.

• Built optimized SQL views supporting BI and reporting teams across departments.

• Implemented logging and error-handling frameworks improving ETL reliability and monitoring.

• Resolved critical production data load failures under tight SLAs.

• Collaborated with onsite and offshore teams within Agile sprint cycles supporting enterprise reporting initiatives.

Environment: SQL Server 2017/2019, SSIS, T-SQL, Power BI, Azure DevOps HDFC Bank, India

SQL Developer BI Developer May 2020 – Aug 2023

Project: Retail Banking Data Warehouse & Reporting Platform

• Designed and developed SSIS ETL workflows consolidating transactional and customer data into centralized data marts.

• Built fact and dimension tables supporting sales performance, customer analytics, and risk reporting.

• Developed complex stored procedures, views, and reconciliation queries for regulatory and operational reporting.

• Created 20+ SSRS and Power BI reports used by 100+ business stakeholders across sales and finance teams.

• Improved SQL query efficiency through index optimization and execution plan analysis.

• Supported high-availability reporting databases including backup and recovery processes.

• Provided ongoing production support in a high-volume banking environment ensuring business continuity.

Environment: SQL Server 2016, SSIS, SSRS, Power BI, Oracle 11g, T-SQL EDUCATION

Master of Science in Computer Science

University of Bridgeport, CT

Contact this candidate