Initial_Requirements.xlsx
XLSX spreadsheet 24 KB Posted
- Attached to
- Risk Scorecard Software Implementation
- Solicitation number
- OPIC-18-R-0007
- Issued by
-
Overseas Private Investment Corporation
About this file
Initial Requirements Document
View the file
Other files
| File | Type | Posted |
|---|---|---|
| QA-_Part_3.pdf | ||
| QA-_Part_2.pdf | ||
| Bank_Scorecard_Template.pdf | ||
| QA_-_Part_1.pdf | ||
| Attachment_3-_Price.xlsx | XLSX spreadsheet | |
| Attachment_3-_Price.xlsx | XLSX spreadsheet | |
| Attachment_2-_OPIC_Terms_and_Conditions.pdf | ||
| Attachment_1_-_Statement_of_Work.pdf | ||
| SOW,_Attachment_1_NDA.pdf | ||
| OPIC-18-R-0007.pdf |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Sheet1
| Item# | CATEGORY | GENERAL REQUIREMENTS | CRITICALITY WEIGHT | CRITICALITY |
| 1 | Capability | Recreate existing scorecard templates in the system | 10 | Critical |
| 2 | Capability | Leverage, facilitate and/or manage existing scorecards for Banks, NBFI's, Hotels, Microfinance Institutions, Microfinance Investment Vehicles, Debt Funds, Project Finance, Construction/Real Estate and Manufacturing/Services | 10 | Critical |
| 3 | Capability | User has option of Creating New Scorecard from list of templates or Update Existing One | 10 | Critical |
| 4 | Capability | Enables user to update scorecard information without re-imputing data -copy and paste functionality from Insight, EBS Dashboard, Excel, Word etc. | 10 | Critical |
| 5 | Capability | In-house maintenance-->enhancements to existing scorecards (refinements to weights, calibration, etc.), creation of new scorecards (Funds) | 10 | Critical |
| 6 | Capability | Improves process traceability and transparency | 10 | Critical |
| 7 | Capability | Provides centralization of Credit Risk data and methodology | 10 | Critical |
| 8 | Capability | Provides improved data storage from existing MS Access capability, so that power users can easily access data (current & historical) for reporting and analysis. | 10 | Critical |
| 9 | Capability | Create a snapshot of the data used for producing a rating in both raw (pure data) and formatted (pdf, doc, xls or html) modes | 10 | Critical |
| 10 | Capability | Capability to manage the following period information: |
Period Type (YearEnd/Interim/Month), Period Closing Date (dd/mm/yyyy), Period Length (1-12 months), Period Occurrence (0-12), Statement Source (OPIC list),
| Statement Source Currency (List of cu | 10 | Critical | |||
| 11 | Capability | Allows modification to scorecard templates -add/delete/edit field and properties | 10 | Critical | |
| 12 | Capability | Assuming no linkages to OPIC's Spreading Application, ability to capture the formulas for financial ratios |
Durazzo, Yvonne: Durazzo, Yvonne:
The officer's are already used to calculating ratios directly in the excel model, so this part in red is a nice to have rather than critical. What is critical is to have the ability to input a ratio directly, calculate the NPV of the cash flow (in the PF model) and/or read off of Risk Analyst spreads. Question: is this the same as #17? The description alludes to reporting, but the comments seem to be similar, not sure if one has to do with actually being able to do calculations in the platform and the other has to do with calculations in the reports?
| Karen Segerstrom: we should at the very least capture the ratio's value (critical) and then, if possible (nice to have) capture the actual calculation so I have split these into 2 separate requirements | 9 | Nice to Have | |||
| 13 | Capability | Assuming no linkages to OPIC's Spreading Application, ability for user to input value derived from financial ratios calculated in other applications | 10 | Critical | |
| 14 | Capability | Capability to manage financial statements in the following time periods: year end, interim (i.e., 3, 6, 9 mos), and monthly (1 mo) | 10 | Critical | |
| 15 | Capability | Capability to compare prior period scoring to current period scoring of quantitative and qualitative factors, in side by side columns | 7 | Nice to Have | |
| 16 | Capability | Calculate peer data on a group of entities sharing similar criteria and/or use peer data for comparison or business rules | 10 | Critical | |
| 17 | Capability | Capability to manage worldwide entity locations | 6 | Nice to Have | |
| 18 | Capability | Capability to manage the borrower - obligor relationship | 6 | Nice to Have | |
| 19 | Capability | Manage covenants and monitor their performance over time with automated checks and covenant formulas | 5 | Nice to Have | |
| 20 | Cost | Implementation cost is manageable | 10 | Critical | |
| 21 | Cost | Annual maintenance and operational costs are manageable | 10 | Critical | |
| 22 | Historical Data | Extract data from the production environment and move it to a retention environment that will preserve all data older than 10 years based on OPIC retention policies | 10 | Critical | |
| 23 | Historical Data | Accommodate OPIC's data retention needs as defined through OPIC and Federal policies | 10 | Critical | |
| 24 | Historical Data | Data migration from current Access databases to the system for historical data management | 10 | Critical | |
| 25 | Historical Data | Data migration from current Access databases to the system is available for reporting | 10 | Critical | |
| 26 | Implementation | General timeframe for deployment is manageable/acceptable (i.e., Fall of 2018) | 10 | Critical | |
| 27 | Implementation | The web-based client or thick client solution is manageable | 10 | Critical | |
| 28 | Implementation | The server operating system is congruent or interfaces well with OPIC's existing architectural standards, O&M model and IT policy/processing | 10 | Critical | |
| 29 | Implementation | The system security is robust and fed-compliant | 10 | Critical | |
| 30 | Implementation | The system security is role-based and has clear visibility/access roles that are managed by the user/customer administrator | 10 | Critical | |
| 31 | Implementation | Information is accessed via robust controls | 10 | Critical | |
| 32 | Implementation | The implementation is vendor managed | 10 | Critical | |
| 33 | Implementation | The customer has the ability to weigh in heavily on the technical implementation of the solution | 10 | Critical | |
| 34 | Implementation | Uses single-sign-on to authenticate the user automatically | 10 | Critical | |
| 35 | Implementation | Manage 100-200 simultaneous users | 10 | Critical | |
| 36 | Implementation | Manage a total finance exposure of approximately $16B and approximately 300+ projects | 10 | Critical | |
| 37 | Implementation | Must meet federally regulated user interface standards | 10 | Critical | |
| 38 | Implementation | Implementation will follow OPICs Software Development Lifecycle (SDLC) standards | 10 | Critical | |
| 39 | Implementation | In-house maintenance via long-term vendor contract | 8 | Nice to Have | |
| 40 | Implementation | Mobile capabilities are offered | 8 | Nice to Have | |
| 41 | Implementation | The solution is cloud-based | 8 | Nice to Have | |
| 42 | Implementation | Lessons learned are captured from prior implementations and are accessible to OPIC as part of the RFP process | 8 | Nice to Have | |
| 43 | Integration | Insight will populate scorecard with Project ID#, Project Name, Country name, Project description, Loan amount, and Officer name | 10 | Critical | |
| 44 | Integration | Scorecards will interface with OPIC's Spreading Application | 10 | Critical | |
| 45 | Integration | Integrates well with OPIC shared drives | 10 | Critical | |
| 46 | Integration | Integrates well with OPICs general IT infrastructure to include storage and virtualization management | 10 | Critical | |
| 47 | Integration | Integrates well with Centrify for Single Sign-On (SSO) | 10 | Critical | |
| 48 | Integration | Integrates well with Windows Server 2008 and 2012 | 10 | Critical | |
| 49 | Integration | Integrates well with MS SQL Server 2008/2012 | 10 | Critical | |
| 50 | Integration | Interface mechanisms are supported (e.g., published/well documented web services, APIs, data model, data dictionary, etc.) | 10 | Critical | |
| 51 | Integration | Ability to manage OPIC's existing Finance portfolio of project types, project names, sector types etc. | 10 | Critical | |
| 52 | Integration | The application will effectively push data to Insight (and other Salesforce applications where appropriate) as needed | 8 | Nice to Have | |
| 53 | Integration | Integration is viable. Interface tools are used to push and/or pull data between your application and others | 8 | Nice to Have | |
| 54 | Integration | Integrates well with Tableau | 8 | Nice to Have | |
| 55 | Integration | Integrates well with Oracle EBS and LNS | 10 | Critical | |
| 56 | Integration | Integrates well with Oracle database and OBIEE | 10 | Critical | |
| 57 | Integration | Integrates well with MS Access - Country Ratings and Regulatory Environment databases | 10 | Critical | |
| 58 | Integration | Integrates well with SharePoint - i.e., document management, collaboration and limited document workflow capabilities | 8 | Nice to Have | |
| 59 | Integration | Integrates well with TRIM - i.e., record management | 8 | Nice to Have | |
| 60 | Integration | Integrates well with Salesforce | 10 | Critical | |
| 61 | Integration | Tools or integration touch points are easy to use | 8 | Nice to Have | |
| 62 | Integration | Tools or integration touch points are easy to manage | 8 | Nice to Have | |
| 63 | Integration | Display consolidated information from various data sources | 8 | Nice to Have | |
| 64 | Integration | Open a report screen seamlessly from another application (within a frame or popup window) | 8 | Nice to Have | |
| 65 | Reporting | Reporting capability on the Quantitative and Qualitative Factors within a single scorecard and across multiple scorecards | 10 | Critical | |
| 66 | Reporting | Scorecard information will be saved in a data warehouse (i.e., a Gov-approved facility - cloud-based or EBR, etc.) | 10 | Critical | |
| 67 | Reporting | Reporting capability on Scorecard Information is available | 10 | Critical | |
| 68 | Reporting | The reporting capability is offered as part of the solution | 10 | Critical | |
| 69 | Reporting | The reporting capability is a mixture of canned and ad hoc | 10 | Critical | |
| 70 | Reporting | Print out generated report(s) | 10 | Critical | |
| 71 | Reporting | Export generated report(s) | 10 | Critical | |
| 72 | Reporting | System data can be downloaded via PDF, Word and/or Excel formats | 10 | Critical | |
| 73 | Reporting | Reporting capability is available and linked to EBR, EBS, Insight for other, non-scorecard information (NAICS, Region, Sponsor, etc.) | 10 | Critical | |
| 74 | Reporting | The reporting capability is vendor-managed | 8 | Nice to Have | |
| 75 | Reporting | Power users can create reports | 8 | Nice to Have | |
| 76 | Reporting | Create own reports using a drag and drop interface | 8 | Nice to Have | |
| 77 | Reporting | Customize the display of specific report sections | 8 | Nice to Have | |
| 78 | Search | User can create/update scorecard by searching on: Scorecard ID#, Project ID#, Project Name, Type of Scorecard, Borrower, Status (pre or post-commitment), Country, Officer Name, etc. | 10 | Critical | |
| 79 | Security | Version control is available | 10 | Critical | |
| 80 | Security | Audit trail is available | 10 | Critical | |
| 81 | Security | Point in Process is available | 10 | Critical | |
| 82 | Workflow | Ability to manage rating processes executed at loan origination, commitment and at least once per year (or more frequent) following initial disbursement | 10 | Critical | |
| 83 | Workflow | Workflow capability (Origination) where the scorecard is pushed through Approvals: Line Officer-->Credit Policy--->Risk Management | 10 | Critical | |
| 84 | Workflow | Workflow capability (Monitoring) where the scorecard is pushed through Approvals: PMD Officer-->PMD Director-->Risk Management | 10 | Critical | |
| 85 | Workflow | Provide users with a task list showing their assigned work items based on the real-time status of all workflows | 8 | Nice to Have | |
| 86 | Workflow | Management of user task list(s) and associated notification capability | 8 | Nice to Have | |
| 87 | Workflow | Automatically process scorecard creation, input and management workflows throughout the scorecard lifecycle | 10 | Critical | |
| 88 | Workflow | Review, analyze and automate existing scorecard processing (i.e., recommend and implement process improvements where appropriate) | 10 | Critical | |
| 89 | Workflow | Provide ability to easily facilitate customizations and integrations | 8 | Nice to Have | |
| 90 | Workflow | Provide ability to adapt to changing and/or parallel processes | 8 | Nice to Have | |
| 91 | Workflow | Provide auditability and traceability for all processing actions | 10 | Critical | |
| 92 | Workflow | Provide a notification system to manage status, status updates, critical time lapsed per status(es) and/or other key metrics that facilitate scorecard processing and analytics | 8 | Nice to Have |
Sheet2
Sheet3
File details come from the government source that posted it.