Parse XBRL data from FFIEC - MySQL XML Database XBRL
We need someone to develop a system that will parse the data from /public/PWS/DownloadBulkData.aspx - XBRL data - Data are available quarterly, however we just need for you to setup the system so that we can then parse the past data. - download of the data can be manual - need a backend system that will take the data parse it and put into data (MySQL) in some structure table. - The key will most likely be RSSID and report date. It really depend on how you design the database. We basically need to be able to retrive data for a particular bank/financial institution for a given quarter (report date) - we need UBPR data (which I think also includes the call report) - ideally if done using PHP (if not perl or something else) ------------------------------------------ Added 3 AUG 2012, 10:36 AM EDT Some addition clarification - The system need to have one row per bank (key of RSSID) - Need to also get the data from the data dictionary ( /reportforms/mdrm/DataDictionary/search.cfm). Each of the data field in the data downloaded is label with MDRM# which can be search using the above url to find out what it means. We also need a lookup table of all the MDRM# that is used in the data downloaded - All data should be store in DB. we will access it by connecting to the DB. This project all you need to worry about is parse the data and store into the db so that we can query it of RSSID or FDIC cert id if available for each reporting period Desired Skills: MySQL XML Database XBRL Keywords: Software Application, MySQL, XBRL, Database, XML
| Expired |
Colette Davis
Business Consultant
View profile
Wid Bastian
Writer
View profile
Hector Rivera
Multimedia Expert
View profile
Roger Harris
Creative Writer
View profile
Related projects
Search for freelance jobscan’t wait for more clients
and advertising. Thank you."