Summary
Overview
Work History
Education
Skills
Certification
EXPERIENCE SUMMARY
Timeline
Generic

Swetha Bakkani

Mechanicsville,VA

Summary

Results-driven and motivated graduate seeking a SQL BI Developer position to leverage a strong educational background and over 10 years of extensive experience in business intelligence and data analysis. Proven ability to transform complex data into actionable insights, driving informed decision-making and organizational growth. Committed to utilizing technical expertise in SQL and BI tools to enhance data-driven strategies and contribute to team success. Eager to bring a passion for data and a collaborative spirit to a dynamic work environment.

Overview

11
11
years of professional experience
1
1
Certification

Work History

Sr. SQL BI Developer

Compunnel Inc
06.2023 - 03.2024
  • Experience in loading the data from Database to CRM / CRM to Database which involves update. Created solutions in CRM which involves editing the fields in the Form.
  • Designed and Developed SSIS packages which loads data from DB2 and SQL to CRM and then update the fields in CRM.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures, functions. Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
  • Planned and executed end-to-end migration of on-premises Microsoft SQL Server databases to AWS cloud infrastructure, ensuring minimal downtime and data integrity.
  • Optimized database performance post-migration by tuning queries, indexing strategies, and leveraging AWS-native features for improved scalability and cost efficiency.
  • Designed and implemented data warehousing solutions in Amazon Redshift, optimizing schema design using distribution keys, sort keys, and compression encoding for high performance.
  • Developed and maintained ETL pipelines to load structured and semi-structured data into Redshift from diverse sources using AWS Glue, AWS Data Pipeline, and SQL-based transformations.
  • Optimized complex SQL queries in Redshift by analyzing execution plans and applying best practices to improve query performance and reduce processing time.
  • Experience in Developing the SSRS reports using Stored Procedures and tabular Models.
  • Created complicated reports like parameter-based reports, graphical reports, well-formatted reports, drill-down reports, matrix reports, chart and tabular using SSRS.

Sr. SQL BI Developer

Compunnel Inc
02.2022 - 05.2023
  • Experience in Data load into database using SSIS from Dynamics CRM to SQL Database.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures, functions. Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
  • Experience in Developing the SSRS reports like Tabbed reports, score cards, workbook using Stored Procedures and tabular Models.
  • Designed and Developed SSIS packages to load files automatically using For loop/ For each loop in sequence container and performed data transformations using data tools like derived column, merge, Lookup, sort, conditional split, union all etc.
  • Experience in adding new tables to the existing Tabular Models using SSAS for SQL Database and also adding new attributes and maintain the tabular models in order to develop SSRS reports.
  • Created complicated reports like parameter-based reports, graphical reports, well-formatted reports, drill-down reports, matrix reports, chart and tabular using SSRS.
  • Led end-to-end migration of on-premises SQL Server databases to Azure SQL Database, ensuring minimal downtime and zero data loss.
  • Analyzed existing database schemas and optimized objects before migration to improve performance in the Azure cloud environment.
  • Configured and used Azure Database Migration Service (DMS) and SQL Server Management Studio (SSMS) for seamless data transfer.

Sr. SQL BI Developer (T-SQL/ SSIS/ SSRS)

Compunnel Inc
02.2020 - 01.2022
  • Experience in Data load in to database using SSIS/Informatica and also developed Queries using Teradata/TSQL for Medicare and Medicaid related data.
  • Experience in Data load into database using UET tool and also developed Queries using T-SQL for Medicaid related data.
  • Experience in loading data from flat files by using Teradata utilities like Fast Load, Fast Export, TPUMP etc.
  • Used Teradata stored procedures and functions and loaded data in to tables.
  • Experience developing Weekly and Monthly Reports like parameter-based reports, drill-down reports, matrix reports, chart and tabular using SSRS.
  • Experience in developing the Data Driven Subscription based SSRS reports and schedule jobs using TIDAL.
  • Worked with T-SQL to create Tables, Views, and triggers and stored Procedures, functions. Created complex queries which involve usage of Joins, Sub-queries, Functions, Temporary tables etc.
  • Created Indexes for fast retrieval of the data and used string functions for space management in database. Involved in Performance tuning and Query Optimization using execution plan.
  • Extensively designed the packages and data mapping using Control flow task elements, Sequence container task, Dataflow Task, Execute SQL Task, For Each Loop Container, For Loop Container and Script Task in SSIS Designer.
  • Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension.

SQL BI Developer (T-SQL/ SSIS/ SSRS/ SSAS)

AV Enterprise Inc
12.2018 - 05.2019
  • Provide SQL Development using MS SQL Server, SSIS and SSRS in relation to analyze and troubleshoot errors in the reports and packages.
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers in SQL Server.
  • Created and developed ETL packages with different data sources (SQL Server, Oracle, Flat Files, Excel source files, XML files etc.) and loaded the data into destination databases by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Created complicated reports like parameter-based reports, graphical reports, well-formatted reports, drill-down & drill-through reports, matrix reports, chart and tabular using SQL Server Reporting Services (SSRS).
  • Experience in developing and managing SSAS cubes, dimensions , data source views including deploying and processing of SSAS objects.
  • Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type 1 and type 2 Slowly changing dimensions (SCD).
  • Migrated on-premises SQL Server databases to Azure SQL Database and Azure Synapse Analytics, ensuring minimal downtime and data integrity.
  • Developed and orchestrated ETL pipelines in Azure Data Factory for integrating data from multiple sources into centralized data warehouses.
  • Performed data analysis to generate various trend reports and generated Ad-hoc, matrix and tabular reports using SQL Server Reporting Services (SSRS) based on client needs.

SQL BI Developer (T-SQL/ SSIS/ SSRS/ SSAS)

EPE Innovations LLC
03.2017 - 11.2018
  • Experience in providing Reports using SSRS to the end client and providing complete support to the reports and stored procedures developed.
  • Developed Complex Stored Procedures using Dynamic queries based on the requirement and integrating them to SSRS reports such that the user can view the report based on their selection.
  • Designed and developed Tabular Data models in SSAS using tables, views, and created few measures, KPI, Perceptive and calculated tables using DAX Queries, applied row level security
  • Developed dashboards using visualizations and developed self-service report by applying the Row level security for tax related data using Power BI
  • Experience in fixing the PWC tax application and integrating the Power BI reports in to application using .net scripts in spotlight at the back end.
  • Connected and transformed data from multiple sources (SQL Server, Excel, SharePoint, APIs, Azure SQL) using Power Query and Power BI Dataflow.
  • Created complex DAX measures and calculated columns to enable advanced analytics and KPI tracking.

SQL Developer/ SSIS/ SSRS/ T-SQL

Sanguine Software Solutions Inc
10.2015 - 02.2017
  • Optimized data models for performance by reducing dataset size, implementing star schema, and managing relationships efficiently.
  • Developed row-level security (RLS) to control data access and ensure compliance with organizational policies.
  • Published reports to Power BI Service and scheduled data refreshes to ensure real-time or near-real-time data availability.
  • Experience in creating Tabbed Reports, Tabular reports, Matrix reports, Parameterized reports, Sub reports, Drill down and Drill Through reports using SQL Server source and SSAS source.
  • Worked with T-SQL to create Tables, Views, and triggers stored Procedures, functions, Dynamic pivot and unpivot, cursors, triggers etc.
  • Created complex queries which involve usage of Joins, Sub-queries, Stored Procedures, Functions, CTE, Temporary tables, Views etc.
  • Created Indexes for fast retrieval of the data using Table valued, Scalar valued functions and Involved in Performance tuning and Query Optimization using execution plan.

SQL Developer/ SSIS/ SSRS/ T-SQL

Sanguine Software Solutions Inc
06.2015 - 10.2015
  • Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
  • Created complicated reports like parameter-based reports, graphical reports, well-formatted reports, drill-down reports, matrix reports, chart and tabular using SSRS.
  • Developed custom reports using SQL Server Reporting Services (SSRS) to review score cards, business trends based on the data from different retail locations.
  • Performed data analysis to generate various trend reports and generated Ad-hoc, matrix and tabular reports using SQL Server reporting services based on customer needs.

SQL Developer/ SSIS/ SSRS/ T-SQL

Sanguine Software Solutions Inc
01.2015 - 06.2015
  • Extensively designed the packages and data mapping using Control flow task elements, Sequence container task, Dataflow Task, Execute SQL Task, For Each Loop Container, For Loop Container and Script Task in SSIS Designer.
  • Designed and developed efficient SSIS packages for processing fact and dimension tables using transformations like Fuzzy lookup, lookup, merge, merge join, script component and Slowly changing dimension.
  • Created numerous simple to complex queries involving joins, correlated sub-queries and CTE’s techniques for diverse business requirements. Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
  • Involved in Performance tuning and Query Optimization of Stored Procedures and queries using execution plan and profiler.
  • Created User defined scalar and table valued functions and complex stored procedures to implement business logic.
  • Used new functions like Last_Value, First_Value and Concat in Sql Server 2012
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling. Implemented error handling techniques like Try and catch, @@ error in Stored procedures.

SQL Developer/ SSIS/ SSRS/ T-SQL

Sanguine Software Solutions Inc
08.2013 - 12.2014
  • Extracted the data from Oracle, Flat Files, transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2012).
  • Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
  • Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions in SQL Server.
  • Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and developer database code as well as T-SQL code from developers and QA.

Education

Masters in Science - Pharmaceutical Chemistry

FDU

Bachelors in Pharmacy - undefined

JNTU

Skills

  • Experience with multiple SQL Server versions
  • Advanced SQL skills
  • Languages: T-SQL, Pl-SQL, DAX, MDX
  • Reporting and analytics: SQL Server Reporting Services, Power BI, Tableau
  • Version control management: Tortoise SVN, VSS, TFS

Certification

Microsoft Certified Solution Expert in SQL Server 2012/2014.

EXPERIENCE SUMMARY

  • Around 10+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2017/2014/2012/2008(R2) in Development, Test and Production Environments with various business domains like Financial, Healthcare, Clinical, Insurance.
  • Designed conceptual Data models Normalization techniques using MS-Visio tools developed OLTP, OLAP/ Data Warehouse, Data Mart and ODS Databases.
  • Experience in creating and managing fragmentation of Indexes to achieve better query performance. That increases my ability in Performance Tuning, Query Optimization using SQL Profiler.
  • Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC)
  • Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using SSIS.
  • Developed Power BI Reports and Dashboards using complex DAX formulas using Direct Query and live connect using Analysis services.
  • Experience in developing Multidimensional and tabular model using Star and Snowflake schema using DAX and MDX queries
  • Developed OLAP Cubes with Partitions, perspectives using SQL Server Analysis Services (SSAS).
  • Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.
  • Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
  • Results-driven Cloud Data Engineer with extensive experience in designing, developing, and deploying scalable solutions on AWS and Microsoft Azure platforms.
  • Skilled in migrating on-premises databases to AWS Redshift, RDS, and Azure SQL Database, leveraging cloud-native services such as Azure Data Factory, Synapse Analytics, AWS Glue, and S3 for end-to-end ETL/ELT pipelines.
  • Proficient in optimizing data storage, implementing cloud security best practices, and automating deployments with Azure DevOps and AWS CodePipeline.
  • Adept at collaborating with cross-functional teams to deliver secure, high-performance, and cost-optimized cloud solutions that support advanced analytics and business intelligence initiatives.
  • Excellent communication skills, analytical skills, understand business requirements in various domains.

Timeline

Sr. SQL BI Developer

Compunnel Inc
06.2023 - 03.2024

Sr. SQL BI Developer

Compunnel Inc
02.2022 - 05.2023

Sr. SQL BI Developer (T-SQL/ SSIS/ SSRS)

Compunnel Inc
02.2020 - 01.2022

SQL BI Developer (T-SQL/ SSIS/ SSRS/ SSAS)

AV Enterprise Inc
12.2018 - 05.2019

SQL BI Developer (T-SQL/ SSIS/ SSRS/ SSAS)

EPE Innovations LLC
03.2017 - 11.2018

SQL Developer/ SSIS/ SSRS/ T-SQL

Sanguine Software Solutions Inc
10.2015 - 02.2017

SQL Developer/ SSIS/ SSRS/ T-SQL

Sanguine Software Solutions Inc
06.2015 - 10.2015

SQL Developer/ SSIS/ SSRS/ T-SQL

Sanguine Software Solutions Inc
01.2015 - 06.2015

SQL Developer/ SSIS/ SSRS/ T-SQL

Sanguine Software Solutions Inc
08.2013 - 12.2014

Bachelors in Pharmacy - undefined

JNTU

Masters in Science - Pharmaceutical Chemistry

FDU

Similar Profiles

CREATE PROFILE