SUMMARY

• An accomplished Data Warehouse and Transactional Database Architect specializing with over 20 years of experience in database design and analysis with extensive experience in the full life cycle of the database design process including requirements definition, prototyping, proof of concept, design, interface implementation, testing, and maintenance.

PROFESSIONAL EXPERIENCE

Operating Systems: Windows (7, 10, Server 2012/2016), UNIX (Sun Solaris, Free BSD, AIX)

Programming Languages: Visual Basic, C, C++, C#, T - SQL, Shell

Scripting: (Windows, UNIX), HTML

Databases: SQL Server 2008 R 2/2012/2014/2016/2017/2019 , Azure SQL, IBM INFORMIX, Access

Software: IBM Cognos 8/10, Visual Studio 2010/2012/2015/2017/2019 (SSIS, SSAS, and SSRS), Team Foundation Server, Visual Source Safe, Subversion Source Control, GIT Source Control, Crystal Reports, Microsoft Teams, Microsoft Office, Microsoft Visio, Tableau, Erwin Data Modeler, Power BI.

Cloud Technologies: Azure Data Lake, Azure SQL Database, Azure Data Factory, Azure Databricks, Azure Synapse (Formerly Known as Azure SQL Data Warehouse), Azure Analysis Services, Azure DevOps, Microsoft Power BI

PROFESSIONAL EXPERIENCE

Confidential, Pearland, Texas

Azure Data Architect/Engineer

Responsibilities:

• Architected and implemented an Enterprise Data Warehouse solution to provide company-wide data analysis on sales and fraud detection.
• Create schema for metadata database to audit data lineage points and control Azure Data Factory Pipeline flows.
• Build Azure Data Factory (V2) pipelines to ingest source system data into Azure Data Lake Storage.
• Create complex data transformations and automated data ingestion into information marts utilizing Azure Databricks.
• Create conceptual, logical, and physical data models for the Enterprise Data Warehouse and downstream information marts.
• Collaborate closely with team members to ensure the highest quality of project deliverables and best architectural practices.

Confidential, Plano, Texas

Director/Business Intelligence

Responsibilities:

• Designed and implemented the Enterprise Data Warehouse and Analytic project from scratch utilizing cloud-based infrastructure and the Data Vault 2.0 design pattern to ensure agility and reliability.
• Managed and collaborated with my team to deliver departmental analytic needs hourly via Information Marts that are audited and monitored so Enterprise collaboration on requested metrics could occur in a transparent fashion.
• Reduced Azure Cloud costs by nearly 50% by performing a close analysis of costs and making suggestions on how some of the infrastructure components were being utilized.
• Integrated build and release pipelines in Azure DevOps for the purpose of continuous integration across all environments to ensure the highest product quality.
• Implemented Near-Real Time Dynamic ETL processes utilizing SSIS, T-SQL, and Cloud PowerShell script to populate Data Warehouses and Data Marts.

Confidential, Frisco, Texas

Manager/Consultant

Responsibilities:

• Mentored and trained junior developers on best practices and implementation for the SDLC in an Agile environment.
• Implemented Near-Real Time Dynamic ETL processes utilizing SSIS to populate Data Warehouses and Data Marts in Azure SQL.
• Provided management with estimates of needed Azure assets and ensured that the project stayed within the budget.
• Started a POC that would utilize Azure Data Lake Store (ADLS) to start feeding the Kafka enterprise service bus.

Confidential, Plano, Texas

Data Warehouse Architect

Responsibilities:

• Created and implemented the Database Development Life Cycle to organize project deliverables and decrease time to market with improved quality.
• Mentor and train new team members on how to create high efficiency ELT processes to decrease negative impact on customer facing systems while increasing system performance.
• Created the conceptual, logical and physical data models to create the new Enterprise Data Warehouse utilizing Kimball Star Schema methodologies.
• Created dashboards with Tableau that consume departmental data marts.
• Designed and implemented SSAS cubes to allow business users to quickly consume existing business metrics.
• Implemented Near Real Time(NRT) Dynamic ELT processes utilizing SSIS to populate Data Warehouses and Data Marts.

Confidential, Dallas, Texas

Manager/Database Development

Responsibilities:

• Architected and implemented the multidimensional data model for the Enterprise Data Warehouse to provide departmental metrics.
• Architected and implemented a near-time SQL 2012 ELT data warehouse load that determines relational database changes every one minute and processes these changes into a star schema for downstream analysis.
• Mentor and cross-train team members in development and architecture methodologies to increase project throughput.
• Created and implemented a Data Vault schema to represent a layer between the transactional system and data warehouse to ease the impact of upstream schema changes and increase downstream performance.
• Managed multiple development teams simultaneously that provided business solutions with quality.
• Created departmental SSRS reports and SSAS cubes to consume enterprise analytics.

Confidential, Plano, Texas

Sr. Data Development

Responsibilities:

• Designed and maintained the data import process to import Google Analytic data to provide granular client web site statistics for centralized reporting.
• Architected the database schema and ETL process to import vehicle images, trim, and incentive data for our clients in real time to be reflected on their web sites.

Confidential, Carrollton, Texas

Business Intelligence Program Director

Responsibilities:

• Created the enterprise data warehouse ETL process via SSIS packages from scratch. The data warehouse ETL job (staging, dimension and fact processing, and data mart population) processes over 350 GB of data in 30 minutes.
• Managed and lead a team of 2 data warehouse developers.
• Modeled denormalized data models (dimensions and facts) from relational data sources to provide a user-friendly structure (star schema) so that end users may create their own ad-hoc reports via the IBM Cognos report portal.

Confidential, Dallas, Texas

Lead SQL Developer

Responsibilities:

• Created and implemented SSIS packages to ETL client’s updated account information from creditors.
• Designed and deployed reports via SSRS 2005/2008 to report sales and lead statistics.
• Designed and implemented the real time leads distribution system, with SSIS, that allows the debt consultants to be in contact with the client within seconds of them submitting their information via the public website.
• Designed the data schema, stored procedures, views, indexes, and user-defined functions for the new CRM system. I also created the ETL with SSIS to import all legacy data from the old system to the new schema.
• Mentor junior level database developers and ensure quality code by reviewing all code and structures that is intended for production use.

Confidential, Dallas, Texas

Senior Systems Engineer

Responsibilities:

• Designed import processes utilizing Data Transformation Services to import terabytes of 3rd party client data into our enterprise database.
• Consolidated over 100 DTS packages into 1 package that can import standardized data for all existing and new clients.
• Converted existing database schema over to a data warehouse utilizing a star schema to enhance enterprise reporting.

Confidential, Dallas, Texas

Software Developer

Responsibilities:

• Constructed SQL 2005 DTS/SSIS packages and stored procedures to import financial transaction data for financial transaction reconciliation and instrument mapping purposes.
• Created a C# application that looks for data files at a specified interval so that custodian transaction data was updated on the fly.
• Designed an account management tool in C# to allow the users to do real-time changes to client accounts for reconciliation.
• Implemented and maintained 3rd party reconciliation application (FMC Recon) to replace the less efficient reconciliation tool.
• Researched the standardization of client transaction files via FPML.
• Utilized SSRS to create and generate reports according to end-user specifications.

Confidential, Dallas, Texas

Software Developer

Responsibilities:

• Created automated customer billing solutions and agent payment platforms utilizing DTS Packages, stored procedures and views on SQL Server 2000 to gather customer payment and billing information.
• Implemented credit/debit card interface and server to allow our customer service representatives to take real-time payments via the Internet. This project saves the company several thousands of dollars every year because no commission needs to be paid to any agent for these transactions.
• Created an application to monitor our Integrated Voice Response (IVR) system and alert designated users instantly if this system is down or disabled.
• Designed and implemented DTS Packages, on SQL Server 2000, to import billing data from the Incumbent Local Exchange Carriers on various data sources for cost analysis and auditing purposes.
• Designed and developed COM component enhancements that support and enhance our customer service application. These ActiveX components will increase productivity when migrating our applications to the Web.
• Created enhancements and maintained the custom accounting system enterprise application in Visual Basic 6.0.

Confidential, Irving, Texas

Application Developer

Responsibilities:

• Designed, developed, and supported the National Repair Center customer service application. This application manages repair orders and is interfaced with the existing Package Manifest system to allow the user to instantly send repair orders very quickly back to the customer.
• Implemented Intranet web pages to provide online support for the POS system for on-call personnel.