{"id":537,"date":"2019-05-12T20:08:49","date_gmt":"2019-05-12T08:08:49","guid":{"rendered":"https:\/\/saulsafu.com\/portfolio\/?p=537"},"modified":"2023-04-04T20:09:15","modified_gmt":"2023-04-04T08:09:15","slug":"senior-visualizations","status":"publish","type":"post","link":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/","title":{"rendered":"Senior Visualizations"},"content":{"rendered":"
Tower Insurance<\/a> \/ From:<\/strong> 07\/2018 | To:<\/strong> 09\/2019 \/ Auckland, NZ<\/div>\n\r\n\r\n

My main activities were to develop datasets and visualisations using Power BI (M and DAX included). Additional tasks include to perform Business and Data Analysis to find the correct data sources, scripting queries using T-SQL against SQL Server and, Hive and Impala against the Data Lake to feed the datasets, facing internal customers to gather their requirements and data needs, also, helping my team with the creation of internal processes. Recently, as part of the Big Data project, I have been learning Python to manage and maintain the data migration from SQL Server on-premises sources to Hive and Kudu tables in Cloudera.<\/p>\n

Part of my activities also include maintaining and creating SSIS ETL packages\/jobs and maintaining legacy Data Stage ETL jobs.<\/p>\n<\/div>\n\r\n\r\n

\r\n
Functional Experience:<\/div>\r\n

Visualisations with Power BI, Project estimations, Business and Data Analysis, Business Processes design and diagramming.<\/p>\n<\/div>\r\n<\/div>\n\r\n\r\n

\r\n
Tools:<\/div>\r\n

Data Lake in Azure infrastructure\/virtualization running in Cloudera with Hadoop\/Hive\/Impala, SharePoint, SQL Server, DAX, SSIS, Confluence, MS Teams, Cognos, Data Stage.<\/p>\n<\/div>\r\n<\/div>\n\r\n\r\n\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":517,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[8],"tags":[],"class_list":["post-537","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-job","xfolkentry","clearfix"],"acf":[],"yoast_head":"\nSenior Visualizations | Saulsafu<\/title>\n<meta name=\"description\" content=\"Visualisations with Power BI, Project estimations, Business and Data Analysis, Business Processes design and diagramming. | Data Lake in Azure infrastructure\/virtualization running in Cloudera with Hadoop\/Hive\/Impala, SharePoint, SQL Server, DAX, SSIS, Confluence, MS Teams, Cognos, Data Stage.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Senior Visualizations | Saulsafu\" \/>\n<meta property=\"og:description\" content=\"Visualisations with Power BI, Project estimations, Business and Data Analysis, Business Processes design and diagramming. | Data Lake in Azure infrastructure\/virtualization running in Cloudera with Hadoop\/Hive\/Impala, SharePoint, SQL Server, DAX, SSIS, Confluence, MS Teams, Cognos, Data Stage.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/\" \/>\n<meta property=\"og:site_name\" content=\"Saulsafu\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/saulsafu\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/saulsafu\" \/>\n<meta property=\"article:published_time\" content=\"2019-05-12T08:08:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-04T08:09:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"810\" \/>\n\t<meta property=\"og:image:height\" content=\"456\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"adminSaulsafu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"adminSaulsafu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/\"},\"author\":{\"name\":\"adminSaulsafu\",\"@id\":\"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/911b118687f03af2778ee325257ffa62\"},\"headline\":\"Senior Visualizations\",\"datePublished\":\"2019-05-12T08:08:49+00:00\",\"dateModified\":\"2023-04-04T08:09:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/\"},\"wordCount\":18,\"publisher\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/911b118687f03af2778ee325257ffa62\"},\"image\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg\",\"articleSection\":[\"Job\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/\",\"url\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/\",\"name\":\"Senior Visualizations | Saulsafu\",\"isPartOf\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg\",\"datePublished\":\"2019-05-12T08:08:49+00:00\",\"dateModified\":\"2023-04-04T08:09:15+00:00\",\"description\":\"Visualisations with Power BI, Project estimations, Business and Data Analysis, Business Processes design and diagramming. | Data Lake in Azure infrastructure\/virtualization running in Cloudera with Hadoop\/Hive\/Impala, SharePoint, SQL Server, DAX, SSIS, Confluence, MS Teams, Cognos, Data Stage.\",\"breadcrumb\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#primaryimage\",\"url\":\"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg\",\"contentUrl\":\"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg\",\"width\":810,\"height\":456,\"caption\":\"Visualizations\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/saulsafu.com\/portfolio\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Senior Visualizations\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/saulsafu.com\/portfolio\/#website\",\"url\":\"https:\/\/saulsafu.com\/portfolio\/\",\"name\":\"Saulsafu\",\"description\":\"Portfolio\",\"publisher\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/911b118687f03af2778ee325257ffa62\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/saulsafu.com\/portfolio\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/911b118687f03af2778ee325257ffa62\",\"name\":\"adminSaulsafu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/adc42f81f8cad6d0e8e1e9b9080f2ba149ae7bfce54e073f1ae068e6a5be7be7?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/adc42f81f8cad6d0e8e1e9b9080f2ba149ae7bfce54e073f1ae068e6a5be7be7?s=96&r=g\",\"caption\":\"adminSaulsafu\"},\"logo\":{\"@id\":\"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.saulsafu.com\",\"https:\/\/www.facebook.com\/saulsafu\",\"https:\/\/www.linkedin.com\/in\/saulsafu\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Senior Visualizations | Saulsafu","description":"Visualisations with Power BI, Project estimations, Business and Data Analysis, Business Processes design and diagramming. | Data Lake in Azure infrastructure\/virtualization running in Cloudera with Hadoop\/Hive\/Impala, SharePoint, SQL Server, DAX, SSIS, Confluence, MS Teams, Cognos, Data Stage.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/","og_locale":"en_US","og_type":"article","og_title":"Senior Visualizations | Saulsafu","og_description":"Visualisations with Power BI, Project estimations, Business and Data Analysis, Business Processes design and diagramming. | Data Lake in Azure infrastructure\/virtualization running in Cloudera with Hadoop\/Hive\/Impala, SharePoint, SQL Server, DAX, SSIS, Confluence, MS Teams, Cognos, Data Stage.","og_url":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/","og_site_name":"Saulsafu","article_publisher":"https:\/\/www.facebook.com\/saulsafu","article_author":"https:\/\/www.facebook.com\/saulsafu","article_published_time":"2019-05-12T08:08:49+00:00","article_modified_time":"2023-04-04T08:09:15+00:00","og_image":[{"width":810,"height":456,"url":"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg","type":"image\/jpeg"}],"author":"adminSaulsafu","twitter_card":"summary_large_image","twitter_misc":{"Written by":"adminSaulsafu","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#article","isPartOf":{"@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/"},"author":{"name":"adminSaulsafu","@id":"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/911b118687f03af2778ee325257ffa62"},"headline":"Senior Visualizations","datePublished":"2019-05-12T08:08:49+00:00","dateModified":"2023-04-04T08:09:15+00:00","mainEntityOfPage":{"@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/"},"wordCount":18,"publisher":{"@id":"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/911b118687f03af2778ee325257ffa62"},"image":{"@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#primaryimage"},"thumbnailUrl":"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg","articleSection":["Job"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/","url":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/","name":"Senior Visualizations | Saulsafu","isPartOf":{"@id":"https:\/\/saulsafu.com\/portfolio\/#website"},"primaryImageOfPage":{"@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#primaryimage"},"image":{"@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#primaryimage"},"thumbnailUrl":"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg","datePublished":"2019-05-12T08:08:49+00:00","dateModified":"2023-04-04T08:09:15+00:00","description":"Visualisations with Power BI, Project estimations, Business and Data Analysis, Business Processes design and diagramming. | Data Lake in Azure infrastructure\/virtualization running in Cloudera with Hadoop\/Hive\/Impala, SharePoint, SQL Server, DAX, SSIS, Confluence, MS Teams, Cognos, Data Stage.","breadcrumb":{"@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#primaryimage","url":"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg","contentUrl":"https:\/\/saulsafu.com\/portfolio\/wp-content\/uploads\/2019\/05\/visualization_01.jpg","width":810,"height":456,"caption":"Visualizations"},{"@type":"BreadcrumbList","@id":"https:\/\/saulsafu.com\/portfolio\/senior-visualizations\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/saulsafu.com\/portfolio\/"},{"@type":"ListItem","position":2,"name":"Senior Visualizations"}]},{"@type":"WebSite","@id":"https:\/\/saulsafu.com\/portfolio\/#website","url":"https:\/\/saulsafu.com\/portfolio\/","name":"Saulsafu","description":"Portfolio","publisher":{"@id":"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/911b118687f03af2778ee325257ffa62"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/saulsafu.com\/portfolio\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/911b118687f03af2778ee325257ffa62","name":"adminSaulsafu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/adc42f81f8cad6d0e8e1e9b9080f2ba149ae7bfce54e073f1ae068e6a5be7be7?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/adc42f81f8cad6d0e8e1e9b9080f2ba149ae7bfce54e073f1ae068e6a5be7be7?s=96&r=g","caption":"adminSaulsafu"},"logo":{"@id":"https:\/\/saulsafu.com\/portfolio\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.saulsafu.com","https:\/\/www.facebook.com\/saulsafu","https:\/\/www.linkedin.com\/in\/saulsafu"]}]}},"_links":{"self":[{"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/posts\/537","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/comments?post=537"}],"version-history":[{"count":8,"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/posts\/537\/revisions"}],"predecessor-version":[{"id":638,"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/posts\/537\/revisions\/638"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/media\/517"}],"wp:attachment":[{"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/media?parent=537"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/categories?post=537"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/saulsafu.com\/portfolio\/wp-json\/wp\/v2\/tags?post=537"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}