Project: Electronic Timesheet System
Project Description:
This application was developed in Power builder 8.0 and MS SQL Server as backend. The application was interacting to Oracle based Baan ERP system for charge codes validation. As company changed their ERP from Baan to Visibility, the application needed to talk to Visibility back end ORACLE 8i database. I have developed an interface to interact with visibility Oracle back end and validate charge codes.
Roles & Responsibilities:
1. Created user interface to interact with ERP back end ORACLE 8i database. These changes are made using Power builder 9.0 (with PFC)
2. Created windows, data window, menu-item and other objects using inheritance in PB PFC objects.
3. Enhanced power builder codes to implement Real time charge code validation against ORACLE 8i database (which is back end for ERP system)
4. Created PL/SQL procedures and packages to post employee's leave / vacation record and labor distribution records.
5. Also creat