Senior Data Solutions Consultant

• May 2023 - Present

Lead Data Engineer

• Apr 2021 - Present

Celonis Data Engineering consulting to Johnson & Johnson. Vertica SQL, Dimensional Data Modeling, Digital Transformation and Process Engineering. Celonis Data Engineering consulting to Johnson & Johnson. Vertica SQL, Dimensional Data Modeling, Digital Transformation and Process Engineering.

Lead Data Analytics Engineer

• Aug 2020 - Apr 2021

Celonis business process modeling and mining. Supporting Lockheed Martin modernization through Business Process Optimization and Conformance.

Lead Data Analytics Software Engineer

• Apr 2017 - Aug 2020

Data Architect (JP9711, 2020)Designed SQL Server data architecture for geographically distributed training systems using micro-services orchestrated by Kafka. Used SQL Developer Data Models, Cameo, Confluence, Liquibase, and Swagger as documentation to determine optimal database design. Assists other teams with database design best practices and considerations.------------------------------------------------Lead Data Warehouse Engineer (UKMFTS, AIR5428, BWC, 2017-2020)Delivered program and R&D data warehouse projects for flight training, logistics, reliability and maintenance customers. (SQL Server 2014/2016/2017, BIML, DQS+MDS Master Data Management, Kimball Models w/ SSAS Reporting in SSRS)Lead team to meet customer-facing project timelines and internal R&D objectives. Estimated project scope and assigned tasks to resources. (JIRA, Confluence, MS Project)Participated in Adaptive Learning R&D project as a data warehouse SME. Show less

Data Engineer Consultant

• Nov 2019 - Feb 2020

HLTH.IT in conjunction with Cancer Treatment Centers of America Delivered SQL Server 2017 MVP on Azure Data Warehouse and Data Mart (3NF) modeling with MDM (DQS, MDS). Provided ETL design and optimization. Consulted on BIML script development. HLTH.IT in conjunction with Cancer Treatment Centers of America Delivered SQL Server 2017 MVP on Azure Data Warehouse and Data Mart (3NF) modeling with MDM (DQS, MDS). Provided ETL design and optimization. Consulted on BIML script development.

Data Warehouse Engineer

• Oct 2014 - Apr 2017

Delivered SQL 2012 OLAP and OLTP reporting solutions in the Electronic Health Records industry. Implemented data solution involving Meaningful Use (MU) and CMS (NQF, PQRS) measurements for long term historical trending and analytic reporting using SQL 2012, SSIS, SSAS, and SSRS. Implemented MU summary reports representing hundreds of measures, saving the customer base an estimated 55,000 man hours in MU reporting tasks. Coached Agile methodology via Team Foundation Server 2013 to address shortcomings in business forecasting, capacity planning, and team morale. Recommended and implemented tools, processes, and policies to mature database change management. Designed logical data model and implemented physical model for new Practice Management Dashboard. PMD is an actionable, interactive, drill-down view of a medical practice's health in the form of KPIs and trends. Developed auditing and legacy "paper trail" data sets to support traditional users. Assisted CEO with management decisions: - Enterprise cloud migration (performance testing, tuning, best practices research, break-even analysis) - Interviewing candidates Show less

Data Warehouse Analyst Sr Staff

• Jan 2013 - Oct 2014

Developed the SOFSA Enterprise Decision Support System, a MSSQL 2008 R2 solution to reduce data stovepipes and provide cross-functional, self-service BI in a logistics landscape. EDSS is a multi-tiered metrics platform designed to cater to a variety of information workers - from dock workers to operations managers to program management. The system enabled enterprise-wide analytics on a $2 billion inventory as well as manufacturing, quality, and accounting data.Primarily performed SSIS ETL design/dev, dimensional data modeling, and requirements analysis with SSAS and Performance Point/Report Builder development. PL/SQL development support. Attended Kimball University DW/BI Lifecycle training in order to champion standard, proven DW methodologies to the team. Show less

Systems Integration Analyst Staff

• Nov 2011 - Jan 2013

Responsible for utilizing the entire Operations and Support team to identify, determine root cause, and perform post-mortem actions for all Service Level Agreement infractions. Leverages in house MSSQL solution, GCSS Metrics Data Mart, to support program management decisions by reporting incident trends and capacity forecasts.Decreased routine ETL processing times by over 85% - from 3+ days to <8 hours - through index and data type analysis. The data mart was expanded with additional data sets to provide comprehensive SLA goal tracking without minimal additional processing time. Show less

Sr. Metrics Analyst

• Oct 2008 - Nov 2011

MS SQL 2005 data mart design, development, and optimization for GCSS-AF (www.my.af.mil). Data mart solution processes over 100m records per week and maintains over 2Tb of data for historical querying and analysis. MS SQL 2005 data mart design, development, and optimization for GCSS-AF (www.my.af.mil). Data mart solution processes over 100m records per week and maintains over 2Tb of data for historical querying and analysis.

Communications Engineer

• Jan 2008 - Oct 2008

ASP.Net (VB.Net) and SQL 2000/2005 development for enterprise project management visualizations. SQL Server Reporting Services (SSRS) and custom Dundas controls. Developed Metastorm pilot project to showcase Metastorm features and efficiency gains as a project lifecycle management tool. ASP.Net (VB.Net) and SQL 2000/2005 development for enterprise project management visualizations. SQL Server Reporting Services (SSRS) and custom Dundas controls. Developed Metastorm pilot project to showcase Metastorm features and efficiency gains as a project lifecycle management tool.

Metrics Analyst

• Aug 2005 - Jan 2008

SQL 2000 development and optimization; migration of capabilities to SQL 2005. Delivered various data analysis reports using Excel Analysis Toolpack. Administered COGNOS, Sawmill, and Access ETL and reporting tools. SQL 2000 development and optimization; migration of capabilities to SQL 2005. Delivered various data analysis reports using Excel Analysis Toolpack. Administered COGNOS, Sawmill, and Access ETL and reporting tools.

Web Developer

• Jul 2002 - Aug 2005

Performed development tasks in a team setting using ASP, ASP.Net 1.0 and 1.1 (VB.Net), as well as VB.Net and SQL 2000 for console applications. Created inventory tracking system to assist in additional equipment management duties. Performed funeral services for armed service veterans throughout Alabama for the Maxwell/Gunter Honor Guard. Attended training by the Air Force Honor Guard and assumed responsibilities as flight trainer. Performed development tasks in a team setting using ASP, ASP.Net 1.0 and 1.1 (VB.Net), as well as VB.Net and SQL 2000 for console applications. Created inventory tracking system to assist in additional equipment management duties. Performed funeral services for armed service veterans throughout Alabama for the Maxwell/Gunter Honor Guard. Attended training by the Air Force Honor Guard and assumed responsibilities as flight trainer.