Project
Download
1 / 10

Project - PowerPoint PPT Presentation


  • 95 Views
  • Uploaded on

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.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Project' - toni


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Project

Project

CPR E

CPR E

CPR E

SE

Joe Briggie

Kenny Trytek

Abby Birkett

Derek Woods


Needs statement
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.


Project objective
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.


System diagram

Employee UI

Denormalized

IBM MDM Server

Landing Zone

Batch App

Work Area

ETL

Normalized

No Conflicts?

DAL

Client UI

Web Svcs.

SYSTEM DIAGRAM


Functional requirements
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


Non functional requirements
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


Constraints
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


Risks
RISKS

  • External site could change its storage format, causing the parser to fail

  • External site may not be available at all times


Task schedule fall 2010
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