Oracle Technical
Resume:
Raphael Chinnaraja
************@*****.***
Mobile: 079-***-**-**
Professional Summary
Fifteen years of experience in Software System Design, Development, customization,
implementation, testing and support of software applications in Client–Server, Database and
enterprise software environments. Has good working experience in different domains like Sales,
Banking, Purchase, Inventory, Logistic & Transportation, Budgeting, HR, Payroll and Oracle Grants.
Experience in Re-engineering of various business applications using Oracle and competent in
Discoverer 4i, Oracle 9ias, 12i. Very good experience in SEI-CMM Level5 quality
standards.
Key areas of strengths are highlighted in the following.
Oracle General Ledger, Purchasing, HR and Payroll and Grants modules.
•
Oracle Forms 9i, Reports 9i, Workflow, Discoverer 4i and BI.
•
Oracle Applications Customisations.
•
Preparation of test cases for Unit and Integration Testing.
•
Strong Analytical skills and Domain expertise.
•
Very strong in Performance Tuning (SQL queries).
•
Good Customer Interaction and Communication.
•
Achievement:
Spirit of Mahindra Satyam Award 2009-2010
Education
Degree University Year of Passing
M.Sc (Computer Science) St.Xavier’s College, Palayamkottai 1998
B.Sc (Computer Science) St.Xavier’s College, Palayamkottai 1996
Experience
Organization Designation Duration
Satyam Computer Associate Delivery Manager (BI-2) Oct-2010 to till date
Services Ltd., Consultant (BI-1) Jul-2009 to Sep-2010
Hyderabad, India Sr. Sys Analyst ( T2) Jul-2006 to Jun-2009
Systems Analyst Oct-2003 to Jun-2006
Sr.Software Engineer July –2002 to Oct-2003
CG-VAK Software Software Engineer March – 2001 to
Exports Ltd., Coimbatore, June – 2002
India
Alphanet, Coimbatore, Software Engineer Sep – 1999 to
India Feb –2001
Hcl Info systems Ltd, On The Job Trainee Dec – 1997 to
Coimbatore India Oct – 1999
Technical Skills
PL/SQL
Languages
Oracle 7.x, 8.0, 8i,10g
Databases
ERP Oracle Applications : 11.5.9, 12.0.4
Developer 2000( Forms Version 4.5, 5.0, 6i and Reports
GUI
Version 2.5, 3.0, 6i),Developer 9i
SQL*Loader, TOAD, Discoverer 4i,Workflow,BI and Sql
Tools & Utilities
Navigator
Sales, Banking, Purchase, Inventory, Logistic &
Domain Knowledge
Transportation, Budget, HR, Payroll, Grants, Projects and
Assets
Projects Profile
Project Name : ILO IRIS RICE Development
9.
International Labour Organization, Geneva
Client
Project Manager
Role
Mahindra Satyam Computer Services Limited, India
Organization
10/2009 to till date
Duration
12 to 20 Oracle 12.0.4
Team Size
Environment Software Languages : PL/SQL
Database : Oracle 9i,10g
GUI : Developer 6i,9ias, 12ias
O/S : Windows 2000, Solaris
Tools : Discoverer 4i,Workflow,BI
Product Version: Oracle Application 12.0.4 (12i)
Hardware Intel Pentium Based Machines
Project Description
Project IRIS is live from 2005 onwards, Mahindra Satyam provides technical and
functional support to ILO in managing their ERP and fusion middleware systems.2 nd and 3rd
level support and enhancements were done by the team in onsite and offshore.
Contribution
Resource Planning, deployment and management
•
Offshore setup
•
Account mining
•
Pre sales support
•
Project Name : ILO IRIS RICE Development
8.
International Labour Organization, Geneva
Client
Project Lead
Role
Satyam Computer Services Limited, India
Organization
12/2003 to 09/2009
Duration
6 Module: Oracle Grants, GL,AP,
Team Size
Purchasing, Budget, HR And
Payroll
Project Description
Project IRIS is a personalized Enterprise Resource Planning (ERP) system, used in the
ILO's resource management activities. Most of the support functions are within the
organization-- including program planning, human resources/payroll, financial reporting,
procurement, payroll and travel will be part of this new solution. IRIS (Integrated Resource
Information Systems) which is highly used to meet the Strategic objectives of ILO. Being a
purely budget based organization, it has two bolt on applications which deals in budgeting of
various projects via SM (Strategic Management Module) PBPS (Project Budget Proposal
System), etc.
Contribution
Developed Custom Interface to import award budgets,,historical transactions,
•
current year actuals, obligation transactions and, tasks information from external source
to Oracle Grants Accounting, Utilized most of the conversion programs to import
transaction data from legacy system to IRIS.
Developed Reports using Oracle Discover 4i,Reports 9i and XML, Customized
•
workflow and forms
Preparation of Technical & Data base Design documentation for PBPS module in co-
•
ordination with the Offshore
Component Migration to various instances using Kintana Tool. (Mercury IT Governance.
•
Build all the Conversions for importing Legacy data to Oracle Grants Accounting.
•
Prepared technical design documents for RICE components
•
Project Name : GATI GEMS (GATI Enterprise
7.
Management Systems)
GATI Limited.
Client
Module Leader
Role
Satyam Computer Services Limited, India
Organization
07/2002 to 12/2003
Duration
40 Module: Hub, GL,AP,AR
Team Size
Project Description
GATI Cargo Management Services is a pioneering company in India providing Cargo
Management Services and Third Party Logistics Services with the largest network in India
and SAARC countries. The objective of this project was to provide a highly versatile
functional system and to give efficient IT supports to GATI Operations. The application was
designed for improving the efficiency in handling of operations, in the process of tracking and
monitoring the Cargo movement with accurate billing & accounting. The organization's
processes are integrated with the implementation of Oracle Financial and CRM where data
from the GATI system flows to the different modules (GL, AP, AR) of Oracle Application and
CRM through open interfaces. Oracle Financials suite is integrated to three legacy systems with
interfaces to various modules. The project involves development of OLTP reports using Oracle report
6i and OLAP reports using Discoverer 4i.
Contribution
Developing Program specifications and Unit Testing Plans for GATI.
•
Involved in analysis and design of a module that generates optimum route on cost and day
•
basis from one point to another point for different products.
Involved in designing a system of transferring data between different off-line branches
•
and uploading data from off-line branch to main database.
Involved in guiding the coding process, reviewing code & preparing and reviewing unit
•
test cases for different units.
Involved in the maintenance of form template, which is used by the total team.
•
Project Name : Banking System
6.
City Co-operative Bank in Coimbatore,
Client
India
Module Leader
Role
CG-VAK Software Exports Ltd, India
Organization
03/2001 to 06/2002
Duration
16 Module : Loans and Deposits, AP, AR, GL
Team Size
Project Description
The target segment for this software is primarily Co-operative banks, which caters to
District, City and Urban population. The subsystems in the product are Savings Account,
Current Account, Cash Credit members, Cash credit small scale Industries, Deposits Loans,
Jewel Loan, Locker, Share Member, Payroll, General Ledger, General Module and User -
Management. This is an integrated system with on-line updating of all related entries of other
relevant modules which involves the design and development of the Loan, Deposit,
Investments, and Jewel Loan modules. The deposit and loan module provides facilities for
maintaining deposit & loan details of the customers and the various transactions related to
deposits & loan. The Investment is a comprehensive unit taking care of the Investments of the
bank. Deposit Module is related to the creation of deposit groups, deposits opening deposit
closing deposit renewal and deposit extension. Different types of deposit's like fixed deposit,
recurring deposit and cash deposit are created. This module deals with the opening of new
deposits, renewal of deposits, extension of deposits and closing of deposits.
Contribution
• Analysis and design of the system.
• Reports using Reports 3.0.
• Unit testing and integration testing.
• Implementation
Project Name : Stock Maintenance System
5.
P. Mallaiyan & Co (BPC Dealer) Coimbatore, India
Client
Module Leader
Role
Alphanet.
Organization
05/2000 to 02/2001
Duration
15 Module: Billing, AP,AR,GL
Team Size
Project Description
A billing system is developed for a Gas station to maintain the purchase, sales and stock
accounts. The system is designed in such a way that the bills are printed online and given to
the customers. The system is designed to deliver the bills to the customers through a speedy
process. The major processes of the system are: daily stock closing, party indent maintenance,
fortnight party ledger processing, and cancellation of bills and receipts. Daily reports on
duplicate bills, cash sales, credit sales and cancellation of bills will be created by this system
for management purpose. Fortnight party ledgers enhance the vehicle-wise and bill-wise
details of the customers and a party-wise summary to the management.
Contribution
• Analysis and design of the system.
• Developing Reports using Reports 3.0.
• Unit and integration testing.
• Implementation
Project Name : Trading Management System
4.
Jeya Traders
Client
Module Leader
Role
Alphanet.
Organization
11/1999 to 04/2000
Duration
2 Module : Trading
Team Size
Project Description
This trading system is developed to maintain the purchase, sales and stock accounts of
oil dealers. This contains modules like Supplier Master, Customer Master, Item Master, Item
Receipts, Item Issues, Party Ledger, Collection Details, Intimation Letter, and Pending
Payments of customer, Purchase Orders, Quotation Chart and Stock Maintenance. An
additional feature includes the bank passbook maintenance.
Contribution
• Analysis and design of the system.
• Development
• Unit testing and integration testing.
• Implementation
Project Name : Online Textile Information System
3.
Sri Nachammai Cotton Mills Ltd, Salem, India
Client
Module Leader
Role
Hcl Info systems Ltd
Organization
01/1999 to 10/1999
Duration
10 Module : Inventory
Team Size
Project Description
Online Textile Information System, which takes deals with the day to-day activities of
a textile mill. It consists of purchase module, which includes vendor master, purchase
requisition, quotation matching, purchase order and bill passing against the purchase order.
The system automatically closes the purchase order. Sales module deals with the stock of
finished goods that are ready for sale and maintains the customer master also. Inventory
system has a link with the purchase for purchase order closing. Material receipts, material
issues and material returns are the major transactions in this system. The inventory module
maintains the material master. The secretarial system consists of share management activities
like share issues, share merging, share splitting and the shareholder master. The production
management system is used to keep track of the production process. This consists of cone
winding. Personnel Information System contains the Employee Master, Payroll Processing,
Bonus Processing, and Leave records of the employees. Financial Information System takes
care of the payments, receipts, trial balance, trading accounts, profit and loss accounts and
Balance Sheets. The Management Information system is the collection of important reports
from systems like quotation matching, trading accounts, balance sheet, and profit and loss
statement.
Contribution
• Analysis and design of the system.
• Development
• Unit testing and integration testing.
• Implementation
Project Name : RSCL_DEV
2.
Rajshree Sugars and Chemicals Ltd, Coimbatore, India
Client
Module Leader
Role
Hcl Info systems Ltd
Organization
04/1998 to 12/1998
Duration
26 Module : Stores Accounting
Team Size
Project Description
Inventory module deals with purchase requisition (Local & Head Offices), goods
inward cum inspection report, cash purchase, material wise issues to and from departments,
and analysis with the stock ledger processing. The module also handles the Item Master and
has a close link with the Purchase Module for Purchase Order and Head Office Purchase
Requisition. For local purchases the bill clearance is used to pass the cash purchases
information to the financial accounting system. Returnable gate pass and non returnable gate
pass are additional features of the system.
Contribution
Analysis and design of the system.
•
Development
•
Unit testing and integration testing.
•
Implementation
•
Project Name : RSCL_DEV
1.
Rajshree Sugars and Chemicals Ltd, Coimbatore, India
Client
Team Member
Role
Hcl Info systems Ltd
Organization
12/1997 to 03/1998
Duration
26 Module : Purchase Accounting System
Team Size
Project Description
This application is basically a Purchase Accounting System, consisting of quotations,
requests/receiving, and comparison of quotations, raising and cancellation of Purchase orders.
This system is having interaction with Stores Accounting System for Purchase Requisition
and Material Inward Note. This system passes the notification for bill clearance to the
Finance Accounting System. This module will take care of the Supplier Master.
Contribution
• Development and testing of the system
• Implementation of the system
Personal Details
Name Raphael Chinnaraja
Email Id ************@*****.***
Type of Visa holding B Permit From 12/2005 on words Valid Up to : 31/01/2014
L Permit From 12/2003 to 12/2005
(Switzerland)
Location Geneva, Switzerland
Languages English, Tamil
Contact Numbers : 004*-***-**-**-**
Contact this candidate