Summary
Overview
Work History
Education
Skills
Affiliations
Certification
Interests
Timeline
Groups Affiliations
Generic

Peter M. Florenzano

Auburn,USA

Summary

Seasoned Principal Data Engineer with expertise in performance tuning, security, high availability, Database Architecture, ETL/ELT pipeline design/implementation, data warehouse, 'lift and shift' migrations from on-premise to PaaS SQL Server environments. Skilled in building ETL solutions with both structured & unstructured data, report building, and backup/recovery strategies. Seeking a challenging full-time permanent position as a senior/principal/lead level data engineer within an MS SQL Server/Azure and/or relational/non-relational database environment.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Principal Data Engineer

KBR
03.2023 - 07.2025
  • Built custom Azure Synapse notebooks and pipeline which utilizes a variety of data sources including relational databases (Oracle & SQL) and non-structured JSON data coming from live IoT devices.
  • Developed custom Python programs for ingesting various data types into the Asset Management product.
  • Performance tune and secure our databases within an MS Azure environment.
  • Created and demoed custom built Power BI reports to various clients.
  • Attended various trade shows to help promote our Asset Management product.
  • Created Azure IOT Hubs with relations to iMonnit for device management.
  • Developed CI/CD procedures for both Power BI Reporting & Azure environment.
  • Implemented a solution to migrate from Azure Analysis Service models to Power BI Premium semantic models which resulted in saving the company 100k annually.
  • Team lead for offshore resources.

Senior Data Engineer

Cooler Screens
01.2022 - 03.2023
  • Built custom Azure Streaming Analytics jobs off using an Event Hub input pointing to a live API to both Azure Synapse Analytics and Power BI reports.
  • Built custom Azure Data Factory pipelines and Databricks notebooks to company and Microsoft standards.
  • Modified existing pipelines to run more efficiently which resulted in saving thousands of dollars monthly on ELT/ETL loading costs.
  • Build and maintain new documents within Cosmos DB for our application platform.
  • Assisted developers by re-architecting our products database to conform with 3rd normal form standards for both referential integrity and performance.
  • Assisted with building a new more normalized data model for our existing RVA application within PostgreSQL.
  • Building new development/test/production environments for both Azure SQL Database and Azure Synapse Analytics.
  • Convert old methodologies of using MS Excel spreadsheets as their pre-existing reporting tools to Power BI, which helped Cooler Screens gain more insights into their product.

Senior Data Engineer

RESurety
07.2021 - 12.2021
  • Built custom ETL & ELT processes with converting non-structured JSON data to structured/readable data for the data scientist team within an AWS/PostgreSQL/Snowflake environment.
  • Build pipelines using ETLeap.
  • Building data warehouses within Snowflake.
  • Building databases within PostgreSQL.
  • Developing a Data Governance Policy for the company with the thought of obtaining continuous delivery using CI/CD tools such as GitHub or Azure DevOps.

Senior Data Engineer

Planet Technologies
03.2019 - 07.2021
  • Performed MS Access to Azure SQL Database conversions for various clients.
  • Build pipelines using Azure Data Factory and SSIS.
  • Developed various data warehouses using both Azure SQL Data Warehouse (former) & Azure Synapse Analytics.
  • Performed data migrations from on-premises SQL Server to Azure SQL Database and Azure SQL Managed Instance.
  • Created Power BI reports using various data sources with a variety of metrics for various customers. These insights improved average costs of nearly 2k a month.
  • Responsible for creating statement of work documents for clients, including time management for tasking purposes.
  • Assisted with the development of Data Governance policies.
  • Providing customer training for Power BI ‘Dashboard in a Day’ throughout the country for various clients.

Senior Data Engineer

Thunderhead ONE
05.2016 - 03.2019
  • Managed high transactional databases within a Microsoft Azure SQL VM clustered environment utilizing SQL Server 2014-2017 Availability Groups and Azure SQL databases vNext.
  • Migrated development, QA, staging and production environments from Microsoft Azure SQL VM to Azure SQL database elastic pools using transactional replication for minimal to no downtime, saving the company tens of thousands of dollars monthly.
  • Created Azure elastic jobs for index performance tuning using Microsoft PowerShell.
  • Developed a series of SSIS ETL packages & SQL Server Agent jobs to write to Azure BLOB storage for daily uploading to Power BI.
  • Perform Ad-Hoc data exports for various customers.
  • Creating, processing and deploying data models from various data sources, including Azure BLOB storage, Azure Table storage to Azure Analysis Services and MySQL/MariaDB to Azure SQL Database via BLOB storage.
  • Create custom Azure Analysis Services measures using the DAX querying language.
  • Building cost effective Azure SQL Data Warehouse(s) with the use of SSMS, SSIS and Azure Data factory for data movement strategies.
  • Creating Power BI reports for both business and various teams across the organization.

Principal Database Administrator

BuyBook Technologies/AutoTrader
04.2013 - 05.2016
  • Managed high volume databases within a clustered physical/Microsoft Hyper V environment using (SQL Server 2008R2, 2012 & 2014). Using Idera Diagnostic Manager, RedGate SQL Monitor Console & AppDynamics for database management, SQL Backup for both backups and restores and Microsoft native toolset.
  • Designed & implement transactional and snapshot replication, with multiple subscribers across different platforms for both production and reporting use.
  • Developed SSIS packages for outgoing/incoming FTP files to and from various vendors and to load data.
  • Developed and maintained existing SSRS reports for senior level management and end users.
  • Converted SSIS 2008R2 packages to 2014 using SSDT.
  • Designed & implemented log shipping for the disaster recovery environment.
  • Weekly capacity planning & overall database server performance evaluations.
  • Managed and developed a Database & Website refresher tool that will dynamically refresh databases within the integration and quality assurance environments, based on what selections were set during runtime. This reduced manual intervention by 50%.
  • Manage security and performance tuning daily.
  • Assisted Database Developer/Architect with normalizing the current database structure.
  • Learning/researching SQL Server 2016.
  • Create database projects and performing deployments using Visual Studio 2013 SSDT.
  • Using both TFS and GIT for SQL code repository and documentation.
  • Managed SAN migration project with third party vendors.
  • Data warehouse training.
  • PowerShell script creation and maintenance.
  • Coursera Data Scientist Big Data Statistical training.

Database Administrator

Catholic Medical Center
08.2010 - 10.2012
  • Manage high volume databases within both a, SQL Server clustered environment (active-passive & active-active) architecture (SQL Server 2000, 2005 & 2008 & 2008 R2) and Oracle (MS Windows & AIX) environments.
  • Manage TSM hardware upgrade project.
  • Work with end users on various projects.
  • Diagnosed long running applications on the database level and perform corrective action with the use of both SQL Server native and third-party performance tools.
  • Created Heterogeneous replication strategies with the use of both Omni View Replicator and native SQL Server replication.
  • Oracle clients 10.2 & 11 installed on both client machines and servers (32 & 64bit) machines.
  • Managing IBM Tivoli version 6.2 backups daily.

Database Administrator

PC Connection
04.2007 - 08.2010
  • Manage high volume databases within a, SQL Server clustered environment (active-active & active-passive) architecture (SQL Server 2000, 2005 & 2008).
  • Manage user security (by SOX standards) on all types of databases, including VLD's (Very Large Databases).
  • Work with end users on various projects.
  • Developed backup and recovery strategies within the organization.
  • Diagnosed long running applications on the database level and perform corrective action, with the use of both SQL Server native and third-party performance tools.
  • Created Heterogeneous replication strategies with the use of both Omni View Replicator and native SQL Server replication.
  • Performed various SQL Server installations on both standalone and cluster environments (SQL Server 2000 SQL Server 2005, SQL Server 2008 & SQL Server 2008 R2 on a Windows 2003, Windows 2008, & Windows 2008 R2 environment).

Education

A.S - Computer Science, accounting

Gateway Community Technical College
North Haven, CT
06.1996

Skills

  • Microsoft Azure expertise
  • Azure SQL Database
  • Azure SSIS Integration Services
  • Azure Data Factory
  • Azure Synapse Analytics
  • Azure BLOB Storage
  • Azure Data Lake
  • Azure Analysis Services
  • Azure Data Warehouse
  • AWS
  • S3
  • PostgreSQL
  • Python
  • ETLeap
  • Snowflake
  • Cosmos DB
  • MS Windows
  • MS Office
  • SQL Server - All versions
  • Oracle
  • DB2
  • MS Access
  • Power BI
  • SQL Server Reporting Services

Affiliations

  • New Hampshire ATV Club of America
  • SQL PASS Member

Certification

Azure Data Engineer Associate

Interests

  • I participate in various sports activities for physical activity, camaraderie, and personal growth
  • Gym Workouts
  • Mindfulness Practices

Timeline

Principal Data Engineer

KBR
03.2023 - 07.2025

Senior Data Engineer

Cooler Screens
01.2022 - 03.2023

Senior Data Engineer

RESurety
07.2021 - 12.2021

Senior Data Engineer

Planet Technologies
03.2019 - 07.2021

Senior Data Engineer

Thunderhead ONE
05.2016 - 03.2019

Principal Database Administrator

BuyBook Technologies/AutoTrader
04.2013 - 05.2016

Database Administrator

Catholic Medical Center
08.2010 - 10.2012

Database Administrator

PC Connection
04.2007 - 08.2010

A.S - Computer Science, accounting

Gateway Community Technical College

Groups Affiliations

  • SQL Pass/SQL Saturday member
  • Power BI of New England member

Similar Profiles

CREATE PROFILE