SUMMARY

• 9 years of experience in various technologies with 3 years in US working as Developer / Business Analyst diversified experience in complete life cycle software development which includesRequirement gathering, software design, analysis, development andimplementation of web and client serverapplications.
• Extensive experience using Microsoft Technologies likeASP.NET, C#,VB.NET, ASP, PHP, MS SQL Server 2000/2005/2008 , MYSQL, MS - Access, SSIS, XML, Java Script, AJAX.
• Excellent Knowledge on .Net 3.0 /3.5 (WCF), Web Services, WPF (MVP).
• Experienced in creating reports in Crystal Reports, SSRS and Microsoft Reporting Service
• Experience in writing and tuning complex stored procedures forSQL Server.
• Involved in preparing Object Oriented AnalysisandDesignDocuments and experience working with OOP concepts and design patterns.
• I have best working experience in Healthcare, Media, Financial investments, Transportation, Government and Retail domains
• Involved in requirements gathering and extensive interaction with clients for process flow and methodologies.
• Experience with Unit Test Case development and Scenario writing to support User Acceptance Testing.
• Good team player with the ability to work independently in a time sensitive environment.
• Good organizational and communication skills, with the ability to clearly express technical concepts verbally and in written.
• Good in learning new technology and easily adapt to new environment.

TECHNICAL SKILLS

O.S.: Windows 95/98/NT/XP/2000/Vista/ 7

Languages: VB6.0/5.0, C#, VB.NET, T-SQL.

Internet Technologies: ASP, ASP.NET, JavaScript, Pearl, VBScript, HTML/DHTML, AJAX, CSS, XML/XSLT, XML Web Services, WCF, Web Services

App./web Servers: IIS

Databases: Oracle 9i/8i/7.x, MS Access, MS SQL Server 2005/2008

Reporting: SSRS 2005/2008, Crystal Reports

Database Technologies: T-SQL, ADO/DAO, ADO.NET, ODBC, Stored Procedures, Triggers, Views, IBM DB2, MSMQ

Frameworks: .NET 4.0/3.5/3.0/2.0/1.1 , Windows Presentation Foundation, Surface SDK

Other Tools: MS Access Reports, MS Office

PROFESSIONAL EXPERIENCE

Confidential, Milwaukee, WI

Business Consultant

Responsibilities:

• Primary responsibility is to understand the existing manual process and gather additional requirements from end users that need to be incorporated into the new system and communicate the same to offshore team.
• Prepared Business requirement document with use cases.
• Prepare interactive wire frame in excel, present same to client and share the same with offshore.
• Clarify offshore queries on business process by discussing the same with client for better understanding of the process.
• Verify screen and database designed by offshore.
• Analyzed Excel sheets that are being used today to generate Ad Plan and performed legacy field mapping with IOCMS database fields.
• Analyzed module external and internal interface with other applications that will feed and extract information from the new system.
• Reviewed and provided valuable comments on deliverable documents (HLD, LLD).

Confidential

.NET Technical Architect

Responsibilities:

• Primary responsibility is to analyze the existing system used by Confidential ’s.
• Attend the meeting with Business Users and Confidential ’s Technical team to understand the existing application, configuration and limitations.
• Developed best practice, solution and design of new system SGIMP using C#.NET, WCF, MSMQ, MS SQL and IBM DB2.
• Identified all applicable interfaces necessary for new design.
• Suggested necessary changes in the process.
• Suggested to use staging database to store data for future analysis and to retrieve/re-run the pricing process from point of failure.
• Suggested SQL Replication / Mirroring to replicate pricing information applicable for respective day / date from IBM DB2 to staging database, in order to improve the efficiency of the pricing batch creation process.
• Provided new application architecture using above identified technologies, interfaces identified and suggestion to improve the overall application performance and efficiency.
• Prepared technical Design (High Level & Low Level) document.
• Coordinating with offshore team in developing the application design proposed above.

Environment: C#.NET, SQL Server 2005, VSS, .NET Framework 3.5, Net 4.0, C#, WPF, MVVM, Windows NT/Xp, WCF, MSMQ, IBM DB2.

Confidential, Camp Hill, PA

.NET Programmer Consultant

Responsibilities:

• Developed FEMM (Front End Security Management Module), based on business requirements, which act as a gateway to provide and revoke access to / from IOCMS application
• Followed the SDLC Methodology fromDesign, development, testing and deployment aspects of it.
• Designed User Interface Screens using VB.Net Web using Web Client Software Factory (WCSF).
• Created and developed application using WCF Services.
• Developed reports using Microsoft report viewer.
• Experience in UML methodology.
• Used SQL Server Profiler for Performance Tuning.
• Developed dynamic stored procedures and user defined functions using SQL Server 2005.
• Wrote Unit Test Cases for reports and screens.
• UsedVisual SourceSafe (VSS) and Team Foundation Server (TFS) for software code management.

Confidential

Module Lead

Responsibilities:

• Worked as Onsite Module Lead / Coordinator for Release & Re-Entry (REE) module of IOCMS.
• Primary responsibility is to understand the existing application in mainframe and gather additional requirements from end users that need to be incorporated into the new system and communicate the same to offshore team.
• Prepare interactive wire frame in excel, present same to client and share the same with offshore.
• Clarify offshore queries on business process by discussing the same with client for better understanding of the process.
• Verify screen and database designed by offshore.
• Analyzed Main Frame Screens and performed legacy field mapping with IOCMS database fields.
• Analyzed module external and internal interface with other agency and within the application.
• Shared knowledge with other module leads/ Team Members to better knowledge of application and how it affects REE module and vise versa.
• Reviewed and provided valuable comments on deliverable documents (SRS, UIS).

Environment: VB.NET, ASP.NET, SQL Server 2005, TFS, .NET Framework 3.5, Windows NT/Xp, Web Client Software Factory(WCSF), WCF, SSRS, SSIS, Microsoft reporting Service

Confidential

Team Lead

Responsibilities:

• Business Hours & 24*7 Support for Confidential Engineering & Flight Ops Ms Access applications.
• Carry out daily maintenance activity.
• Recovery & Resolution of tickets raised by the Service & Support centre in a prompt and timely manner
• Providing information on adhoc requests about existing applications.
• Requirement Gathering, Design, Development and Testing of Local Enhancements.
• Main responsibility is to coordinate the Onsite and offshore in development and delivery activities.
• Requirement Gathering from Customer and pass it to offshore.
• Arrange frequent meeting between Business and offshore to resolve any queries regarding the development
• Testing reports developed by offshore before delivering it customer
• Involved windows Xp migration of all Engineering applications. This activity involves converting all Ms Access and Visual Basic application to Windows Xp operating system compatible. In which Ms Access 97 databases where converted into Ms Access 2003 format.
• Enhanced Warranty Db application to store attachment files in DB as binary stream to facilitate adding more details to the Warranty Claims.
• Added two new functionality in Warranty Db application to create store and Review Claims related to “Shop Processing Time” and “Loans”.
• Converted all Crystal Reports used in engineering application from version 9 to 11.1 as part Xp migration program.
• Production Support activity for Engineering Ms Access applications
• Carry out daily maintenance.
• Recovery & Resolution of tickets raised by the Service & Support centre in a prompt and timely manner
• Providing information on adhoc requests about existing applications.
• Requirement Gathering, Design, Development and Testing of Local Enhancements.
• Converting SLDP Ms Access application backend database to SQL - MS Access has a tendency of getting corrupt when multiple users access data. And it is recommended only for storing small amount of data (<1 GB, after which it becomes questionable). Te backend of the SLDP database will be converted to SQL Server, which is a more Robust database system and will fix the corruption issue.

Environment: Windows 2000/XP, VB, VBA, Crystal Reports 8.5/11.1 / 11.2 , Ms Access, DB2.

Confidential, Chicago / New York

.NET Programmer

Responsibilities:

• Applications were delivered with high quality & with time.
• Worked as active team member in resolving issues within the team.
• Worked as a member of QA team. The main tasks involved are developing Automation applications to automate QA processes using C#.net and Crystal Reports.
• Applications deals with retrieving/formatting the raw data transferred between the BNS server to the electronic exchange.
• Generates reports on status of the successful formatting done by the application. This will help user to track the number of data failed to format.

Environment: Windows 2000/XP, AS400, C#.net, Crystal Reports 8.5, IBM series, DB2, Mercury Quality Centre, Quick Test Professional, Clear Case(for source code control)

Confidential

IT Consultant

Responsibilities:

• Worked at client side at Ranbaxy IT building Gurgaon, India.
• Wrote SQL queries according to the client business requirement.
• Wrote user-defined SQL functions to perform necessary calculation before providing output to report through SQL queries.
• Implemented & tested SMS system successfully and dually appreciated by the client for active work.

Environment: Windows NT/2000/XP, Crystal Report 8.5, SQL server 2000

Confidential

.NET Developer

Responsibilities:

• Design and develop application using C#, ASP.net and SQL Server as per business requirement.
• Regularly visited to client side to acquire requirements.
• Implemented in client side & tested successfully

Environment: C#.net, Asp.net, Crystal Reports 8.5, SQL server Confidential UpdatesNoida, India

Confidential

.NET Programmer

Responsibilities:

• Design and developed application using ASP and SQL Server as per business requirement.
• Regularly visited to client side to acquire requirements.
• Implemented in client side & tested successfully.
• 24x7 production support.

Environment: ASP, SQL Server 2000, ASP Fileupload, Soft Aritans

Confidential

.NET Programmer

Responsibilities:

• Designed and developed application using C#, Asp.net and SQL server as per requirement.
• Deploying application in server and testing.
• Maintained Web server and database in web server.
• Worked as network administrator to manage systems and network of the company.

Environment: C#, Asp.net, Crystal Reports 8.5, SQL server