{"id":548,"date":"2021-12-27T07:37:55","date_gmt":"2021-12-27T07:37:55","guid":{"rendered":"https:\/\/demosites.royal-elementor-addons.com\/portfolio-v1\/?page_id=7"},"modified":"2025-11-26T11:22:30","modified_gmt":"2025-11-26T18:22:30","slug":"home-portfolio-v1","status":"publish","type":"page","link":"https:\/\/tedutter.com\/","title":{"rendered":"Home"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"548\" class=\"elementor elementor-548\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-558627a elementor-section-height-full elementor-section-boxed elementor-section-height-default elementor-section-items-middle wpr-particle-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"558627a\" data-element_type=\"section\" id=\"Home\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t\t<div class=\"elementor-background-overlay\"><\/div>\n\t\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-c4c0ee7\" data-id=\"c4c0ee7\" data-element_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-134e3fc elementor-invisible elementor-widget elementor-widget-heading\" data-id=\"134e3fc\" data-element_type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInDown&quot;}\" 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\">Ted Utter<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0158f05 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"0158f05\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ccd4fbe elementor-widget__width-initial animated-slow elementor-invisible elementor-widget elementor-widget-text-editor\" data-id=\"ccd4fbe\" data-element_type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeIn&quot;}\" 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>I am an IT and data professional with over 20 years of experience. I have a diverse skill set in data, full stack programming and networking. I\u2019ve done hundreds of data migrations and conversions with accuracy and proficiency along with reliable workflows, ETL processes, and data solutions. I have strong SQL skills in creating queries, reports, stored procedures and views, with additional expertise in Python data libraries for automation and data processing. I have extensive experience in SQL Server and MySQL. I&#8217;m at ease working with large enterprises and small businesses alike. I\u2019m passionate about IT and data and an enthusiastic lifelong learner.\u00a0 I&#8217;m excited to talk about how I could put my skills to work for you.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-0c96b1f elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"0c96b1f\" data-element_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-inner-column elementor-element elementor-element-d287142\" data-id=\"d287142\" data-element_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-52178d0 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"52178d0\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-map-marker-alt\" viewBox=\"0 0 384 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M172.268 501.67C26.97 291.031 0 269.413 0 192 0 85.961 85.961 0 192 0s192 85.961 192 192c0 77.413-26.97 99.031-172.268 309.67-9.535 13.774-29.93 13.773-39.464 0zM192 272c44.183 0 80-35.817 80-80s-35.817-80-80-80-80 35.817-80 80 35.817 80 80 80z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Denver, Colorado 80220<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"mailto:tedutter@gmail.com\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-envelope\" viewBox=\"0 0 512 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M502.3 190.8c3.9-3.1 9.7-.2 9.7 4.7V400c0 26.5-21.5 48-48 48H48c-26.5 0-48-21.5-48-48V195.6c0-5 5.7-7.8 9.7-4.7 22.4 17.4 52.1 39.5 154.1 113.6 21.1 15.4 56.7 47.8 92.2 47.6 35.7.3 72-32.8 92.3-47.6 102-74.1 131.6-96.3 154-113.7zM256 320c23.2.4 56.6-29.2 73.4-41.4 132.7-96.3 142.8-104.7 173.4-128.7 5.8-4.5 9.2-11.5 9.2-18.9v-19c0-26.5-21.5-48-48-48H48C21.5 64 0 85.5 0 112v19c0 7.4 3.4 14.3 9.2 18.9 30.6 23.9 40.7 32.4 173.4 128.7 16.8 12.2 50.2 41.8 73.4 41.4z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">TedUtter@gmail.com<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\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<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-a7b223e\" data-id=\"a7b223e\" data-element_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-60fd61b elementor-mobile-align-left elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"60fd61b\" data-element_type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"http:\/\/www.linkedin.com\/in\/tedutter\" target=\"_blank\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-linkedin-in\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M100.28 448H7.4V148.9h92.88zM53.79 108.1C24.09 108.1 0 83.5 0 53.8a53.79 53.79 0 0 1 107.58 0c0 29.7-24.1 54.3-53.79 54.3zM447.9 448h-92.68V302.4c0-34.7-.7-79.2-48.29-79.2-48.29 0-55.69 37.7-55.69 76.7V448h-92.78V148.9h89.08v40.8h1.3c12.4-23.5 42.69-48.3 87.88-48.3 94 0 111.28 61.9 111.28 142.3V448z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">LinkedIn<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/github.com\/tedutter\">\n\n\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fab-github\" viewBox=\"0 0 496 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M165.9 397.4c0 2-2.3 3.6-5.2 3.6-3.3.3-5.6-1.3-5.6-3.6 0-2 2.3-3.6 5.2-3.6 3-.3 5.6 1.3 5.6 3.6zm-31.1-4.5c-.7 2 1.3 4.3 4.3 4.9 2.6 1 5.6 0 6.2-2s-1.3-4.3-4.3-5.2c-2.6-.7-5.5.3-6.2 2.3zm44.2-1.7c-2.9.7-4.9 2.6-4.6 4.9.3 2 2.9 3.3 5.9 2.6 2.9-.7 4.9-2.6 4.6-4.6-.3-1.9-3-3.2-5.9-2.9zM244.8 8C106.1 8 0 113.3 0 252c0 110.9 69.8 205.8 169.5 239.2 12.8 2.3 17.3-5.6 17.3-12.1 0-6.2-.3-40.4-.3-61.4 0 0-70 15-84.7-29.8 0 0-11.4-29.1-27.8-36.6 0 0-22.9-15.7 1.6-15.4 0 0 24.9 2 38.6 25.8 21.9 38.6 58.6 27.5 72.9 20.9 2.3-16 8.8-27.1 16-33.7-55.9-6.2-112.3-14.3-112.3-110.5 0-27.5 7.6-41.3 23.6-58.9-2.6-6.5-11.1-33.3 2.6-67.9 20.9-6.5 69 27 69 27 20-5.6 41.5-8.5 62.8-8.5s42.8 2.9 62.8 8.5c0 0 48.1-33.6 69-27 13.7 34.7 5.2 61.4 2.6 67.9 16 17.7 25.8 31.5 25.8 58.9 0 96.5-58.9 104.2-114.8 110.5 9.2 7.9 17 22.9 17 46.4 0 33.7-.3 75.4-.3 83.6 0 6.5 4.6 14.4 17.3 12.1C428.2 457.8 496 362.9 496 252 496 113.3 383.5 8 244.8 8zM97.2 352.9c-1.3 1-1 3.3.7 5.2 1.6 1.6 3.9 2.3 5.2 1 1.3-1 1-3.3-.7-5.2-1.6-1.6-3.9-2.3-5.2-1zm-10.8-8.1c-.7 1.3.3 2.9 2.3 3.9 1.6 1 3.6.7 4.3-.7.7-1.3-.3-2.9-2.3-3.9-2-.6-3.6-.3-4.3.7zm32.4 35.6c-1.6 1.3-1 4.3 1.3 6.2 2.3 2.3 5.2 2.6 6.5 1 1.3-1.3.7-4.3-1.3-6.2-2.2-2.3-5.2-2.6-6.5-1zm-11.4-14.7c-1.6 1-1.6 3.6 0 5.9 1.6 2.3 4.3 3.3 5.6 2.3 1.6-1.3 1.6-3.9 0-6.2-1.4-2.3-4-3.3-5.6-2z\"><\/path><\/svg>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Github<\/span>\n\t\t\t\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f84f9d3 wpr-button-icon-style-inline wpr-button-icon-position-right elementor-widget elementor-widget-wpr-button\" data-id=\"f84f9d3\" data-element_type=\"widget\" data-widget_type=\"wpr-button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\n\t\t\t\n\t\t\n\t\t<div class=\"wpr-button-wrap elementor-clearfix\">\n\t\t<a class=\"wpr-button wpr-button-effect wpr-button-none\" data-text=\"\" href=\"https:\/\/tedutter.com\/wp-content\/uploads\/2025\/11\/Ted-Utter-SQL-Developer.pdf\" target=\"_blank\">\n\t\t\t\n\t\t\t<span class=\"wpr-button-content\">\n\t\t\t\t\t\t\t\t\t<span class=\"wpr-button-text\">Download Resume<\/span>\n\t\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t<\/span>\n\t\t<\/a>\n\n\t\t\t\t<\/div>\n\t\n\t\n\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 class=\"elementor-element elementor-element-0f9b143 elementor-widget__width-initial elementor-fixed elementor-view-default elementor-widget elementor-widget-icon\" data-id=\"0f9b143\" data-element_type=\"widget\" data-settings=\"{&quot;_position&quot;:&quot;fixed&quot;}\" data-widget_type=\"icon.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-icon-wrapper\">\n\t\t\t<a class=\"elementor-icon\" href=\"#Home\">\n\t\t\t<svg aria-hidden=\"true\" class=\"e-font-icon-svg e-fas-chevron-up\" viewBox=\"0 0 448 512\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\"><path d=\"M240.971 130.524l194.343 194.343c9.373 9.373 9.373 24.569 0 33.941l-22.667 22.667c-9.357 9.357-24.522 9.375-33.901.04L224 227.495 69.255 381.516c-9.379 9.335-24.544 9.317-33.901-.04l-22.667-22.667c-9.373-9.373-9.373-24.569 0-33.941L207.03 130.525c9.372-9.373 24.568-9.373 33.941-.001z\"><\/path><\/svg>\t\t\t<\/a>\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-487dceb\" data-id=\"487dceb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\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-0aba7c7 elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"0aba7c7\" data-element_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-0940498\" data-id=\"0940498\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-eba455d elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"eba455d\" data-element_type=\"section\" id=\"About\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-dbffd27\" data-id=\"dbffd27\" data-element_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-a5b8552 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"a5b8552\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\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<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-964ed3d\" data-id=\"964ed3d\" data-element_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-b5c9ad0 elementor-widget elementor-widget-heading\" data-id=\"b5c9ad0\" data-element_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\">About Me<\/h2>\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\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-84f0181 elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"84f0181\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-wide\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-839fdb9\" data-id=\"839fdb9\" data-element_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-21a50f5 elementor-widget elementor-widget-heading\" data-id=\"21a50f5\" data-element_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\">Skills\n<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3bc33ec elementor-widget elementor-widget-text-editor\" data-id=\"3bc33ec\" data-element_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>Skills by percentage competency.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e844e2e wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"e844e2e\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:99,&quot;counterValuePersent&quot;:99,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">SQL<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d62ef5c wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"d62ef5c\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:85,&quot;counterValuePersent&quot;:85,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">Python<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-374b259 wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"374b259\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:85,&quot;counterValuePersent&quot;:85,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">APIs<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ef1b355 wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"ef1b355\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:85,&quot;counterValuePersent&quot;:85,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">ETLs<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1b0e92d wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"1b0e92d\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:80,&quot;counterValuePersent&quot;:80,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">Docker<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e31623e wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"e31623e\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:80,&quot;counterValuePersent&quot;:80,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">OOP<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1874a06 wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"1874a06\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:75,&quot;counterValuePersent&quot;:75,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">Git<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d04098f wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"d04098f\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:75,&quot;counterValuePersent&quot;:75,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">PHP<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-775c0ec wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"775c0ec\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:75,&quot;counterValuePersent&quot;:75,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">Reporting\/Visualization (Power BI, Tableau)<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4a7a464 wpr-pbar-title-pos-outside wpr-pbar-counter-pos-outside wpr-prbar-layout-hr-line elementor-widget elementor-widget-wpr-progress-bar\" data-id=\"4a7a464\" data-element_type=\"widget\" data-widget_type=\"wpr-progress-bar.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\n\t\t<div class=\"wpr-progress-bar\" data-options=\"{&quot;counterValue&quot;:60,&quot;counterValuePersent&quot;:60,&quot;counterSeparator&quot;:&quot;&quot;,&quot;animDuration&quot;:1000,&quot;animDelay&quot;:0,&quot;loop&quot;:&quot;&quot;,&quot;loopDelay&quot;:&quot;&quot;}\">\n\t\t\n\t\t\t<div class=\"wpr-prbar-content elementor-clearfix\"><div class=\"wpr-prbar-title-wrap\"><div class=\"wpr-prbar-title\">AWS (S3, Glue, Athena)<\/div><div class=\"wpr-prbar-subtitle\"><\/div><\/div>\n\t\t<div class=\"wpr-prbar-counter\">\n\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value\">0<\/span>\n\t\t\t\n\t\t\t\t\t\t<span class=\"wpr-prbar-counter-value-suffix\">%<\/span>\n\t\t\t\n\t\t<\/div>\n\n\t\t<\/div>\n\t\t<div class=\"wpr-prbar-hr-line\">\n\t\t\t<div class=\"wpr-prbar-hr-line-inner wpr-anim-timing-ease-default\">\n\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\n\t\t\n\t\t<\/div>\n\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<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-a6ba317\" data-id=\"a6ba317\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-32ecdc9 elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"32ecdc9\" data-element_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-inner-column elementor-element elementor-element-c1f8946\" data-id=\"c1f8946\" data-element_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-9c74f0b elementor-widget elementor-widget-heading\" data-id=\"9c74f0b\" data-element_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\">Work Experience<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fcc0297 elementor-widget elementor-widget-heading\" data-id=\"fcc0297\" data-element_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 Developer<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d626afe elementor-widget elementor-widget-heading\" data-id=\"d626afe\" data-element_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\">2002-2025<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3468d20 elementor-widget elementor-widget-text-editor\" data-id=\"3468d20\" data-element_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<ul><li>Developed and optimized complex SQL queries and ETL pipelines to collect data from APIs, databases, JSON, and XML into SQL RDBMS improving client processes, saving time and increasing accuracy<\/li><li>Cleaned and transformed data using Python scripts and SQL stored procedures<\/li><li>Streamlined client data processes using Python to ingest data from APIs, transformed data with python and SQL reducing manual work and delivery time<\/li><li>Built and maintained JasperReports to meaningfully display client data and reveal business insights<\/li><li>Gave management progress analysis tools through PHP based reporting tools for process and work queue monitoring<\/li><li>Maintained and updated data driven PHP and Java based web application<\/li><li>Established and monitored data replication between remote and data center locations<\/li><li>Orchestrated complex scheduled processes to move data through various stages<\/li><li>Analyzed complex data and developed migration and conversion plans for large Fortune 500 enterprises<\/li><li>Migrated physical servers to virtual environments using both Hyper-V and VMWare platforms<\/li><li>Developed SQL queries to improve efficiency in implementing data systems by targeting relevant components drastically cutting implementation time<\/li><li>Reliably maintained critical business infrastructure, networks, systems, databases and websites in a 24\/7 data center environment<\/li><li>Built PHP\/SQL Server based vendor management application to add customer records, associate vendors and automate emailing vendor rebates<\/li><\/ul>\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<div class=\"elementor-element elementor-element-1b0ac07 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"1b0ac07\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-6bb79ae elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"6bb79ae\" data-element_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-inner-column elementor-element elementor-element-13124a0\" data-id=\"13124a0\" data-element_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-58fda94 elementor-widget elementor-widget-heading\" data-id=\"58fda94\" data-element_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\">Field Engineer | Data Conversion Engineer<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e8fb06f elementor-widget elementor-widget-heading\" data-id=\"e8fb06f\" data-element_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\">1997-2001<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2da9bac elementor-widget elementor-widget-text-editor\" data-id=\"2da9bac\" data-element_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<ul><li>Performed data conversions for TREEV Content Management systems<\/li><li>Converted legacy TREEV system data to import into latest TREEV systems<\/li><li>Analyzed data, developed a conversion strategy and processed scripts to convert data<\/li><li>Worked with customers to develop data layout for their new systems<\/li><li>\u00a0Supported team of Field Engineers performed implementation of document imaging systems<\/li><li>Completed professional implementation of TREEV document imaging systems<\/li><li>Visited banking industry customers onsite to perform hardware\/software setup, customization, and training to customer specifications<\/li><\/ul>\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\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-92b91fa elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"92b91fa\" data-element_type=\"section\" id=\"Portfolio\">\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-a4323ea\" data-id=\"a4323ea\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-9b6a169 elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"9b6a169\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-no\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-1f448c4\" data-id=\"1f448c4\" data-element_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-8619460 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"8619460\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\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<div class=\"elementor-column elementor-col-50 elementor-inner-column elementor-element elementor-element-6651f9f\" data-id=\"6651f9f\" data-element_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-92e5a0e elementor-widget elementor-widget-heading\" data-id=\"92e5a0e\" data-element_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\">My Portfolio<\/h2>\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 class=\"elementor-element elementor-element-4155c25 elementor-widget elementor-widget-text-editor\" data-id=\"4155c25\" data-element_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>Here are three of my projects. I hope to add to this section soon. Please stay tuned!<\/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-cf217df elementor-section-boxed elementor-section-height-default elementor-section-height-default wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no\" data-id=\"cf217df\" data-element_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-7439100\" data-id=\"7439100\" data-element_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-25db553 elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"25db553\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\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<div class=\"elementor-element elementor-element-1fb9d3e e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-parent\" data-id=\"1fb9d3e\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-b257158 elementor-widget elementor-widget-heading\" data-id=\"b257158\" data-element_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\">Python API ETL and MySQL<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-830b383 elementor-widget elementor-widget-text-editor\" data-id=\"830b383\" data-element_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>Watch me explain how I was able to automate billing for a client using the Order Desk API, Python and MySQL. I was able to automate a manual process to save a bundle of time while making billing more accurate. This project uses pandas, json, sqlalchemy, requests, regular expressions, openpyxl libraries and more in Python. View the source code on Github:\u00a0<a href=\"https:\/\/github.com\/tedutter\/OrderDeskAPI\">https:\/\/github.com\/tedutter\/OrderDeskAPI<\/a><\/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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-cd975d6 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-parent\" data-id=\"cd975d6\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-107c6cc elementor-widget elementor-widget-video\" data-id=\"107c6cc\" data-element_type=\"widget\" data-settings=\"{&quot;youtube_url&quot;:&quot;https:\\\/\\\/youtu.be\\\/A2-il2siWcA&quot;,&quot;video_type&quot;:&quot;youtube&quot;,&quot;controls&quot;:&quot;yes&quot;}\" data-widget_type=\"video.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-wrapper elementor-open-inline\">\n\t\t\t<div class=\"elementor-video\"><\/div>\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\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-780b79e e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-parent\" data-id=\"780b79e\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-dd3084e elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"dd3084e\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1d3a146 elementor-widget elementor-widget-heading\" data-id=\"1d3a146\" data-element_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\">Tableau Visualization<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f3b59b4 elementor-widget elementor-widget-text-editor\" data-id=\"f3b59b4\" data-element_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>Featured below is a dashboard created in Tableau showing year over year sales information with data collected from the Order Desk API. This visualization shows changes in sales current vs. previous year with a selectable year parameter. The left half shows the best performing products for the selected year and the bottom left shows a comparison with the previous year sales for the product. The&nbsp;right half shows the best performing vendors for the selected year. The bottom center features month by month comparison for total sales of the selected year and the pervious year. The bottom right shows current vs previous year comparisons by top 10 vendors. Hovering over the bottom middle month on the graph will change the graph to the right and left to show performance for a given month current vs previous year.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-724a8f9 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-child\" data-id=\"724a8f9\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2b74ccc elementor-widget elementor-widget-html\" data-id=\"2b74ccc\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class='tableauPlaceholder' id='viz1763765341282' style='position: relative'><noscript><a href='#'><img alt='OrderDeskDash ' src='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;Or&#47;OrderDeskOrders&#47;OrderDeskDash&#47;1_rss.png' style='border: none' \/><\/a><\/noscript><object class='tableauViz'  style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' \/> <param name='embed_code_version' value='3' \/> <param name='site_root' value='' \/><param name='name' value='OrderDeskOrders&#47;OrderDeskDash' \/><param name='tabs' value='no' \/><param name='toolbar' value='yes' \/><param name='static_image' value='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;Or&#47;OrderDeskOrders&#47;OrderDeskDash&#47;1.png' \/> <param name='animate_transition' value='yes' \/><param name='display_static_image' value='yes' \/><param name='display_spinner' value='yes' \/><param name='display_overlay' value='yes' \/><param name='display_count' value='yes' \/><param name='language' value='en-US' \/><param name='filter' value='publish=yes' \/><\/object><\/div>                <script type='text\/javascript'>                    var divElement = document.getElementById('viz1763765341282');                    var vizElement = divElement.getElementsByTagName('object')[0];                    if ( divElement.offsetWidth > 800 ) { vizElement.style.width='1200px';vizElement.style.height='827px';} else if ( divElement.offsetWidth > 500 ) { vizElement.style.width='1200px';vizElement.style.height='827px';} else { vizElement.style.width='100%';vizElement.style.height='1477px';}                     var scriptElement = document.createElement('script');                    scriptElement.src = 'https:\/\/public.tableau.com\/javascripts\/api\/viz_v1.js';                    vizElement.parentNode.insertBefore(scriptElement, vizElement);                <\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-96a2667 e-flex e-con-boxed wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-parent\" data-id=\"96a2667\" data-element_type=\"container\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-3465d79 e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-child\" data-id=\"3465d79\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-556687d elementor-widget-divider--view-line elementor-widget elementor-widget-divider\" data-id=\"556687d\" data-element_type=\"widget\" data-widget_type=\"divider.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-divider\">\n\t\t\t<span class=\"elementor-divider-separator\">\n\t\t\t\t\t\t<\/span>\n\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fecddbf elementor-widget elementor-widget-heading\" data-id=\"fecddbf\" data-element_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\">Power BI Visualization<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-15edcaa elementor-widget elementor-widget-text-editor\" data-id=\"15edcaa\" data-element_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>This visual below is a sales dashboard created in Power BI. This report captures top performing products, brands and vendor booths at the event. Also shown is the best customers and best selling reigns and districts. Visit my Github page to get all the details on this project including the SQL queries for cleaning and analysis: <a href=\"https:\/\/github.com\/tedutter\/TradeShow\">https:\/\/github.com\/tedutter\/TradeShow<\/a><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-90bfeef e-con-full e-flex wpr-particle-no wpr-jarallax-no wpr-parallax-no wpr-sticky-section-no e-con e-child\" data-id=\"90bfeef\" data-element_type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-62dfaae elementor-widget elementor-widget-html\" data-id=\"62dfaae\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<iframe title=\"Trade Show Sales Dashboard\" width=\"80\" height=\"500\" src=\"https:\/\/app.powerbi.com\/view?r=eyJrIjoiY2ZjNzg3OGItN2FjOS00Y2Q0LTg3ZTQtM2VkOWE4MmM3OWQzIiwidCI6IjU1YjExZTY4LTkxN2MtNDhiZi05MDQ0LTM4Mzc2MWY5ODEwMiIsImMiOjZ9&pageName=ee9b3d9afcc28d231fe2\" frameborder=\"0\" allowFullScreen=\"true\"><\/iframe>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Ted Utter I am an IT and data professional with over 20 years of experience. I have a diverse skill set in data, full stack programming and networking. I\u2019ve done hundreds of data migrations and conversions with accuracy and proficiency along with reliable workflows, ETL processes, and data solutions. I have strong SQL skills in creating queries, reports, stored procedures and views, with additional expertise in Python data libraries for automation and data processing. I have extensive experience in SQL Server and MySQL. I&#8217;m at ease working with large enterprises and small businesses alike. I\u2019m passionate about IT and data and an enthusiastic lifelong learner.\u00a0 I&#8217;m excited to talk about how I could put my skills to work for you. Denver, Colorado 80220 TedUtter@gmail.com LinkedIn Github Download Resume About Me Skills Skills by percentage competency. SQL 0 % Python 0 % APIs 0 % ETLs 0 % Docker 0 % OOP 0 % Git 0 % PHP 0 % Reporting\/Visualization (Power BI, Tableau) 0 % AWS (S3, Glue, Athena) 0 % Work Experience Data Developer 2002-2025 Developed and optimized complex SQL queries and ETL pipelines to collect data from APIs, databases, JSON, and XML into SQL RDBMS improving client processes, saving time and increasing accuracy Cleaned and transformed data using Python scripts and SQL stored procedures Streamlined client data processes using Python to ingest data from APIs, transformed data with python and SQL reducing manual work and delivery time Built and maintained JasperReports to meaningfully display client data and reveal business insights Gave management progress analysis tools through PHP based reporting tools for process and work queue monitoring Maintained and updated data driven PHP and Java based web application Established and monitored data replication between remote and data center locations Orchestrated complex scheduled processes to move data through various stages Analyzed complex data and developed migration and conversion plans for large Fortune 500 enterprises Migrated physical servers to virtual environments using both Hyper-V and VMWare platforms Developed SQL queries to improve efficiency in implementing data systems by targeting relevant components drastically cutting implementation time Reliably maintained critical business infrastructure, networks, systems, databases and websites in a 24\/7 data center environment Built PHP\/SQL Server based vendor management application to add customer records, associate vendors and automate emailing vendor rebates Field Engineer | Data Conversion Engineer 1997-2001 Performed data conversions for TREEV Content Management systems Converted legacy TREEV system data to import into latest TREEV systems Analyzed data, developed a conversion strategy and processed scripts to convert data Worked with customers to develop data layout for their new systems \u00a0Supported team of Field Engineers performed implementation of document imaging systems Completed professional implementation of TREEV document imaging systems Visited banking industry customers onsite to perform hardware\/software setup, customization, and training to customer specifications My Portfolio Here are three of my projects. I hope to add to this section soon. Please stay tuned! Python API ETL and MySQL Watch me explain how I was able to automate billing for a client using the Order Desk API, Python and MySQL. I was able to automate a manual process to save a bundle of time while making billing more accurate. This project uses pandas, json, sqlalchemy, requests, regular expressions, openpyxl libraries and more in Python. View the source code on Github:\u00a0https:\/\/github.com\/tedutter\/OrderDeskAPI https:\/\/youtu.be\/A2-il2siWcA Tableau Visualization Featured below is a dashboard created in Tableau showing year over year sales information with data collected from the Order Desk API. This visualization shows changes in sales current vs. previous year with a selectable year parameter. The left half shows the best performing products for the selected year and the bottom left shows a comparison with the previous year sales for the product. The&nbsp;right half shows the best performing vendors for the selected year. The bottom center features month by month comparison for total sales of the selected year and the pervious year. The bottom right shows current vs previous year comparisons by top 10 vendors. Hovering over the bottom middle month on the graph will change the graph to the right and left to show performance for a given month current vs previous year. Power BI Visualization This visual below is a sales dashboard created in Power BI. This report captures top performing products, brands and vendor booths at the event. Also shown is the best customers and best selling reigns and districts. Visit my Github page to get all the details on this project including the SQL queries for cleaning and analysis: https:\/\/github.com\/tedutter\/TradeShow<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"elementor_canvas","meta":{"footnotes":""},"class_list":["post-548","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/tedutter.com\/index.php?rest_route=\/wp\/v2\/pages\/548","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tedutter.com\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/tedutter.com\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/tedutter.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tedutter.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=548"}],"version-history":[{"count":435,"href":"https:\/\/tedutter.com\/index.php?rest_route=\/wp\/v2\/pages\/548\/revisions"}],"predecessor-version":[{"id":1598,"href":"https:\/\/tedutter.com\/index.php?rest_route=\/wp\/v2\/pages\/548\/revisions\/1598"}],"wp:attachment":[{"href":"https:\/\/tedutter.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=548"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}