Thom Pantazi adz6ln@r.postjobfree.com

904-***-****

KEY SKILLS

Microsoft SQL Server

T-SQL

DB2

Purview

Databricks

Cognos

Power BI

Python

Data Warehouse

ETL

Azure DevOps

DAX

C#/.NET

CERTIFICATIONS

70-778 Analyzing and

Visualizing Data with

Microsoft Power BI

AZ-900 Azure

Fundamentals

PCAP™ – Certified

Associate in Python

Programming

SR. DATA ENGINEER

Thom is a technical and business savvy leader who thrives on helping organizations optimize their performance through Business Intelligence and Analytics. He excels in helping both business users and technical teams in taking advantage of proven patterns and practices in finding solutions to Business Intelligence and Data Management. Working with on-prem and cloud-based platforms he has nearly 4 decades of deep and wide experience in all aspects of data management including: enterprise pattern design, data modelling, star schema and dimensional modelling, ETL design, data mapping, data flow documentation, etc.

TECHNOLOGY SUMMARY

DATABASES: SQL Server 2019 - 2000, IBM DB2, Azure SQL Synapse, Azure SQL DB SYSTEMS: Microsoft Windows 10, 8, 7, XP, Server 2012, Azure VM, IBM iSeries SOFTWARE: Azure Data Factory, Databricks, Azure Logic Apps, SQL Server, Synapse, DevOps, Terraform, Data Stage, Azure Machine Learning LANGUAGES: T-SQL, Python, C#, .NET, DAX, SSIS Expressions IT EXPERIENCE

SHI CORP DATA ARCHITECT, 2/22 – 9/23

Built dynamic data extraction framework using Databricks

Implemented Azure Purview establishing data governance best practices enabling self service Power BI reporting 3 CLOUD

SOLUTIONS/

PRAGMATIC

WORKS

CONSULTING:

SR. DATA ENGINEER, 8/18 – 1/22

Lead a team that delivered a JD Edwards data warehouse reporting system using Azure data factory and capturing data lineage and governance details with Purview.

Established cost savings through dynamic scaling services as needed.

Delivered Azure ML POC in for large industrial automated natural gas facility identifying sensor anomalies by simulating streaming from OSI PI system.

Migrated major grocery chain data warehouse from DB2 to Azure using dynamic ADF pipelines

Assisted banking client effort in delivering Azure based data flow to satisfy new government regulations

Built a dynamic Data Factory solution for data movement and cleansing

Created Logic Apps to provide alerting and status reports

Developed data dictionary mapping data movement

process

LANDSTAR DATA ARCHITECT, 2/98 – 7/18

Received a US patent for a voice-based alerting engine that improved safety and increased driver profitability while dynamically matching freight with operators.

Thom Pantazi adz6ln@r.postjobfree.com

904-***-****

Saved lives and money by reducing accident fatality rate from 2.7 per billion miles to 1.6.

Built a star schema-based data warehouse targeting revenue and expense improvements making Landstar

more agile and responsive to rapid market change while enabling record growth year over year.

Developed analytic dashboards with business units to make data warehouse solutions both more responsive and agile enough to adapt to changing conditions.

Increased driver profitability via patented voice-based alerting engine that searched for and called drivers about loads available at their anticipated destination, eliminating need for them to look at their phones.

Designed conformed slowly changing dimensions (SDMs) as an enterprise canonical model to represent business fundamentals.

Built a competitive pricing system that allowed sales agents to pull pricing from proprietary internal data both historical and spot market, as well as various external sources, enabling highly accurate and timely bid responses that used real time analytics to determine lane rates.

Designed ETL solutions that combined data from disparate sources making them available to Data Warehouse and Operational Data Store (ODS).

Designed interfaces for purchased or hosted applications that interacted with legacy and sun setting systems, smoothly merging old and new technology.

Worked with both Kanban and Scrum teams to support agile development for both teams.

Mentored younger developers and designers. Coached on ETL process best practices and aided in personal

development.

Lead BI discovery sessions and collaborate with business users to identify KPIs and gather requirements.

Built scope, estimates, project plans and requirements.

Designed data warehouse star schema models with SCD and conforming dimensions providing data mining across subject domains.

Developed test and deployment plans and instructions

Contact this candidate