Addendum No. 1 - QA and RFP Revisions .pdf

Legislative Appropriations System/Planning and Budgeting Subsystem (LAS/PBS) Data Application Migration

RFP No. EOG-RFP-23-01

Addendum No.1 Questions and Answers and RFP Revisions

Questions and Answers

The EOG has received the following questions through email, and the Agency’s answers are provided in the table listed below:

No. Question Answer

1. Is there anyway you can email me the SOW? I am having problems trying to access the documents. Please let me know.

Please refer to the solicitation documents, including all attachments, for further information:

https://vendor.myfloridamarketplace.com/search/bids/detail/1486

2. Good afternoon, can you help me with these Advertisement Numbers, how does this work?

Please refer to the solicitation documents, including all attachments, for further information:

https://vendor.myfloridamarketplace.com/search/bids/detail/1486

3. Whether companies from Outside USA can apply for this?

(like,from India or Canada)

See Section 5, Location of Work, Attachment, A, Scope of Services.

Conversion and migration work may be performed at the Contractor’s site but cannot be performed offshore. All data must remain in continental US (unless otherwise approved in accordance with 60GG-4 F.A.C.). The final product will reside in a cloud infrastructure.

4. Whether we need to come over there for meetings?

See Section 6, Reports and Meetings, Attachment A, Scope of Services.

At a minimum, weekly meetings between the Contractor and SDD should be conducted in person or via teleconference as dictated by the LAS/PBS contract manager. All meetings must include agenda and final minutes provided by the Contractor. Remote meeting software can be used. If proprietary software is used for meetings, the Contractor must supply licenses for SDD.

5. Can we perform the tasks (related to RFP) outside USA?

(like, from India or Canada)

See Section 5, Location of Work, Attachment, A, Scope of Services.

Conversion and migration work may be performed at the Contractor’s site but cannot be performed offshore. All data must remain in continental US (unless otherwise approved in accordance with 60GG-4 F.A.C.). The final product will reside in a cloud infrastructure.

6. Can we submit the proposals via email?

See Section 2.10, Proposal Submittal, of the RFP for submission instructions.

7. Are alternative cloud databases, not Oracle, acceptable?

No.

8. What new web technologies/langua ges can we use for the LAS/PBS Web application?

Preferences are VB.Net or C#.

https://vendor.myfloridamarketplace.com/search/bids/detail/1486 https://vendor.myfloridamarketplace.com/search/bids/detail/1486

9. RFP mentions that the migration should keep the existing key structures - does this mean that schema should not change?

See Section 3.1, Database, Attachment A, Scope of Services .

The Oracle relational design must keep the key structure from the LAS/PBS Adabas database. The key structure will maintain the unique identifier for each record in a file. The schema should remain as close as possible to the current structure but if needed, any changes to the schema would need to be approved by SDD.

10. RFP mentions about "columns" approach, can you elaborate on the "columns" approach? how the data owner is identified on each column?

Columns use the Adabas Periodic Group construct. This characteristic is the ability to maintain the order of the occurrences. If a periodic group originally contained three occurrences and the first or second occurrence is later deleted, those occurrences are set to nulls; the third occurrence remains in the third position.

Columns also identify the “Owner” of the data.

For example: A01 - “A” is the owner (Agency) and “01” is the index of the Periodic Group. The index can range from 01 – 99.

11. What is the existing database size that has to be converted?

See Section 3.1, Database, Attachment A, Scope of Services .

56GB for each instance of the LAS/PBS database (Prod, Test, Dev and Sandbox).

12. Approximate number of rows per table that have to be converted

There are approximately 20 million records average of 166 thousand per table.

13. How much data gets added each month, what is the expected growth rate of the database size

See Section 3.1, Database, Attachment A, Scope of Services.

We need to allow 5% data growth per year.

14. What is the expected user load on the application?

average user load and peak user load?

Concurrent users during peak demand is estimated at 150. During other times, the average is approximately 70 users.

15. What are the different types of users accessing the system? where are those user accounts maintained?

All users of LAS/PBS are maintained within the application. The roles are “Analysts” and “Master – systems administrator”. Each Analyst role is further restricted by the functions assigned to their operator security record which is based on components and transactions within the application.

16. Are we supposed to use the existing directory system or

We need more clarification of what this question means. If this refers to our existing network, then the answer is yes.

migrate to any other system?

17. What is the current level of performance and efficiency of the existing database?

An example of buffer efficiency for our Adabas database is there was 200 million logical reads and the database only made 108,344 associator and data reads.

18 What is the current level of performance and efficiency of the existing application?

The average response time is currently 1 second or less for online transactions and 2 – 10 seconds for batch processes.

19. What is the RTO/RPO expected for DR?

The mainframe RTO/RPO is 1 hour. However, the remaining work that needs to be done is 4 hours.

20. Can you share the DR architecture of current system?

Not at this time, not applicable.

21. Are we supposed to use existing service for email, pdf, word, excel generation? or provide our own solution for these?

Vendor can propose new solution(s) or use existing. LAS/PBS uses PDFBox to create PDF’s which will need to be replaced. LAS/PBS uses SoftArtisans to create excel spreadsheets and word documents.

22. Is there any existing framework service for logging, auditing and exception handling that the converted system should leverage?

Should use existing framework provided by Oracle and Windows.

23. How is access management implemented in the current system?

does the converted code handle it implicitly or we are supposed to propose our own solution separate from code conversion

The converted code should handle the application access as stated in the Scope of Services, Section 3.5.3 Application Security.

24. Is there a need for proposing a separate solution?

Not at this time.

25. Any caching solution used in current application? does the converted solution use the same? or we are

The solution should leverage Oracle and Windows Server technologies, however Vendor may propose options.

supposed to propose our own?

26. How many batch jobs are there in the current solution, how long they run and what are their schedules?

LAS/PBS is comprised of on/line data entry and viewing of data and batch reports. There are approximately 75 transactions that create batch reports that can be run at anytime of the day by the users with most reports completing in a matter of seconds.

There are approximately 20 nightly batch jobs.

27. Do we need to include a separate batch processing solution along with the converted code?

Yes, a batch scheduling process needs to be proposed.

28. Does the current solution have any monitoring solution in place? should we propose one for this

RFP?

LAS/PBS mainframe currently includes a real-time monitoring solution (Scope of Services section 3.7 LAS/PBS Software Environment).

Vendor can propose a new solution.

29. Can you share the current network architecture of the application?

Please see Exhibit 2 to Addendum No. 1, LASPBS Network.

30. Is there a need for any site-to-site connectivity incase we propose a cloud based implementation?

Need more clarification.

31. What is the size/complexity of the application in terms of Lines of Code? Please provide a break up of number of Lines of Code for:

a. Natural Programs

b. Sub programs

c. Help Routines

d. Maps

e. COBOL

f. Copybooks

g. JCLs

h. PROCs

Refer to Scope of Services section 3.7 LAS/PBS Software Environment.

• 1.5 million lines of Natural code;

• Total of 2,196 Natural programs;

• Total of 740 Natural subprograms;

• Total of 237 Help Routines;

• Total of 1,240 Help Maps;

• Total of 876 Maps;

• Total of 23 Local Data Areas and 3 Global Data Areas;

• Total of 269 Copy Codes;

• Total of 337 Natural Libraries;

• Total of 265 Cobol objects;

• Total of 166 Copy Books;

• Total of 1,002 production JCL members;

• Approximately 50-70 procs in use.

32. Please confirm if we can assume all Jobs/CICS/Program s are active?

Yes.

33. Please confirm if we can assume all latest source code is available and there are no missing source codes?

Yes.

34. Please elaborate if there are any performance challenges in system

AS-IS?

There are no performance issues in the current system.

35. Please confirm if there are any Assembler, REXX, CLIST etc in use?

What other Mainframe tech is in use? Please provide counts and Lines of Codes for each.

See Section 3.7, LAS/PBS Software Environment, Attachment A, Scope of Services.

This includes software that is used within the IBM mainframe environment. Counts of lines and codes for the IBM z/OS features and utilities are not available.

36. Please confirm if there are any reporting/printing mechanisms in place that needs to be migrated?

LAS/PBS creates reports in PDF’s and spreadsheets and Word documents and sends PDF’s to users’ email accounts. This will all need to function in the converted application.

37. Is every application on Mainframe being migrated? Will there be any residual applications on Mainframe that would need access to files/database from migrated environment?

No. LAS/PBS application is self-contained on mainframe.

38. Apart from the interfaces to other State systems, are there any

FTP/SFTP/MQ/XCO

M/EMAIL

connectivity (in any direction) from the current applications to any internal/external interfaces? How many such

No. See Section 3.5.6, Other Processes, Attachment A, Scope of Services to see current interfaces.

interfaces are there in total?

39. Please confirm if there is a preferred cloud provider?

No.

40. Please provide counts of PREDICT rules to be converted. Can the free rules be provided for review?

Please see Exhibit 1 to Addendum No.1, LASPBS Objects EADR BDDR & Rules.

The estimated number of rules to be considered in the conversion is 40.

41. Please confirm if there are VSAM files in use? Are NATURAL programs accessing VSAM files? (if yes, specify # of programs with access & number of VSAM files and their sizes)

There are no VSAM files in use.

42. Please confirm if IMS is in use? Are NATURAL programs accessing IMS? (if yes, specify # of programs with access & count and size of IMS)

IMS is not in use.

43. Please confirm if DB2 is in use? Are NATURAL programs accessing DB2? (if yes, specify # of programs with access & count and size of DB2 tables in use)

There are no DB2 databases included or integrated with LAS/PBS application.

44. Please confirm if there is any access to System files

(FNAT, FUSER,)

from the application?

(if yes, please specify # of programs with access)

No, the application / source code does not reference these.

45. Please confirm if there is any use of NATRJE in

Yes, NATRJE is used. Approximately 115 programs.

programs? (if yes, specify # of programs with NATRJE usage)

46. Please confirm if Natural Security is used(any use of NATURAL security user exits in the applications?)

No. Natural Security is not used.

47. Please confirm if any NATURAL User Exits in programs are used? (if yes, specify # of programs)

None.

48. Please provide count of ,NATURAL Entities generated by NATURAL Construct? (specify number)

Natural Construct is not used.

49. Please confirm if there is existence of in line NATURAL code in the JCLs

No. We do not have any in line Natural coding in our production JCLs.

50. Please confirm if any ADABAS utilities are used in JCLs

Yes, backup jobs use ADABAS utilities.

51. Please confirm the count of COBOL programs accessing below ADABAS in

ONLINE & BATCH

i. ADASQL

ii. ADAPREP

iii. Direct Commands

iv. Any Other

Most COBOL programs use direct command/calls to ADABAS. We do not use ADASQL or ADAPREP.

52. Please confirm Number of JCL steps activating

NATURAL

Most production JCLs log into Natural and run programs.

53. Please confirm Number of JCL steps activating ADABAS utilities

Our ADABAS production backup jobs activate ADABAS utilites (approximately 8-10 steps).

54. Please specify % of structured mode vs.

% of reporting mode of NATURAL

There is approximately 60% Reporting vs 40% Structured mode.

55. Please specify number of Batch vs.

Online vs. Used in both entities for

NATURAL

LAS/PBS is comprised of online data entry and viewing of data and batch reports. For the LAS/PBS application, there are approximately 27 mainframe online transactions and 67 batch reporting transactions (each involves between 10 – 20 objects). For the LAS/PBS Web application, there are approximately 80 online transactions and 90 batch reporting transactions where the web calls to the mainframe will need to be converted. There are approximately 20 nightly batch jobs.

56. In Section 3 of the 'Attachment A', it is mentioned that Database needs to be converted first.

Please elaborate this. Is it expected that DB is converted and migrated to Prod first and the application conversion is expected to happen in the next phase?

The database structure must be approved first to understand how the uniqueness and challenges of ADABAS is being converted. The data will then need to be converted based on the new structure and all data in the database must be verified that it matches the current database. The new Oracle database will not be promoted to the Production environment for use until the end of the project.

57. Please provide an indication in terms of % how many modules/objects will be changed during a 6month period in a typical year?

Internally, limited changes will be made to LAS/PBS during this time.

Externally, LAS/PBS is waiting for the PALM project to resume which will increase the number of objects.

58. How many ADABAS MU/GE? Please confirm the count of MU(multiple elements).

There are approximately 60 files that have MU/PE where each file could have more than one MU/PE.

59. Please provide various types and number of utilities in use:

a. IBM utilities

b. In house utilities

c. 3rd party utilities

Refer to Sections 3.6 LAS/PBS Hardware Environment and 3.7 LAS/PBS Software Environment. Attachment A, Scope of Services. There is a list of all software currently in use.

60. Please provide Count of FOCUS components and Lines of Code

There is one feature of LAS/PBS that uses FOCUS within 3 Natural objects.

61. Please provide Count of PROCs used in JCLs and their Lines of Code

There are approximately 50 – 70 procs in use, each with approximately 30 – 50 lines of code.

62. We are assuming that GDG files will be migrated as-is.

Please confirm if this is fine.

GDG files are not to be migrated.

63. What is the scheduler in the non-mainframe environment? Do you have a preference to use the same Scheduler in the Target state?

We are looking for proposals for the scheduling solution. Possibly leverage current Windows solution(s).

64. Please confirm if there is a preferred software security solution

There is no preferred software security solution. However, The converted code should handle the application access as stated in the Scope of Services, Section 3.5.3 Application Security.

65. Can you confirm that the counts of existing databases and objects are refer to production environment?

If not please specify which additional environments will be included and what portion of these counts is related to production.

The database and object counts are production.

66. What is the current framework for organizing LAS/PBS transactions in Natural? Is it substantially different than the framework in LAS/PBS Web?

Need more clarification. The LAS/PBS Web framework is already established. Any mainframe screen map to be converted currently has a location identified in LAS/PBS Web and corresponding Oracle database entry.

67. Please confirm that the target integrations with

FLAIR/PALM,

People First, AMTRK, SUS and BAPS can be achieved by sending or receiving files using FTP/SFTP.

68. What improvements is the agency seeking to the platform and software technologies, other than having a unified web-based application?

None.

69. Does the agency prefer an on-premise deployment or cloud deployment of the target solution?

No preference.

70. Does the agency have a preferred cloud target, for example Oracle Cloud (OCI), Amazon (AWS), Google (GCP) or Microsoft (Azure)?

No preference.

71. How many modules and total lines of code are in LAS/PBS for each of the following languages/ componennts:

6.1.Mainframe

6.1.1 Natural

6.1.2 Natural maps

6.1.3 COBOL

6.1.4 JCL

6.1.5 ADABAS

Files

6.1.6 ADABAS

File/Data Definition Modules

(DDM)

• The ADABAS database has 120 tables and ddms;

• There are approximately 20 million records in the entire database;

• 1.5 million lines of Natural code;

• Total of 2,196 Natural programs;

• Total of 740 Natural subprograms;

• Total of 237 Help Routines;

• Total of 876 Maps;

• Total of 269 Copy Codes;

• Total of 265 Cobol objects;

• Total of 166 Copy Books;

• Total of 1,002 production JCL members;

• Approximately 2,000+ Web/VB.Net/HTML/ASP/CSS objects;

• Average 15,000 – 20,000 lines per page;

• Approximately 65 Oracle tables;

• Approximately 30 stored procs/packages.

6.2 Web

6.2.1 VB.Net

6.2.2 HTML

6.2.3 ASP

6.2.4 CSS

6.2.5 Oracle Table

(count)

6.2.6 Oracle Stored

Procedures

6.2.7 Oracle DDL

(lines of codes)

72. Does the web application use EntireX to query data from the mainframe application or does it only transfer data sets from the mainframe as files using FTP/SFTP? If it does use EntireX directly, how many distinct transactions are coded?

The current LAS/PBS web application uses EntireX to send/receive data sets and does not use FTP/SFTP. There are over 250 transactions in the LAS/PBS application.

73. Do you have time frame for the Digital transformation & application Modernization?

Timeline is based on Vendor responses.

74. How much budget is allocated for this program?

Budget and timeline are based on Vendor responses/proposals.

Currently, a 2 million dollar budget has been allocated for this project.

75. What is your preferred cloud provider for the target platform?

No preference.

76. Are you open for Lift & shift strategy and then transforming

No preference.

applications as this reduces the business down time?

77. Do you have a clear vision of the future and where your applications will live?

The vision is for LAS/PBS to reside in a cloud environment.

78. Do you have resources for managing the new platform?

Yes.

79. Is there a particular reason for going to Oracle database?

As there are more efficient native databases on the cloud

We have an established Oracle footprint with in-house expertise.

80. Are these applications feeding into any other systems or fed from other systems?

Yes. Refer to Section 3.4, Application Framework, Attachment A, Scope of Services.

(FLAIR/PALM, People First, AMTRK, SUS and BAPS).

81. What is the strategy preferred application for future use?

Need clarification.

82. Who maintains the applications and platform?

Currently, Department of Financial Services maintains the mainframe.

LAS/PBS has in-house DBAs and Network administrators. Future state is that LAS/PBS application will be maintained by SDD staff.

83. How many MIPS are consumed by the production environment out of the total capacity of

1193 MIPS?

Per DFS mainframe statistics, LAS/PBS MIPS usage is 62.

84. What are the preferred programming languages for restructuring Natural programs?

The preferred language is VB.Net or C#.

85. Section 3.4.2 – Are web-based

Angular/HTML5/CS S screens (with identical mainframe map functionality) an acceptable solution for the converted Natural Maps?

86. Section 3.5.1-3.5.5 – Application security mapping – does the security tables and its functionality described all currently exist within the application code or do some of these constitute new security mapping requirements?

All LAS/PBS security functionality exists in code.

87. What version and release of Oracle database software is currently used by VB.NET application?

The current production version of Oracle is 19C.

88. We understand the agency wants new LAS/PBS application to run on Windows Server. Is C#.NET preferred target language for translation the mainframe source code of the LAS/PBS application given Microsoft is no longer evolving VB.NET? If not, please specify the target language for the mainframe source code.

The preferred language is VB.Net or C#.

89. How does LAS/PBS VB.NET application communicate with EntireX? For example, does this use web services (XML/SOAP)? Also, please provide

The current LAS/PBS web application uses EntireX to send/receive data sets using web services. There are over 250 transactions in the LAS/PBS application and over 2000 objects in the VB.Net LAS/PBS project.

approximate number of web services between VB.NET and EntireX.

90. What version and release of Entire X is being used? Also, is this hosted on Windows?

The current version of EntireX is 10.5 and is running on mainframe and Windows servers.

91. What is the approximate number of lines of code for Natural and COBOL (programs and other associated objects) in LAS/PBS system that will need to be migrated? We appreciate information in the RFP in terms of number of programs, however, to more accurately estimate scope and effort, we request the agency to provide approximate number of lines of code for Natural and COBOL.

There is approximately 1.5 million lines of Natural and COBOL code.

92. What is the number of VB.Net objects in LAS/PBS that will require modifications to update the mainframe calls via EntireX, in order to access the converted data in the new RDBMS? If possible, please provide the number of mainframe calls in the VB.Net code.

There are approximately 350 objects on the mainframe that the LAS/PBS web application calls.

93. Does LAS/PBS consist of Report Mode or Structured Mode for Natural? If both are in use, please provide an

There is approximately 60% Reporting vs 40% Structured mode Natural code to be converted.

approximate split between Report and Structure modes.

94. Is there a portion of Natural and/or COBOL source code currently in system but no longer in use in the mainframe production environment? If so, please specify an approximate amount of source code no longer in use.

All code provided will be active and in scope for conversion.

95. Is the agency asking for plan only from Contractor for One Year Post Implementation Support and Maintenance OR plan and services to provide support and maintenance for one year? This question is about section

4.5.1 in Attachment A - Scope of Services.

The Agency is requesting a plan and services to provide support and maintenance for one year.

96. How many user screens in LAS/PBS Mainframe system?

There are approximately 120 screens that will need to be converted.

97. Page 24 of Attachment A - Scope of Services says "1,002 production JCL members", how many batch programs or batch jobs are currently scheduled to run in LAS/PBS mainframe system?

There are approximately 20 nightly batch jobs.

LAS/PBS is comprised of online data entry and viewing of data and batch reports. For the LAS/PBS application, there are approximately 27 mainframe online transactions and 67 batch reporting transactions (each involves between 10 – 20 objects). For the LAS/PBS Web application, there are approximately 80 online transactions and 90 batch reporting transactions where the web calls to the mainframe will need to be converted.

98. There is inconsistency between Section

2.19 Order of

Precedence of the

Please see RFP Revision 1, below and Attachment F, Revised Draft Contract.

RFP and Section 1.C Order of Precedence of the Draft Contract. Will the Agency please clarify that the RFP Order of Precedence applies and not the Draft Contract?

Otherwise, will the Agency be open to discussing inconsistencies in the Draft Contract after award?

The RFP Order of Precedence applies during the solicitation phase. The Order of Precedence in Attachment F, Revised Draft Contract, will apply once the contract has been executed.

99. In Attachment F Section 3.A (Time is of the Essence) is unusual for a technology project as requested in the RFP. Our experience indicates that the focus should be on key project milestones and those should be met unless there is mutual agreement to change any of those key project milestones. Will the Agency consider changing the language in 3.A to focus on key project milestones and not each and every obligation in the Contract?

Please see Attachment F, Revised Draft Contract.

100. In Attachment A, Section 10 Deliverables, Performance Standards, and Financial Consequences, we request that the Agency put a commercially reasonable limitation

Since the financial consequences are deliverable based and fees are not fixed per year, this request cannot be accomodated.

on the Financial Consequences of 10% of fees per year.

101.

In Attachment F, Section 9. C Copyright, Patent and Trademark, will the Agency please confirm that Contractor will retain all rights in its pre-existing intellectual property and its derivatives used in the performance of this Agreement?

See Section ( 9.D.), Copyright, Patent, and Trademark, Attachment F, Revised Draft Contract.

Within thirty days (30) of execution of this Agreement, the Contractor must disclose all intellectual properties relevant to the performance of this Agreement which he or she knows or should know could give rise to a patent or copyright. The Contractor will retain all rights and entitlements to any pre-existing intellectual property which is disclosed.

102. What is the current interface type to transfer data between LAS/PBS and FLAIR/PALM, People First, AMTRK, SUS and

BAPS?

Currently the integration with those systems are sending or receiving files using FTP/SFTP.

103. We understand the agency wants new migrated LAS/PBS application to be hosted on cloud.

Does existing

LAS/PBS VB.NET

application continue to reside on on-premise servers?

No, it should all reside in clould.

104. Does LAS/PBS and/or other in-scope applications use "Screen scrapping" for data exchange or extracting data for generating reports?

No.

105. In section 3.5.1.

(Application Security) is stated that the LAS/PBS application has three levels of security:

"Operator (role), This is stored in ADABAS security tables not RACF.

Column, and Budget Entity. These security levels function within the application and are used in conjunction with each other throughout the application". Can the State confirm if the Operator (role), Column security, Budget Entity security are defined in the RACF system or if these are stored in ADABAS security tables?

106. In section 3.5.1.

(Application Security) can the State confirm where the audit logs are maintained? For example, are these maintained in the application ADABAS database or are these maintained in

RACF?

They are stored in ADABAS file not RACF.

107. Can the State confirm the current user authentication process for the LAS/PBS Web application?

The user must have a UserID in the system. Currently we do not have two-step authentication.

108. Will you share a copy of the source code with the bidders?

Source will be shared with the awarded Vendor.

109. If the DFS Mainframe is to begin decommissioning in 2024, when will it be fully decommissioned and when does the new application

Undetermined at this time.

need to be completed?

110. Will the single web-based solution be integrated with the existing LAS/PBS Web, or a combination of a new server-based solution that will integrate with LAS/PBS Web?

It will be intergrated so the user only goes to one application.

111. What is the Agency Cyber Security Plan?

SDD follows FLDS cyber security plans.

112. Is private cloud allowed, or an option?

No preference.

113. Are there latency or other non-functional requirements (NFRs) for any of the applications they integrate with? For example:

• Latency and

NFRs within the app itself

• Latency and other NFRs between the app and other state apps

No known latency issues.

114. If better options are available, can they be incorporated rather than leveraging LAS/PBS Web email, pdf, and other services, even if it means changing LAS/PBS web to those?

Will consider all proposals.

115. Is reporting available for current application utilization, such as CP3000 or SCRT?

We currently use Treehouse TRIM for database and CICS/application statistics and utilization.

116. What percentage of utilization does this application consume of the overall mainframe?

Per DFS mainframe statistics, LAS/PBS MIPS usage is 62.

117. Estimated lines of code, complexity?

Any common routines in a concatenated library? Any extensible arrays, independent variables, or other Natural version 8 constructs?

There are approximately 1.5 million lines of code. We do not use Natural Construct. However, we use dynamic variables within Natural objects.

118. Once LAS/PBS application is converted and residing on modern platform technologies (public cloud), is the desire for the bidder to provide fully managed services for support and enhancement of application, or co-manage services with the SDD team?

No.

119. As part of the DR requirement, how many DR tests are needed in a calendar year? What is the expected duration of those tests?

Currently we run 1 test per year for 1 week with DFS.

120. Is there a preference for the region for

DR?

No.

121. How should the bidder provide requests for exceptions or other modifications to the

See Section 2.10 (C.), Proposal Submittal, of the RFP.

The Respondent objects to and should not consider any additional terms or conditions submitted by a respondent, including any appearing in documents attached as part of a Respondent’s response. In submitting terms and conditions in the Draft Contract?

its response, a Respondent agrees that any additional terms or conditions, whether submitted intentionally or inadvertently, shall have no force or effect.

122. If Public Cloud is the desired destination, who is the preferred Public Cloud provider?

There are no preferences.

123. Is Oracle a firm requirement, or will EOG consider other database options? If Oracle is required, please describe the current licensing agreement and any size restrictions

Oracle is a firm requirement. Licensing of Oracle for other supported applications are provided by the cloud vendor and billed to LAS/PBS.

124. Is there a target preference between C#.NET, java, or VB.Net?

Preferences are VB.Net or C#.

125. Can a vendor provide its own primary proposal and concurrently be a subcontractor or partner on another vendor's proposal?

Yes. See 2.13 (A.3.), Scoring and Evaluation, of the RFP.

Proposals may be rejected if more than one proposal is received from a Respondent. Such duplicate interest may cause the rejection of all proposals in which such Respondent has participated. Subcontractors may appear in more than one proposal.

126. Does EOG have any modernization goals beyond decommissioning the mainframe?

No.

127. P.8, 2.10 Proposal Submittal, A.1. Please confirm/clarify that the State wants 7 copies of the Technical Proposal and 7 copies of Cost Sheet.

The Agency is requesting seven (7) technical proposal copies and one cost sheet per proposal. Six (6) additional copies of the Cost Sheet is not necessary.

128. P.8, 2.10 Proposal Submittal, A. 2 “scanned” copies. We assume searchable PDF will be acceptable for this requirement. Please confirm.

Yes. Searchable PDF will be acceptable.

129. Please identify where in the proposal to include the Certification of a Drug-Free Workplace and the letter from surety company.

The Certification of a Drug-Free Workplace Form and the letter from a surety company can be included in Tab A of the Technical Proposal.

Placement of the forms will not effect the responsiveness of the proposal.

130. Deliverable 17 (p.

25) is a full year of maintenance after all other work is complete. Please confirm/clarify whether this must occur within the two-year contract period.

Deliverable 17 will occur after Deliverables 1 through 16 have been completed. Deliverables 1-16 will occur within the two-year contract period. Deliverable 17 will occur after the two-year contract period.

131. How many datasets are moved and on what schedule?

“Datasets are moved from the mainframe to the web servers via FTP/SFTP.”

The nightly batch jobs create and move datasets to windows servers using FTP/SFTP. There are also many datasets that are creates on demand via transactions and then transferred.

132. In terms of disaster recovery Return to Operations (RTO), what is the desired time duration?

The mainframe RTO/RPO is 1 hour. However, the remaining work that needs to be done is 4 hours.

133. What information will be contained in and in what format?

“..transaction requirements will be provided to the Contractor by SDD”

These are functional requirements in Word/PDF format.

134. 3.2.3. The application development and test environments should mirror the

Production and Test must mirror each other. Development and Test can be smaller. All environments must use same versions of software.

production environment. Does this include data volume as well as

HW/SW/OS?

135. How many concurrent users are estimated for the completed solution during the high demand of the annual budget cycle?

Concurrent users during peak demand is estimated at 150.

136. Please describe the current process for adding/modifying/del eting Codes and Titles. Will the same process be used in the converted solution?

The same pocess will be in place. Codes are added or modified by a limited number of users.

137. Does the current solution allow for physical deletion of data? If so, what is the process.

Yes. Users can delete data as needed. SDD performs a yearly process to delete old data as well.

138. For all Downloads and Uploads – please provide the file layouts

Most files that are uploaded or downloaded are in fixed format non-encrypted.

139. For all Reports – please provide the report layouts and the reporting language/code.

Please also quantify Natural reports as online versus batch?

Report layouts will be provided in the requirements. The reports have been standardized as well. LAS/PBS is comprised of on/line data entry and viewing of data and batch reports. There are approximately 75 transactions that create batch reports that can be run at anytime of the day by the users with most reports completing in a matter of seconds.

140. Does SDD have a preferred automated testing tool?

We use MS Azure.

141. 4.2.2 Solution Design RFP States Contractor shall “make no changes to functionality or screen design.” Isn’t the Contractor responsible for making changes to

The intent is that the application will be converted not changing functional requirements. SDD will maintain all emergency changes during the conversion project and provide to Vendor to retrofit.

the converted solution for those changes that occur in the current production solution during the course of the project?

a. “Solution and strategy for remediating changed LAS/PBS application code occurring throughout the project timeline into the new converted LAS/PBS application;”

142. SDD will be modifying the legacy application throughout this period. Please describe (quantity, complexity) the application coding changes that occur during a normal fiscal year.

The intent is that the application will be converted not changing functional requirements. SDD will maintain all emergency changes during the conversion project and provide to Vendor to retrofit.

143. How many users by role will require training? Functional and Technical?

The training required will be for SDD developers during code walk through. SDD currently has 7 developers.

144. Please confirm all training documentation and operations manuals may be delivered electronically.

Yes.

145. Please provide a list of the last 12 months data quality defects that have been corrected.

None.

146. For Production Go- Live how much downtime will be allotted for LAS/PBS to be offline to users?

Vendor to provide estimate. 1 – 2 days worst case.

147. Please provide an annual calendar for peak periods for the Post Implementation Support and Maintenance

Peak seasons are:

• Start Up peak June and July;

• Agency Legislative Budget Requests during September and

October;

• Governor’s Recommendations November or January depending upon start of session;

• Session begins in January on even years (e.g. 2022) and in

March on odd years (e.g. 2023) and lasts for 60 days;

• Session can last longer if needed/special extension.

148. What Remote meeting software is currently used?

GoTo Meetings or Teams.

149. The RFP requires a cloud-based application and environments. Does the State require a specific cloud host (AWS, Azure, Google Cloud, etc.)?

No preferences.

150. Please identify any code conversion tools that the State has researched in planning this project.

None.

151. Please provide the current budget for this project

Budget and timeline are based on Vendor responses/proposals.

Currently, a 2 million dollar budget has been allocated for this project.

152. Please confirm/clarify whether the FBI Level II background check is required for the vendor’s staff.

A background check is required based on EOG’s employment standards.

153. Will EOG or Agency assign a Governance or PMO team to the essential LAS/PBS data application project?

Yes.

154. Where is the backup/disaster recovery system for the LAS/PBS data application located?

The DR site is off site adhering to COOP standards.

155. For the LAS/PBS data application migration is there a ‘Cloud First’ strategy? If so, is it a financial decision that is beyond the scope of this migration process, i.e.

moving from 1 cloud to anther?

The vision is for LAS/PBS to reside in a cloud environment with a one-time migration/conversion effort.

156. The backup/disaster recovery systems for the LAS/PBS data application, does EOG or Agency currently leverage a cloud-based system? If so, what cloud-based system?

No.

157. Is your preferred migration target language C# or Java?

The preferred languages are VB.Net or C#.

158. Will the vendor be expected to follow the EOG or Agency Governance or PMO team managing the LAS/PBS data application project?

Yes.

159. Is there more than

1 ADABAS

Logical Structure?

No.

160. Is ADABAS Accessed from

COBOL?

Yes.

161. % Natural Code in Reporting Mode?

There is approximately 60% Reporting vs 40% Structured mode Natural objects to be converted.

162. % Natural Code in Structured Mode?

There is approximately 60% Reporting vs 40% Structured mode Natural objects to be converted.

163. % Natural Code Online?

LAS/PBS is comprised of online data entry and viewing of data and batch reports. For the LAS/PBS application, there are approximately 27 mainframe online transactions and 67 batch reporting transactions (each involves between 10 – 20 objects). For the LAS/PBS Web application, there are approximately 80 online transactions and 90 batch reporting

164. % Natural Code Batch?

LAS/PBS is comprised of online data entry and viewing of data and batch reports. For the LAS/PBS application, there are approximately 27 mainframe online transactions and 67 batch reporting transactions (each involves between 10 – 20 objects). For the LAS/PBS Web application, there are approximately 80 online transactions and 90 batch reporting

165. Are code generators in use for JCL, Natural or

COBOL?

No.

166. Is there significant generation of JCL, Natural or COBOL at runtime (this includes use of NATRJE that was mentioned, Natural RUN, …)?

Yes. There are Natural programs which build JCL to run.

167. Can you confirm the Natural library count being 337?

Confirmed.

168. Adabas: are there MU and/or PE fields with more than 191 occurrences?

No.

169. Adabas: are occurring super descriptors being used?

Yes.

170. Adabas: are phonetic or hyper descriptors being used?

No.

171. Can a detail infrastructure component inventory be provided?

Need clarification.

172. Is there a reason why the LAS/PBS application needs to be converted in stages (with Adabas database and LAS/PBS Web Oracle database being first)?

To ensure the database redesign meets our expectations and passes data verification/validation before testing converted application.

173. If database conversion is the first stage, is there then only one more stage after that, i.e.

2 stages, in total?

The database conversion is the first stage. After that the application code conversion can be done and will be tested in stages.

174. Given Oracle database target, which LDAP solution is required, e.g.

Oracle Unified Directory (OUD), Microsoft ADS, or other?

We use a MS solution.

175. Is it the requirement or would it be acceptable to convert SAG Natural to COBOL?

No.

176. Can you provide a rough breakdown of online vs batch programs in % or actual numbers?

LAS/PBS is comprised of online data entry and viewing of data and batch reports. For the LAS/PBS application, there are approximately 27 mainframe online transactions and 67 batch reporting transactions (each involves between 10 – 20 objects). For the LAS/PBS Web application, there are approximately 80 online transactions and 90 batch reporting

177. Can you provide program (and lines of code if available) volumes breakdown of COBOL and Natural?

See Section 3.7, LAS/PBS Software Environment, Attachment A, Scope of Services.

• 1.5 million lines of Natural and COBOL code;

• Total of 2,196 Natural programs;

• Total of 740 Natural subprograms;

• Total of 237 Help Routines;

• Total of 1,240 Help Maps;

• Total of 876 Maps;

• Total of 23 Local Data Areas and 3 Global Data Areas;

• Total of 269 Copy Codes;

• Total of 337 Natural Libraries;

• Total of 265 Cobol objects;

• Total of 166 Copy Books;

• Total of 1,002 production JCL members;

• Approximately 50-70 procs in use.

178. Is your preferred migration target language C# or Java?

The preferred languages are VB.Net or C#.

179. Is there more than 1 ADABAS Logical Structure?

No.

180. Is ADABAS Accessed from

COBOL?

Yes.

181. % Natural Code in Reporting Mode?

There is approximately 60% Reporting vs 40% Structured mode Natural objects to be converted.

182. % Natural Code in Structured Mode?

There is approximately 60% Reporting vs 40% Structured mode Natural objects to be converted.

183. % Natural Code Online?

LAS/PBS is comprised of online data entry and viewing of data and batch reports. For the LAS/PBS application, there are approximately 27 mainframe online transactions and 67 batch reporting transactions (each involves between 10 – 20 objects). For the LAS/PBS Web application, there are approximately 80 online transactions and 90 batch reporting

184. % Natural Code Batch?

LAS/PBS is comprised of online data entry and viewing of data and batch reports. For the LAS/PBS application, there are approximately 27 mainframe online transactions and 67 batch reporting transactions (each involves between 10 – 20 objects). For the LAS/PBS Web application, there are approximately 80 online transactions and 90 batch reporting

185. Are code generators in use for JCL, Natural or COBOL?

No.

186. Is there significant generation of JCL, Natural or COBOL at runtime (this includes use of NATRJE that was mentioned, Natural

RUN, …)?

Yes. There are Natural programs which build JCL to run.

187. Can you confirm the Natural library count being 337?

Confirmed.

188. Adabas: are there MU and/or PE fields with more than 191 occurrences?

No.

189. Adabas: are occurring super descriptors being used?

Yes.

190. Adabas: are phonetic or hyper descriptors being used?

No.

191. May additional subcontractors be added after an award is issued if deemed necessary by the scope of work?

Yes. See Section 13(F.), Employees, Assignment, and Subcontractors, Attachment F, Revised Draft Contract.

Subcontractors must be approved in writing. The Contractor is fully responsible for satisfactory completion of all subcontracted work.

192. What are the lines of code by language for all languages in scope?

There is approximately 1.5 million lines of Natural and COBOL code.

193. How many tables and elements are in each database?

There are 120 tables in the production ADABAS database. Each table can have from 20 to 100 elements.

194. Can you produce a list of External calls?

(Support libraries, System Utilities, etc.?)

There are many support libraries and utilities in use by the LAS/PBS mainframe application.

195. If the state can’t provide the above details, will we have an opportunity to analyze the application code base ourselves at some point in the response?

Yes. SDD can provide a representative sample of application code.

196. Would FL EOG consider alternative database platforms other than Oracle?

No.

197. Does FL EOG have an existing cloud deployment today (AWS/Azure/GCP/et c.)? If so, can details around current architectures be provided such as account/subscription structure and

Please see Exhibit 2 to Addendum No.1, LASPBS Network.

EOG currently has a single application located in the cloud. The application is written in VB.Net and Oracle database.

network architecture?

198. Due to the complexity of the system and two week period for viewing posted EOG responses, will FL EOG consider extending the RFP due date?

Please see Addendum No. 2, Timeline Revision.

199. As only one week was given for Respondents to formulate questions, can FL EOG include an additional question period due to the complexity of the system?

One question and answer period is scheduled for this RFP which is listed in the timeline of the RFP.

200. Does the current environment have sufficient bandwidth to support a migration? Please provide current network connectivity requirements.

As stated in Attachment A, Scope of Services, there is a need to determine and propose the solution to ensure there is sufficient bandwith for this conversion and implementation. This may not be finalized until the Vendor has been selected and project commenced. LAS/PBS access is the internet via a 500MB to the State MAN.

201. What type of connectivity is required into each application environment? RDP?

Bastion? VPN routing? Shared services?

For remote access, we currently use VPN.

202. Are there any non-standard/advanced connectivity/configur ation requirements in the current environments that would need special consideration during migration?

No.

203. What application SLAs exist that would need to be taken into account?

There are no SLAs for LAS/PBS.

204. Are you using any managed backup process/service?

Please detail your current backup and recovery implementation and any requirements for cloud implementation

No backup service is being used.

205. What RPO and RTO are required for the application after migration?

The mainframe RTO/RPO is 1 hour. However, the remaining work that needs to be done is 4 hours. We are expecting similar or better RTO/RPO after migration.

206. Does FL EOG expect that post implementation support to include the Cloud infrastructure monitoring and operations of the application post-migration?

Based on the approved post-migration support agreement as proposed by Vendor.

207. Which compliance frameworks does FL EOG require for this solution?

See Attachment H, Data Security Requirements.

208. Would FL EOG consider refactoring to a hosted Database platform such as Amazon Relational Database Service or Oracle Database Cloud Service? Does the database require specific functionality that might prevent this?

There are no known functionality restrictions that would prevent this.

209. Does the application use standard interfaces only vs.

some O/S-specific elements?

Yes.

210. If the conversion cannot be performed for a specific component, will FL

EOG consider having that component rewritten?

211. What version of Microsoft VB.Net is currently in use today?

MS Visual Studio Enterprise 2015

Addendum No. 1

The Agency hereby amends RFP No. EOG-RFP-23-01 as noted within this Addendum. For revisions, underlines and highlights represent additions and strikethroughs represent deletions. In the event of a conflict between previously posted information and the information contained herein, the information herein shall control. The information included in this addendum is hereby made part of this solicitation.

Failure to file a protest within the time prescribed in section 120.57(3), Florida Statutes, or failure to post the bond or other security required by law within the time allowed for filing a bond shall constitute a waiver of proceedings under chapter 120, Florida Statutes. Any protest concerning this agency decision must be timely filed with the Agency Clerk. Protests may be filed by courier, hand delivery, or U.S. mail at Executive Office of the Governor, Attention: Dawn Hanson, 400 S Monroe St., Tallahassee, FL 32399-0001. Protests may also be filed by email at dawn.hanson@eog.myflorida.com. It is the filing party’s responsibility to meet all filing deadlines.

The Procurement Officer should be copied in such filings.

Please note: This addendum does not need to be returned with the proposal.

1. Section 2.19, of the RFP, Order of Precedence, is hereby amended as follows:

2.19 Order of Precedence

All responses are subject to the terms and conditions of this solicitation, which, in case of conflict, will have the following order of precedence listed:

Addenda to Solicitation, if issued (in reverse order of issuance) This Solicitation Scope of Services Cost Sheet Draft Contract Other RFP Attachments State of Florida, Instructions to Respondents (PUR 1001) State of Florida, General Conditions (PUR 1000) Technical Proposal Instructions and Evaluation Criteria Instructions to Respondents (PUR 1001) General Conditions (PUR 1000) Introductory Materials and Solicitation Overview Section

2. The RFP, is hereby amended to add the following Section 2.23, Modification or Withdrawl of Proposal.

2.23 Modification or Withdrawal of Proposal

Respondents may modify submitted proposals at any time prior to the proposal due date.

Requests for modification of a submitted proposal shall be in writing and must be signed by an…