Database Management

Macro’s ongoing maintenance of large analytic databases enhances our ability to provide analytic services in a timely and efficient manner. We understand the scope, strengths, and limitations of a comprehensive array of data resources in many subject areas. Working with Federal agencies and not-for-profit organizations, our analysts compile, integrate, tabulate, and analyze statistics on various aspects of the data we gather or manage. Macro also has extensive analytical and data management experience with secondary data sources. We can readily investigate the data sources and incorporate their useful elements.

Howard Hughes Medical Institute Financial Project
This project involved replacing and integrating multiple legacy systems into one database, with numerous software tools for accessing the data. The back-end data storage for all of the systems is an SQL Server database. The front-end systems consist of both client-server systems for HHMI internal use and Web systems for internal and external data collection and reporting. The systems support all phases of entry, updating, maintenance, and reporting of financial information. A Microsoft Access client-server system is used to initialize information on new grants. All the systems use the same database, so management can obtain reports on all available financial information easily. The Budget and Expense System (BESt) is used by grantees to submit budget and expenditure reports. This Web-based system allows grantees full access to their budget and expense data via the Internet. BESt provides built-in reports that allow grantees to view and format their budget and expense data conveniently. It also provides built-in validation to track grantee expenses against HHMI guidelines.

MacroNet | Privacy Statement | Contact Us | Site Map | What’s New