PROFESSIONAL SUMMARY:

• 5+ years of Strong Experience in developing applications using SQL Server Integration Services (DTS 2000/SSIS 2005/2008) and Reporting Services(SSRS 2005/2008).
• Strong Experience in Developing Applications, including Dimensional Data Modeling - Star Schema, Facts & Dimensions
• Experience using Microsoft .NET platform with 3-tier Development environment using C#, ASP.NET, ADO.NET, XML, Web Services, SOAP, ODBC, IIS, Crystal Reports.
• Proficient Experience in developing SQL/PL-SQL Stored Procedures, Triggers, Views, functions.
• Excellent team player, involved in the SDLC cycle to Design, Develop, Unit-Test and deploy the Software Applications.
• Excellent analytical, communication, organizational and presentation skills.

Operating Systems: Windows XP/NT/ 2000 /2003/ 98 / 95.
Development Languages & GUI Tools: C#.Net, C, C++, VB.NET, T-SQL, VB script.
Web Technologies: ASP.Net
Databases: SQL Server 2000/2005/2008 and Oracle9i, Oracle 10g
Middle Ware: ADO. Net, ADO.
Methodologies: OOP, Client/Server, and Browser/Server.
Internet Technologies: AJAX, VB Script, JavaScript, HTML, DHTML, Front Page, CSS, and XML, XSL and XSD.
Reporting Tools: SSRS 2005/2008, Crystal Reports 8.0, 9.0
Web Servers: IIS 5.1, 6

MASTER OF ENGINEERING
BACHELOR OF TECHNOLOGY

WORK EXPERIENCE:

Confidential,Virginia Beach,VA 08/2011-till date
Programmer Analyst(SSRS/SSIS/T-SQL/PL-SQL)

Confidential, works on to educate the members about theirhealth status and empower themto take steps toimprove their quality of life by properly managingtheir health conditions. The objectives of the various projects include, Building Provider- network of qualified health care Providers before a contract with a state is signed, to verify and access the medical professionals\' background to ensure that the providers have the legal rights to practice and that they meet AGP\'s needs.(Credentialing).

Environment: MS SQL Server 2005/2008, SSIS, SSRS 2005/2008/2012,
VB Script, SVN, JIRA, Tidal job Scheduler, Visual Studio 208, Visual Studio 2010.

Responsibilities:

• Application Development for the Provider Network Design ,Development and support to provide an analysis of the contracted states\' provider landscape
• Developing SSRS 2005/2008 reports to help analyze the Credentialing of the Practitioners Process
• Extensively worked on to re-write/convert the majority of the reports, from VB to SSRS 2005/2008.
• Strong Understanding of the FACETS front-end application.
• Development and deploying of the SSIS 2005/2008 packages to maintain, update and migrate the data into and from the FACETS application database.
• Worked with SSRS 2012 report manager to upload, manage the contents and to create the linked reports and setting up the security options for the required users to access.
• Participating in the Business Requirements Analysis and LOE discussions for the State reports.
• Participating the design, code reviews with the team members.
• Extensive work on tuning the long-running SQL /PL-SQL Stored Procedures, when needed.
• Heavily worked on daily adhoc -to-production reports.
• Involved in providing the break-fix, for the reports that fail to run on production environment.
• Involved in working with SQL DBA\'s to set up new deployment environment and new user groups for the environments created by providing them with SQL scripts and necessary documentation to execute the deployment instructions across the Development-QA-Production Environments.
• Pro-active in learning new methodologies and technologies when needed to reach the goal of coming up with an optimum solution for the various project designs.

Confidential, FAIRFAX,VA 09/2010-08/2011
SSRS/SQL/ETL Developer

Confidential, has successfully provided the debt recovery industry with best-of-breed technology solutions to help increase profits from collections. The objective of the project was to develop the database scripts and the ETL Programs that would load the daily financial data received from the customers, into the application and also to develop the SSRS Reports on demand, for Credit Bureau Reporting.

Environment: MS SQL Server 2005/2008, SSIS, SSRS, Pervasive Data Integrator, SVN Source Control, JIRA.

Responsibilities:

• Support the Debt Collection Application specifically application related Payment Imports and skiptracing of the consumer address information.
• Extensive work in SSIS, MS SQL server and SQL programming
• Work on query tuning and optimizing database code and developing batch processing jobs.
• Perform various activities with team of technical staff and business managers and practitioners in the business unit to determine systems requirements and functionalities needed in large/complex development project.
• Assess detailed specifications against design requirements.
• Develop code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues.
• Develop Unit test cases and perform Unit testing and system testing of assigned components.
• Ability to analyze and resolve performance issue with database code involving SSIS and MS SQL Server 2005/2008.
• Responsibilities taken as a production support Developer for applications as on needed basis.
• Very Strong ability to understand and support installation/upgrades of Third Party Software.
• Knowledge of financial instruments such as making payments to the account after splitting them to the accounts based on the commission rates and the bucket levels.
• Experience using SubVersion as the source control.

Confidential, Herndon, Virginia 1/2010-09/2010
SSIS/ETL Developer

Confidential, is a government-sponsored enterprise (GSE) chartered by Congress with a mission to provide liquidity, stability and affordability to the U.S. housing and mortgage markets.

Hardware/Software: MS SQL Server 2000/2005, SSIS, Oracle 10g, , Visual Studio .NET 2005, .NET Framework 2.0/3.5, Windows NT 2003,Autosys,HP Quality Center, IBM Rational Clear Case, Compass Point tool.

Responsibilities:

• Support the Capital Markets Technology Applications specifically application related pricing, hedging and securitization of Mortgages as well as applications related to income forecasting.
• Extensive work in SSIS, MS SQL server and SQL programming
• Work on query tuning and optimizing database code and developing batch processing jobs.
• Perform various activities with team of technical staff and business managers and practitioners in the business unit to determine systems requirements and functionalities needed in large/complex development project.
• Develop code, perform reviews to advance application upgrade, extension, or other development. Analyze application for data integrity issues.
• Develop Unit test cases and perform Unit testing of assigned components
• Ability to analyze and resolve performance issue with database code involving SSIS and MS SQL Server 2000/2005.
• Very Strong ability to understand and support installation/upgrades of Third Party Software.
• Knowledge of financial instruments such as Mortgage, bonds, MBS etc
• Using Rational Clear Case, Clear quest for the source control.
• Work on to generate on-demand/daily reports using COMPASS POINT software ,used by the Traders in the Mortgage Industry.

Confidential, Irving, TX 02/ 2009 - 03/2010

Pipeline management was developed to track loan and its details. The applications was designed to provide loan officers, loan processors, and managers with instant access to the complete range of customer history that is stored in a single database, and made available through intuitive interfaces designed around the way they work..

Role: .NET/SSIS/SSRS Developer Intern

Responsibilities:

• Involved in Application Design, Code development, Database design andTesting of the application.
• Developed Data Access Layer, Business Layer and Presentation Layer.
• Involved intensively working with Object Oriented Programming Techniques. Designed, developed, exposed and consumed XML Web Services to provide business logic and dynamic reporting using C# and .NET framework.
• Used C# for creating classes and worked on integrating Crystal Reports with ASP.NET.
• Developed User controls and worked on Custom Controls for the presentation layer.
• Implementation of Ajax on server controls to avoid page post back, page flickeringand for improving the performance of the application.
• Extensive use of SQL queries, Stored Procedures, functions and Packages for better performance, to retrieve data from the back-end database.
• Creation of Stored Procedures, Views and Triggers to increase the functionality and efficiency of the application.
• Experience in creating SQL Server reports, handling sub reports and defining query for generating drill down reports using SSRS 2005/2008.
• Extensively worked on Migration of MS SQL 2000 to MS SQL Server 2005 and strong knowledge of SQL server ETL development.

Academic Projects: Confidential, TX August2007-December 2008

Interactive Student Forum

Technologies Used: C#/ASP.NET, HTML, and MS SQL Server 2000/2005 and above, MS Office
Interactive Students Forum is a web application for holding discussions and posting user generated content. It is a special forum for the students and lecturers of our college providing an opportunity to enhance their knowledge in specific areas. It is designed such that students get their doubts clarified by anyone at anytime. Interactive Students Forum is a place where users leave messages or discuss certain topic at any time.

Role: Web Developer

Responsibilities:

• Involved in creation of Data Access Layer, Business Access Layer and Presentation Access Layer using C# and ASP.NET.
• Applied various styles in CSS to effectively present the Web application.
• Use of SQL queries, Stored Procedures, Views and Triggers for better performance, to retrieve data from the back-end database.
• Handled Web.config andeffectivelyimplemented role based security to the application by using the forms authentication.
• Involved in NUnit testing to ensure that the application and logic was functioning correctly.

Library Management System Project

Technologies Used: Visual Studio .NET 2005, SQL Server 2005
The Library Management System provides the features like login, register, add category, add / remove book, search / issue book, return book.

Responsibilities:

• Design and developing the web forms using ASP.NET
• Extensive use of data readers, datasets and Data grids for editing, displaying the data for the Admin modules.
• Developed and exposed stored procedures for schedules and dynamic reports.
• Implemented Custom error handling for the application
• Implemented export to excel functionality in ASP.NET for publishing reports.

Confidential, Bangalore, India 06/ 2005-07/2007
Client: Confidential, Melbourne, Australia
SQL Server Developer

Confidential, one of the biggest telecommunication companies in the Australia, provides not only wireless and wire communication but also broadband internet access service as well. The project that I worked is a National Sale Tracking (NST) system, which uses Microsoft SQL Server 2000 and Microsoft 2000 advanced data center Servers, including 4 sets of cluster servers. My responsibilities involved in writing stored procedures, designing DTS packages, automating SFTP and migrating databases from UAT to Pilot and to Production environment.

Responsibilities:

• Managing Enterprise and Distributed Data Warehouses in Developmental and Production Environments using SQL 2005 & SQL 2000. Design, develop, test and automate Extraction Transformation & Loading (ETL) processes using SQL Server Integration Services (SSIS 2005).
• Used various Migration Wizards like Import and Export Wizard and Migration Wizard.
• Created packages and jobs to import the data on daily basis using SSIS and designed reports using SSRS.
• Extract the data from SQL Server 2000 to SQL Server 2005 using SSIS as ETL tool.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Created various Stored Procedures to validate the data from Source and update the records and insert them into a newly created tables.
• Used SSIS as ETL Tool to extract the data from production servers to OLAP Data ware house.
• Developed Matrix and tabular reports by grouping and sorting rows.
• Build and maintain complex SQL queries for data analysis, data mining and data manipulation. Organize analytical data; ensure data quality and aggregate data for strategic reporting, Performance optimization on database solutions.
• Developed the T-SQL Statements while loading the data into Target Database.
• Created Stored Procedures, UDF, and Views.
• Daily monitoring of the database performance .
• Rebuild indexes on various tables.
• Involved in deployment and testing of the application which uses SQL Server backend.
• Meet end users to discuss legacy reporting, to gather requirements, design specifications, data mapping and develop new reports using SQL Server Reporting Services (2005).
• Implemented security on the report server.

Environment: SQL Server 2000/2005, Enterprise Studio, Management Studio