Jobs

Description

2-3 days per week 4-8 hrs each day

Standard Hours Per Week : 24.00

Required Skills

• MS Access, Quick Base, Honeywell PHD

Must Have

• CTS

Scope:  detailed description of service & materials requested 

CTS Stabilization and Support

• Diagnose and resolve CTS connectivity and performance issues impacting manufacturing and business processes.
• Restore and maintain connections supporting Posit/Streamlit, R&D applications, and data integrations.
• Identify and document CTS system vulnerabilities, dependencies, and operational risks.
• Support emergency troubleshooting activities during CTS outages or degraded system performance.

QuickBase Recovery and Transition

• Support recovery of QuickBase outages and data access issues.
• Assist with extraction, backup, validation, and preservation of historical QuickBase data.
• Support migration planning and transition activities required to retire QuickBase functionality.
• Document data retention requirements and migration risks.

Golden State Transition Support

• Provide subject matter expertise regarding CTS architecture, interfaces, and data flows.
• Support functional mapping of CTS business processes into SAP, Proficy, Nexus/OneLab, Power BI, and other approved future-state platforms.
• Review migration plans for completeness and operational readiness.
• Assist with cutover preparation and legacy system retirement activities.

CTS to OneLab Plus Master Data Migration Support

• Support identification and extraction of CTS master data required for OneLab Plus implementation.
• Assist with mapping CTS master data structures to OneLab Plus requirements.
• Review and validate migrated data for accuracy, completeness, and usability.
• Identify and resolve legacy data quality issues impacting migration readiness.
• Document data transformation rules, assumptions, and migration dependencies.
• Support testing and validation activities necessary for business acceptance of migrated master data.

Knowledge Transfer and Documentation

Develop documentation covering:

• CTS architecture
• Critical interfaces
• Data flows
• System dependencies
• Business process impacts
• Troubleshooting procedures
• Master data ownership and migration considerations
• Conduct knowledge transfer sessions with site personnel.
• Establish support requirements necessary for complete retirement of CTS and QuickBase.

Expectations:  description of site/area, performance criteria, general expectations, and other special considerations

CTS Stabilization

Success Criteria

• Critical CTS connectivity issues identified and resolved or mitigated.
• Business-critical users regain required system access.
• Known operational risks documented with mitigation plans.

QuickBase Recovery and Data Preservation

Success Criteria

• Historical data successfully backed up and validated.
• Outstanding outage or data-access issues resolved or documented.
• Transition requirements formally established.

Golden State Migration Support

Success Criteria

• Legacy system requirements documented and mapped to future-state platforms.
• Open CTS-related migration gaps identified and addressed.
• Support provided to transition workstreams as requested by project leadership.

CTS-to-OneLab Plus Master Data Migration Package

Success Criteria

• CTS master data inventory identified and documented.
• Required master data extracted and prepared for migration.
• Data mapping and transformation requirements documented.
• Migration validation completed with identified issues addressed or documented.
• Business stakeholders confirm data is suitable for OneLab Plus implementation activities.

Knowledge Transfer Package

Success Criteria

• Complete documentation package delivered.
• Knowledge transfer sessions conducted.
• Support responsibilities transitioned to designated site resources.
• CTS, QuickBase, and OneLab Plus migration knowledge formally documented.

Legacy System Retirement and Exit Strategy

Success Criteria

• Retirement path documented for remaining CTS and QuickBase functions.
• Remaining risks documented.
• Legacy support requirements transferred to appropriate long-term system owners.
• Contractor support no longer required for sustained operations.

Specialty:  individual trade required…electrical, plumbing, millwright, concrete, etc?

The contractor shall possess specialized expertise in legacy manufacturing information systems, IT/OT integration, data migration, and digital transformation initiatives. Specific expertise includes:

• Chemical Tracking System (CTS) architecture, support, and troubleshooting
• CTS is the Chemical Tracking System requiring support, and it is Microsoft Access-based. Microsoft Access is the program/platform skill required to support CTS. Direct CTS experience is preferred but not required; supplier may qualify by demonstrating significant Microsoft Access experience, including database troubleshooting, query development, form/report support, and maintenance of legacy Access-based functionality.
• QuickBase application support, recovery, and retirement
• CTS-to-OneLab Plus master data migration and validation
• Manufacturing data integration and reporting systems
• Data extraction, data retention, and migration methodologies
• Manufacturing process and laboratory data workflows
• Legacy system decommissioning and transition planning
• Knowledge transfer, documentation development, and support model transition
• Sacramento Plant CTS and QuickBase system architecture, business processes, and historical dependencies