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
Wells Fargo 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
AT&T Inc. 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
JPMorgan Chase & Co. 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, JPMorgan Chase 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,GA 2/2006 -7/2007
MS SQL Server/SSIS/SSRS Developer
SunTrust Banks, Inc. 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.