SUMMARY

• 7 years of professional experiences in Database Design, Development and Maintenance as SQL Server Developer/BI Developer using MS SQL Server 2008/2008 R2/2012, SSIS 2008/2010/2012, SSRS 2008/2010/2012 and deeply understood business objectives and processes in Finance Industry, Shipping Industry and Healthcare Industry fields
• Proficient in Microsoft T - SQL (DDL and DML) in constructing Tables and Normalization on database Tables
• Highly proficient in using Microsoft T-SQL to create and optimize database objects - Tables, Views, Indexes, Triggers, Stored Procedure, Transactions, CTEs, Joins and performance tuning
• Expert in using complex T-SQL queries, dynamic SQL, sub-queries and complex joins
• Knowledge of all the phases of Software Development Life Cycle (SDLC)
• Outstanding experience in specifying issues in database, debugging, troubleshooting and improving database performance
• Extensive experience in data extraction, transforming and loading (ETL) using SQL Server Integration Services (SSIS), creating various packages depending on user requirements
• Superior experience in usage of SSIS control flow tasks (For loop, For each loop, Execute SQL task) and data flow tasks such using transformation (Conditional Split, Data Conversion, Loop up, Derived Column, Merge, Union all, Merge join)
• Experienced in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS packages
• Experienced in creating reports for business analysis and management purposes using SQL Server Reporting Services (SSRS)
• Expert in creating Drill down and Drill through, Ad Hoc, parameterized reports, Sub-reports, Snapshots, designing report layout using SQL SSRS
• Expert in involving variety of features using complex expressions to Calculate, Group, Filter and Format the contents of the report
• Experienced in developing OLAP Cubes, Dimensions using SQL Server Analysis Services (SSAS)
• Experienced in using Tableau to generate different types of report
• Excellent Communication skills, has excelled as team player and equally excelled when worked individually

TECHNICAL SKILLS

• T-SQL
• Data Architecture
• SDLC
• MDX
• MS SQL Server 2008/2008 R2/2012
• SQL Server Analysis Services 2008/2010/2012
• SQL Server Integrated Service 2008/2010/2012
• SQL Server Reporting Services 2008/2010/2012
• Report Builder
• MS Access
• MS Excel
• MS Office
• Tableau 7.0/8.0
• MS Windows 8
• MAC OS X
• JAVA
• HTML
• PHP
• ASP.NET
• Dreamweaver

PROFESSIONAL EXPERIENCE

Confidential, Iselin, NJ

BI/ SQL Developer (SSIS, SSRS, SSMS)

Responsibilities:

• Gathered business requirements from sales team and business analyst team, and worked in connection with the enterprise data warehouse architecture on the development of logical data models
• Installed and Configured SQL server 2012 on Development and production server
• Created dynamical queries, Sub-queries, CTEs, Joins, User Defined Function, Transaction, Trigger, Stored Procedure, Index and implemented as the business requirements to manipulate data, secure and optimize database
• Tuned complex SQL queries and Stored Procedures to increase performance and worked on Exception handling with Try/Catch
• Conducted and monitored database management by usingSQL Profiler and DatabaseEngine Tuning Advisor
• Designed and deployed various ETL packages to migrate the data coming from SQL Server and to synchronize daily transaction data by using SSIS
• Incrementally and dynamically transformed data by using SSIS (Conditional Split, Data Conversion, Loop up, Derived Column, Merge, Union all, Merge join, Slowly Changing Dimension)
• Generated reports from SQL Server Databases and OLAP data warehousing
• Developed Matrix reports, Parameterized reports, Drill-through reports, Drill-down reports as per business requirements by using SSRS
• Deployed types of reports into web-portal by using SSRS
• Created visualization reports to show the customer feedback on the services using Tableau

Environment: MS SQL Server 2012, SQL Server Integration Services(SSIS) 2012, SQL Server Reporting Services(SSRS) 2012, SQL Profiler, Tableau 8.0, MS Office

Confidential, Albany, NY

BI/ SQL Developer (SSIS, SSRS, SSMS)

Responsibilities:

• Actively supported business users for change in requests
• Involved in gathering business requirements and provided documentation to plan, define and design data
• Created detailed reports for the sales department to help them analyze the customer behavior and customer feedback and involve in supporting generating reports for end-users
• Performed ETL packages to extract data from OLTP data sources such as Excel, Access, Text files and Oracle, SQL Server using SSIS
• Implemented slowly changing dimension transformation to maintain the historical data in data warehouse
• Created packages with different control flow options and data flow transformations such as Conditional Split, Derived Column, Look up, Data Conversion, Merge, Merge Join
• Extensively used Joins and Sub-queries for complex queries involving multiple tables from different databases
• Created effective User Defined Function, Stored Procedure, Triggers, Transactions to facilitate data consistency and efficient data manipulation
• Developed dynamic SQL queries for reports on Enterprise Data Warehouse(OLAP) and Operational database(OLTP)
• Used Execution Plan to optimize the performance of database
• Created user defined financial reports to provide on demand financial data analysis using Excel and created charts and pivot tables in Excel
• Created Multi-Dimentional cubes using SSAS based on business requirements
• Generated reports of various output formats as requested by the management such as drill down, drill through reports
• Performed complex expressions to group data, filter and parameterize reports
• Deployed the generated reports created using SSRS to the server
• Generated different types of visualization reports using Tableau

Environment: MS SQL Server 2012, SQL Server Integration Services(SSIS) 2010, SQL Server Analysis Services(SSAS) 2010, SQL Server Reporting Services(SSRS) 2010, SQL Profiler, Database Engine Tuning Advisor, Tableau 7.0, MS Office

Confidential, Woodbury, NY

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

Responsibilities:

• Designed Data Warehouse and analyzed various approaches for maintaining different dimensions and facts
• Designed ETL packages with different data sources (SQLServer, Flat files, Excel source files, Oracle) and loaded the data into target tables by performing different kinds of transformations using SSIS
• Used event handler for error handling of Packages
• Used bulk insert in SSIS for faster transfer of data
• Used T-SQL to create tables, views, user defined functions, CTEs, Index for implementing application functionality at the database side for performance improvement
• Modified T-SQL Stored Procedure/Triggers for validating the integrity
• Used ETL packages to extract, transform and load data into data warehouse databases by using SSIS
• Built Multidimensional Expressions (MDX) queries for Analysis Services & Reporting Services
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS
• Created parameterized, drill down, drill through and subreport using SSRS
• Generated weekly and monthly reports for the financial advisors in wealth management team

Environment: MS SQL Server 2012, SQL Server Management Studio(SSMS), MS SQL Server Integration Services(SSIS) 2010, MS SQL Server reporting Services(SSRS) 2010, T-SQL, MS Excel, MS Office

Confidential, Boothwyn,PA

BI/ SQL Developer (SSIS, SSAS, SSRS)

Responsibilities:

• Responsible for designing logical as well as physical database
• Defined data types, created database and database objects such as tables and views
• Tested the table with complex queries such as Joins, Sub-queries and Temp Tables
• Converted complex business logic into T-SQL Stored Procedures and User Defined Functions
• Created indexes (Clustered & Non-clustered) to reduce data retrieval time
• Used Try Catch in stored procedure to perform error log mechanism
• Created ETL packages to migrate data from different data sources to data warehouse by using SSIS
• Created Custom Logging in SSIS packages
• Wrote queries to create drill down, drill through and ad-hoc reports on regional analysis on pharmacy, nursing and benefits services using SSRS
• Actively supported business users for changes in reports as and when required using SSRS
• Used complex expressions to group data, filter and parameterize reports
• Deployed reports on server using SSRS and created linked reports and snapshots
• Designed and created data mart, fact tables, dimension tables and online analytical processing (OLAP) cubes for the analysis of business condition using SSAS

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS) 2010, MS SQL Server Analysis Services (SSAS) 2010, SQL Server Reporting Services (SSRS) 2010, T-SQL, MS Office

Confidential

MS SQL Server Developer (T-SQL, SSIS, SSRS)

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2005 and MS Access Databases
• Developed logical and physical database by using Normalization
• Developed complex T-SQL in creating tables, constraints, indexes and views
• Designed and Implemented the Stored Procedures and Triggers for automating tasks
• Generated daily reports by using SQL queries and Stored Procedures
• Analyzed database growth and space requirement
• Created ETL packages to extract data from global datacenter and load data to local datacenter
• Involved in generating and deploying various reports such as parameterized reports, matrix reports by using expressions and parameters

Environment: MS SQL Server 2008, MS Access, T-SQL, SQL Server Integration Services (SSIS) 2008, MS SQL Server Reporting Services (SSRS) 2008, MS Office