SQL/DAX Unicorn Data Architect

Theodore Seeber

503-***-**** *********@*****.*** LinkedIn

DATA MANAGEMENT DATA ANALYTICS DATA VISUALIZATION AUTOMATION SOFTWARE ENGINEERING

Software Engineer & Data Architect with strong experience developing data-driven solutions that significantly improve operational and technical processes.

Specializes in engineering large-scale enterprise database environments, developing automation solutions, and deploying technologies according to regulatory compliance directives. Coordinates the work of multidisciplinary technology project teams to ensure the success of data solution engineering initiatives. Currently seeking a Senior Data Analyst role.

PROFESSIONAL ACHIEVEMENTS

Generated detailed reports in Power BI for the Optane product while overseeing quality assurance and defect management, contributing to timely Apache Pass and Barlow Pass releases while improving project delivery efficiency by 35%., reducing manual tasks to save $1.4 million annually.

Implemented compliance validation for an SQL database with pre-trigger data cleanup, decreasing data-related compliance incidents by 35%.

Reverse-engineered databases for Freightliner/BMW and a medical lab, increasing process visibility by 95% and enabling AI functionality that reduced labor by 25%.

Upgraded 36 ETL processes from SQL 2018 to SQL 2022 in Azure, enhancing data governance and reducing data center costs by 15%.

Developed a SQL-based application for product manufacturing and quality management, cutting waste by 33%.

Integrated PIP and SSN data governance regulations into Workday data imports, improving compliance by 20% and increasing tool engagement by 38%.

PROFESSIONAL EXPERIENCE

UNCOMN Remote Chicago/St. Louis/California – Data Analyst Consultant (October 2024 – January 2025)

Mentored younger engineers on being a contractor

Created and tested EDI queries for EDI 322 using Python

Created AWS/S3/Postgres connection to PowerBI dashboard for data analysis

Created custom one off reports for end client from database using PowerBI and distinct SQL queries.

INFORMATION-R-US – Beaverton, OR- Digital Intelligence Consultant (Mar. 2024 - Present

Oversaw a project focused on creating an engineering workstation for a materials engineering business, helping the customer to reduce project lead times.

Managed the development of a hybrid online and in-person meeting platform for a nonprofit organization, improving the customer’s meeting participation metrics by 85%.

Implemented point-of-sale systems for multiple customers, which contributed to a 20% rise in their overall sales and fundraising.

Developed a Data Governance Schema in the Azure Data Center for Databrick capacity planning, enhancing data tracking capabilities by 25%.

Developed a Data Governance Schema in the Azure Data Center for capacity planning, enhancing data tracking capabilities by 25%.

Theodore Seeber PAGE TWO

INTEL- MSO, Hillsboro, OR - Enterprise Architect (Sep. 2023 - Feb. 2024)

Supported the transition to Agile and SQL 2022, establishing Agile practices for a geographically dispersed team, resulting in increased ticket velocity and faster support case completion.

Conducted root cause analyses focused on resolving critical architectural and system issues; leveraged findings to implement improvements that reduced error rates by 25%.

Optimized Data Governance Framework: Created a Data Governance Schema in the Azure Data Center for Databricks capacity planning, boosting data tracking efficiency by 25%.

Engineered CI/CD deployment pipelines in Azure, providing a new development architecture that accelerated support case resolution times.

INTEL- DCAI Hillsboro, OR- Senior Software Data Analyst (Sep. 2016 - Aug. 2023)

Provided expertise on data entry issues in the ETL process, using SSIS, SSRS, Python, and Java enhancing data accuracy and reducing errors by 75%; also analyzed data schemas and developed advanced queries, improving ETL efficiency and decreasing server loads by 35%.

Generated detailed reports in Power BI for the Optane product while overseeing quality assurance and defect management activities, contributing to timely Apache Pass and Barlow Pass releases while improving efficiencies in project delivery by 35%.

Facilitated improved team communications and collaboration by promoting time-zone-friendly meetings, leading to 75% reduced trouble ticket backlogs.

Diagnosed and categorized bugs for the 10 nm chip manufacturing process node, expediting the delivery of 10 nm server products to data centers for Fortune 500 clients by 45%.

Managed ETL pipeline from 32 separate data sources, including MongoDB, Oracle, PostGres SQL, MySQL, SQL Lite, MariaDB, Denodo, and

XTREME CONSULTING GROUP, Portland, OR- Data Detective (Mar. 2016 - Aug. 2016)

Analyzed and documented SAPGUI VBS scripts, DTS scripts, SSIS scripts, 1,734 tables, 4,000 views, and 3,000 stored procedures in SQL Server 2005, establishing oversight of Freightliner North America’s parts supply chain database, which improved data governance by 75%.

SOFTWARE TECHNOLOGY GROUP Beaverton, OR - Senior Consultant (Mar. 2015 - Oct. 2015)

Enhanced an ASP.NET 4.0 Webforms website by updating CSS, HTML5, and integrating Exigo web service and Azure Database, supporting online organizational charts for an HR client and reducing support requests by 20%.

INTEL CONTRACT EMPLOYEE Hillsboro, OR- July 2014-March 2015

Continued to maintain reports for Intel CPTD with SQL Server 2012, SQL Server 2008, Aegis, WCF, MVC and JQuery

Managed transition of older Access reports using Aegis Excel extracts to SAP ME using SQL Pathfinder

Created datapath from SQL Pathfinder to XML to SQL Server 2012 to keep Enforcer working (an Access front end tool used by CPTD Debug Team)

Managed data merges and ETL from Oracle tools into SQL Server 2012

MINDTECK, Hillsboro, OR - Software Engineering Consultant- October 2013-July 2014

Created a reporting database for Intel CPTD group with SQL Server 2012, SQL Server 2008, Aegis, MVC and JQuery

INFOBAHN SOFTWORLD Hillsboro, OR- Software Engineering Consultant- January 2013-August 2013

Redesigned 1st normal form data warehouse to 4th normal form with random incoming data in SQL Server from Oracle and Android JSON sources with redundancy including mirrored server and watch server.

Main Database Administrator for the project

Developed complex BI front end in C#, ASP.NET 4.5, WCF, HTML 5 and Javascript, MVC

APEX SYSTEMS, BEAVERTON, OR - Software Engineering Consultant- Oct 2010-December 2012

Managed legacy client-server system with over 8000 active users and multiple databases tied to other systems for Integra.

Back end SQL Server 2008, front end VB6/C#/VB.NET/ WPF on a Citrix Virtual Server

Main database developer for the project

INFORMATION-R-US, BEAVERTON, OR - Independent Consultant- Oct 2001-September 2011

Software Modifications to PTI Global timecard system as needed, Visual Studio 2003/Visual Studio 2008 with Access backend

Analyzed VB6/VB.NET/ WPF /C#/SQL Server 2008 Labvantage LIMS system for ZRT Laboratory, a local medical analysis company. Used WCF to design a REST web service link to new online reporting system in XML, using TDD architecture. Modified WPF layer for printing of PDF reports.

Visual Studio 2003-2005-2008-2010, SQL Server 2010, ASP.NET 3.5, Windows XP, Windows 7, Excel Macro 2007/2010, SSRS, AcitveReports

PTI GLOBAL, BEAVERTON, OR - Software Engineer-July 2008-Aug 2010

Contracted to Intel working on hardware testing software comparing performnce of 8 different laptop systems with 26 variants, using VBScript and AutoIt for automation, Assembly Language, SQL 2005, VB.NET WPF and Waitn shell scripting, working on a team using Agile Development

Contracted to Intel working on extranet e-commerce application to schedule classes and order class materials to promote technology use in the classroom for K-12 teachers, using SQL 2005, C# 2008, ASP.NET 3.5, WCF, HTML 4.0, CSS & Javascript

Designed the next-generation 3rd normal form database in Postgres SQL for the internal timecard project.

ODOT, SALEM, OR - Software Analyst- June 2006-April 2008

Worked on a variety of support & maintenance projects in VB, C#, AJAX, ASP.NET, and SQL Server Transact SQL

Helped create major n-tier business projects on the intranet in the areas of utility bill processing, rail inspection, and civil rights using Agile Development, VB.NET 2003, SQL Server and Crystal Reports 11.

Worked on Fleet Condition Model covering a $350 million set of assets

GALT FOUNDATION, SALEM, OR - MS Office and VB Consultant- December 2003-June 2005

Worked on Contract with State Agency

Primary responsibility upgrading databases for Windows XP Rollout (Agency was moving from Office 97 base to Office 2002 base).

Secondary Responsibility major rewrite of database linking for sets of users with a mixture of Windows XP and Windows NT installations

SUPPORTFREAKS.COM, BEAVERTON, OR - Independent Consultant - April 2002-December 2003

Provide immediate technical support to visitors to the site via chat, email and telephone.

WELLSOURCE, INC., CLACKAMAS, OR - Software Engineer - August 1999 - October 2001

Created dynamic system which enabled users to access the database from Web as well as Desktop.

Designed databases in 3rd normal form.

Created 4-tier ActiveX Com+ components in VB 6.0 that used XML for communication between layers using Agile Development in SQL Server 7.

CASCADE CONSULTING, BEAVERTON, OR - Senior Consultant - February 1999 - September 1999

Acted as primary programmer for analysis, design, implementation and installation of a server-side EXE that created ASP pages based on input data and generated e-mail alerts to the client's customers in VB 5, ASP, and SQL Server 6.5 in 3rd normal form with denormalized star schema views.

System enabled day traders to get alerts on stock market data from a single source.

IMG, INC., BEAVERTON, OR - Consultant - September 1997 - February 1999

Used programming and technical skills to create enterprising and effective programs, which helped the sales force at a Fortune 500 Company meet sales goals Oracle 8i and Crystal Reports/Crystal Info Server 6.

Assisted in programming fish-tracking project for government agency, which allowed field experts to bar code and categorize salmon growth and return rates using VB4 & Access.

Created manufacturing scheduling system which enabled a plastic products manufacturer to better use machine time using VB3.0 & Sybase SQL Anywhere.

CASINO SOFTWARE CORPORATION OF AMERICA, SALEM, OR - Software Engineer - July 1995-July 1997

Worked on all core products and led the software development of Las Vegas version of software.

Created demo product to attract financing from Casinos, including a CD-ROM to distribute at shows.

VB 3.0, SQL Server 6, SQL Server 6.5, Access 2.0, Crystal Reports 2, Crystal Reports 3, Crystal Reports 4

TECHNICAL SKILLS

DATABASES: SQL Server, Oracle, SQLite, MySQL, MariaDB, MongoDB, Denodo, Active Directory, Postgres SQL

DATA SCHEMAS / APIs: JSON, XML, CSV, ODBC, JDBC

SOFTWARE DEVELOPMENT LANGUAGES: Python, SQL, C#, Java, Perl, M, DAX, PHP, HTML 3.0-5.0, JavaScript, PowerShell, CMD, Bash, ASP, LINQ, C++

FRAMEWORKS: Web Forms, Windows Forms, ASP.NET, Power BI, SSIS, SSAS

METHODOLOGIES: Scripting, Procedural, CI/CD, Scrum, Agile, Waterfall, cURL, REST

SOFTWARE LIFECYCLE MANAGEMENT TOOLS: Jira, Git, Red Hat SQL Tools, Microsoft Project, Gantt Charts, Visio Data Flow Diagramming, Visual Bugs, Visual Studio IDE

OPERATING SYSTEMS / ENVIRONMENTS: Windows Server, Windows Client, Azure, Linux, AWS S3

DATA ANALYTICS: Excel, Crystal Reports, Power BI

PRODUCTIVITY SOFTWARE: Office 365, Word

EDUCATION

Bachelor of Science, Software Engineering Technology

OREGON INSTITUTE OF TECHNOLOGY

Contact this candidate