SUMMARY

• 10+ years of experience in all phases of software product development life Cycle, including functional & technical design, analysis, programming, testing, deployment and maintenance.
• 7+ years of experience in .NET framework, ASP.NET, C#.NET, VB.NET and ADO.NET.
• 6+ years of experience in SQL Server 2000(creating Tables, Views, Stored Procedures, Triggers etc.,) MS Access and MySQL
• Strong developing experience in Visual Studio.NET 2003 / 2005, Visual Studio 6.0
• Good knowledge on winforms using .Net framework
• Areas of strength include C#.Net, Visual Basic 6.0, VB.NET, SQL Server 2000, SQL Server 2005, SSIS, MS Access and MySQL.
• Good knowledge on Windows desktop applications
• Involved in testing (Unit, Integration, Functional and Volume) the applications
• Involved in documentation of functional and technical specifications
• Proficient at setting priorities and meeting goals, Outstanding communication and interpersonal capabilities
• Quick learner with ability to rapidly achieve organizational integration, assimilate job requirements, employ new ideas, concepts, methods, and technologies.
• Energetic and self - motivated team player.

TECHNICAL SKILLS

.Net: C#.Net, VB.NET, ADO.NET, ASP.NET Framework, VS.NET, ActiveX control, .NET 2.0 /1.1, Winforms

Languages: Visual Basic 6.0, C#, C/C++,VB script

Reports: Crystal Reports

RDBMS: SQL Server 2000, SQL Server 2005, MS-ACCESS and MySQL 4.1 etl: SSIS

Tools: Visual Studio.NET 2005, Visual Studio 6.0, VSS 6.0

Operating Systems: Windows 98/2000/XP/2003

Protocols: HTTP, FTP, TCP/IP

Web Technologies: XML, HTML, CSS, VBScript

PROFESSIONAL EXPERIENCE

Confidential, IA

Senior Analyst Programmer

Responsibilities:

• Prepared Pseudo code before start implementing the actual coding
• Created tables for the project
• Created and used SQL stored procedures to insert update and delete transactional data.
• Implemented validations using SQL Server 2005
• Design and created different ETL packages using SSIS from Oracle source to Sql server as destination.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Prepared tests cases for Quality assurance and testing application
• Created SSIS Packages to import and export data
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize performance
• Written Test Cases
• Involved in testing and debugging
• Involved in client support activities
• Involved in writing functional documentations for the end users
• Gained knowledge on Customer relationship management and Inventory management
• Implemented validations using SQL and C#.NET
• Involved in Source Code Management using Visual Source Safe.

Environment: Microsoft SQL Server Enterprise Edition, SQL Server Integration Service Tools, SSRS Windows server 2003, C#.Net, ADO.NET, Microsoft Visual Studio.Net 2005.

Confidential

System Analyst Programmer

Responsibilities:

• Developed winforms using .NET controls
• Interact with users and analyzing the requirements and convert them into technical specifications
• Performed extensive coding using C#.NET
• Created Custom controls through C#.NET
• Developed Generic API’s for the module
• Extensively worked on Data Adapter, Data Readers and Data Sets of ADO.NET.
• Used .NET Data grid control to display and sort multiple records.
• Prepared Pseudo code before start implementing the actual coding
• Written comments for functions, procedures, classes, objects and variables in every project
• Created tables for the project
• Created and used SQL stored procedures to insert update and delete transactional data.
• Implemented validations using SQL and C#.NET
• Involved in Source Code Management using Visual Source Safe.
• Developed extensive number of reports through Data Reports
• Written Test Cases
• Involved in testing and debugging
• Involved in client support activities
• Involved in writing functional documentations for the end users
• Gained knowledge on Customer relationship management and Inventory management

Environment: C#.Net, ADO.NET, Microsoft Visual Studio.Net 2005, SQL Server 2000, SSRS,HTML, XML, Visual Source safe, Windows server 2003

Confidential

System Analyst Programmer

Responsibilities:

• Developed winforms using .NET controls
• Interact with users and analyzing the requirements and convert them into technical specifications
• Performed extensive coding using C#.NET
• Created Custom controls through C#.NET
• Developed Generic API’s for the module
• Extensively worked on Data Adapter, Data Readers and Data Sets of ADO.NET.
• Used .NET Data grid control to display and sort multiple records.
• Prepared Pseudo code before start implementing the actual coding
• Written comments for functions, procedures, classes, objects and variables in every project
• Created tables for the project
• Created and used SQL stored procedures to insert update and delete transactional data.
• Implemented validations using SQL and C#.NET
• Involved in Source Code Management using Visual Source Safe.
• Developed extensive number of reports through Data Reports
• Written Test Cases
• Involved in testing and debugging
• Involved in client support activities
• Involved in writing functional documentations for the end users
• Gained knowledge on Customer relationship management and Inventory management

Environment: C#.Net, ADO.NET, Microsoft Visual Studio.Net 2005, SQL Server 2000, HTML, XML, Visual Source safe, Windows server 2003, Microsoft Office Suite, Crystal Reports

Confidential

System Analyst Programmer

Responsibilities:

• Actively involved in designing and coding for the entire application.
• Developed Generic API’s for the module
• Prepared Pseudo code before start implementing the actual coding
• Written comments on each section of the code
• Extensively worked on Data Adapter, Data Readers and Data Sets of ADO.NET.
• Designed and developed customized forms, which extensively use data grids controls using VB.Net
• Developed generic tab user control to display data driven tabs on pages
• Created tables and Stored procedures for the project
• Created user defined data types and added them to model database for future purpose.
• Developed extensive number of reports through Crystal Reports
• Actively involved in testing the application
• Involved in testing and debugging
• Involved in client support activities
• Gained knowledge of Freight Management process

Environment: VB.Net, ADO.NET, Microsoft Visual Studio.Net 2003, SQL Server 2000, Visual Source safe, Windows server 2003, Microsoft Office Suite, Crystal Reports

Confidential, PA

System Analyst Programmer

Responsibilities:

• Created webforms using .Net framework
• Developed the Session Manager and Data Manager windows Services using ASP.Net
• Developed Web Forms using .NET server controls
• Performed extensive coding.
• Extensively worked on Data Adapter, Data Readers and Data Sets of ADO.NET.
• Used .NET Datagrid control to display and sort multiple records.
• Involved in writing code on ADO.NET to communicate with database.
• Generated Data Transfer Service Packages to export the data from Excel to SQL server database.
• Designing the backend database using the MS SQL Server 2000.
• Created and accessed PL/SQL stored procedures to insert update and delete transactional data.
• Implemented most of the business logic using stored procedures.
• Implemented client and server side validations using .NET validation controls
• Involved in Source Code Management using Visual Source Safe.
• Written SQL scripting files.
• Unit testing and bug fixing during functional testing & UAT (user acceptance testing).

Environment: ASP.Net, ADO.NET, Microsoft Visual Studio.Net 2005, SQL Server 2000, HTML, XML, Visual Source safe, Windows server 2000, Microsoft Office Suite, Crystal Reports

Confidential

Analyst Programmer

Responsibilities:

• Requirement Analysis and study about the system
• Played a vital role in designing forms, modules and reports
• Developed reports using Visual Studio Data Report.
• Implemented business logics using Visual Basic 6.0 with SQL Server 2000 as backend.
• Connection established through ADO.
• Used various data control and display elements like MS Flex Grid and List Control to extract data from the backend.
• Wrote Stored Procedures to incorporate new Business logic.
• Wrote SQL Queries for creating and updating tables, reports
• Interacted with the end users to get the new requirements for the reports and testing.
• Performed testing and debugging

Environment: Visual Basic 6.0, Crystal Reports, MSSQL Server 2000, MS Word and MS Excel