Sowmya Badida
Summary
Microsoft BI Developer for 10+ years of IT Experience in System Design, Development and Support of Microsoft SQL Server 2012/2014/2016/2017/2019 in Development, Data warehouse, Test and Production Environments on various business domains like Financial, HealthCare, Banking. A Smart-working, Motivated, Detail-Oriented team player with excellent communication, interpersonal and problem-solving skills.
Overview
10
10
years of professional experience
Work History
Sr. ETL/PowerBI Developer
Texas Capital Bank
Dallas
03.2021 - Current
- Designed and implemented SSAS Tabular Cube as the reporting layer and Used DAX scripting to access data from Tabular Model
- Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
- Experienced to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation
- Also, one must be experienced in developing custom visuals for Power BI
- Expert in writing Parameterized Queries for generating Tabular reports, drill down, drill through, click through, matrix, chart, snap shots, formatting report layout
- Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries
- Involved in Creating User Security and Roles in Power BI
- Incorporated filters to narrow down data presented and slicers for appropriate user interaction, conditional formatting to spotlight alarming or profitable numbers
- Experience in Integrating Power BI App with Azure Active Directory Groups and Office 365 group to implement Row level Security
- Experience in Integrating Power BI App with SharePoint
- Assigning different access permissions and security levels for the reports in Power for various levels of users in the company
- Designed, Developed and Deployed Dashboards in Power BI
- Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases
- Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
- Involved in creating SSIS jobs to automate the reports generation, cube refresh packages
- Designed and developed SSIS packages to move data from various sources into destination flat files and databases
- Implemented error & failure handling in SSIS packages using event handlers, row redirects, check points and used loggings for monitoring the execution
- Performed unit level testing based on unit test case documents prepared from requirements
- Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc
- Perform data analysis on source system data to understand gaps, inconsistencies, and other quality issues, and develop data quality improvement solutions
- Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent
- Creating complex JIRA workflows including project workflows, custom fields, notification schemes, reports, and dashboards in JIRA
- Experienced in Creating Stories and Reports in JIRA using Easy BI Plugin
Sr. BI Developer
Anthem BCBS
VA
03.2017 - 02.2021
- Used Power BI Custom visuals like Power KPI, Chiclet Slicer, Info Graphic Designer, Spline Chart to make the visuals look and understand better
- Developed Power BI Apps to deliver key metrics to multiple groups within the organization
- Shared Power BI reports and dashboards to various user's groups using app workspace
- Involved in designing and publishing visually rich and intuitive Power BI dashboards
- Designed dashboards utilizing Power BI with rich visuals such as charts, slicers, gauges, funnel, word cloud
- Created reports using stored procedure
- Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS)
- Installation and configuration of SQL Server Reporting Services (SSRS)
- Created reports using stored procedure
- Involved in scheduling, creating snapshots and subscriptions for the reports
- Generated periodic reports based on the statistical analysis of the data from various time frames and division using SQL Server Reporting Services (SSRS)
- Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using SSRS
- Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server
- Configure and maintain using report manager and report server for SSRS, deployed and scheduled the reports in Report manager
- Designed SSIS Packages using Business Intelligence Development Studio (BIDS) to extract data from various data sources and load into SQL Server 2012 & 2016 database for further Data Analysis and Reporting by using multiple transformations
- Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server and Flat files
- Experience in creating and deploying SSIS (ETL process) packages using various Transformations such as Slowly Changing Dimension, Multicast, Merge Join, Lookup, Fuzzy Lookup, Conditional Split, Aggregate, Lookup, Merge, Derived Column and Data Conversion Transformations
- Created SSIS packages to integrate the data coming from flat files
- Migrated SSIS Packages from during data migration
- Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
- Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database
- Created SSIS packages to import the data into SQL server
- Determined procedures to identify and collect all required data, validate process and recommend improvements to corporate data
- Analyzing, modified, Data Cleansing on SQL Database and wrote complex TSQL statements and Migrated data into Excel files
- Debugged the processes, triggers, views, monitored the system and SQL server job schedule and recorded any errors
- Wrote complex T-SQL batches with Common Table Expressions (CTE's) for recursive operations
- Creation of Clustered and Non-Clustered Indexes for Query Performance and Generate various reports using complex stored procedures
SQLBI Developer
BB&T
Charlotte, NC
01.2015 - 02.2017
- Created complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
- Scheduled jobs using SQL Server Agent for executing the stored SSIS packages which were developed to update the database
- Created SSIS packages to import the data into SQL server
- Developed SSIS packages to provide data for SSRS reports
- Migrated data from different databases and from lower to higher environments and maintained batch files
- Worked with configuring checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
- Developed and supported SSRS reports for various business units and Optimization of Program Metrics
- Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements
- Wrote Complex SSRS Expressions and built the reports in Ad hoc Tool called Report Builder, Used Drill down, Drill Through, Parameterized functionality in the reports
- Experienced in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager
- Generated various reports with drilldowns, drill through, parameterized reports from the cubes by connecting to Analysis server from SSRS
- Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, chart report, Graphs
- Actively participated in interacting with users, team lead, DBAs, and technical manager to fully understand the requirements of the system
- Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application
- Created Proper Indexes for better performance of Stored Procedures
- Created logical and physical data models using best practices to ensure high data quality and reduced redundancy
SQLBI Developer
Swayam Info Logic Solutions
Hyderabad, India
07.2014 - 12.2014
- Scheduled jobs to execute SSIS packages which were developed to update database objects daily and maintain nightly loads of data by creating the corresponding tasks
- Created logical and physical data models using best practices to ensure high data quality and reduced redundancy
- Responsible for Database and Log Backups and Restoration, Backup Strategies and Scheduling Backups
- Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS)
- Modified existing SSIS packages to meet current business needs
- Created reports using stored procedure
- Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS)
- Automated execution process, scheduling, deploying of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent
- Involved in creating SSIS jobs to automate the reports generation, cube refresh packages
- Designed and developed SSIS packages to move data from various sources into destination flat files and databases
- Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server
- Deployed SSRS reports to Report server and configured cached reports
- Developed stored procedures, views and User Defined Functions using T-SQL statements
- Actively participated in gathering of User Requirement and system specification
- Involved in creating clustered and Non-Clustered Indexes to improve the database transactions performance
Education
Bachelors - Computer Science
JNTU
Hyderabad, India05.2014
Skills
- SQL
- SSIS
- SSRS
- SSAS
- SSMS
- PowerBI
- SQL Server Agent
- Azure Devops CI/CD
- Team Foundation server
- Azure Cloud
- JIRA
- SVN
- UNIX
- Toad for Oracle
- Control M
- Azure SQL Database
- Visual Studio
Timeline
Sr. ETL/PowerBI Developer
Texas Capital Bank
03.2021 - Current
Sr. BI Developer
Anthem BCBS
03.2017 - 02.2021
SQLBI Developer
BB&T
01.2015 - 02.2017
SQLBI Developer
Swayam Info Logic Solutions
07.2014 - 12.2014
Bachelors - Computer Science
JNTU
Similar Profiles
Laren MaloneLaren Malone
Treasury Escalations at Texas Capital BankTreasury Escalations at Texas Capital Bank
Soso YilkalSoso Yilkal
SharePoint / Power Platform / Dynamics 365 Developer at Texas Capital BankSharePoint / Power Platform / Dynamics 365 Developer at Texas Capital Bank
Erin KetonenErin Ketonen
Vice President, Program Mgr - Practice Leadership at Texas Capital BankVice President, Program Mgr - Practice Leadership at Texas Capital Bank
Alyssa KayeaAlyssa Kayea
Loan Operations Booking Specialist at Texas Capital BankLoan Operations Booking Specialist at Texas Capital Bank
Sri Harsha AyyadevaraSri Harsha Ayyadevara
Sr. PowerBI Developer at InEight Inc.Sr. PowerBI Developer at InEight Inc.