SUMMARY

• Over 8 years of experience in IT industry performing Database Design, Development and Database Administration using SQL Server 2012/R2/2008/2005 in DEV, TEST and PRODUCTION environments with various domains like Financial, Insurance and Health Care.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using BCP utility and Import Export Wizard / SSIS services.
• Expertise in data validation, data scrub and data cleanse using fuzzy lookup, fuzzy group, derived column and DQS (Data Quality Service) in SSIS.
• Experience in software Analysis, Design, Development, Testing, Implementation and Production Support of Client/Server and Web based applications.
• Experienced in Conceptual Model Design, Logical Model Design and Physical Model Design.
• Expertise in T - SQL (DDL, DML), Complex Queries, Tables, Views, Stored Procedures, Indexes, Cursors, User Defined Functions and Triggers.
• Experienced in Installing, Configuring, Managing, Upgrading, Migrating, Monitoring and Troubleshooting of SQL Server SQL Server 2012/R 2/2008/2005.
• Expertise in creating Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, FTP Task and Data Flow Task.
• Expertise in creating Transformations like Lookup, Derived Column, Conditional Split, sort, data Conversion, multicast, Derived column, Union All, Merge Join, and OLEDB Command.
• Expertise in creating data sources and data source views (DSVs), named calculations and named queries.
• Expertise in Configuration, Logging, Error Reporting and Variables in SQL Server Integration Services to make package portable which Deployment and Troubleshooting.
• Designed and developed OLAP Cubes with star schema and Dimensions using SSAS. Querying and manipulating multidimensional cube data through MDX Scripting.
• Experience in performing Data Conversion, Data Scrubbing, and Data Transformations with SSIS Packages and stored Procedures.
• Experience in design and implement processes for Deploying, Upgrading, Managing, and extracting data for reporting using SQL Server Objects.
• Good knowledge of working with MySQL, DB2 and OOPS Concepts.
• Generated parameterized queries for tabular, matrix reports using SQL Server reporting services (2005/2008)
• Experience in creating drill down, linked, sub cascading reports and Reports in SSRS.
• Highly organized with the ability to manage multiple projects and meet deadlines, quickly grasp and master new concepts and technologies.
• A team player with excellent interpersonal, communication and presentation skills, excellent oral / written communication and interpersonal skills.

TECHNICAL SKILLS

• MS SQL Server 2012, 2008/2008R2, 2005
• Business Intelligence Development Studio
• Enterprise Manager
• Query Analyzer
• Profiler
• Performance Monitor
• DDL
• DML
• Stored Procedures
• Triggers
• SSIS
• SSAS
• SSRS
• Windows 7/XP/98
• Data Migration
• Import/Export Wizard
• MS Excel
• JavaScript
• C++
• C#.NET
• T-SQL
• MS Visio 2000/2003
• Visual Studio 2005/2010

PROFESSIONAL EXPERIENCE

Confidential, Orlando, FL

MS SQL Server Developer

Responsibilities:

• Involved in gathering market data and requirements, analysis, and specifications of the system.
• Created ETL package on different data sources, transformed all kinds of source files and load them into data base.
• Designed and created tables, indexes, and views based on user requirements.
• Used Conditional Split, Derived Column, which were used for Data Scrubbing, data validation before loading the data into the Data warehouse.
• Responsible for developing processes, tuning SQL Server, locks and indexes configurations, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.
• Set up scheduled jobs in SQL server using Agent.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Developed and maintained the OCPS students’ information website using JavaScript and Jquery.
• Utilized Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, and Data Flow Task and transformations like Derived Column, Conditional Split, Lookup, Merge, Sorting, Merge Join, Fuzzy Grouping, Fuzzy Lookup, Row Count, Data Conversion etc.
• Designed and developed various service management reports, utilizing dynamic and cascading prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Created data loads and Upgrade scripts for data migrations and validations

Environment: MS SQL Server 2008R2/2012, SQL Server Integration Services(SSIS), JavaScript, Jquery Enterprise Management Studio, MS Query Analyzer, SQL profiler and SQL Server Reporting Services (SSRS), MS Excel.

Confidential, Northbrook, IL

MS SQL Server/ BI Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Used Data profiling task to analyze the quality of the customer data from various sources and created SSIS packages to store consistent data in central repository.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition of the reports.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Used Merge in development, test and production for changing the referenced data.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.

Environment: MS SQL Server 2008R2/2012, SQL Server Integration Services(SSIS), Enterprise Management Studio, MS Query Analyzer, SQL profiler and SQL Server Reporting Services (SSRS), MS Excel, MS Visual Studio.NET# 2008.

Confidential, Libertyville, IL

MS SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Gathered user requirements and analyzed and designed software solution and database.
• Designed the Entity Relationship(ER) models.
• Extensively worked on full Software Development Life Cycle (SDLC) of the project from Database Design and Modeling to implementation and maintenance.
• Designed and Developed SSIS Staging Packages to Stage Source files to SQL Server Source Database
• Developed ETL packages with different data sources (SQL Server, Flat Files, Excel source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.
• Designed various packages using various task e.g. For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
• Involved in Loading Dimension with the SSIS slowly changing Dimension Wizard.
• Experience in performance tuning of SSIS Packages using row transformations.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.
• Created complex Stored Procedures for validation process & for loading data from the staging area to the product database in SQL 2008.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS.
• Deployed SSIS packages from Development to Testing Servers
• Worked on all activities related to the development, implementation and Support of ETL processes for large-scale Data Warehouses using SQL Server SSIS
• Created and developed query for Tabular and Matrix Reports using SQL Server 2008 Reports Services (SSRS)
• Created Drill-through reports, parameterized reports and linked reports using SSRS 2005 and 2008.
• Worked on Report generation using SQL Server Reporting Services (SSRS) that could be used to send information to Client.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Reports migrations from Actuate to SharePoint/SSRS technology.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Promoted Reporting Definition Language (RDL) to Reporting Service Server (SSRS).

Environment: SQL Server 2008, 2008R2, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SSAS, Visual Studio 2008/2010, Business Intelligence development studio, .NET, SQL Management Studio 2012,MS Excel.

Confidential, Columbia, MD

MS SQL Server/ BI Developer

Responsibilities:

• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Created joins and sub-queries for complex queries involving multiple tables.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Created data loads and Upgrade scripts for data migrations and validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Worked on SSRS to generate more than 60+ reports for various user groups and developer groups.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Created various Weekly and Monthly reports showing detailed information.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Implemented Unit Tests and Integration Tests.
• Prepared documentation related to database design, objects security and rules.

Environment: SQL Server 2008R2, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.

Confidential, Austin, TX

MS SQL Server/ SSIS/SSRS Developer

Responsibilities:

• Wrote T-SQL Tables, Stored procedures, Views and Triggers for performing database operations on SQL Server 2008.
• Designed, developed & tested complex SSIS ETL Packages to pull data from sources like Flat Files, Excel Files, Various databases (DB2, SQL), JDE and other web applications into the Data warehouse System.
• Utilized Control Flow Tasks like For Loop Container, For Each Loop Container, Sequential Container, and Data Flow Task and transformations like Derived Column, Conditional Split, Lookup, Merge, Sorting, Merge Join, Fuzzy Grouping, Fuzzy Lookup, Row Count, Data Conversion etc.
• Configured and maintained Report Manager and Report Server for SSRS.
• Installed and administered Microsoft SQL Server Reporting Services, created schedule reports and sent reports via email.
• Developed queries for generating drill down reports in SSRS 2008.
• Generated and tested reports using Global Variables, Expressions and Functions for the reports.
• Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2008.
• Created connections to source data by creating Linked Servers using ODBC drivers and OLEDB Providers to move data into Source system (SQL Server database).
• Designed and Generated Reports with SQL Server Reporting Services (SSRS).

Environment: SQL Server 2008/2005, Java Scripts, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), T-SQL, ETL, SQL Management Studio 2012, MS Excel

Confidential

MS SQL Server / Crystal Report Developer

Responsibilities:

• Involved in gathering requirements, analysis, and specifications of the system.
• Created reports on purchases charged to grants, contracts, sponsored programs, restricted funds by specific expenditure policy of the funding source.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize the procedures and triggers to be used in production.
• Designed and developed various service management reports, utilizing dynamic and cascading prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports.
• Involved in scheduling the monthly and weekly reports.

Environment: MS SQL Server 2000, T-SQL, SQL Management Studio 2012, MS Excel, Crystal Report,