SUMMARY:

• Over 8 years of IT experience in the Analysis, Design, Development, Administering, Implementing and Testing Client/server application using Microsoft SQL Server (Development, UAT and Production Environment).
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, designing logical/physical databases and Troubleshooting.
• Extensive experience with different phases of project life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Experience in SQL Server DTS design, constructing, and deployment
• Transformed data from one server to other servers using tools like Data Transformation Services (DTS).
• SQL Server 2000/2005/2008 RDBMS database development including T-SQL programming.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, using ERWIN
• Knowledge in creating web applications using ASP.Net, ASP, HTML, JavaScript and CSS (Cascading Style Sheets).
• Experience in creating client server application using VB, VB.Net, C#, WPF
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Involved in DBA activities such as backups, restores etc.
• Exposure to CMMI, ISO and QA processes, change control management, source safe, version controlling etc.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS:

Database: SQL Server 2000, 2005, Oracle

Operating Systems: Windows XP/2000/2003.

Programming Languages: SQL, PL/SQL,C#

ETL Tools: DTS

RAD Tools: VB 6.0, VB.Net

PROFESSIONAL EXPERIENCE:

Confidential

Lead Developer

Responsibilities:

• Analysis of business requirement document to identify the gaps in BRD
• Analysis and preparation of functional requirement document
• Preparation of technical specification document
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Develop modules with efficient coding and unit testing
• Coordinating with the QC team during testing and providing the required support
• Business objects are implemented using VB, VB.Net and C#
• User Interface is implemented using ASP and ASP.Net
• Migration of VB 6.0 to .Net 3.5 using WPF

Confidential

Lead/Developer

Responsibilities:

• Preparation of technical specification and Impact analysis document
• Develop modules with efficient coding and unit testing
• Defect tracking and metric preparation.

Confidential

Senior System Analyst

Responsibilities:

• Analysis and preparation of functional requirement document
• Preparation of technical specification document
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Develop modules with efficient coding and unit testing
• Implemented the project using VB 6.0 as the front end
• Business logic where implement using Informix 4GL
• Coordinating with the QC team during testing and providing the required support

Confidential

Senior Software Engineer

Responsibilities:

• Preparation of technical specification document
• Develop modules with efficient coding and unit testing

Confidential

RTQ Programmer

Responsibilities:

• Installing and Configuring of SQL Server 2000/7.0 0n windows 2000/NT OS.
• Managing of databases objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Developed DTS Packages to transfer the data between SQL server database and files.
• Creation and management of database maintenance plan for various database consistency checks.
• Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
• Implemented the project using VB.Net as the front end
• Used Crystal Report for generating report outputs.
• Preparation of technical specification document
• Develop modules with efficient coding and unit testing

Confidential

Programmer

Responsibilities:

• Installing and Configuring of SQL Server 2000/7.0 0n windows 2000/NT OS.
• Managing of databases objects like Tables, views, indexes etc.
• Implementing Backups and restoring when necessary.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Implemented the project using VB.Net as the front end
• Used Crystal Report for generating report outputs.

Confidential

Programmer

Responsibilities:

• Managing of databases objects like Tables, views, indexes etc.
• Managing of users including creation/alteration, grant of system/db roles and permission on various database objects.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Implemented the project using VB 6.0 as the front end
• Used Crystal Report for generating report outputs

Confidential

Programmer

Responsibilities:

• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Implemented the project using VB 6.0 as the front end
• Used Crystal Report for generating report outputs