Professional Summary:

• Over 8 Years of IT Experience in Business Intelligence Technologies and Database with Extensive Knowledge in ETL Process and Reporting Services using SQL server 2008/2005, SSIS and SSRS.
• Expertise in creating SSIS packages for integrating data using OLE DB connection from homogeneous and heterogeneous sources (Excel, CSV, Flat file, Oracle). By using multiple transformations like Data Conversion, Conditional Split, SCD, Bulk Insert, and Merge Join.
• Experience in writing complex TSQL Queries involving various tables using Inner and outer joins.
• Experience in writing ComplexT-SQL Stored Procedure and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity, SQL joins and writing Sub Queries.
• Expertise in optimizing the queries by creating Index views, clustered and non-clustered indexed views.
• Extensively worked on VMware workstation. Deployed SQL server.
• Expertise in various phases of project life cycles (Design, Analyzing, Implementation and testing).
• Extensive knowledge in Extraction, Transforming and Loading (ETL) data using SQL Server Integration Services (SSIS), Bulk Insert and BCP.
• Expert in migration of databases from Oracle and non-oracle sources to SQL databases using 2008 SSIS (SQL Server Integration Services).
• Expert in creating various types of reports like complex drill down reports& drill through reports, Matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Extensive knowledge in designing reports using cascading parameters, Parameterized reports, report models for Adhoc reports using SQL server Reporting services (SSRS) based on Requirement.
• Constructed Cubes based on data volumes mostly adhering to Star Schema using strong knowledge of Data Warehousing, Star Schema, Snow-Flake Schema, Fact and Dimension Tables.
• Experience in the performance tuning using SQL profiler identified slow running queries and optimized the queries to see that it will not affect the server performance.
• Ability to quickly adapt and learn, works well in team environment as well as independently with minimum supervision.
• Excellent in communication skills highly motivated and result oriented professional.

Educational Qualification:
Masters in Computers Science

Skill Set:
MS SQL Server 2000/2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Analysis Services 2005/2008,MS SQL Server Integration Services 2008/2005, MS Access, C++, HTML, VMware, MS Visio 2003,Windows server 2000/2003, Crystal Reports XI/8.5/8.0, Visual Studio 2005/2008, MS VISIO 2000/2003 Remote Desktop, DreamWeaver, Flash, Ms Office, Ms Frontpage.

Projects Summary:

Confidential, Cupertino, CA 04/2010- present 
MS SQL Developer / SSRS/SSIS Developer
CONFIDENTIAL specializes in developing and manufacturing computing, data storage, and networking hardware, designing software and delivering services. Contracts for manufacturers, retailers and distributors of consumer electronics, appliances through a global organization providing innovative business solutions, which operates in all most every country. The project involved generating reports for product cost planning to plan costs for desktop accessories without reference to orders, and set prices for desktop accessories and other cost accounting objects. The project was also involved to design and develop database for SQL server 2008. 
Hardware/Software: 
MS SQL Server 2005/2008, MS SQL Server Reporting Services 2005/2008 , Integration Services (SSIS), DTS, T-SQL,VB,C#, MS Excel, DB2, Access and Excel.

Responsibilities

• Studied the current transactional database in order to understand the existing system and created the approach documents for the migration task.
• Created and documented the mapping of the database objects from source to target database.
• Responsible for generating sales ranking reports using the migrated data.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and parameterized and Linked reports.
• Identified and worked with parameters for creating cascading parameterized reports in SSRS 2008.
• Involved in Debugging and Deploying reports on the production server and analyzed reports and fixed bugs in stored procedures on the ongoing database operations, as needed, to resolve business problems.
• Migrated SSAS cubes using the Analysis Services Execute DDL Task and built reports from the cubes.
• Deploying and scheduling Report subscriptions using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created report models and configured the report builder for building Adhoc reports.
• Migrated data from MS SQL Server 2005 to MS SQL Server 2008.
• Create store procedure specifically for cleansing and managing data and used the same in SSIS Execute SQL Task.
• Created Complex Stored Procedures, Triggers, Functions, Tables, Views and other T_SQL code and SQL joins to ensure efficient data retrieval.
• Created SQL Agent Jobs for scheduling SSIS Packages, SSRS reports and alerts.
• Configured and fine-tuned all the ETL (Extract, Transform and Load) workflows.
• Created SSIS script task with C# code for obtaining parameters from the applications.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.

CONFIDENTIAL, Manhattan, NY, 9/2008- 03/2010
MS SQL Server 2008 SSIS/SSRS Developer 
The Depository Trust & Clearing Corporation is the largest financial services post-trade infrastructure in the world, with operating facilities in multiple locations in the U.S. and overseas. CONFIDENTIAL is the holding company for six subsidiary businesses -- a depository and five clearing corporations -- as well as the global joint venture with Thomson Financial (called Omgeo). Through its subsidiaries, CONFIDENTIAL provides clearance, settlement and information services for virtually all equity, corporate debt, municipal debt, government securities, mortgage-backed securities
Hardware and Software:
MS SQL Server 2005/2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, Visual Studio 2008, VMware Enterprise Manager, SQL Server Management Studio (SSMS) and SQL profiler.

Responsibilities:

• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Involved in Performance tuning and Query Optimization by using SQL profiler.
• Resolved deadlocks issues with the databases and servers on a real-time basis.
• Worked with business analysts to identify, design and implement solutions for extraction and integration of data to and from databases and data marts for the purposes of data extraction and reporting using SSRS.
• Migrated SQL Server databases to latest version 2008 from SQL server 2005.
• Integrated data from homogeneous, heterogeneous sources and legacy systems (SQL, DB2, Excel sources) to SQL server database.
• Generated performance based reports using SSRS for the managers to show holdings against various measures like time, area, and price-range.
• Created Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi Dimensional Expression (MDX) to access them.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Extensively worked on star schema for building the OLAP cubes.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Created scripts components to write customer functions in dataflow used data grids to display the data in a customized way.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases
• Designed, developed, modified and enhanced the database structures and database objects.
• Updated the existing Business Objects Universes as requested by the users with the new requirements to add new universe classes and objects for new database entities and attributes.

Confidential, Pleasanton, CA 01/2007 - 8/2008
MS SQL Server 2005, SSIS/SSRS
Disetronic Medical Systems is a member of Confidential, a leader in diabetes care. They are one of the largest manufacturers of insulin pumps in the world and a leading supplier of infusion sets and supplies for almost all brands of insulin pumps. . The Project was to create accurate and frequent reporting system. Using SQL Server 2005 and SQL server reporting service and Intergration services was able to cut reportingtime in half and able to make business decisions that increase profitability and making ETL processing much effective.
Hardware/Software:
MS SQL Server 2005, SQL Server Reporting Services 2005, SQL Server Integration Services 2005, SQL Server Analysis Services 2005, T-SQL, Windows XP, MS Excel and SQL profiler.

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Scheduled reports and exported in PDF, Word and Excel format.
• Worked on error handling a module consisting of data from bank, transactions, currencies, countries, master, static etc.
• Designed, deployed, and maintained various SSRS Reports in SQL Server.
• 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.
• Involved in designing a cube which helped to show balances and profits of each region bank all over the nation.
• Managed and coordinate with remote user for change request and optimization of application

Confidential, OH
11/2005 –12/2006
MS SQL Server Developer
Commercial & individual banking products and services like online Banking, Bill Pay, and Cash management Services, Telephone Banking round the clock. The main tasks involved a lot of ETL activities through extracting data from various sources and creation of OLAP structures for analysis purposes and reporting purposes. 
Hardware/Software:
MS SQL Server 2000, 2005, ETL, SSIS, SSAS, SSRS, OLTP, T-SQL, Erwin 4.1, Windows XP, MS Access, MS Excel

Responsibilities:

• Involved in Installing SQL Server 2000 with latest service pack.
• Extensively worked in creating Database, database objects such as view, table, stored procedure, trigger and function using T-SQL.
• Performance tuning of stored procedure.
• Wrote complex Join queries using T-SQL.
• Created the Logical and Physical Data Model using Erwin tool.
• Created DTS Packages to integrate the Business Logic and Data Transformations
• Transformed data using DTS packages, BCP utility and Bulk Insert statement.
• Created and saved DTS package according to requirements.
• Performance tuning of server and gave suggestion to senior developer.
• Created and managed index.
• Involved in Performance Tuning activities including Query Tuning and Index Maintenance.
• Monitoring the application and database performance using SQL Profiler and Performance Monitor
• Used Index tuning wizard to get a better idea of implementing indexes on the existing databases
• Created Database Maintenance Plans for Database Backups, Re-indexing and Data Integrity Checks
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.
• Created Windows Admin Scripts to monitor Disk and Tape Backups, Disk Space and Service Status for different servers and generate alerts.
• Created SQL Server Agent Alerts to monitor the SQL Server Events and SQL Server Performance Alerts and notify the Administrators of the critical situations.
• Created Triggers to monitor activities on server as well as database and generate alerts and notifications.
• Created Stored Procedures, User-Defined Functions, Ad-hoc Scripts and Cursors on Development and Test servers for pre-deployment testing.

Confidential 07/2002 - 08/2005 
MS SQL Server DBA
CONFIDENTIAL is one of the largest banking and financial services organizations in the world. CONFIDENTIAL\'s international network comprises around 8,000 offices in 87 countries and territories in Europe, the Asia-Pacific region, the Americas, the Middle East and Africa. Worked on retail collection system, a GUI based client/server bill collection software, to assist brokers in carrying out their daily transactions. Upgrade from MS SQL Server 7.0 to 2000.
Hardware/Software: 
MS SQL Server 2000, T-SQL, SQL Server 2000 Reporting Service, VSS, Windows 2000 Server, Enterprise Manager, Query Analyzer, SQL Profiler

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management, 
  Developed backup restore scripts for SQL Server as needed.
• Upgraded to latest version from SQL server 7.0 to 2000.
• Written various stored procedures for the purpose of application development.
• Tuned SQL statements (Using Indexes) and Stored Procedures.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
  Disaster recovery and database maintenance plan.
• Replication of data using Transactional method.
• Migrated data from sql server 7 to sql server 2000 successfully
• Data conversion from Text File into SQL Server Table.
• Created constraints and validated database integrity.
• Designed and implemented data access stored procedures and triggers for automating tasks. 
  Job scheduling and alerts.
• Designed and implemented user log in and security.
• Extracted Data from MS Access.
• Created many complex Stored Procedures / Functions and used them in Matrix Reports.
• Created reports and hosting it in the web for the users.