Professional Summary:

• Over 8 years of Information Technology development experience on Database Design and Development in SQL server 2012/2008R2/2008/2005/2000 system in OLTP and OLAP environment in various industries like Health Care, Insurance and Finance.
• A motivated, highly organized individual and enthusiastic team player with excellent communication, analytical and problem solving skills.
• Have in-depth knowledge of T-SQL Data Definition Language, Data Manipulation language
• Created tables, views, user defined functions, cursors, derived tables, common table expressions CTEs and Triggers to facilitate efficient data manipulation and data consistency
• Dealt extensively with Relational Database Management Systems, including ERD data modeling, Normalization, Constraints, Querying, Joins, Keys, Data Import/Export
• Wrote sub-query, correlated sub-query, complex Stored Procedures and ad-hoc TSQL statements
• Encapsulated Ad-hoc TSQL statements into Store Procedures for Optimization
• Wrote ad-hoc queries utilizing Dynamic SQL and SQLCMD command line utility
• Created and maintained Clustered Index and Non Clustered Index
• Implemented ETL Packages using SSIS 2012/2008R2/2008/2005/2000, creating SSIS,DTS packages for large data transfers between MS-SQL Servers and automating using SQL jobs
• Implemented all transformations available on the SSIS toolbox
• Created master and child packages, package configurations and logging
• Used variables and expressions in packages
• Extracted, transformed, and loaded data ETL between Homogenous and Heterogeneous System using SQL tools SSIS, DTS, Bulk Insert, BCP, and XML
• Created Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages
• Generated reports using MS Reporting Services 2012/2008R2/2008/2005/2000
• Configured report server and report manager scheduling, gave permissions to different level of users in SQL Server Reporting Services SSRS
• Generated on-demand and scheduled reports for business analysis or management decisions using SQL Server Reporting Services
• Done performance tuning by using SQL Server Profiler and database tuning advisor
• Excellent technical and analytical skills with a clear understanding of data architecture, metadata, design goals of ER modeling for OLTP and dimension modeling for OLAP
• Calculated measures and dimension members using multi-dimensional expression MDX , mathematical formulas, and user-defined functions
• Scheduled and deployed reports, and uploaded files to a report server catalog from the report manager
• Designed and implemented relational database model as per business needs
• Used Informatica PowerCenter to integrate the data for the enterprise
• Analyzed, designed, developed, tested and implemented systems following the SDLC

Business Technical skills:

MSSQLServer2012/2008R2/2008/2005/2000,SSRS2012/2008R2/2008/2005/2000, SSAS 2012/2008R2/2008/2005/2000, SSIS 2012/2008R2/2008/2005/2000, DB2, MS-Access 2000, MS Excel, Erwin 8.0/7.2/7.1, MS Visio 2010/2007/2005, .NET, VB 6.0, Oracle 11g/10g, T-SQL, PL/SQL, HTML, XML, XSL, Java script, VB Script, C , Visual Studio 2012/2008 R2/2008/2005/2000, ODBC, MS office, Windows NT/ 2000 Server/ XP.

PROFESSIONAL EXPERIENCE:

Confidential

Role: SQL Server/ SSIS / SSRS Developer

CareFirst BlueCross BlueShield is a large health insurance company. The aim of the project was to load the data from the heterogeneous sources into the DW and generating Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports as per the business requirements.

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Agile SDLC model system.
• Performed all SDLC phases related to extract, transform, and load ETL processes using SQL Server Integration Services SSIS and SQL Server T-SQL stored procedures within SQL Server 2012 environment.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints and created Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Performed User Defined Functions for giving Scores and views for the application.
• Deployed, monitored SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Full load Incremental load with several Data Flow tasks and Control Flow Tasks using SSIS.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.
• Implemented Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.
• Generated Parameterized, Drill-through, and Drill-down Reports to get monthly customers account details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Tools Technologies:

MS SQL Server 2012, T- SQL, Power Pivot, MS Excel 2007/2003, Microsoft SQL Server Integration Services SSIS , Microsoft SQL Server Reporting Services SSRS , Microsoft SQL Server Analysis Services SSAS ,SQL Server Business Intelligence Development Studio, Team Foundation Server TFS ,Visual Source Safe VSS , ERwin 8.0/MS Visio 2010

Confidential

Role: SQL Server/SSIS/SSRS developer

American International Group is a large global insurance company. The major part of the project was creating the packages for extracting, migrating, loading data in data warehouse and creating Tabular reports, Matrix reports, Gauges Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as per the requirements.

Responsibilities:

• Participated with Business Analyst in order to gather requirements for design and implementation of database.
• Designed logical/physical data models using Erwin tool 7.2.
• Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL mapping processes and maintained the mapping documents.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into data warehouse using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension SCD to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard and deploy packages to production Server.
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Increased query performance, necessary for statistical reporting by more than 25 after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Designed and developed SSIS ETL/SSIS packages to validate, extract, transform and load data from OLTP systems to the Data warehouse and Report-Data mart
• Designed and developed different type of reports including Tabular forms, Matrix cross Tab report form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription Data Driven and Standard to publish reports.
• Integrated report using ASP.net application.

Tools Technologies:

MS SQL Server 2008R2, Enterprise Edition, MS SSRS 2008R2, .NET, MS SSIS 2008R2, T-SQL, ASP.net, VB Script, Windows Server 2007, Erwin 7.2,

Confidential

Role: SQL Server/SSIS /SSRS Developer

The goal of the project was to enhance the Claims Management and Reconciliation CMR Health Information Management/Enterprise Document Management System, which included changes and fixes to the Claim Engine with the various Business Owners and project involved designing new database schemas, extracting loading the data, performing analysis and then generating various types of reports.

Responsibilities:

• Conducted Data Analysis and performed Data Modeling and Created the ER diagrams using Logical Schema.
• Designed and developed SSIS ETL packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Created SSIS package to load data from Flat File to Data warehouse and Report-Data mart using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup, which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Data Staging to SQL server. Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.
• Configured files to deploy the SSIS packages across all environments.
• Responsible for managing BI environment, which includes Business model, Data Model, Data sources, ETL tools, target data warehouse, Data marts, and Reporting tools. Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, using SSRS 2008. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studio BIDS . Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.
• Extensively used SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Involved in fine tuning SQL query, SQL Optimizing using SQL Profiler, Index Tuning Wizard, and Database Tuning Advisor.
• Work directly with managers and testing team in an Agile methodology of SDLC.

Tools Technologies:

Windows 2007-Advanced server and Enterprise Server 2003, .NET, MS SQL Server 2008, SQL server integration services SSIS 2008, SQL server reporting services SSRS 2008, TSQL. Erwin tool 7.2.

Confidential

Role: SQL Server/SSIS /SSRS Developer

The project mainly involved designing, creating and maintain databases, It also included developing and maintaining SSIS packages and creating reports using SSRS.

Responsibilities:

• Support development and implementation of Mortgage Information System Data Warehouse
• Created the basic SSIS Framework Technical documents consisting of Naming conventions for packages, transformations, connection managers, log files etc.
• Implemented various types of control flow and data flow transformations in packages to handle different logics and Created SQL Server Integration Services package for Market Value Process feed.
• Used C scripts in SSIS script task to run custom scripts in package flow.
• Created command files to execute the SQL Server Integration packages using dtexec utility and passed connection and variable values to the packages.
• Used event handlers to send custom e-mail notifications to business users as well as technical teams.
• Gathered Business requirement for the Mortgage Information System to support the UMB Loans. Worked extensively with business users to get approvals on the changes.
• Modified the existing packages to create logging and getting the truly international loans data from the Loan Management workstation.
• Created Portfolio Exposure Report based on the sub segment code of the accountholders which gave the users summary and detailed level info regarding their accounts.
• Created various Reports using SQL Server Reporting Services based on the requirements specified by the business users.
• Performed end to end Analysis of the Mortgage Information System Sources and downstream system and created Mapping documents for project references.
• Enhanced Downstream System process of creating a Mortgage.xml file using Visual Studio 2008.
• Wrote various new and modified the existing Stored Procedures using T SQL based on the project requirement.
• Created various functions to get different kind of spot rates e.g. current spot rate, Average Spot Rates and effective date conversions.
• Created Document of understanding for each enhancement.
• Created Test cases for IT testing of each enhancement and performed system testing.
• Coordinated with the business users to complete the User Acceptance Testing.
• Provided Production Support to business users on daily basis to resolve data related issues and maintained the proper documentation of issues.
• Worked in Agile, scrum, and sprint environment.

Tools Technologies:

Microsoft SQL Server 2008/2005, Visual Studio 2008, SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , C , Microsoft Visio 2007, Microsoft Project 2003

Confidential

Role: SQL Server/SSRS Developer

Smart Power's Super User for their Energy Trading Risk Management ETRM software. Project interface between the software users and technical support team to ensure the software is optimized to meet business requirements and extensively dealt with Reference Data. The project followed Agile Scrum methodology.

Responsibilities:

• Involved in gathering the report specifications by interacting with the business users
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Increased query performance, necessary for statistical reporting by more than 25 after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Planned, defined and designed data based on the business requirement.
• Designed and developed different type of reports including: Tabular forms, Matrix cross Tab report form, Conditional, List items, Charts and Sub reports, Drill down reports.
• Designed and implemented Parameterized and Cascading Parameterized reports using SSRS.
• Wrote Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS.
• Deployed and scheduled Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Tools Technology:

MS SQL Server 2005 , Enterprise Edition, MS SSRS 2005,T-SQL, VB Script, Windows Server 2003, Erwin 7.1.