Overview
Skills
Job Details
| TITLE OF POSITION | Business Analyst and Test Support (Project Role: Senior Technical Specialist) |
| AGENCY NAME | The California Public Employees' Retirement System (CalPERS) |
| PERIOD OF PERFORMANCE | 1 Year |
| REFERENCES | Three |
| INTERVIEW | Virtual or Client location (As client's Discretion) |
| PLACE OF PERFORMANCE | Hybrid (Consultant will be required to report to the CalPERS Headquarters three days per week) |
| SCOPE OF WORK | 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. |
| *Mandatory Experience | |
| Please see attachment A- Evaluation Criteria- Separately attached (Candidate needs to fill out the form) | |
| Role and Responsibilities | |
| 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. 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. |
EVALUATION CRITERIA FOR BEST VALUE AWARD
| Qualifications
| Writeup By Consultant |
| 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
|
|
| 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.
|
|
| 3. Nine (9) years' (within the last 12 years) experience in project work in large volume data processing and analysis.
|
|
| 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.
|
|
| 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).
|
|
| 6. Seven (7) years' (within the last 10 years) experience with Business Intelligence (BI) dashboards and BI reports in Power BI Platform.
|
|
| 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.
|
|