{"id":1145,"date":"2022-03-22T20:35:01","date_gmt":"2022-03-22T20:35:01","guid":{"rendered":"https:\/\/shabnamyazdani.com\/delegata\/?page_id=1145"},"modified":"2022-06-21T17:59:39","modified_gmt":"2022-06-21T17:59:39","slug":"san-joaquin-county","status":"publish","type":"page","link":"https:\/\/shabnamyazdani.com\/delegata\/san-joaquin-county\/","title":{"rendered":"San Joaquin County (SJC) Case Studies"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"1145\" class=\"elementor elementor-1145\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-dace051 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"dace051\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-29f3e4f\" data-id=\"29f3e4f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-0729e05 elementor-widget elementor-widget-image\" data-id=\"0729e05\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"150\" height=\"150\" src=\"https:\/\/i0.wp.com\/shabnamyazdani.com\/delegata\/wp-content\/uploads\/2022\/03\/san-joaquin-county-logo-150x150-1.png?fit=150%2C150&ssl=1\" class=\"attachment-large size-large wp-image-956\" alt=\"\" srcset=\"https:\/\/i0.wp.com\/shabnamyazdani.com\/delegata\/wp-content\/uploads\/2022\/03\/san-joaquin-county-logo-150x150-1.png?w=150&ssl=1 150w, https:\/\/i0.wp.com\/shabnamyazdani.com\/delegata\/wp-content\/uploads\/2022\/03\/san-joaquin-county-logo-150x150-1.png?resize=77%2C77&ssl=1 77w, https:\/\/i0.wp.com\/shabnamyazdani.com\/delegata\/wp-content\/uploads\/2022\/03\/san-joaquin-county-logo-150x150-1.png?resize=92%2C92&ssl=1 92w, https:\/\/i0.wp.com\/shabnamyazdani.com\/delegata\/wp-content\/uploads\/2022\/03\/san-joaquin-county-logo-150x150-1.png?resize=100%2C100&ssl=1 100w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-fbf0c21\" data-id=\"fbf0c21\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a44808e elementor-widget elementor-widget-heading\" data-id=\"a44808e\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">San Joaquin County (SJC) Case Studies<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2f8a9d2 elementor-widget elementor-widget-text-editor\" data-id=\"2f8a9d2\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>San Joaquin County (SJC) boasts seven cities (approximately 921,600 total acres) and an array of opportunities for boating, fishing, camping, and history-gathering. Each city, including the unincorporated County areas, offers a way to enjoy California\u2019s nature and culture.<\/p><p>SJC is the 15th largest county in California and the nation\u2019s eighth leading producer of agricultural products. Covering 1,400 square miles, its population is nearly 600,000 people. To better serve its employees, reduce costs, and improve operational efficiencies, SJC partnered with Delegata to leverage web-based technologies that provide an effective Government-to-Employee (G2E) platform and bring additional information and efficiency to support County employees.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2e60b98 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2e60b98\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-11a114f\" data-id=\"11a114f\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-a0437b1 elementor-widget elementor-widget-heading\" data-id=\"a0437b1\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">County Intranet Portal<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8d63356 elementor-tabs-view-horizontal elementor-widget elementor-widget-tabs\" data-id=\"8d63356\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-tabs\">\n\t\t\t<div class=\"elementor-tabs-wrapper\" role=\"tablist\" >\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1481\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-1481\" aria-expanded=\"false\"> The Challenge<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1482\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1482\" aria-expanded=\"false\">The Solution<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-1483\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1483\" aria-expanded=\"false\">  The Benefits<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"elementor-tabs-content-wrapper\" role=\"tablist\" aria-orientation=\"vertical\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-1481\" aria-expanded=\"false\"> The Challenge<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1481\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1481\" tabindex=\"0\" hidden=\"false\"><p>With more than 7,000 employees across 30 departments using a variety of computer systems, San Joaquin County had a major integration challenge. Technology needed to play a key role in supporting the delivery of administrative services through easy access to internal business and employee services. Solutions needed to integrate new technologies with previous legacy investments and processes to effectively move SJC toward its eGovernment vision.<\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1482\" aria-expanded=\"false\">The Solution<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1482\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1482\" tabindex=\"0\" hidden=\"hidden\"><p>SJC partnered with Delegata to establish an eGovernment infrastructure capable of quickly and efficiently deploying applications and data throughout the organization. Delegata combined its knowledge of government services and technology, employing Oracle\u2019s newly released 9iAS Portal, to create SJC\u2019s innovative Intranet portal. The solution required working closely with Oracle to refine and maximize the portal\u2019s ability to meet the County\u2019s needs. Leveraging off-the-shelf capabilities with existing SJC systems and data, Delegata combined our strong information architecture, systems integration and quality assurance expertise to deliver an integrated, sustainable solution.<\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-1483\" aria-expanded=\"false\">  The Benefits<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-1483\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-1483\" tabindex=\"0\" hidden=\"hidden\"><p>With the Intranet portal project, SJC made noticeable strides toward full eGovernment implementation with the ability to quickly integrate and distribute applications as needed. Overall collaboration levels were improved, providing employees with quick access to news and business information. The Oracle 9iAS platform also supports improved information management and library capabilities and addresses archive issues. Additionally, the portal provides a unified place for County employees to access information, equipping them with an effective access point for enterprise-wide operations knowledge.<\/p><\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-eb03382 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"eb03382\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-16dd813\" data-id=\"16dd813\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-60c8713 elementor-widget elementor-widget-heading\" data-id=\"60c8713\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Data Warehouse<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-46b0a26 elementor-tabs-view-horizontal elementor-widget elementor-widget-tabs\" data-id=\"46b0a26\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"tabs.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-tabs\">\n\t\t\t<div class=\"elementor-tabs-wrapper\" role=\"tablist\" >\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-7411\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-7411\" aria-expanded=\"false\"> The Challenge<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-7412\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-7412\" aria-expanded=\"false\">The Solution<\/div>\n\t\t\t\t\t\t\t\t\t<div id=\"elementor-tab-title-7413\" class=\"elementor-tab-title elementor-tab-desktop-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-7413\" aria-expanded=\"false\">  The Benefits<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t<div class=\"elementor-tabs-content-wrapper\" role=\"tablist\" aria-orientation=\"vertical\">\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"true\" data-tab=\"1\" role=\"tab\" tabindex=\"0\" aria-controls=\"elementor-tab-content-7411\" aria-expanded=\"false\"> The Challenge<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-7411\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"1\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-7411\" tabindex=\"0\" hidden=\"false\"><p>With many aging systems supporting the information needs for the county justice system, there were significant problems in trying to obtain information on a required topic, when the data partially resided in multiple systems in use. Management decisions could not be made on which problems could be resolved, where money was not being collected, what services were performing at appropriate levels, and many other factors that would allow the county to function with a more strategic focus.<\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"2\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-7412\" aria-expanded=\"false\">The Solution<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-7412\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"2\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-7412\" tabindex=\"0\" hidden=\"hidden\"><p>The Data Warehouse initiative began more as a strategy engagement. Initially, the defined requirements pointed to the need for a reporting database. As the details behind other systems and other areas of concern to the county began to clarify, the solution became a comprehensive data warehouse that did not consolidate most information, but rather provided the means to pull information from multiple systems throughout the county justice application suite, so that required facts could be obtained based on predominant dimensions of data in use within the county organizations. During the initiative, significant connectivity and access problems were resolved, enabling the data warehouse to operate within the defined enterprise architecture. Concurrently, the various factions within the county came to realize and appreciate what the data warehouse provided as an information asset.<\/p><\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-tab-title elementor-tab-mobile-title\" aria-selected=\"false\" data-tab=\"3\" role=\"tab\" tabindex=\"-1\" aria-controls=\"elementor-tab-content-7413\" aria-expanded=\"false\">  The Benefits<\/div>\n\t\t\t\t\t<div id=\"elementor-tab-content-7413\" class=\"elementor-tab-content elementor-clearfix\" data-tab=\"3\" role=\"tabpanel\" aria-labelledby=\"elementor-tab-title-7413\" tabindex=\"0\" hidden=\"hidden\"><h6>BUSINESS BENEFITS<\/h6><p>The county business clients were skeptical at first, since their past reporting databases were not reliable and information was not consistent across systems. As demonstrations continued for available data from multiple systems, it was apparent that the data was accurately reflected from each system. The practices had to be put in place to decide which systems should be considered the master data of record and then to implement ways to ensure that other systems utilized this master data.<\/p><h6>TECHNICAL BENEFITS<\/h6><p>The technical implementation of the Data Warehouse had to resolve significant data sharing issues in the county infrastructure. Following this resolution, the problem related to multiple systems with duplicate data had to be resolved. The data warehouse enabled this interaction through its interactive design to and from each source system. The resolution of the data issues was retained internally, based on the capabilities to map data to and from the multiple systems in question, enabling the county to use the system for much more than originally anticipated.<\/p><\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>San Joaquin County (SJC) Case Studies San Joaquin County (SJC) boasts seven cities (approximately 921,600 total acres) and an array of opportunities for boating, fishing, camping, and history-gathering. Each city, including the unincorporated County areas, offers a way to enjoy California\u2019s nature and culture. SJC is the 15th largest county in California and the nation\u2019s [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"nf_dc_page":"","om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"class_list":["post-1145","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/shabnamyazdani.com\/delegata\/wp-json\/wp\/v2\/pages\/1145","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/shabnamyazdani.com\/delegata\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/shabnamyazdani.com\/delegata\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/shabnamyazdani.com\/delegata\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/shabnamyazdani.com\/delegata\/wp-json\/wp\/v2\/comments?post=1145"}],"version-history":[{"count":7,"href":"https:\/\/shabnamyazdani.com\/delegata\/wp-json\/wp\/v2\/pages\/1145\/revisions"}],"predecessor-version":[{"id":2360,"href":"https:\/\/shabnamyazdani.com\/delegata\/wp-json\/wp\/v2\/pages\/1145\/revisions\/2360"}],"wp:attachment":[{"href":"https:\/\/shabnamyazdani.com\/delegata\/wp-json\/wp\/v2\/media?parent=1145"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}