Professional Summary:

Around 7 years of IT experience with over 6+ years of experience in SQL Server and involved in all phases of Software Development life cycle from gathering requirement, development, implementation, testing and support.

• Over 6+ years of experience in SQL Server development and administration with DBA duties.
• Experience in SSIS, SSAS and SSRS of MS SQL Server tools.
• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2000/2005/2008 using SQL Server Integration Services (SSIS).
• Well - versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, develop and debug Stored Procedures and Triggers.
• Experience in creating SQL Logins, Roles and Authentication modes as a part of security policies for various categories of users.
• Experience in using BCP and Bulk Insert commands while working with Flat files

Extensive knowledge of Relational Database Management Systems including MS SQL Server 7.0/ 2000/ 2005/2008 R2, Oracle 8i/ 9i/ 10g, DB2and Teradata.

• Extensive experience with monitoring, tuning, analyzing DB performance and allocating server resources to achieve optimum DB performance by performing various query-optimization techniques.
• Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects.
• Expertise in identification of Business & Data requirements and converting them into conceptual & logical data models.
• Experience in Dimensional Data Modeling Star and Snow Flake Schemas.
• Expertise in Database driven web based application developer: using SQL Server 2000, MS Access, Visual SourceSafe, MS SharePoint, MS FrontPage.
• Experience in maintaining database, including updating statistics, re-indexing, structure modifications, and index analysis and also Log Shipping, Mirroring & Replication to restore Database backup.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication to develop creative solutions for challenging client needs.

Technical Skills:

• RDBMS: SQL Server 2008R 2/2008/2005/2000/7.0, Oracle, MS Access.
• SQL Server Tools: MS SQL Server 2008R 2/20 /7.0, MSSQL Server Reporting Services 2008R 2/2008/2005/2000 (SSRS), MSSQL Server Analysis Services 2008R2/20082005(SSAS), MSSQL Server Integration Services 2008R2/2008/2005 (SSIS), Data Transformation Services(DTS), Oracle 9i/10g, ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP).
• Operating Systems: Windows 2000/2003/XP/NT/Vista
• Programming Language: T-SQL, C++, HTML, JSP, Java Script, Asp.Net and VB.Net.
• Reporting Tools: Crystal Reports, SQL Reporting Services and Actuate E-Reporting.
• Data Modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

Professional Experience: Confidential,TX

Sr. SQL Server Developer SSIS/SSRS/SSAS

Description: Confidential, started the first website that allowed consumers themselves not only to access Saber’s fare and schedule information, but also to reserve, book, and purchase tickets without the help of a Travel agent or broker. .As a part of team, my responsibilities included writing store procedures, designing DTS packages, migrating databases to Production environment, modifying database structures, providing support and guidance to operational models by checking for data quality and its consistency.

Roles & Responsibilities:

• Created tabular and matrix reports in SSRS. Wrote stored procedures and functions to create SSRS reports.
• Involved in the creation and deployment of the reports using SSRS and configuring the SQL Server Reporting Server
• Created views as required by front-end developer for easier implementation on ASP.net pages, and wrote instead-of triggers on those views to provide efficient data manipulation.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Involved in designing cubes in SSAS environment using Snowflake and Star Schemas.

Environment: MSSQL Server 2008 Enterprise Edition, T-SQL, ODBC, ER/Studio, SSAS, SSIS Packages, SSRS, SQL profiler, ASP.net, VB Script, Java Script.

Confidential,PA

Sr. SQL Server/SSIS/SSRS Developer

Description: Confidential,offer various types of life insurance, from the pure protection of term life insurance to the flexibility and growth potential of universal and variable universal life insurance policies. The main goal of the project is to extract, transform and load data from different sources using Microsoft Integration Services and maintain them in a Data ware house.

Roles & Responsibilities:

• Create new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users, clients, and managers.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Responsible for creating the reports basing on the requirements using SSRS 2008.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS).
• Involved in Deployment and Administration on SSIS packages with Business Intelligence development studio.
• Developed, monitored and deployed SSIS packages.
• Performance tuning of Stored Procedures and T-SQL Queries.
• Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
• Used Execution Plan, SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in Designing, Analyzing, building and testing of OLAP cubes in SSAS and adding calculations using MDX.
• Performed data conversion from flat file into a normalized database structure.
• Involved in System Study analysis for logical/physical data model there by defining strategy for implementing Star Schema with Fact and Dimension tables.

Environment: SQL Server 2005/2008 Enterprise Edition, SSAS, SSIS, T-SQL and SSRS

Confidential,NJ

Client: Confidential

Sr. SQL Server/SSAS/SSRS/SSIS Developer

Description: Confidential,has been honored in Fast Company’s annual Most Innovative Companies issue, as the fifth Most Innovative Health Care Company in the World for its pioneering electronic health record that is the world’s largest civilian electronic health record.

The project involved in up gradation and migration from SQL server 2005 to SQL Server 2008 and also to provide reports using SSRS for the business users according to their requirement.

Roles and Responsibilities:

• Gathered user requirements. Responsible for Analysis and implementation for DB changes requested by users. Developing reports using efficient data retrieval techniques.
• Updated functional specification and technical design documents. Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Developed Analysis Services Project. Responsible for identifying and defining Data Source and Data Source views. Created cubes and defined the dimensions.
• Create and maintain project artifacts including; data requirements, technical specifications, test plans, etc using Business intelligence tools.
• Defined attribute properties in a Parent Child Dimensions. Responsible for hiding and disabling attributes hierarchies. Sorting attributes members based on a secondary attribute.
• Defining relationships between Dimensions and Measure groups. Involved in the design and development of the SSAS cubes and MDX queries
• Specifying the named sets for calculations using named queries. Responsible for creating reports based on the requirements using SSRS 2008.
• Identified the database tables for defining the queries for the reports. Defined report layouts for formatting the report design as per the need. Identified and defined the Datasets for report generation.
• Wrote queries for drill down reports to get the dataset required to build the report. Identified and included report parameters for parameterized report. Formatted the reports using Global variables and expressions. Deployed generated reports onto the Report Server to access it through browser.

Environment: MS SQL Server 2008, SQL Server Analysis Services, SQL Server Reporting Services 2008, Windows XP

Confidential,Deerfield, IL

Sr. SQL Server Developer

Description: Confidential,is one of the applications being developed at Walgreens. The application uses predictive modeling in order to identify patients who are at risk of leaving Walgreens pharmacy in the near future. The model is based on approximately 40 different variables that describe patient prescription filling behavior, patient characteristics and store level characteristics. After identifying these patients they will be given either A Promotional card or PMR (Personal Medication Report) or a convenience package ( Auto Refill, Express Pay and 90-day at retail) in order to retain the patients.

Roles and Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Used SSIS to create .dtsx packages to validate, extract, transform and load data from different source’s and mapped them onto destination.
• Extracted data from different sources like Oracle, SQL Server, Flat Files, Teradata, Composite View and transformed, loaded onto required database through SSIS 2005.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Expertise knowledge on variables to make package dynamic and scheduled the package using SQL Server Agent as per the business requirement.
• Well versed with creating stand alone packages for data extraction using SQL Server Integration Services and also have experience on creating dynamic packages through Script task components.(VB.NET)
• Experienced in creating XML file for package configurations.
• Good knowledge on optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Expertise knowledge in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, views and other SQL joins and statements for applications using SQL Server 2005.
• Managed large number of Meta Data Tables which are used in the process of ETL in SQL Server 2005.
• Good experience in working with higher environments like SIT, UAT and Production environments. Also experienced in creating DDL scripts like CREATE TABLE, ALTER TABLE, and DROP TABLE for Databases, SQL Jobs, and Linked Server when moved from lower environments to higher environments.

Client: Confidential, NY

Project - TSI

Sr. SQL Server Developer

Confidential,was a financial domain web project for documenting transactions between Banks and Financial Organizations. Banks were giving loans on some amount for certain conditions. There were total three meetings between banks and financial organizations. The documents of terms and conditions were displayed to the financial organizations in this meeting. It was on the financial organization to accept the terms and conditions. All these transactions and reports were maintained by this project.

Roles and Responsibilities:

• Creating and maintaining complex stored procedures, Extended System SP, Triggers, views, Tables, user defined functions, DBCC commands.
• Implemented Database Mirroring and Log Shipping as part of Disaster Recovery.
• Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various Categories of users.
• Created Linked server and running distributed queries to access data from other remote servers.
• Prepared different types of reports using SSRS.
• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services (SSIS), including upgrading DTS to SSIS.
• Performed daily tasks including backup and restore using scheduled SQL Jobs and alerts.
• Rebuilding the Indexes at regular intervals for better performance.
• Knowledge of implementing SQL Server Service Broker.
• Developed SQL Queries to get results in XML Format.
• Troubleshoot system issues, performance tuning using SQL Server Profiler and Database Engine Tuning Advisor for performance purpose.
• Performed some of the DBA activities like Backup, Restore, monitoring etc.
• Worked on the data warehouse design and analyzed various approaches for maintaining different dimensions and facts in the process of building a data warehousing application.
• Involvement in defining scope for new releases and helping business in solving existing issues.

Environment: SQL Server 2005, SSIS, SSRS, Crystal Reports, ETL, Win 2000 Professional, Win Server 2003.

Confidential

SQL Server Developer

We installed the CommPlus for grouping Confidential,Databases in different branches for Depository Services and providing a Real-time Voice Response Support for their Customers all over India. CommPlus is an Interactive voice response system dealing with Beneficiary, Non-Beneficiary Clients, Transactions (Pledge, Account Transfer, Inter Settlement, Delivery Out, and CM Pool to Pool), Billing, Holding, Portfolio and Reporting through Mail and Fax. Fax reports are based on the concept of Fax on Demand and support multi-language.

Roles and Responsibilities:

• Created a Database and normalized the database into small tables by applying rules of Normalization, defined Check Constraint and applied Business Rules.
• Installed SQL Server 2005 Servers, multi instances.
• Responsible for security and roles.
• Responsible for development of Procedures, Functions and database Triggers.
• Designed Data was stored in MS SQL Server
• Created indexes and analyzed its role for optimizations
• Developed Dynamic search queries and results with manipulated data.
• Responsible for developing file transfer controls.

Environment: SQL Server 2005, Crystal Reports, ETL, Win XP.