SOW_-_IT_Support_Services_ver_7_2014.docx

Federal Election Commission Statement of Work

Title IT Support Services

Date: June 16, 2014 Version 1.7 Statement of Work- IT Support Services

1. Introduction: The Federal Election Commission is an independent regulatory agency charged with administering and enforcing the Federal Election Campaign Act of 1971, as amended. The duties of the FEC are to disclose campaign finance information, to enforce the provisions of the law such as the limits and prohibitions on contributions, and to oversee the public funding of Presidential elections. The Commission enforces limitations and prohibitions on contributions and expenditures, investigates and assesses fines for violations, audits a limited number of campaigns and organizations for compliance, and administers the presidential campaign fund, which provides public funds to candidates for president.

The FEC also publishes reports filed by Senate, House of Representatives and Presidential campaigns and other political committees that disclose how much each committee has raised and spent and includes each donor's address, occupation , employer and job title. This database dates back to 1980. Private organizations are prohibited from using this data to solicit new individual donors, but Political Action Committees (PACs) may be solicited. The FEC is also charged to keep these exhaustive campaign finance resources available to the public. The FEC also offers a program of public education, directed primarily to explaining the law to the candidates, campaigns and political committees which it oversees. The FEC is responsible for ensuring the information it holds is readily available to the public.

The Commission investigates apparent violations and may assess fines and other civil penalties. A limited number of campaigns and organizations may be audited for compliance. The FEC administers the Presidential Campaign Fund, which provides public funds to eligible Presidential candidates.

The six Commissioners, no more than three of whom may represent the same political party, are appointed by the President and confirmed by the Senate. The Commissioners serve full-time and are responsible for administering and enforcing the Federal Election Campaign Act. They generally meet twice every two weeks, once in closed session to discuss matters that, by law, must remain confidential, and once in a meeting open to the public. At these meetings, they formulate policy and vote on significant legal and administrative matters.

More information may be found at WWW.FEC.GOV.

2. Purpose: Any resulting RFP will solicit proposals for services to augment FEC staff capacity with mastery of the unique Federal Election Regulations, the Disclosure Database and the major and minor Disclosure Systems and Programs. These include Data Capture, Information Management, the FEC Website, FEC Election Map, eReview, the Disclosure Systems such as Administrative Fines and others, Law Manager interfaces to eReview and the Searchable Applications, Alternative Dispute Resolution Office (ADRO), Office of Administrative Review (OAR) and ad hoc projects which are sometimes highly time sensitive. In addition to the above institutional and system knowledge, the contractor selected shall provide Project Management and software development across multiple technologies to the Information Technology Division across the full software development lifecycle to perform enhancements, maintenance, break fixes and new development on these mission critical systems and others as needed. These systems are used by hundreds of users including about two thousand Senate, House and Presidential candidates, thousands of political committees, watchdog groups, researchers, reporters and others.

It is vital that support staff is able to grasp the business rules and technologies as quickly as possible and to be able to maintain all components quickly and efficiently, often with very short turn-around times.

These systems gather data from internal and external sources, process it in numerous ways, load it into other systems for further processing and analysis and correlate it to produce various reports and correspondence used to enforce the laws and regulations the agency oversees. The systems are in various phases of the development lifecycle – some modules are in production, some in development and some are in design. They are in constant flux as Program rules, Commissioner requests and regulations evolve and the underlying suite of technologies sunset or are improved themselves.

All systems activities must be in alignment with the FEC’s enterprise architecture regarding security standards, project goals, strategies and client expectations and the strategies and goals of the FEC CIO.

The FEC reserves the right to interview personnel offered by the winning proposal.

3. Scope: The contractor should ensure, to the maximum extent possible, that personnel assigned possess multifunctioning capabilities across the following skills:

a. Skills

1. Senior C#.Net Developer

Shall possess mastery of Federal Election Commission Public Disclosure data and systems, eReview modules, Data Entry, Data Integrity, Info Management.

Java and .Net environments, prefer staff who perform as both Java and .Net Senior Developer; C#, ASP.NET framework, Microsoft Visual Studio, Telerik grid controls, IIS services, J2EE, jQuery, HTML

Description of task – Government employee will work with contractor Program Manager to ensure all prioritized work is flowing smoothly through the queue. Contractor employee shall have experience developing fully functional .NET and Java applications accessing an Oracle database. Communicates with end users and technical staff to gather and clarify requirements. Suggests process, data and application improvements. Codes and tests then works with users during User Acceptance Testing. Works with government technical staff on questions or knowledge transfer. This resource will also have application and web server configuration and management responsibilities.

It is desirable that this resource is equally capable in Java.

2. Senior Java Developer

Shall possess mastery of Federal Election Commission Public Disclosure data and systems, Data Entry, Data Integrity, FEC Website applications support, OAR, Info Management, eReview modules and Searchable Applications.

J2EE, J2EE, EJB, GWT, JDeveloper, Struts, Tiles, JavaScript, CSS, VC++, SQL, PL/SQL. Provides support for all of the Disclosure Systems, Data Capture, Searchable Applications, eReview, ADRO, OAR and Info Management. These resources will also perform application and web server configuration and management Description of task – Government employee will work with contractor Program Manager to ensure all prioritized work is flowing smoothly through the queue. Shall have experience developing fully functional Java applications accessing an Oracle database. Communicates with end users and technical staff to gather and clarify requirements. Suggests process, data and application improvements. Codes and tests then works with users during User Acceptance Testing. Works with government technical staff on questions or knowledge transfer.

It is desirable that this resource is equally capable in .Net.

3. Java Web programmer:

Shall possess mastery of Federal Election Commission Public Disclosure data and systems, FEC Website applications support.

Java environment: Java, J2EE, EJB, Struts, AJAX, JavaScript - DOM and jQuery, CSS, Eclipse/JDeveloper, Tomcat, Apache, SVN, XML, DHTML, SQL/PLSQL

Description of task – Government employee will work with contractor Program Manager and FEC IT Manager to ensure all prioritized work is flowing smoothly through the queue. Communicates with end users and technical staff to clarify requirements. Maintain existing Java applications, Develop enhancements, resolve issues. Suggests process, data and application improvements. Codes and tests then works with users during User Acceptance Testing. Works with government technical staff on questions or knowledge transfer.

Must have experience with full life cycle of web development including extensive HTML, SHTML, EJB, Struts, CSS, JavaScript, DOM, jQuery, eclipse/jDeveloper, Tomcat, SVN, XML, DHTML and AJAX experience. Must have excellent communications skills and be a great team player.

Desirable Plus if experience includes: Intranet Dashboard, Wikimedia, Web 2.0, PHP, mySQL, open source

4. Senior Analyst/Senior Database Developer/Java Programmer/Crystal Reports Developer

Requires a thorough knowledge and understanding of end-to-end FEC business processes, FEC data, Disclosure Applications, eReview Reports, Law Manager Reports, Crystal Reports, Business Objects Administration, PL SQL, FEC Website applications Provide analysis and support for data related requests, Searchable applications and general IT miscellaneous projects as needed. Business Analysis and requirement gathering skills and knowledge of complex business logic. Requires the ability to communicate well with users to gather requirements. Develop reliable applications, including design, development, testing and on-going support.

Technical Skills: Oracle 11g, SQL, PL/SQL, Crystal Reports XI, Java, J2EE, MS Office, Windows.

5. Program Manager/Project Manager/Analyst/Coder

Requires mastery of Disclosure applications, eReview modules, Data Entry, Data Integrity, FEC Website applications support, ADRO, OAR, Info Management and Searchable Applications.

Description of task - Program Management, Project Management methodologies, Business Analysis, Requirements Analysis, Relational Databases, Database programming - SQL, PL/SQL, Informatica, Miscellaneous Software Engineering tools, TOAD, Microsoft Project.

Communicates with government Program Manager and various stakeholders to assess and prioritize requirements, competing priorities and risk management, provides weekly and monthly status reports to government management. Directs and coordinates technical effort on all supported applications. Performs analysis, coding, testing, documentation support as needed using above described technologies.

6. Java Web programmer:

Shall possess mastery of Federal Election Commission Public Disclosure data and systems, FEC Website applications support.

Java environment: Java, J2EE, EJB, Struts, AJAX, JavaScript - DOM and jQuery, CSS, Eclipse/JDeveloper, Tomcat, Apache, SVN, XML, DHTML, SQL/PLSQL

Description of task – Government employee will work with contractor Program Manager and FEC IT Manager to ensure all prioritized work is flowing smoothly through the queue. Communicates with users to clarify requirements. Maintain existing Java applications, Develop enhancements, resolve issues. Suggests process, data and application improvements. Codes and tests then works with users during User Acceptance Testing. Works with government technical staff on questions or knowledge transfer.

Shall have experience with full life cycle of web development including extensive HTML, SHTML, CSS, Javascript and AJAX experience. Shall have excellent communications skills and be a great team player. Shall have experience mentoring junior developers.

Desirable Plus if experience includes: Intranet Dashboard, Wikimedia, Web 2.0, PHP, mySQL, open source

7. OpenText Enterprise Content Management Administrator.

The ECM Suite system is a multi-server enterprise platform. Core responsibility of the Administrator is in maintaining the ECM Suite content warehouse including production, test, and development environments. Duties include customer support, system configuration, data migration, performance tuning, and security assurance. Additional responsibilities include maintaining system documentation; troubleshooting; and leading technical implementations with database, email, and network administrators.

8. eReview Project Manager

Perform developmental activity functions. In other words, there is no separate PM role to staff. A developer or analyst provides the role IN ADDITION to development and analysis. Requires a thorough knowledge of eReview and has technical skills in key technologies such as .Net, PL/SQL or Oracle or all for example.

9. Business and Requirements Analysis

Business and Requirements Analysis are performed by the entire team in conjunction with FEC resources including the FEC Program Manager. It is critical that the members of the team be equally able to understand the business requirements and to develop software quickly and effectively to meet them.

10. PL/SQL

As the data is rather complex and intricately inter-related and there is a great deal of logic in the database, the entire team works coding and tuning PL/SQL.

11. Senior Informatica Programmer

Informatica plays a significant role in these systems; therefore, the FEC requires that at least two of the key proposed employees are able to tune and alter the Informatica schema and define new ones as needed.

12. QA Engineering

Quality Assurance is performed by the entire team using Test Driven Development techniques. There is no separate QA role.

b. Technologies, tools and systems currently employed by the FEC, including, but not limited to:

1. Oracle v. 11g running on Solaris 9

2. Java 2 Enterprise Edition (J2EE) on Oracle J2EE application server

3. .Net C# Framework

4. AJAX, Javascript

5. Informatica v 7.1.5

6. Intranet Dashboard – see www.intranetdashboard.com

7. Crystal Reports XI

8. Tomcat 7

9. TOAD

10. SQL/PL/SQL

11. Clear Quest v. 7.0.0.1

12. MS SQL Server

13. Erwin

14. Enterprise Content Management

15. Adobe products and applications

16. EJB

17. Struts

18. GWT

19. CSS

20. MyBatis

21. Javamail

22. Business Objects

23. FEC Intranet on .NET SQL Server

24. T-SQL

25. Visual C++

4. Tasks:

a. Enhance, update, develop, and maintain the FEC Disclosure applications – Candidates and political committees in Federal elections must meet specific filing and reporting regulations. . The Commission's Disclosure database is the repository for campaign finance data and statements of candidacy and committee organization. There is a suite of applications that culls data from the Commission's Disclosure database. These applications provide Commission staff with tools for Administrative Fines, Compliance Tracking, Data Capture and much more. Technical oversight is performed by the IT Applications Team.

b. Enhance, update, develop and maintain the E-Review system – This system has five modules.

There are numerous trouble tickets open with varying priorities and new ones are added weekly. The COR (Contracting Officer’s Representative) and contractor will work with the users to ensure that the defects are prioritized appropriately and the contractor will provide start and estimated end dates for the resolution of the tickets.

This activity will be covered in weekly status reports and discussed in weekly status meetings. Technical oversight is performed by the IT Applications Team.

c. Work with the FEC team to continue to improve Data integrity – data coming in to the FEC is received in electronic and paper formats. Accurate reporting naturally depends on accurate data, so sensitivity to this in all systems is crucial. Technical oversight is performed by the eFiling and Disclosure Branches.

d. Update, complete development and maintain the FEC intranet – The intranet is estimated to be 15 – 20% complete and employees are using it. The outstanding 80% must be developed and published and the entire site studied for usability. Technical oversight is performed by the Purchased Applications / LOB Team.

e. Update, generate, maintain documentation for existing systems and for new development. The team documents their work. There is no Tech Writer on the contract.

f. Maintain skill levels – Contractors are responsible for staying abreast of technical components as they evolve.

g. Thorough software test plans, testing and reporting of same; Technical oversight is performed by the OCIO Applications Branch.

h. Provide knowledge transfer, technical coaching and advice to FEC technical staff.

5. Deliverables:

All documentation deliverables shall be provided in Microsoft Office format (i.e. Word, Excel, etc.) and shall be provided in soft copy. Deliverables include:

a. Weekly Status Report

b. System Documentation such as, but not limited to:

1. Release Procedures

2. Release Notes

a. Incremental system updates

b. Incremental bug fixes

3. Prioritized schedule of bug fixes in concert with Rational Clear Quest tickets and priorities

4. Test plans and test results

5. Configuration Documentation

c. All software source code developed and compiled code delivered is the property of the FEC and will reside in VSS.

6. Estimated Period of Performance/Place of Performance:

The period of performance shall consist of a base year and four option years. Contractor personnel shall be located on-site with the FEC; the current location is 999 E St., NW Washington, DC 20463.

7. Government Furnished Equipment (GFE) - The FEC will provide PC’s for all on-site personnel.

image1.jpeg