SQL Server DBA & BI Developer
Resume:
VYSALI GUTTA
SQL BI Developer SQL Server Power BI SSIS ETL
*************@*****.***
PROFESSIONAL SUMMARY
SQL BI Developer and Data Analyst with experience in SQL Server development, business intelligence, ETL/data integration, data warehousing, and enterprise reporting. Skilled in T-SQL, SSIS, SSRS, SSAS, Power BI, and ETL platforms including Informatica PowerCenter and IBM DataStage. Experienced in developing SQL queries and database objects, building data pipelines and analytical reports, validating data, troubleshooting production issues, and supporting testing, UAT, and business requirements. Background includes healthcare and healthcare supply-chain analytics, cross-functional collaboration, and Agile/SDLC delivery.
TECHNICAL SKILLS
SQL & Database:
Microsoft SQL Server, T-SQL, Azure SQL, Oracle, Teradata, PL/SQL, Stored Procedures, Views, CTEs, Functions, Triggers, subqueries, Joins, Indexing, Query Optimization, Performance Tuning, Teradata BI & Reporting:
Power BI, Power BI Service, Power Query, DAX, SSRS, Crystal Reports, Tableau, Qlik Sense, Excel, Gateway, SSRS, SSAS, KPI dashboards, Parameterized Reports
ETL & Data Integration:
SSIS, Informatica PowerCenter, IBM DataStage, Azure Data Factory, SAP BODS/BODI, ETL Pipeline Development, Data Integration, Data Transformation, Data Validation, Data Cleansing, Source-to-Target Mapping, error handling, scheduling, monitoring
Data Warehousing & Modeling:
Data Warehousing, Dimensional Modeling, Star Schema, Snowflake Schema, Fact & Dimension Tables, Data Marts, OLTP/OLAP, SSAS, MDX
Cloud & Big Data:
Microsoft Azure, Azure Databricks, Databricks SQL, Spark, Power BI Service Programming & Scripting:
Python, Pandas, NumPy, Matplotlib, Seaborn, PowerShell Tools & Development:
SSMS, SQL Server Agent, SSDT, Visual Studio, SQL Profiler, Database Engine Tuning Advisor, Git, Jira, SDLC, Agile/Scrum
Analysis & Delivery:
Requirements gathering, business and technical documentation, data profiling, data-quality checks, reconciliation, UAT, production support, root-cause analysis, Agile/Scrum, Jira EDUCATION
Master of Science in Computer Science
Silicon Valley University 2012–2014
PROFESSIONAL EXPERIENCE
SQL Server Power BI Developer
Cigna Healthcare – Bloomfield, CT Aug 2023 - Present
• Designed and optimized end-to-end ETL workflows using SSIS and IBM DataStage, integrating high- volume healthcare data from SQL Server, Oracle, SAP BW, and Azure-based sources into enterprise data warehouses.
• Developed complex T-SQL queries, stored procedures, views, CTEs, functions, joins, and data transformation logic to support reporting, analytics, and downstream applications.
• Developed interactive Power BI dashboards and reports using DAX, Power Query, SQL, calculated measures, KPIs, and time-intelligence calculations for healthcare operational and financial analytics.
• Built and maintained SSIS data integration pipelines with validation, logging, error handling, checkpoints, and restartability to support reliable production data processing.
• Analyzed and transformed JSON, XML, CSV, TXT, and flat-file data using SQL, SSIS, and Databricks for standardized data ingestion and downstream reporting.
• Leveraged Azure Databricks and SQL for large-scale extraction, transformation, processing, and analysis of high-volume healthcare datasets.
• Developed and maintained SSRS reports, including tabular, matrix, drill-down, subreports, parameterized, and scheduled reports using optimized SQL datasets.
• Integrated Power BI with SQL Server, Oracle, SAP BW, and Azure SQL, supporting governed data access and reliable enterprise reporting.
• Designed incremental ETL and scheduled data-refresh processes and deployed SSIS packages across development and production environments to support recurring data loads.
• Performed SQL Server query and database performance tuning using execution plans, indexing strategies, query analysis, SQL Profiler, and resource utilization monitoring.
• Published and managed enterprise Power BI content through Power BI Service, including workspace administration, dataset refreshes, report deployment, sharing, and access management.
• Configured and monitored the Power BI On-premises Data Gateway to maintain connectivity between on-premises SQL Server sources and cloud-based Power BI reports.
• Performed data validation, reconciliation, profiling, and root-cause analysis to identify data-quality issues, ETL failures, transformation discrepancies, and production pipeline problems.
• Collaborated with business stakeholders, analysts, and technical teams to gather requirements, define business rules, validate results, and translate reporting needs into scalable BI solutions.
• Participated in the complete SDLC and Agile delivery process, including requirements analysis, technical design, development, testing, deployment, documentation, production support, Jira tracking, and troubleshooting.
ETL/SQL Developer
Optum – Eden Prairie, MN Jun 2021 - May 2023
• Designed and developed enterprise ETL solutions using Informatica PowerCenter, SQL Server, Teradata, and MicroStrategy to integrate data from multiple source systems into enterprise data warehouses.
• Translated business and technical requirements into ETL mappings, transformation logic, source-to- target mappings, data flows, and reusable development standards.
• Developed complex Informatica mappings using Source Qualifier, Lookup, Joiner, Aggregator, Expression, Update Strategy, Sequence Generator, Stored Procedure, and SQL transformations.
• Configured and monitored Informatica workflows, worklets, sessions, events, decisions, notifications, commands, assignments, timers, and scheduling for automated data processing.
• Extracted, transformed, validated, and loaded data from SQL Server, flat files, Excel, and relational database sources into staging and enterprise data warehouse environments.
• Developed data cleansing, standardization, validation, and transformation processes to improve data quality, consistency, and completeness across integrated source systems.
• Designed and maintained staging structures, fact tables, dimensions, source-to-target mappings, and dimensional data warehouse models supporting analytical and reporting requirements.
• Utilized Teradata FastLoad, MultiLoad, and BTEQ for high-volume data loading, data processing, key generation, and warehouse operations.
• Developed complex T-SQL queries, stored procedures, SQL scripts, joins, and transformation logic to support ETL processing and reporting requirements.
• Created and optimized SSIS packages using control-flow and data-flow components to integrate SQL Server, flat-file, and Excel data sources.
• Developed SSRS reports, including parameterized, drill-through, ad-hoc, and operational reports using optimized SQL queries and stored procedures.
• Automated recurring ETL and database activities using SQL Server Agent, including job scheduling, sequencing, alerts, and operational monitoring.
• Performed data reconciliation and validation between source, staging, and target environments and troubleshot ETL failures, SQL errors, data discrepancies, and transformation issues.
• Collaborated with business analysts, QA teams, developers, and data warehouse stakeholders throughout requirements analysis, development, testing, deployment, production support, and defect resolution.
SQL Developer
Capital One – McLean, VA May 2014 - June 2015
• Developed complex T-SQL queries, stored procedures, views, functions, and database objects supporting enterprise reporting, data processing, and analytical requirements.
• Designed and implemented SSIS ETL workflows to extract, transform, validate, and load data from multiple source systems into centralized data warehouse environments.
• Developed reusable SQL scripts and stored procedures implementing business rules, data transformations, validation logic, and reporting requirements.
• Performed SQL Server query optimization and database performance tuning using execution plans, indexing strategies, query analysis, and resource utilization.
• Designed and maintained relational and dimensional data models, including fact tables, dimension tables, relationships, and star-schema structures.
• Developed SSRS reports, including parameterized, tabular, matrix, drill-down, and scheduled reports using optimized SQL datasets.
• Created automated data validation, reconciliation, and cleansing processes to identify discrepancies and improve data accuracy and consistency.
• Developed and monitored SQL Server Agent jobs to automate database processes, ETL workflows, recurring data loads, and reporting activities.
• Troubleshot ETL failures, SQL errors, data discrepancies, and reporting issues, performing root-cause analysis and implementing corrective solutions.
• Supported database maintenance, data migration, schema changes, deployments, and SQL Server environment activities across development, QA, and production.
• Collaborated with business analysts, QA teams, developers, and business stakeholders throughout the SDLC and Agile/Scrum development process.
Contact this candidate