SUMMARY

• Seven years of extensive experience in Database design and development on MS SQL Server applications in multiple domains such as Learning Management Systems, Banking and Retail domain using Integration Services (SSIS), Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
• Solid experience in designing and developing Reports using SSRS in Microsoft BI environment.
• Expert in creating SQL Server Reports such as Drill Down Reports, Matrix and Linked Reports, Sub Reports, Indicators, Gauges, Cascading Parameters, Charts and Basic Maps.
• Experience in creating Reports using Data Driven Subscription and Snap Shots in Report Manager.
• Expert in creating SSIS packages for ETL (Extracting, Transforming and Loading) of data.
• Experience in Designing Packages using Control Flow Task such as For Loop Container, Foreach Loop Container, Sequence Container, Execute SQL Task and Data Flow Task.
• Hands on Experience in creating SSIS packages using various Transformation such as Derived Coulmn,Conditional Split, Data Conversion and Merge Join to Load data into SQL Server Destination, Excel Destination, Flat File Destination and Data Reader Destination.
• Expert in deploying the packages in multiple environments like File System and SQL Server Environment.
• Good Understanding of Star Schema, Snowflake Schema, OLTP, OLAP systems, Data warehouse and Data mart concepts.
• Experience in Developing and Extending SSAS Cubes, Dimensions, Data Source Views, Basic MDX Queries, Deploying and Processing SSAS objects.
• Experience in building analytical data models using Power Pivot for Excel Add - in.
• Excellent knowledge in creating Database, Tables, Stored Procedures, Views, Indexes, Functions, Triggers and Complex Queries on SQL Server.
• Experience in using tool like MS SQL Profiler, Query Execution plan, Windows performance for monitoring and tuning SQL Server Performance.
• Hands on experience in TFS build automation, publishing build using Visual Studio.
• Experienced in working with project team through all phases of Software Development Life Cycle (SDLC) - Project Analysis, Requirements, Design, Development and Testing.
• Hands on experience in working project team using agile methodology.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and strong analytical skills.
• Strong team player. Ability to work independently and in a team environment and actively participate in projects within work groups and across organizations.

TECHNICAL SKILLS

• MS SQL Server 2005/2008/2008 R2
• SQL Server 2016/2014/2012
• Windows 7/ 10
• SQL Profiler
• Oracle 8
• Microsoft BI Tool SSRS/SSIS/SSRS
• T-SQL
• Visual Studio 2008/2010/2013
• Report Builder 3.0
• SQL Server Agent
• C#
• ASP.NET
• Crystal Report
• MS Access
• Black Box Testing

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

MS SQL Server Developer/SSIS/SSRS/SSAS

Responsibilities:

• Involved in Designing and Developing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems using SSIS.
• To maintain and restore the SQL databases across various environments.
• Designed SSIS ETL packages to extract and load from different data sources including SQL Server, Flat Files, Excel Files, and XML Files etc.
• Developed packages using Control Flow Task like For Loop Container, Foreach Loop Container, Sequence Container, Execute SQL Task and Data Flow Task to load the Data.
• Data mapping the transformation using Derived column, Conditional Split, Data Conversion, Merge Join and Lookup.
• Created Deployment utilities to deploy the package using File System Deployment and SQL Server and Implemented Error handling using Event Handlers.
• Schedule the SSIS packages through SQL agent jobs.
• Designed and Developed Business Intelligence data model using SSAS and created dimension and fact table in dataware house systems.
• Generated ad hoc reports and designed attractive report pages based on clients’ request.
• Developed matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports using SSRS.
• Created Matrix Reports with all aggregate functions and expressions, dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Developed T-SQL stored procedures, functions, Views and data load scripts for the product development team.

Environment: MS SQL Server 2012, SSIS, SSRS, SSAS, SQL Server Business Intelligence Development Studio(BIDS), Windows 7/10, T-SQL, Microsoft SQL Server Management Studio(SSMS), Visual Studio, MS Excel 2013

Confidential, Phoenix, AZ

MS SQL Server Developer/SSIS/SSAS/SSRS

Responsibilities:

• Developed Data Mapping to map the data from data mart to Enterprise Data Warehouse.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems using SSIS.
• Developed packages using Foreach Loop Container to load the bulk files from source files.
• Created multiple transformation task using Conditional Split, Merge Join and Derived Column.
• Exposed to ETL architecture for overall data transfer from the source database to EDW.
• Debugged SSIS package with breakpoint and event handlers and deployed the packages.
• Presented SSRS Report with collected requirements in communication with BA.
• Arranged SSRS reports for daily, monthly basis update with SQL Server Agent.
• Defined cube, reviewed cube, modified cube and documentation accordingly.
• Participated designing Database Warehouses with multi-dimensional models using Star Schema principle.
• Enhanced Stored procedures to build dimensions and load data to fact table for transforming data from data mart to data warehouse.
• Generated T-SQL Scripts, Stored procedures, triggers, cursors, tables, views for application.

Environment: MS SQL Server 2012, SSRS, SSAS, SSIS, SQL Server Data Tools, MS Access, Windows 2007, T-SQL, MS Excel

Confidential, Bridgewater, NJ

MS SQL Server /BI Developer

Responsibilities:

• Actively involved in Business meetings and requirement gathering sessions.
• Involved in creating and deploying reports using SQL Server Reporting Services.
• Utilized SSRS reports from different source formats and satisfying clients by representing reports and presentations.
• Generated drill-down, drill-through, sub reports, chart reports, multi parameterized reports.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Administrated and scheduled mailing subscriptions on SSRS reporting server.
• Developed dependent, dynamic menu objects to allow end-users selection and data filtering capabilities.
• Created Matrix Reports with all aggregate functions and expressions, dashboard SSRS reports under report server projects and publishing SSRS reports to the reports server.
• Generated T-SQL Scripts, Stored Procedures, triggers, cursors, tables, views for application.

Environment: MS SQL Server 2008, SSRS, Microsoft Visual Studio Team System(VSTS), Windows XP, Crystal Reports, T-SQL, MS Excel

Confidential, South Plainfield, NJ

MS SQL Server Developer/SSAS/SSRS Developer

Responsibilities:

• Developed Drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Expressions and Functions based on the requirements in SSRS.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Created Report Snapshots to improve the performance of SSRS.
• Responsible for updating staging and dimensional databases as well as rebuild the dimensions and cubes in Analysis Services (SSAS).
• Experienced identifying the dimension, fact tables and designed the data warehouse using star schema.
• Deployed reports to the reports server and report manager.
• Involved in troubleshooting performance issues and fine-tuning queries and stored procedures.
• Generated T-SQL Scripts, Stored Procedures, triggers, cursors, tables, views for application.

Environment: MS SQL Server 2008, T-SQL, SSRS, SSAS, BIDS, MS-Excel, Power Pivot, SQL Server Agent

Confidential

MS SQL Server/BI Developer

Responsibilities:

• Analysis, Design and Development of database using ER Diagram, Normalization and relational database concepts.
• Designed and Developedcomplex Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Indexes andSQLjoins.
• Optimized query performances in T-SQLqueries and stored procedures, eliminating redundant and inconsistent data.
• Maintenance of database by monitoring performance and data integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Applying constraints and configuring triggers to apply the business rules. Backing Up & Restoring User Databases.
• Cross functional coordination between Business and technical teams for Requirement Gathering.

Environment: MS SQL Server 2008, SSIS, SSRS, Visual Studio, Management Studio, MS Excel