Data Ssis

CAREER SUMMARY

Around * years of working experience in Microsoft SQL Server (2008/2012/2014/206/2019), Business Intelligence through SQL Server Integration, Analysis and Reporting Services (SSIS, SSAS, SSRS), and working in all phases including Design, Testing, Analysis Development and implementing using MS SQL server

Experienced ETL Developer with wide-ranging proficiency in designing SQL Server objects like Tables, View, Stored Procedures and Functions. Very good hands-on experience on Writing Complex TSQL Queries for doing ETL work and for reporting purpose. Experienced in designing SSIS ETL Frameworks and designing packages dynamically which can load data from different sources to destination like SQL Server. Proficient in developing different types of SSRS reports and good experience in managing them and providing Support. Good experience in designing Datamart and developing SSAS Cube, both Multi-dimensional and Tabular model cubes. Experienced in creating Power BI visualizations and making enhancements to the existing reports. Published and administrated Power BI reports, datasets, workspaces, and apps.

TOP KEY SKILLS

T-SQL

ETL

Visual Studio

Auto Sys

Azure

SSIS

SQL Server Database

Business Intelligence

Splunk

GIT

BIRST

SSRS

Data Warehousing

Data Modeling

Solar Winds

AWS

Power BI

SSAS

RELEVANT EXPERIENCE

Sr. Application Analyst/Developer Nov 2019 – Till Date

Lincoln Financial Group, NH

Sr. SQL BI Developer Nov 2018 – Oct 2019

Liberty Mutual Insurance, NH

Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan. Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.

Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.

Developed data model, SQL Coding, SQL Query tuning process and Schemas.

Customers provide us the information through System One and from there data will get loaded into our database tables through the ETL packages that were scheduled to run every night.

Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.

Used Configuration Files in SSIS to ease the process of moving the packages across servers.

Designed packages which utilized tasks and transformations such as Execute SQLTask, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.

Developed packages in SSIS with error handling. Involved in data cleansing to remove unnecessary columns eliminate redundant and inconsistent data by using SSIS transformations.

Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.

Created Package Configurations to deploy packages from development to production server.

Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in SQL Reporting Services (SSRS)

Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS).

Creating SSAS cubes using both Tabular model and Multidimensional model to analyze data from different sources.

Worked on new reporting tool BIRST for creating templates and Subscriptions for different customers based on the requirements from the customer.

Used the tool BIRST to create, generate and distribute the reports to the customers which includes both Standard Report Templates and Custom Report Templates.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Created Regression test scripts to validate the results and created the test cases. Tested the code by writing re-usable Unit Testing Scripts and TDD Scripts.

Worked with the customers to understand their report requirement and created Business Requirements Document (BRD) based on their expectations and also updated ALM (Application life cycle management) tool with the business requirements before starting the development.

Extensively Used Informatica Designer as an ETL tool to extract data from legacy source Disability Reporting System (DRS) to Target system.

Extensively worked on migration project where we migrated all the data from Liberty to Lincoln which involves SQL Server migration from 2016 to 2019.

Worked on migrating the ETL packages to Lincoln where we have various types of packages such for S1(System One) ETL, Claims, Leaves, Billing Center, Sybase etc.

Trained on migrating the SQL data using transactional replication and in AWS DMS (database migration services) and validating the source and destination tables by creating the tasks to validate them. Trained in AWS S3 and EC2 instances and storing the data.

Worked on TFS version control to check-in the code and have used the merging branch techniques. Also used GITLAB after post Integration

SQL BI Developer May 2017 – Oct 2018

State Farm Insurance, Bloomington, IL

Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan. Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc. Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.

Designed packages which utilized tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.

Develop and implement test plans to ensure successful delivery of a project. Implemented Performance Tuning and Query Optimization.

Created Package Configurations to deploy packages from development to production server.

Designed tabular, matrix reports, drilldown, drill through, Parameterized and linked reports in SQL Reporting Services (SSRS) which helps the users to get the claims report.

Prepare and Distribute Financial Reports using SSRS to internal and provide recommendations for client’s strategic decision making. Resolved production issues related to the SSRS reports and create ad-hoc financial reports for the clients

Using SQL Server Reporting Services (SSRS) generated periodic reports based on the statistical analysis of the data. Designed Cubes with Star Schema using SQL Server Analysis Services 2012 (SSAS).

Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.

Used various SSIS transformations such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into Production tables.

Configured SQL mail agent for sending automatic emails when a SSIS package is failed or succeed.

Created packages and scheduled them in SQL Agent jobs to get data from OLTP.

Modifying SSIS packages for business logic enhancements. Writing/modifying VB scripts for sales file moments and data loads.

Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Scheduled the SSIS package services to run at different intervals to fetch the data and for transferring the data into different database.

Set up some tables in the main server as a snapshot publication and push them to the warehouse server (Subscriber) on the nightly basis. This eliminated the old way of emailing spreadsheet on the weekly basis.

Created Package Configuration files to support the SSIS packages in different environments.

Generated Dynamic Reports from Cubes (SSAS) using SSRS 2012. Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Deploying and scheduling reports using SSRS to generate daily, weekly, monthly and quarterly reports run periodically.

Created SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation.

Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.

MSBI Developer Aug 2016 – Apr 2017

CareFirst, Baltimore, MD

Worked on creating Tables and writing Stored Procedures and User Defined Functions.

Tested the application which involves Retesting, GUI Testing and Functional testing.

Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.

Created Databases, Tables, Indexes, Unique/Check Constraints, Views, Stored Procedures, Triggers, Functions. Also wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.

Performed report analysis, requirements gathering, design, development, and deployment of business requirement documents.

Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.

Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques. Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.

Worked with transferring the data using SSIS (SQL Server Integration Services) packages. Used MS Excel, CSV files as data source and copied data to the target.

Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Functions, Views Rules, Defaults and complex SQL statements.

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. Troubleshooted the already existing SSIS packages.

Managed server related issues. Developed unit test plans for SSIS packages. Also provided documentation for reports and SSIS packages.

Responsible for development of complex reports by using SSRS. Developed various Cross Tab Reports, Drill down, Sub Reports, and Parameter Reports to generate all daily, weekly, monthly, and quarterly Reports Including current project status.

Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).

Created multiple automated reports and dashboards sourced from data warehouse using SSRS.

Responsible for back up and Restoration of SQL Reporting Service. Also provided Documentation support on SSRS 2012 as assigned.

SQL Developer Jul 2013 - Dec 2014

Innovation Communication Systems, India

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data. Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.

Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database. Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.

Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code. Created SSIS Packages to integrate data coming from Text files and Excel files.

Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.

Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.

Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks. Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

EDUCATION

Bachelor of Technology in Electronics and Communications Engineering – April 2014

Jawaharlal Nehru Technological University Hyderabad, India

Master of Science in Electrical Engineering – May 2016

State University of New York (SUNY), New Paltz, NY

Contact this candidate