CA Commission on Teacher Credentialing

ECI was the prime contractor for this project and provided a team of consultants to design, develop and implement the Data Warehouse and SSAP Dashboard application. The solution required deep, expert level understanding of SQL Server, TFS, .NET Framework, Tableau, and MS Office.

Estrada Consulting provided a team of consultants to design, develop and implement the SSAP Dashboard and Data Warehouse.  Established data architecture plan and schedule, provided project work plan and schedule, maintained and updated work plan.  Reviewed and analyzed existing data and data sources, determined logical and physical data model, designed, and created and delivered the enterprise data model.  Identified, diagramed, and catalogued the logical data structures and identified data migration structures.  Conducted data integration, developed dashboards, and migrated data into the new data warehouse.

Results and Value

Development of Data Warehouse and Public Dashboards:

• Provided project work plan and schedule, maintained and updated work plan
• Reviewed and analyzed existing data and data sources
• Determined logical and physical data model.
• Designed and created and delivered the enterprise data model
• Established and maintained data modeling plan and schedule.
• Established data architecture plan and schedule
• Provided detailed design and design document for the data dashboard construction
• Identified, diagramed, and catalogued the logical data structures and identified data migration structures.
• Conducted data integration, developed dashboards, and migrated data into the new data warehouse.
• Developed test scripts and conducted dashboard integration testing.
• Completed ETL scripts.
• Worked with all project stakeholders on the data modeling and data architecture progress and activities.

ECI provided Project Management, Business/Systems Analysis, System Design and Development, Testing, and Knowledge Transfer services, and employed various methodologies such as PMBOK (Plan Schedule Mgmt., Communications Plan, Risk Mgmt., WBS, etc.) Agile (backlog, scrubbing, ceremonies, stand-ups, etc.), Kimball, Test Driven Development, and used Team Foundation Server as Source Control.