Recent State of California Consulting Engagements

• CA Department of Industrial Relations, Oakland, CA (2011)
  For the Agency Director of the DIR and the Executive Officer of the California Commission on Health and Safety and Workers’ Compensation, RTC performed three interrelated strategic studies to evaluate the effectiveness of current computer systems and made recommendations for process and technology improvements to maximize usability and enhance user experience of those systems.

• CA Department of Health Care Services, Sacramento, CA (2011)
  Performed requirements analysis for two new systems replacements. Documented system requirements, staff skill requirements and developed vendor solicitation documents (IT MSA Requests for Offer) including statements of work, cost worksheets, requirements, terms and conditions to upgrade health care information protection for two existing systems as required by federal law. Coordinated scoring and evaluation plan and advised on risk mitigation strategies for effective procurement.

• Inteq, CA Department of Finance (Fi$CAL Project), Legislative Data Center, Defense Finance and Accounting Service, Healthnet, and others, 1996–current; ongoing.
  Developed and facilitated custom classes and workshops for client staff involved in strategic requirements analysis and design projects.

• CA Department of Finance (2008-2009)
  Trained the FI$CAL business analysts on how to develop effective business requirements and create sections of the upcoming FI$CAL RFP. Provided workshops for skills development for the team on data modeling and data requirements analysis, process modeling and mapping, function hierarchy development, and requirements gathering skills.

• CA Department of Public Health (2007-2009)
  Served as project manager for a team of RTC consultants performing a feasibility study to replace an accounting/billing system. Created a business case to justify the system replacement, confirmed requirements with users, analyzed and costed solution alternatives, documenting all findings in FSR form. Developed all sections of the FSR including proposed solution, business case, baseline and costs.

• CA Department of Health Services (2006-2007)
  Managed a team of consultants to develop an ITPP and RFP for the Children’s Medical Services Net system (CMS Net), including ensuring RFP met current DGS guidelines for procurement documents and addenda. Renee served as the Acquisition Manager on this project, checking bid response format and submissions, and participating in confidential discussions during the Draft Proposal phase. Developed an evaluation plan and detailed scoring sheets. Liaised directly with DGS analysts responsible for releasing this DHS RFP.

• CA State Water Resources Control Board (2005-2006)
  Business Process Analysis for the Statewide Budgeting Office- Developed detailed business and systems requirements for a new budgeting system, confirming requirements with users, investigated potential software solutions and costs, and created process and data models of requirements as well as a function hierarchy of requirements for this business process analysis engagement.

• CA State Water Resources Control Board Water Rights Information Management System(2005)
  Developed detailed business and systems requirements for replacement of current Water Rights information systems. Created a business case to justify the replacement, created and confirmed models of requirements with users, provided an analysis of solutions alternatives and costed a proposed solution, documenting all findings in a feasibility study report for this major systems initiative. DOF approved the FSR.

• CA Department of Consumer Affairs (2002-2007) Feasibility studies and business process analyses.
  Renee managed procurement activities and teams of RTC consultants on preparatory systems acquisition efforts for improved licensing and enforcement applications. Enterprise-wide business analysis involved all business entities of DCA in planning improvements in processes prior to acquiring a new licensing and enforcement system for use by all Boards and Bureaus across the State.

• CA Department of Transportation – Common Data Model for Transportation Infrastructure Funding System(2004)
  Renee served as project manager and quality control consultant for this engagement to determine a new integrated basis for sharing data across three major project management and fund tracking systems across Caltrans divisions. Deliverables included a data model, function hierarchy and new database using Oracle 9i to hold data in common to serve all legacy and new functional requirements.

• CA Department of Transportation – IT Systems Inventory Study for the Project Management Office (2003)
  Renée served as overall project manager for a ten-month engagement to interview users and managers across all 800 Caltrans divisions and organizational units to gather IT systems information, model enterprise business functions, review and agree business functions, and design and implement a database system to support the statewide IT systems inventory information. Performed QA and training of PMO staff and provided ongoing project management support, including identification and resolution of issues and risks.

• CA Gambling Control Commission (CGCC), Sacramento CA – RFP (2003)
  Managed quality for a project to develop a 250-page Request for Proposal (RFP) calling for vendors to customize a COTS application for the licensing information system of California’s gambling industry. Reviewed drafts and all deliverables for quality and conformity to DGS guidelines. Served as liaison with government agency departments

• CA Department of Motor Vehicles – Project Advisor for RFP Development (2002)
  Supervised a procurement documentation manager and provided quality assurance services on a project to write a 300-page Request for Proposal (RFP) calling for replacement of DMV core legacy systems with a custom-developed integrated database and set of applications

• CA DFG – HR/Timesheets Analysis of Requirements Project(2002-2003)
  Renée served as project manager and QA consulting for a reengineering project to model business processes using UML and to identify and assess ERP solutions (COTS) for HR and time reporting functions for the Department, and provide feasibility and financial impact recommendations for a new Administrative Systems solution FSR.

• CA DOT – Universal Transportation Project Identifier – Enterprise Business Process Study (2001)
  Project Scope: Perform research and interviews, develop data models, and propose solutions to the lack of a single identifier across different systems for transportation project tracking and accounting.

• CA DMV – “Joint Enterprise Data Integration Strategy” Project – JEDIS (January 2000 to November 2001)
  Project Scope: Team with the Strategic Planning and Control unit to develop skills, identify appropriate work functions and build a team for a newly created data administration function at DMV.

• CA DMV – Enterprise Business Process Integration Project (October 2000 to June 2001)
  Project Scope: Develop an enterprise-wide integrated function hierarchy to integrate core processes across the Occupational Licensing, Drivers’ Licensing and Vehicle Registration areas.

• CA Water Resources Control Board – Enterprise Data Modeling and Documentation (2000-2002)
  Project Scope: Analyze requirements and create a large-scale enterprise-wide model of integrated data requirements for a major alternative procurement effort involving the redesign of multiple systems; train staff and users on CDM and data modeling techniques.

• CA DMV (via Synergy Consulting) Business Process Reengineering, Drivers’ Licensing (July 2000 to June 2001 and July 1999 to June 2000)
  Project Scope: Perform process analysis, data analysis and modeling, quality assurance of data models, user interviewing and process reengineering for the Drivers’ Licensing unit, under subcontract to Synergy Consulting. Provide training, project management support, Oracle Designer, and CDM method expertise to the Process Reengineering team.

• CA Legislative Data Center/Defense Finance and Accounting Service/Washington Mutual and other private clients
  Develop and facilitate custom workshops to aid teams involved in strategic analysis projects.

• Science Applied International Corporation (SAIC) (May 2001-May 2002)
  Project Scope: Provide quality reviews, overall project management, staff training and mentoring, data modeling, requirements analysis, user session facilitation, quality assurance, database design, and Oracle web forms programming for a redesign of SAIC’s contract management system for the Naval Weapons Defense Center.