Professional Summary
Over 7+ years of IT Experience in Database Design, Development and business intelligence of SSMS, SSIS, SSRS, SSAS and Tableau/Power BI in Development, Test and Production Environments on various business domains like Health Care, Finance and Insurance. Expertise in Microsoft Business Intelligence (MSBI), OLTP and OLAP using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ETL Data Warehouse, SQL Server Analysis Services (SSAS) and MS SQL Server (2008,2012,2014,2016,2019) Experience in creating Parameterized Reports. Profound Knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Complex views, Dynamic SQL, Triggers, Cursors and ER Diagrams. Working experience in creating Database Objects like tables, Constraints (Primary key, Foreign key, Unique, Default), Views and Indexes. Experience in developing the applications using T-SQL Programming (DDL, DML and DCL). Having experience in data analysis SQL server database development and maintenance, data modeling that support day to day business operations and auditing of databases for user transactions, login and database actions and removing orphan users. Expertise in writing T-SQL Queries, Complex Stored Procedures, creating Triggers, Cursors, User-Defined Functions, Joins and Common Table Expressions (CTE). Expertise in Extracting, Transformation and Loading (ETL) using various tools like export/import data and SQL Server Integration Services. Created, Developed, Tested and Deployed Packages into production servers by creating package configurations. Advanced in creating ETL process, Data warehousing. Operations Data Store concepts, data marts and OLAP technologies, Including Star and Snowflake schema. Expertise in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through Drill Down reports using SSRS. Very good knowledge in fine tuning long running T-SQL scripts to simple ones, Creating Indexes, Updating statistics and so on. Experience in transforming data using Data Flow Tasks like Derived Column, Audit, Slowly Changing Dimension, Data Conversion, Row Count, Merge Join, Lookups, Union All etc. Experience in implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Checkpoints and Logging for Complex SSIS Packages. Experience in migration of on-premise SQL Server schemas to the cloud of Azure SQL Server DB and Azure VM, developed and maintained databases across both on-premise and cloud deployments. Experience in Advanced Excel like Power View, Power BI, Power Pivot and Excel Data Connection Adequate in creating and changing the data visualizations in Power BI reports and Dashboards on client requests. Have some experience to use C#, visual basics. Net for script tasks and script components with variables in SSIS. Excellent Analytical, Interpersonal and Communication skills, fast learner, hardworking and versatile team player.