ATTACHMENT_16_KEY_STAFF_QUALIFICATIONS_MATRIX.xlsx
XLSX spreadsheet 170 KB Posted
- Solicitation number
- 0000040415
- Issued by
- California
About this file
This is a Key Staff Qualifications Matrix worksheet for RFP ISD26-3629, a DMV Digital Experience Platform (DMV DXP) WS3A solicitation. The document serves as an evaluation tool for assessing the qualifications of bidders' proposed key staff members across 25 distinct classifications required to perform implementation services outlined in the Statement of Work (Exhibit A). The 25 key staff positions include Project Manager, Senior Information Architect/Lead, Data Conversion Lead, Senior Data Architect/Database Administrator, ETL Developer, Senior Salesforce Developer, Salesforce Developer, MuleSoft Developer, Senior Integration Lead, Data Analyst, Business Analyst, Senior Program Manager/Engagement Director, Senior Solution Architect/Chief Architect, Legacy/Mainframe Modernization Lead, Security Lead/Contractor Security Manager, Release and Cutover Manager/Transition Manager, Quality Assurance and Test Lead, Data Quality and Reconciliation Lead, OCM Lead, Training and Knowledge Transfer Lead, Scrum Master, Test Automation Engineer, Test Analyst/Tester, Technical Writer/Documentation Lead, and Rules Engine Developer. Bidders must complete qualification worksheets for all DMV-specified key staff and any bidder-specified key staff holding the same roles, with mandatory qualifications evaluated on a pass/fail basis and desirable qualifications awarded points ranging from 117 to 137 points per staff classification.
The worksheet requires bidders to provide detailed information for each proposed key staff member, including full name, start and end dates of relevant experience, client names, project names, and descriptions demonstrating how each project satisfies specific mandatory experience requirements. Bidders must ensure proposed key staff listed in the qualifications matrix match those identified in the Cost Workbook (Exhibit D) and must provide resumes only for bidder-specified key staff, not for DMV-specified key staff. All experience must have occurred within specified timeframes prior to the Phase 1 Response due date, with ongoing projects credited only through that deadline. Key Staff Reference Forms must be provided for each project cited, and the State reserves the right to contact references for verification. The same resource cannot be assigned to multiple roles, and all key staff must serve in full-time capacity. Failure to provide sufficient detail demonstrating satisfaction of minimum experience requirements may result in the bid being deemed non-responsive.
View the file
Other files
Show all 42
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
0-Instructions
| DMV DXP WS3A RFP (ISD26-3629) - Attachment 16: Key Staff Qualifications Matrix | ||
| Worksheet No. | Worksheet Title | Desireable Point Available |
| Worksheet No. 0 | Instructions | |
| Worksheet No. 1 | Project Manager Qualifications | 137 |
| Worksheet No. 2 | Senior Information Architect / Lead Qualifications | 137 |
| Worksheet No. 3 | Data Conversion Lead Qualifications | 131 |
| Worksheet No. 4 | Senior Data Architect/Database Administrator Qualifications | 128 |
| Worksheet No. 5 | Extract / Transform / Load (ETL) Developer Qualifications | 128 |
| Worksheet No. 6 | Senior Salesforce Developer Qualifications | 128 |
| Worksheet No. 7 | Salesforce Developer Qualifications | 128 |
| Worksheet No. 8 | Mulesoft Developer Qualifications | 117 |
| Worksheet No. 9 | Senior Integration Lead Qualifications | 128 |
| Worksheet No. 10 | Data Analyst Qualifications | 117 |
| Worksheet No. 11 | Business Analyst Qualifications | 117 |
| Worksheet No. 12 | Senior Program Manager/Engagement Director Qualifications | 122 |
| Worksheet No. 13 | Senior Solution Architect/Chief Architect Qualifications | 124 |
| Worksheet No. 14 | Legacy/Mainframe Modernization Lead Qualifications | 128 |
| Worksheet No. 15 | Security Lead/Contractor Security Manager Qualifications | 122 |
| Worksheet No. 16 | Release and Cutover Manager/Transition Manager Qualifications | 122 |
| Worksheet No. 17 | Quality Assurance and Test Lead Qualifications | 122 |
| Worksheet No. 18 | Data Quality and Reconciliation Lead Qualifications | 122 |
| Worksheet No. 19 | OCM Lead Qualifications | 121 |
| Worksheet No. 20 | Training and Knowledge Transfer Lead Qualifications | 121 |
| Worksheet No. 21 | Scrum Master Qualifications | 121 |
| Worksheet No. 22 | Test Automation Engineer Qualifications | 117 |
| Worksheet No. 23 | Test Analyst/Tester Qualifications | 117 |
| Worksheet No. 24 | Technical Writer/Documentation Lead Qualifications | 117 |
| Worksheet No. 25 | Rule Engine Developer Qualifications | 127 |
| 3097 |
| Staff Qualifications Matrix Instructions |
| Bidder must complete this workbook for all DMV-Specified Key Staff and any Bidder-Specified Key staff with the same role as DMV-Specified Key Staff roles. Non-Key staff are not to be listed (there are no specified qualifications for Non-Key staff). |
Resumes should be provided for only for Bidder-Specified Key staff. Resumes are NOT required for DMV-specified Key Staff or Non-Key Staff. Instead, satisfaction of requirements for DMV-specified Key Staff must be demonstrated in this workbook. Bidder must specify the required experience in the space allotted for each Key Staff qualification, showing projects used to qualify the Key Staff’s mandatory experience. Key Staff Reference Forms must be provided for each project cited, if required. The State may contact Key Staff references provided to verify the information. Any conflicting information may result in the bid being deemed non-responsive.
Specify the Bidder’s firm name in the appropriate field and enter a response to the "Bidder Agrees?" question for each qualification. Do not enter any information in shaded fields.
Unless stated otherwise, all experience used to meet the minimum requirements must have occurred within the specified number of years prior to the solicitation release date.
Enter the requested information for each Key Staff project that supports the claimed experience. See column definitions below.
If a project end date or experience end date identified on the Key Staff Qualifications matrix exceeds the due date for Submission of Phase 1 Responses - because it is an ongoing project - only credit for the experience acquired up to the due date for Submission of Phase 1 Responses will be provided.
The Total Months column is automatically calculated and rounds up or down to the nearest whole month (e.g., 2/1/2020 to 2/14/2021 = 13 months; 2/1/2020 to 2/13/2021 = 12 months). The day of the month must be provided.
It is Bidder’s responsibility to provide sufficient detail in its responses to permit the State to evaluate the Key Staff's ability to meet the mandatory qualification requirements. If the State is unable to determine the minimum experience has been met, Bidder’s Proposal may be deemed non-responsive.
Key staff are required to serve in a full-time capacity. The same resource may not be assigned to meet multiple roles.
Points will be awarded to Bidders that meet the criteria set forth in the desirable experience qualifications as specified in RFP Section 6: Evaluation.
The following Key Staff are required to perform the services as described in Exhibit A, Statement of Work. Additional Contractor (Key and Non-Key) staff will be necessary, within the fixed costs established by this Agreement, for adherence to the implementation schedule and service-level agreements.
1. Project Manager
2. Senior Information Architect / Project Technical Lead
3. Senior Data Architect / Database Administrator
4. Data Conversion Lead
5. Extract / Transform / Load (ETL) Developer
6. Senior Salesforce Development Lead
7. Salesforce Development Lead
8. Mulesoft Developer
9. Senior Integration Lead
10. Data Analyst
11. Business Analyst
12. Senior Program Manager/Engagement Director
13. Senior Solution Architect/Chief Architect
14. Legacy/Mainframe Modernization Lead
15. Security Lead/Contractor Security Manager
16. Release and Cutover Manager/Transition Manager
17. Quality Assurance and Test Lead
18. Data Quality and Reconciliation Lead
19. OCM Lead
20. Training and Knowledge Transfer Lead
21. Scrum Master
22. Test Automation Engineer
23. Test Analyst/Tester
24. Technical Writer/Documentation Lead
25. Rules Engine Developer
The Bidder must provide sufficient staffing to achieve project deliverables and milestones and ensure the proposed staff shown in this Attachment 17.1: Key Staff Qualifications Matrix matches the proposed staff listed in Exhibit D: Cost Workbook.
| Key Staff Qualifications Bidder Fields |
| > Bidder Agrees: Enter "Yes" or "No" to indicate willingness to fulfill the requirement |
> Bidder's Proposed Staff Name: Specify full name of proposed Key Staff > Start Date: Enter the beginning of the qualifying experience (MM/DD/YYYY) > End Date: Enter the end of the qualifying experience (MM/DD/YYYY). For ongoing, specify the Phase 1 Response due date > Client Name: Enter the name of the agency/organization/entity from which the experience was obtained (Should match name on Reference Form) > Project Name: Enter the name of the project completed on behalf of the named Client (Should match the name on the Reference Form, if Reference Form is required) > Description: Provide a brief description (100 words or less) of the project's scope and how the project helps the Bidder meet the requirement
| Key Staff Qualifications Bidder Fields |
| > Bidder Agrees: Enter "Yes" or "No" to indicate willingness to fulfill the requirement |
> Bidder's Proposed Staff Name: Specify full name of proposed Key Staff and any relevant certification(s) > If additional Key Staff for a given classification within this workbook are being proposed, copy and paste the Key Staff rows for each additional Key Staff
1-Project Mgr
| DMV DXP WS3A RFP (ISD26-3629) - Attachment 16: Key Staff Qualifications Matrix | ||||||||||
| Bidder Name: | Key Staff Qualifications Details | Project #1 | Project #2 | Project #3 | Project #4 | Project #5 | Project #6 | |||
| Req. # | Scoring Element | Bidder Agrees? | ||||||||
| (Yes/No) | Scoring Method | Bidder's Proposed Staff Name | ||||||||
| (First & Last) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description |
(100 words or less)
| EXAMPLE→ | The Staff must possess X experience. | Mandatory | YES | Pass /Fail/Points | Samuel Watkins | 1/1/20 | 12/1/20 | 11 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | 1/1/20 | 2/1/20 | 1 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | |
| Classification 1. PROJECT MANAGER MANDATORY QUALIFICATIONS | ||||||||||||||||||||||||||||||||||||||||||
| PM.1 | The individual proposed as Project Manager (PM) must have experience managing one or more projects with a contract value of at least ten million dollars ($10M), for seven (7) years in the past ten (10) years, involving: | |||||||||||||||||||||||||||||||||||||||||
| • | PM.1a: Modernizing large legacy systems | |||||||||||||||||||||||||||||||||||||||||
| • | PM.1b: Completing data cleansing, conversion, and migration activities | |||||||||||||||||||||||||||||||||||||||||
| • | PM.1c: Developing functionality in Platform as a Service applications | |||||||||||||||||||||||||||||||||||||||||
| • | PM.1d: Integrating enterprise applications with other internal and external systems | |||||||||||||||||||||||||||||||||||||||||
| • | PM.1e: Managing third-party and internal cross-functional teams | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| PM.2 | The individual proposed as PM must have at least two (2) years of experience in the last seven (7) years of experience performing knowledge transfer involving: | |||||||||||||||||||||||||||||||||||||||||
| • | PM.2a: Training and/or training materials development | |||||||||||||||||||||||||||||||||||||||||
| • | PM.2b: System documentation (including tools used, mapping logic, challenges faced, and how they were addressed) | |||||||||||||||||||||||||||||||||||||||||
| • | PM.2c: Data analytics to identify opportunities for further optimization. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| PM.3 | Possession of a current Project Management Institute (PMI) Project Management Professional (PMP) certification OR other current PM certification by a nationally recognized educational body. | Mandatory | Pass / Fail | |||||||||||||||||||||||||||||||||||||||
| PM.4 | A bachelor's degree or equivalent four-year combination of industry-related professional experience and education. | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| Experience in any or all of the following Desirable Qualifications will provide points. | ||||||||||||||||||||||||||||||||||||||||||
| PM.5 | The individual proposed as Project Manager must have at least two (2) years of experience in the last seven (7) years managing projects involving large-scale systems supporting two (2) million transactions per day. | Desirable | 137 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| Desirable Qualifications Points | ||||||||||||||||||||||||||||||||||||||||||
| for Key Staff: | 137 | |||||||||||||||||||||||||||||||||||||||||
| If more than one Key Staff is being proposed for this Classification, copy Rows 2-12 and paste below for each additional Key Staff |
2-Sr. IA-Lead
| DMV DXP WS3A RFP (ISD26-3629) - Attachment 16: Key Staff Qualifications Matrix | ||||||||||
| Bidder Name: | Key Staff Qualifications Details | Project #1 | Project #2 | Project #3 | Project #4 | Project #5 | Project #6 | |||
| Req. # | Scoring Element | Bidder Agrees? | ||||||||
| (Yes/No) | Scoring Method | Bidder's Proposed Staff Name | ||||||||
| (First & Last) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description |
(100 words or less)
| EXAMPLE→ | The Staff must possess X experience. | Mandatory | YES | Pass /Fail/Points | Samuel Watkins | 1/1/20 | 12/1/20 | 11 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | 1/1/20 | 2/1/20 | 1 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | |
| Classification 2. Senior Information Architect / Lead MANDATORY QUALIFICATIONS | ||||||||||||||||||||||||||||||||||||||||||
| SA.1 | The individual proposed as Senior Information Architect / Lead must have experience in a Senior Information Architect / Lead role on a project performed in the last seven (7) years with a contract value of at least ten million dollars ($10M). | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SA.2 | An individual being proposed for the role of Senior Information Architect / Lead must meet at least two (2) of the following SA.2 minimum experience requirements. Satisfaction of the minimum experience requirements must be demonstrated through the Bidder's proposed staff qualification response. | |||||||||||||||||||||||||||||||||||||||||
| • | SA.2a: Seven (7) years or more of experience in the last ten (10) years leading data vision alignment and strategy on projects involving system transformation to Salesforce platform. | |||||||||||||||||||||||||||||||||||||||||
| • | SA.2b: Seven (7) years or more of experience in the last ten (10) years leading mainframe services modernization and integration projects. | |||||||||||||||||||||||||||||||||||||||||
| • | SA.2c: Seven (7) years or more of experience in the last ten (10) years architecting and developing functionality in the Salesforce Platform | |||||||||||||||||||||||||||||||||||||||||
| • | SA.2d: Seven (7) years or more of experience in the last ten (10) years integrating enterprise applications with other internal and external systems using MuleSoft integration Platform. | |||||||||||||||||||||||||||||||||||||||||
| All of the above SA.2 minimum experience requirements must be met by the combined set of proposed staff for the role of Senior Information Architect / Lead. | Mandatory | Pass / Fail | 0 | Ensure this Project Description attests to at least two (2) of the SA.2 minimum experience requirements shown in Column B. | 0 | Ensure this Project Description attests to at least two (2) of the SA.2 minimum experience requirements shown in Column B. | 0 | Ensure this Project Description attests to at least two (2) of the SA.2 minimum experience requirements shown in Column B. | 0 | Ensure this Project Description attests to at least two (2) of the SA.2 minimum experience requirements shown in Column B. | 0 | Ensure this Project Description attests to at least two (2) of the SA.2 minimum experience requirements shown in Column B. | 0 | Ensure this Project Description attests to at least two (2) of the SA.2 minimum experience requirements shown in Column B. | ||||||||||||||||||||||||||||
| SA.3 | The individual proposed as Senior Information Architect / Lead must have at least five (5) years of experience in the last ten (10) years in Salesforce implementation. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SA.4 | The individual proposed as Senior Information Architect / Lead must have at least two (2) years of experience in the last seven (7) years developing system architecture on a project involving more than 10 million records. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SA.5 | The individual proposed as Senior Information Architect / Lead must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Information Architect / Lead role providing knowledge transfer. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SA.6 | The individual proposed as Senior Information Architect / Lead must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Information Architect / Lead role completing data integration via interfaces. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SA.7 | Possession of one or more of the following certifications, in good standing: | |||||||||||||||||||||||||||||||||||||||||
| • | Certified Salesforce Architect | |||||||||||||||||||||||||||||||||||||||||
| • | MuleSoft Certified Integration Architect | |||||||||||||||||||||||||||||||||||||||||
| • | MuleSoft Certified Platform Architect | |||||||||||||||||||||||||||||||||||||||||
| • | Certified Senior System Architect | |||||||||||||||||||||||||||||||||||||||||
| • | Certified Application, Solutions, or Systems Architect | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| SA.8 | Possession of a bachelor’s or advanced degree in Computer Science, Management Information Systems, Engineering, Math, or related field, or four (4) years of equivalent industry-related professional experience and education. | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| Experience in any or all of the following Desirable Qualifications will provide points. | ||||||||||||||||||||||||||||||||||||||||||
| SA.9 | The individual proposed as Senior Information Architect / Lead must have two (2) or more years of experience in the last seven (7) years on project(s) on behalf of a state department of motor vehicles. | Desirable | 137 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| Desirable Qualifications Points | ||||||||||||||||||||||||||||||||||||||||||
| for Key Staff: | 137 | |||||||||||||||||||||||||||||||||||||||||
| If more than one Key Staff is being proposed for this Classification, copy Rows 2-16 and paste below for each additional Key Staff |
3-Data Convers Lead
| DMV DXP WS3A RFP (ISD26-3629) - Attachment 16: Key Staff Qualifications Matrix | ||||||||||
| Bidder Name: | Key Staff Qualifications Details | Project #1 | Project #2 | Project #3 | Project #4 | Project #5 | Project #6 | |||
| Req. # | Scoring Element | Bidder Agrees? | ||||||||
| (Yes/No) | Scoring Method | Bidder's Proposed Staff Name | ||||||||
| (First & Last) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description |
(100 words or less)
| EXAMPLE→ | The Staff must possess X experience. | Mandatory | YES | Pass /Fail/Points | Samuel Watkins | 1/1/20 | 12/1/20 | 11 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | 1/1/20 | 2/1/20 | 1 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | |
| Classification 4. DATA CONVERSION LEAD MANDATORY QUALIFICATIONS | ||||||||||||||||||||||||||||||||||||||||||
| DCL.1 | The individual proposed as Data Conversion Lead must have experience in a Data Conversion Lead role on a project performed in the last seven (7) years with a contract value of at least ten million dollars ($10M). Experience will involve: | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.1a: Performing data cleansing | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.1b: Performing data normalization | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.1c: Ensuring data integrity | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.1d: Measuring data quality | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.1e: Performing data mapping | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.1f: Designing data transformations and integration from multiple data sources | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.1g: Incorporating data security constraints into the conversion solution | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.1h: Working with functional, testing, interface, and other application teams to ensure the Conversion solution supports their requirements | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DCL.2 | The individual proposed as Data Conversion Lead must have at least three (3) years of experience in the last seven (7) years as a Conversion Lead utilizing extract, transform, and load (ETL) toolsets on projects. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DCL.3 | The individual proposed as Data Conversion Lead must have at least three (3) years of experience in the last seven (7) years working with data conversion efforts involving different legacy data formats and legacy data repositories (e.g., DB2). | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DCL.4 | The individual proposed as Data Conversion Lead must have at least three (3) years of experience in the last seven (7) years working with analytical data concepts and implementing data quality standards and methodologies. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DCL.5 | The individual proposed as Data Conversion Lead must have at least two (2) years of experience in the last seven (7) years performing and/or leading teams that performed conversion of legacy systems containing over two hundred (200) million records. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DCL.6 | The individual proposed as Data Conversion Lead must have experience in a Data Conversion Lead role on a legacy mainframe DB2/VSAM data conversion project, including data assessment to evaluate data sources and data quality. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DCL.7 | The individual proposed as Data Conversion Lead must have at least two (2) years of experience in the last seven (7) years of experience in a Data Conversion Lead role on a project involving data migration from existing to new system(s), conducting the following specific activities: | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.7a: Data migration planning | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.7b: Pre-migration validation testing | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.7c: Extract, transform, and load (ETL) – actual data transfer and transformation | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.7d: Post-migration validation to ensure data accuracy and completeness | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.7e: Data security measures for the entirety of the migration process. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DCL.8 | The individual proposed as Data Conversion Lead must have at least two (2) years of experience in the last seven (7) years of experience in a Data Conversion Lead role providing knowledge transfer. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DCL.9 | The individual proposed as Data Conversion Lead must have at least two (2) years of experience in the last seven (7) years of experience in a Data Conversion Lead role completing data integration via interfaces. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DCL.10 | The individual proposed as Data Conversion Lead must have at least two (2) years of experience in the last seven (7) years in: | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.10a: Salesforce experience, and | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.10b: Postgres experience, and | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.10c: Talend experience, and | |||||||||||||||||||||||||||||||||||||||||
| • | DCL.10d: OwnBackup experience. | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| DCL.11 | Possession of a bachelor’s degree or equivalent four (4)-year combination of industry-related professional experience and education. | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| Experience in any or all of the following areas will provide additional points beyond those awarded for the mandatory experience requirements above. | ||||||||||||||||||||||||||||||||||||||||||
| DCL.12 | The individual proposed as Data Conversion Lead must have at least two (2) years of experience in the last seven (7) years on project(s) on behalf of a state department of motor vehicles. | Desirable | 131 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| Desirable Qualifications Points | ||||||||||||||||||||||||||||||||||||||||||
| for Key Staff: | 131 | |||||||||||||||||||||||||||||||||||||||||
| If more than one Key Staff is being proposed for this Classification, copy Rows 2-19 and paste below for each additional Key Staff |
4-Sr. DA_DBA
| DMV DXP WS3A RFP (ISD26-3629) - Attachment 16: Key Staff Qualifications Matrix | ||||||||||
| Bidder Name: | Key Staff Qualifications Details | Project #1 | Project #2 | Project #3 | Project #4 | Project #5 | Project #6 | |||
| Req. # | Scoring Element | Bidder Agrees? | ||||||||
| (Yes/No) | Scoring Method | Bidder's Proposed Staff Name | ||||||||
| (First & Last) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description |
(100 words or less)
| EXAMPLE→ | The Staff must possess X experience. | Mandatory | YES | Pass /Fail/Points | Samuel Watkins | 1/1/20 | 12/1/20 | 11 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | 1/1/20 | 2/1/20 | 1 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | |
| Classification 3. SENIOR DATA ARCHITECT/DATABASE ADMINISTRATOR MANDATORY QUALIFICATIONS | ||||||||||||||||||||||||||||||||||||||||||
| DBA.1 | The individual proposed as Senior Data Architect / Database Administrator must have experience in a data architect role on a project performed in the last seven (7) years with a contract value of at least ten million dollars ($10M). | Mandatory | YES | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
| DBA.2 | The individual proposed as Senior Data Architect / Database Administrator must have at least five (5) years in the last seven (7) years as a data architect, facilitating data vision alignment and strategy on projects involving legacy system transformation to modernized data platform(s), and data cleansing, conversion, and migration project(s). | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.3 | The individual proposed as Senior Data Architect / Database Administrator must have at least five (5) years of experience in the last ten (10) years in data modeling and database design. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.4 | The individual proposed as Senior Data Architect / Database Administrator must have at least two (2) years of experience in the last seven (7) years performing data architecture on a project involving more than two hundred (200) million records. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.5 | The individual proposed as Senior Data Architect / Database Administrator must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Data Architect / Database Administrator role on a legacy mainframe DB2/VSAM data conversion project, including data assessment to evaluate data sources and data quality. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.6 | The individual proposed as Senior Data Architect / Database Administrator must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Data Architect / Database Administrator role on a project involving data migration from existing to new system(s), conducting the following specific activities: | |||||||||||||||||||||||||||||||||||||||||
| • | DBA.6a: Data migration planning | |||||||||||||||||||||||||||||||||||||||||
| • | DBA.6b: Pre-migration validation testing | |||||||||||||||||||||||||||||||||||||||||
| • | DBA.6c: Extract, transform, and load (ETL) – actual data transfer and transformation | |||||||||||||||||||||||||||||||||||||||||
| • | DBA.6d: Post-migration validation to ensure data accuracy and completeness | |||||||||||||||||||||||||||||||||||||||||
| • | DBA.6e: Data security measures for the entirety of the migration process. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.7 | The individual proposed as Senior Data Architect / Database Administrator must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Data Architect / Database Administrator role providing knowledge transfer. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.8 | The individual proposed as Senior Data Architect / Database Administrator must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Data Architect / Database Administrator role completing data integration via interfaces. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.9 | The individual proposed as Senior Data Architect / Database Administrator must have at least two (2) years of experience in the last seven (7) years of experience working with Salesforce data. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.10 | The individual proposed as Senior Data Architect / Database Administrator must have at least two (2) years of experience in the last seven (7) years of experience working with Postgres. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.11 | The individual proposed as Senior Data Architect / Database Administrator must have at least two (2) years of experience in the last seven (7) years of working with OwnBackup. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.12 | Possession of one or more of the following certifications, in good standing: | |||||||||||||||||||||||||||||||||||||||||
| • | Data Architect certification | |||||||||||||||||||||||||||||||||||||||||
| • | Data Modeling certification | |||||||||||||||||||||||||||||||||||||||||
| • | Database Administrator certification | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| DBA.13 | Possession of a bachelor’s or advanced degree in Computer Science, Engineering, Math, or related field, or equivalent four (4)-year combination of industry-related professional experience and education. | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| Experience in any or all of the following areas will provide additional points beyond those awarded for the mandatory experience requirements above. | ||||||||||||||||||||||||||||||||||||||||||
| DBA.14 | The proposed Data Architect must have two (2) or more years of experience in the last seven (7) years on project(s) on behalf of state department of motor vehicles. | Desirable | 64 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| DBA.15 | The proposed Data Architect must have two (2) or more years of experience in the last seven (7) years as a senior ETL Developer or senior data modeler. | Desirable | 64 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| Desirable Qualifications Points | ||||||||||||||||||||||||||||||||||||||||||
| for Key Staff: | 128 | |||||||||||||||||||||||||||||||||||||||||
| If more than one Key Staff is being proposed for this Classification, copy Rows 2-22 and paste below for each additional Key Staff |
5-ETL Dev
| DMV DXP WS3A RFP (ISD26-3629) - Attachment 16: Key Staff Qualifications Matrix | ||||||||||
| Bidder Name: | Key Staff Qualifications Details | Project #1 | Project #2 | Project #3 | Project #4 | Project #5 | Project #6 | |||
| Req. # | Scoring Element | Bidder Agrees? | ||||||||
| (Yes/No) | Scoring Method | Bidder's Proposed Staff Name | ||||||||
| (First & Last) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description |
(100 words or less)
| EXAMPLE→ | The Staff must possess X experience. | Mandatory | YES | Pass /Fail/Points | Samuel Watkins | 1/1/20 | 12/1/20 | 11 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | 1/1/20 | 2/1/20 | 1 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | |
| Classification 5. EXTRACT/TRANSFORM/LOAD (ETL) DEVELOPER MANDATORY QUALIFICATIONS | Mandatory | |||||||||||||||||||||||||||||||||||||||||
| ED.1 | The individual proposed as ETL Developer must have experience in a ETL Developer role on a project performed in the last seven (7) years with a contract value of at least ten million dollars ($10M). | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| ED.2 | The individual proposed as ETL Developer must have at least three (3) years of experience in the last seven (7) years as an ETL Developer utilizing extract, transform, and load (ETL) toolsets on legacy data to Salesforce data projects. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| ED.3 | The individual proposed as ETL Developer must have at least three (3) years of experience in the last seven (7) years working on ETL projects involving at least three (3) different legacy data formats and at least three (3) different legacy data repositories. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| ED.4 | The individual proposed as ETL Developer must have at least two (2) years of experience in the last seven (7) years performing ETL on a project involving more than two hundred (200) million legacy data records to Salesforce. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| ED.5 | The individual proposed as ETL Developer must have at least two (2) years of experience in the last seven (7) years of experience in a ETL Developer role on a legacy mainframe DB2/VSAM data conversion project, including data assessment to evaluate data sources and data quality. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| ED.6 | The individual proposed as ETL Developer must have at least two (2) years of experience in the last seven (7) years of experience in an ETL Developer role on a project involving data migration from existing to new system(s), conducting the following specific activities: | |||||||||||||||||||||||||||||||||||||||||
| • | ED.6a: Data migration planning | |||||||||||||||||||||||||||||||||||||||||
| • | ED.6b: Pre-migration validation testing | |||||||||||||||||||||||||||||||||||||||||
| • | ED.6c: Extract, transform, and load (ETL) – actual data transfer and transformation | |||||||||||||||||||||||||||||||||||||||||
| • | ED.6d: Post-migration validation to ensure data accuracy and completeness | |||||||||||||||||||||||||||||||||||||||||
| • | ED.6e: Data security measures for the entirety of the migration process. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| ED.7 | The individual proposed as an ETL Developer must have at least two (2) years of experience in the last seven (7) years of experience in an ETL Developer role, providing knowledge transfer. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| ED.8 | The individual proposed as an ETL Developer must have at least two (2) years of experience in the last seven (7) years of experience in an ETL Developer role completing data integration via interfaces. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| ED.9 | Possession of one or more of the following certifications, in good standing: | |||||||||||||||||||||||||||||||||||||||||
| • | An SQL programming and database management certification | |||||||||||||||||||||||||||||||||||||||||
| • | A Python, Bash, or Perl scripting language certification. | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| ED.10 | The individual proposed as an ETL Developer must have at least two (2) years of experience in the last seven (7) years of experience in: | |||||||||||||||||||||||||||||||||||||||||
| • | ED.10a: Salesforce experience, and | |||||||||||||||||||||||||||||||||||||||||
| • | ED.10b: Postgres experience, and | |||||||||||||||||||||||||||||||||||||||||
| • | ED.10c: Talend experience, and | |||||||||||||||||||||||||||||||||||||||||
| • | ED.10d: OwnBackup experience. | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| ED.11 | Possession of a bachelor's degree or equivalent four (4)-year combination of industry-related professional experience and education. | Mandatory | Pass / Fail | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | To be listed on resume, with a photocopy of the certification attached | |||||||||||||||||||||||||||||||||
| Experience in any or all of the following areas will provide additional points beyond those awarded for the mandatory experience requirements above. | ||||||||||||||||||||||||||||||||||||||||||
| ED.12 | The individual proposed as ETL Developer must have at least two (2) years of experience in the last seven (7) years on project(s) on behalf of state department of motor vehicles. | Desirable | 64 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| ED.13 | The individual proposed as ETL Developer must have at least four (4) years of experience in the last seven (7) years performing ETL on a project involving more than nine hundred (900) million legacy records. | Desirable | 64 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| Desirable Qualifications Points | ||||||||||||||||||||||||||||||||||||||||||
| for Key Staff: | 128 | |||||||||||||||||||||||||||||||||||||||||
| If more than one Key Staff is being proposed for this Classification, copy Rows 2-20 and paste below for each additional Key Staff |
6-Sr. Salesforce Dev
| DMV DXP WS3A RFP (ISD26-3629) - Attachment 16: Key Staff Qualifications Matrix | ||||||||||
| Bidder Name: | Key Staff Qualifications Details | Project #1 | Project #2 | Project #3 | Project #4 | Project #5 | Project #6 | |||
| Req. # | Scoring Element | Bidder Agrees? | ||||||||
| (Yes/No) | Scoring Method | Bidder's Proposed Staff Name | ||||||||
| (First & Last) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description | |||||||
| (100 words or less) | Start Date | End Date | Total Months | |||||||
| (Calculated) | Client Name | Project Name | Description |
(100 words or less)
| EXAMPLE→ | The Staff must possess X experience. | Mandatory | YES | Pass /Fail/Points | Samuel Watkins | 1/1/20 | 12/1/20 | 11 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | 1/1/20 | 2/1/20 | 1 | Department of ABC | ABC Automation Project | [100 words or less] | 3/1/20 | 4/1/20 | 1 | Department of DEFG | DEFG Automation Project | [100 words or less] | 5/1/20 | 5/1/21 | 12 | Department of HIJ | HIJ Automation Project | [100 words or less] | |
| Classification 6. Senior Salesforce Developer MANDATORY QUALIFICATIONS | ||||||||||||||||||||||||||||||||||||||||||
| SRD.1 | The individual proposed as Senior Salesforce Developer must have at least five (5) years of experience in the last seven (7) years as a Senior Salesforce Developer completing the following: | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1a: Complex Apex coding and Salesforce integration | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1b: Creating and managing Salesforce objects and fields | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1c: Writing Salesforce Object Query Language (SOQL) queries | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1d: Utilizing Lightning components and Lightning Design System | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1e: Implementing data validation rules and workflows. | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1f: Automating complex business transaction states and resolutioning workflows | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1g: Implementing complex Case Management type of workflow for resolution, routing, and approval involving complex layer of users of all levels | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1h: Utilizing OmniStudio components, developing Omniscripts, Data Raptors and integration procedures | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1i: Implementing large-scale complex batch job and scheduling and executions | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1j: Implementing detailed and complex user and transaction auditing and logging | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.1k: Executing complex data loading | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SRD.2 | The individual proposed as Senior Salesforce Developer must have experience in a Senior Salesforce Developer role for at least three (3) years on a project performed in the last seven (7) years with a contract value of at least ten million dollars ($10M). | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SRD.3 | The individual proposed as Senior Salesforce Developer must have at least four (4) years of experience in the last seven (7) years working on Salesforce projects with the following tasks: | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.3a: Using MuleSoft Integration Platform, Rest and SOAP APIs to connect Salesforce with external systems | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.3b: Implementing middleware solutions for complex integrations with Salesforce | |||||||||||||||||||||||||||||||||||||||||
| • | SRD.3c: Ensuring data synchronization between Salesforce and other platforms. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SRD.4 | The individual proposed as Senior Salesforce Developer must have at least four (4) years of experience on Salesforce projects in the last seven (7) years configuring Salesforce settings and features, creating and managing user roles and permissions, and setting up workflows, approval processes, and business validation rules. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SRD.5 | The individual proposed as Senior Salesforce Developer must have at least four (4) years or more of experience in the last seven (7) years working on Salesforce projects identifying and fixing bugs in Apex code and Visualforce pages, providing technical support to end-users, and monitoring Salesforce system performance and making necessary adjustments. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SRD.6 | The individual proposed as Senior Salesforce Developer must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Salesforce Developer role on a large-scale system project supporting one (1) million transactions per day. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SRD.7 | The proposed Senior Salesforce Developer must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Salesforce Developer role on a project involving mainframe batch service migration to SaaS or PaaS. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SRD.8 | The individual proposed as Senior Salesforce Developer must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Salesforce Developer role on a project involving highly detailed auditing and logging to support intelligent fraud detection. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SRD.9 | The individual proposed as Senior Salesforce Developer must have at least two (2) years of experience in the last seven (7) years of experience in a Senior Salesforce Developer role ensuring data security measures for the entirety of the project. | Mandatory | Pass / Fail | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| SRD.10 | Possession of one or more of the following certifications, in good standing: |
This is the start of the file's text. The full file is on GovTribe.
File details come from the government source that posted it. Updated .