ACCOMPLISHMENT

1. First 6-month period report (July 1, 2010 - December 31, 2010)
   1. Completion of the in-house developed Electronic Business Integrated System (e-BIS). An ORACLE based application, e-BIS was designed to replace the existing Visual Basic based application, Tax Revenue and Collection System (TRACS). The system includes:
   • Online Business Permits and Licensing System at the Permits and Licensing Division - Office of the City Mayor.
   • Online Billing and Collection System at the License Division - Office of the City Treasurer;

   • Salient features of the system:
     • Electronic capturing and printing of Business Application Data
     • Online generation of Business Permits
     • Online assessment and business taxes
     • Online Billing
     • Online collection and generation of Official Receipts (Accountable Form No. (AF51)
     • Computer generated reports
     • Management monitoring information like real time computer display of business transaction data to include daily, month-to-date and year-to-date number of Business Permits issued and Business Tax Collection.

2. Last 6-month period report (January 1, 2011-June 30, 2011)
   • Implementation of the ORACLE based Electronic Business Integrated System (e-BIS).
   • On-going enhancement of front-end program modules as my be required by end-users.
   • On-going development of regular and ad hoc reports required by city departments/offices and other agencies of the government.
   • On-going maintenance and monitoring of system performance.

1. Local Area Network
   • Setting up A Local Area Network at the Accounting Department and installation of Windows 2000 Operating System on the server where the electronic New Government Accounting System (e-NGAS) software was installed. This set-up was used for database buildup.
2. Systems Availability
   • 100% availability of computer resources. Downtime is mainly due to power outrage.
   • Restoration of IT equipment in its functional state at a short period of time during the water overflow that drenched our computer servers thus enabling the city government to continue its service to the public within a short period of time.
3. Application Program
   • Development and deployment of a software program using ORACLE for the Integrated Community Based Information system (ICBIS)
4. Computer Maintenance and installation/upgrading of software programs.
   1. Departments provided with computer-related service and their corresponding number of repair request made are as follows:

1. Local Area Network
   • A Local Area Network was set-up at the accounting department in preparation for the electronic New Government Accounting System (e-NGAS)
2. Systems Availability
   • 100% availability of computer resources. Downtime is mainly due to power outrage.
3. Application Programs
   • Building up of a database of all city-owned computers for monitoring of repair history and other repair-related data. Each computer including its major components are labeled using barcode.
4. General Revision
   • Completion of encoding of new market and assessed values and printing of Notice of Assessment and Tax Bill for the 140,000 parcels.
5. Computer maintenance and installation/upgrading of software programs.
   1. Departments provided with computer-related service and their corresponding number of repair request made are as follows:

1. Wireless Network set-up
   • A wireless Wide Area Network was set-up to connect five (5) offices of the City Government in various location outside of City Hall to the base station at MITCS this providing internet access and data transfer among said offices. The offices involved are the General Services Office, Bacolod Housing Authority, Accounting Department, Bacolod City College and City Engineer's Office.
2. Timely submission of reports
   • The Daily Collection Report is now generated on a daily basis. Before we have experienced backlog for several days.
3. Application Programs
   • Development and deployment of Lot Beneficiary Information System for the Bacolod Housing Authority. Program modules include:
     • Master file maintenance of original lot awardees and actual occupants;
     • Data Entry for lot payments;
     • Report generation - Alpha Master List per site.
   • Development of the general revision programs.
4. Setting-up of a database and monitoring system for computers of the City. This will enable us to monitor repair history, warranty period and the like.
   List of computers served as of December 31, 2004:

5. Maintenance of the official website of the City Government
6. TRACS Project
   • Continuous coordination with the developer of the TRACS program module re problems encountered during implementation.
   • Management and maintenance of database of the business and collection modules.
7. Computer maintenance and installation/upgrading of software programs.