1 / 10

Project

Project . CPR E CPR E CPR E SE. Joe Briggie Kenny Trytek Abby Birkett Derek Woods. Needs Statement. (Companies are like Ogres Onions ). Master Copy. Large companies have many layers of corporate hierarchy.

toni
Download Presentation

Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Project CPR E CPR E CPR E SE Joe Briggie Kenny Trytek Abby Birkett Derek Woods

  2. Needs Statement (Companies are like OgresOnions) Master Copy • Large companies have many layers of corporate hierarchy. • Financial and data records are sometimes conflicting between various layers/entities. • Accurate and comprehensive company records are needed. • There is a need for “Data Mastering”: It’s like digitally re-mastering an audio CD or a movie to eliminate glitches and errors.

  3. PROJECT OBJECTIVE • Develop an automated data harvesting tool to collect FDIC and FFIEC records from government websites. • Develop a database model to store the records • Design a GUI to make them accessible to accountants and analysts for mastering • The end result is to save money & ensure quality data for Kingland Systems clients.

  4. Employee UI Denormalized IBM MDM Server Landing Zone Batch App Work Area ETL Normalized No Conflicts? DAL Client UI Web Svcs. SYSTEM DIAGRAM

  5. Functional Requirements • System shall autonomously traverse publicly available websites • System shall parse information from downloaded file in portable document format (pdf) • System shall put parsed information into a flat file • System shall allow user the ability to create records • System shall allow user the ability to edit records • System shall allow user the ability to delete records • System shall maintain a normalized database • System shall expose functionality through web services

  6. Non-Functional Requirements • System shall support concurrent users • A single run of system shall complete execution in less thansix hours • System shall be scalable to include more websites than originally specified easily • Web services shall be available at all times • System shall be completed by May of 2011

  7. CONSTRAINTS • System shall be written in ASP.NET • System shall interact with a third party library to facilitate database interaction • The database may not be available at all times

  8. RISKS • External site could change its storage format, causing the parser to fail • External site may not be available at all times

  9. TASK SCHEDULE – FALL 2010 • Project Plan – • Complete Initial Prototypes – • Design Document Draft – • Design Document – 10/12/2010 11/16/2010 11/16/2010 12/3/2010

  10. PROJECT COST • Free!

More Related