Summary:

• Over 7 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 ,SSAS and SSRS.
• Experienced in writing complex TSQL Queries involving various tables using SQL joins and writing Sub Queries.
• Experienced in writing complex-SQL Stored Procedures and constructing Tables, Triggers, user functions, Views, Indexes, Relational data models and data integrity.
• Expertise in optimizing the queries by creating Index views, clustered and non-clustered indexed views.
• Expertise in various phases of project life cycles (Design, Analyzing, Implementation and testing).
• 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.
• 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).
• 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 and also worked on cube performance.
• 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 requirements.
• Experienced in performance tuning using SQL profiler identified slow running queries and optimized the queries to see that it will not affect the server performance.
• Creative and aggressive self-starter with integrative thinking skills, highly organized, efficient, able to prioritize and handle multiple tasks under pressure.

Skill Set:

DBMS & RDBMS:SQLServer 2000/2005/2008, Oracle 9i/10gR2/11g.SQL Server Tools:SQL Server Enterprise Manager, T-SQL, Data Transformation Services (DTS), DBCC, BCP, SQL Server Profiler, SQL Server Query Analyzer, Import/Export tools, SQL Server Agent, Server Integration Services (SSIS), SQL Server Analysis Services(SSAS),SQL Server Reporting Services (SSRS),oracle enterprise manager and TOAD. SQL Jobs, SQL Alerts and SQL Mail, SQL Server Management Studio, SQL Server Integration Services.Programming Languages:T-SQL, PL/SQL, VB,C#, C, C++, Windows Power shell.Operating Systems:Microsoft Windows NT/95/98/XP, Microsoft Windows 2000/2003/2005 32bit &64bit, UNIX.Reporting Tools:SQL Server Reporting Services,MS Excel.Office Tools:MS office, Visio, Word, Outlook.Web Technologies and Software:HTML, DHTML, XML, Adobe Dreamweaver, Flash.

Educational Qualification:
Bachelor of Engineering and Technology

Professional Experience:

Confidential, Ada, MI February 2010-Present
MS SQL Server BI Developer
Confidential is one of the world’s largest multilevel marketing consumer products including various products like Nutrilite dietary supplements, XS Energy Drinks, personal care, home care, air and water purifiers and Artistry cosmetics. 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
Environment: 
MS SQL Server 2005/2008, MS SQL Server Reporting Services (SSRS) , Integration Services (SSIS), SQL Server Analysis Services(SSAS), DTS,T-SQL,VB,C#, MS Excel, Oracle, 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.
• Deployed and scheduled reports subscription 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.
• Created 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 November 2008- February 2010 
MS SQL Server BI Developer 
Confidential 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.
Environment: 
MS SQL Server 2005/2008, SQL Server Reporting Services(SSRS), SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS) , 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.
• 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 September 2006- August 2008 
MS SQL Server BI Developer 
Confidential is a member of The Roche Group, 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 Integration services was able to cut reportingtime in half and able to make business decisions that increase profitability and making ETL processing much effective.
Environment: 
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:

• Identified slow running queries, optimized stored procedures, tested applications for performance and 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. March 2005 – July 2006
MS SQL Server Developer
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.
Environment: 
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.