PROFESSIONAL SUMMARY:

• Over 7+ years of extensive work experience as a SQL Server Developer and in depth proficient experience in Database and Business Intelligence Technologies with expertise on ETL Process and Reporting using SQL Server 2008/2005, SSIS and SSRS.
• Expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS, creating mappings/workflows to extract data from Oracle, SQL server and flat file sources, legacy systems and load into various Business Entities.
• Expert in Creating Indexes, Views, Complex Triggers, effective Functions and appropriate stored procedures to facilitate efficient data manipulation and data consistency.
• Expert in Data Integrity, Performance Tuning, Query Optimization and Validation issues.
• Expert inDesigned high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.Writing T-SQL and Data Migration Projects.
• Experienced in working with Star/Snowflake Schema modeling to develop ROLAP/MOLAP/HOLAP cubes using SQL Server 2005/2008 Analysis Services.
• Experience in developing and deploying cubes using MS SQL Server 2005 Analysis Services involving multidimensional data.
• Experience withSQL Serverand T-SQL in creating Tables, Views, Indexes, Triggers, stored procedures , User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
• Expert in database activities like database creation and maintenance, performance monitoring, tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
• Experience in Extraction and Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle and DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP &Bulk Insert utilities.
• Extensive knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Experienced in data loads, database integration/conversions, performance tuning and optimization.
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client requirement.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Oracle 10g
Languages: C/C++, C#,T-SQL, My SQL, VB, HTML, XML
Operating Systems: Windows 95/2000/2003/NT/XP/VISTA/7, UNIX, MS DOS
Databases: MS SQL Server 2008/2005/2000
Reporting Tools: SSRS 2008/2005
DB Utilities: SQL Server Management Utility, Query Analyzer
Application Software: Visual Studio 2008/2005, MS Office, MS Access
Other BI Tools: SQL Server Integration Services (SSIS), Export & Import (DTS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS)

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ Jan 11- till date
MS SQL Server Developer

UnitedHealth Group is a leading health care company. Involve in the migration of databases from SQL Server 2005 to SQL Server 2008 to fulfill requirements for reporting. Also single-handedly led the migration of several hundred DTS packages and upgraded to SQL Server 2008 Integration Services (SSIS) environment. Developed and deployed new packages and implemented a series of best practices rules for all packages in the SSIS environment.

Responsibilities:

• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Optimized the performance of queries with modifications in T-SQL queries.
• Created drill down and sub reports from SSAS cubes that can be browsed on web
• Created SQL Server Reports using SSRS for management. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS Reports.
• Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
• Created SSIS packages to migrate data from Oracle 8i, MS SQL 2005 to MS SQL Server 2008.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse.
• Developed high Level Design of ETL DTS Package in MS SQL Server 2005 for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Analyzed business requirements and built logical data models that describe all the data and relationships between the data.
• Documented the data such as entity relationships and attributes, file descriptions and definitions.
• Good experience and knowledge of working with Report Manager, Report Builder, Reporting Security and Reporting Services Configuration manager.
• Created variables and defined formula to capture user responses to a prompt and to display document information for Web reports
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Promoted database objects from test/development to production. Coordinated and communicated production schedules within development team.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS
• Generated Chart-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS
• Generated reports using Expressions and Functions using SSRS

Environment:
MS SQL Server 2008, SQL Server 2005, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, Windows 2000/2003/NT/XP.7

Confidential, Pennington, NJ Jan 10 – Dec 10
MS SQL Server Developer/BI Developer

Bank of America Merrill Lynch is the investment banking and wealth management division of Bank of America with presence in more than 150 countries. The aim of the project was to design and develop Data Marts from Oracle Data Warehouse, to migrate the data from different sources into the databases using SSIS in generating customer profile reports, customer transaction reports, compliance reports, Audit reports and HR reports using SSRS and deployed it on SharePoint 2007.

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Developed logical and physical data models for schemas using MS Visio.
• Installed SQL Server 2008 R2 and Management tools using SQL Server Setup Program.
• Developed and maintained many SSRS reports in BIDS for users by gathering and analyzing the requirements, validating the accuracy of the report’s output and deploying it on SharePoint 2007 and in .net intranet applications for internal Investment clients.
• Coordinated with DBA in creating and managing tables, indexes, triggers, db links and privileges.
• Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
• Designed SSIS Packages to extract, transfer and load (ETL) data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc to extract, transfer and load (ETL) data from OLTP to OLAP databases.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Handled slowly changing dimensions to maintain the history of the data.
• Developed all the required Stored Procedures, user defined functions, triggers, views using T-SQL as per business logic which were used to support .net Investment application for customers.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats (PDF, Excel) and resolved formatting issues.
• Optimized the performance of queries with modifications in T-SQL queries, Normalized Tables, established Joins and created Indexes whenever necessary.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS and integrated in SharePoint environment.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Performed daily tasks including backup and restore by using SQL Server 2008 R2 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Involved in preparing training document for application development and QA/UAT teams.

Environment:
MS SQL Server 2008 R2, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), BIDS, Visual Studio 2005, VSS 2005, MS Visio 11.0, Windows NT/2003, Microsoft .NET framework 3.5.

Confidential, Rockville, MD Oct 08 – Dec 09
MS SQL Server / DTS / Developer

Thomson Financial focused on providing integrated information solutions to business and professional customers. The project involved designing a new database schema and migrated databases to Production environment, modifying database structures, providing support and guidance to operational models by checking for data quality and its consistency.

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2005.
• Created the database for the reporting team.
• Solved various T-SQL issues using Query Analyzer.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created ad hoc T-SQL Queries.
• Created backup and restore operations.
• Created Database Triggers to implement business requirements.
• Created complex Stored Procedures and Functions to support the front-end application.
• Optimized SQL queries for improved performance and availability.
• Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
• Ensured Data Recovery, Maintenance, and Data Integrity and space requirements for physical Database.
• Reorganized database structures as needed, automated procedures at regular intervals.
• Optimized long running Stored Procedures and queries for effective data retrieval.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support the whole SSIS process workflow.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS

Confidential,Mumbai, INDIA Dec 06 – Oct 08
MS SQL Server Developer

The Reliance Group is India's largest private sector enterprise, with businesses in the energy and materials value chain. The project was more on the upgrading of the server from a MS SQL Server version 7.0 to the MS SQL 2000 version. Implementation of user login and security was developed and implemented.

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2005.
• Created the database for the reporting team
• Optimized SQL queries for improved performance and availability.
• Monitored Strategies, Processes and Procedures to ensure the Data Integrity, Optimized and reduced Data Redundancy, maintained the required level of security for all production and test databases.
• Designed and developed the database based on these requirements.
• Actively involved in different stages of Project Life Cycle
• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS (Data Transformation Service), T (Transact)-SQL, Stored Procedures and Views).
• Involved in migration of SQL server 7 to SQL server 2000 using Upgrade Advisor.
• Installed and Configured SQL Server 2000, Created Logins, Users and Maintenance Plans managing use of Disk space, memory and connections to the database.
• Involved in assisting QA team in deploying and testing the application, which uses SQL Server as a database
• Involved in creation of stored procedures, triggers using T SQL according to the requirement of the projects.
• Involved in Performance tuning and optimizing for SQL Server Application by using performance monitor.

Environment: SQL Server 2000/7, T-SQL, Query Analyzer, Windows NT/2000 server

Confidential, Hyderabad, India Nov 04 - Dec 06
MS SQL DEVELOPER

Life Insurance Corporation of India (LIC) is a Government of India enterprise, and is thelargest life insurance company and also the largest investor of the country. The corporation is aimed at providing life insurance services and offers attractive savings features along with various insurance policies. The project was to load the data from various sources (branches of LIC) into a single Data warehouse by the help of BCP.

Responsibilities:

• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, Stored Procedures and Views.
• Involved in developing the SQL code for the application
• Involved in designing and implementing the Stored Procedures and Triggers for automating tasks.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.
• Analyzed the Reports, Tables and ETL process.
• Created and automated regular Jobs such as Daily/Weekly Report Generations.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Managed and Monitored System Utilization. Managed Backup and Disaster Recovery of the systems. Managed the security of the servers as a part of administration duties.

Environment: SQL Server 2000/7, T-SQL, Query Analyzer, Windows NT/2000 server