SUMMARY

• 9+ years of Information Technology development experience on Database Design and Development inSQLserver 2012/2008R 2/2008/2005/2000 system in OLTP and OLAP environment in various industries like Finance, Insurance and Health Care.
• A motivated, highly organized individual and enthusiastic team player with excellent communication, analytical and problem solving skills.
• Has in - depth knowledge of Transact-SQL(Data Definition Language, Data Manipulation language)
• Creates 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 E/R Diagrams, 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 DynamicSQLand SQLCMD command line utility
• Created and maintained Cluster Index and Non Cluster Index
• Implemented ETL Packages using DTS andSSIS2012/2008R 2/2008/2005/2000 , creatingSSIS,DTSpackages for large data transfers between MS-SQL Servers and automating using SQL jobs
• Implemented all transformations available on theSSIStoolbox.
• 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 usingSQLtools (SSIS, DTS, Bulk Insert, BCP, and XML)
• Created Jobs, Alerts,SQLMail Agent, and schedule DTS/SSISPackages
• Generated reports using MS Reporting Services 2012/2008R 2/2008/2005/2000
• Configured reportserverand report manager scheduling, gave permissions to different level of users inSQLServerReporting Services (SSRS)
• Generated on-demand and scheduled reports for business analysis or management decisions usingSQLServerReporting Services
• Possesses 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
• Designed, created and processes cubes using SSAS
• Calculated measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions
• Designed aggregations and pre-calculates using SSAS.
• Created groups and measures, KPIs
• Scheduled and deployed reports, and uploaded files to a reportservercatalog from the report manager
• Designed and implemented relational database model as per business needs
• Analyzed, designed, developed, tested and implemented systems following the SDLC

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

MS BI Developer/SSIS Developer/SSRS Developer

Responsibilities:

• Actively involved in creating Custom Reports by understanding the Management and senior level Management’s need to support in business.
• Designed and Modified Tabular, Matrix, Drill Through, Drill Down, List, Sub report and made them dynamic using SSRS 2012/2008 R2.
• Created parameterized report as per the user role and level, Cascading parameterized report, and Multi value parameterized Report.
• Developed Report Models for creating Ad Hoc Reports using report builder.
• Developed Reports including hyperlink to SharePoint and Used JAVA Script to open report in different window for better comparison perspective.
• Responsible for deploying report directly to production server and Developer Server.
• Scheduled and Maintained Reports Job and subscription to deliver reports in various rendering format.
• Extensively created dashboard reports to track Reports Performance based on their data retrieval time, Data operational time and Data rendering time to address issue for better optimization in timely Manner.
• Organized reports folders for better convenience by linking similar reports from one folder to another, and Created user friendly report to find any reports among the all reports.
• Created and modified SSIS (ETL) packages to validate, extract, transform and load data into database.
• Implemented various tasks and transformations for data cleansing and performance tuning of packages by using SSIS.
• Experienced in creating jobs, Alerts, and Scheduling SSIS Packages using SQL Server Agent job.
• Configured files to deploy the SSIS packages across all environments.
• Responsible for creating and modified database objects like table, Views, Store Procedure, and User Defined 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.

Environment: MS SQL Server 2012, SQL server reporting services (SSRS) 2012/2008 R2, SQL server integration services (SSIS) 2012.

Confidential, Rye Brook, NY

MS BI Developer/SSIS Developer/SSRS Developer

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.
• Participated in testing to receive and process HL7 ORU R01 Version 2.5.1 messages to Webserver
• Tested the HL7 ORU R01 Version 2.5.1 to receive messages from HL7 ORU R01 version 2.3.1.
• Gathered the Requirements for Enhancement of Electronic Lab Reporting Dashboard and implemented the timely status/error messages in the Dashboard
• Designed a Document of Identifying and marking outbound laboratory results to public health entity to be accommodated on the Webserver.
• Testing of HL7 Message Validation and sending of ADT Messages like ADT A01, ADT A04 and ADT A08.
• 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 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.

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

Confidential, Manhattan, NY

SQL Server/SSIS /SSRS Developer

Responsibilities:

• Conducted Data Analysis and performed Data Modeling and Created the ER diagrams using Logical Schema.
• Designedand 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 usingLookup, 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 2012. 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 2012.
• 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.

Environment: Windows 2007-Advanced server and Enterprise Server 2003, MS SQL Server 2008, SQL server integration services (SSIS) 2012, SQL server reporting services (SSRS) 2012, TSQL. Erwin tool 8.0.

Confidential, St. Louis, MO

MS SQL Data Warehouse Developer

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 detect 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 Confidential 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.

Environment: 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, San Francisco, CA

SQL Server /SSIS /SSRS Developer

Responsibilities:

• Involved in gathering the report specifications by interacting with the business users
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Created XML and SQL Server package configuration to make package dynamic using SSIS package Configuration Wizard.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Experienced in creating jobs, Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages.
• 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.

Environment: s: MS SQL Server 2008, Enterprise Edition, MS SSRS 2008, MS SSIS 2008,T-SQL, VB Script, Windows Server 2003, Erwin 7.1.

Confidential

MS SQL Server ETL Developer

Responsibilities:

• Actively participated in interaction with users, Team Lead, DBA's and technical managers to fully understand the requirements of the system.
• Performed Migration of data from SQL Server .
• Developed a data model and implemented the same using ERWIN.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple vtpp tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints.
• Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Designed SSIS (ETL) Packages to extract data from various heterogeneous data sources such as Access database, Excel spreadsheet and flat files into SQL Server 2005.
• Created the packages in SSIS (ETL) with the help of Control Flow Containers, Tasks and Data flow Transformations.
• Developed Slowly Changing Dimensions (SCD) in SSIS (ETL) to perform the Incremental and Historical loads of data in the data warehouse.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms and type1 and type 2 changes
• Worked with Inbuilt Transformations in SSIS (ETL) like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
• Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database which provides efficient and granular level of control.
• Performed Data profiling tasks In SSIS (ETL) using the Data Profile Viewer and then clean and standardize the data as appropriate for the Databases.
• Conducted the Error handling in SSIS (ETL) using the Event Handlers.
• Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Created Ad-Hoc reports using Report Builder.
• Deployed reports in various environment of report server.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Multi-dimensional Objects Cubes, Dimensions using SSAS.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS.
• Wrote MDX queries to access data from OLAP cubes.
• Ran DBCC and fixed data corruption in application databases.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: MS SQL Server 2005/2000, SSIS 2005, SSRS 2005, SSAS 2005, Visual Studio 2005, T- SQL, Visual Source Safe 2005 (VSS), XML, ADO.NET, ERWIN 7.1, MS-Access, MS-Excel