Report Developer

SUMMARY

Seasoned Microsoft Certified Cloud Solution Architect with 20+ years of expertise in designing and implementing cloud data platform solutions for customers across various industries. Expertise in SQL CE (Data & AI) and data Stream Solutions, successfully provided services in architecting and implementing highly available solutions with Microsoft applications, and Azure Cloud innovations.

HIGHLIGHTS

oAt Microsoft successfully delivered multiple Azure Data Platform VBDs (Value Based Deliveries) to enterprise clients including Phillip 66, JCPenney, CenterPoint Energy, and American Airlines.

oProficiently Derived Data architectural excellence, data management, schema design, application tier integration & services, and infrastructure architectures for Microsoft.

oSupported customers with multi-cloud constructs, including a customer possessing AWS Cloud's largest fleet of SQL Servers with 5K clusters.

oDesign HADR systems and troubleshoot existing SQL Server estates.

oMigrated and troubleshoot Enterprise Rentals SSRS environment to Azure IaaS in a scaled-out deployment.

oIdentified/remediated Azure cloud adoption roadblocks related to networking, security/identity, migration strategies, and design patterns.

oProvided data architectural expertise at Baker Hughes for a variety of enterprise-level initiatives including SOA Data Tier Design, Salesforce.com, Datawarehouse - ODS and OLAP schema designs, Enterprise SQL Clustering.

oAt JP Morgan Chase provided data management and system design expertise for a variety of multi-billion dollar Critical 1 systems consisting primarily of SQL OLTP production servers located in Houston, Dallas, Seattle, and Northridge California.

Skills

Years of Experience

Overall SQL Server stack Expertise

20+

Data & Cloud Platform Deployment & Configuration

7+

Azure Cloud Services, Azure PaaS, Linux/Unix

7+

SCORECARD

Cloud Solution Architect

Aug 16 – Oct 23

Microsoft, Houston, TX

Delivered innovation and re-architecture for designated customers as the primary support for both on-premises SQL Server and Azure data platforms. Customers included:

oPhillip 66 (Azure)

oJCPenney (On Premise)

oNCR (On Premise and Azure SaaS)

oInfor (AWS SaaS)

oEnterprise (On Premises & Azure)

oH&R Block (Azure SaaS)

oWillis Towers and Watson (On Premises & Azure SaaS)

oCenterPoint Energy (On Premise)

oCenturyLink/IBM (On Premise)

oRack Space (On Premise)

oUnited Airlines (Azure)

oAmerican Airlines (Azure)

oSpirit Airlines (IaaS in Azure)

Delivered Data Platform VBDs (Value Based Deliveries) to enterprise clients:

oAzure Data Migration Service

oAzure Automated Backups

oAzure Data Synch

oAzure SQLDB

oAzure SQLMI

oAzure SQLMI Link

oAzure SQL Server IaaS

oServerless compute tier for Azure SQL Database

oPerformance Tuning and Optimization

oSQL Server HA/DR

oSQL Server RAS (Risk Assessment Service)

oSQL Server 2022 Features

Proposed and assisted in the delivery of data architectural excellence, data management, schema design, application tier integration & services, and infrastructure architectures

Identified/remediated Azure cloud adoption roadblocks related to networking, security/identity, migration strategies, and design patterns

Developed repeatable use migration builds at the tenant level that allowed any business submit to prescriptively migrate to their subscription

Utilized expert-level skills across the SQL Server product stack and the IaaS and PaaS implementation equivalents in Azure.

Engaged with customer's SQL teams to address performance and responsiveness issues through deep-dive tuning sessions

Routinely assessed customer architectures and environments proactively to identify compliance with best practices

Partnered with Microsoft Support Services routinely to drive root cause of disruptions relating to SQL Stack both on-premises and in the Azure cloud within Linux/Unix environments

Worked with teams of customer Architects to deliver value and expedite Azure cloud adoption

Supported customers with multi-cloud constructs, including a customer possessing AWS' largest fleet of SQL Servers with 5K nodes

Routinely advised customers with hands-on POCs, non-production migration process hardening, and subsequent production implementation support, hands-on code reviews & rewrites

Personalized proactive training/education, and specific technology discussions during initiative-building exercises

Lead SQL Server DBA/SQL Architect Apr 10 – Mar 16

Exterran, Houston, TX

Designed, built, and successfully migrated all non-Oracle production systems that utilize SQL Server for an Exterran 2015 divestiture of its US operational unit, creating production & non-production systems with dedicated SQL storage over 500TB

Develop HSE Reports for Exterran’s HSE Team in SSRS.

Utilized VMWare, EMC VNX5800 SAN with RDM, built an 8 node, 256 core VM hosts for a production SQL clustering solution across 2 data centers Established recovery time objectives and data retention policies

Migrated, re-stacked, and supported 2 PBs across production, development, and UAT due to divestiture activities at Exterran/ArchRock as they functioned as one entity for 6 months preceding regulatory approval

Developed enterprise development & deployment standards for OLTP, OLAP, and SSIS database object creation/best practices

Set up TFS and subsequent processes to support both Microsoft & Oracle development repositories across three lifecycle environments

Worked as a technical lead for designing/build-out of a Microsoft Fast Track BI Solution utilizing an EMC dedicated storage frame with 24 TB of data storage to house SQK Server ODS, and Data Warehouse

Built Microsoft SharePoint BI Stack; including 7 TB Analysis Services, Reporting Services, SharePoint & Performance Point

Implemented Kerberos authentication for several BI web applications

Evangelized the need to select an Oracle EBS third-party product to speed the delivery of BI for prescribed functional groups This included EBS database triggers, Informatica ETL, and pre-defined dimensions which enabled a time to market in less than 7 months for many key business units

Worked as a technical lead for a multi-million-dollar enterprise implementation of Autodesk Vault

Redesigned an Autodesk Vault solution to utilize SQL Server merge replication and local application servers to reduce WAN traffic to optimize database synchronization

Senior SQL DBA/Data Architect Nov 06 – Feb 09

Baker Hughes, The Woodlands. Texas

Provided architectural leadership for a variety of enterprise-level initiatives including SOA Data Tier Design, Salesforce.com, Datawarehouse - ODS and OLAP schema designs, Enterprise SQL Clustering, ArcGIS-driven applications

Evangelized best practices and design patterns for robust solutions

Senior SQL DBA/Data Architect

Dec 00 – Nov 06

JP Morgan Chase (WAMU), Irving, TX

Provided data management and system design for a variety of multi-billion dollar Critical 1 systems consisting primarily of SQL OLTP production servers located in Houston, Dallas, Seattle, and Northridge California

Technical Expertise:

SQL Server SSRS

SQL Server Clustering (HADR)

SQL Replication

SQL Performance Tuning

SQL Server Integration Services (SSIS)

Data Strategies

Data Privacy

Master Data Management

Data Architecture & Modeling

Azure Data Lakes

Azure CLI

Linux, Unix

Azure Data Factory

Site Reliability Engineering

Microservices

DevOps

Design Patterns

Conflict Resolution

Hadoop

Data Integration & Analysis

Data Centers Relocation

Cloud Computing

Active Directory

Infrastructure, Virtualization

Educational Background:

Master's Degree, MPA - Focus Econometrics, University of Houston, Houston, TX

Certifications:

Microsoft Certified Professional (MCP), Microsoft, 2016

Certified Cloud Data Platform Solutions, Microsoft, 2016

Certified Azure Administrator Associate, Microsoft, 2020

Contact this candidate