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 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 different transformations in SSIS.
• Hands on experience working with SSIS for ETL process ensuring proper implementation of Event Handlers and package configurations.
• Good in deploying Packages to file system and Sql server.
• 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 SSRS by creating Job schedule and SQL Mail Agent Packages.
• Experience in T-SQL queries like Stored procedures, Indexes, Triggers, Views and User-Defined Functions.
• Expert in creating Joins for queries involving multiple tables.
• Expert in Import-Export Data and load into various Business Entities.
• Involved in Query Optimization and Performance Tuning using SQL Profiler.
• Proficient in SQL Server and T-SQL in constructing Tables, Normalization techniques on database Tables.
• Experienced in Normalization and Data modelling using SQL Server Enterprise manager.
• 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.
• Excellent technical skills with clear understanding of ER modeling for OLTP.
• Migration experience from MS SQL Server 2008 to MS SQL Server 2012.
• Expertise in Data Modeling for Moderate to Large Data Systems.
• Extensive experience as a solution for information systems, focusing on database architecture and application integration.
• Good knowledge of Kimball design methodology.
• Experience in Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC).
• 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, Erwin Data Modeler, Power BI, PL/SQL, C#, .NET, Teradata, Python, 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, Tampa, FL

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

Responsibilities:

• Developed ETL using SSIS including data extraction, transformation and Loading between multiple data sources and destinations.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Worked extensively on configuring the transformations in SSIS.
• 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 by creating various SSIS packages.
• Worked on creating SSIS packages by deploying them to the Sql server and executing the Packages in Development.
• Developed various types of Reports like Tabular Reports and Drill Down reports using SSRS.
• Designed and created Report templates, bar graphs and pie charts.
• 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.
• 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.
• Data migration using DTS services across different databases like flat files.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling.
• Established the SQL BI suite of tools as the preferred standard for presentation and worked to optimize the application architecture.
• Experience with Data Cleansing, Data Profiling and Data analysis.
• Wrote efficient stored procedures for the optimal performance of the system.
• 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.
• 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.

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, Team Foundation Server 2010 (TFS) and MS Excel

Confidential, Minneapolis, MN

MS SQL BI/ETL Developer (SSIS), SSRS, 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.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Experienced migration of data from various OLTP data sourcessuch as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for 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.
• Data migration using bulk copy program and DTS from Databases and Flat files.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.
• 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.
• Owned and managed all changes to the Created data models, solution designs and data architecture.
• 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, Des Moines, IA

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 a nd MS Excel.

Confidential, San Francisco, CA

SQL Server BI 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) a nd MS Excel.

Confidential

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.
• Involved in extracting the data using SSIS from OLTP pre-staging to OLAP staging.
• 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 a nd MS Excel.