Experience Summary

• *+ years of experience in systems Analysis, design and development of complex software systems in

Finance, Health, Manufacturing sectors.

• Experienced in requirement analysis, coding and testing various modules in a software development life

cycle.

• Excellent team player and proven track record working in various team sizes performing cross functional

roles.

• Worked as Team lead, and led a team in many assignments and successfully implemented the project.

• 6+ years of experience in Design, Development, and Enhancement and Maintaining applications in

Oracle 8i/9i/10g using SQL, PL/SQL in Windows 9x/NT/2000/XP and UNIX environments.

• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and

Functions. Strong knowledge in Oracle cursor management and exception handling.

• Developed Client Server applications using front end tools like Oracle Developer 2000 Forms 6i,

Oracle Reports /6i, Jdeveloper 10g.

• Involved in designing numerous Oracle Forms and Reports by interacting directly with End Users and

Business Analyst.

• Worked as a key member for the Capability Maturity Model 5 i.

Technical Summary

Software / Tools

Oracle Forms 6i/9i, reports 6i/9i, Jdeveloper 10g,IBM RAD 7.0, IBM Rational Clear Case, Visual

Source Safe, Toad, SQL Plus Editor, Oracle Fusion Middleware

Database

Oracle 10g, Oracle 8i/9i, Oracle 11g

Operating System

Window XP Professional, Windows 2000/NT

Server Administration

Oracle Internet Application Server, Windows NT/2000 server

Functional Areas

3 Child Support Domain Experience with Federal System requirements

4 State Budgeting Systems

5 Manufacturing Systems

Education

Master’s degree in Computer Applications from University of Madras, 2000

Professional Certifications

Oracle 11g Certified Associate DBA.

Engagement Overview

Project: The State of Maine Child Support Conversion Project July 2009 – Present

State of Maine, USA

Role: Senior Developer ( Team Lead)

The project involves in migrating the entire OCSE management and operations systems from mainframe to

client server architecture using Oracle, D2K and PLSQL. The project includes several subsystems and I am

involved in Customer Review, Case Inititation, Establishment, Enforcement Subsystems Information

Development.

The primary functions of these subsystem are creating cases throught the Customer Service and entering the

Data in to the system through Case Initiation and the process goes throught he various subsytems like

Enforcement and Establishment. Also the process involve sending notices to the person involved in the case.

The notice is developed in the Reports 10 g and the user is allowed to fill the notice. After the required

information is filled, the notice data is saved into respective database tables. And the report of the notice is

generated using RDF (output formats like PDF,IMAGE,EXCEL). The entire project is developed under the

Application Server Architecture and is web enabled.

Project Environment: Oracle 10g Database, Oracle Forms 10g, Reports 10g, Oracle Internet

Application Server 10g, Toad for SQL processes.

Responsibilities:

• Involved in analyzing the existing mainframe code for conversion and prepared document on

the existing system.

• Created templates documents and project development components.

• Involved in Creating Common PL/SQL Packages and Procedures for the Project.

• Involved in Documentation of Screen Specifications.

• Involved in creating standard objects for the project with Forms and PL/SQL.

• Involved in creating standard PL/SQL package templates for the Design.

• Creating PL/SQL Database Triggers for the Application.

• Designed and Developed screens.

• Involved in testing all the Screens Developed.

Project: NJKiDS State of New Jersey June 2006 – July 2009

Protech Solutions, Inc.

Role: Team Lead

• The Project is used by the Office of the Child Support Enforcement (OCSE), State of New Jersey, USA.

The NJKiDS System project is a result of the State being under a mandate by the United States

Department of Health and Human Services to have an integrated and operationally certified automated

child support enforcement system.

•

The project involves in migrating the entire OCSE Management and Operations systems from Mainframe

to Java Technology. The Project includes several subsystems like Case Management Subsystems

Information, Financial Subsystems Information, Scheduling, Enforcement, Locate, Interface and

Interstate.

Project Environment: Java, IBM RAD 7.0, IBM Clear Case, SQL Plus, Toad, SQL Developer, MS

Office 2000, Oracle JDeveloper 10G, Oracle Database 10g and Windows 2000/ Windows XP Professional

Responsibilities:

• Leading the BCM module team of six UI Programmers and two batch programmers.

• Writing Technical Specifications based on the draft requirements from Joint Application

Design Sessions.

• Writing DSD’s for the Online and Batch Programs based on the Use Cases.

• Writing Test Scripts for the Screens and Batch Programs.

• Involved in writing Oracle PL/SQL Stored Procedures and Oracle Packages.

• Performed tuning for the complex queries in PL/SQL

• Involved in creating PL/SQL common packages used across the application.

• Writing the PL/SQL Batch Programs.

• Involved in Performance tuning of complex queries.

• Testing the Input and Output Files from and to the other Agencies.

• XML Notice Generation for the NJKiDS application through PL/SQL Packages.

• Module lead for the Bank and Cash Management System.

Project: The State of Massachusetts Child Support System Mar 2005 – May 2006

State of Massachusetts, USA

Role: Module Lead

The project involves in migrating the entire OCSE management and operations systems from mainframe to

client server architecture using Oracle 9i and PLSQL. The project includes several subsystems and I am

involved in Financial Management Subsystems Information Development.

The primary functions of this subsystem are sending notices to the person involved in the case. The notice is

developed in the forms 9i / Reports 9i and the user is allowed to fill the notice. After the required

information is filled, the notice data is saved into respective database tables. And the report of the notice is

generated using RDF. The entire project was developed under the Client Server Architecture and is web

enabled

Project Environment: Oracle 9i, Oracle Forms 9i, Reports 9i, Oracle Internet Application Server

Responsibilities:

• Writing Technical Specifications based on the draft requirements from Joint Application

Design Sessions.

• Writing DSD’s for the Online and Batch Programs based on the Use Cases.

• Writing Test Scripts for the Screens and Batch Programs.

• Framed the Coding Standard Scripts used across the Application.

• Creating Tables Structures, Synonyms and Indexes.

• Involved in Creating PL/SQL Packages and Procedures for the Project.

• Involved in Documentation of Screen Specifications.

• Involved in creating Forms standard objects and PL/SQL Objects for the project.

• Performed tuning for the complex queries in PL/SQL

• Involved in creating standard PL/SQL Package templates for the Design.

• Designed and Developed screens.

• Writing Data Clean up procedures with PL/SQL.

• Fixing and Executing the Batch Programs. (On Call)

Project: Performance Budgeting and Accountability System Oct 2004 – March 2005

Protech Solutions, Inc.

Role: Team Cordinator

This is an online Budgeting and costing solution aimed at integrating various state agencies in the state of

Arkansas to better utilize costing and budgeting information published by the SBA, AR. Involved in the

activities include Architecture Piloting, Functional prototyping and Domain Understanding.

Project Environment: VB.NET, Web Services, .NET Framework, Visual Studio .NET 2003, XML,

COM, SQL Server 2000, ADO.NET, Toad, Visual Source Safe 6.0 and Windows 2000

Responsibilities:

• Used VB.NET Win forms to provide Interface to the users

• Used Visual Studio.NET 2003 for developing applications

• Involved in the team of writing ABSCORE.DLL, which contains the core Elements of the

application as components with its own validation features.

• Data handling was done using Data Access Layer object

• Developed application with Remoting Web Methods, which interacts with various subsystems

to exchange and support data

• Used SQL Server 2000 as backend database

Project: The Indian Government Mint Jan 2004 – Oct 2004

Mumbai, India

Role: Team Lead

The project involved in automating the entire salary management and manufacturing systems in client server

architecture using Oracle, D2K and PLSQL. The project includes several subsystems and I am involved in

Salary Management Information, Costing Management and Coin Management Subsystems Development.

The primary functions of these subsystems are salary calculation for the employees of the different

employment and also the salary benefits calculation. Costing and Coin Management systems to involve the

users to enter the coin order details to be manufactured and providing the reports about the total materials

supplied from outside and also the total amount of materials utilized to make coins.. The reports are

developed in the reports 6i. And the report of the notice is generated using RDF. The entire project was

developed under the Client Server Architecture and is web enabled

Project Environment: Oracle 8i, Oracle Forms 6i, Reports 6i, Oracle Internet Application Server

Responsibilities:

• Leading the team of Six Programmers.

• Involved in Creating Common PL/SQL Packages for the Project.

• Collecting requirements from the end user.

• Involved in Documentation of Screen Specifications.

• Writing Data Clean up procedures with PL/SQL.

• Performed tuning for the complex queries in PL/SQL

• Involved in creating standard objects for the project with Forms and PL/SQL.

• Involved in creating standard PL/SQL package templates for the Design.

• Creating PL/SQL Database Triggers for the Application.

• Creating Wizard Level and Block Level Objects with Forms 6i and Reports 6i.

• Creating Materialized views for the various dimensions of reports.

• Designed and Developed screens.

• Involved in testing and integrating all the Screens Developed.

• Involved in training the end user.

Project: The State of Maine Child Support Tracking System April 2003 – Dec 2003

State of Maine, USA

Role: Developer

The project involves in migrating the entire OCSE management and operations systems from mainframe to

client server architecture using Oracle, D2K and PLSQL. The project includes several subsystems and I am

involved in Financial Management Subsystems Information Development.

The primary functions of this subsystem are sending notices to the person involved in the case. The notice is

developed in the forms 6.0 and the user is allowed to fill the notice. After the required information is filled,

the notice data is saved into respective database tables. And the report of the notice is generated using RDF.

The entire project was developed under the Client Server Architecture and is web enabled

Project Environment: Oracle 8i, Oracle Forms 6i, Reports 6i, Oracle Internet Application Server

Responsibilities:

• Involved in Creating PL/SQL Packages and Procedures for the Project.

• Involved in Documentation of Screen Specifications.

• Involved in creating standard objects for the project with Forms and PL/SQL.

• Involved in creating standard PL/SQL package templates for the Design.

• Creating PL/SQL Database Triggers for the Application.

• Designed and Developed screens.

• Involved in testing all the Screens Developed.

Project: Mailing System for IQS October 2002 – March 2003

ProtechSoft (In House Project)

Role: Software Engineer

Integrated Quality System is an In house project, which was developed for integrating all the modules like

Bug Tracking System, Time Sheet, Project Management Tool, etc., related to the ISO Process. The project

was developed as a part of Integrated Quality System. This project involves Messaging and Mail transfer

using E Mail server, which will enable easy transaction.

Project Environment: Oracle 8i, Forms 6i,Reports 6.0, Email Server and Windows NT

Responsibilities:

• Designed, Developed and Handled Forms Client.

• Created PL/SQL Packages and Procedures for the Project.

• Involved in creating standard objects for the project with Forms and PL/SQL.

• Involved in creating standard PL/SQL package templates for the Design.

• Involved in screen specific documentation.

• Involved in preparing help documents/user manuals

• Involved in providing Training to the Users.

• Involved in preparing User Manual.

Project: Arkansas Child Support Information System (ARCSIS) Aug 2001 – Sep 2002

Office of Child Support Enforcement, State of Arkansas

Role: Software Engineer

• The Project is used by the Office of the Child Support Enforcement (OCSE), State of Arkansas, USA.

The Arkansas Child support Tracking System project is a result of the State being under a mandate by the

United States Department of Health and Human Services to have an integrated and operationally certified

automated child support enforcement system.

•

• The project involves in migrating the entire OCSE Management and Operations systems from Mainframe

to Web Technology. The Project includes several subsystems like Case Management Subsystems

Information, Financial Subsystems Information, Scheduling, Enforcement, Locate, Interface and

Interstate.

•

Project Environment: ASP 3.0, COM, VSS 6.0, Java Script, XML, HTML 4.0, SQL Server 2000, IIS 5.0

and Windows 2000

Responsibilities:

• Involved in the design and development of Active Server Pages (ASP)

• Used Visual InterDev for ASP page design and development

• He was Responsible for handling JavaScript to provide proper date validations

• Suggested design changes in HTML to improve their performance (Nested tables were re

designed to avoid late rendering time)

• Supported with JavaScript to avoid multiple submission of any Server pages

• Used style sheets to provide better and unique GUI appearance

• Responsible for solving the performance issues related to the application

• Provided extensive support to intranet users, to keep the application running

• Used Data Access Layer (DAL) for Data Access

• Used SQL Server 2000 as backend database

• Developed T SQL stored procedures to support data activity

• Used Visual Source Safe for file backups and storage

Project: The Michigan Wayne County Oct 2000 – Aug 2001

Child Support Tracking System

State of Michigan, USA.

Role: Software Engineer

The project involves in migrating the entire OCSE management and operations systems from mainframe

to client server architecture using Oracle, D2K and PLSQL. The project includes several subsystems and I

was involved in Case Management Subsystems Information Notice Development.

The primary functions of this subsystem are sending notices to the person involved in the case. The notice

is developed in the forms 6.0 and the user is allowed to fill the notice. After the required information is

filled, the notice data is saved into respective database tables. And the report of the notice is generated

using RDF. Reports are generated for different activities like Income withholding (IIWO), Parenting Time

Order (PART), License Suspension (LCSP) and Tax Offset (TOFF) etc. The entire project was developed

under the Client Server Architecture and is web enabled.

Project Environment: Oracle 8i, Forms 6i, Reports 6.0 and Windows NT

Responsibilities:

• Created PL/SQL Packages and Procedures for the Project.

• Involved in Documentation of Screen Specifications.

• Designed and Developed screens.

• Involved in Notice (Reports) Development.

• Involved in Testing all the Notices and Screen Developed.

Contact this candidate