PROFESSIONAL SUMMARY:

• 7+ Years of experience in IT, as MS SQL Server Database BI Developer in Windows environment, current experience with SQL 2008/2005.
• Extensive knowledge and Experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses usingSQL Server SSIS 2008.
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS), Business Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Very good experience in Creating, deploying SSIS Packages and migrating DTS Packages from 2000 to 2005/2008.
• Experience in migration of SSRS reports from SQL 2000 to SQL 2005 and SQL 2008.
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Experience in Performance Tuning and Query Optimization.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance.
• Developed ETL process using SSIS with Various Control Flow, Data Flow tasks and Store Procedures for Work Order Validation process.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Expert in creating the cubes and dimensions in SSAS.
• Extensive Experience in creating different types of reports like Drill down, Drill through, Parameterized etc.
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client\'s business requirements.

Technical Skills:

• SQL Server Tools : Enterprise Manager, Profiler, Query Analyser, Export & Import (DTS), SSIS, SSRS, SSAS.
• RDBMS : MS SQL Server 2000/2005/2008, MS Access.
• ETL Tools : DTS, SSIS, Data Stage.
• Languages : Transact SQL, C, Visual Basic 6.0, VB.Net, ASP.NET, HTML.
• Operating Systems :Windows95/98, Windows2000/NT/XP, MS DOS.
• Reporting Tools : Crystal Reports 11,10,9, SSRS.
• Other tools : Microsoft Visual Studio 2005, Crystal Reports, ProClarity ODBC, and MS Office, Erwin4.0.

Professional Experience:

Project Description:
Confidential is a world-leading financial services company, advising clients in all aspects of finance, around the world, around the clock. Confidential operates in three global divisions - Private Banking, Investment Banking and Asset Management. It pursues a client-focused integrated bank strategy. Confidential is strongly anchored within its industry and the regulatory environment. Confidential: more than 150 years as a byword for expert financial advice.
Responsibilities:

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Created cubes and dimensions and measures and calculated measures according to the business requirements.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2008.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Involved in Migration of SSRS 2005 to SSRS 2008.
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Configured SSRS with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2000 to MS SQL 2005 as well as Created interface storedprocedures used in SSIS to load/transform data to the database.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Created SSIS Packages from various data sources.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using theSSIS ETL tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Operations and perform the Different required transformation in the Staging Database and make the data ready to load in the Data Warehouse Database.
• Developed reports in SSRS 2008 and deployed reports into SharePoint Server 2007 (MOSS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.

Environment: SQLServer 2008, Business Intelligence Studio (SSAS, SSIS, SSRS), SharePoint 2007, T SQL, Erwin, Oracle 10g, ProClarity, MS Excel.

Confidential Parsippany, New Jersey Apr\'09 - Jul\'11 SQL Server BI (SSRS/SSIS/SSAS) Developer
Project Description:
Confidential has an application which helps to know the Life cycle of a Product. This application will help the end users to know the different stages the Product has been in before going into production (manufacturing). There are different departments which have to approve for the product to go for production and this application helps them to understand the needs of the product and then accordingly decide the productivity of the product.

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in developing reports using SSRS.
• Advanced extensible reporting skills using SQL Server 2005 Reporting Services (SSRS).
• Developed a High level dashboard using SSRS 2005.
• Experienced in Designing stylish report layout.
• Designed and created Report templates, bar graphs and pie charts based on the financial data using SSRS 2005.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2005.
• Involved in designingParameterized Reports and Report Modelsfor generatingAd-hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Involved in designingWeb based ASP.NET applications.
• Coordinated with front-end for implementing logic in Stored Procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in upgrading from SQL Server 2000 to SQL Server 2005/2008.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Created SQL Server Reports using SSRS 2005.Identified the data source and defined them to build the data source views.
• Used DDL and DML for writing triggers, stored procedures to check the data entry and payment verification.

Environment: SQL Server 2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Oklahoma Nov\'07-Mar\'09
SQL Server Developer

Project Description:
Confidential is the largest producer of natural gas in the United States. Headquartered in Oklahoma City, the company\'s operations are focused on exploratory and developmental drilling and corporate and property acquisitions in various regions of the United States. The application Confidential is a comprehensive well information system that combines a detailed data model with powerful schematic and reporting capabilities.

Responsibilities:

• Standardized way of writing stored procedure following a specific pattern and naming conventions.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performanceboost.
• Developed various reports using SSRS, which included writing complex stored procedures for datasets.
• Involved in Report Authoring, Report Delivery (using both Pull and Push strategy) and Report Management for various types of reports.
• Participated in creating reports that deliver data based on stored procedures.
• Created simple Reports using SSRS, ProClarity.
• Experience in creating snapshots of static reports and configure subscription.
• Developed Multi dimensional Objects (Cubes, Dimensions) using MS Analysis Services (SSAS).
• Involved in Creation of Dimensions using STAR and SNOW FLAKE Schema.
• Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse (ETL).
• Encapsulated frequently used SQL Statements into stored procedures thereby reducing the execution time.
• Involved in developing triggers to audit schema changes at the database level.
• Created Transactional Replication, Pull Subscription and defined publications to transfer data from branch to head office and vice versa.
• Created sub-reports to present more detailed information about the summary.
• The task involved writing a lot of SQL Code, including use of complicated joins and cursor loops.
• Lead the team of developers to write efficient code.
• Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment.

Environment: SQL Server 2005, MS Excel 2003, MS SQL Query Analyzer, SQL Profiler, ETL, MS SQL Server Reporting Services, MS SQL Server Analysis Services.

Confidential, Hyderabad, India Aug\'04-Oct\'07
MS SQL Server Developer

Project Description:
This project was for the Automobile Finance division of a leading bank. The department in the company provides customers with loan solutions to pay for and manage the cost of automobile. Customer-centric data base was build to analyze transactions across finance, marketing, risk, collections, and consumer relations was developed.

Responsibilities:

• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in Design, Development and testing of the system.
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan) .
• DevelopedUser Defined Functionsand createdViews.
• CreatedTriggers to maintain the Referential Integrity.
• Implemented Exceptional Handling.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• Rebuilding IndexesandTables as part of Performance Tuning Exercise.
• Involved in performing database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: SQL Server 7.0/2000, SQL, T-SQL, BCP, Visual Basic 6.0/5.0, Crystal Reports 7/4.5,ASP/VB.NET.