Quality


Solicitation 5000000403 Data Management/Quality...

2 downloads 234 Views 439KB Size

State of California

Bid 5000000403

5

Solicitation 5000000403

Data Management/Quality Specialist

designation: Public

State of California

6 6/24/2015 5:38 PM

p. 1

State of California

Bid 5000000403

5000000403 Data Management/Quality Specialist Number   

5000000403

Title   

Data Management/Quality Specialist

Start Date

Jun 23, 2015 8:29:22 AM PDT

End Date

Jul 7, 2015 2:00:00 PM PDT

Contact   

Erin Marty

5

AGPA 916-414-4053 [email protected]

Standard Disclaimer     The State of California advises that prospective bidders periodically check the websites, including but not limited to Bidsync, and/or other state department links for modifications to bid documents. The State of California is not responsible for a prospective bidder's misunderstanding of the bid solicitation or nonresponsive bid due to failure to check these websites for updates or amendments to bid documents, and/or other information regarding the bid solicitations. Failure to periodically check these websites will be at the bidder's sole risk. The information published and/or responded to on these websites is public information. Confidential questions/issues/concerns should be directed to the contact on the ad.

Addendum # 1 New Documents           Attachment I - Proposer Information Offer Sheet.doc Attachment III - Business Reference Sheet.doc Attachment II - Skill Summary Sheet.doc Attachment IV - Personal Approach Sheet Amended.doc

Description The purpose of this RFO is to select one (1) experienced Data Management/Quality Specialist with detailed knowledge and experience of both data management and data quality assurance processes, tools and methodologies to ensure that data management/quality are represented within CalSTRS Information Technology (IT) processes and standards at the enterprise level. The Data Management/Quality (D-M/Q) Specialist is responsible for helping CalSTRS establish, standardize, and mature its overall data management and data quality framework including tools, platforms, methodologies, processes, and best practices, etc.

6 6/24/2015 5:38 PM

p. 2

State of California

Bid 5000000403

CALIFORNIA STATE TEACHERS’ RETIREMENT SYSTEM

Technology Services California Multiple Award Schedule (CMAS) Agreement for a Data Management/Quality Specialist

REQUEST FOR OFFER # 5000000403 OFFER DUE DATE July 7, 2015 Julio Perez Central Procurement Analyst California State Teachers’ Retirement Systems 100 Waterfront Place, Mail Stop #30 West Sacramento, CA 95605 [email protected]

RFO Issue Date: June 23, 2015

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 3

State of California

Bid 5000000403

Request for Offer # 5000000403 Data Management/Quality Specialist Page 2 of 10

REQUEST FOR OFFER

You are invited to review and respond to the California State Teachers’ Retirement System (CalSTRS), Request for Offer (RFO), entitled Data Management/Quality Specialist. Read this document carefully. In submitting your Offer, you must comply with the instructions, terms and conditions stated in this RFO and in your CMAS contract. Your Offer must be received in the office of CalSTRS via email no later than July 7, 2015 by 2:00 p.m. PT. Offers received after the specified date and time may be rejected. You may request clarification of the content of this RFO by submitting written questions to: Julio Perez Central Procurement Analyst [email protected] Any attempt by a firm responding to this Offer to initiate contact with any member of the Teachers’ Retirement Board and/or CalSTRS staff, other than the CalSTRS Contact listed above, regarding this RFO process may disqualify the firm from further consideration. Please note that no verbal information given will be binding upon the California State Teachers’ Retirement System unless such information is incorporated into the RFO via addendum.

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 4

State of California

Bid 5000000403

Request for Offer # 5000000403 Data Management/Quality Specialist Page 3 of 10

GENERAL INFORMATION

A. INTRODUCTION CalSTRS, with a portfolio valued at $193.1 billion as of April 30, 2015, is the largest educator-only pension fund in the United States. CalSTRS administers a hybrid retirement system, consisting of traditional defined benefit, cash balance and voluntary defined contribution plans. CalSTRS also provides disability and survivor benefits. CalSTRS serves California’s 868,000 public school educators and their families from the state’s 1,600 school districts, county offices of education and community college districts. CalSTRS operates under sections of the California Education Code known as the Teachers’ Retirement Law, which established the State Teachers’ Retirement Plan with CalSTRS as the administrator. The purpose of this RFO is to select one (1) experienced Data Management/Quality Specialist with detailed knowledge and experience of both data management and data quality assurance processes, tools and methodologies to ensure that data management/quality are represented within CalSTRS Information Technology (IT) processes and standards at the enterprise level. The Data Management/Quality (D-M/Q) Specialist is responsible for helping CalSTRS establish, standardize, and mature its overall data management and data quality framework including tools, platforms, methodologies, processes, and best practices, etc. You may submit (1) proposed project person for this RFO. The services required are described in Exhibit A, Statement of Work included in this document. The selected respondent/contract personnel are responsible for any travel costs that they may incur while providing the services identified in the Statement of Work. All work must be performed on-site at the CalSTRS headquarter facility in West Sacramento, CA. The total services period may be up to twelve (12) months with an option to extend up to Twenty-four (24) additional months with an estimated average of 160 work hours per month. The proposed project person selected as a result of this RFO will be under the direction of the CalSTRS Chief Technology Officer (CTO) or designee.

B. BACKGROUND The CalSTRS Technology Services (TS) as well as business programs have many reporting needs across the enterprise. The development and maintenance of a consistent and shared enterprise reporting framework will enable CalSTRS to expedite the creation of high quality reports to meet various business needs.

For more information about the CalSTRS organization, mission, vision, and strategic and business plans, go to www.calstrs.com. C. QUALIFICATIONS REQUIREMENTS Proposed project person must meet all of the following minimum qualifications to CalSTRS satisfaction to be given further consideration. Failure to satisfy any of the minimum qualifications upon submittal of the Offer may result in the immediate rejection of the Offer. Minimum Administrative Qualifications As of RFO due date; a) The respondent must hold a current Information Technology California Multiple Award Schedule (CMAS) agreement with the Department of General Services. b) The respondent must submit all data/information and attachments requested in the offer format described in Section D.2 Offer Requirements.

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 5

State of California

Bid 5000000403

Request for Offer # 5000000403 Data Management/Quality Specialist Page 4 of 10

Minimum Technical Qualifications As of the RFO due date, the proposed project person must have: a. As of the RFO due date, the proposed project person must have at least ten (10) years of working experience in Information Technology or Information System (IT or IS) fields with most experiences in the area of data management, database development/administration, or data quality assurance such as data cleansing/reconciliation, data validation, data conversion/migration for large complex software systems; b.

As of the RFO due date, the proposed project person must have at least eight (8) years of experience working as a data modeler creating both logical and physical data models for various relational databases;

c.

As of the RFO due date, the proposed project person must have at least six (6) years of experience performing data migration efforts including analysis, cleansing, conversion, verification and validation to ensure data quality and consistency;

d.

As of RFO due date, the proposed project person must have at least five (5) years of experience working with Microsoft DBMS, i.e. SQL Server 2005/2008/2012, etc.;

e.

As of the RFO due date, the proposed project person must have at least five (5) years of experience analyzing functional and nonfunctional requirements and translating them into technical requirements for data management and data quality assurance purposes;

f.

As of the RFO due date, the proposed project person must have knowledge and at least one (1) year of experience overseeing data cleansing and validation portions of entire System Development Life Cycle (SDLC) to ensure data quality and timely defect resolution(s), etc;

g.

As of the RFO due date, the proposed project person must have at least two (2) years of experience producing the following documents: data verification & validation requirements, data management/quality frameworks that encompass the standards, processes, tools, and best practices in data management/quality at the enterprise level; and

h.

As of RFO due date, the proposed project person m ust have a Bachelor degree or higher in computer science/engineering or comparable technical training/education from a government accredited/sanctioned college or university as evidenced by a copy of the diploma/certificate.

2b. Desirable Technical Qualifications It is desirable for the proposed project person to have the following listed experience, knowledge, skills and abilities: a. As of RFO due date, the proposed project person has two (2) years or more of experience working as a Database Administrator (DBA) on MS DBMS, etc.; b. In-depth knowledge with various enterprise technologies and software products such as Enterprise Information Management, Enterprise Content Management, and Enterprise Resource Planning products (for example, SAP, MS Dynamics CRM etc.); c. Experience working with legacy mainframe applications; d. As of RFO due date, the proposed project person has experience producing the following documents: technical requirements, data requirements, data conversion/migration platform architecture, data validation test cases etc.

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 6

State of California

Bid 5000000403

Request for Offer # 5000000403 Data Management/Quality Specialist Page 5 of 10

D. OFFER REQUIREMENTS AND INFORMATION 1.

2.

3.

Time Schedule CalSTRS will use its best efforts to adhere to the time schedule. However, CalSTRS reserves the right to amend the time schedule, as it deems necessary. Event

Date

Release of RFO

June 23, 2015

Offer Due Date

July 7, 2015, 2:00 p.m. PT

Estimated Start Date for Written Offer Comparisons and Interviews

TBD

Estimated Start Work Date

TBD

Offer Requirements To be eligible, an Offer must include the following listed attachments: a.

Attachment I, Information & Offer Sheet

b.

Attachment II, Skill Summary Sheet

c.

Attachment III, Business Reference Sheet One (1) Business Reference Sheet must be completed for each proposed project person. Business references should be able to verify the proposed project person’s experience, within the last fifteen (15) years.

d.

Attachment IV, Personal Approach Sheet

e.

Proposed project person’s Resume

f.

Current California Multiple Award Schedule (CMAS) Agreement One (1) copy of the Respondent’s current complete/signed CMAS agreement and all supplements issued by the Department of General Services.

g.

Current General Services Administration (GSA) Agreement One (1) copy of the Respondent’s current GSA agreement pricing pages applicable to the Respondent’s CMAS contract, which includes the personnel classifications, hourly rates, and minimum qualifications.

Submission of Offer a. The Offer must be submitted via email to [email protected] and received no later than the Offer due date and time specified on the cover page of this RFO. Late and incomplete Offers may be rejected. b.

It is the Respondent’s responsibility to respond with all data/information requested; provide data/information that is deemed adequate for CalSTRS to determine/verify the proposed project person’s ability to perform the tasks/activities defined in Exhibit A, Statement of Work; and submit all data/information in the Offer format described in Section D. Subsection 3. Offer Requirements.

c.

By submittal of an Offer, the Respondent declares that any proposed project person is in compliance with all experience, qualification, and education requirements stipulated in the CMAS and GSA agreements.

d.

This RFO and all Offers in response to this RFO will be made a part of the resulting contract file. All documents submitted in response to this RFO will become the property of the State of California and may be subject to review by or release to the public under the California Public Records Act, Government Code 6250 et seq.

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 7

State of California

Bid 5000000403

Request for Offer # 5000000403 Data Management/Quality Specialist Page 6 of 10

4.

e.

CalSTRS encourages Respondents to submit their Offers early.

f.

CalSTRS accepts no responsibility for any technical difficulties associated with the electronic transmission of any Offer.

g.

Costs for developing Offers and in anticipation of award of an agreement are entirely the responsibilities of the Respondents and shall not be charged to CalSTRS.

h.

Respondents may modify their Offer, after its submission, by withdrawing their original Offer and resubmitting a new Offer prior to the submission due date. Offer modifications submitted in any other manner, oral or written, will not be considered. Respondents may withdraw their own Offer by submitting a written withdrawal request to the CalSTRS Contact via email at [email protected]. Respondents may thereafter submit a new Offer prior to the Offer due date.

i.

CalSTRS may modify the RFO prior to the Offer due date by issuing an addendum.

j.

Respondents are cautioned to not rely on CalSTRS to discover and report to the Respondent any defects or errors in the submitted documents. Respondents, before submitting their documents, should carefully proofread for errors and ensure adherence to the RFO requirements.

k.

CalSTRS reserves the right to reject all Offers. CalSTRS is not required to award an agreement.

Comparison Process a. Upon receipt, Offers will be checked for the presence or absence of required content. Incomplete Offers may be rejected. No assumptions will be made by CalSTRS regarding the intentions of the Respondent in submitting the Offer. b.

Offers and any subsequent presentations should be submitted with the most favorable terms the Respondent can offer.

c.

If CalSTRS is unable to execute an agreement with the highest scoring responsible Respondent, CalSTRS reserves the right to award the agreement to the next highest scoring responsible Respondent.

d.

Offers will be reviewed to determine best value using the following five (5) phases. PHASES 1 2 3 4 5

SATISFACTION OF MINIMUM QUALIFICATIONS WRITTEN OFFER COMPARISON INTERVIEWS COST COMPARISON TOTAL SCORE REFERENCE CHECKS/COST NEGOTATIONS

Pass/Fail 75 points 100 points 75 points 250 points Pass/Fail

1) The Respondent’s proposed project person will be reviewed to determine all of the minimum qualifications are met to CalSTRS satisfaction to be given further consideration. Failure to satisfy any of the minimum qualifications upon submittal of the Offer will result in the immediate rejection of the offer. 2) Offers meeting the minimum qualifications will move to Phase 2, Written Offer Comparison, to be reviewed for expertise, education, and experience of the proposed project person in the criteria listed above by a team composed of at least two (2) CalSTRS employees. 3) In Phase 3, highest scoring respondents, from the Written Offer Comparison, will be invited for one or more rounds of interviews. 4) In Phase 4, Cost Comparison will be considered for Respondents who participated in Phase 3. The hourly rates provided in the Respondent’s Attachment I, will be reviewed using the cost formula indicated below. The Offer with the lowest rate will receive the full allotment of points.

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 8

State of California

Bid 5000000403

Request for Offer # 5000000403 Data Management/Quality Specialist Page 7 of 10

Lowest Proposed Cost x Maximum Number Points (75) = Respondent’s Score Respondent’s Cost 5) In Phase 5, CalSTRS may conduct reference checks and negotiate rates with the Respondent with the highest score after Phase 4. If either reference checks or cost negotiations are not successful with the highest scoring Respondent, CalSTRS reserves the right to conduct reference checks and negotiate rates with the successively highest scoring Respondent(s). 5.

Award If at any time during or at the conclusion of this RFO process CalSTRS determines that, in its opinion, the results of this process are unsatisfactory, CalSTRS reserves the right to discontinue this process and decline to award an agreement. If CalSTRS enters into an agreement, it will be with the Respondent having the highest score, subject to cost negotiations, and satisfying all the requirements for this RFO.

6.

Payment Structure The payment structure for activities performed under Exhibit A, Statement of Work, is: Deliverables Based Hourly Invoices shall be submitted in triplicate not more frequently than monthly in arrears. Invoice(s) must include: 1) Purchase Order Number, 2) Contractor’s name, address and telephone number, 3) total amount of invoice, 4) copies of the Contractor’s weekly status reports that cover the invoice dates, and 5) a copy of the timesheet approved/signed by the CalSTRS Contract Manager that covers the invoice dates.

7.

Services or Procurement Resulting from Agreement No person, firm, or subsidiary thereof awarded an agreement resulting from this RFO may submit a bid for, nor be awarded a contract for, the provision of services, procurement of goods or supplies, or any other related action which is required, suggested, or otherwise deemed appropriate in the end product of an agreement resulting from this RFO. (PCC§10365.5).

8.

Workers’ Compensation/Employer’s Liability Insurance Contractor shall maintain statutory workers’ compensation and employer’s liability coverage for all its employees who will be engaged in the performance of the agreement, including special coverage extensions where applicable.

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 9

State of California

Bid 5000000403

Request for Offer # 5000000403 Data Management/Quality Specialist Page 8 of 10

EXHIBIT A STATEMENT OF WORK The Data Management/Quality Specialist, i.e. Contractor, will ensure that data management/quality strategy, processes, standards, and relevant technology trends are incorporated into CalSTRS Information Technology (IT) at the enterprise level. The Contractor is responsible for helping CalSTRS realize that its future-state IT architecture must include data management/quality through the involvement of business programs and project teams to develop the CalSTRS overall data management/quality framework. The development of a consistent enterprise data management/quality framework allows CalSTRS to obtain the optimum value for the investments made in technology, and most importantly, in the new pension solution. All work must be performed onsite at the CalSTRS headquarter facility in West Sacramento, CA. SCOPE OF SERVICES During this engagement, the Contractor reports directly to CalSTRS Chief Technology Officer (CTO) or designee(s), and may be assigned to one or more teams, programs or projects during the total services period. Contractor shall perform all of the following tasks and deliverables: 1.

Development of Data Management/Quality Framework; •

Review business requirements documentation and various technical documentation to understand the business needs, issues and concerns with respect to the data quality related to the legacy systems and new pension solutions;



Collaborate with both business and IT SMEs to collect, verify, develop, and document applicable data quality requirements;



Propose a framework that include strategies, methodologies, processes and tools covering various aspects of such as data management/quality measurements, data quality assurance, data migration, etc. and



Review, update, and provide written comments on all data quality related documentation, e.g. test results and reports.

Specific Deliverables(s) 1.

2.

Develop, review, update, and provide all applicable data management/quality documents and specification documents, as well as other applicable technical analysis documentation using CalSTRS documentation templates.

Enterprise Data Cleansing, Validation, and Migration Methodologies; •

Collaborate with other CalSTRS teams and designated SMEs to suggest and make improvements to the processes and approaches in data cleansing, validation, conversion and migration efforts with respect to the upcoming new pension solution.



Lead and/or assist in developing a set of standards, processes, and best practices in using tools to perform data quality assurance effort.

Specific Deliverables(s) 1.

3.

Develop, review, update, and provide a set of documents for the enterprise data management, data quality assurance and data migration, as well as other applicable technical documentation using CalSTRS documentation templates.

Enterprise Data Management/Quality Standards and Processes Oversight and Support; •

Work with various CalSTRS teams to ensure enterprise DQM standards and processes are followed;



Review data quality assurance and migration processes and procedures to verify its conformance to the enterprise data management/quality standards and best practices; and

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 10

State of California

Bid 5000000403

Request for Offer # 5000000403 Data Management/Quality Specialist Page 9 of 10



Provide guidance and support to other CalSTRS teams; explaining data management/quality standards, processes, and best practices to various stakeholders.

Specific Deliverable(s) 1.

4.

Monthly updates of status reports detailing major technical activities, task status, schedule status, issues, and risks and mitigations.

Technical Knowledge Transfer; •

Conduct fifty-two (52) one-hour informal knowledge transfer sessions;



Conduct twelve (12) one-hour formal knowledge transfer sessions;



Support CalSTRS staff at meetings, via email or personal inquiries; and



Incorporate information into technical requirements and analysis artifacts.

Specific Deliverable(s)

1. All applicable training materials and documentation. 2. Written report of formal knowledge transfer sessions to include attendees, time and date, and any action items. 5.

Status Reporting(s); •

Update monthly engagement status;



Develop and present technical findings for schedule, resources, issues, risks and mitigations during the monthly status review;



Monthly status report, to include, but is not be limited to all of the following: •

Meetings attended, presentations delivered, and completed assignments;



Activities planned for the coming month; and



Observations and recommendations.

Specific Deliverables(s) 1. Written monthly report, due five (5) working days after the start of the next month, detailing project status; (i.e. technical findings for schedule, resources, issues, risks, monthly activities, meetings attended, and plans for the coming month).

6.

Final Report; Upon completion of the contract, Contractor shall submit a Final Report to CalSTRS to include, but not limited to, project activities, accomplishments, budget summary, lessons learned, and suggestions/recommendations for developing and/or improving ongoing maintenance and support. The Final Report shall summarize all activities, tasks, results, anomalies, and dispositions. Specific Deliverable(s) 1.

Final report using CalSTRS template due two (2) weeks after contract end date.

Transfer of knowledge to appropriate CalSTRS employees is required.

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 11

State of California

Bid 5000000403

Request for Offer # 5000000403 Data Management/Quality Specialist Page 10 of 10

Completion Criteria Deliverables/tasks will include all work assignments identified to be completed. Deliverables/tasks are considered complete after a quality assurance process is completed and approved by designated reviewers. Performance and timeliness of all deliverables/tasks will be monitored via the submission of weekly status reports and meetings. Status and actual hours will be reported on a weekly basis for the deliverables/tasks assigned. Each deliverable/task will be tracked via the appropriate program/project schedule and budget to monitor progress toward the completion of the deliverables/tasks and milestones.

Security and Confidentiality CalSTRS Human Resources Office shall conduct a background investigation on any contractor personnel that will have access to confidential information. CalSTRS will issue a badge for physical security to the appropriate CalSTRS work areas. The CalSTRS Contract Manager will identify the data access requirements for access to system data and coordinate with appropriate channels to ensure the proper access is assigned and reviewed periodically for update as necessary. Access rights will be monitored and concerns of improper data access will be brought to the attention of the CalSTRS Contract Manager.

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 12

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 1 of 1

ATTACHMENT I Information and Offer Sheet Firm Firm Name Street Address City, State, Zip Code CMAS & Small Business / DVBE Certification CMAS Number CMAS Term Dates Certified Small Business Enterprise Yes or No. If Yes, provide number.

Certified Disabled Veteran Business Enterprise Yes or No. If Yes, provide number.

Administrative Contact Name Title Office Telephone # (Include area code) Cell Telephone # (Include area code) FAX # (Include area code) Email Address Authorized Signer Name Title Office Telephone # (Include area code) Cell Telephone # (Include area code) FAX # (Include area code) Email Address

Proposed Project Person Name of Proposed Project Person CMAS (GSA) Classification CMAS (GSA) Hourly Rate Discount Hourly Rate Offered

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 13

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 1 of 9

ATTACHMENT II Proposed Project Person Skill Summary Sheet

Firm Name Proposed Project Person Name Proposed Project Person must meet the following minimum qualification(s) to CalSTRS satisfaction to be given further consideration. Failure to satisfy any of the minimum qualifications upon submittal of the response may result in the immediate rejection of the response.

MINIMUM TECHNICAL QUALIFICATIONS a.

YES / NO

NUMBER OF YEARS

As of the RFO due date, the proposed project person must have at least ten (10) years of working experience in Information Technology or Information System (IT or IS) fields with most experiences in the area of data management, database development/administration, or data quality assurance such as data cleansing/reconciliation, data validation, data conversion/migration for large complex software systems.

Do you meet the above minimum qualification(s)? Please give us a detailed description (including dates and locations) of specific work experience that meets the minimum qualifications.

Description

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 14

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 2 of 9

MINIMUM TECHNICAL QUALIFICATION b.

YES / NO

NUMBER OF YEARS

As of the RFO due date, the proposed project person must have at least eight (8) years of experience working as a data modeler creating both logical and physical data models for various relational databases

Do you meet the above minimum qualification(s)? Please give us a detailed description (including dates and locations) of specific work experience that meets the minimum qualifications.

Description

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 15

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 3 of 9

MINIMUM TECHNICAL QUALIFICATION c.

YES / NO

NUMBER OF YEARS

As of the RFO due date, the proposed project person must have at least six (6) years of experience performing data migration efforts including analysis, cleansing, conversion, verification and validation to ensure data quality and consistency.

Do you meet the above minimum qualification(s)? Please give us a detailed description (including dates and locations) of specific work experience that meets the minimum qualifications.

Description

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 16

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 4 of 9

MINIMUM TECHNICAL QUALIFICATION d.

YES / NO

NUMBER OF YEARS

As of the RFO due date, the proposed project person must have at least five (5) years of experience working with Microsoft DBMS, i.e. SQL Server 2005/2008/2012, etc.

Do you meet the above minimum qualification(s)? Please give us a detailed description (including dates and locations) of specific work experience that meets the minimum qualifications.

Description

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 17

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 5 of 9

MINIMUM TECHNICAL QUALIFICATION e.

YES / NO

NUMBER OF YEARS

As of the RFO due date, the proposed project person must have at least five (5) years of experience analyzing functional and non-functional requirements and translating them into technical requirements for data management and data quality assurance purposes.

Do you meet the above minimum qualification(s)? Please give us a detailed description (including dates and locations) of specific work experience that meets the minimum qualifications.

Description

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 18

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 6 of 9

MINIMUM TECHNICAL QUALIFICATION f.

YES / NO

NUMBER OF YEARS

As of the RFO due date, the proposed project person must have knowledge and experience overseeing data cleansing and validation portions of entire System Development Life Cycle (SDLC) to ensure data quality and timely defect resolution(s), etc.

Do you meet the above minimum qualification(s)? Please give us a detailed description (including dates and locations) of specific work experience that meets the minimum qualifications.

Description

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 19

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 7 of 9

MINIMUM TECHNICAL QUALIFICATION g.

YES / NO

NUMBER OF YEARS

As of the RFO due date, the proposed project person must have experience producing the following documents: data verification & validation requirements, data management/quality frameworks that encompass the standards, processes, tools, and best practices in data management/quality at the enterprise level.

Do you meet the above minimum qualification(s)? Please give us a detailed description (including dates and locations) of specific work experience that meets the minimum qualifications.

Description

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 20

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 8 of 9

MINIMUM TECHNICAL QUALIFICATION h.

YES / NO

NUMBER OF YEARS

As of the RFO due date, the proposed project person must have a Bachelor degree or higher in computer science/engineering or comparable technical training/education from a government accredited/sanctioned college or university as evidenced by a copy of the diploma/certificate.

Do you meet the above minimum qualification(s)? Please give us a detailed description (including dates and locations) of specific work experience that meets the minimum qualifications.

Description

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 21

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 9 of 9

For each DESIRABLE QUALIFICATION give a brief description (including dates and locations) of specific work experience that meets/exceeds the skill criteria and demonstrates the number of YEARS entered. Descriptions and YEARS entered must clearly map back to specific employment history listed on your resume.

DESIRABLE TECHNICAL QUALIFICATIONS a.

NUMBER OF YEARS

As of the RFO due date, the proposed project person has two (2) years or more of experience working as a Database Administrator (DBA) on MS DBMS, etc.

Description

b.

In-depth knowledge with various enterprise technologies and software products such as Enterprise Information Management, Enterprise Content Management, and Enterprise Resource Planning products (for example, SAP, MS Dynamics CRM etc.).

Description

c.

Experience working with legacy mainframe applications;

Description

d.

As of RFO due date, the proposed project person has experience producing the following documents: technical requirements, data requirements, data conversion/migration platform architecture, data validation test cases etc.

Description

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 22

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 1 of 1

ATTACHMENT III Proposed Project Person Business Reference Sheet Firm Name Proposed Project Person Name

Reference 1 Name of Company/Agency Company/Agency City, State Contact Person (Name and Title) Contact Telephone # (Include area code) Contact Email Address Dates of Service Reference 2 Name of Company/Agency Company/Agency City, State Contact Person (Name and Title) Contact Telephone # (Include area code) Contact Email Address Dates of Service Reference 3 Name of Company/Agency Company/Agency City, State Contact Person (Name and Title) Contact Telephone # (Include area code) Contact Email Address Dates of Service

Our Mission: Securing the Financial Future and Sustaining the Trust of California’s Educators 6/24/2015 5:38 PM

p. 23

State of California

Bid 5000000403

Request for Offer 5000000403 Technology Services Data Management/Quality Specialist Page 1 of 1

ATTACHMENT IV Proposed Project Person Personal Approach Sheet

Firm Name Proposed Project Person Name Table 1 Describe your methodology and approach to complete the services identified in the RFO 5000000403 Statement of Work. Include how you plan to provide the services, your needs to complete the services, your assumptions, and your constraints. Also include any industry practices and standards that will be followed. The content of Table 1 may be a maximum of two (2) pages. Table 1 – Methodology and Approach Description

6/24/2015 5:38 PM

p. 24

State of California

Question and Answers for Bid #5000000403 - Data Management/Quality Specialist

Bid 5000000403

5

Overall Bid Questions There are no questions associated with this bid.   

6 6/24/2015 5:38 PM

p. 25