Closed

Need AWS expert to convert database to StratML Format

Simply stated, the objective is to convert the relevant elements of the IRS Form 990 database into model performance plan/reports for all of the tax-exempt million+ organizations included in the database.

Since the data is not particularly well-suited to the purposes of performance plans and reports, the challenge will be to map the most relevant elements in the database to the elements of the StratML standard. My preliminary mappings are documented at [login to view URL]

The desired outputs are individual performance plan/report files for each of the organizations in *valid* StratML Part 2, Performance Plan or Report format, conforming to the latest schema provided at [login to view URL] and presented in a template similar to this: [login to view URL] or perhaps, more simply, like this: [login to view URL]

The final wording in the template may change, depending upon feedback from Charity Navigator &/or other potential stakeholders, and it would be good to test the concept with a limited number of the records in the database before converting all million+ of them.

Rather than providing files for all of the organizations in bulk, an alternative would be to generate such files for them individually, upon demand. However, that would not achieve the objective of generating a corpus of StratML data sufficient to demonstrate highly useful and scalable StratML query services for more than a million files.

The database is available via Amazon Web Services at [login to view URL]

Jason Lind has done some preliminary work on it at [login to view URL] & [login to view URL]

Gannon Dick has also downloaded a bunch of the data but I’m not sure what, if anything, he may have done with it.

Potential value-added users of the data include applications and services being developed by Andre Cusson, Chris Fox, Alejandro Revuelta, Uli Bethke, and Patrick Durusau.

Targeted secondary users include the tax-exempt organizations themselves, for such purposes as attracting and justifying contributions and/or engaging prospective performance partners in pursuit of common and complementary objectives.

This example shows how the financial data from the Form 990 database has been presented in the context of Charity Navigator’s plan: [login to view URL] However, the data in that example has been entered manually and is a combination of data from the 990 database and Charity Navigator’s website. As indicated above, the challenge will be to see how well the most relevant elements of data in the database can be mapped into the elements of the StratML standard.

At a minimum, the names of the organizations and their financial data will be rendered in StratML format in the context of a template along the lines of the one cited above. The purpose of doing so would be to make it as easy as possible for them to flesh out the template with their own goals, objectives, stakeholders, and non-financial performance indicators.

With reference to organizations who may choose not to do so, the objective would be to enable their stakeholders (e.g. their contributors) to easily see they have failed to document and openly share their performance plans and report data… and to encourage their stakeholders to take appropriate action based upon such knowledge. Such prospective users would be the third potential set of stakeholders for this initiative.

Among the use cases for StratML documented thus far, here’s how this one has been documented:

Note: Job description went over 4,000 characters, here's a link to the full description:

[login to view URL]

Skills: Amazon Web Services, Database Development, Database Programming, Software Architecture, Software Development

See more: I need AWS expert, Need an expert who has good understanding and knowledge of Google Map API and Geofence., convert database bak format, need convert logo banner format, convert xml file format database sqlite database, convert visual foxpro database access format, convert database access executable format, need joomla expert, need asterisk expert, need dns expert, need flash expert, database gps api google maps, need seo expert, need excel expert, mysql database integration api, need dreamweaver expert, need jamroom expert, need seo expert website, convert stl iges format, convert address book format, turbolister database file format, report database excel format php, convert csv file format, convert database bak, convert database access exe

About the Employer:
( 16 reviews ) Derry, United States

Project ID: #17176414

12 freelancers are bidding on average $1314 for this job

$1250 USD in 20 days
(35 Reviews)
6.8
$1250 USD in 20 days
(11 Reviews)
5.2
donnyforu

Hello, I am a seasoned IT professional with more than 23 years/ two decades of experience. I have worked for top global IT companies and successfully managed large and complex large IT projects. Harnessing this experi More

$2500 USD in 20 days
(5 Reviews)
4.6
mmadi

Hi MattWJackson good day! I have extensive experience in Amazon Web Services, Database Development, Database Programming, Software Architecture, Software Development. please check more from here [login to view URL] More

$1050 USD in 24 days
(6 Reviews)
4.0
ranumehta2017

Hello There , Hope you are doing great ! Amazon AWS Expert Team We are a competent team for AWS and proud member of Amazon AWS global partner network (APN) and a certified More

$1250 USD in 20 days
(24 Reviews)
4.5
$750 USD in 20 days
(23 Reviews)
4.0
$1250 USD in 20 days
(6 Reviews)
3.2
fullstackpratim

Top rated AWS expert on freelancer (MEAN / MERN) Dear Employer, Hi, my name is Parth, I am a fullstack developer specializes in creating beautiful web sites and mobile app. In my 9 years in the Web and Mobile More

$1500 USD in 30 days
(1 Review)
2.4
relevantsystems

Hi. I have read this job description carefully. Thank you for your detailed description. I am very interested on this project and willing to discuss it via chat with you I have experience in managing database so ca More

$1250 USD in 20 days
(0 Reviews)
0.0
mandalpu

Hi, I have good understanding of Databases, Java and have familiarity with XML and can help you with the conversion of the data into StratML Format.

$1333 USD in 20 days
(1 Review)
0.0
ragupathig2

Over All 7 + Years IT related experience in file maker pro and AWS cloud 2+ Years’ Experience in Planning Designing, Implementing and Maintaining System Applications in AWS Cloud in windows environments and Experi More

$1055 USD in 20 days
(0 Reviews)
0.0
$1333 USD in 10 days
(0 Reviews)
0.0