BI/DW Data Architect Resume

SUMMARY

Dedicated and results - driven database professional with extensive experience across all levels of data analysis, modeling, and design roles.
A rich history of experience spanning across multiple industries, including IT services, software development, insurance, healthcare, food distribution, manufacturing, banking, transportation, and education.
Strong interpersonal and written communication skills that allow for effective collaboration across any personal or cultural divide.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

BI/DW Data Architect

Responsibilities:

Developed, deployed, and maintained a complete digital media interaction data warehouse utilizing Azure Data Lakes, Cosmos DB, Azure Data Factory and a U-SQL database.
Managed the reporting database for a multi-branch dental association, including the migration of SSRS and SSIS from SQL Server 2008 to SQL Server 2017, and the development of a change tracking system using dynamicSQL and temporal tables
Maintained and supported a complete Azure cloud data warehouse for an appliance manufacturer which included the use of DevOps Pipelines, Azure Event hubs, Azure Analysis Services, Power BI, and BIML
Maintained a sales and contact management data warehouse for a truck manufacturer which incorporated T2 code, BIML, and master data to dynamically build the complete data warehouse development process
Used BEAM methodology to develop a complete data mart for income statement analysis, implemented in Azure using Data Lake, Delta Lake, Azure Data Factory, Databricks, Snowflake, and Tableau

Confidential

BI/DW Architect

Responsibilities:

Gathered requirements, profiled data, and delivered analysis from 7 sources of transactional data for usage in a 10 Factor data warehouse
Developed, deployed, and maintained an ACA Accountable Care Organization (ACO) data warehouse using Toad data modeler, SSIS 2016, and SQL Server 2016, as a product to be sold to other ACOs
Developed, deployed, and maintained a multi-data mart data warehouse for direct-to-customer sales and club membership analysis which allowed for the creation of a complex customer matching process for a conformed customer dimension
Designed the SSIS ETL environments along with integrating source & version control into the existing processes while maintaining minimal impact to current development
Utilized the Agile software development methodology to develop an automated SSIS process to deploy an Azure SQL Server Instance, database application code, DDL, and data for a patient billing & insurance management system that allowed each client to have their own isolated environment

Confidential

Data Warehouse Consultant

Responsibilities:

Served across various roles, including Data Architect, Business Analyst, ETL Developer, and Database Administrator
Developed ETL packages in SSIS in the complete loading of multiple data marts for the analysis of POS locations including club membership and marketing performance metrics
Optimized existing data warehouse sales quote data loading process over 75% by reducing load time by 6 hours

Confidential

Senior Database Administrator

Responsibilities:

Monitoring, maintaining, and tuning over 50 production SQL Servers production environments for complete management of the manufacture logistics and storage of the metal food container
Regular, 24/7 support provided to all urgent and emergency issues that arose
Managing the replication of ERP data to and from various manufacturing and storage plants

Confidential

Senior Database Administrator

Responsibilities:

Managed and maintained the full database and BI development lifecycle which included development, QA, UAT, performance and production database environments
Implemented database standards in design, development, and deployment of both OLAP and OLTP projects
Worked closely with the BI department to improve both the design and performance of the relational and multi-dimensional (SSAS) databases
Designed and developed SSIS packages for various projects, including BI, ETL, and processing
Monitored, maintained, and tuned over 100 production SQL Servers, SSIS, SSAS, and SSRS production environments for management of the complete modern cell phone lifespan
Provided regular, 24/7 support to all urgent and emergency issues that arose