Professional Summary:

• Over 7 Years of extensive IT experience as a Microsoft SQL Server 2000 /2005/2008/2008R2 Developer in creating Business Intelligence Solutions like SSIS, SSAS, SSRS and expertise in designing and implementing Relational Database model as per business needs in different domains like Insurance, Banking, Telecomm and Finance.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008R2.
• Experience with all phases of Software Development Life Cycle (SDLC) and project methodologies.
• Expert in Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Comman Table Expressions (CTEs), Table Variables and Views.
• Extensive knowledge in tuning T-SQL queries (DDL, DML and DCL) to improve the database performance and availability.
• Expert level skills in objects creation such as Tables and Views, Table Normalization, User Created Data Types, User Profiles, Data Dictionaries, Data Integrity, Performance Tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Experience in code optimization and improving efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
• Good knowledge in normalizing and de-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor (DTA), DBCC Commands and Query Execution Plans.
• Expertise in Designing and Implementing Business Intelligence applications using SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS).
• Excellent skills in implementing ETL Packages using Data Transformation Services (DTS) and SSIS 2000/2005/ 2008/2008R2.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in Debugging, Error Logging, Error Handling and Production Support for SSIS.
• Hands on experience in data Extraction, Transforming and Loading (ETL) using SSIS, BCP, Bulk Insert, DTS, and XML between Oracle, DB2, and Access to MS SQL server database.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Merge Join, Sort, Fuzzy Grouping, Pivot).
• Experience in building SSIS packages (.Dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Experienced in installing and configuring MS SQL Server Reporting Services (SSRS) and assigning permissions to different levels of users in SSRS.
• Proficiency in creating different types of reports such as Tabular Reports, Cross-Tab, Conditional, Pie Chart Reports, Drill-down, Drill Through, Top N, Summary and Sub reports, Ad-hoc reports and formatting them.
• Expertise in developing Ad-Hoc, Drill down, Drill through reports using Local and Global Variables, Expressions and Filters in SQL Server Reporting Services (SSRS).
• Worked with OLAP and Data warehouse application and worked with Star Schema, Snowflakes Schema dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs.
• Proficient in designing Sub Reports, Parameterized and Cascaded Parameterized Reports.
• Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience in creating complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Design and build experience in using performance features such as Partitioning, Aggregations and KPIs.

Education:
Bachelor of Technology in Computer Science

Technical Skills:

Programming Languages T-SQL, C, C++, PL/SQL, C#, XML, VB .Net, Visual Basic 6.0

Operating Systems Windows Server 2003, Windows XP/ 2000/ 95/ NT, Linux, UNIX

SQL Server
ToolsSQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Database Tuning Wizard, Import & Export, Visual Studio Net

ETL Tools SQL Server Integration Services (SSIS) (2000, 2005, 2008, 2008R2), Data Transformation Services(DTS)

OLAP/ Reporting Tools SQL Server Analytical Services (SSAS) (2000, 2005, 2008, 2008R2), SQL Server Reporting services (SSRS) (2000, 2005, 2008, 2008R2), Crystal Reports(9/10/XI/2008)

Others Toolsb MS Office, , MS Visio, Share Point MOSS 2007

Professional Experience:

Confidential, Columbus, Ohio Dec 2009 - Till Date
SQL Server Developer/SSIS/SSRS/SSAS
JP Morgan Chase Bank is an American multinational banking corporation of securities, investments and retail. It is a major provider of financial services, with assets of US $2 trillion and the largest bank in United States by sales, profits, assets and market value. It is also the world’s largest public company. The JP Morgan brand is used by the investment banking as well as the asset management, private banking, private wealth management and treasury & securities services divisions.
Roles and Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Upgraded MS SQL Server 2005 database to MS SQL Server 2008, by using Detach/Attach, Back up & Recovery.
• Design and implementation of Stored Procedures and Triggers for automating tasks.
• Interacting with the users and troubleshooting the problems involved with the development of Stored Procedures, triggers and problems related to the privileges.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
• Created Views to reduce database complexities for the end users.
• Created checks and constraints to maintain data integrity.
• Involved in De-Normalization of existing tables for faster query retrieval.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted to sql reporting.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created master ETL packages which include various packages in them and scheduled them to execute based on the given requirement time.
• Developed SSIS packages for File Transfer from one location to the other using FTP task
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Experience in Debugging, Error Logging, Error Handling and Production Support for SSIS.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Generated reports using SSRS which were sent to different Clients, and managers.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2005 Analysis Services.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Ensured best practices are applied and integrity of data is maintained through security and documentation.

Environment: Windows 2003 Server/XP, SQL Server 2008/2005, SQL Integration Services (SSIS), SQL Reporting (SSRS), Business Intelligence Studio, Visual Studio 2008/2005, OLE DB, DTS Package, SharePoint MOSS 2007, Crystal Reports, Erwin 4.0, VB.Net, HTML.

Confidential Dallas, Texas June 2007 - Nov 2009
SQL Server Developer/SSIS/SSRS/SSAS
Phytel is the national leading provider of automated patient care management. Phytel integrates with existing technology, including practice management systems in addition to incorporating prescription data, lab data, and other clinical data, to develop and maintain a health and disease management patient registry for healthcare organizations.
Roles and Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, User Defined Functions, Triggers and Rules.
• Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, optimization) and .NET data access components.
• Implemented constraints on tables. Database tuning and performance planning.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.
• Dropped and recreated the Indexes on tables for performance improvements.
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
• Created SSIS packages to transfer data from Oracle to SQL server using different SSIS components and used configuration files and variables for production deployment.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and Union All.
• Created master ETL packages which include various packages in them and scheduled them to execute based on the given requirement time.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted to sql reporting.
• Involved in daily loads (Full & Delta) into Staging and ODS areas, trouble shooting process issues and errors.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups.
• Created several Staging Databases. Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Made Packages Parameterized using Configuration Manager and Implemented Logging in SSIS.
• Designed various reports using different reporting features such as group by, drilldowns, and drill through using SSRS 2005.
• Created parameters (multivalve, hidden, default etc.) for the required fields using the report designer in order to see the dropdowns in the end report.
• Used various types of report layout options like charts (bars, lines, pie etc.), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• Created Ad Hoc reports by building models in Report Builder using SQL 2005 Model Designer and Report Builder.
• Created weekly and monthly reports as per requirement using SSRS.
• Developed reports from SQL server and cubes using SQL server analysis services database.
• Scheduled the reports to refresh and run on daily, weekly and monthly basis in the report manager and SharePoint.
• Created and debugged data connections, data sources and Data Source Views.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
• Involved in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application. Cleansing and solving Database troubles.

Environment: MSSQL Server 2008R2/2008/2005, SQL Server Analysis Services (SSAS), Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), VS2005, ETL, MDX, Microsoft Office SharePoint Server (MOSS) 2007, Performance Point Server 2007, T-SQL, Microsoft.NET (C# .Net), SQL Profiler, Oracle 10g.

Confidential Trumbull, CT June 2006 - May 2007
SQL Server Developer/SSIS/SSRS
People’s united bank is a diversified financial services company. They provide consumer, commercial, insurance, mortgage, and trust services to personal and business customers. This project involved in providing a stage, which supports the banking transactions for customers, and maintaining the OLTP and OLAP databases, writing included writing queries using DML/DDL/DCL’S and managing the tables. Writing stored procedures, Triggers and indexes for efficient performance of database. Transferred databases Involved in troubleshooting and upgrading SQL server.
Roles and Responsibilities:

• Transformed complex business logic into database design and maintaining it by using sql objects like stored procedures, functions, views, T-SQL scripting and jobs.
• Successfully implemented indexes on tables for optimum performance.
• Developed complex stored procedures using T-SQL to generate Ad-hoc reports within SQL Server Reporting services.
• Working Experience in Code Optimization and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Experience in using Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Good knowledge in normalizing and de-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Creating Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Maintained the database by monitoring performance integrity and optimize SQL Queries for high performance using SQL Profiler.
• Created SSIS package to extract data from MS Excel, Access to SQL 2005.
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling data from various data sources using BCP in staging database from MS Access, Excel.
• Developed parameterized, drill down, drill through and sub reports to meet the business requirements.
• Dimensional Data Modeling experience using Data Modeling, Star Schema/Snowflake Modeling, Fact & Dimensions tables.
• Creating report model on SSAS cubes as well as changing default configuration on existing cubes.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005) 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 developing Ad-Hoc, Drill down, Drill through reports using Local and Global Variables, Expressions and Filters in SQL Server 2005/2008 Reporting Services (SSRS).
• Worked with OLAP and Data warehouse application and worked with star schema, snowflakes schema dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs.
• Proficient in creating Standard Subscriptions and Data driven subscriptions for delivering reports to people internally within the project.
• Proficient in designing Sub Reports, Parameterized and Cascaded Parameterized Reports.
• Environment: SQL Server 2005/2000, SQL Server Analysis Services (SSAS), Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), VS2005, windows 2003, T-SQL, DTS, Oracle, PL/SQL, SQL Profiler, MDX, C#.

Confidential Scottsdale, AZ Dec 2005 - May 2006
SQL Server Developer/SSIS/SSRS
McKesson is America\'s oldest and largest health care services company. McKesson\'s vision is to create a health care system where quality is higher, mistakes are fewer and costs are lower. It is the nation\'s leading health care IT Company, with software and hardware technology installed in more than 70% of the nation\'s hospitals. It provides decision support software to help physicians determine the best possible clinical diagnosis and treatment plans for patients. It also develops and installs electronic systems that eliminate the need for paper prescriptions.
Roles and Responsibilities:

• Created complex stored procedures and functions to support efficient data storage and manipulation as well as database Replication.
• Created new database objects like Stored Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Designed and implemented data access stored procedures and Triggers for automating tasks.
• Implemented constraints on tables. Database tuning and performance planning.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.
• Dropped and recreated the Indexes on tables for performance improvements.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Involved in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS 2005/2008), DTS, Bulk Insert and Bulk Copy Program utility.
• Transforming and Validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Created SSIS packages for transferring the data from different systems.
• Design and developing SSIS packages to import data from various large volume encrypted files into SQL database for data warehouse.
• Responsible for cleaning the data and maintaining the accuracy and quality of the data load from the files into the database objects.
• Created linked servers for data retrieval using OLEDB data source and providers.
• Proficiently created Reports based on the requirements using SSRS 2005, 2008.
• Identified the database tables for defining the queries for the Reports.
• Defined parameters for parameterized Reports.
• Proficiently scheduled the Subscription Reports with the Subscription Report wizard.
• Excelled in deployment and generation of Reports.
• Preparing the reports for the day-to-day as well as weekly/monthly purposes.

Environment: Microsoft SQL Server 2000/2005, Windows Server 2003, SQL Profiler, Tuning Advisor, SSMA, SSRS, SSIS, DTS, ASP.Net, Query Analyzer, Enterprise Manager.

Confidential Oct 2004 – Nov 2005
SQL Server DBA/Developer
ICICI Bank is the second largest financial service company headquartered at Mumbai India. It ranks second in term of sales and total assets. It offers a wide range of banking products and financial services to corporate and retail customers through a variety of delivery channels and through its specialized subsidiaries in the areas of investment banking, life and non-life insurance, venture capital and asset management.
Roles And Responsibilities:

• Developed Stored Procedures to retrieve data from multiple tables.
• Implemented Check, Primary Key and Foreign Key constraints on tables for referential integrity.
• Fine tuned DML, DDL scripts with lock hints for improved performance.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Successfully implemented indexes on tables for optimum performance.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
• Good knowledge in normalizing and de-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create packages to validate, extract, transform and load data to data warehouse databases, data marts and process cubes to store data to OLAP databases and configured packages event logs.
• Worked with Data architect in developing data marts Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing cubes.
• Involved in project status report updates/ creation of issue items for reviews/updates of technical and transformation files on timely basis.
• Used SQL profiler to view index performance to mostly eliminate table scan.
• Monitored the database and performed fine-tuning, query optimization for improved performance.

Environment: Microsoft SQL Server 2000, MS Access, T-SQL, DTS, Oracle 7.x, Windows Server 2003/NT/XP, Microsoft Office 2003.

Confidential Oct 2003 - Sept 2004
SQL Server Developer / DBA

Airtel Inc is one of the biggest telecommunication companies in India provides not only wireless and wire communication but also broadband internet access service as well, serving millions of customers nationwide.

Roles and Responsibilities:

• Installation and configuration of SQL Server 2000.
• Created and developed stored procedure, Triggers, indexes and functions to handle complex business rules.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
• Good knowledge in normalizing and de-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Created users and logins and granted the permissions at server and Database level.
• Managing SQL servers, databases, and storage management.
• Developed DTS packages to transfer the data between SQL server and other database and files.
• Partly involved in trouble shooting and debugging errors.
• Developed various Transact-SQL scripts to generate various reporting needs.
• Building utility programs for data extraction, transformation, and importing/exporting with SQL Server Database.
• Restoring the backup files on different environments (development, test and production).
• Implemented disaster recovery plans (Log shipping).
• Implemented Security, which included creating Logins, Users and granting permissions to users.

Environment: Windows server, SQL Server 2000, T-SQL, DTS, MS Access, MS Excel, MS visual source safe.