{"id":2122,"date":"2023-04-23T21:56:50","date_gmt":"2023-04-23T21:56:50","guid":{"rendered":"https:\/\/luizfelipe.com.br\/?post_type=projects&#038;p=2122"},"modified":"2024-05-01T15:19:26","modified_gmt":"2024-05-01T15:19:26","slug":"dadosgov-at-serpro","status":"publish","type":"projects","link":"https:\/\/luizfelipe.com.br\/index.php\/projects\/dadosgov-at-serpro\/","title":{"rendered":"DadosGov at SERPRO"},"content":{"rendered":"\n<p>After approximately 6 months working at SERPRO, I was transferred to an area that urgently demanded strategic interest from the Presidency of the Republic of Brazil.<\/p>\n\n\n\n<p>The problem at the time was the balance of accounts of President Lula&#8217;s government, which was ending his second term at that time.<\/p>\n\n\n\n<p>At that time, several reports on results achieved in public policies were processed through an internal BI platform called Netuno BI.<\/p>\n\n\n\n<p>Netuno BI was a tool with many limitations and required much manual work from analysts interested in developing dashboards using this technology.<\/p>\n\n\n\n<p>When I was introduced to the service that should be performed, my superiors intended that I join the team that developed the dashboards using this tool. However, I quickly realized that my mission on that team would be another.<\/p>\n\n\n\n<p>Dashboards were created with a lot of manual work, where the data analyst needed to fill in several specific fields in configuration files, which informed the name of the columns and the number of decimal places, among many other attributes that were filled in manually and that exposed the process to many human failings.<\/p>\n\n\n\n<p>It was quickly realized that the process was not functional and that it would be impossible to meet the requested deadline by maintaining the same process. On that occasion, I had to make a very challenging decision. I proposed a completely new process, where all these programming files were automatically generated through programming, consulting a few dozen metadata available in the database.<\/p>\n\n\n\n<p>I already had previous experience at UFJF with successful code generator programs. I decided to call this program Aut\u00f4mato, and at the end of the day, it generated a ZIP package with several files recognized by Netuno BI. With this automation, it was possible to reduce a 4-hour workload to just a few seconds.<\/p>\n\n\n\n<p>With the previous process, publishing only a few historical data series per day was possible. After this automaton&#8217;s implementation, hundreds of them could be published on the same day. In addition to this improvement, I also proposed a serial production, in which all files were transferred to the server only at the end of the day, instead of sending them one by one as was done before.<\/p>\n\n\n\n<p>With all these improvements, it was possible to publish the almost 2,000 historical series that were part of the 6 books registered in the notary&#8217;s office that contained vital information on the Balance of the Eight Years of President Lula&#8217;s Government. As a result of this work, I was invited to the Government Balance Ceremony, which was held at the Planalto Palace in Bras\u00edlia in the presence of the President of the Republic.<\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"384\" data-id=\"2140\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/telaoPlanalto.jpeg\" alt=\"\" class=\"wp-image-2140\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/telaoPlanalto.jpeg 512w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/telaoPlanalto-300x225.jpeg 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"384\" data-id=\"2141\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/LulaNoI3Gov.jpeg\" alt=\"\" class=\"wp-image-2141\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/LulaNoI3Gov.jpeg 512w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/LulaNoI3Gov-300x225.jpeg 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/figure>\n<\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"512\" height=\"384\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/EquipeNoPlanalto.jpeg\" alt=\"\" class=\"wp-image-2142\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/EquipeNoPlanalto.jpeg 512w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/EquipeNoPlanalto-300x225.jpeg 300w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><figcaption class=\"wp-element-caption\">Presence of the team at the Balance Ceremony of the 8 years of the Lula Government, where the DadosGov System was presented by the President of the Republic on 12\/15\/2010 (personal file)<\/figcaption><\/figure>\n\n\n\n<p>Once these hundreds of historical series were created, the next step was to develop a flow to keep this information updated. Something important to keep in mind is that communication must be planned according to the recipient of the message. This same concept can be perfectly applied in software development, in the approach that we need to speak our client&#8217;s language. Our clients were mainly advisors to the Presidency of the Republic and Ministry, and they used spreadsheets as the primary means of capturing and managing this data. Based on these premises, we developed a process that could import such information in a secure, efficient way and speak the client&#8217;s language.<\/p>\n\n\n\n<p>This upload process was organized into six steps:<\/p>\n\n\n\n<ol>\n<li>Selection of the historical series and period to be updated;<\/li>\n\n\n<li>Automatic generation of the spreadsheet to be edited by the user with the data present in the database;<\/li>\n\n\n\n<li>Filling out and uploading the spreadsheet with updated data;<\/li>\n\n\n\n<li>Automatic detection of modifications and feedback to the user;<\/li>\n\n<li>User confirmation regarding the data sent and sending a textual description of the update;<\/li>\n\n\n<li>Issuance of a receipt for the update made.<\/li>\n\n<\/ol>\n\n\n\n\n<p><br><\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-2 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"812\" height=\"402\" data-id=\"2198\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload1.png\" alt=\"\" class=\"wp-image-2198\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload1.png 812w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload1-300x149.png 300w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload1-768x380.png 768w\" sizes=\"auto, (max-width: 812px) 100vw, 812px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"809\" height=\"528\" data-id=\"2199\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload2.png\" alt=\"\" class=\"wp-image-2199\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload2.png 809w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload2-300x196.png 300w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload2-768x501.png 768w\" sizes=\"auto, (max-width: 809px) 100vw, 809px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"696\" height=\"654\" data-id=\"2202\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload3.png\" alt=\"\" class=\"wp-image-2202\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload3.png 696w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload3-300x282.png 300w\" sizes=\"auto, (max-width: 696px) 100vw, 696px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"832\" height=\"461\" data-id=\"2201\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload4.png\" alt=\"\" class=\"wp-image-2201\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload4.png 832w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload4-300x166.png 300w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload4-768x426.png 768w\" sizes=\"auto, (max-width: 832px) 100vw, 832px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"864\" height=\"695\" data-id=\"2203\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload5.png\" alt=\"\" class=\"wp-image-2203\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload5.png 864w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload5-300x241.png 300w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload5-768x618.png 768w\" sizes=\"auto, (max-width: 864px) 100vw, 864px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"875\" height=\"256\" data-id=\"2200\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload6.png\" alt=\"\" class=\"wp-image-2200\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload6.png 875w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload6-300x88.png 300w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2024\/04\/upload6-768x225.png 768w\" sizes=\"auto, (max-width: 875px) 100vw, 875px\" \/><\/figure>\n<\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>This process allowed the team&#8217;s bottleneck activities to be automated, freeing up time so that people could better exercise their creativity in evolutionary tasks that add increasingly more value to the service provided.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"437\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/001-telaprincipal-1024x437.png\" alt=\"\" class=\"wp-image-2124\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/001-telaprincipal-1024x437.png 1024w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/001-telaprincipal-300x128.png 300w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/001-telaprincipal-768x327.png 768w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/001-telaprincipal.png 1438w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"484\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/totais-1024x484.png\" alt=\"\" class=\"wp-image-2126\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/totais-1024x484.png 1024w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/totais-300x142.png 300w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/totais-768x363.png 768w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/totais.png 1113w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\t\t\t\t\t<div\n\t\t\t\t\t\tclass=\"wp-block-uagb-image-gallery uagb-block-e3c3d93c     \"\n\t\t\t\t\t\tstyle=\"\"\n\t\t\t\t\t>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery spectra-image-gallery__layout--tiled spectra-image-gallery__layout--tiled-col-4 spectra-image-gallery__layout--tiled-col-tab-4 spectra-image-gallery__layout--tiled-col-mob-4\">\n\t\t\t\t\t\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2127'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/territorioxingu.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/territorioxingu.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/territorioxingu-300x47.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2128'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/tabelaBFRS-1024x443.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/tabelaBFRS-1024x443.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/tabelaBFRS-300x130.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2129'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/MinhaCasaMinhaVida-1024x722.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/MinhaCasaMinhaVida-1024x722.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/MinhaCasaMinhaVida-300x211.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2130'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/mapaMG-1024x507.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/mapaMG-1024x507.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/mapaMG-300x149.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2131'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/mapaBrasilTR-1024x423.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/mapaBrasilTR-1024x423.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/mapaBrasilTR-300x124.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2132'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/LuzParaTodos-1024x413.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/LuzParaTodos-1024x413.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/LuzParaTodos-300x121.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2133'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/graficoUFS-1024x413.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/graficoUFS-1024x413.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/graficoUFS-300x121.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2134'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/graficobarramontada-1024x693.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/graficobarramontada-1024x693.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/graficobarramontada-300x203.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2135'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/galeriadeFotos.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/galeriadeFotos.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/galeriadeFotos-300x183.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class='spectra-image-gallery__media-wrapper' data-spectra-gallery-image-id='2136'>\n\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media spectra-image-gallery__media--tiled\">\n\t\t\t\t<picture>\n\t\t\t\t\t<source media=\"(min-width: 1024px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/arvores-1.png\">\n\t\t\t\t\t<source media=\"(min-width: 768px)\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/arvores-1.png\">\n\t\t\t\t\t<img decoding=\"async\" class=\"spectra-image-gallery__media-thumbnail spectra-image-gallery__media-thumbnail--tiled\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/arvores-1-182x300.png\" alt=\"\" loading=\"lazy\" \/>\n\t\t\t\t<\/picture>\n\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-blurrer\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption-wrapper spectra-image-gallery__media-thumbnail-caption-wrapper--overlay\">\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-thumbnail-caption spectra-image-gallery__media-thumbnail-caption--overlay\">\n\t\t\t\t\tNo Caption\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"spectra-image-gallery__media-sizer\"><\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<div class='spectra-image-gallery__control-lightbox' tabindex='0'>\n\t\t\t\t\t\t\t\t\t\t\t<div class=\"swiper spectra-image-gallery__control-lightbox--main\" dir=\"\">\n\t\t\t\t\t<div class=\"swiper-wrapper\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/territorioxingu.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/tabelaBFRS.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/MinhaCasaMinhaVida.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/mapaMG.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/mapaBrasilTR.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/LuzParaTodos.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/graficoUFS.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/graficobarramontada.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/galeriadeFotos.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<div class=\"swiper-slide\">\n\t\t\t\t\t\t\t\t<img class=\"swiper-lazy\" data-src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/arvores-1.png\" alt=\"\"\/>\n\t\t\t\t\t\t\t\t<div class=\"swiper-lazy-preloader swiper-lazy-preloader-white\"><\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<div class=\"swiper-button-next\"><\/div>\n\t\t\t\t\t<div class=\"swiper-button-prev\"><\/div>\n\t\t\t\t<\/div>\t\t\t\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<button class='spectra-image-gallery__control-lightbox--close'>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<svg xmlns=\"https:\/\/www.w3.org\/2000\/svg\" viewBox= \"0 0 320 512\"><path d=\"M310.6 361.4c12.5 12.5 12.5 32.75 0 45.25C304.4 412.9 296.2 416 288 416s-16.38-3.125-22.62-9.375L160 301.3L54.63 406.6C48.38 412.9 40.19 416 32 416S15.63 412.9 9.375 406.6c-12.5-12.5-12.5-32.75 0-45.25l105.4-105.4L9.375 150.6c-12.5-12.5-12.5-32.75 0-45.25s32.75-12.5 45.25 0L160 210.8l105.4-105.4c12.5-12.5 32.75-12.5 45.25 0s12.5 32.75 0 45.25l-105.4 105.4L310.6 361.4z\"><\/path><\/svg>\n\t\t\t\t\t\t\t\t\t\t\t\t<\/button>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\n\n\n<figure class=\"wp-block-image aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"940\" height=\"1024\" src=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-940x1024.png\" alt=\"\" class=\"wp-image-2178\" srcset=\"https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-940x1024.png 940w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-275x300.png 275w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-768x837.png 768w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-1410x1536.png 1410w, https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-1880x2048.png 1880w\" sizes=\"auto, (max-width: 940px) 100vw, 940px\" \/><figcaption class=\"wp-element-caption\">The last version of DadosGov that was rebranded to PGI<\/figcaption><\/figure>\n","protected":false},"author":2,"featured_media":2178,"template":"","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","_ti_tpc_template_sync":false,"_ti_tpc_template_id":""},"customer":[71],"modality":[25],"period":[30,31,32,33],"platform":[26],"role":[67,39,35],"technology":[18,17,68,38,69],"class_list":["post-2122","projects","type-projects","status-publish","has-post-thumbnail","hentry","customer-civil-house-presidency-of-the-republic","modality-development","period-30","period-31","period-32","period-33","platform-web","role-data-analyst","role-developer","role-it-architect","technology-css","technology-html","technology-netuno-bi","technology-php","technology-postgres"],"acf":[],"uagb_featured_image_src":{"full":["https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_.png",3589,3910,false],"thumbnail":["https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-150x150.png",150,150,true],"medium":["https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-275x300.png",275,300,true],"medium_large":["https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-768x837.png",768,837,true],"large":["https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-940x1024.png",940,1024,true],"1536x1536":["https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-1410x1536.png",1410,1536,true],"2048x2048":["https:\/\/luizfelipe.com.br\/wp-content\/uploads\/2023\/04\/pgi.gov_.br_-1880x2048.png",1880,2048,true]},"uagb_author_info":{"display_name":"Luiz Oliveira","author_link":"https:\/\/luizfelipe.com.br\/index.php\/author\/luiz\/"},"uagb_comment_info":0,"uagb_excerpt":"After approximately 6 months working at SERPRO, I was transferred to an area that urgently demanded strategic interest from the Presidency of the Republic of Brazil. The problem at the time was the balance of accounts of President Lula&#8217;s government, which was ending his second term at that time. At that time, several reports on&hellip;","_links":{"self":[{"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/projects\/2122","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/projects"}],"about":[{"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/types\/projects"}],"author":[{"embeddable":true,"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/users\/2"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/media\/2178"}],"wp:attachment":[{"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/media?parent=2122"}],"wp:term":[{"taxonomy":"customer","embeddable":true,"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/customer?post=2122"},{"taxonomy":"modality","embeddable":true,"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/modality?post=2122"},{"taxonomy":"period","embeddable":true,"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/period?post=2122"},{"taxonomy":"platform","embeddable":true,"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/platform?post=2122"},{"taxonomy":"role","embeddable":true,"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/role?post=2122"},{"taxonomy":"technology","embeddable":true,"href":"https:\/\/luizfelipe.com.br\/index.php\/wp-json\/wp\/v2\/technology?post=2122"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}