SUMMARY

• A Dynamic Professional with 8+ years of experience in Development and Database maintenance using MS SQL Server 2014/2012/2008 and developing T - SQL queries, ETL packages, and reports using SQL Server Management Studio (SSMS), Microsoft BI Stack (SSIS/SSRS), and Tableau.
• Experience in working various fields like Media, Banking and Retail Business services.
• Experience in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Expert in Data Extraction, Transforming and Loading (ETL) from various data sources to destinations Data using Connections provided by SSIS.
• Experience in using transformations like Aggregate, Data conversion, Lookup, Merge, Multicast, Sort and Conditional Split in SSIS.
• Hands on experience working with SSIS for ETL process ensuring proper implementation ofEvent Handlers, Error handling andpackage configurations.
• Expert in Import-Export Data and load into various Business Entities.
• Good in deploying Packages to file system and Sql server.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS) and Data Transformation Services (DTS).
• Expert in developing Reports like Tabular and Matrix Reports using SQL Server Reporting Services (SSRS).
• Experience in developing Drill Down, Cascading, Parameterized and Sub reports using variables and expressions for the business users.
• Good in maintenance and Administration of SSRSby creating Job schedule, SQL Mail Agent Packages.
• Experience in Dynamic SQL, Collections and PL/SQL Tables.
• Experience in T-SQL queries like Views, Triggers, Stored procedures, Indexes and User-Defined Functions.
• Expert in creating Sub-Queries and Joins for queries involving multiple tables.
• Excellent technical skills with clear understanding of ER modeling for OLTP.
• Hands on experience in working with project team using Waterfall Model.
• Involved in Query Optimization and Query Performance Tuning using SQL Profiler.
• Great understanding of Relational Database Management Systems (RDBMS).
• Proficient in SQL Server and T-SQL in constructing Tables, Normalization techniques on database Tables.
• Expertise in Data Modeling for Moderate to Large Data Systems.
• Experience in the Latest BI Tools Tableau, Dashboards in latest Design and Presentation.
• Well versed in Performance Designed Dashboards and reports using and SSRS Reports.
• Good knowledge of Kimball design methodology.
• Experience in Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC).
• Experience in working with MS SQL Server Analysis Services (SSAS) in creating OLAP cubes.
• Involved in Staging Partitions and mechanisms for databases.
• Experience in Database Architecture based on functional requirements and system design of the client using RDBMS concepts.
• Experienced in Data Conversion, Normalization and Data modelling using SQL Server Enterprise manager.
• Good work ethics with excellent communication and interpersonal skills with a strong attitude towards technologies quickly supporting the project requirements.

TECHNICAL SKILLS

• MS SQL Server 2014/2012/2008 R2
• SQL
• T-SQL
• MS Visual Studio 2008/2010/2013 SQL Server Integration Services (SSIS)
• SQL Server Reporting Services (SSRS)
• SQL server management studio(SSMS)
• SQL Server Data Tool(SSDT)
• BI tools
• SQL Server Agent
• Business Intelligence Development Studio (BIDS)
• SQL Server Analyzer & Profiler
• Tableau 9.0/9.7
• Informatica
• PL/SQL
• C#
• .NET
• Teradata
• MS SQL Server Analysis Services (SSAS)
• C
• Java
• Team Foundation Server 2010 (TFS)
• Windows 2007/08/10 and MS Office Suite (Excel
• PowerPoint
• Word
• Outlook).

PROFESSIONAL EXPERIENCE

Confidential, New York

MS SQL BI Developer (SSMS, SSIS, SSRS, Tableau)

Responsibilities:

• Developed ETL using SSIS including data extraction, transformation and Loading between multiple data sources and destinations.
• Worked extensively on configuring the transformations in SSIS.
• Performed data conversions from Flat files into a Normalized database structure.
• Designed and implemented SSIS packages to migrate data from heterogeneous data sources to staging area and load the data to data warehouse.
• Transformed and Loaded data into SQL server database using OLE DB connection by creating various SSIS packages.
• Worked on creating SSIS packages by deploying them to the Sql server and executing the Packages in Development.
• Designed ETL Packages using SQL Server Integration Services (SSIS) and troubleshot Packages using Event Handler and Logging.
• Developed various types of Reports like Tabular Reports and Drill Down reports using SSRS.
• Developed Cascading, Parameterized and Sub reports using variables and expressions for the business users.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2010.
• Extensively used collection in PL/SQL objects for improving the performing.
• Used Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections.
• Created Dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Developed dashboard reports using Reporting Services and reporting.
• Wrote efficient stored procedures for the optimal performance of the system.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created reports to retrieve data using Stored Procedures that accepts parameters.
• Created Stored procedure, Indexes, Constraints and User Defined Functions.
• Created views to facilitate easy user interface implementation.
• Involved in developing triggers to audit schema changes at the database level.
• Responsible for Creating and Modifying T-SQL stored procedures/ triggers for validating the integrity of the data.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Worked on writing the queries, joining multiple tables to make changes in the tables.
• Used Query Analyzer to optimize SQL queries.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent.
• UsedSSISto create ETL Packages to validate, extract, transform and load data to data mart databases.
• Loading data from various sources to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Environment: MS SQL server 2014/2012, SQL Server Management Studio (SSMS), T-SQL, SQL Server Data Tools (SSDT), Microsoft Visual Studio 2013/2010 for SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), Tableau 9.7 and MS Excel

Confidential, Bridgeport, CT

MS SQL BI/ETL Developer, Tableau

Responsibilities:

• Worked on ETL in creating SSIS packages, building, deploying and executing the packages in the environment.
• Designed and implemented SSIS packages to migrate data from heterogeneous data sources to staging area and load the data to data warehouse.
• Designed and tuned ETL packages which utilized tasks such as Data Flow Task, Sequence Containers to load several folders into databases.
• UtilizedSSIS(SQL Server Integration Services)to produce a Data Martfor reporting.
• Worked on import & export of data from Text to SQL Server in SSIS.
• Worked with various sources in the data flow tasks and used various transformations like Aggregate, merge, multicast, data conversion, sort and conditional split
• Troubleshoot ETL Packages and read Logging files to solve the issues of package failure.
• Created Tabular, drill down reports using SSRS 2010 for Sales department.
• Involved in deploying of requested Reports.
• Generated daily, weekly and monthly reports as per the customer requirements using subscriptions and maintained the snapshot history.
• Developed numerous reports using SSRS for day to day financial reporting.
• Created records, tables, collections for improving Query performance.
• Used Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Created Dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Developed dashboard reports using Reporting Services.
• Responsible for creating datasets using T-SQL and stored procedures.
• Participated in creating reports that deliver data based on stored procedures.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created Views to reduce database complexities for the end users.
• Created Constraints, Written and executed T-SQL queries like Stored Procedures and Triggers using SQL Server Management Studio.
• Worked on import & export of data from Text, Excel to SQL Server.

Environment: MS SQL server 2012, T-SQL, MS SQL Server Data Tools (SSDT), Visual Studio 2010 for SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS), SQL server management studio(SSMS), SQL Server Agent, Tableau 9.7 and MS Excel.

Confidential, Houston, TX

MS SQL BI /ETL/SSRS Developer

Responsibilities:

• Created SSIS Packages to migrate slowly changing dimensions.
• Extracted Data from various sources like flat files to SQL Server database Using SSIS Package.
• Used various loop Containers in SSIS for Control Flow.
• Designed ETL Jobs/Packages using SQL Server Integration Services SSIS and troubleshot Packages using Event Handler and Logging.
• Maintained existing and created new relational and OLAP data warehouses using ETL processes.
• Created tabular, drill down and parameterized reports using SSRS.
• Experience in creating snapshots of static reports and configure subscription.
• Wrote efficient stored procedures for the optimal performance of the system.
• Created new database objects like Triggers and Views using T-SQL in SQL Server 2012/2008.
• Encapsulated frequently used SQL Statements into stored procedures there by reducing the execution time.
• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• Created views to facilitate easy user interface implementation.
• Created indexed views and appropriate indexes to reduce the running time for complex queries.
• Designed, developed and tested processes, which include the creation of scripts.
• Loading data from various sources to SQL Server database Using SSIS Packages and created data mappings to load the data from source to destination.
• Worked on Agile methodology.
• Tested the Installation of SQL Server.
• Used Query Analyzer to optimize SQL queries.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling.
• Involved in creating ER diagrams and mapped the data into database objects.
• Involved in the complete life cycle of the project, from Planning Staging and pushing the codes to production.
• Experienced in Developing SSAS Cubes and Deploying and Processing SSAS objects.

Environment: SQL server 2012/2008 R2, T-SQL, SQL Server Integration Services (SSIS) 2010, SQL Server Reporting Services (SSRS) 2010, SSMS and MS Excel.

Confidential, San Francisco, CA

SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Involved in data warehouse and ETL development.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Worked with various containers in the control flow task such as For Loop, For Each Loop.
• Extracted and reviewed data from heterogeneous sources like (Excel, flat file, Text Format Data) using SQL (SSIS).
• Created SSIS packages using term extraction, execute SQL task to generate underlying data for the reports and to export cleaned data, excel spread sheets, text files to data warehouse / Oltp DB.
• Used scripts and variables, email notifications for ETL process using Data Integrator.
• Created various SSIS packages by extracting data from various sources according to the requirements.
• Generated various reports like Cascade type reports and Drill down reports.
• Created sub-reports, tabular, parameterized and reports.
• Performed logical and physical data modeling.
• Designed and developed Cubes using SQL Server Analysis Service (SSAS).

Environment: SQL server 2008 R2, T-SQL, SQL Server Integration Services (SSIS) 2008, SQL Server Reporting Services (SSRS) 2008, SSMS, SQL Server Analysis Services (SSAS) and MS Excel.

Confidential, Lansing, MI

SQL Server Developer

Responsibilities:

• Created views to facilitate easy user interface implementation.
• Created Business stored procedures and functions to support efficient data storage and manipulation.
• Developed ETL using SSIS including data extraction, transformation and Loading between multiple data sources and destinations.
• Worked extensively on configuring the transformations in SSIS.
• Transformed and Loaded data into SQL server database using OLE DB connection by creating various SSIS packages.
• Involved in developing triggers to audit schema changes at the database level.
• Worked on improving the performance of the system.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Making a Report as per user requirement using MS Reporting Services.
• Created sub-reports to present more detailed information about the summary.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.

Environment: SQL server 2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SSMS and MS Excel.