PROFESSIONAL SUMMARY:

• 17 years of progressively responsible hands on experience in Information technology with extensive experience in Software Development Life Cycle phases like requirement gathering, application designing, code developing, application testing, software implementation and production support of various enterprise applications, client server applications, web applications and windows applications.
• Experience in various Industry Verticals likes Finance/Banking, Manufacturing, IT industry, Government, Hospitality, etc.
• Substantial experience in developing various applications (Windows, Web, Web services) using .Net technologies VB.Net 2.0/3.5/4, C#. Net 2.0/3.5 ASP.Net 2.0/3.5 technologies and VB 5.0/6.0, ASP 2.0/3.5, Crystal Reports 6.5/8/11, SSRS, ADO.Net, ADO, DAO, ODBC
• Developed web applications using ASP.Net, JavaScript, HTML, XML, XSLT, CSS and Visual Interdev, Visual Studio2005, VS2008, VS2010, VS2012, VS2013, Web services, WCF Services, Ajax, LINQ.
• Developed Win Forms using C#.Net and VB.Net and knowledge in WPF applications
• Substantial experience in VBA programming using MS Excel 2000
• Experience in designing and developing databases with MS SQL Server 6.5/7.0/2000/2005/2010 and Oracle 10g and MS Access 97/2000/2003/2007
• Developed reports using SQL Server Reporting Services (SSRS) and having knowledge in SQL Server Integration Services (SSIS)
• Used TOAD to work with Oracle packages and procedures
• Experience in Database programming using Oracle PL/SQL procedures and SQL Server T - SQL, Stored Procedures, triggers, views and DTS packages
• Well versed with Software Engineering principles and involved in building many frameworks and applications using Software Development Life Cycle methodologies like Structured Design, RAD(Rapid Application Development), SCRUM patterns
• Working knowledge in Configuration and Version Management using Visual Source Safe, Team Foundation Server and Harvest
• Experience in dealing with end users, business analysts, testers and management, had Team Lead experience and also had offshore team co-ordination experience
• Highly motivated and conscientious team player with problem solving, trouble-shooting capabilities, excellent analytical and presentation skills with ability to work to meet deadlines

TECHNICAL SKILLS:

Programming languages: C#2.0/3.5/4, ASP. Net 2.0/3.5, VB.Net 2.0/3.5/4, Visual Basic 5.0/6.0, ASP 2.0/3.5/4

Programming Tools: Visual Studio 6.0/2005/2008/2010/2012/2013 , Visual Interdev

Scripting Languages: VBScript, JavaScript

Markup Languages: HTML, XML, XSL, CSS

Reporting Tools: Crystal Reports 6.5/8/11, Active Reports, Excel Reporting, SSRS, SSIS

Web Server: Internet Information Server 5.0/6.0/7.5

Technologies: ADO. Net, ActiveX, ADO, DAO, ODBC, RDO, COM and MTS, LINQ

RDBMS: SQL-Server 6.5/7.0/2000/2005/2010 , Oracle 10g, MS-Access 97/2000/2003/2007

Third Party Tools: Far point technology controls, Sheridan Controls, Win Merge, TOAD, ERWIN, IplotX, Test Director, Peregrine

Operating Systems: Windows 95/98/NT/2000/XP/7, Windows 2003R2, Windows 2008R2, MS-DOS, Unix

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Programmer Analyst

Responsibilities:

• Migrated old web applications(developed in VS2005, VS2008, VS2012) to new environment(VS2013) Migrated old SQL Server databases (SQL Server 2005, SQL Server 2008) to SQL Server 2012
• Assigned tasks to Offshore team and get it done and test it before deploying to Test, QA and Prod environments.
• Updated complex SQL Stored Procedures, Views using SQL Server Management Studio 2012
• Ensuring to keep changes to the files by using Team Foundation Server (TFS 2013)
• Developed and consumed WEB Services and WCF Services
• Used MVC 4.0 architecture in developing Enterprise Work Flow and OEE (Overall Equipment Effectiveness) projects
• Created SSRS reports
• Co - ordinated with Offshore team in assigning the task and get it done.
• Involved in Code Review, unit testing, integration testing and deployment process.

Environment: Visual Studio 2013, C#.Net 4.0, VB.Net 4.0, ASP.Net 4.0, SQL Server 2012, Windows 7, Team Foundation Server 2013, Web Services, WCF Services, MVC architecture 4.0, SSRS Reports

Confidential

Sr. Programmer Analyst

Responsibilities:

• Developed webpages for the above modules using MVC architecture Written complex SQL Stored Procedures, Views using SQL Server Management Studio 2010.
• Ensuring to keep changes to the files by using Team Foundation Server (TFS)
• Used LINQ to connect to the database and call stored procedures and views.
• Developed SSRS Reports

Environment: Visual Studio 2010, VB.Net 4.0, ASP.Net 4.0, SQL Server 2010, LinQ, Windows 7, Team Foundation Server, SSRS Reports

Confidential, Troy, MI

Sr. Programmer Analyst

Responsibilities:

• Ensuring to keep changes to the files by using Team Foundation Server (TFS) worked on WCF and Web Services
• Developed SSRS reports.

Environment: VB.Net 4.0, SQL Server 2008, Windows XP, Windows 7, Team Foundation Server, MVC4.0, Web Services, WCF, SSRS reports

Confidential, Harrisburg, PA

Sr. Programmer Analyst

Responsibilities:

• Rewriting legacy VB6 application into C#.Net Document preparation, Flow chart preparation
• Written complex SQL queries using joins, stored procedures in SQL Server 2008 using Management Studio.
• Ensuring to keep changes to the files by using Clear Case
• Used XML to upload the Batch Information to insert into Database
• Files were Encrypted, Compressed, Split into multiple compressed files and then uploaded
• Used web service to interact with Database from COM component

Environment: VB6.0, C#.Net 3.5, SQL Server 2008, Windows 7, Clear Case, ASP.Net, COM Component, XML, Web Service

Confidential, NY

Sr. Programmer Analyst

Responsibilities:

• Maintenance of the existing applications Document preparation, Flow chart preparation
• Written complex SQL queries using joins, stored procedures in SQL Server 2008 using Management Studio
• Modified existing Win Forms and also developed new Win Forms using VB.Net
• Ensuring to keep changes to the files by using Visual Source Safe

Environment: VB.Net 2.0/3.0/3.5, SQL Server 2008 (SQL/TSQL), Windows 7, Visual Source Safe, Web Services, WCF, Win Forms

Confidential, Plainview, NY

Sr. Programmer Analyst

Responsibilities:

• Involved in gathering requirements from the client Used multithreading to improve the performance and responsiveness of the application
• Worked on TCP/IP objects to interact with remote machines and devices
• Enhancements to the legacy application by modifying Macros in Excel and MS Access (VBA programming)
• Maintenance and Enhancements to the existing CTCFlex application (VB6 platform) for supporting all the above said tools
• Acted as offshore coordinator supervising a team of 3 people for getting the project done in time
• Tested software manually on desktop and critical tasks on the tool itself by running the tool
• Version maintenance of various versions of the application using VSS
• Used Test Track Pro to track the bugs found by the users and used to fix them
• Used Win Merge for comparing and merging the field changes to the code into the main application
• Used IPlotX for plotting graph for running process.
• Managed Offshore team in explaining the requirements, assigning the task, solving their doubts, code reviewing, testing their work in local system etc..

Environment: VB6.0, Windows XP, VSS, Test Track Pro, MS Access 2000, Snag It, IPlotX

Confidential, Wilmington, DE

Programmer Analyst

Responsibilities:

• Created new database tables for new enhancements to the application in Oracle 10g Designed web pages using ASP.Net 2.0 and programmed using C#.Net 2.0
• Involved in requirements gathering from the users of the application and updated the requirement specification document
• Maintaining the Card Services Applications by resolving TD (Test Directory) issues
• Assisting Production Support issues and resolving the Peregrine tickets and updating Live Link Documents (ASG (Application Support Guide) documents and Password change documents)
• Developed new Crystal Reports8.0 and enhancements to the existing reports
• Created new and modifications to the existing Oracle packages, PL/SQL Procedures, triggers and views
• Managed Version control software (Harvest) for maintaining various versions of the project
• Involved in UAT and software integration testing
• Used Test Director to track the bugs faced by the testing team and used to fix them
• Implemented AJAX functionality through JavaScript and web services
• Worked with master pages and user controls
• Applied CSS styles for web page design
• Handled code deployment by preparing deployment documents and package
• Developed application following MVC (Model View Controller) pattern
• Used XML document for data transfer between MAC application and TSYS

Environment: C#.Net2.0, ASP. Net2.0, Oracle10g PL/SQL, Windows 2000, Crystal Reports 8.0, XML, Harvest, CSS, Test Director, Peregrine

Confidential, Irving, TX

Programmer Analyst

Responsibilities:

• Involved in front end coding using C#.Net2.0 and ASP.Net and did client side scripting in JavaScript and server side scripting in VBScript Used Object Oriented Design and patterns to design the Object Model for the System
• Coordinated with the offshore team in developing the application
• Created Stored Procedures and triggers to perform automated rules, updating to related tables in SQL Server
• Developed COM components using Visual Basic6.0, and designed web pages using ASP.Net2.0, C#.Net2.0
• Used Visual Source Safe for version controlling
• Used Test Director 8.0 for writing Test Cases and involved in Unit Testing and Integration Testing
• Used Threading concept for multiple property processes simultaneously for faster execution
• Responsible for end user supporting and bug fixing
• Developed and deployed reports using SSRS (SQL Server Reporting Services)
• Developed user interface screens using repeater, data grid, grid view, user controls and validation controls
• Fetched data from Informix to display it in legacy front - end application
• Interacted closely with business analysts to define the requirements of several modules and used Object Oriented Analysis and Design principles to design the system

Environment: VB6.0, C#.Net2.0, ASP.Net2.0, SQL Server2000, SSRS, ADO.Net, Informix, Windows 2000, Visual Studio 2005, Visual Source Safe, IIS, Test Director 8.0

Confidential

Sr. Developer

Responsibilities:

• Designed and developed the GUI interfaces using VB 6.0 and wrote code for the aboveFunctionalities
• Created ActiveX Components required for the project using Visual Basic 6.0
• Designed product coding standards and developed the Client/Server Application using VB 6.0, SQL Server 2000
• Generated the company historical database reports using Crystal Reports 8
• Developed COM components for handling multi databases connections and data retrieval using VB 6.0
• Migrated the application from VB6.0 TO VB.Net 2.0. Developed Win Forms using VB.Net
• Maintained legacy database using MS Access 2000
• Took individual charge to design and develop software for the above requirements in Teller module.
• Used barcode reader device to read barcodes on checks to get check details and also compared scanned signatures with existing signature in the data base
• Designed and created tables using SQL Server 2000 and wrote T - Sql Stored Procedures and Triggers for the database interaction through the application.
• Designed and developed offline transaction module
• Used XML, XSLT for data transfer from one application to the other application
• Used DTS Package to Import/Export data between Excel and SQL Server
• Mentored junior developers and performed code reviews
• Maintained VSS version control management tool for maintaining various versions of the application
• As a Team Lead, gathered requirements from the management and transferred the knowledge to the team and took responsibility to complete the work in estimated time and did code review, unit testing, integration testing before moving the code to the next environment

Environment: VB 6.0, VB.Net 2.0, Win Forms, SQL Server 2000, MS Access, ADO, Crystal Report, T-SQL, XML, XSLT, ERWIN, VSS

Confidential, Scotch Plains, NJ

Programmer/Analyst

Responsibilities:

• Designed, developed and tested Fraud Reports and Operational Reports in ASP Designed database of RAP and developed the component Rapstore to store the Rap file information into the database.
• Designed the screens in ASP and programmed in VB6.0
• Created an ActiveX EXE for developing Fraud reports EAR, HUR and HUS and mailing them to the corresponding destinations
• Used Crystal Reports8 to develop the organizational reports that are used to estimate the revenue incurred through this application.
• Used HTML pages in designing the web pages and VBScript for server side validations
• Involved in development and maintenance of the project and reports developed in ASP and Crystal Reports connecting to SQL Server database using VB DLLs and ODBC drivers
• Draw the process flow diagram using Visio. Developed TAPStore and Charge - Recalculator components for XOR module and developed and tested the module
• Maintained various versions of the project using VSS
• Active member throughout the SDLC (Software Development Life Cycle)
• Involved in Functional and Technical documentation

Environment: Windows 2000, VB6.0, ASP, IIS, HTML, VBScript, SQL Server 2000, Crystal

Confidential

Programmer/Analyst

Responsibilities:

• Involved in Gathering, Analyzing and Documenting user requirements Provided technical lead to the team
• Designed application in Visual Basic 6.0
• Involved in coding and testing of inventory and invoice modules
• Involved in preparation of User manual and involved in end user .
• Involved in Unit Testing, Integration Testing of the modules
• Coordination and implementation of changes due to User Testing of the software
• Written macros in Excel to export data from Excel data sheet to MS Access (VBA Programming)
• Provided management team with various reports and presentations developed with MS Office Applications
• Participated in several UAT (testing), migration and production releases for the software updates and version upgrades

Environment: Visual Basic 6.0, MS Access7, VBA, Excel and Windows 98

Confidential, Wayne, PA

Programmer/Analyst

Responsibilities:

• Analyzed and documented user requirements from the clients Developed database model for application by using Vision Enterprise Architect
• Developed stored procedures using SQL Server 6.5
• Used Visual Inter Dev for developing ASP pages
• Involved in Coding for Applicant Details Screen, Search Screens for Applicant and full search for Applicant using Active Server page, Java Script and VB Script
• Written COM Components in Visual Basic 5.0
• Designed several reports using Seagate Crystal Report 6.5
• Provided full end user support by implementing daily requests and managing request tracking system
• Transferred business and proprietary system application knowledge to new developers joining the team
• Participated in several UAT (testing), migration and production releases for software upgrades and version upgrades

Environment: Visual Basic 5.0, MS Access 7, SQL Server 6.5, Seagate Crystal Report 6.5Visual Inter Dev, Active Server Pages, Java Script, VB Script