Posted by on January 07, 19103 at 18:02:35:

J.CHANDRA SEKHAR

'C' Block, 6th Unit, No. 6
Palm Courts Condo,
Jalan Sultan Abdul Samad, Brickfields
50470 Kuala Lumpur Malaysia
) 00 60 166916420
Email ID: mailsek@yahoo.com

OBJECTIVE
Seeking a challenging career in IT industry with a good knowledge in Analysis, design and development of Client/Server Applications Using ORACLE and Developer 2000

SUMMARY:
· 4 Years of experience in Information Technology.
· Strong technical skills in DEVELOPER 2000 (Forms 6.0,Reports 6.0) / Oracle (SQL Plus 8.x, PL/SQL 8.x, Stored Procedures and Database triggers).
· Self-motivated, hard-working programmer.
· Highly responsible and initiative team player..

TECHNICAL SKILL
Operating systems : DOS 6.22,Solaris/Linux and Windows platform, Windows NT
Languages : C,C++,COBOL,PASCAL,VB and FORTRAN
DBMS : Foxpro 2.6
RDBMS : Oracle 7.x & 8.0, MySQL, Postgres, Access
GUI : Developer 2000 (Forms 4.5 & 5.0,6.0 Reports 3.0,6.0)

JOB HISTORY

Regional Information System Sdn. Bhd. Kuala Lumpur Malaysia, (Since April '2000 to till date)
Working as a System Consultant involved in designing, coding, debugging, testing and assisting for implementation for various clients’ projects under Oracle/D2K.

Aditya Software Pvt. Ltd., (Since April '99 to March 2000)
Worked as a Programmer and involved in coding, debugging, testing and assisting for implementation for various client's projects under Oracle/D2K.

CMC Ltd., (Since Oct '98 to Mar'99)
Worked as Project Trainee and involved in coding for Payroll sub system. Under Oracle/D2k.

PROJECTS WORKED

Project Name : Asset Management System
Platform : Developer 2000 / ORACLE 8.X / Windows 95
Duration : April ‘2002 to till date
Role/Description : Design & Development of the System

The system is implemented in a organizations immediately and offers financial and time saving benefits in the areas of asset management, asset accounting, asset tracking, IT management, insurance and risk management, servicing, maintenance and reliability and help desk information

· Asset Register
The asset register provides an easy to use interface for entering, finding, listing and analysing assets. The register is not in any way a separate part of the system but forms the hub of the system around which all features is based.

· Asset Accounting
Assets can belong to an unlimited number of books. Depreciation profiles can change over time and the administrator can specify which formulae or tables are used in depreciation calculations. The system exposes a number of "variables" for use in depreciation calculations. Indexation of assets is easy to set up and is defined per category group per financial year per currency.

· Asset Tracking
Location Audits are set up in the system and users can determine which categories of assets and which locations will be included in the audit.

· Insurance and Claims
Assets are linked to insurance policies and the system reports on uninsured assets, under-insured assets, over insured assets, double insurance issues, outstanding claims, and assets liable to claims

· Servicing, Maintenance and Reliability
Servicing, Maintenance and Reliability tracking are built into the system. The development is intended to cover traditional servicing and maintenance of equipment and machinery, plus servicing of buildings, cars and computer assets. Servicing is implemented via a concept of service plans. Each asset is linked to a service plan. A service plan is a list of services that will be done on an asset over its lifetime. Service scheduling is implemented by allowing the user to state under each service the frequency in which the service should be done.

· Help Desk
The help desk function is tightly integrated into the servicing, reliability and maintenance module This allows all asset related maintenance, servicing, repair and troubleshooting to be managed under one unified system. The fault-logging module is designed to allow help desk staff or end users to log faults. A comprehensive fault search function is provided which allows multiple selection of status and type classifications as well as selection by asset custodian and other commonly used criteria. Labour and materials costs are recorded separately against every item of work whether servicing or help desk faultfinding and fixing.



Project Name : Clinical Management System
Platform : Developer 2000 / ORACLE 8.X / Windows 95
Duration : August ‘2001 to February ‘2002
Role/Description : Design, Development & Implementation of the System

The Clinic Management System is a solution specially designed to allow a more efficient and effective control over the clinic’s resources, time management and catering to a patient’s requirement. It eliminates as many time-consuming tasks as possible, with features such as patient information management, appointment management, inventory control management and other aspects of a clinic operation.

· Patient Information Management
Patient Information Management enable complete and accurate retention of all patient's details and records, total control and easy access of this information, which will also be automatically, linked to key clinic processes such as allergy alerts during drug dispensation process.

· Appointment Management
Appointments are effectively scheduled with the ability to increase patient convenience through a suitable choice of pre-appointment reminder. At any point of time, the doctor can rearrange their schedule; the appointment management will be automatically updated. Interaction with Queue Management module has made the system even capable of actively re-scheduling appointments to minimize patient waiting time and therefore reduce inconvenience if appointment run overtime.

· Queue Management
A smart and effective queue management system helps to streamline the operations of the clinic but most importantly, the waiting time for a patient is minimized. To ensure that no patient is overlook, a simple yet powerful alert system is incorporated in our solution which will provide a reminder to the clinic administrator about all patients who are in the queue for longer than a certain pre-specified time.

· Consultation and Billing Management
Doctors will use the Consultation Management module to enter his case notes and consultation fee. The entire fee he entered will automatically be added to bill. Nurses will use the Billing Management module to enter the name of the drug(s) to be issued to patient, and other fee of the bill, as well as printing of the bill invoice to patient.

· Drug and Consumable Management
Drugs and Item Management enable the clinic to have complete control over the inventory of items.

· Account and Statistic Management
The complete control over the billing and invoicing procedures in the clinic. Account Management system comprises of a suite of powerful database storage and search features, as well as reminders for accounts that are currently overdue.

Project Name : Personal Information System./Recruitment Process
Client : Offices of Public Service Commission/Public Service Department, Brunei.
Platform : Developer 2000 / ORACLE 8.X / Windows 95
Duration : April ‘2000 to till Date
Role/Description : Development & Implementation of the System

This system deals with the requirements of Public Service Commission and Public Service Department of Brunei Government. I have been involved as a Analyst Programmer and completed the following tasks.

a) Design, Development Of Recruitment application using FORMS and REPORTS.
b) Written Database triggers
c) Written Stored Procedures and packages.
d) Created Test Data
e) Involved in training the users

The following areas are covered in the Recruitment Process.
· Application Entry
· Automatic Short Listing
· Scheduling of Recruitment Examination / Interview
· Scanning Candidate Documents and storing in the database
· Generation of Offer Letter based on various templates

More over Civil service Institute (Cater the Human resource developments needs for the service personnel of Brunei Government and Enterprises) requirements also taken in to the development for the given below activities.
· Program schedule
· Participants request and registration
· Award of contract for Training
· Conduction of training
· Course Evaluation & Feed back Appraisal
· Certification
· Payment

Administration Section Module
-The Administration Section (AS) Module is to aid the Administration Section of the organisation in its operations. It consist of the following sub-modules:
. Financial Management System
. Stock Management System
. Library Management System
. Building Maintenance System

Apart from the above I was also involved in training the users and prepared the help manual. The help manual was generated from Oracle Designer and compiled using Microsoft Help Compiler. The complete application was available on Bilingual (MALAY/ENGLISH) form.

Project Name : Stores Maintenance System for Southern Railway at BBQ Depot.
Client : Southern Railway, BBQ Depot. (Division of Indian Railways).
Platform : Developer 2000 / ORACLE 8.X / Windows 95
Duration : Feb’2000 to Mar’2000
Role/Description : Design, Development, Testing & Implementation of the System

The project is developed for Southern Railway at BBQ Depot. This Stores Maintenance System is an integration of three modules namely General stores, M&P and T&P Stores. The main feature of the system is to monitor the details of Order Booking, Indent processing, Purchase order, Stock position of imprested and Non Imprested items, Issues, Stock transfer and generating various Reports required by the concern.

Project Name : Coach Information System for Southern Railway at BBQ Depot.
Client : Southern Railway, BBQ Depot. (Division of Indian Railways).
Platform : Developer 2000 / ORACLE 8.X / Windows 95
Duration : April 1999 to Jan 2000
Role/Description : Design, Development, Testing & Implementation of the System

The project is developed for Southern Railway at BBQ Depot. This system captures all the information about the Rail Coaches in the service loco station. Its maintenance separate History Card for AC & Non AC coaches, Rake particular of the Incoming and Outgoing Trains, Detachment and Attachment of coaches at the co-ordination meeting. Overdue schedule forecast of AC & Non AC Coaches for Intermediate Over Heads (IOH) & Periodic Over Heads(POH) and the cause of sick at both electrical and mechanical level. It generates some of the vital statements such as Age analysis statement, Date wise sick detachment analysis. Sick position at 17.00, 8.00hrs, Ineffective position of mechanical sick, Coach defect analysis within 90 days of POH. Other railway coached running in this circuit, Pit occupation chart. Broken glass details, Pest control details, watering details, Public complaints, reroute detention, yard inventory details, Forecasting of incoming trains and generated Reports required by the concern.

Project Name : Time Office module for Payroll subsystem of Online Integrated
Information System.
Client : TNPL (Tamil Nadu News Print and Papers Limited).
Platform : Developer2000 / ORACLE 8.X / Windows 95
Duration : Feb’99 to March’99
Role/Description : Design, Development & Implementation of the System

The project I developed is part of a mini-ERP developed by CMC Ltd., for a leading Paper Company in Tamilnadu. The entire project stands as an Online System, which integrates the corporate offices and branches at geographically separated places. The module, which I have developed, is a sub module of Payroll Sub System of OIIS (Online Integrated Information System). The Time Office module records the details of Attendance, Leave, OT, Casual Off, Holiday, Wages, Permission Hours, Loss of Pay Details of all Employees and generating reports required by the concern.

Project Name : Provident Fund module for Payroll subsystem of On Line
Integrated Information System.
Client : TNPL (Tamil Nadu News Print and Papers Limited).
Platform : Developer2000 / ORACLE 7.X / Windows 95
Duration : Oct’98 to Jan’99
Role/Description : Design, Development & Implementation of the System

The project I developed is part of a mini-ERP developed by CMC Ltd., for a leading Paper Company of Tamilnadu. The entire project stands as an Online System, which integrates the corporate offices and branches at geographically separated places. The module I developed is a sub module of Payroll Subsystem of OIIS. This Provident Fund module records the details of PF Receipts, PF Loan System, PF Disbursements, PF Trust Investments and PF Master Maintenance. This System also maintains the guidelines on the eligibility of Refundable and Non Refundable loans, details of Refundable loans availed, Investments activities of the Provident Fund Trust and generating PF Reports required by the concern.

Personnel Information

Date of Birth : October 29th 1974
Nationality : Indian
Marital Status : Unmarried
Passport Number : A8606153 (Valid till 01.02.2010)
Permanent Address : New: 21, Old 13 Vysar Nagar Colony,
1st Street 2nd Lane Vysarpadi (p.o),
CHENNAI - 600 039,
INDIA
) 00 91 44 5514771

Qualification
Master of Computer Applications (MCA) From University Of Madras, Chennai, INDIA
Attended ORACLE Course at BITECH.