Net Systems Architect

Job Details:

Position: .Net Systems Architect

Location: Tallahassee FL Onsite)

Duration: 12+ Months contract with possible extension

Duties

Applications Support Areas

General tasks required of Contractor in all Application Support Areas:

• Application testing and coordination with Stakeholders or others as required.
• Quality assurance on all work performed
• Create and maintain all documentation (Department templates where appropriate)
• Virtual attendance at application development and other stats meetings when directed by the TSC Manager.
• Knowledge transfer and mentoring.

a. Application Support Area 1 – Data Submission Area.

These systems support the initial login and authentication of external user filing and document handling of submissions and delivery of the submitted data and documents to the proper application and/or database receptacles, Support includes:

1. Office of Insurance Regulation Industry Portal (iPortal).

2. External filing portion of the Insurance Regulation Filing System.

3. Any other applications that may be created later that are primarily unique to this Application Support Area.

4. Related web services and back-end processing.

5. Other related support necessary to fulfile the goals of this Purchase Order.

b. Applications Support Area 2 – Financial Filing Submission and Management Area.

These systems support the external submissions from iPortal, the validation of data and documents received, and the internal processing and management of industry financial data. Support includes:

Financial Analysis and Monitoring EDMS (FAME).

1. Financial Examination Scheduler (FES).

2. Regulatory Electronic Filing System (REFS) (External filing portion of FAME).

3. Related web services and back-end processing.

4. Any other applications that may be created later that are primarily unique to this Application Support Area.

5. Other related support necessary to fulfill the goals of this Purchase Order.

c. Applications Support Area 3 – Forms, Rates, and General Data Submissions and Filing Management Area.

These systems support the external submissions from iPortal, the validation of data and documents received, the internal processing and management of industry forms and/or rate filings or general data requests that are processed and managed in the same applications as forms and/or rate filings, and the outward display of rate data via website to the public. Support includes:

1. Electronic Data Management System (EDMS) Product form and rate filings.

2. Electronic Data Management System (EDMS) Internal Search.

3. Insurance Regulation Filing System (IRFS) Product form and rate filings.

4. IRFS Search/PDF Gen (public search and download of form and rate filings).

5. PDF Stamping.

6. IRFS administration tools that support Forms and Rates filings

7. Medicare Supplement Insurance Rates (MGAP).

8. Property and Casualty Rate Data and Collection Management System (PCRDCMS).

9. Rate Comparison Tools ) CHOICES

10. Related web services and back-end processing.

11. Any other applications that may be created later that are primarily unique to this Application Support Area.

12. Other related support necessary to fulfill the goals of this Purchase Order.

d. Applications Support Area 4 – Data and Survey Submissions and Filing Management Area.

These systems support the external submissions from iPortal, the validation of data and documents received, and the internal processing and management of surveys, data templates, and related documents collected by statute or commissioned by OIR. Most of the data collected in this area is classified as part of regular or ad hoc data activities. Support includes:

1. Insurance Regulation Filing Systtem (IRFS) Data Collection submissions.

2. IRFS administration tools that support data collection filings.

3. Filing review and workflow portion of the Insurance Regulation Filing System (IRFS).

4. Related web services and back-end processing.

5. Any other applications that may be created later that are primarily unique to his Application Support Area.

6. Other related support necessary to fulfill the goals of this Purchase Order.

e. Applications Support Area 5 – Document Storage, Imaging, and Retrieval Area.

These systems support the seamless transition of submitted documents from iPortal or internal scanning functions to document repositories for later retrieval. Support includes:

1. FileNet P8 Document Storage and Retrieval.

2. Imaged Document PDF storage, retrieval, and generation.

3. FileNet Backend Processing Services (FBPS).

4. Content Search.

5. Related web services and back-end processing.

6. Any other applications that may be created later that are primarily unique to this Application Support Area.

7. Other related support necessary to fulfill the goals of this Purchase Order.

f. Applications Support Area 6 – Company Management, Admissions and Authority Determination Support Area.

These systems support the processing and verification of regulated or registered companies and other entities OIR must oversee. The applications support functions of company admissions, background investigations of officers and directors, business authorities and lines of business and ongoing public information needed to be collected by statute and/or for contacting proper parties. Support includes:

1. Insurance Regulation Filing System (IRFS) Company Application submissions.
   
   IRFS administration tools that support company application filings.
2. Company and Other Entity Navigator (COREN)/CORE database.
3. Application Coordinator (AppCoord).
4. iAPPLY (External filing system for company applications).
5. Web-Enabling Company Admissions Application (WECAA).
6. Public Search of Active Companies.
7. Related web services and back-end processing.
8. Any other applications that may be created later that are primarily unique to this Application Support Area.
9. Other related support necessary to fulfill the goals of this Purchase Order.
   
   g. Applications Support Area 7 – Specializde Applications Data Submissions Area.
   
   These systems support the external submissions from iPortal for specialized functions or needs usually defined by statute, but sometimes commissioned by OIR. Most are stand-alone applications with external-facing features. Support includes:
10. Professional Liability Claims Reporting (PLCR).
11. Quarterly Supplemental Reporting Next Generation (QUASRng).
12. Workers' Compensation Claims System (WCCS).
13. Other related support necessary to fulfill the goals of this Purchase Order.
    
    h. Applications Support Area 8 – Specialized Applications Internal Area.
    
    These systems support legal, financial, and administrative functions within OIR. Most are stand-alone applications with a limited number of internal users. Support includes:
14. Office Automation Tracking System (OATS).
15. Media Call Tracking System (MCTS).
16. Bill Analysis Tracking System (BATS) – part of IRFS internal.
17. Consent Order Tracking System (COTS) – part of IRFS internal.
18. Market Regulation Tracking Systtem (MRTS) – part of IRFS internal.
19. Public Record Request Tracking System (PRRTS) – part of IRFS internal.
20. Invoicing – part of IRFS internal.
21. Legal Case Tracking System (LCTS) – part of IRFS internal.
22. Other related support necessary to fulfill the goals of this Purchase Order.
    
    i. Applications Support Area 9 – Consolidation of Submissions and Reviews with Enhanced Security.
    
    This area includes the central access mechanism to OIR applications (APC) and the basic database structure and submission and review processes across applications.
23. Application Process Control (APC).
24. Company Dashboard (Search application).
25. Insurance Regulation Filing System (IRFS) ongoing enhancements.
26. Other related support necessary to fulfill the goals of this Purchase Order.
    
    j. Applications Support Area 10 – System Modernization.
    
    This area includes Modernization of OIR's Applications in Support Areas 1 through 9.
27. Develop and deploy integrated solutions aimed at modernizing, consolidating, and coordinating the independently designed applications.
28. Determine how existing applications, legacy systems, databases, Web interfaces, and/or hardware logic, which may be currently operating on multiple platforms, work together to meet the new and emerging enterprise requirements.
29. Work with users to gather business requirements, perform database analysis, code and test routines to ensure successful and seamless communication among the various IT systems and application components

Qualification Requirements.

1. The mandatory and preferred qualification requirements for the Contractor Representative, to be provided by the Contractor, are found in Attachment 6, Skills Matrix. The Contractor represents that the Response accurately reflects the knowledge, skills, and abilities of the Contractor Representative. Further, the Contractor represents that the Contractor Representative and any subsequent Contract Representative provided by the Contractor to perform these services meets or exceeds the mandatory and preferred professional qualification requirements outlined in Attachment 6, Skills Matrix.

2. OIR may accept one or more Contractor Representatives who must meet the minimum knowledge and skill levels set out in the STC and this SOW. The Contractor Representative(s) will be selected based upon their ability to complete all tasks listed in Section 5, Application Support Areas.

Required Skills Set:

• ASP
• ASP.Net
• C#.Net
• Data Compare
• DocuVieware
• Elastic Search
• Excel (2003, 2010, and above)
• HTML
• IIS
• JavaScript
• MS.Net (1x and above)
• Microsoft Office SharePoint Services
• NHibernate
• NHibernate Profiler
• Oracle database (12x, 19x)
• Oracle PL/SQL
• PowerDesigner (8.x, 10.x, 12.x) data modeling
• Schema Compare
• Single Sign-On Services
• Team Foundation Server
• TOAD, SQLDevloper or PL/SQL Developer
• Visual Basic (6.x and above)
• VBScript
• WebServices
• XML
• Elastic Search
• Google Chrome (55 and above)
• Microsoft Edge (109 and above)
• Mozilla Firefox (30.x and above)
• Telerik Kendo UI Complete for ASP.Net
• SoftArtisans ExcelWriter (2.x and above)
• Neevia DocConverter (6.x and above)
• DocCreator *4.x and above)
• Aspose Total for .NET
• Regular Expressions Character Conversions (RegEx)
• FileNet Image Services API (4.x and above)
• FileNet P8
• FileNet eProcess Workflow API (5.x and above)
• Scanning Services
• OIR File Share
• Firefox (55.x and above)
• .NET 10 and above
• Microsoft Blazor
• Azure App Service
• Azure SQL
• Bootstrap

Job Type: Contract

Pay: $ $100.54 per hour

Expected hours: 40 per week

Application Question(s):

• Do you have strong hands-on experience with ASP.NET, C#.NET, and upgrading or modernizing legacy .NET applications (including VB6/Classic ASP to .NET 6–10, Blazor, Azure)?
• How many years of experience do you have working with Oracle (12c/19c), writing PL/SQL, and using tools like TOAD or SQL Developer?
• Have you supported or developed integrations with FileNet P8, FileNet Image Services API, or FileNet Workflow (eProcess)?
• Can you describe your experience modernizing large legacy enterprise systems and integrating multiple applications using web services (REST/SOAP), APIs, and backend processing?
• Do you have practical experience working with Azure App Service and Azure SQL in a production environment?
• Have you worked with front-end or UI frameworks such as Telerik Kendo UI, Bootstrap, Blazor, or Elastic Search?
• What is your experience with NHibernate or other ORMs, and have you used tools like PowerDesigner, Schema Compare, Data Compare, or ExcelWriter?
• Are you proficient with IIS configuration, Team Foundation Server (TFS), Single Sign-On integrations, and enterprise application deployment?
• Can you handle application testing, QA, documentation, mentoring, and supporting multiple business-critical applications simultaneously?

Work Location: In person