MSBI Developer - SQL & ETL Specialist with 3.4 Years

KT

KALYANI TAGAD

***************@*****.*** +91-775******* India

MSBI Developer with 3.4 years of experience in Microsoft Business Intelligence technologies, currently working at Cognizant. Strong expertise in SQL Server, SSIS, SSRS, and Power BI, with hands-on experience in designing and implementing end-to-end ETL solutions, database development, and enterprise reporting. Proven ability to work with US-based mid-level enterprise clients, delivering scalable data integration and reporting solutions to support business decision-making.

• MSBI Stack

• SSIS

• SSRS

• SQL Server

• Databases

• ETL Development

• Data Extraction

• Transformation

• Loading

• SQL

• Complex Queries

• Joins

• CTEs

• Stored Procedures

• Performance Tuning

• Transformations

• Lookup

• Conditional Split

• Derived Column

• Data Conversion

• Merge Join

• Union All

• Aggregate

• Pivot

• Unpivot

• Reporting & Visualization

• SSRS Reports

• Power BI Dashboards

• Scheduling & Deployment

• SQL Server Agent Jobs

• SSIS Configurations

• Tools

• SSMS

• Power BI Desktop

• Excel

• Operating System

• Windows

• Methodologies

• SDLC

• Production Support

• Unit Testing

Cognizant Technology Solutions

MSBI Developer

09/2022 - Current

Designed and developed SSIS ETL packages to extract data from heterogeneous sources including SQL Server, Oracle, DB2, Excel, Flat Files, and CSV.

•

Built and optimized SQL queries, views, stored procedures, and functions for large-scale data processing.

•

Implemented ETL performance tuning techniques such as indexing, query optimization, and data flow enhancements.

•

Created and scheduled SQL Server Agent Jobs for automated data loads and reporting.

•

Developed SSRS reports (Tabular, Matrix, Drill-down, Drill-through) based on business requirements.

•

• Designed Power BI dashboards by extracting and transforming data using Professional Summary

Core Skills

Professional Experience

Power Query and DAX.

Worked closely with US-based clients to gather requirements, analyze data needs, and deliver reporting solutions.

•

Performed unit testing, deployment, and production support for BI solutions.

•

Actively participated in daily status calls, incident resolution, and enhancement discussions.

•

Project 1

Project Title: CommInsure – Wealth Management Data Warehouse Client: Commonwealth Bank of Australia

Role: MSBI / SSIS Developer

Environment: SQL Server 2012 & 2016, SSIS 2012 & 2016 Project Description:

CommInsure is the insurance division of the Commonwealth Bank of Australia, providing wealth management and insurance services across multiple geographies including the US, UK, Asia, and New Zealand. The project focused on maintaining and enhancing the enterprise wealth management data warehouse, consolidating data related to policies, customers, premiums, advisors, and life coverage from multiple source systems to support executive reporting and business decision-making.

Roles & Responsibilities:

Project 2

Project Title: Enterprise Information Management System Client: Bandhan Bank

Role: MSBI Developer (SSIS, SSRS, SQL)

Operating System: Windows

Environment: SQL Server, SSIS, SSRS

Project Description:

The EIMS project was focused on implementing Management Information System (MIS) and RBI regulatory reporting for Bandhan Bank. The solution handled high-volume data related to loans, deposits, and customer information, enabling timely and accurate reporting for senior management and regulatory compliance. Roles & Responsibilities:

Designed, developed, and implemented complex ETL solutions using SSIS to integrate data from heterogeneous sources including SQL Server, Oracle, DB2, Flat Files, Excel, and CSV.

•

Participated in business requirement analysis and preparation of requirement documents in coordination with stakeholders.

•

Implemented multiple SSIS transformations such as Slowly Changing Dimension (SCD), Lookup, Derived Column, Conditional Split, Data Conversion, Aggregate, Sort, Merge, Merge Join, Pivot, Unpivot, and Union All.

•

• Developed master–child SSIS packages to improve reusability, maintainability, and scheduling efficiency. Utilized SSIS Control Flow tasks including ForEach Loop, Execute SQL Task, Script Task, File System Task, Execute Package Task, Data Flow Task, and Bulk Insert Task.

•

• Created and scheduled SQL Server Agent Jobs for automated ETL execution and monitoring.

• Configured SSIS packages using XML configuration files, SQL Server tables, and parent package configurations.

• Designed and maintained database objects such as tables, views, stored procedures, functions, indexes, and user roles.

• Supported reporting needs by ensuring accurate and timely data availability for leadership dashboards. Analyzed client specifications and reporting requirements from multiple business units such as loans and deposParticipated in daily status and requirement discussion calls with stakeholders.

•

Designed and developed end-to-end ETL workflows using SSIS, covering extraction, transformation, and loading processes.

•

Built SSIS packages using Control Flow tasks including For Loop Container, ForEach Loop Container, Sequence Container, Execute SQL Task, and Data Flow Task.

•

• Developed and optimized SQL queries, views, and stored procedures to support reporting and reconciliation.

• Created SSRS reports in tabular and matrix formats for management and compliance use.

• Performed unit testing, deployment, and production support for ETL and reporting solutions.

• Ensured data accuracy, performance, and timely delivery of MIS and regulatory reports. Projects

Master of Science (M.Sc.) in Bioinformatics

01/2022

Bachelor of Science (B.Sc.) in Bioinformatics

01/2020

• English

• Hindi

• Marathi

Education

Languages

Contact this candidate