Max Jaison Jayapaul

Summary Information

 Objective

Seeking a challenging career in software technology developing Windows based applications.

Experience Summary

2½ year’s experience with 2 years overseas, 1 year on Documentum products, 1 year developing database oriented application software in Windows using Visual Basic 5.0, MS SQL Server and MS Access and 6 months teaching experience. I am currently working with Documentum products, which are used in Electronic Document Management Systems. I have worked on a three-tier client server project for a large transport company in Kuwait. I have worked on more than 60 reports using Crystal Reports v4.6. I have also passed the Microsoft Visual Basic 5.0 exam and Visual Basic 6.0 Distributed and Desktop Applications. I am confident and have the capability to independently adapt to newer areas of software technology. I am able to work in a multiethnic team environment. I have experience in the following areas.

• Three tier architecture (TTA) for enterprise-wide solutions 
• ActiveX
• Remote Data Object (RDO), Data Access Object (DAO)
• Component Object Model (COM) and DCOM
• Crystal Reports v4.6
• True DBGrid
• Visual SourceSafe for source code management.
• Help file creation and Resource Files
• Common utilities of Microsoft SQL Server 6.5/7.0
• Documentum Products Customizations

Qualifications

Other Information

• Passport No : A2977793
• Date Of Birth : 10 October 1975
• Nationality : Indian
• Sex : Male

Employment History 

 Current Project

Brief Description

The Drawing Management System of the Saudi Consolidated Electric Co. uses Documentum products to store metadata and the contents of the Electricity Distribution Maps made on Micro-station on Docbases at Riyadh and Dammam. The customizations on the product allows the user to enter 20 user defined attributes from which the name of the drawing is automatically formed. A particular attribute, Drawing Number is automatically incremented every time a new drawing is made. The other customizations pertain to permissions given to super users. A single Employee Report was alos made using Visual Basic 6.0 and MS Excel 97. 

Key Projects

Brief Description

The Customer Document Management System of Etisalat stores important customer documents like Application Forms, Passport Copies, Vouchers etc. in electronic format on DocBases at Abu Dhabi, Dubai and Sharjah. I have created 5 reports using MS Excel which keeps track of the number of documents retrieved, number of documents and pages imported, number of documents and pages imported per subscriber etc. A bulk offline batch loader was created using DocPage Builder which loaded multi-tiff images scanned using Imput Accel into the DocBase. A SEDCO Term integration was also created using Visual Basic 6.0 to integrate Workspace with main-frame based Ingres. 

Brief Description

This system converts text file data exported from K.P.T.C.’s main frame computer, into SQL Server tables. The system takes care of erroneous data by generating records into an error log table. It keeps check on errors like referential integrity violations, primary key violations, data type mismatch etc. The error log table stores the errors and the record key. The text file data may tab-delimited or have fixed lengths. It also contains a report options which allows the user to generate the report for module / table / transaction / without duplicate record / with duplicate record/date wise. Data converted using this system is used by the modules developed below.

Brief Description

The KPTC Information System is an enterprise level project that links the various departments of the Kuwait Public Transport Co. that are spread across the geography of Kuwait. It contains 8 major modules : Puchase, Stores, Third Party Garages, Workshop and Own Garages, Personnel, Payroll, Fleet Management, Legal and Finance modules. Listed below are the brief descriptions of the 4 modules I have worked on. 

The Stores Module keeps track of the various items received by the Stores Department of K.PT.C. It maintains the technical details and the stock of each item at its various depots around Kuwait. The Store Receipt Voucher transaction maintains the receipt of the items from the Purchase Dept. It issues these items to the requested Workshop Dept. by entering the details in an Issue Voucher transaction. Inter-store transfers are maintained using Transfer Voucher transaction. The stock of each item is maintained month-wise and store-wise. It also contains queries and reports for the top management about slow moving stock, physical stock verifications, return stock etc.

The Workshop and Own Garages module deals with the computerization of the workshop that repair K.P.T.C.’s own bus fleet. The basic transaction is the Work Order that is created whenever a bus goes to the garage for repair or for maintenance. By choosing a set of jobs for repairing a bus, the computer automatically specifies the necessary spare parts and standard time required to complete the job. The module also calculates the time spent on a work order by an employee on a bus using the Labor Card transaction. The Bus Maintenance Schedule automatically finds out which bus requires maintenance based on its mileage. There is also a Spare Part Projection transaction projects the number of spare parts required for a particular period based on the bus maintenance schedule.

The Third Party Garages Module maintains the details of operations and management of garages used to provide maintenance service to cars .It involves job planning and Scheduling, jobs Follow up and control work in progress monitoring invoicing and documentation support .It gets input values as spare part issue, code master update, operation planning and etc .It produces output as job order history, list of invoices, garage issue document, section work progress, job order and spare parts details and order, receipt and issue voucher.

The Purchase Module is the primary module of the K.P.T.C. Information System Project. Any purchase made by K.P.T.C. is recorded here. First a tender is sent out to selected companies using the Tender Master. The quotations received from these companies are entered using the Quotations transaction. Using the Quotation Comparison report, the company with the lowest price is selected and a Purchase Order is sent using the Purchase Order transaction. Once the items are received by shipment, the items received are entered using the Supplier Invoice transaction. It also has a set of queries and reports for top management which reports on the status of every Purchase order, Lead Times per item etc.

Technical Description

• This system was developed using Three Tier Architecture (TTA).
• One Windows NT Server for SQL Server 6.5 Database.
• Four Windows NT Servers as Middle Tier for business rules.
• 40 Windows 95 terminals as client machines.
• For Remote Automation in TTA, DCOM utility is used.

Brief Description

This system is used to print a set of reports for business customers who are on Gulf Air’s Frequent Flyers Program. Text file data is exported from an Informix / New Era system which is then converted to MS Access database. It prints out a report showing the number of kilometers the customer has flown by Gulf Air, the number of points he or she has accrued and the benefits he or she receives according to these points. 

Additional Qualifications

• Certificate in Java Programming (Infodrive)
• Diploma in Database Management Systems (Infodrive)
• Institute of Electrical and Electronics (IEEE) member
• Passed Microsoft Visual Basic 5.0 exam. Scored 830.
• Passed Microsoft Visual Basic 6.0 Distributed Apps exam. Scored 785.
• Passed Microsoft Visual Basic 6.0 Desktop Apps exam. Scored 857.
• Currently working towards an MCSD (Microsoft Certified Solution Developer).

References

Last Updated on 1 January 2000