Professional Summary:

• 10 years of professional experience on Design, Development and Maintenance of Database using tools of MS SQL Server 2000/2005/2008 as a Developer.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experience in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating Dynamic packages for Incremental Loads and Data Cleaning in Data Ware House using SSIS.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Excellent experience in developing stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for the Business Users.
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Involved in Query Optimization and Performance Tuning using SQL Profiler, Index Tuning Wizard and store procedure Debugger.
• Involved in system analysis, design, development, testing and implementation of projects Software Development Life Cycle (SDLC).
• Expert in performing various types of testing like Functional Testing, Regression Testing and System Testing and Acceptance Testing.
• Good team player, Self-motivated and possess ability for critical thinking and analysis and Strong inclination for finishing job before project deadline.

Education Qualifications: 
MS. Computer Applications 
BS. Commerce 

Skillset: Windows 2008/ 2003/2000/NT server, MS SQL Server 2000/2005/2008,T-SQL, PL/SQL, Visual Studio 2008/2005/2003,C, C++, VB.net, DTS, SSIS, MS Access,, Oracle, SQL Server Business Intelligence Development Studio (SSBIDS), SQL Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, SSAS, MS Office, Adobe Photoshop, Ms Excel, MS-Project 2000, Excel, SQL Server Reporting Services, Crystal Reports

Projects Summary:

Confidential, Phoenix, AZ 11/2011 – To Present
MS SQL Server Developer/ SSRS/SSIS Developer /Analyst/Architect 
Confidential is one of the largest financial institutions in the world. Responsible for helping to design and develop a EDW for all of Wells Fargo’s Home equity reporting needs and creating reports on top of the EDW.
Hardware/Software:
MS SQL Server 2005/2008, MS SQL SSRS, SSIS, Visual Sourcesafe, Windows 2003 Advanced Server.
Responsibilities:

• Gathered from the users their home mortgage modification reporting requirements like Referrals, Application, Submittals and Decisions etc. for their Home Equity solutions.
• Production support on all the user issues including bug fixing, report enhancements, and user training.
• Responsible for providing analytical data for their decision support.
• Designed the database by creating tables, semi-summary tables and other database objects to cater to the needs of the user requirements.
• Responsible for report performance and interacted with the DBAs to advise on table partitioning, data imports from DB2 databases and other issues.
• Responsible for smooth transition during upgrades of DW objects like stored procedure, tables, packages etc.
• Mentoring other team members on the requirements, database design, applications and business processes.
• Performed QA to ensure correctness and performance of their reports
• Participated in weekly IT status update meetings.
• Designed and developed a database to house data from various data sources for all reporting needs.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Identified the Data Source and defined them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005/2008.
• Schedule jobs to transfer reports to MS Excel.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created parameterized, drill-down and drill-through reports.
• Deployed reports to Reporting Services.
• Participated and documented all aspects of the QA process.

Confidential, Middletown, NJ 11/2008 – 11/2011
MS SQL Server Developer/ SSRS/SSIS Developer /Architect 
Confidential. is one of the largest tele-communications company in the world. Responsible for helping to design and develop a EDW for all of AT&T’s Eastern Division reporting needs and creating reports on top of the EDW.
Hardware/Software:
MS SQL Server 2005/2008, MS SQL SSRS, SSIS, Visual Sourcesafe, Windows 2003 Advanced Server.
Responsibilities:

• Gathered reporting requirements from every department.
• Participated in weekly IT status update meetings.
• Designed and developed a database to house data from various data sources for all reporting needs.
• Created SSIS packages to extract, transfer and load data into the data warehouse on a daily basis.
• Identified the Data Source and defined them to build the Data Source Views.
• Developed Query for generating drill down reports in SSRS 2005/2008.
• Schedule jobs to transfer reports to MS Excel.
• Created and scheduled SQL jobs to run SSIS packages on a daily basis.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
• Configured packages event logs.
• Created ETL SSIS packages both design and code to process data to target databases.
• Created parameterized, drill-down and drill-through reports.
• Created subscription to reports.
• Deployed reports to Reporting Services.
• Participated and documented all aspects of the QA process.

Confidential, IL 8/2007-11/2008
MS SQL Server/ SSRS /SSIS/SSAS Developer /Architect
Confidential. is a leading global financial services firm with assets of $2 trillion and operations in more than 60 countries. The firm is a leader in investment banking, financial services for consumers, small business and commercial banking, financial transaction processing, asset management, and private equity. A component of the Dow Jones Industrial Average, Confidential serves millions of consumers in the United States and many of the worlds most prominent corporate, institutional and government clients under its J.P. Morgan and Chase brands.
Hardware/Software: 
Microsoft SQL Server 2008/2005, Windows XP, Transact SQL, SSIS, SSRS, Erwin, Query Analyzer, SQL Query Manager, MS Visual Source safe, Performance Monitor, Query Optimizer.
Responsibilities:

• Played an important role in understanding custom objects ofPayment Net functionalities and implement them in the JPMC Commercial Cards system and related enhancements.
• I will also be responsible for configuring all the Events that should get triggered pertaining to the Payment Net functionality.
• Installed and configured SQL Server 2008 in test environment with latest service packs and migrated few database.
• Created ETL packages in SSIS with error handling.
• Conducted data migration processes in the SQL Server environment using SQL Server Integration Services.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server 2008 Integration Services (SSIS).
• Transformations of data such as adding derived column, sorting of data, merging of data has been done while pulling data from SQL Server 2005 to the SQL Server 2008.
• Performance tuning, and Optimization of procedures and queries.
• Created Complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL. Worked on Performance point server and created management reports.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Developed Sub Reports, Matrix Reports, Tabular, Charts, Drill down and Parametric reports, using SQL Server Reporting Services (SSRS).
• Worked with building the complex Ad Hoc, Standard Reports using SSRS and worked with tuning the large complex reports on SQL Server Database.
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Conducted data analysis and did Data Modeling and Created ER Diagrams using Logical Schema and Star Schema.
• Involved in developing logical and physical modeling of the database using Erwin.
• Responsible for logical and physical data modeling, database design, star schema, data analysis, programming, documentation and implementation.

Confidential, Atlanta, GA 2/2006 -7/2007
MS SQL Server/SSIS/SSRS Developer
Confidential. is a diversified financial services holding company whose businesses provide a range of financial services to consumer and corporate clients. The project involved building a data repository to organize mortgage loan documents that are received from customers, submitted through various branches and different sales teams. Prior to the development of the system the data existed in various RDMS and post development the system is made as single stop for various needs. 
Hardware/Software:
MS SQL Server 2000/2005, SSIS, SSRS, T-SQL, Visual Studio 2005, MS Office, SQL Profiler, Windows 2000/2003 
Responsibilities:

• Developed Complex Queries in T-SQL, Stored Procedures, and Views with best execution plan.
• Created User Defined Functions, Triggers, Indexes.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
• Used the SSIS to migrate Databases such as Oracle and Access database, flat files to SQL server 2005.
• Developed DTS jobs to import data from legacy systems.
• Used SQL Server Mail Agent for sending automatic emails when any packages, queries are failed.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Used Event Handlers for Exception Handling in SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Complex Reports like Cascaded Reports, Drill Through, Tabular Reports, Matrix Reports, Drill-down and Crosstab Reports.
• Designed and developed various Service management reports, utilizing dynamic and cascading Prompts, sub-reports, charts, Formulas, parameterized reports, Navigation reports and dynamic reports using SSRS.

Confidential, PA 8/2005 – 2/2006 
MS SQL Developer
Confidential is one of the leading health care systems, which provide wide variety of health insurances. Confidential is known for its quality and efficiency, which offer products like Whole life insurance, Universal life insurance and Term Life insurance. This project involved the development of a Web based intranet application for employees within the company. The employees can access complete customer account information, process insurance claims and authorize claims of the customers. The application generates free quotes for the customers depending on the type of insurance plan selected after validating their personal information.
Hardware/Software:
MS SQL Server 2000, T-SQL, Enterprise Manager, SQL 7.0, Developer 2000,MS Office 2000, Windows 2000, ASP/VB.NET.
Responsibilities:

• Responsible for installation, configuration and maintenance of MS SQL Server on various environments.
• Developed stored procedures and T-SQL code to accomplish various tasks.
• Created the different user defined functions in the application.
• Tuned SQL statements and Stored Procedures.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Managing disk space on Windows NT systems.
• Interacted with front-end developers to fix data base issues.

Confidential, Hopkins, MN 7/2004- 8/2005 
MS SQL Server Developer:
Confidential is a diversified health and well-being company dedicated to making health care work better. Confidential offers a broad spectrum of products and services through seven operating businesses: Confidential, Ovations, AmeriChoice, Uniprise, OptumHealth, Ingenix and Prescription Solution. The project is about developing and implementing database and providing support thereby increasing the performance of the database.
Hardware/Software:
MS SQL Server 2005, SQL Server 2000, SSRS, SSIS, T-SQL, MS-Excel, XML, Windows 2000/2003/NT/XP.
Responsibilities:

• 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.
• 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).
• Created SSIS packages to migrate data from Oracle 8i, MS SQL 2000 to MS SQL Server 2005.
• 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 SQL server Reports using SSRS 2005 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 new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• 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.
• Created drill down and sub reports from SSAS cubes that can be browsed on web.
• Created cube structure for the analysis of business condition and for creation of report using SSAS.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
• Created Queries for generating drill down reports in SSRS 2005.