CEDPA Financial Management System Integration Proof of Concept

1. Orion Grant Reporting SystemGrantor AccountGMLOB ECP CorpDocument Management OnBase Online TeradataFFAT EnterpriseData Warehouse CitigroupWorldLinkPayment Services Internet AccessFFAT Users CEDPA Financial Management System IntegrationProof of Concept GrantiumEnterprise Grant Management Orion Grant Reporting SystemGrantee Account CEDPA

2. Roadmap Grantium Enterprise Grant Management

3. Grantor Orion Microsystems, Inc.Grant Management System Grant Event 1Program Grant Award Grant Event 8Inquiry Grant Events Program Grant Award Finance Grant System Setup Finance Award Certification Grantee Processing a Grantee Obligation b Grantee Direct Cost Oblg c Grantee Direct Cost d Program Income e Indirect Cost ASAP & PMS Drawdown Regulatory Forms Web Portal Interface Inquiry Finance SGL Interface 8 1 2 6 7 4 9 3 5 Grantee Payment GLOWS Grantor Agency 1 Program Office Finance Office 6 3 2 9 SGL Interface 3 CFOAuditorsInspector GeneralCongressOMB 3 Firewall Firewall E-Gov Application Service Provider Grantee Data Entrya. Obligation b. Direct Cost Oblg c. Direct Cost d. Program Income e. Indirect Cost GLOWS E-Grant Portal 6 9 2 5 Firewall Firewall 8 Processor Optional GrantApplication 4 Forms BusinessIntelligenceWeb Portal Firewall Firewall Database Optional Interface GrantAccounting&Reporting Host Server Operation GranteeUsing FullIn-HouseGLOWS STR Grantor Interface Firewall Firewall Opentext Grantee Interface Grant Event 2Finance Grant System Setup Grant Event 7Web Portal Interface Grant Event 6Regulatory Forms Grant Event 5ASAP & PMS Drawdown Grant Event 3Finance Award Certification Grant Event 9Finance SGL Interface Grant Event 4Grantee Processing Orion Microsystems, Inc.Grant Management System Core Accounting System SGL 3a Reconciliation 1) Required if 3a SGL Update 2) Not Required if SGL Update Grant ReportingSF269SF270SF272 Grant AwardCertification Grant SystemSetup 3 Alternative ASAP & PMS Reports 7

4. CEDPA FUND & INFORMATION FLOWCitigroup WorldLink Payment Services 1 USAID issues grant to CEDPA Info Legend USAID Worldlink Information Flow 2a 6 $$ HHS-PMS process/ release funds to bank HHS-PMS domiciles funds for CEDPA PMS – PaymentManagementSystem HHS-PMS Info Info 2b 4 5b 10 7a Receive info for reconciliation CEDPA receives info on grants CEDPA sends payment notification CEDPA sends request to HHS-PMS Receive payment notification Info CEDPA 5a 7b 9 Citigroup sends file to CEDPA for HHS-PMS Funds available through Citigroup Send info to CEDPA Citigroup 3 8 Grantee/ Vendor/ Country Staff Grantee requests CEDPA funding Receive funds. Send info. Info 7c Initiate payment (thru Citigroup) to Grantee/ Vendor/Staff Authorized Country Staff

5. Teradata Enterprise Data Warehouse Enterprise Data Warehouse The Teradata Warehouse solution allows you to analyze business operations and drive better, faster decisions by providing a complete view of your business and giving you the flexibility and agility to compete. Teradata Warehouse provides integrated, optimized and extensible technology and services for a single application-neutral repository of your current and historical data, forming the framework of the business intelligence architecture. The latest release, Teradata Warehouse 8.2, includes advanced features such as high-performance parallel database technology, a full suite of data access and management tools and robust data mining software. Plus, you'll receive expert data warehouse training and the advice of the industry's most experienced data warehouse consulting professionals. These are just a few of the top 10 reasons why industry leaders worldwide choose Teradata Warehouse. Active Enterprise Intelligence allows you to incorporate data from across the enterprise into every customer interaction, enabling you to convert information into intelligence, and intelligence into actions. Active Data Warehousing, the foundation of Active Enterprise Intelligence, drives vital data into the hands of your front-line decision makers, extending traditional data warehouse functionality into the realm of tactical decision making through near real-time information access and analyses and predictive analytics. Active Data Warehousing As business analytics become more instrumental in strategic decision making, Active Data Warehousing represents the next phase of decision making intelligence. Active Data Warehousing extends the support provided by the traditional data warehouse by: Allowing access by customers, partners and suppliers Integrating multi-subject, cross-channel information to optimize business opportunities In addition, Active Data Warehousing allows thousands of users to access and query the system at the same time and provides for more flexible ad hoc reporting and machine modeling, such as data mining, to discover new hypotheses. Typical performance levels in Active Data Warehousing are measured in seconds and only comprehensive detailed data available within minutes is acceptable for most implementations. Active Data Warehousing helps you get closer to customers, optimize your supply chain, accurately track asset movement, plan and manage successful promotional campaigns, automate your sales force and conduct critical business analysis needed to compete in today's marketplaces.

6. ECP CorpDocument Management OnBase Online >> ERP IntegrationECP provides document imaging and workflow integration solutions for a variety of ERP or Line of Business applications.PeopleSoftECP provides complementary document imaging, document management and workflow solutions to PeopleSoft users worldwide. We seamlessly integrate with PeopleSoft to deliver digital versions of paper and other electronic documents associated with PeopleSoft transactions. Users have the ability to easily capture, route, store, and retrieve documents and images associated with transactions while dynamically managing the entire range of back-office processes from a single desktop. ECP extends the value of the defined workflow processes contained within PeopleSoft by combining it with imaging technology. Oracle FinancialsECP has a method for integrating data capture, imaging and workflow technologies into existing Oracle applications. Users can retrieve and view relevant documents directly from the Oracle application, eliminating the inefficiencies of manual processes. By integrating imaging with ERP applications, companies can improve the processing of applications, invoices, checks, and expense reports to speed approval, posting, and payment.JD EdwardsECP offers integrated capture, document imaging and workflow solutions to JD Edwards customers. Users have the ability to easily capture, route, store, and retrieve documents and images associated with transactions while managing the entire range of back-office processes from a single desktop. Our workflow solutions allow for automatic routing and distribution of documents. Users have a single point of access for all images and transactions. Users are more productive because they now have access to electronic data and scanned documents directly from JD Edwards without having to switch back and forth between applications.SAPECP provides complementary document imaging, document management and workflow solutions to SAP users worldwide. We seamlessly integrate with SAP to deliver digital versions of paper and other electronic documents associated with SAP transactions. Users have the ability to easily capture, route, store and retrieve documents and images associated with transactions while dynamically managing the entire range of back-office processes from a single desktop.