Senior Technical Specialist

4. Project Scope / Tasks The consultant will work with the state team and undertake duties as an expert-level business analyst and tester for enterprise on-premise and cloud applications. The consultant will lead efforts to enhance enterprise system(s) / sub-system(s) changes by performing detailed analysis, functional design, and testing activities and support for User Acceptance Testing (UAT) with the program Subject-Matter Experts (SMEs). The work primarily involves facilitation and leading of Joint Application Requirements (JAR) and Joint Application Design (JAD) sessions with SMEs from program and technical teams to ensure their business requirements are met. This also includes the consultant developing and execution of functional test plans for change requests, defect fixes and Business Intelligence (BI) dashboards. The work of the business analyst / tester will also include status reporting, documenting, and maintaining as is and to-be processes, creating and maintaining system functional documentation and business requirements documents. The scope of this project encompasses the following deliverable base tasks : Deliverable 1 : Business analyst for the myCalPERS and other enterprise applications.

• Lead analysis and design efforts for enhancing various enterprise system(s) and sub-systems(s).
• Facilitate and lead Joint Application Requirements (JAR) and Joint Application Development (JAD) sessions with customer representatives, developers, testers, and other technical staff to ensure the customer's needs are met. ESDD Business Analyst and Test Support Letter of Engagement No. 2025-0933
• Create and maintain business requirements document, design artifacts and requirements traceability matrix.
• Build Power BI Dashboards to support data analysis and business decisions. Deliverable 2 : Test support for enterprise applications.
• Assist test personnel with the development of test scenarios and scripts.
• Execute test scenarios and scripts, track, and document defects.
• Develop and provide test results for review.
• Collaborate with various IT and program area staff to triage defects and issues. Deliverable 3 : Knowledge Transfer
• Contractor will provide knowledge transfer of the change requests, associated design documentation and test scripts.
• Knowledge transfer to occur via collaborative documentation, code commenting, cross training, and job shadowing.
• Knowledge transfer to take place at CalPERS via regular scheduled meetings and review of documentation.
• Documentation to include best practices and lessons learned. On an ongoing basis through the end of the contract all work products and deliverables (project status reports, business process, triage incident reports with resolution, meeting minutes, test cases, test outcomes) details have to be discussed with the contract manager to ensure that all of the information is documented and placed in a file share. The contract manager will schedule knowledge transfer sessions at regular intervals to ensure that all of the work production details have been documented and the knowledge has been transferred to the state personnel. SCOPE OF WORK REQUIREMENTS Scoring Points Qualifications 70 1. Nine (9) years' (within the last 12 years) in project work and technical writing to include : detailed analysis, development and maintenance of business requirements, technical requirements, use cases and design documents 0 - 10 2. Nine (9) years' experience (within the last 12 years) in project work in the Business Progress Reengineering (BPR) arena; at least five (5) years of said experience must have been mapping the current state of a business process and analyzing the business process to find gaps. 0 - 10 3. Nine (9) years' (within the last 12 years) experience in project work in large volume data processing and analysis. 0 - 10 4. Must have a minimum of seven (7) years (within the last 10 years) of experience in Oracle 11g and 19c writing and troubleshooting SQL code to design back-end queries for data set-up and verification. 0 - 10 5. Five (5) years' (within the last 10 years) experience performing regression test; writing scripts, executing scripts, creating test cases and test data, reviewing test results; also assisting with User Acceptance Testing (UAT). 0 - 10 6. Seven (7) years' (within the last 10 years) experience with Business Intelligence (BI) dashboards and BI reports in Power BI Platform. 0 - 10 ESDD Business Analyst and Test Support Letter of Engagement No. 2025-0933 Attachment B 7. Experience with testing of software deployments / components in the cloud (Azure or AWS) 8. Experience working with public pension systems or experience with Governmental Retirement Benefits and Health Programs functions. 0 - 5 0 - 5