2.1 develop an application to provide online status reporting of projects to external GSA customers. The application will be developed to support the given legacy INS requirements. Other customers…

2.1 develop an application to provide online status reporting of projects to external GSA customers. The application will be developed to support the given legacy INS requirements. Other customers will not be included the requirements development effort. The application requirements established with INS will meet the base needs of other federal customers. A change control board that includes a legacy INS representative will provide additional detail concerning the functional requirements. The scope of the project will include: two online reports o project status o detail project obligation/expense tracking ability to support multiple customers o application security and design will support multiple customers RWA and project search capability by: o customer AB code, RWA number, customer RWA number, building number, name, city, state daily data extraction from five source systems o fmis: financials o lris: r & a project dates o star: lease project dates, building info o RWA tracker: commitments, RWA dates, project description o OA tool OA dates, square feet, rates, rent interface error processing and rollback ability for customer to enter their own RWA information online link to associates directory link to RWA search ability for customers to email GSA project managers ability for GSA managers to enter data and review and manage data retrieved from source systems. This will involve complex logic to select and override source data: o group rwas into projects o enter building number if dummy number used on RWA o select correct lease if multiple leases retrieved from star o select correct project if multiple projects retrieved from star o select correct occupancy agreement if multiple agreements retrieved from OA tool o enter project status information oracle database to store data retrieved from source systems and data entered online by GSA managers and customers initial and ongoing data conversion effort to read fmis tables and load prior year RWA data when each new customer is added report print o ability to print two online reports plus an additional customer summary that includes RWA number, building location, manager, and authorized, committed obligated, expensed and billed total, ability to download all reports to word and excel online help computer based training (CBT) the application should be developed using the following software standards: sun solaris oracle 9I database oracle 9I/as java edition java 2 platform, enterprise edition (J2EE) client microsoft explorer 5.5 or above