SUMMARY

• Over 10+ Years of extensive working Experience in full life cycle development involving Analysis, Design, Development, Deployment, Testing, Implementation & Maintenance of application software in Web - based environment, distributed n-tier architecture and Client/Server architecture.
• Excellent working experience in Application, Intranet and Internet Programming using VB.Net, ASP.Net, C#, MVC3, LINQ, Visual Basic 6.0, Crystal Reports, Ajax, XML, JavaScript, HTML, DHTML, CSS, MS OLAP, PL/SQL, ADO.Net, DTS, SSIS, Awk Script, Bash Script, Shell Script, Windows API, MS SQL Server’s 2005/2000/7.0 and MS Sql Server Reporting Services.
• Excellent working experience using with Internet Information Server (IIS), Windows/ Confidential Server.
• Excellent working experience in Web Programming using HTML, DHTML, Ajax, JQuery and JavaScript.
• Extensive experience in Writing Stored Procedures / Triggers / Cursors / Indexes.
• Experience in MS SQL Server Installation, Configuration, Performance Tuning, client/server connectivity, building servers, trouble shooting, clustering, query optimization, back-up/recovery, running Database Consistency Checks using DBCC and troubleshooting on large databases and maintaining, supporting, monitoring production and test environments.
• Excellent working experience in design and development of several reports using Crystal Reports 7.0/8.5/9.0/10.0 & MS SQL Server Reporting Services 2008/2005/2000.
• Excellent troubleshooting techniques and experience with replication server, migration, DTS and SSIS.
• Good working experience in Enterprise Manager, T-SQL and Query Analyzer.
• Excellent working knowledge in BCP, MQ Series (Message-Queuing).
• Experience working with Large Databases and in supporting multiple production database servers.
• Strong Database Objects development - Tables, Views, Triggers, Stored procedures, Cursors, T-SQL batches using SQL Server 2005/2000 and MS Access.
• Experience in Database/Data migration from Database to Database, DTS packages and SQL batches.
• Experience in Unix, Awk Script, Bash Script, Shell Script and Cygwin tools
• Excellent working experience in Security Issues, Performance Tuning and Testing.
• Excellent working experience in handling Third Party Tools like Mapforce, Erwin, SQLCompare etc.
• Excellent working experience in configuration management using MS-Visual Source Safe and WinCVS.
• Very strong analytical and problem solving techniques, presentation skills & deliverance and proven team player/leadership qualities.
• Excellent communication and interpersonal skills and a good team player.
• Expertise in Requirement analysis, Database design, Data modeling and complete software lifecycle.
• Having Working Experience in Insurance / Banking / Retail / Finance / ERP / Healthcare Domains.

TECHNICAL SKILLS

DotNet: C#, ASP.Net, VB.Net, MVC3, LINQ

OS: Windows XP Professional, Windows 2008/2000 Advanced Server/Professional, Windows Confidential 4.0 Server/Workstation, Windows 9x

ETL: SQL Server DTS / SSIS

Language: C, C++, Html, Xml, Awk Scripting, Bash Scripting, Shell Scripting, Unix

RDBMS: MS SQL Server 2005/2000, Oracle 10g, MS Access

Source Safe: Visual SourceSafe, Win CVS

Reporting Tool: Crystal Report 8.5 and SQL Server Reporting Services 2005/2000

Tools: Office 97/2000/XP, VBA Programming, Microsoft Mappoint 2003

Application: Visual Basic 6.0, Cygwin 1.7.1

Web Server: IIS 5.0 & IIS 6.0

Third Party Tools: SQL Compare 3.0/7.1, CA ERwin DataModeler

PROFESSIONAL EXPERIENCE

Confidential, IL

Architect / SQL Developer

Responsibilities:

• Working in a team of Five, Involved in design, development, enhancement, implementation, testing, maintenance, version upgrade and performance tuning of the application
• Participated in meetings with Business Partners & Business Analyst to gather business and software requirements for application backend design and development
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application, creating new stored procedures & SQL scripts as part of the enhancements.
• Created Business Intelligence reports on a periodic basic for different facilities based on the business requirement
• Perform database consistency checks at regular intervals.
• Used Microsoft Visual Source Safe for version control.

Environment: Microsoft SQL Server 2005, SSIS 2005, VB Script, Microsoft SQL Server Reporting Services 2008/2005, VB Script, Unix, Erwin, Cygwin, Awk Scripting, Bash Scripting, Shell Scripting and VSS.

Confidential, IL

SQL Developer

Responsibilities:

• Worked in a team of Ten, Involved in development, enhancement, testing and performance tuning of the application
• Developed the Application using Microsoft.Net (VB.NET).
• Extensively used ADO.Net to interact with the SQL Server database.
• Participated in meetings with Business Partners & Business Analyst for development of the application.
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application, creating new stored procedures & SQL scripts as part of the enhancements.
• Perform database consistency checks at regular intervals.
• Using PVCS for version control.

Environment: VB.Net, C#.Net, ADO.Net, XML, .Net framework 3.5, TSQL, Stored Procedures, Scripts, PVCS and Microsoft SQL Server 2005.

Confidential, IL

SQL Developer / ETL Developer

Responsibilities:

• Worked in a team of Ten, Involved in development, enhancement, testing and performance tuning of the application
• Developed the Application using Microsoft.Net (ASP.NET).
• Developed Custom Controls and User Controls using C#.
• Extensively using ADO.Net to interact with the SQL Server database.
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application & data migration, created new stored procedures & SQL scripts as part of the enhancements.
• Created new SQL scripts/TSQL for the data validation/datatype checks/referential integrity checks/rollback scripts etc.
• Developed DTS/SSIS Packages to transform data from Text/CSV/Excel file to SQL Server database.
• Worked in SQL Server Reporting Services 2005 for reports generation.

Environment: ASP.Net, C#.Net, ADO.Net, AJAX, JavaScript, XML, MS SQL Server 2005/2000, TSQL, Data Transformation Service (DTS), SSIS, Windows XP, Visual Source Safe and Microsoft SQL Server Reporting Service 2005.

Confidential, NE

SQL Developer / ETL Developer

Responsibilities:

• Worked in a team of Nine, Involved in development, enhancement, testing and performance tuning of the application.
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application & data migration, created new stored procedures & SQL scripts as part of the enhancements.
• Created clustered and non-clustered indexes for improved performance.
• Developed DTS Packages to transform data from text file to SQL Server database.
• Worked in SQL Server Reporting Services 2005 for reports generation.
• Perform database consistency checks at regular intervals.

Environment: SQL Server 2005/2000, TSQL, Oracle 10g, DTS, Windows XP, Visual Source Safe and Microsoft SQL Server Reporting Service 2005.

Confidential, DC

SQL Developer / ETL Developer / Application Developer

Responsibilities:

• Worked in a team of Eleven, Involved in development, enhancement, testing and performance tuning.
• Developed the Application using Microsoft.Net (ASP.NET and VB.Net).
• Developed Custom Controls and User Controls using C#.
• Extensively used ADO.Net to interact with the SQL Server database.
• Analyzed the bottlenecks in the stored procedures, SQL queries and tuned them for improving the performance of the application & data migration, created new stored procedures & SQL scripts as part of the enhancements.
• Worked in SQL Server Reporting Service 2000 for reports generation.
• Used SQL Compare 3.0 a third party tool to check the data consistency.
• Participated in meetings with Business Partners & Business Analyst for development of the application.
• Used Visual Source Safe for version control.

Environment: ASP.Net, VB.Net, C#.Net, ADO.Net, .Net Framework, Xml, JavaScript, MS SQL Server 2005/2000, SQL Compare 3.0 and Microsoft SQL Server Reporting Service.

Confidential, VA

SQL Developer / Application Developer

Responsibilities:

• Worked in a team of five, Involved in development, enhancement, testing and performance tuning of the application.
• Developed the Application using Microsoft.Net (ASP.NET).
• Developed Custom Controls and User Controls using C#.
• Extensively used ADO.Net to interact with the SQL Server database.
• Analyzed the bottlenecks in the stored procedures and tuned them for improving the performance of the application, created new stored procedures as part of the enhancements.
• Worked in SQL Server Reporting Service for reports generation.
• Participated in meetings with Business Partners & Business Analyst for development of the application.
• Used winCVS for version control.

Environment: ASP.Net, C#.Net, ADO.Net, .Netframework 1.1, Xml, IIS 6.0, JavaScript, WinCVS 1.3, MS SQL Server 2000 and Microsoft SQL Server Reporting Service.

Confidential, VA

SQL Developer / Application Developer

Responsibilities:

• Worked in a team of six, Involved in development, enhancement, testing and performance tuning of the application.
• Developed the Application using Microsoft.Net (ASP.NET).
• Developed Custom Controls and User Controls using C#.
• Extensively used ADO.Net to interact with the SQL Server database.
• Analyzed the bottlenecks in the stored procedures and tuned them for improving the performance of the application, created new stored procedures as part of the enhancements.
• Worked on SQL Server Reporting Service for reports generation.
• Used winCVS for version control.

Environment: ASP.Net, C#.Net, ADO.Net, .Netframework 1.1, IIS 5.0, JavaScript, WinCVS 1.3, MS SQL Server 2000 and Microsoft SQL Server Reporting Service.

Confidential, WA

SQL Developer / Application Developer

Responsibilities:

• Worked in a team of five, Involved in development, enhancement, testing and performance tuning of the application.
• Developed the Application using Microsoft.Net (ASP.NET).
• Developed Custom Controls and User Controls using C#.
• Extensively used ADO.Net to interact with the SQL Server database.
• Participated in meetings with Business Partners & Business Analyst for development of the application.
• Analyzed the bottlenecks in the stored procedures and tuned them for improving the performance of the application, created new stored procedures as part of the enhancements.
• Worked on Data Transformation Services (DTS) to download data from ftp, transform data from text files to SQL Server database tables and update certain table in database using SQL Server DTS packages.
• Used winCVS for version control.

Environment: ASP.Net, C#.Net, ADO.Net, .Netframework 1.1, IIS 5.0, JavaScript, WinCVS 1.3, MS SQL Server 2000 and Microsoft SQL Server Data Transformation Service(DTS).

Confidential

SQL Developer / Application Developer

Responsibilities:

• Worked in a team of six, mostly involved in development, enhancement of the module, as well as performance tuning.
• Developed the Application using Microsoft.Net (ASP.NET).
• Extensively used ADO.Net to interact with the SQL Server database.
• Analyze the bottlenecks in the stored procedures and tune them for improving the performance of the application, created new stored procedures as part of the enhancements.
• Analyze the requirements and enhancements the application interfaces and the database.
• Participated in meetings with Business Partners for the module development.
• Worked on crystal reports for report generation.
• Used Visual Source Safe 6.0 for version control.

Environment: ASP.Net, C#.Net, ADO.Net, .Netframework 1.0, IIS 6.0, Visual SourceSafe 6.0, Crystal Reports 8.5 and MS SQL Server 2000.

Confidential, NY

SQL Developer / Application Developer

Responsibilities:

• Worked in a team of four, mostly involved in development, enhancement, testing, as well as performance tuning of the application.
• Developed the Application using Microsoft VB 6.0.
• Extensively worked on Microsoft Map Point 2003
• Participated in meetings with Business Partners for the application development.
• Used Visual Source Safe 6.0 for version control.

Environment: Visual Basic 6.0, ADO, Visual SourceSafe 6.0, Crystal Reports, Microsoft Access, Microsoft SQL Server and Microsoft Map Point 2003.