Project Title : Oracle Financials

Duration : 2.5 years

Client : Dubai Aluminium Co. Ltd. (DUBAL)

Role : Systems Analyst

- Customisation of GL and AR Module.

Environment : Oracle Financials Rel. 10.7.0 SC161

Operating System : Windows NT 4.0, AIX ver4.0

Team Strength : 5

Dubai Aluminium Company Limited – DUBAL a major aluminium smelter, power station and desalination plant complex stands the largest non-oil foreign exchange earners in U.A.E. As the company is known world wide, DUBAL is the largest manufacturer of foundry alloy in the world. 

• Contribution:

• Analysed and customised AR module like defining Flex Fields, creating value sets and adding look up codes to suit the requirements of the client Business.
• Developed specification for reports, Forms, PL/SQL specific to user requirements.
• Customised Oracle Financials report as per the user requirements. Developed, tested and registered new reports adhere to Oracle Financials standards.
• Designed intermediate and mapping tables for conversion.
• Writing conversion scripts to download the data into intermediate tables using Stored procedures/Packages and PL/SQL.
• Responsible for downloading data from AS400, uploading to interim tables and sort out exceptions.
• Involved in testing, User support, parallel run, User reviews and Implementation.
• Integration of all customizations into the application using AOL.
• Performance tuning of forms and SQL.
• Writing database triggers.
• Archiving data from AS400.
• AR Interfaces - Autoinvoice and Customer Interface.
• Customisation of Cash Interface
• Involved in Y2K Mega patches/Dynamic testing.
• Designed and developed fully customised module ' Metal Invoicing' which have been added to AR.

• Customising Accounting and Production Period Calendar, Classification of Cost centres, exchange rates, telephones.
• Conversion of historical data from legacy GL system in AS400.
• Customised forms for the conversion of old cost centre, accounts, sub accounts, projects, Employee, code Combinations and uploading them as GL.
• GL Interface - Journal Import.
• Customised forms and reports on user requirement.

• The work was to have a tailor made module for generating Metal Invoices for sales. This was done based on Oracle Standards and using AOL. My role was to design detail Technical Specifications, Design and Code Forms, write stored procedures and Test and Implement the system. This required extensive study of Oracle Corps. standards while writing specifications, writing code and Designing forms. The project also required extensive study of Applications Object Library (AOL).
• The objective of this module was to create a system for invoicing of finished goods sales fully integrated with the AR and GL modules of Oracle Financials on the one side and the AS400 SOP (Sales Order Processing) System on the other. This system has a setup part for defining Accounting Rules, Pricing Elements and Covering Letters. This system encompasses functions such as automatic generation of invoices based on Shipments, Analysis and Pricing data held in the existing SOP system on AS/400, interface to Oracle AR through the ‘Autoinvoice’ feature, Generation of accounting entries through the Oracle GL interface, Generation of credit/debit memos arising from price-revision, Generation of covering letters together with shipping documents, Sales Daybook and other analytical reports. This system is developed on Oracle RDBMS (ver. 7.3) and establishes an interface with the SOP system on AS/400 using a set of database triggers and the Oracle Gateway product for DB2/400.

Project Title : Reduction Plant Monitoring System (RPMS).

Duration : 17 Months

Client : Dubai Aluminium Company Ltd.

Role : Systems Analyst

Environment : Oracle 8i, Developer 2000(Forms 4.5 & Reports 2.5), Pro*C.

Operating System : Windows NT 4.0, HP Unix 10.1, AIX ver 4.0.

Team Strength : 3

The system consists of :

Project Title : Sales Accounting System.

Duration : 10 Months

Client : Hindustan Organic Chemicals Ltd.

Role : System Analyst

Environment : Oracle 7.1, Developer 2000 (Forms 4.5 & Reports 2.5)

Operating System : Windows NT 4.0

Team Strength : 4

• This System automates the sales related activities of Hindustan Organic Chemicals Ltd. HOCL has an existing Sales Accounting System based on Unify RDBMS. The work involves the re-engineering of the present system for satisfying the new requirements. HOCL is the sole manufacturer of chemical products like Phenol, Acetone, Cumene etc. This system was developed for Cochin Plant. The work include delivery order preparation, Invoice generation and sales accounting. In sales accounting, software automates generation of receipts and payments vouchers, journal vouchers, credit and debit notes.

Project Title : Drug Inventory Management System

Duration : 9 Months

Client : KSDC, Trivandrum.

Role : System Analyst

Environment : Oracle 7.0, Developer 2000 (Forms 4.5 & Reports 2.5)

Operating System : SCO Unix, Windows 95

Team Strength : 3

• KSDC is a government agency supplying medicines to government hospitals and health centres in the state. This Package keep track of receiving medicines from distributors and distributing them to mini depots on requests. This system take care of the expiry dates of the medicines. The medicines, whose expiry dates are near will be issued first. The Package generates reports and documents like Purchase order, Issue order, list of all medicines with expiry dates, current stock level of medines, list of outstanding medicines, List of outstanding requisitions, list of rejected medicines etc.

Involved in System Study, Analysis, Design, Development and Testing.

Project Title : Payroll Processing System

Duration : 6 Months

Client : Lakshmi Mills, Coimbatore.

Role : System Analyst

Environment : Oracle 6.0, Forms 3.0, Reports 1.1.

Operating System : SCO UNIX Rel 3.1

Team Strength : 3 

• This package will support the organisation in automating their payroll system, covering employee details maintenance, earning, deduction maintenance, attendance details maintenance, Leave maintenance, Report generation and query analysis. The system maintains the details of admission and termination of each employee. It also handles the income tax and PF. It has the facility for the automatic Calculation of Bonus. The report generation will support the organisation in preparing pay-slips, salary register, loan information etc as per the needs of the organisation.

Project Title : Hotel Administration System

Duration : 7 Months

Client : Hotel Malabar International Calicut.

Role : Programmer

Environment : Oracle 6.0, Forms 3.0, Reports 1.1

Operating System : SCO UNIX Rel 3.1

Team Strength : 4

Project Title : Education and Training Information System

Duration : 8 Months

Client : Alpha Data Informatics, Trivandrum.

Role : Programmer

Environment : Oracle 6.0, Forms 3.0, Reports 1.1

Operating System : SCO UNIX Rel 3.1

Team Strength : 3

Project Title : Hospital Management System

Duration : 7 Months

Client : KPM Hospital Malappuram

Role : Programmer

Environment : Oracle 6.0, Forms 3.0, Reports 1.1

Operating System : SCO Unix.

Team Strength : 4

• This system is meant for Hospital information Processing. It includes Patient and staff management, room management and service management. In-patients and out-patients are treated separately. Validation is performed for out-patient card for each consulting. Enquiry regarding patients and staff can be performed. The system automates the scheduling of duties of doctors, nurses, and other staff. Rooms are allocated for in-patients from available rooms list which can be changed subject to the availability of rooms and on priority of reservation. Service management deals with the operation services and with the supply of medicines. History maintenance and billing also takes place through the system. Reports are generated for different purposes.

Project Title : Real Estate Information System

Duration : 7 months

Client : Kairali Real Estate Cochin.

Role : Programmer

Environment : FoxPro

Team Strength : 2

• This is an information system that assists the people interested in buying land to buy land of their choice and fore those interested in selling land to sell. It matches buyers and sellers according to the criteria specified like area of land, location, nature, type of deal etc. Buyers and sellers register themselves in the database by filling in the details of land they intended to sell and also their preferences. Matching is done in all the factors and buyer / seller is given a list of all perfect matches and partial matches in the decreasing order of number of factors matched. A Detailed report on the matches of land are given to users on demand.