SUMMARY:

• Over Ten (11) years of IT experience in Application & Web - based software development.
• Extensive experience in Microsoft Technologies including VB.Net, VB 6.0, ASP, SQL, PL/SQL, JavaScript, VBScript, HTML, Oracle 8x/9x/10g/11, MS- SQL Server 6.0/7.0/2000/2005/2008, Serena PVCS Version Manager 8.0, MS Access, Crystal Reports 6.0/7.0, Data Reports 5.0/6.0, Front page 2000, Win Runner 6.0/7.0, Test Director 6.0/7.6, TIDAL.
• Strong working experience in Design, Development and Programming using SQL, PL/SQL, Crystal reports, Data Reports, SQL Server and MS Access.
• Experience in writing Stored Procedures, Functions, Database Triggers and Packages using PL/SQL
• Extensively worked as a product support engineer in analyzing and resolving the customer issues.
• Involved in developing, coding and all the way to testing and implementation and can handle responsibilities independently as well as a proactive team member.
• Technical expertise in all phases of the SDLC including requirement analysis, design, development and implementation at client location.
• Strong Management Interpersonal & Communication Skills Ability to work unsupervised and communicates with people at variety of levels, analytical, administration, programming, system testing, research and problem solving skills.
• Focused on discovering and addressing the needs of customers and internal partners.
• Capability to learn fast and assume any responsibilities.
• Significant contributions to projects covering Banking & Financial systems & Treasury management Systems.
• Developing, implementing of the module & providing all kinds of support for business application software for clients.
• Expertise in developing WEB pages using HTML, ASP, VB Script, Java Script, Application software with Visual Basic and the controls like ADO, Record set, Data List and other various controls.
• Involving in Solution Design Phase for the clients’ requirements.
• Client interaction for requirement gathering, Case / system / Process Study
• Configure Tidal jobs, setup jobs, execute jobs, create calendar for jobs
• Participate in implementation of the modules developed.
• Perform in depth analyses to identify problems.
• Analyze business processes by breaking them down into their component parts.
• Recommend and implement process improvements.
• Help in resolving problems or developing cross-functional solutions.
• Identify patterns, trends and opportunities related to Software Development.
• Help in critical phase to the development team.
• Sets challenging goals and strives to surpass prior levels of achievement.
• Interpersonal and Influencing Skills/Relationship Building:
• Build and maintained a network of contacts relevant to one’s work.
• Sought more efficient and effective methods to improve performance.
• Willing to learn from others and is open to others’ opinions (even when different from one’s own).Genuinely values others input and expertise.
• Make verbal and written presentations slides that are clear and concise.

TECHNICAL SKILLS

Operating System: Windows 7/XP, DOS, and UNIX.

Programming Language: VB.Net, C, Visual Basic 6.0, Java

DBMS: FoxPro, Ms-Access

RDBMS: Oracle 8x/9x/10/11, Ms- SQL Server 2000/2005/2008

​Testing Tools: Win Runner 6.0/7.0, Test Director 6.0/7.6 and Load Runner 6.0

Scripting Language: VB Script, Java Script, HTML, ASP, FrontPage 2000, Crystal Report 6.0/7.0, Data Report 5.0/6.0, Serena PVCS Version Manager Version 8.3.0.0

PROFESSIONAL EXPERIENCE

Confidential, NYC

Senior Programmer/Technical Analyst

Responsibilities:

• Co-ordinate with BI team on Business Requirements, prepare Functional requirement document with Technical specification.
• Prepare Analysis document for enhancement to the existing system and new system with Impact to the other application.
• Develop the enhancement screens & Coding in VB.Net/Visual Basic
• Create test scripts and test scenarios for QA team to test.
• Write SQL Statements, Views and Stored Procedures in SQL Server for new system/enhancements.
• Extensive use of UDF, Objects, Modules, Procedure in VB.Net/Visual Basic.
• Setup new JDA Arthur plans with views, elements, components, variables.
• Generate executable for deployment in development, QA, UAT and Production.
• Version control using VSS/TFS for creating builds and releases.
• Analyse/ Co-ordinate with the user on any issues, solve production issues on day to day basis.
• Configure/Install CPS, Arthur and other tools on the user’s machine and train the user on use of the application.
• Monitor the Windows Scheduler/ Tidal jobs and create a report on the weekly basis.
• Worked with other integration team to ensure that the development/production issues are resolved.
• Coordinate with Migration team with the Business rules/New enhancement to the existing system.
• Create Interface between the parent application and child application through Interop.
• Build new DLL and executable for the existing project.

Environments: Windows XP, VB.Net, Tidal, Visual Basic 6.0, VBA, MS-office 2010, SQL Server 2005, Oracle Essbase client 11, VSS

Confidential, NJ

Senior Programmer/Analyst

Responsibilities:

• Analysis the System Requirements, Detail Design, Design Reviews and code review
• Development of screens & Coding in VB.Net/Visual Basic
• Developed standard Reports using Crystal Report, Excel Spreadsheets, VBA for displaying the Data.
• Developing SQL Statements, Views and Stored Procedures in SQL Server.
• Extensive use of UDF, Objects, Modules, Procedure in VB.Net/Visual Basic.
• According to the test scenario developed test frames, create the test scripts
• Version control using PVCS for creating builds and releases.
• Worked with testing, Billing, CRM team to ensure that the development/production issues are resolved.
• Coordinate with Migration team with the Business rules/New enhancement to the existing system.
• Re-write the existing code with Visual Studio version selector.
• Create Interface between the parent application and child application through Interop.
• Create new DLL and executables for the existing project.

Environments: Windows 2000, Visual Basic 6.0, VBA, MS- Excel, SQL Server 2000, Oracle, PVCS 6.0

Confidential, IL

Senior Programmer

Responsibilities:

• Analysis the System Requirements, Design and coding.
• Develop & Code forms in Visual Basic and ASP
• Used ADO objects like ADODB Connection, Command and Record set for database connectivity.
• Developed standard Reports using Crystal Report, Word Document, ASP for displaying the Data.
• Developing SQL Statements, Views and Stored Procedures.
• Extensive use of UDF, Objects, Modules, Procedure in Visual Basic and ASP Pages
• Worked interactively with the internal staff and with end users to find solutions to any issues that occurred.
• Worked with testing team to ensure that the development issues are resolved.

Environments: Windows XP, Visual Basic 6.0, ASP 3.0, HTML, Java Script, VB Script, SQL - Server

Confidential, CT

Software Programmer

Responsibilities:

• Analysis the System Requirements, Design and coding.
• Design & Coding the Web-pages using ASP, HTML, Java script.
• Develop & Code forms in Visual Basic
• Used ADO objects like ADODB Connection, Command and Record set for database connectivity.
• Developed standard Reports using Crystal Report, Word Document, ASP for displaying the Data.
• Developing SQL Statements, Views and Stored Procedures.
• Extensive use of MS- Excel, MS- Word for developing reports.
• Extensive use of UDF, Objects, Modules, Procedure in Visual Basic and ASP Pages
• Generate letters/reports for the clients through VBA in Ms-Office.
• Reporting the Bugs using Test Director.
• According to the test scenario developed test frames, create the test scripts
• Tested the loading times of images and suggested some modifications to the development for fast loading of the pages.
• Worked with testing team to ensure that the development issues are resolved.

Environments: Windows XP, Visual Basic, ASP, HTML, VBA, MS- Excel, Java Script, VB Script, SQL - Server

Confidential, JPMC, NY

Software Programmer

Responsibilities:

• Analysis the system requirements, Design and coding.
• Designing and developing the Web-pages using ASP, HTML, Front page, Java script.
• Extensively used ADO objects like ADODB Connection, Command and Record set.
• Developed standard Reports using HTML, Java Script, ASP for displaying the Data.
• Developing SQL Statements and Stored Procedures.
• Developing reports using MS-Excel, Ms- Word.
• Involved in developing policies and procedures to ensure web site release integrity.
• Reporting the Bugs using Test Director.
• According to the test scenario developed test frames, created the automated test scripts using Test Director.
• Coded error handlers for smooth execution of test procedures to eliminate unexpected aborting Modularized the test cases by creating Generic Functions that deal with different sets of data.
• Tested the loading times of images and suggested some modifications to the development for fast loading of the pages.
• Worked with testing team to ensure that the development issues are resolved.

Environments: Windows 2000, ASP, Front Page, MS- Excel, HTML, Java Script, SQL - Server 6.0/7.0, PL/SQLInternet Explorer 5.0/6.0, Test Director 6.0

Confidential, NC

Software Programmer

Role/Responsibilities:

• Design and developments of Active Server Pages using development environment Visual Interdev 6.0 and HTML Language with scripts.
• Involved in participating analysis and coding.
• Extensively used ADO objects like ADODB Connection, Command and Record set.
• Extensively used JavaScript to validate user input values and check browser compatibilities.
• VB Script and Java Script are used to perform Server Side validations and Client side Validations.
• Developed standard Reports using HTML, Java Script, ASP for displaying the Data.
• Extensive use of Ms- Excel for developing reports.
• Identified and prioritized test cases, analyzed defects, evaluated test coverage, and generated status reports
• Extensive working in SQL, PL/SQL, SQL PLUS, Crystal Reports.
• Performed Manual Testing and Automated Testing
• Created automated test scripts for functional, regression testing using Win Runner.
• Linked requirements to test cases for Traceability in Test Director. Used Test Director as defect tracking tool
• Extensively involved to develop the Technical Documentation. Performed Unit test and system test

Environments: ASP, HTML, Front Page, Java Script, VB Script, Ms- Excel, SQL- Server 6.0, PL/SQL, Oracle, Ms-Access, PL/SQL, Test Director 6.0, Crystal Reports 7.0,Windows NT

Confidential

Software Programmer

Role/Responsibilities:

• Understand the requirement of the corporate with documentation & reports required as per the management
• To design & Development of Input Screen with the flow of data, which the input screen are, suppose to carry.
• Extensively used ADO objects like ADODB Connection, Command and Record set.
• Handling the test module with the calculations/formulas as per the banker/FEMA guidelines
• Design of billing module for the above said system and generating Summary reports, Profitability report and many more.
• Extensively used Java script to validate user input values and check browser compatibilities.
• Creating Interface to transfer data to Excel file & documents formats
• Developed User manuals and Training manuals. Implemented validations in code-behind and JavaScript.
• Design and Development of database.
• Wrote PL/SQL stored procedures, functions, Trigger to meet new features to be incorporated in the System to implements business rules.
• Back end programming using PL/SQL
• Developed standard Reports using HTML, Java Script, ASP for displaying the Data.
• VB Script and Java Script are used to perform Server Side validations and Client side Validations.
• Actively involved in testing of the software

Environments: FrontPage 2000, HTML, ASP, VB Script, Java script, Test Director 6.0,Oracle, SQL- Server, PL/SQL.

Confidential

Sales & Purchase Order

Role/Responsibilities:

• Interaction with business owners for review and update of system documents, reports and requirement & specification from development personnel prior to testing
• Involved in participating analysis and coding.
• Successfully designed and created user controls based on the business rules which are used in dis applications. Involved in complete system development life cycle and documentation.
• Development of Database Management Systems (DBMS) using MS Access.
• Extensively used ADO objects like ADODB Connection, Command and Record set. Used disconnected Record sets to reduce the time to tie up a pooled connection and increase in scalability.
• Worked extensively with server controls like Data Grid, Data Reader, Data Repeater and Data List.
• Created data verification forms and database which includes table for stock, sales and Purchase records.
• The system includes reporting 21 different heads like Purchase Order, Sales Order, Invoice, Stock, and Billing etc.
• Involved to review the site validation plan & system validation & Involved in manual testing of the application.
• Involved in developing training manuals, delivery plans and installation. Performed Functional and Regression testing using Win Runner.
• Extensive use of SQL Queries to interact with Databases
• Testing different modules and their functionality. Reporting bugs using the Test Director
• Designed Forms using Visual Basic.
• Designed crystal reports, some of the forms and coding. Trained users how to use Crystal Reports.
• Actively involved in Testing of the system

Environments: Visual Basic 6.0, MS Access 2000, Ms-excel, Win Runner 6.0, Test Director 6.0, SQL and Oracle 8i

Confidential

Software Programmer

Role/Responsibilities:

• Analysis of the above requirement of the customer and design, develop them into computerised system
• Design & Develop Input Screens employee hiring needs, screen candidates, and hire applicants quickly. To further simplify the hiring process
• Extensively used ADO objects like ADODB Connection, Command and Record set.
• Process the appointment letters for the selected candidates using. Add the require information of the employee in the database, providing them with companies ID card and registering them on the payroll.
• Generating reports for the management to track the number of employee’s working in the organisation in various departments through Crystal Reports
• Input Screens Rules for coverage, premium, and employer match computations using forms, data controls, data grid, and data list.
• Used SQL Statements and Stored Procedures.
• Well versed in Open Database Connectivity (ODBC).
• Designed Test Plan and Documentation. All levels of Testing done by Win Runner

Environments: Visual Basic 6.0, Oracle 8i, SQL, PL/ SQL Data Reports 4.0, Crystal Reports 5.0, Win Runner 5.0 and Test Runner 5.0.

Confidential:

Role/Responsibilities:

• To Design and Code of Input Screen and database. Streamlines salary planning, designation, salaries, new recruitments, selection procedures assigning new profile for the selected candidates, appraisals, increment process, retirements details.
• Extensively used ADO objects like ADODB Connection, Command and Record set. Used disconnected Record sets to reduce the time to tie up a pooled connection and increase in scalability.
• Designed and created user controls based on the Company’s policy, rules which are used in dis applications.
• Creating online attendance screen.
• Generating all the reports regarding PF, Super Annotation, Gratuity, and Attendance sheet.
• Generating reports in Crystal reports as per the requirement of the management for the module from selection procedure till the retirement process.
• Client Server application was designed and developed using VISUAL BASIC and backend as SQL SERVER and ORACLE.
• Extensively involved to develop the Technical Documentation
• Performed Unit test and system test

Environments: Visual Basic 6.0, Crystal Report 5.0, Oracle 8, SQL Server, Test Runner 5.0 and Win Runner 6.0

Confidential

Responsibilities:

• To Code Test Bench Module. dis helps in Learning and testing the skills of the user. The administrator decides the levels of test.
• Design, Code & Development the screens pages using ASP, HTML, Front page for the learning Session, Web based reports, which enables administrators to keep track on various learning sessions.
• Implemented validations in code-behind and JavaScript.
• Involved in User Testing and defect fixing.
• Developed standard Reports using HTML, Java Script, ASP for displaying the Data.
• Involved in the User Interface customization for of the training session.
• Involved in adding more functionality for the existing KB (Knowledge Base) feature and modified the category assignment functionality accordingly
• Extensively used Java script to validate user input values and check browser compatibilities.
• Designing the user manuals for the employee, dis helps them to understand the functionalities of the system.
• Involved in creating of folders and user account credentials on WIN2000 Server.
• Participated in various Bankers meetings/forums to understand the requirements and discussed the enhancement and modification request issues.
• Involved in UI & Control design, coding, debugging using Testing Tools, Manually and Implementation.
• Involved in Assembly Testing, Product Testing, User Testing and defect fixing.
• Modify database structures.

Environments: Front Page, HTML, Java script, ASP, Oracle 8, Win Runner 5.0, Test Runner 5.0