V. SARAVANAN

12, Sri ramulu street
Mathi alagan nagar
Saligramam
Madras – 600 093
INDIA

Tel: 91-44-4722178
Fax: 91-44-4835161
mailto:saravanan@vsnl.com
http://business.vsnl.com/saravanan

OBJECTIVE

To successfully continue my career as a RDBMS Application Developer / Database Designer with a progressive company where my talent can be applied to their full potential

TECHNICAL SKILLS

• Client/Server programming
• Object-oriented programming
• Database designing
• Performance tuning
• SQL optimisation techniques
• Job: system design, database module, screen module, report module, coding, debugging, trouble-shooting, tuning and implementation.

EDUCATION

1988 - Bachelor of Commerce, Guru Nanak College - Madras University
1989 - Diploma in Computer Applications, I.S.D.S., Madras
1994 - Diploma in RDBMS - Sybase, Powerbuilder, Visualbasic - Software solution integrated ltd
1997 - AS/400 - Software solution integrated ltd, Madras
1998 – SAP/3 ABAP4 training courses in Parkway Management care, Singapore
1998 - Visual C++ - Software Technology Group, Madras
1998 - Java, JDK 1.2, JDBC, Java Beans, CORBA, RMI -  MAT Systems, Madras
1998 - Lotus Notes Certified Course - System Administrator - MicroUniv, Madras

PROFESSIONAL EXPERIENCE

From Jan 98 to Sep 98 (9 months)
CapGemini Asia, Singapore
(A Software development concern)
Role: System Support
Team : 6

Project: CITIBANK -CPC (Check Processing Centre)
Softwares : Informix DSA v 7.x, HP-Unix v 10.02 K-shell, C compiler,
Hardware : 2 HP-9000

CPC is a centralised system to effectively handle all the operational aspects of Citibank’s Cash Management Function, involving capture of Cheque and Deposit details, Dispatches to correspondent banks, Processing liquidations, Disbursements, client payouts, monitoring Client’s credit lines and reconcilations with the correspondent Bank’s books.

I have been working on bugs removal and maintenance support. I was monitoring major 6 branches viz., Thailand, Taiwan, Indonesia, Philippines, Korea and Hongkong

I was involved in preparation of Requirements study, Investigation, Functional specifications and effort estimate, System design, Program specifications, Program construction, Module Test, System Integration Test Plan, performing SIT, Scheduling for User Acceptence Test, performing UAT, system setup till sign-off from the User. All the programs are maintained in unix SCCS (Source code control system).

This is the application for Citibank check clearance centre comprises:

• Implementation of Security by maker-checker concept
• Authorisation is another check to enforce validation of transactions
• Provision of Online credit, priority wise check movement
• Processing of check dispatch/movement for liquidation
• Liquidation of checks (Scheduled / Amount based / Check based
• Dealing with 7 type of customers
  Clean collection, Guaranteed local, Guartanteed Direct, Guaranteed Non-direct
  Discounted local, Discounted Direct, Discounted Non-direct
• EOD validation, Batch processing
• MIS reports

Laising with Clients, Operators, Users, UAT people, DBAs, SPs and Librarians
Solving production problems in the cases of delicate/complex (severity level 3, 2, 1)

From May 97 to December 97 (7 months)
Parkway Managed Care Pte Ltd., Singapore
(Group of Mount Elizabeth Hospital)
Role: System Analyst

This is a concern, ISD department for the top 3 hospitals of Singapore. They are Mount Elizabeth+ Gleneagles+East Shore. Parkway is a medicare group, provides medicare solution to the members of the major companies in Singapore. These medicare members can avail medical treatment from any of the registered clinics in Singapore. My system monitors cash flow between parkway, members and clinics. It maintains transactions of subscription details from the client members, similarly payment of service charges to clinics. There are about 50 clients, 23000 members and 1000 private clinics have involved in this scheme.

Project: PATIENTS CONSULTATION ENTRY MODULE
ONLINE INSURANCE CLAIMS APPLICATION THRU INTERNET
Softwares: Visualbasic 5.0, TrueGrid 5.0, Active X document

This module created specifically for the clinics who are involved in our medicare scheme. This is a special VB based package to be utilised in most of the member clinics. It facilitates to key in all the patient details and their necessary treatment details. Daily transactions will be transferred over internet using this ActiveX (VB) application. Transactions are submitted by the clinics to parkway to seek medical claim reimbursement. It facilitates to have one standard package in all the clinics, maintains standard format of data, so as to ensure easy data maintenance between clinics and us and vice versa. Any upgradation in the package can be easily distributed to all the clinics via internet. All powerful innovative new enhancements provided to survive in the fast changing computer industry. Mainly, it reduces most of the paper work, reduces network traffic. Because internet way data transfer is a cheaper and easier than traditional type of data transfer methods. The submitted data would be downloaded by Parkway Server (MS-SQL) for validation process.

Implementation of SMARTCARD is also designed, it is to store relevant clinic information and patient information in the card, so that this card can be used anywhere, anytime and all the information required can be read immediately.

Project: HOSPITAL FINANCE ANALYSES
Softwares: MS-SQL Server on Windows-NT

• Monitors cash in and out flow between Parkway, client members and clinics.
• Analyzing members medical expenses details
• Billing monthly/yearly/quarterly subscriptions from the members.
• Service charges to the clinics.