EDUCATION:

B.E.,(Computer Science & Engineering), Madras University, April ‘94.

CAREER PROFILE :

• Over Sixteen years of programming experience in project management with consistently increasing responsibilities in software Development, Analyzing, Designing, Testing ,Support and implementation.

• Have strong expertise in ORACLE 7.x,8.0,8i,10g FORMS 6/4.5/3.0, REPORTS 6/2.5, PL/SQL, SQLPLUS, PRO *C, SOA,BPEL including 2½ years of Experience in implementing full life cycle Oracle Applications in multi org environment in modules Accounts Receivables, Accounts Payables and General Ledger, Alerts, Workflow and AOL in Rel 11.03/11i. I have a sound knowledge in ORACLE Databases in creating packages, procedures and functions for Oracle Application Interfaces and conversions.

• Experience in Designing and Developing commercial business applications.

• Experience in Designing and Developing applications in a manufacturing and materials management environment.

• Enthusiastic, committed, self-starter and resourceful.

• Versatile team player with good communication and interpersonal skills.

EMPLOYMENT DETAILS:

From Nov 98 – Till Date : Syntel Inc., USA., Project Lead (Client:- First Data Merchant Services, Maryland, USA).

From Oct 97 – Nov 98 : Mastech System Corporation, United Kingdom

From Dec 96 – Oct 97 : Silverline Industries, Chennai, India.

From Jun 96 – Nov 96 : HMT Industries Ltd, Bangalore, India.

From Aug 94 – May 96 : Expo Systems, Chennai, India .

TECHNICAL ENVIRONMENT:

Hardware :IBM PC Compatibles, HP 9000/800 Series,HP UX 11.0(N Class,K Class,D Class Series), SUN

SOLARIS

Operating Systems :UNIX,WINDOWS 3.11, 95, 98, NOVELL NETWARE, WINDOWS NT

Languages :C,C++, COBOL.

Database :ORACLE 7.x,8.0,8i,10g

GUI :SDK, VISUAL C++, DEVELOPER 2000(FORMS 6/4.5/3.0&REPORTS 6/2.5).

Tools :PRO *C 2.2, SQLPLUS 3.3,PL/SQL 2.3,SQLFORMS 3.0,SOA,BPEL.

ERP :Oracle Financials Ver11.03, Ver 11i

MAJOR ASSIGNMENTS:

Project : Integrated Suspense System and Funding System

Role : Project Lead

Client : First Data Merchant Systems, USA.

Description : First data uses the submitted details to carry out the transactions with the associated. The

transactions are stored. FDMS acts as a gateway for the transactions that come from merchants and

as well as banks. Submission could be classified as paperless transaction, paper transaction and

key automated data entry. Main thing involved are Paperless Transaction System, Funding,

Interchange, Chargeback , Automated Clearance Housing (ACH). Various card types are handled in

this process, major cards involved are Master Card,Visa, Amex, Wex, Exxon, BP. Here main thing

would be to load the data which comes from merchant in flatfile to mainframe, mainframe transmits

the file to unix server (connect direct/Network Data Mover(NDM) is the medium used for

transmittiing) . Data gets loaded through sql loader scripts. Users then gets to verify the information

and work them out, then there are various automated oracle jobs which runs at certain time,

produces flat file and sent them to Mainframe. Then it goes to various areas like bank and other

processing areas. Technical environment for this project is Oracle, SQL, PLSQL,KSH,Cron

Tab,Toad, Unix,Java, Mainframe,VB

Period : Apr 2003 – Till date

Environment : ORACLE 8i,10g, Unix

Responsibilities : Production Support and Development team lead.

Involved in developing new applications.

Tracking issues and fixing them.

Customization of backend PL/SQL routines on the server to develop stored procedures, functions,

packages , views and triggers to meet customer requirement.

Developed Oracle PL/SQL tored Procedures,Functions,Packages, SQL scripts to facilitate the

functionality for existing module.

Developed Oracle PL/SQL packages and procedures for loading data coming in flat file from

mainframe, and other sources and run them as a stream.

Developed backend Oracle PL/SQL procedures, functions for processing the information that was

being called from front end application like visual basic, java.

Developed Oracle PL/SQL procedure,function,package to produce flat file and sent them to mainframe.

Developed Oracle PL/SQL procedure,function,package to handle all the complex processing that is

called from front end like Splitting,resolving etc.

Implemented complex SQL queries on the database along with stored procedures, triggers and

PL/SQL code blocks.

Developed applications with PL/SQL, Database design and data modeling using TOAD

Wrote SQL queries to access data from Oracle database.

Wrote Unix Shell scripts to accept flat file and load them to database through sqlloader.

Wrote Unix Shell scripts to call SQL script and manipulate the data coming in the flat file.

Wrote Control files to load the data through sqlloader.

Developed many Unix KSH scripts for batch scheduling.

Scheduled the cronjobs to trigger batch schedules automatically.

Wrote Connect Direct/NDM shell script to sent the file to Mainframe from unix server.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking.

Did Unit testing , System testing, Integration testing.

Involved in time estimation and impact analysis preparation

Involved in designing of various critical data flow diagrams required for the project

Working on Redesigning a SYSTEM using eResXpress.

Using SOA designed and developed Business Rules Engine to execute and integrated with web

application.

Wrote and run test cases and modules for load testing scenarios.

Provided technical decision support for the system and business analysts.

Project : Value link System

Role : Project Lead

Client : First Data Merchant Systems, USA.

Description : Solution providing all processing required to support stored value cards. Value link enables clients to

efficiently implement their own customized electronic payment and promotion programs using stored

value cards. Stored value allows cash or other information of value to be placed and stored on a

centralized database. This value can be quickly and accurately accessed using a plastic magnetic

strip card via a common POS terminal. It can be used in place of paper based products such as

cash, gift certificates, merchandise credits, and loyalty cards. Typically, merchants are only required

to add some minimal programming changes to their retail POS terminal software and they can begin

to accept stored value cards. By sending a transaction to valuelink, the merchants can perform

functions such as increasing the card’s balance, recording a sale, which decreases the balance of an

account, and retrieving the card’s balance. No new dedicated card reading equipment or expensive

chip cards are required. Technical environment for this project is Oracle, SQL, PLSQL,KSH,Cron

Tab,Toad, Unix,Java, Mainframe,VB

Period : Jan 2003 – Mar 2003

Environment : ORACLE 8i, Unix , C

Responsibilities : Production Support and Development team lead.

Tracking issues and fixing them.

Wrote Unix scripts and C scripts.

Involved in Functonal Analysis, requirement analysis and preparation of specification documents.

Did Defect Tracking.

Did Unit testing , System testing, Integration testing.

Involved in time estimation and impact analysis preparation

Involved in performance tuning of the various times taking stored procedures and functions

Project : Freight Management Systems

Role : Programmer Analyst

Client : Kintetsu World Express, USA.

Description : There are four major core applications.

Customer Service System (CSS) - Complete pipeline visibility for all KWE customers on a global

basis via our home page on the Internet.

Unified Freight System (UFS) - Localized, unified, core applications: airfreight, ocean freight, break-

bulk and warehousing.

Unified Accounting System (UAS) - The Unified Accounting System (UAS) is a strategic global

project that will enhance the current financial and accounting reporting capabilities.

Unified Warehouse System (UWS) .

Data from all KWE and agent offices worldwide is fed into the CSS system.

CSS also provides the capability for each customer to schedule reports based on their own standard

set of criteria for Order, Warehouse, or Shipment reporting. Technical environment for this project is

Oracle, SQL, PLSQL, ORACLE Application 11i, Forms, Reports

Period : Aug 2000 – Jan 2003

Environment : ORACLE 8.0,8i, Developer 2000, Forms 6, Reports 6.

Oracle APPS 11.03/11i Modules - Account Receivable, Accounts Payables,General Ledger.

Responsibilities : Customization and enhancement of Oracle Applications for freight management systems.

Preparing detailed design document for interfaces, conversions, forms and report customizations

using Oracle AIM documents. Worked in AR, AP , GL modules

Customizing existing forms in 6/4.5 and reports in 6/2.5 to meet the client needs.

Developing Applications using Forms 6/4.5, Reports 6/2.5.

Converted forms 4.5 to 6 and Reports from 2.5 to 6. Handled Customer and Vendor Interfaces

applications.

Handled the Interface flow between the applications.

Registering Forms, Value Set, Concurrent programs,Executables in AOL.

Defining alerts as per the system requirements.

Preparing unit test plan for each interface and conversion programs.

Giving production support. Customized CUSTOM.pll for Customized forms.

Wrote Stored Procedures,Functions and Database Triggers.

Unit Testing,System Testing and Implementation of Application.

Project : AfterMarket Salesorder Management System

Role : Programmer Analyst

Client : Cummins Engine Company, USA.

Description : Aftermarket Sales Order Management System(ASOMS) is a windows driven environmet and is run

on an Oracle database. As soon as data is entered into the system, it is immediately available, on-

line to all users. Orders are entered through different modes like Web based system, Fax, Phone

etc. Orders are handled in different formats like Customer down, immediate delivery etc. ASOMS is

the heart of the Aftermarket Logistics Planning System(ALPS) and will support:

Order management

Inventory

EDI with customers

Invoicing

Core tracking with delivery partners

Purchasing – EDI with suppliers

Technical environment for this project is Oracle, SQL, PLSQL, Reports.

Period : Nov 1998 – June 2000

Environment : ORACLE 8.0, Developer 2000

Responsibilities : Wrote Stored Procedures,Functions and Database Triggers.

Developing Reports 2.5 for the entire ASOMS modules.

Prepared User and Developer Manual.

Involved in performance tuning of the various times taking stored procedures and functions.

Unit Testing,System Testing and Implementation of Application.

Project : Invoicing

Role : Programmer Analyst

Client : GE Caledonian, United Kingdom.

Description : It is aircraft engine manufacturing company. Whenever new engine comes entry is made and it is

made available to users.Technical environment for this project is Oracle, PLSQL, Forms, Reports.

Period : Oct 1998 – Nov 1998

Environment : ORACLE 7.3, Developer 2000

Responsibilities : Wrote Stored Procedures,Functions and Database Triggers.

Developed applications in Forms 4.5 Reports 2.5 for the entire invoicing module.

Prepared User and Developer Manual.

Involved in time estimation and impact analysis preparation

Involved in performance tuning of the various times taking stored procedures and functions.

Unit Testing,System Testing and Implementation of Application.

Project : Annuities Tracking System

Role : Programmer Analyst

Client : Electronic Data Systems(EDS), United Kingdom.

Description : It is billing system developed by EDS,Electronic Data Systems,UK branch for Xerox Document

company . In this system datas are read from IBM flat files and put into database. This system is

divided into 5 levels namely Entity , Common Business unit, Sales Team, Sales Territory and

Machine. Bill is prepared at all the levels . Billing is carried out in Phased and Billed modes. In case

of phased mode, bills are prepared every month. In case of Billed mode, bills are prepared

quarterly. Revenues obtained are rolled up at all levels. In billed rollup we can see the summation

of reveues for a specified period. In case of phased rollup breakup of revenues are available for

each period. Technical environment for this project is Oracle, SQL, PLSQL, Forms, Reports.

Period : Nov 1997 – Sep 1998

Environment : ORACLE,Pro *c,SQLForms 3.0,Developer 2000.

Responsibilities : Wrote Stored Procedures and Database Triggers. Development of Forms.

Upgradation to Forms 5.0 Version from Sqlforms 3.0.

Did Year 2000 remediation for existing pro*c programs. Prepared Test Plans.

Prepared User and Developer Manual.

Involved in performance tuning of the various times taking stored procedures and functions.

Unit Testing,System Testing and Implementation of Application.

Project : Invoice System and Inventory System

Role : Programmer Analyst

Client : Bahrain Telecom Communication, Bahrain.

Description : Invoice System and Inventory system is an integrated billing and customer administration system

designed to enable telephony service provider to efficiently manage this billing and administrative

tasks. It supports totally 28 services of Telecom industry which includes Mobile,Pager,Cellular,Voice

Mail Conferencing etc. System providing facility to apply different tariffs for different network operator,

will take care ICA(Inter Carrier Accounting), produce TAP in tape format,providing accounting

interface, keeping tack of Customer payments using Collection actions etc. User can setup deposit

as well as Price plan for different product and sevices etc. Technical environment for this project is

Oracle, SQL, PLSQL, Forms, Reports.

Period : Dec 1996 – Oct 1997

Environment : ORACLE 7.3, Developer 2000.

Responsibilities : Study and design the system

Developed Customer Care and Account Number creation modules in Forms 4.5,Reports 2.5.

Wrote Stored Procedures and Database Triggers.

Prepared User and Developer Manual.

Involved in performance tuning of the various times taking stored procedures and functions.

Unit Testing and System Testing.

Project : Purchase Order System

Role : Programmer

Client : HMT, Bangalore.

Description : Purchase Order System is one of the major module of VIKAS which is an MRP II package. It

maintains information about suppliers,part supplied by them, about Requistion, Tenders, Quotation,

Proposal, Sanction, Purchase Order, Material inwards. It generates vendor rating based on user

supplied criteria, provides comparative statement. It generates Proposals, Purchase Orders and

Material Inwards Slip. It maintains receipt of Material Inspection of Material and Receipt of stores.

Technical environment for this project is Oracle.

Period : Jun 1996 – Nov 1996

Environment : ORACLE 7.3, Developer 2000.

Responsibilities : Developed modules using Forms 4.5, Reports 2.5, pro*c programs.

Wrote Stored Procedures and Database Triggers.

Prepared User and Developer Manual.

Involved in performance tuning of the various times taking stored procedures and functions.

Unit Testing, System Testing and Implementation of application.

Project : Sales Processing

Role : Programmer

Client : Expo System, Chennai.

Description : Sales Processing module was developed to organise the Sales Processing. This system provides

effective information for making the sales process smoother and easier. The sales processing

system maintains the average cost of the Acrylic Fibre in the market and the rate at which it is being

sold to different customers. The different activities that take place during the sales like order

registration, invoicing, delivery conditions, payments, mode of transport and other formalities are also

in the preview of systems. Technical environment for this project is Oracle

Period : Feb 1996 – May 1996

Environment : ORACLE 7.3, Developer 2000.

Responsibilities : Developed modules in Forms 4.5, Reports 2.5.

Wrote Stored Procedures and Database Triggers.

Involved in performance tuning of the various times taking stored procedures and functions.

Unit Testing, System Testing and Implementation of application.

Project : Attendance Recording system

Role : Programmer

Client : Expo System, Chennai.

Description : Developed a system to record the attendance of employees and use it for getting various information

like sales incentivies various leaves availed by employees, scheduled shifts of employees, shift

changes, it helps time office, provides personnel department with upto-date information about

employees attendance and provides the pay roll system with the details. Technical environment for

this project is Oracle.

Period : Aug 1995 – Dec 1995

Environment : ORACLE 7.3, Developer 2000.

Responsibilities : Developed modules in Forms 4.5, Reports 2.5.

Wrote Stored Procedures and Database Triggers.

Involved in performance tuning of the various times taking stored procedures and functions.

Unit Testing, System Testing and Implementation of application.

Project : Front Office Managements System

Role : Programmer

Client : Expo System, Chennai.

Description : This is a sytem developed for quick access to any information in the office. This provides information

regarding various products, customers, vendors, products supplied by vendors, products bought by

customers, whether wholesale or retail customers, their payment details, employees, mode of

transport of delivery persons. Technical environment for this project is Oracle.

Period : Feb 1995 – Jun 1995

Environment : ORACLE 7.3,Forms 3.0, Pro *c..

Responsibilities : Developed modules in SQLForms 3.0,pro*c programs.

Wrote Stored Procedures and Database Triggers.

Involved in performance tuning of the various times taking stored procedures and functions.

Unit Testing, System Testing and Implementation of application.

Project : Civil Supplies

Role : Programmer

Client : Expo System, Chennai.

Description : This project contains all details needed for running Civil Supplies Invoice System. This project

maintains the Master Entry,Transaction Entry and Reports. Master entry contains addition addding

new customer certain products allocated to him. Modification modifyting certain details. Deletion

deleting a customer. Transaction Entry maintains the list of products he purchased. Reports

maintains the detail Customer - Wise Reports daily and monthly, Product - Wise Report daily and

monthly. Technical environment for this project is Oracle.

Period : Feb 1995 – Jun 1995

Environment : ORACLE 7.3, Forms 3.0, Pro *c..

Responsibilities : Developed modules in SQLForms 3.0, pro*c programs.

Wrote Stored Procedures and Database Triggers.

Unit Testing, System Testing and Implementation of application.

Contact this candidate