Professional Summary

• A Microsoft Certified Professional with around 7 + years of total IT experience in the Design, Modeling, Development, Implementation and Support of SQL Server 2000/2005/2008/2008 R2.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Experience in maintaining one to many and many to one relationships while moving data between two databases.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Expertise in writing T-SQL Queries, Dynamic-queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visula C# in script component of SSIS.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SQL Server Analysis Services.
• Worked with report manager for deploying the reports across all the environments.
• Expertise in using global variables, expressions and functions for the reports with immense experience in handling sub reports in SSRS.
• Experienced in installing and configuring Reporting services and assigning permissions to different levels of users in SSRS.
• Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008.
• Ability to handle Multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Good ability to quickly grasp and master new concepts and technologies

Technical Skills

Operating Systems Win 2000/NT/2003/2008 server.
RDBMS MS SQL SERVER 2008/2005/2000, MS Access, Oracle8i/9i.
Database Tools SQL Query Analyzer, SQL Enterprise Manager, Management.
Studio, SQL Server 2005, Query Editor, Reporting Server,
Ms-Access.
ETL Tools Data Transformation Services (DTS), MS SQL Server Integration
Services (SSIS).
Reporting Tools Crystal Reports XI/X, MS SQL Server Reporting Services (SSRS).
Data Modeling ER-Win 4.0, MS Visio 5.0.
BI Tools MS SQL Bussiness Intelligence, Business Objects.
Programming Languages Unix,C#, Asp.Net,XHTML and XML.

Education Confidential

Certifications

Microsoft Certified Technology Specialist -Microsoft SQL Server 2008 Business Intelligence (SSIS, SSRS, SSAS) Development and Maintenance.

Professional Experience

Confidential,Maine Sep’11 – Till Present
SQL Server/SSIS/SSRS Developer

WIC-Program - The State of Maine government has intiated the federally funded WIC program (Women Infant and Children Nutrition program) for thousands of Maine Families. It helps the Maine kids grow up strong and healthy. WIC food benefits are available based on income guidelines and up-to-date nutrition research.

Responsibilities:

• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 and SSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the State and Local Agency users.
• Prepared the complete data mapping and Report Definitions for the project which involved around 33 reports.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, Drill down and Drill through reports using SSRS.
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and

triggers.

• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Environment: Windows 2007 enterprise,SQL Server 2008/2005,SQL Integration Services(SSIS), Business IntelligenceDevelopment Studio, Visual Studio 2008/2005, OLE DB

Confidential, Michigan Mar’ 10 – Aug’11
SQL Server/SSIS Developer

Zondervan is a publishing company involved mainly in bible publishing. It a part of the one of the most famous publishing company HARPER COLLINS. Their mission is to be the leader in Christian communicaations meeting the needs of people with resources that glorify the GOD and promote biblical principles.

Responsibilities:

• Implementation of MS SQL Server 2008/2005 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL Server 2005 and 2008 database and configuration of Report manager.
• Responsible for performing T-SQL tuning, multi tasking and optimizing queries for reports which take longer time in execution with SQL Server 2008/2005.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into UL Database and DB2 Billing Systems.
• Developed, deployed, and monitored SSIS Packages.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005/2008.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports.
• Created reports with Analysis Services Cube as the data source using SSRS.

Environment: MS SQL Server 2005/2008, SQL Reporting Services (SSRS), SQL Integration Services (SSIS), MS SQL Server 2008, Ms Access2007, Office2007, Windows Server 2003.

Confidential, Tampa, Florida Mar’ 09 – Feb’ 10
SQL Server (SSIS/SSRS) Developer

Health Integratedis the leading innovation partner for health plans, providing evidence-based solutions to accelerate achievement of health management goals for clinical outcomes, quality measures and cost containment. The Project involved in creating stored procedures, triggers, T-SQL and mainly dealt with SSMS.

Responsibilities:

• Involved in installing and maintaining MS SQL Server 2000/2005.
• Created Data Model or the Marketing Information System Team using Erwin.
• Created SSIS package for loading the data coming from various interfaces like OMS, Orders, Adjustments and Objectives and also used multiple transformation in SSIS to collect data from various sources.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Scheduled and maintained daily and monthly loads of OMS, Orders, Objectives and Adjustments data through jobs, tasks, and alerts.
• Created stored procedures to build Fact tables in data mart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and create super user reports using (SSRS).
• Using SSAS created OLAP cubes for data mining and created reports from OLAP cubes using SSRS.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Created Database Objects - Tables, Indexes, Views,Stored Procedures and User defined functions according to the requirements of the project.
• Using reporting services (SSRS) generated various reports.

ENVINORMENT: Windows XP, Windows 2003, Terminal Server, T-SQL, BCP, SQL Jobs, SQL Server Management studio, SQL Server 2005, SSIS, SSRS, SSAS, ERWIN.

Confidential, Omaha, NE June’ 08 – Feb’ 09
SQL Server 2005 Developer

West Corporation is connecting with their customers, speaking out clearly, confidently, persuasively in a market place that spans the globe and yet is as personal as a conversation between two people. It is having a call center and they maintain databases for different clients by using SQL 2000 and SQL 2005 Servers.
Responsibilities:

• Create new tables, views, indexes and user defined functions.
• Actively designed the database to fasten certain daily jobs and some stored procedure.
• Created SSRS reports for Franchise Health Reports.
• Created User list first title played reports.
• Created reports by retrieving the data from cube using MDX reports.
• Designed reports, Graphs and deployed reports to web applications using SSRS.
• Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
• Designed MDX queries to retrieve data from SSAS cubes.
• Created SSIS packages for File Transfer from one location to the other using FTP task.
• Designed Cube partitioning and incremental synchronization for SSAS cubes.
• Involved in performance tuning of TSQL queries and Stored Procedures.
• Optimized query performance by creating indexes.
• Involved in Administration of the SQL Server by creating users & login ids with appropriate roles & grant privileges to users and roles.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL

Queries and Stored Procedures.

• Use the SQL Analyzer, and Profiler for studying the SQL statements and procedures
• Developed complex stored procedures to create various reports.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Designed Star Schema and Snow flaked schemas in the process of data modeling.
• Access SQL Server using front end applications like VB.

ENVINORMENT: Windows 2003 Advanced Server, MS SQL Server 2005, MS Outlook, TSQL, Erwin, , SSIS, SSRS, SSAS,VB

Confidential Jan’ 07 – Feb’ 08
SQL Server Developer/DBA

ICICI Insurance Company is one of the biggest commercial insurance and banking company that provides dependable, competitive priced insurance coverage to farm and ranch families. It’s mainly located in India. The job was to develop, implement and maintain all databases including stored procedures, triggers, and complex queries, which include the administration of various databases in both development and production environments.

Responsibilities:

• Backend database development in MS SQL Server, writing complex queries, stored procedures, views, triggers, cursors, UDFs.
• Responsible for installation of SQL Server, database design, and create schema objects like tables, views and indexes.
• Performed Database code Migration from SQL Server 2000 to 2005 in SDLC environment using Bridging Scripts, Column Mapping Tool and Source Control Explorer in Visual Source Safe (VSS) and finally passing all triggers, views under Unit Testing for validating data insert, update and delete.
• Experience in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Extensive use of Triggers to implement business logic and for auditing changes to critical tables in the database.
• Experience in development of extracting, transforming and loading (ETL), maintain and support the enterprise data warehouse system and corresponding marts
• Experience with SSIS performance tuning using counters, error handling, event handling, re-running of failed SSIS packages using checkpoints and scripting with Active-X and VB.NET in SSIS.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts. .
• Experience in generating reports using linked reports, sub reports and filters in SQL server reporting services.
• Linked business processes to organizational objectives, performing critical path analysis, analyzing ER diagrams.

Environment: MS SQL Server 2000, T-SQL, DTS, Windows XP, 2000, MS Visio 2000, MS Projects 2000.

Confidential Sep’ 05 – Dec’ 06
SQL Server Developer/DBA

The Department of Consumer Affairs is one of the largest Government handled public welfare department in India and also the country's largest investor. It is fully owned by the Government of India. It was founded in 1958. Headquartered in Mumbai, which is considered the financial capital of India, the department currently has 10 zonal Offices and 111 divisional offices located in different parts of India, at least 2048 branches located in different cities and towns of India along with satellite Offices attached to about some 50 Branches, and has a network of around one million and 200 thousand employees for soliciting consumers.

Responsibilities:

• As a developer I was responsible for the systems study, analysis, understanding systems design and database design.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Experience in creating small Packages.
• Created Views to facilitate easy user interface implementation, and triggers on them facilitate consistent data entry into the database.

Environment:HTML,VBScript, SQL Server 2000, SQL Query Analyzer, DTS, Windows NT, MS Access,MS Excel, Erwin.