F_Labor_CW.xlsx

XLSX spreadsheet 29 KB Posted

Attached to
7H--United States Geological Survey (USGS) Water Missi
Solicitation number
140G0223R0001
Issued by

View the file

Other files

File Type Posted
Attachment_H7_Q_A_0010.xlsx XLSX spreadsheet
Sol_140G0223R0001_Amd_0010.pdf PDF
Attachment_H6_Q_A_0009.xlsx XLSX spreadsheet
Sol_140G0223R0001_Amd_0009.pdf PDF
Revised_Factor_H_-_Price_0008.pdf PDF
Sol_140G0223R0001_Amd_0008.pdf PDF
E_Revised_Sample_Project_Proposal_0008.pdf PDF
Factor_I_-_Sample_Project_Proposal_Technical_Evaluation_0008.pdf PDF
Sol_140G0223R0001_Amd_0005.pdf PDF
H5_Q_A_0007.xlsx XLSX spreadsheet
Sol_140G0223R0001_Amd_0007.pdf PDF
M_20221169001_0006.docx DOCX document
L_20222280350_036_0006.docx DOCX document
J_NWQL_ASR_Form_0006.pdf PDF
K_ICPRE21005_0006.docx DOCX document
H4_Q_A_0005.xlsx XLSX spreadsheet
I_Recorded_Video_0005.pdf PDF
H3_Q_A_0004.pdf PDF
Sol_140G0223R0001_Amd_0004.pdf PDF
Sol_140G0223R0001_Amd_0003.pdf PDF
Attachment_H2_0002.xlsx XLSX spreadsheet
Sol_140G0223R0001_Amd_0002.pdf PDF
Attachment_H_0001.pdf PDF
Sol_140G0223R0001_Amd_0001.pdf PDF
E_Sample_Project_Pro.pdf PDF
C_Vid_User_Srt_CrossW.xlsx XLSX spreadsheet
G_Licensing_W.xlsx XLSX spreadsheet
B_User_Stories.xlsx XLSX spreadsheet
D_DOLs.pdf PDF
A_Requirement.docx DOCX document
Sol_140G0223R0001.pdf PDF
Show all 31

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

Experience

RFP 140G0223R0001 LIMS Solution
Attachment F - The 10-Year Labor Category Worksheet
Experience LevelDescripton
Level IA Level I labor category typically has 0 to 3 years experience, a BA/BS degree or equivalent training and experience. Level I is responsible for assisting more senior staff and functional duties under the oversight of senior positions
Level IIA Level II labor catogory typically has 3 to 10 years experience, a BA/BS or MA/MS degree or equivalent training and experience. This level typically performs all functional duties independently.
Level IIIA Level III labor category typically has over 10 years of experience and a MA/MS or higher degree ore equivalent experience and trainng. The Level III category typically works on high-visibility or mission critical aspects of a given program and performs all functional duties independently. The Level III labor category may oversee the efforts of less senior staff and/or be responsible for the efforts of all staff assigned to a specific job.
Subject Matter ExpertA Subject Matter Expert is an individual whose qualifications and/or particular expertise are exceptional and/or highly unique. Subject Matter Experts do not have specific experience/education qualifications, but are typically identified as recognized Industry leaders for a given area of expertise. Subject Matter Experts typically perform the following kinds of functions: Initiates, supervises, and/or develops requirements from a project’s inception to conclusion for complex to extremely complex programs; Provides strategic advice, technical guidance and expertise to program and project staff; Provides detailed analysis, evaluation and recommendations for improvements, optimization development, and/or maintenance efforts for client-specific or mission critical challenges/issues; Consults with client to define need or problem supervises studies and leads surveys to collect and analyze data to provide advice and recommend solutions. Has exceedingly deep expertice in a given area, method, or technology that is required to resolve complex or unusual problems.

Note Contractors may deviate from the definitions above when responding to task order solicitations so long as the deviations are clearly identified in their task order proposal. For example, a Contractor might label an employee as “Senior”, but the employee does not have a MA/MS degree. Likewise, a Contractor might label an employee as “Junior” even though the employee has more than 3 years experience. Deviations shall be clearly identified in proposals submitted in response to task order solicitations.

LC - Description

RFP 140G0223R0001 LIMS Solution
Attachment F - The 10-Year Labor Category Worksheet
CategoryDescription
Application Engineer / Software Engineer / Software DeveloperConfigure and customize LIMS software according to functional requirements and business process specifications. Test, debug, and refine LIMS to ensure business needs are met. Generate documentation regarding system configurations and customizations for use by future application engineers and USGS system administrators. Generate documentation for use by end users.
Application Hosting ManagerWork with USGS on application and database hosting to meet USGS hosting requirements. Document and provide guidance to USGS for system back-ups and disaster recovery.
Application Support SpecialistConfigure, troubleshoot and debug system errors once system has been deployed. Test system tweaks and fixes to ensure system operates as agreed upon with USGS. Document configurations and fixes.
Application Systems AnalystWork with end-users on project development and implementation. Provide analysis and guidance in systems integration between LIMS and other USGS software and data systems. Analyses to include overall process and design for integrations as well as cost-benefit for implementation. Specify system inputs and outputs, business rules, and processing steps in accordance with user needs.
Business AnalystProvide expertise in, but not limited to, Configuration Management, Strategic Planning, Knowledge Management, and Business Analysis and Business process analysis. Provide expertise in business process and systems analysis, design, improvement, and implementation efforts and in translating business process needs into technical requirements. Assist in identifying relevant laboratory best practices and quality management standards, including GLP (Good Laboratory Practice), to optimize organizational impact of LIMS implementation. Identify information technology inadequacies and/or deficiencies that affect the functional area’s ability to support/meet organizational goals. Generate functional area strategies for enhanced IT operations in a cross-functional area mode throughout the organization.
Chemical Analyzer/Laboratory Data System ConsultantPossesses a deep knowledge of one or more chemical analyzers and the associated software used by the USGS. Works with the implementation team and the USGS to understand the abilities of the LIMS and the USGS workflow needs, and recommends options for operating and configuring the instrumentation and the instrument software as well as for configuring and operating the LIMS to best capture the USGS needs. Where there exists newer laboratory instrumentation or laboratory data system software that would better suit the LIMS implementation, while maintaining USGS data quality goals, recommends options for equipment that better suits USGS operations.
Computer Systems Analyst / Software ArchitectAnalyze existing infrastructure (such as computers, peripherals, network) to identify gaps in technology and provide recommendations for improvement and system optimization. Analyze user interfaces, maintain hardware and software performance tuning, analyze workload and computer usage, maintain interfaces with outside systems, analyze downtimes, and analyze proposed system modifications, upgrades and new COTS solutions. Coordinate closely with programmers to ensure proper implementation of program and system specifications. Develop, in conjunction with functional users, system alternative solutions. Provide guidance to improve technology infrastructure to better support overall laboratory business.
Database ArchitectAnalyze data requirements and model alterations and expansions to the LIMS database architecture. Model database alterations and expansions to accommodate proposed integrations with other USGS software and data systems.
Database EngineerImplement database alterations and expansions to the LIMS database as designed by the database architect. This may include fields, tables, indices, and business rules.
DevOps/DevSecOps EngineerPossesses an deep understanding of the LIMS product internals and infrastructure requirements. Modifies the LIMS system configuration to match USGS user stories and feedback from the implementation team. Insures that the LIMS system is operational and compliant with security policies.
Enterprise ArchitectAnalyze existing USGS infrastructure and applications to identify gaps between them and the LIMS product and provides recommendations for improvement and system optimization. Analyzes interfaces and software performance tuning, analyze workload and data transfer. Designs for enterprise systems, analyze downtimes, and analyze proposed system modifications, upgrades and new COTS solutions. Coordinate closely with programmers to ensure proper implementation of program and system specifications. Develop, in conjunction with LIMS architects system alternative solutions.
Infrastructure ArchitectAnalyzes USGS workflows and requirement in the context of the LIMS system requirements and develops recommendations and designs for systems, configuration, hardware, software, and policies to support the LIMS system.
Laboratory Analytical Systems and Processes ConsultantProvide expertise and analysis for general or specific laboratory processes and analytical systems. Provide system requirements and recommendations based on analysis of lab workflows, needs, and technical requirements. Using laboratory expertise to provide ‘to-be’ recommendations to improve laboratory processes, including implementation of laboratory ‘best practices’, increased lab efficiency, elimination of redundant data entry, and meeting recognized standards in quality control for data and science. Provide recommendations to guide LIMS configurations and customizations.
Laboratory Data Visualization ExpertPossesses a deep understanding of how to visualize analytical chemistry data and views needed to create dashboards for various LIMS users from data stored in LIMS. Works with the USGS and LIMS implementation team to develop effective visualizations for dashboards, workflows, and quality control. Develop recommendations for visualizations hosted by the LIMS system as well as visualization that need to be provided by an external services (Tableau, gnuplot, etc.).
LIMS Data ModelingPossesses a deep understanding of LIMS product data structures and interfaces. Develops test dataset that match USGS workflows to enable testing and validation of implementation, as well as simulation of overall LIMS system performance.
LIMS Integration ConsultantWorks with USGS Laboratory groups to develop an understanding of what aspects of their workflows can be captured in the LIMS product and provide recommendation for how to pivot workflows into the LIMS system, how to configure the LIMS system for their needs, and how to operate the LIMS system after integration. Identifies activities that are well suited for the LIMS system, areas that could with custom configuration, and activities that should be handled outside the LIMS and perhaps by other enterprise applications. Works to help USGS user groups harmonize their processes in LIMS. Possesses good communication skills and ability to understand analytical processes so that they can be implemented most effectively in the LIMS system.
LIMS System IntegratorUses understanding of laboratory processes, LIMS product features, and LIMS product configuration methods to implement USGS laboratory processes and data collection workflows in the LIMS system. Identifies areas were workflows can be optimized by automation within the LIMS systems and areas where workflows can be combined or reused. Also identifies areas and workflows that would be better handled by systems outside of the LIMS product. Works with the USGS and LIMS implementation team to document workflows and underlaying configurations.
LIMS TrainerUsing a deep understanding of the LIMS product and laboratory processes, Educates USGS users on how to efficiently use the LIMS product. Develops videos, tip sheets, and instructions for USGS user groups. May work with other members of the Vendor LIMS team to identify unmet user needs and other opportunities for optimization and integration. Possesses excellent interpersonal skills and is able to empathize and connect with users with a broad range of backgrounds and technical levels.
Program ManagerOversees or manages all tasks and subprojects in the LIMS implementation project from start to finish. May delegate responsibilities to project managers that assist with distinct aspects and phases of the implementation. Responsible for overall planning, scheduling, and directing all phases of the project including software selection, configuration, implementation, and advising on long term maintenance. Analyze new and complex and cross-cutting project-related problems and create innovative solutions that normally involve the schedule, technology, methodology, tools, solution components, and financial management of the project. Engages various stakeholder groups to ensure needs are met. Ensures project stays on time, in scope, and within budget.
Project ManagerOversees or manages projects from start to finish. Responsible for overall planning, scheduling, and directing all phases of a project including software selection, configuration, implementation, and advising on long term maintenance. Analyze new and complex project-related problems and create innovative solutions that normally involve the schedule, technology, methodology, tools, solution components, and financial management of the project. Engages various stakeholder groups to ensure needs are met. Ensures project stays on time, in scope, and within budget.
Quality and Test ExpertLead and oversee testing LIMS configuration, customization, and implementation. Develop and executes test plan. Report bugs and misconfigurations for correction. Validates system functionality so that it operates as designed and meets technical requirements. Ensure overall system is compliant with all applicable federal security and operational requirements. Executes test plan as designed by LIMs integration team leadership and USGS. Report bugs and misconfigurations for correction.
Scientific Data AnalystProvide expertise in how to best capture, export, and analyze laboratory generated data.
Scrum MasterOrganizes work units for LIMS integration and development teams into high value units that move toward the 'to-be' vision. Manages work backlog, coaches and coordinates work among team members. Helps Project managers and product owner accurately assess work progress. Champion of agile methodology.
Security Operations EngineerProvides expertise and analysis for configuring and operating the LIMS system in a secure manner. Reviews operational requirements, provides feedback to stakeholders, and configures the LIMS system to meet security requirements.
Statistical Process Control/Laboratory Data Quality Control ConsultantPossesses a deep understanding of analytical chemistry quality control and statistical process control. Works with the LIMS integration team and USGS users to develop best practices and optimize the quality control data collected and stored in LIMS. Identifies and recommends data quality workflows to be established inside and outside the LIMS system to insure that stored results meet USGS quality management system goals. Works with the implementation team to develop visualizations and reports that demonstrate the quality of data generated that can be used by various stakeholders to assess data reported by the USGS.
System AdministratorOversee and perform day-to-day operations of the system including, system installation, upgrades, and client access. Optimizes system operations.
Technical Writer/Documentation SpecialistWorks with LIMS implementation team and the USGS to create documentation LIMS system implementation, configuration, and operation. Creates training materials (written manuals, online trainings, videos, etc.) for operation of the LIMS system. Works with the LIMS implementation team and USGS to insure that LIMS system error messages are adequately documented.
User Interface and User eXperience (UX/UI) ExpertPossesses a deep understanding of human centric design and laboratory user needs as well as the underlaying architecture of the LIMS product. Works to optimize the user experience by tuning workflows to make them intuitive and efficient. Collaborates with the USGS users and the vendor implementation team to identify and optimize the LIMS user experience to enable higher throughput and reduced errors. Additionally, works with implementation team to insure that the LIMS product is meets accessibility requirements. Works with the implementation team to make sure that interface errors provide clear and actionable feedback to users.

Labor Category Worksheet

RFP 140G0223R0001 LIMS Solution
Attachment F - The 10-Year Labor Category Worksheet
Fully Burdened Rate (in Dollars / Hour)
Labor CategoryExperienceYear 1Year 2Year 3Year 4Year 5Year 6Year 7Year 8Year 9Year 10
Application Engineer / Software Engineer / Software DeveloperLevel I
Application Engineer / Software Engineer / Software DeveloperLevel II
Application Engineer / Software Engineer / Software DeveloperLevel III
Application Engineer / Software Engineer / Software DeveloperSubject Matter Expert
Application Hosting ManagerLevel I
Application Hosting ManagerLevel II
Application Hosting ManagerLevel III
Application Hosting ManagerSubject Matter Expert
Application Support SpecialistLevel I
Application Support SpecialistLevel II
Application Support SpecialistLevel III
Application Support SpecialistSubject Matter Expert
Application Systems AnalystLevel I
Application Systems AnalystLevel II
Application Systems AnalystLevel III
Application Systems AnalystSubject Matter Expert
Business AnalystLevel I
Business AnalystLevel II
Business AnalystLevel III
Business AnalystSubject Matter Expert
Chemical Analyzer/Laboratory Data System ConsultantLevel I
Chemical Analyzer/Laboratory Data System ConsultantLevel II
Chemical Analyzer/Laboratory Data System ConsultantLevel III
Chemical Analyzer/Laboratory Data System ConsultantSubject Matter Expert
Computer Systems Analyst / Software ArchitectLevel I
Computer Systems Analyst / Software ArchitectLevel II
Computer Systems Analyst / Software ArchitectLevel III
Computer Systems Analyst / Software ArchitectSubject Matter Expert
Database ArchitectLevel I
Database ArchitectLevel II
Database ArchitectLevel III
Database ArchitectSubject Matter Expert
Database EngineerLevel I
Database EngineerLevel II
Database EngineerLevel III
Database EngineerSubject Matter Expert
DevOps/DevSecOps EngineerLevel I
DevOps/DevSecOps EngineerLevel II
DevOps/DevSecOps EngineerLevel III
DevOps/DevSecOps EngineerSubject Matter Expert
Enterprise ArchitectLevel I
Enterprise ArchitectLevel II
Enterprise ArchitectLevel III
Enterprise ArchitectSubject Matter Expert
Infrastructure ArchitectLevel I
Infrastructure ArchitectLevel II
Infrastructure ArchitectLevel III
Infrastructure ArchitectSubject Matter Expert
Laboratory Analytical Systems and Processes ConsultantLevel I
Laboratory Analytical Systems and Processes ConsultantLevel II
Laboratory Analytical Systems and Processes ConsultantLevel III
Laboratory Analytical Systems and Processes ConsultantSubject Matter Expert
Laboratory Data Visualization ExpertLevel I
Laboratory Data Visualization ExpertLevel II
Laboratory Data Visualization ExpertLevel III
Laboratory Data Visualization ExpertSubject Matter Expert
LIMS Data ModelingLevel I
LIMS Data ModelingLevel II
LIMS Data ModelingLevel III
LIMS Data ModelingSubject Matter Expert
LIMS Integration ConsultantLevel I
LIMS Integration ConsultantLevel II
LIMS Integration ConsultantLevel III
LIMS Integration ConsultantSubject Matter Expert
LIMS System IntegratorLevel I
LIMS System IntegratorLevel II
LIMS System IntegratorLevel III
LIMS System IntegratorSubject Matter Expert
LIMS TrainerLevel I
LIMS TrainerLevel II
LIMS TrainerLevel III
LIMS TrainerSubject Matter Expert
Program ManagerLevel I
Program ManagerLevel II
Program ManagerLevel III
Program ManagerSubject Matter Expert
Project ManagerLevel I
Project ManagerLevel II
Project ManagerLevel III
Project ManagerSubject Matter Expert
Quality and Test ExpertLevel I
Quality and Test ExpertLevel II
Quality and Test ExpertLevel III
Quality and Test ExpertSubject Matter Expert
Scientific Data AnalystLevel I
Scientific Data AnalystLevel II
Scientific Data AnalystLevel III
Scientific Data AnalystSubject Matter Expert
Scrum MasterLevel I
Scrum MasterLevel II
Scrum MasterLevel III
Scrum MasterSubject Matter Expert
Security Operations EngineerLevel I
Security Operations EngineerLevel II
Security Operations EngineerLevel III
Security Operations EngineerSubject Matter Expert
Statistical Process Control/Laboratory Data Quality Control ConsultantLevel I
Statistical Process Control/Laboratory Data Quality Control ConsultantLevel II
Statistical Process Control/Laboratory Data Quality Control ConsultantLevel III
Statistical Process Control/Laboratory Data Quality Control ConsultantSubject Matter Expert
System AdministratorLevel I
System AdministratorLevel II
System AdministratorLevel III
System AdministratorSubject Matter Expert
Technical Writer/Documentation SpecialistLevel I
Technical Writer/Documentation SpecialistLevel II
Technical Writer/Documentation SpecialistLevel III
Technical Writer/Documentation SpecialistSubject Matter Expert
User Interface and User eXperience (UX/UI) ExpertLevel I
User Interface and User eXperience (UX/UI) ExpertLevel II
User Interface and User eXperience (UX/UI) ExpertLevel III
User Interface and User eXperience (UX/UI) ExpertSubject Matter Expert

File details come from the government source that posted it. Updated .