Summary:

• Over 7 years of strong experience in MS SQL Server development, System Analysis, Design, Development & Support of MS SQL Servers in Production and Development.
• Strongly expertise in MS SQL Server with Business Intelligence (BIDS) 2005/2008 in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Strong SQL Server Developer skills including writing triggers, stored procedures, views, query writing, defining advanced attribute and dimensions properties.
• Experienced in defining Data Sources for creating data source views and writing complex stored procedure, SQL query in SQL server.
• Strong experience in deploying SQL server Analysis Projects and defining Fact relationships in SSAS using MS SQL Server.
• Expert in using T-SQL queries to generate the SQL commands and kept the application portable to most SQL databases.
• Expert in creating SQL server Reports using SSRS and knowledge of upgrade from one edition of SQL Server to another edition.
• Transformed data from various data sources like access, excel, flat file using OLE DB connection by creating various DTS packages & SSIS Packages.
• Strong experience in executing SSIS packages from .NET & ASP.NET.
• Strong expertise in extending script tasks with .NET code assembly from SSIS.
• Expert in Data warehousing & OLAP technology and successfully created Fact Tables, Dimensions and joined them to extract meaningful data.
• Expertise in performance tuning and trouble shooting on database objects and Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Extensively involved in installation of MS SQL Server, security, standards enforcement, performance analysis, tuning, capacity planning, implementing backup and recovery strategy for application and database.
• Strong Object Oriented Analysis, designing and programming technical skills, ability to learn and adapt new emerging technologies quickly.
• Familiar with sizing and systems for specific applications, collecting and analyzing performance data using various tools, establishing baseline performance parameters and implementing tuning and performance improvement measures.
• Ability to handle multiple tasks and demonstrates initiative and adaptability and capable of handling responsibilities independently as well as a proactive team member.

Education:Master in Computer Science

Skill Set:
Microsoft SQL Server 2005/2008, SQL Server Analysis Services 2005/2008, SQL Server Integrated Service 2005/2008, SQL Server Reporting Services 2005/2008, Performance Monitor, SQL Profiler, SQL Query Analyzer, Database Engine Tuning Advisor, ASP.Net, C#. Net, Project, OLAP, OLTP, MDX (Multi-Dimensional Expression), DTS, VisioStudio2005/2008, Erwin4.1/4.2, MS Access, MS Excel, XML, HTML, MS-Office, VSS, Crystal Reports, Report Builder2.0/3.0.

Project Summary:

Confidential, Holly Hill, FL 03/2011 – Present
MS SQL Server/ BI Developer
Florida Health Care Plans is anAmerican insurance companythat focused on health insurance, medical care, health and wellness. The project mainly concentrated on collection of data from heterogeneous database and integrating it into the SQL Server database as backend. Creating OLAP structures to analyze the data and eventually the insurance progress was the priority. SSRS was used for generation of Reports for clients.

Responsibilities:

• Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2008.
• Created Database, tables, views, indexes, stored procedures, triggers and constraints.
• CreatedUser Defined Functionsto encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• DefinedCheck constraints, Business Rules, Indexes, and Views.
• OptimizingStored Proceduresand long running queries usingindexing strategiesand query-optimization techniques.
• Conducted database management, performance measurement andperformance tuningfor new databases and existing databases by usingSQL Profiler, DataEngine Tuning Advisorand index tuning wizard.
• Experience in designing, testing, scheduling and running ETL processes in SSIS.
• Using SSIS built high performance data integration solutions, including extraction, transformation andload (ETL) packagesfor data warehousing.
• Successfully generatedSSISpackages to upload database from differentdata sourcessuch asSQL server, Excel, MS Access, Oracle and flat file.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
• Developed data access layer using C# classes and ADO.NET.
• Designed OLAP cubes with star schema using SSAS.
• Designed SSAS solutionsusingmultiple dimensions, hierarchies, measures groups and Key Performance Indicators (KPIs) to analyze performance of strategic business units.
• Worked onSSRSto generate dynamic reports according to end user requirement and deployed on web-portal.
• Installed and Configured SQL server Reporting service 2008 on Development and production server.
• Created tabular reports, matrix reports, and parameterized reports according to business requirement using SQL Server Reporting Services (SSRS).
• Developed Stored Procedures and views to generate various Drill-down/Drill-through reports.
• Created automatically running stored procedures for day-end operation using SQL Server agent.

Environment:MS SQL Server 2008, SQL Server Integration Services (SSIS) 2008, SQL Server Analysis Services (SSAS) 2008, SQL Server Reporting Services (SSRS) 2008, C#.NET, SQL Server Agent, SQL Profiler, Database Engine Tuning Advisor, Query Analyzer, Index Tuning wizard.

Confidential, Riverside, RI 08/2009 – 02/2011
MS SQL Server/ developer
Citizens Bank is a division of RBS Citizens, one of the largest commercial banking companies in the country, offering quality service to the clients. The goal of the project was to extract and load data from different sources to SQL Server destination data warehouse, also generating and subscribing reports and performing day-to-day tasks. This project also involved generating annual consolidated statement of operation/financial statements. The scope of this project was to integrate data from their distinct financial systems and to create various kinds of reports for management.

Responsibilities:

• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
• Performed gathering and analyzing of requirements including design and development of Technical documentation.
• Create project plans with MS Project. Design and prototype models, test, train and define support procedures.
• Designed, modified database objects such as tables, views, indexes, T-SQL Stored Procedures, defaults, user defined data types and functions.
• Wrote ad-hoc T-SQL queries for data analyzing, research, unit testing and identifying and resolving bugs.
• Extracted and transformed data from various sources such as Pervasive database, SQL server, Excel, Access and flat files using SSIS package into destination tables as per the business requirements.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Optimizing Stored Procedures using SQL Profiler and Database Engine Tuning Advisor.
• Examined execution plans, created covering indexes and filtered indexes when necessary for tuning SQL queries.
• Performed unit, integration and functional testing of the SSIS packages, T-SQL and Stored procedures.
• Developed the front-end web forms using ASP.NET and VB.NET.
• Used Visual Source Safe (VSS) for version control.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008.
• Defined report layouts including report parameters and wrote queries using SSRS 2008 for creating parameterized, drill down, drill through and aggregation reports.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Wrote support documentation for SSIS packages/SSRS reports and Stored procedures.
• Wrote production implementation documents and production support when required.

Environment:MS SQL Server 2008, SQL Server Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2008, T-SQL, C#.NET2.0, Visual Studio 2005, ASP.Net, DTS, Data Analyzer, MS Access, Excel, Performance Monitor, SQL Profiler, Database Engine Tuning Advisor, Erwin 4.2, VSS 2005.

Confidential, Simsbury, CT 04/2008 – 07/2009
MS SQL Server/ BI Developer
Hartford Life Insurance Company provides customers with a range of investment products and services, including individual annuities, mutual funds, and numerous retirement products and services. The scope of the project was mainly involved creating, deploying and scheduling reports on both relational databases as well as analytical cubes.

Responsibilities:

• Installed and configured MS SQL Server 2005 along with Visual Studio on a network domain system.
• Migrated database from SQL server 2000 to SQL server 2005 using SSIS packages.
• Extracted data from many operational systems, including flat files, spread sheets and RDBMSs like SQL Server and optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools like Stored Procedures, User Defined Functions, Views, T-SQL Scripting.
• Developed advanced correlated and un-correlated sub-queries in T-SQL to create complex reports and Prepare the List Report for each customer. Extensive use of T-SQL in DDL and DML commands for various applications.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Monitored the performance of Database objects using Performance Monitor that ships with SQL Server and Created SSIS Packages to import and export data from Excel Spreadsheets, Text files and CSV files.
• Developed Cross-Tabbed and Sub-Reports in SSRS and Designed and developed matrix and tabular format drill down, Linked reports with drop down menu option using SSRS.
• Generated the various kinds of reports using Graphs and Images and Scheduled reports for daily, weekly, monthly for executives, Business analyst and customer representatives for various categories and regions based on business needs using SSRS.

Environment:MS SQL Server 2005 Enterprise Edition, T-SQL, SQL Server Reporting Services (SSRS) 2008, SQL Server Integration Services (SSIS) 2005, OLAP, OLTP, MDX, SQL Profile, Database Engine Tuning Advisor, VisioStudio.

Confidential, Bloomington, IL01/2007 – 03/2008
MS SQL Server/ BI Developer
State Farm Insurance Companies provides policies for various insurance like Automotive, Home, Life, Health and Business. The scope of the project was to implement a web-portal through which individuals and families get accurate quotes for a car insurance. The information is retrieved from a unique database developed on SQL Server 2005.

Responsibilities:

• Created logical and physical data models using Erwin.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created Clustered and Non Clustered indexes on tables.
• Worked as a developer in creating complex Stored Procedures, User Defined Functions, DTS packages, triggers, cursors, tables, scripts, indexes and views and other SQL joins and statements for applications.
• Worked on MS SQL Server tasks such as data loading, batch jobs, BCP, DTS, Instances, Linked Servers and Indexes.
• Created SSIS package for data population from different sources and created SSIS packages for data conversions and load data from flat flies or excel files.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.
• Fine-tuned complex SQL queries and Stored Procedures to increase performance.
• Extensively used XML documents to pass multiple parameters for Stored Procedures to read and write database table.
• Extensively used Enterprise Manager, Query Analyzer, and SQL Server Profiler.

Environment:MS SQL Server 2005, SQL Server Reporting Services (SSRS) 2005, SQL Server Integration Services (SSIS) 2005, T-SQL, XML, SQL Profiler, Database Engine Tuning Advisor, MS Access, Query Analyzer, BCP, Erwin, Import & Export Wizard, Enterprise Manager.

Confidential, China 09/ 2005- 12/ 2006
MS SQL Server Developer

ICBC is a diversified financial services company that provides a broad range of banking, asset management, wealth management, and corporate and investment banking products and services. The Scope of the project was to migrating the Checking, Savings, and other accounts for the customers, it also involved collecting different branch information to the same destination data warehouse.

Responsibilities:

• Logical and physical database development (using ERwin, Normalization, Dimension Modeling and Enterprise Manager).
• Carried out a Developer’s role on MS SQL Server 2000, MS Access Databases (using DTS, T-SQL, Stored Procedures and Views).
• Developed complex T-SQL code for the application.
• Create tables, constraints, indexes and views.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Used DTS for data population from different sources and created DTS packages for data conversions and load data from flat flies or excel files.
• Worked on MS SQL Server tasks such as Data Loading, Batch Jobs, BCP, DTS and Indexes.
• Created and automated regular Jobs such as Daily/Weekly Report Generations in Crystal Reports.
• Managed Backup and Disaster Recovery of the systems.
• Used Visual SourceSafe (VSS) for version control.

Environment: MS SQL Server 2000/7.0, DTS, MS Access, BCP, Crystal Reports, .NET, Erwin, VSS.