Professional Summary
- Over 6 Years of experience in BI solutions using T-SQL, SSRS, SSIS, SSAS and Data modeling, Database Design, Programming using DDL, DML, DCL commands for various business applications. - Interacted with technical team and Business users to perform analysis of business requirements and transformed them into technical requirements for ETL and Reporting needs. - Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases. - Experience in Creating Tables, Views, Complex Stored Procedures to facilitate efficient data manipulation, data integrity and other T- SQL statements for various applications. - Optimized the T-SQL query performance with modifications in T-SQL queries, removing unnecessary columns, establishing necessary joins. - Experience in coding the T-SQL using the Temp tables, Table variables by analyzing the Business logics. - Generated complex Transact SQL(T-SQL) queries, Sub queries, Co-related sub queries, and Dynamic SQL queries. Programming in SQL Server - Using the Stored Procedures, Triggers, User-defined functions and Views, Common table expressions (CTEs) - Proficient in Performance Tuning/Query optimization using indexes. Tuning the performance of stored procedures and large T-SQL Queries using Clustered Indexes, efficient coding standards. - Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency. - Expertise in Migrating the DTS packages to SSIS and to SSDT. - Well experience in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS) 2008/2008 R2/2012/2014 and 2016 - Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS. - Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring various Connection Managers using SSIS. - Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS. - Involved in usage of various SSIS components such as For loop, For-each loop, Fuzzy lookup and hands on experience in Event Handlers, Error Handlers etc. - Experienced in creating master and child packages, Package Configurations and Logging Using SSIS. - Excellent knowledge of using Variables and Expressions in packages of SSIS. - Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling SSIS Packages - Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the business users. - Experience in different type of reports including Tabular forms, Matrix form, Conditional, Drill down, List items, Charts and Sub Reports. - Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS) 2008 R2/2012/2014 - Involved in handling Enterprise wide reporting needs using SQL Reporting Services, Crystal Reports. - Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling for FACT and Dimension Tables using SQL Server Analysis Services. - Worked in dimensional modeling with Star & Snowflake schemas and created the Data Source Views (DSV) and SSAS Cubes using the identified Fact and Dimensional Tables. - Experienced in writing Queries using SQL Server Analysis Services (SSAS). - Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures and Partitions. - Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements. - Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project