PROFESSIONAL SUMMARY * 8 years of experience in IT industry and Data Modeling, Database Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2014/2012/2008R2/2008/2005/2000. * Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases. * Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server. * Experienced in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS). * Had knowledge in integrating and transforming data from different data sources like Oracle, DB2, Excel, and Flat Files to SQL Server 2008R2 using OLE DB connection providers by creating various SSIS packages. * Performed several transformations and data cleansing on data including fuzzy lookup, slowly changing dimension, union all, merge join and check points/break points. * Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS. * Expertise in Developing and Extending MS SQL Server Analysis Services 2005 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries. * Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services (SSRS). * Experienced in creating ad-hoc, drill-down, sub-Report, parameterized, cascading parameterized, drill-through, chart, tabular, matrix reports. * Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS. * Had knowledge in scheduling the reports weekly and monthly basis as per the Client Requirements. * Excellent experience in Designing, Maintaining & Tuning various RDBMS like SQL server 2000/02005/2008/2008 R2, MS Access databases and strong knowledge of SDLC principles. * Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables. * Excellent T-SQL Developer skills including Stored Procedures, Indexed Views, User Defined Functions, Triggers, and Distributed Transactions. * Good understanding of Databases, SQL and Data warehousing/marts. * Highly motivated team player with excellent communication and problem-solving skills. Quick learning ability.

Highlights:

• Microsoft SQL Server
• Stored Procedures
• Information Technology
• Microsoft Visual Studio
• ETL
• TSQL
• SSRS
• SSIS