Home

Bhushan - SQL Developer OR Data Engineer (SQL Server, SSIS, Azure, Healthcare)

[email protected]

Location: Dallas, Texas, USA

Relocation: Yes

Visa: H1B

BHUSHAN CH [email protected] 469-352-9550 HIGHLIGHTS: Over 13+ years of IT experience in healthcare, insurance, Retail, and energy domains. Strong expertise in SQL Server, SSIS, Azure Data Factory, and Power BI for end-to-end data engineering, analytics, and governance solutions. Designed and developed SSIS ETL pipelines to process healthcare eligibility (834), claims (837), and accumulator data, performed validation checks, and automated FTP/SFTP file transfers to securely deliver outbound extracts to business partners in compliance with HIPAA standards. Built and optimized SSIS workflows for Foot Locker retail systems to integrate POS, eCommerce, and inventory data into the enterprise data warehouse, applying performance tuning, incremental loads, and reconciliation processes to ensure accurate sales and inventory reporting. Strong focus on Data Engineering challenges, leading and architecting projects in Cloud technologies with a business-oriented mindset Familiarity with Power BI tools suite including Power BI desktop, Power BI Service, Power Apps, Report Builder (Paginated Reports), Power Automate, Power BI Gateways, Power BI Embedded, and Power BI mobile, Rest API. Developed dynamic DAX measures to calculate total sales, year-over-year growth, and month-to-date performance across multiple Footlocker stores. Starting requirement gathering for Report/data modeling to Production support Hands-on experience with data modeling, governance, data cataloging, and lineage tracking. Adept at translating business requirements into actionable data solutions ensuring compliance with HIPAA and CMS interoperability standards. Skilled in integrating healthcare data sources for claims, member eligibility, provider, and value-based care domains ensuring HIPAA compliance HL7 standards. PROFESSIONAL SUMMARY: Experienced in Data Engineering, SQL, SQL Server, ETL and Power BI Developer, with a proven record of designing and delivering robust, scalable, and compliant data solutions. Extensive hands-on experience in data architecture, cloud integration (Azure), automation, and performance optimization. Specialized in SQL Server-based ecosystems and Microsoft BI stack with deep knowledge of healthcare, Retail and insurance data management. KEY SKILLS AND TECHNOLOGIES: BI Tools: MSBI (SSIS, SSRS), Power BI Desktop, Power BI Service, Power Automate Databases: SQL Server (2005 2017), Azure SQL Database, Snowflake Data Warehouse Query Tools: SQL Server Management Studio (SSMS), SQL Data Tools (SSDT), MS Access, Teradata SQL Assistant, Rapid SQL, PL/SQL Developer ETL Tools: SQL Server Integration Services (SSIS), PowerCenter, Azure Data Factory (ADF) Reporting Tools: SQL Server Reporting Services (SSRS), Power BI Programming Languages: T-SQL, PL/SQL, ASP.NET, VB.NET, C, C++ Other Tools & Domains: SQL Server Agent, ActiveBatch, Git, HealthRules Payor (HRP), Claims Processing, Value-Based Care (VBC), Member Eligibility, Payer Files, Accumulators (HIPAA and HL7 guidelines) EDUCATION: Bachelor of Engineering (B.E.) from Osmania University, 2008 PROFESSIONAL EXPERIENCE: Company: FootLocker June 2025 Till Now Sr SSIS Developer/SQL Developer Roles and Responsibilities: Gathered and analyzed business requirements from merchandising, store operations, and finance teams; documented BRD/FRD and translated retail KPIs into ETL and reporting solutions. Facilitated requirement workshops with cross-functional stakeholders and converted retail needs into functional specifications for BI and ETL teams. Built end-to-end SSIS packages integrating transactional systems, merchandising databases, POS, eCommerce, and inventory systems into the data warehouse. Designed and implemented SSIS Control Flow and Data Flow components including Lookup, Merge Join, Conditional Split, Derived Column, and Slowly Changing Dimension (SCD) transformations. Developed parameterized and reusable SSIS packages using Project Deployment Model with environments for Dev, QA, and Production deployments. Implemented SSIS performance tuning techniques such as optimized buffer sizing, minimized blocking transformations, staging tables, parallel processing, indexing, and data partitioning to improve large-volume data loads. Designed and implemented RESTful API integrations to interact with SQL Server databases, enabling seamless data exchange between web applications and backend systems using stored procedures and parameterized queries. Automated ETL scheduling and monitoring using SQL Server Agent with failure alerts, retry logic, logging, auditing, and error handling to ensure reliable production execution. Performed data validation, reconciliation, and quality checks between source systems and data warehouse layers to maintain data accuracy and integrity. Developed and optimized complex T-SQL stored procedures, views, and queries for sales, inventory, and customer analytics processing. Monitored long-running queries using execution plans and optimized indexing strategies to improve database performance and throughput. Performed SQL Server administration tasks including backups, index maintenance, and user access provisioning to support ETL and reporting environments. Worked closely with IT, operations, development, infrastructure, and production support teams to troubleshoot issues and ensure stable data engineering solutions. Developed and optimized Power BI reports using star schema modeling, DAX (time intelligence, customer segmentation, KPIs), and implemented Row-Level Security (RLS) for role-based access. Built DAX measures for YTD/YOY analysis, repeat purchase rate, average basket value, customer risk analysis, and validation checks to support executive decision-making. Developed SSRS reports (Tablix, Matrix, Charts) and managed report version control using Git for collaborative development. Blue Cross Blue Shield (BCBSAZ) July 2023 April 2025 Sr. SQL & ETL Developer Roles and Responsibilities: Gathered and documented business requirements from claims, enrollment, provider, and compliance teams; prepared detailed BRD/FRD for healthcare data warehouse and reporting initiatives. Facilitated BRD/FRD walkthroughs and translated healthcare KPIs (claims turnaround time, denial rates, enrollment trends) into functional specifications, data mappings, and validation rules for ETL and BI teams. Designed and deployed advanced SSIS ETL workflows to process healthcare EDI transactions including 837 (claims), 834 (eligibility), and 835 (remittance), ensuring HIPAA and HL7 compliance. Implemented CDC-based incremental loads and SCD Type 1/2 logic in SSIS to manage member, provider, and claims dimensions while maintaining historical data integrity. Built robust SSIS error handling, auditing, logging frameworks, and SLA-driven alert mechanisms to support production environments. Developed and optimized stored procedures consumed by REST APIs to handle high-volume transactions, ensuring data integrity, performance tuning, and secure API-to-database communication. Developed SSIS packages for file transfers (FTP/SFTP), inbound/outbound EDI processing, and automated data ingestion pipelines. Created and maintained source-to-target mappings (STTM) for fact and dimension tables supporting claims, eligibility, and provider data. Developed reusable SSIS components applying best practices for modularity, performance tuning, and scalability. Designed, validated, and processed ANSI-standard EDI files per trading partner and CMS guidelines; parsed and loaded EDI data using complex SQL queries and stored procedures. Supported end-to-end claims lifecycle including validation, rejection handling, denial analysis, and reconciliation processes. Developed and optimized T-SQL stored procedures consumed by REST APIs and SSIS workflows to support incremental loads, data validation, and error handling for high-volume transactional data. Automated incremental loads using CDC and implemented data cleansing, deduplication, and enrichment processes. Conducted database performance tuning, indexing strategies, dynamic SQL development, and complex joins to optimize claims processing performance. Integrated data governance, metadata management, lineage tracking, and PHI compliance practices across data warehouse modernization initiatives. Collaborated with compliance and trading partners to ensure HIPAA adherence, privacy tagging, audit readiness, and regulatory reporting compliance. Provided SLA-driven production support, troubleshooting pipeline failures and resolving data quality issues to minimize downtime. Possess strong healthcare domain expertise across Medicare Advantage, Medicaid, and Commercial lines of business. Developed secure Power BI dashboards tracking claims adjudication metrics, denial rates, PMPM trends, enrollment analytics, and provider performance KPIs. Implemented Row-Level Security (RLS), workspace access controls, and gateways to ensure HIPAA-compliant PHI access and automated report refresh. Built advanced DAX measures (YTD claims cost, denial %, readmission metrics, time intelligence calculations) to support financial and regulatory reporting. Published reports to Power BI Service and supported web/mobile accessibility for executive stakeholders. Developed limited Power Apps integrations to support operational data capture connected to reporting solutions. BenefitMall, Dallas, TX Nov 2022 June 2023 Sr. SQL & SSIS Developer Responsibilities: Collaborated with benefits administration, broker management, and finance teams at BenefitMall to gather and document business requirements, preparing BRD/FRD for enrollment reporting, premium reconciliation, and broker commission analytics initiatives. Designed and developed end-to-end SSIS ETL pipelines to process employer group enrollment, member eligibility, premium calculations, claims extracts, and broker commission data into the enterprise data warehouse. Built automated data integration workflows using SSIS and Azure Data Factory (ADF) to ingest and transform carrier reports, payroll files, and benefits administration datasets for reporting and reconciliation. Implemented incremental load strategies using CDC and SCD Type 1/Type 2 methodologies to track enrollments, terminations, plan changes, and historical benefit selections. Performed data cleansing, validation, reconciliation, and error handling to ensure accuracy of enrollment counts, premium billing amounts, broker compensation metrics, and claims data across systems. Developed dynamic and parameterized SSIS packages and reusable ADF pipelines to automate eligibility and claims data processing. Designed star and snowflake schemas to improve reporting performance and optimize analytical queries. Developed complex stored procedures, optimized SQL queries, and performed database tuning to enhance dashboard and report performance. Partnered with data governance teams to define business glossaries, improve metadata enrichment, and enhance data discoverability for self-service analytics and compliance reporting. Served as an ETL Developer within the Business Intelligence team, responsible for designing, developing, enhancing, and supporting BI and data integration solutions. Built end-to-end ETL pipelines where REST APIs served as source systems, SSIS handled orchestration and transformation, and SQL Server (T-SQL) managed staging, data cleansing, and dimensional model loads. Collaborated with IT, architects, business analysts, and reporting teams to gather requirements and deliver scalable BI solutions. Developed interactive Power BI dashboards to analyze enrollment trends, benefit utilization, premium revenue, broker performance, retention metrics, and cost optimization opportunities. Created advanced DAX measures including retention rate, enrollment growth %, premium variance, cost per employee, and time intelligence metrics (YTD, MTD, YOY). Implemented Row-Level Security (RLS) to restrict access based on broker hierarchy, employer groups, and internal business units. Utilized Power Query Editor for data cleaning, transformation, shaping, and merging from multiple data sources. Designed executive-level dashboards with drill-down and drill-through capabilities to support strategic planning and financial analysis. Developed and deployed SSRS reports with KPIs, charts, gauges, indicators, and custom expressions; integrated SSRS with SharePoint for web-based access and distribution. Optimized SSRS report performance by tuning SQL queries and leveraging caching mechanisms. Created dashboards and ad hoc reports by integrating SSIS data flows with Python-generated analytical insights. Analyzed benefit plan data to identify trends, coverage gaps, and cost-saving opportunities for employer groups. CYIENT, India & USA Mar 2012 Oct 2022 Project 1: Westinghouse Electric Company, India/Pittsburgh Sr PowerBI/SQL Server/ETL Database Developer Responsibilities: Collaborated with engineering, plant operations, and compliance stakeholders at Westinghouse Electric Company to gather and document business requirements, translating regulatory reporting, operational metrics, and maintenance tracking needs into BRD/FRD for ETL and BI solution development. Delivered enterprise-scale ETL and data warehouse solutions for clients like Westinghouse. Developed complex PL/SQL and T-SQL code for ETL pipelines handling millions of records daily. Applied data transformation, cleansing, and standardization logic using Power Query style transformations within ETL processes to prepare analytics-ready data. Developed complex T-SQL queries, views, and stored procedures supporting Power BI semantic models, ad hoc analytics, and enterprise reporting needs. Created high-performance SSIS packages using transformations like Lookup, Merge Join, and Conditional Split. Designed, documented, and implemented SCD processes for tracking data changes. Supported nuclear power domain data automation projects ensuring 100% process accuracy. Developed and optimized SSRS reports with drill-through and parameterized functionality. Designed a federated governance model across business units to scale adoption while respecting autonomy and domain-specific needs. Developed SSIS or ETL packages for importing, aggregating, and exporting financial and operational data. Incorporated robust data integrity and error logging mechanisms to ensure reliable and fault-tolerant ETL processing. Designed and implemented SSIS packages for transforming and integrating structured and semi-structured data into data warehouses and data lakes. Applied SSIS Data Flow Transformations such as Sort, Derived Column, Conditional Split, Lookup, and Slowly Changing Dimension (SCD) to clean, transform, and enrich incoming data. Tuned SSIS performance using best practices to enhance throughput and reduce load times in large-scale processing environments. Managed ETL workflows using Control Flow Tasks (e.g., Execute SQL Task, Execute Package Task, Send Mail Task) for automation and orchestration. Project 2: Excentus, Hyderabad Sr SQL Server/ PowerBI Developer Responsibilities: Designed, developed, and maintained end-to-end ETL pipelines using SSIS to process and transform large-scale enterprise data across multiple systems for BI and analytics consumption. Created and optimized complex T-SQL and PL/SQL stored procedures, functions, packages, triggers, and views to support backend data processing and high-performance reporting. Implemented incremental load strategies, dataset optimizations, and dimensional data models (normalized and star schema) to support high-volume reporting and analytics. Built and enhanced SSIS packages using transformations such as Lookup, Merge Join, Conditional Split, and Derived Column, incorporating robust error handling, logging, and alerting mechanisms. Managed SQL Server Agent jobs to automate ETL workflows and ensure timely, accurate data delivery in production environments. Designed and implemented CI/CD pipelines using Jenkins to enable automated testing and deployment of ETL and data engineering workflows. Performed SQL and PL/SQL performance tuning using tools such as EXPLAIN PLAN and SQL Trace, improving query efficiency and resource utilization. Provided SLA-driven production support, including data profiling, reconciliation, troubleshooting pipeline failures, and participating in Agile ceremonies and ETL modernization initiatives. Keywords: cprogramm cplusplus continuous integration continuous deployment quality analyst business intelligence active directory information technology microsoft mississippi procedural language Texas