Attachment F - EHBs EA Labor_Categories-SR_CS.docx

Attachment Q

EHBs Systems Architecture Services and PMO Governance and Support - Indefinite Delivery Indefinite Quantity (IDIQ) – Labor Category Descriptions

Provide resources with demonstrable knowledge of, and preferably experience with, the support of information technology (IT) initiatives in healthcare and federal grants arena. The following labor categories are required to successfully perform the work anticipated under the EHBs Systems Architecture Services and PMO Governance and Support - Indefinite Delivery Indefinite Quantity (IDIQ) RFQ. Several of the labor categories will be considered as required Key Personnel under the IDIQ.

Many of the lead and specialist positions are designated for persons with “hands-on” experience. The offeror may propose additional labor categories in their response as needed to achieve the work and support the tools/technologies described in the IDIQ Statement of Work (SOW) and its attachments:

Key Personnel for Modernization and Enhancement (DME) - Indefinite Delivery Indefinite Quantity (IDIQ)

1. Enterprise Architect

2. Cloud Data Architect

3. Cloud Architect

4. Subject Matter Expert

5. Solution Architect

6. PMO Manager/Analyst

7. IDIQ Program Manager

8. Database Architect

1. Enterprise Architect (Key Personnel) Enterprise architect works with stakeholders, both leadership and subject matter experts, to build a holistic view of the organizations strategy, processes, information, and information technology assets. Takes this knowledge and ensure that the business and IT are in alignment. Links the business mission, strategy, and processes of the organization to its IT strategy, and documents this using multiple architectural models or views that show how the current and future needs of an organization will be met in an efficient, sustainable, agile, and adaptable manner. Must operate across organizational and computing “silos” to drive common approaches and expose information assets and processes across the enterprise. Delivers an architecture that supports the most efficient and secure IT environment meeting the business needs. Must drive both the Business and IT strategies to cohesively enable and drive each other.

Level of Experience: >= 15 years

2. Cloud Data Architect (Key Personnel) Responsible for architecting, designing and implementing end to end solutions in a cloud platform. Design and implement distributed analytic platform and large cloud data warehouse to support the data/search driven analytics and visualization platform. Develop DAR and POC for migrating traditional relational database systems to Platform as Service (PaaS) model. Architect data at rest and in motion using SSL encryption and other encryption methods to protect sensitive information. Design and Implement real time data streaming solutions for reporting and dashboards. Conduct period analysis to fine tune backend jobs, procedures, functions and ETL/ELT processes and migrate them to cloud data platform. Analyze and provide recommendations to choose the right cloud data platform service level for an Enterprise System. Work closely with cloud architects and optimize the data environment to reduce the operating costs in cloud. Must have sound knowledge of TCP/IP, IP addresses, HTTP/HTTPS, TLS, Cloud traffic manager, Cloud Load Balancer, Storage ,NSG, ASG , VNET and Sub-net and DNS.

Level of Experience: >=7 years

3. Cloud Architect (Key Personnel) Responsible for developing cloud strategy and managing cloud migration/adaption process. Regularly evaluates cloud applications, infrastructure, services and software to improve and optimize cloud based solutions. Develops network topology, application security groups, and implements highly secured application segmentation to comply with cyber security standards. Establishes best practices to migrate large, enterprise level applications to cloud (IaaS, PaaS and SaaS). Develops cost optimization techniques to reduce overall cloud infrastructure and services cost. Develops Enterprise level cloud architecture to deploy container based systems in a multi-vendor environment. Conducts Decision Analysis and Resolution (DAR) and develops Proof of Concept (POC) using various cloud platforms and services. Designs and engineers automated deployment, monitoring and maintenance functions. Implements virtualization technologies to achieve the efficiencies and reduce the data and application foot print. Must have sound knowledge of TCP/IP, IP addresses, HTTP/HTTPS, TLS, Cloud traffic manager, Cloud Load Balancer, Storage ,NSG, ASG , VNET and Sub-net and DNS.

Level of Experience: >=7 years

4. Subject Matter Expert (Key Personnel) Provide technical knowledge and analysis of highly specialized applications and operational environment, high-level functional systems analysis, design, integration, documentation and implementation advice on moderately complex problems that require an appropriate level of knowledge of the subject matter for effective implementation. Apply principles, methods and knowledge of the functional area of capability to specific task order requirements, advanced mathematical principles and methods to exceptionally difficult and narrowly defined technical problems in engineering and other scientific applications to arrive at automated solutions. Assist other senior consultants with analysis and evaluation and with the preparation of recommendations for system improvements, optimization, development, and/or maintenance efforts in the following specialties: information systems architecture, networking; telecommunications, automation; communications protocols, risk management/electronic analysis, software; lifecycle management, software development methodologies, and modeling and simulation. Commensurate experience in IT and in new and related older technology that directly relates to the required area of expertise.

Level of Experience: >= 15 years

5. Solution Architect (Key Personnel) Converts the enterprise architecture requirements into an architecture and design that will become the blueprint for a solution that is being created. The conversion should be based state-of-the-art industry design patterns that the solution architect has been involved through experience or published reference architectures with guidance from the enterprise architect. Must balance architectural concerns of the projects with the concerns of the enterprise. Act as the bridge between enterprise architecture and applications architecture. Serves as the development team leader to provide motivation and guidance to the entire development team during the systems development life cycle. Must ensure buy-in from the development team, so that the team is motivated to match the detailed design of the solution to the higher-level architecture. Ensures that the solution architecture aligns with the roadmaps established by the enterprise architecture, and that it adheres to the enterprise architecture design principles. The patterns and guidance developed must become reusable in a broader enterprise architecture context Level of Experience: >= 15 years

6. PMO Manager/Analyst (Key Personnel) Serves as the functional leader of project delivery and governance across the organization. Provides advice and guidance, monitoring and assurance, advocacy and education with respect to programs, projects, and their delivery, to stakeholders. Manages day-to-day activities of the IT program and projects to meet organization goals and requirements. Implements and provides guidance related to PMO processes and policies, oversees the work of project management staff, and works with other stakeholder to define, prioritize, and develop projects and programs. Ensures that project/department milestones/goals are met and adhering to approved budgets.

Level of Experience: >= 7 years

7. IDIQ Program Manager (Key Personnel) The Program Manager manages a large, complex set of IT initiatives. Project complexity may be caused by extensive scope, interdisciplinary involvement, short time-frames, large project teams, a challenging client environment, cutting-edge technology environment, high-availability and system performance requirements, multi-geographic team distribution, or all of the above. The Program Manager drives successful project completion by coaching, consulting, managing and resolving issues, allocating resources, and maintaining team productivity and morale in high- pressure situations. Leads and mentors other team leads and project managers. Initiates, supports and participates in negotiations with prospective customer. Plans, directs and coordinates systems analysis and programming activities. The Program Manager provides guidance in strategic systems planning to project teams. The Program Manager is responsible for preparing incoming management for transition from implementation to business operating stage.

Level of Experience: >= 15 years

8. Database Architect (Key Personnel) Defines file organization, indexing methods, and security procedures for Enterprise applications. Designs database architecture and build out the physical environments to support all application development efforts. Participates in and/or lead production troubleshooting, testing, optimization, performance tuning, and process automation efforts. Experienced in SQL tuning and query optimization tools such as SQL Trace, DBMS_PROFILER. Experienced with data replication and data migrations tools and techniques. Experienced in building custom stored procedures and triggers to automatically populate different tables. Demonstrated experience in working with application developers in troubleshooting code and tracing the code to find out the issues. Experience with large databases with high transaction volume. Working knowledge of software version control concepts and change management processes. Working knowledge of data modeling concepts. Working knowledge of automated job scheduling. Understanding of authentication and authorization security concepts. Understanding of all phases of the SDLC. Demonstrated expertise in change management and version control practices.

Level of Experience: >= 10 years

9. Contract Administrator Experience managing complex IT service IDIQ etc. in a similar contract administrator role. Supports the preparation of Call Order/Task Order responses, management plans and regular reports requested by the COR, Monthly Billing, and various Task Order customer status reports. Develops and presents materials to program and executive management and provides direction to other administrative personnel.

Level of Experience: >= 10 years

10. Technical Project Manager Responsible for ensuring the project team completes the project; oversees and manages the other Project Management Office (PMO) members; provides the overall management of the project direction as related to functionality, schedule and budget; insures adherence to project management and software development life cycle and best practices; manages the team’s performance on project tasks; provides overall project and budget planning, monitoring and control; provides periodic status reports for Senior Leadership; coordinates project issues and dependencies; reviews and approves architecture and product direction; secures acceptance and approval of deliverables from the project sponsor; responsible for status reporting, risk management, and escalation of issues that cannot be resolved by the project team; liaises with all current and future stakeholders; develops staffing plans; manages recruitments and roll offs.

Level of Experience: >= 12 years

11. Cloud Developer/Engineer Responsible for designing, developing, and deploying cloud-based solutions for a large enterprise system. Provides the support for deploying and debugging cloud stacks and ensuring the security of the cloud infrastructure. Creates prototypes, interacts with staff to elicit and define business requirements, integrates systems, and implements packages & web apps/APIs and participates in a multidisciplinary team environment. Maintains one of the specific systems source code and associated sub-products. Develops and maintains data processing applications which meet user and business needs in cloud platform. Codes, tests, and implements computer programs in developmental and maintenance modes. Implements automated unit and regression tests to bring agility. Identifies, analyzes, and resolves cloud infrastructure and code vulnerabilities and application deployment issues.

Level of Experience: >=7 years

12. Technical Architect Provides hands-on day-to-day coaching and support for senior team personnel in all phases of DME projects including technical aspects such as systems architecture, reuse, development processes, technical direction, mentoring of the technical team; provides technical leadership and mentoring on projects from beginning to end, with emphasis not only on excellent initial design and/or package experience, but also on creative problem resolution in a multi- disciplinary environment; recognizes where he/she needs to provide very specific leadership skills to the team(s) that are in need; understands the risks, issues, and the potential areas of concern with the project on an ongoing basis; acts independently as a technical advisor on the most specialized phases of system design, implementation, analysis and programming; leads and participates in major system studies and implementations.

Level of Experience: >= 12 years

13. Business Architect Provides a structured business architecture approach and methodology for capturing the key business requirements at Enterprise level. Implement the process and procedures to maintain the requirement traceability at any given point in time. Conduct analysis to determine best path for solving business problems/opportunities that may include process improvements, system enhancements, improved user training, and/or software procurement. Strong experience in conducting interviews with customers to identify the business gaps and develop business process re-engineering practices. Reviews, analyzes, and evaluates ideas, projects and opportunities to develop new system modules or provide recommendations to enhance the existing modules or business models to achieve operational efficiency. Develop tactical and strategic business needs/goals that provide traceability through the organization and are mapped to metrics that provide on-going governance. Document primary business functions and distinguish between customer-facing, system to system integration, data related and impact of business management functions with the implementation. Define data shared across the enterprise and the relationships between those data at system and organization level along with the business governess policy to access the data. Develop the relationships among business roles, capabilities and business units, the decomposition of those business units into subunits, and the internal or external management of those units.

Level of Experience: >= 12 years

14. Technical Lead Provides a strong focus on a technology area or discipline, especially where deep technical knowledge is required. The role requires direct and leveraged expertise in a specific technology or set of technologies such as .Net, .Net product suites, micro services, cloud adoption, etc., that a team would use to implement a technology solution. Acts as a key driver of design decisions around a product suite, based upon knowledge of the products capabilities and drawbacks. Design and implement automated unit and regression test suites at an Enterprise level. Serves as team expert for the development of the technology solutions, and serves as the point of contact between vendors and the technical team members for resolving challenges and technical problems. Directs team of developers in converting the business requirements into a technical product/solution. Requires strong communication and interpersonal skills. Demonstrated skills in using coding standards and being an active participant in regular code reviews. Demonstrated experience with evaluating code quality using tools such as SonarQube to perform automatic code reviews to detect bugs and security vulnerabilities and resolve them in a timely manner.

Level of Experience: >= 12 years

15. Sr. Software Engineer Oversee a team of software developers and testers to achieve the delivery of project commitments. Works with technical team leads, architects, product managers, and other teams to take ideas through all phases of the projects. Creates schedules and work plans. Participates in long-range planning and development of operational goals and engineering specifications. Develops functional processes and operational policies within the area managed. Responsible for implementing operational and strategic policies and directives. Shares information with related groups/projects. Provides innovative solutions to complex problems, and communicates progress toward project/program goals. Work with the operations to identify, define, measure, analyze, implement and control Applied Technology projects. Perform high level technical analysis activities, such as requirements gathering and gap analysis of user requirements. Develop metrics to help operations track and value improvement projects. Responsible for technical deliverables during the entire lifecycle of technology projects. Break/fix support and maintenance on site and /or remotely.

Level of Experience: >= 10 years

16. Test Engineer Responsible for creating and communicating an automated test plan, providing high-level training for test engineers and software engineers on how to implement the automated testing plan, creating test cases and test scripts based on the requirements traceability matrix and requirements use cases, implementing test cases, logging bugs through tracking tools, creating test reports for the development team and for the project management organization, prioritizing bugs, and verifying fixes as they are released. Lead change control board meetings with customers to prioritize and address them on time. Design and develop test automation frame work at Enterprise level and collaborate in multi-vendor environment to gather feedback to improve the solution.

Level of Experience: >= 10 years

17. Program Manager Responsible for providing leadership, coordination, and logistical support to product and program domains or subject matter areas. Provides technical, managerial, and administrative direction for problem definition, analysis, requirements development and implementation for complex to extremely complex systems in the subject matter area. Applies principles, methods, and domain knowledge of specific functional areas of expertise to specific requirements. Provides advice on esoteric problems which require extensive knowledge of the subject matter. Makes recommendations and advises on organization-wide systems improvements, optimization or maintenance efforts. Sets the agenda for meeting events, leads discussions, and drives the community towards consensus. Monitors progress in the special interest groups (SIGs) within program areas. Coordinates activities and communications with other program areas.

Level of Experience: >=12 years

18. Contract Manager Manages the preparation of contracts, management plans, and various customer reports. Develops and presents materials to program and executive management and provides direction to other administrative personnel. Coordinates schedules to facilitate the completion of Call Order and change proposals, contract deliverables, Call Order reviews, briefings, and presentations. Performs analysis, development, and review of program administrative operating plans and procedures. Coordinates schedules to facilitate completion of proposals, contract deliverables, Call Order review, briefings/presentations, and Integrated Baseline Review (IBR) preparation. Respond promptly to technical statement and service level agreement (SLA) review requests from business development/licensing, partnership sales, and legal counsels.

Level of Experience: >= 10 years

19. Senior Architect Provides hands-on day-to-day coaching and support for senior team personnel in all phases of a project including aspects such as systems architecture, reuse, development processes, technical direction, mentoring of the team; provides technical leadership and mentoring on projects from beginning to end, with emphasis not only on excellent initial design and/or package experience, but also on creative problem resolution in a multi- disciplinary environment; recognizes where he/she needs to provide very specific leadership skills to the team(s) that are in need; understands the risks, issues, and the potential areas of concern with the project on an ongoing basis; acts independently as a technical advisor on the most specialized phases of system design, implementation, analysis and programming; leads and participates in major system studies and implementations.

Level of Experience: >= 15 years

20. Software Development Consultant-Senior Provides a strong focus on a technology area or discipline, especially where deep technical knowledge is required. The role requires direct and leveraged expertise in a specific technology or set of technologies, product suites, etc., that a team would use to implement a technology solution. Act as a key driver of design decisions around a product suite, based upon knowledge of the products capabilities and drawbacks. Serves as team expert for the development of the technology solution, and serves as the point of contact between vendors and the team for resolving difficult problems. Direct a team of developers in converting the requirements into a technical product/solution. Requires strong communication and interpersonal skills.

Level of Experience: >= 10 years

21. Scrum Master Responsibilities for leading the scrum team in using Agile methodology and scrum practices. Help the product owner and development team to prioritize and execute the sprint. Lead the scrum and development teams for various technical and crosscutting teams. Remove impediments and coach the scrum team on removing impediments. Help the scrum and development teams to identify and fill in blanks in the Agile framework. Resolve conflicts and issues that occur. Help the scrum team achieve higher levels of scrum maturity. Support the product owner and provide education where needed.

Level of Experience: >= 10 years

22. Business Analyst Develops and maintains detailed user, business, program, and performance requirements for the development of software applications. Performs through intensive interactions, meetings, workgroups, workshops, etc. to analyze business and user processes, key stakeholder procedures, and community practices. Prepares Epic, user stories and establishes the requirement traceability for each releases. Works with development teams to review the sprint changes, conduct the system /enhancement changes to the customers and stakeholders. Conducts backlog grooming and work with business architect and requirement lead to define the business solution to address the business gaps. Sound knowledge of Agile scrum methodologies and business process re-engineering techniques are required Level of Experience: >= 10 years

23. Software Engineer Creates prototypes, interacts with staff to elicit and defines business requirements, integrates systems, implements packages, and participates in a multidisciplinary team environment. Under the most general direction, maintains one of the specific systems and associated sub-products. Maintains software currency, debugs and configures related software products. Provides operating systems planning and evaluation for performance analysis, capacity planning, and hardware upgrades. Interfaces with other groups to resolve user problems, setting standards, and improving overall efficiency of the operating system. Designs, codes, tests, and implements tools for operations automation. Develops and maintains data processing applications which meet user and business needs. Codes, tests, and implements computer programs in developmental and maintenance modes.

Level of Experience: >= 5 years

24. Database Administrator-Senior Implements, supports and manages the databases for all the systems managed at OIT. Designs and configures relational database objects and is responsible for the data integrity and availability. Ensures database security, including backups and recovery. Plans and budgets staff and data base resources. Database administrator must be proficient in one or more of the leading database management systems, such as, Microsoft SQL Server and Oracle. Participate in and/or lead production troubleshooting, testing, optimization, performance tuning, and process automation efforts. Experienced in SQL tuning and query optimization tools like SQL Trace, DBMS_PROFILER. Experienced with data replication and data migrations tools and techniques. Experienced with large databases with high transaction volume. Working knowledge of data modeling concepts. Working knowledge of automated job scheduling. Understanding of authentication and authorization security concepts. Understanding of all phases of the Systems Development Life Cycle (SDLC).

Level of Experience: >= 10 years

25. Facilitator Assists with meetings or workshops, working with participants to achieve overall objectives and to address drivers, or independently run smaller meetings, workshops, or breakout sessions. Vested in the outcomes of the meeting, and where necessary, has content and subject matter expertise. Facilitates checkpoints and main room discussions. Directs and conducts research necessary to develop and revise comprehensive materials for use in preparation for and during meetings and workshops. Leads the preparation of all materials (e.g., meeting or workshop outline, background material, and session aids) for use during the meetings or workshops. Coordinates staff. Demonstrates excellent interpersonal written and oral communication skills, including those required for executive-level meetings. Maintain currency in the area of expertise and expected to function as an expert in facilitation.

Level of Experience: >= 7 years

26. Quality Assurance Lead Develops and implements quality control processes to ensure compliance with QA standards, guidelines, and procedures to support quality initiatives for a larger Enterprise system. Develops and defines major and minor characteristics of quality including quality metrics, scoring parameters, and determines requisite quality control resources. Establishes and maintains a process for evaluating hardware, software, associated documentation, and assists in the evaluation. Conducts and/or participates in formal and informal reviews at pre-determined points throughout the development life cycle. Determines the resources required for quality control.

Level of Experience: >= 10 years

27. Technical Writer Assists in collecting and organizing information required for preparation of user manuals, training materials, installation guides, proposals, and reports. Edits functional descriptions, system specifications, user manuals, special reports, or any other customer deliverables and documents.

Level of Experience: >= 8 years

28. Business Intelligence Specialist – Tableau Admin/SME Supports data analytics strategies across the agency. Develops and provides new business intelligence solutions (e.g., Tableau). Provides quality assurance of reports generated for distribution. Provides strategic and technical solutions recommendations to support business intelligence, and translate requirements into technical solutions. Architects advanced integrated solutions to improve business performance and serve as a technical team leader of various projects, who can lead teams to implement high quality solutions. Experience with a major Business Intelligence tool is a must.

Level of Experience: >= 7 years

29. Security Engineer Responsible for maintaining & enhancing information security management program(s) to ensure integrity, confidentiality, and availability of information. Adhere to security best practices and comply with government standards. Analyze mission requirements and make recommendations. Assess information security risk and facilitating remediation of identified vulnerabilities for IT security and risk across the enterprise. Generate security reports related to incidents, vulnerabilities, and configurations. Serve as subject matter expert/lead for all IT security related tasks. Collaborate with technology architecture teams by performing security analysis of proposed architectures, risk assessment, providing timely feedback, and comply with security requirements. Provide guidance and best practice recommendations for IT security policies, procedures, and standards that meet regulatory requirements. Maintain knowledge of security regulations, best practices, countermeasures, compliance standards, and current threats.

Level of Experience: >= 10 years

30. Data Analyst Build & operationalize processes to ensure timely data updates and data accuracy in line with project scope and recommendations. Designs and delivers summary reports and insights for improvements. Builds analytical solutions and models by manipulating large data sets and integrating diverse data sources. Performs ad-hoc analysis and provide meaningful reporting to operations and senior leadership. Monitors data quality, troubleshoot data-related problems and offer solutions. Collects, analyzes, and summarizes data to communicate insightful information to the executive team, and key stakeholders. Creates interactive dashboard to measure business performance for key stakeholders. Presents thorough and detailed reports to identify areas of opportunity and insight to drive future decision making. Perform data validation and maintain integrity of databases. Maintains and optimizes Tableau dashboards.

Level of Experience: >= 7 years

31. Service Integration Lead Provides leadership, guidance, instruction, and direction to other members of the development team. Project-based contributions which may include building automation, enhancing plugins, and product-based testing/QA with integrations. Troubleshoots complex implementations of solutions and work with teams in the areas of support, professional services, and customers to provide satisfactory resolution. Identifies gaps in the system architecture, develop capability roadmaps, and analyze alternate solutions. Analyzes current system/applications interfaces to determine potential upgrades. Enhance existing tools and build out new tools for testing API, responsive web and mobile products. Trains and mentors technical staff and provide guidelines and best practices for automation. Participates in Agile working practices such as daily scrum meetings, sprint planning meetings, and reviews.

Level of Experience: >= 10 years

Page | 10 of 11