Experience

Clarion Events North America Inc

• Events Services
• 1 - 100 Employee

• Data Architect

  • Mar 2019 - Present



Coaltrain Software

• Owner / Data Architect / Senior Business Intelligence Specialist

  • Jan 2012 - Present

  Specilizing in Data Warehousing and Business Intelligence solutions. Expert in the Microsoft Business Intelligence Stack, Business Objects Data Integrator/Services and Informatica

• Data Architect\BI Specialist

  • Jan 2012 - May 2012

  Chesapeake Energy, Inc via Stonebridge, Oklahoma City, OK• Performed the role of Data Architect for a project with Chesapeake Energy to build and integrate their Chesapeake Oilfield Services subsidiaries into their existing Enterprise Data Warehouse. The first phase focused only on the Subsidiary Great Plains Oilfield Rentals (GPOR) and bringing their daily operational data in to report metrics and KPI’s on Revenue, Invoices and Equipment Utilization. o Worked with business partners to gather expectations and requirements for the projecto Designed a working proof of concept with live data using SSIS and SQL Server 2008 in which an SSAS Cube was built on top of it to allow the business users to slice and dice their data.o POC was well received and requested that the POC be made into a usable interim system until fully productionized system could be fully developed.o Converted POC done in SQL Server to be hosted in Oracle 11i, including table conversions and SSIS conversion to move from SQL Server to Oracle.o Worked with EDW team on standards and design decisions to integrate the COS data into the existing model., o Worked with EDW team on fitting TrakQuip data into their integration layer using the oilfield industry standard I_PPDM data modelo Worked with TrakQuip project team on anomalies in the source system data and on new processes to support moving data to the warehouseo Designed mapping documents for Informatica team to build ETL Mappingso Performed source system data and functionality analysis to establish required data necessary to generate metrics and KPI’s.o Designed snapshot tables and processes to capture monthly snapshot of ticket data so that Business Users have a point in time reference against a rapidly changing source system.• Environment: SQL Server 2008r2, Oracle 11i, SSIS, SSAS, SSRS, Informatica, Embarcadero Enterprise Architect, ER Studio, Visual Studio 2008, Visual Studio 2010, Team Foundation Server, PPDM, TrakQuip, Visio



John Brown Farms

• Co-owner/operator

  • Aug 2008 - Present

  Raising natural pasture raised Scottish Highlander Cattle without drugs or steroids or hormones and selling direct to the consumer so you know where your beef comes from Raising natural pasture raised Scottish Highlander Cattle without drugs or steroids or hormones and selling direct to the consumer so you know where your beef comes from



American Legion Post 131, Skiatook/Sperry

• Post Commander

  • Jul 2018 - Jul 2021



American Legion Oklahoma District 1B

• 2nd Vice Commander

  • Jul 2019 - May 2021



American Legion Riders Post 131, Skiatook/Sperry

• Riders Director

  • Dec 2018 - May 2021



PennWell

• United States
• Book and Periodical Publishing
• 200 - 300 Employee

• Data Architect

  • Sep 2018 - Mar 2019

• Sr database developer III

  • Mar 2015 - Sep 2018

  Design, build and supports the Marketing Audience Database using microsoft technologies. Proficient in ssis, ssas, ssrs and sql server

• Sr Database Developer II

  • Aug 2012 - Mar 2015

  Designed and implemented Pennwells Marketing Audience Database merging data from various outside systems into a homogenous model for mining customer attributes and generating mailing lists. 35+ million audience members supported and unified across the sources with 1/2 a billion attributes on those audience members and growing as we add new sources of information. Warehouse has a live dynamic query generation tool hitting the data directly to generate on the fly the marketing lists needed for mailings or invitations to conferences, etc...*Environment: SSIS 2012, SSAS 2012, SSRS 2012, MDS 2012, SQL Server 2012, Visual Studio 2012 and 2013, TFS, Pragmatic Works Task Factory, Flat Files, XML Files, Web Service Calls, SSIS Catelogue



Dollar Thrifty Automotive Group

• Leisure, Travel & Tourism
• 700 & Above Employee

• Data Architect/Domain Application Lead

  • Aug 2009 - Jan 2012

  • Performed the role of Data Architect in regards to all of the company’s databases, primarily the warehouses, but advised on all other projects involving database changes/creation. Performed role of Domain Application Lead to manage the technical specifications and direction of all data management projects, including server, storage, tool requirements, working with customers on the business and IT side to establish expectations and needs the projects would. o Designed new data warehouse to combine 3 existing warehouses into a single comprehensive warehouse to provide enterprise reporting.o Designed Informatica and SSIS jobs to load data to a staging database and transformed it to the Enterprise warehouseo Designed and implemented table partitioning, performance indexes.o Revamped two like branded applications in VB 6.0/Classic ASP to ASP.NET 4.0o Voting member of the IT Discover and Define project lifecycle process, ensuring projects are fully thought out, meet architectural guidelines and will benefit the company.o Architected the enterprise reporting environment, from Servers supporting loads, SQL Server Reporting Services stood up in a farm, SQL Server Analysis Services for Data Cubes, and SQL Server 2008 clustered for failover capability.o Created the first enterprise wide library of system data models in Embarcadero and made them available online for the company to use in planningo Implemented an online data dictionary to enable the reporting community to better understand the new warehouse data modelo Enforced database and data movement design criteria on company projects through membership and participation phase gate reviewso Provided support for developers, management and other company personnel when they needed help on accomplishing tasks like complex reporting, data movement, complex SQL queries, programming and other alternatives to better solve a problem.



Integre Systems

• Brazil
• Industrial Machinery Manufacturing
• 1 - 100 Employee

• Senior Consultant - ZIONS Bank

  • Mar 2009 - Aug 2009

  • Project: Provide conversion services of Data Integrator jobs from an Oracle Based target/source system to a hybrid Oracle source/Green Plum Target and GreenPlum source/target. Initial 8 week project extended for additional 4 weeks to do additional conversion work.o Performed Data Integrator Package review and planned for the conversion process, estimated time needed to convert and testing time.o Created Defined flat file formats for 40 output tables from Oracle and created defined YAML files for each export file.o Created Custom DI function to call client specific code in Python/PSQL for handling their custom partitioning of tables and loading of data.o Worked with the Solaris Unix file system, editing files, calling scripts, and testing a new ODBC driver to work with both the Green Plum based Postgre SQL database and SQL Server databases used for data warehouse.o Converted Data Integrator 11.5 and Data Services 3 based jobs to work with the new Greenplum Enterprise data warehouse.o Rewrote scripts and SQL transforms to work with the functionally of Green Plum, removing Oracle specific calls.o Integrated SAP Rapid marts using Data Services to their existing processo Provided support during debugging and testing of the converted Jobs.o Performed performance tuning testing of Job conversions, significantly speeding up their current process by 40% on one conversion batch.• Environment: Business Objects Data Integrator, Business Objects Data Services, Green Plum MMS, Oracle 9i, Oracle 10g, ODBC, YAML, Python, Solaris, Unix, Scripts, PSQL

• Senior Consultant - Covance Laboratories, Inc

  • Jul 2007 - Mar 2009

  • Project: Two-year Data Warehouse Project for $15 million Toxicology Program with Business Objects Data Integrator Implementation. Covance deployed Next Gen to six distinct locations around the world at their main research facilities o As the Lead Architect for two years, designed data warehouse sourced primarily from Next Gen which included 850+ tables per instanceo Designed central reporting data warehouse, which included 300 denormalized tables that were updated in near real-timeo Implemented the extract, load, and transform (ETL) logic in Business Objects Data Integratoro Designed system to allow for one code base to be used on all five source systemso Provided source system analysis and mapping specifications and provided mentoring on Data Integrator to client’s personnelo Designed and managed effort to populate test data into the source system for performance testingo Acted as liaison to the TIBCO team, which provided near real-time data populationo Served as the primary source of information regarding the source and target systems and the transforms neededo Built views and other necessary code segments for the TIBCO implementationo Provided knowledge transfer for Covance to reimplement its data warehouse ETL logic using Business Objects Data Integratoro Assisted with the conversion of the PL/SQL packages as the learning method for implementing the various transforms contained within Data Integratoro Reviewed and made recommendations for job server configurationo Set up a secure, central repositoryo Discussed best practices for using the built-in transforms and functions for handling common data warehousing scenarios including lookups for code translations and the history preserving transform for slowly changing dimensionso Discussed best practices for designing jobs such as when and when not to stage datao Discussed best practices for using the multi-user functionality for versioning, sharing

• Senior Consultant - ICF Internations

  • Feb 2007 - Jul 2007

  • Project: Business Objects solution implementation including Business Objects Data Integrator, Business Objects Enterprise, Web Intelligence, Dashboard Manager, and custom data marto Worked with a team of full-time consultants from Integre Systems to provide ICF International with database design and programming services in order to create a Financial Dashboard reporting system for the Louisiana Road Home Programo Team defined system requirements, created test data, and performed source system analysiso Designed and developed extract, transform, and load (ETL) logic in Business Objects Data Integratoro Designed and developed Business Objects Metrics Universe and Business Objects Dashboardo Tested and validated ETL, Universe, and Dashboard before deploying Dashboardo Conducted knowledge transfer, provided documentation, and provided support for Pipeline Data Mart• Environment: Business Objects Data Integrator, Business Objects Enterprise, Business Objects Dashboard Manager



Scientific Research Corporation

• United States
• Defense and Space Manufacturing
• 700 & Above Employee

• Senior Engineer - SPAWAR

  • Mar 2002 - Feb 2007

  Various project work over the duration there including:Navy Tool for Interoperability Risk Assessment (NTIRA)NTIRA Data WarehouseUniversal Needs Tracking System (UNTS)Master Systems List (MSL)Master Clients List (MCL)ForceNet Implementation Baseline (FIBL)Capability Analysis ToolGeminiiTWOOTOver this time I worked with many diverse technologies:Business Visual Basic 6.0, Visual C++ 6.0, Visual Studio, .NET 2005, .NET 2008, MS SQL Server (2000, 2005, 2008), Microsoft SharePoint, SharePoint Web Parts, Oracle 9i and 10g, Web Services, SOAP, WSDL, MFC, MATLAB, Infragistics Controls, Artificial Intelligence (AI), Microsoft Office Interfacing, PDF Creation, Encryption, Common Access Card Integration, Biometrics, Lotus Notes, Lotus Domino, Secure Sun Solaris, Linux, VMware, Visio, Erwin, Data Modeling, Data Architect, Software Architect, System Architect, Rational Rose, Rational Clear Quest, Rational Requisite Pro, Counter Strike AI Engine API, XML, JAVA, JavaScript, ASP.NET, C#.NET, VB.NET, Custom Controls, Stored Procedures, Triggers, SQL, TSQL, Views, Functions, DTS Packages, Scheduling, Business Objects Data Integrator, Dashboards, DotNetNuke, Web Portals, Web Screen Scrapping, Windows NT, Windows XP, Windows 2003 Server



Integre

• Construction

• Senior Consultant - Pro Health Care

  • Jan 2007 - Jan 2007

  • Project: Business Objects Data Integrator scoping and knowledge transfero Documented and provided recommendations on client’s data warehouse ETL deployment requirementso Evaluated and assisted in building client’s ETL deployment project plano Evaluated current configuration (including job servers and central and local repositories)o Discussed best practices for using the built-in transforms and functions for handling common data warehousing scenarios including lookups for code translations and the history-preserving transform for slowly changing dimensionso Discussed best practices for (a) designing jobs such as when and why not to stage data, (b) using the multi-user functionality for versioning, sharing, and reuse, (c) using built-in transforms and functions for error handling and notification, and (d) change data capture and guidance on when to use Business Objects Data Integrator versus Golden Gateo Configured and tested connectivity to Attunity and configured and tested metadata reporting and metadata integration to Business Objects Universeo Upon completion of his on-site work, developed a comprehensive recommendations document• Environment: Business Objects Data Integrator, Attunity, Golden Gate, Oracle



National Computer Systems (NCS)

• Consultant

  • May 2000 - Oct 2001

  • Project: Next Generation Sorting Equipmento Designed and built touch screen VB applications that interfaced with the real-time operating systemo System separated, scanned, read, and determined which bin to sort the item in the first ten feet of the system in the millisecond time rangeo Designed and built a system for storing the machine run-time information for calibration/configuration management on each custom built machineo System was designed on a custom version of Windows NT to enable it to run Steeplechase OS simultaneously through direct kernel communicationo Designed and built calibration system allowing users a visual view of the system calibrating, providing both numerical and graphical readouts for the system stateo Touch screen applications were designed in VB with the real-time drivers written in C++, included OCR scanners, thickness detectors, barcode readers, and various other custom hardware pieces built into 200 to 400 pocket sorting machines• Environment: Visual Basic 6.0, Visual C++ 6.0, Steeple Chase Real-Time OS, Windows NT, Infragistics Controls, Global Magic Controls, Device Drivers, Custom Dynamic Structured Files, System Calibration, System Control, OCR Scanners, Optical Scanners, Thickness Detectors, Barcode Scanners, Touch Screen



CIMCASE International/Jump Technologies

• Consultant

  • Feb 2000 - May 2000

  • Project: Manufacturing Management Consoleo Converted existing applications from Delphi to VB 6 and made major changes in the functionality and reporting ability of the applicationso Applications communicated via DDE to PLC Server and by TCP/IP to their MTMS MRP system for real-time reporting of parts manufactured • Environment: Business Visual Basic 6.0, Delphi, DDE, Excel, Allen Bradley, PLC Server, TCP/IP, MTMS MRP, 2500 Ton Press, Programmable Logic Controllers, • Project: Manufacturing Management Consoleo Converted existing applications from Delphi to VB 6 and made major changes in the functionality and reporting ability of the applicationso Applications communicated via DDE to PLC Server and by TCP/IP to their MTMS MRP system for real-time reporting of parts manufactured • Environment: Business Visual Basic 6.0, Delphi, DDE, Excel, Allen Bradley, PLC Server, TCP/IP, MTMS MRP, 2500 Ton Press, Programmable Logic Controllers,



CIMCASE International\Jump Technologies

• Consultant

  • Jun 1999 - May 2000

  • Project: Remote Access Programo Designed interfaces to access control modules located at building sites over RS-485 to control up to 16 buildings per COM port from a central locationo Application had two parts: first, the polling part that read in current building environmental parameters and inserting those values into the database backend; the second part was to manage individual building settings either by tweaking individual parameters or changing current running profile settings• Environment: Visual Basic 6.0, RS-485, Serial Communications, MS SQL Server 7.0, Windows Service, Temperature/Building control module, Windows NT

• Consultant

  • Nov 1999 - Feb 2000

  • Project: Inventory Management Systemo Designed a multi-tier inventory tracking/management system in conjunction with the use of handheld scanners to track what inventory had been checked out to a particular vehicle and maintained a real-time inventory count to enable on-time part orders to ensure well-stocked warehouseso Scanners ran on Visual C++ code, front-ends built with Visual Basic and Crystal Reporto Backend data storage in SQL Server 7• Environment: Visual Basic 6.0, Visual C++ 6.0, Crystal Reports, MS SQL Server 7.0, TCP/IP, Hand held wireless scanners, Microsoft Transaction Server (MTS), COM+

• Consultant

  • Sep 1999 - Nov 1999

  • Project: Timecard Management Systemo Designed n-tier system via MTS to provide Human Resources the ability to manage a large personnel base of hourly workers on the plant floor.o System entailed multiple TCP/IP based timecard readers running customized C++ software to capture/record personnel scans, recording their time in the backend databaseo HR applications enabled personnel reports via Crystal Reportso Data was stored in SQL Server 7• Environment: Visual Basic 6.0, Visual C++ 6.0, TCP/IP, time clock modules, Crystal Reports, MS SQL Server 7.0, Microsoft Transaction Server (MTS), COM+

• Consultant

  • Jun 1999 - Sep 1999

  • Project: Pre-Paid Legal Websiteo Designed custom web site for company that was driven by the users’ geographical location to determine what legal notices were required per individual state requirementso Web site provided the company’s sales force with their own sub websites off of the main site, giving the sales individuals various selectable layouts/designs to choose from to customize their siteso Designed web site in Jasmine Object-oriented databases to store data, and the custom html pages needed to build the site on the flyo System also interfaced with the existing backend through IBM DB2Connect library to their DB2 database• Environment: Sun Solaris, IBM DB2, IBM AS 400, Jasmine Object Oriented Database, Object Data Query Language (ODQL), IBM DB2 Connect, Posix C



Doug Carson and Associates

• Programmer

  • Oct 1996 - Jun 1999

  • Project: Mastering Interface Systemo Developed GUI and various backend components for company’s flagship producto Designed and built an automation tool to allow connection to various SCSI tape changers, arrays of CD drives and other devices to schedule day’s worth of production runs ahead of timeo Integrated various hardware SCSI devices into application library, including DLT tape changer, 8mm DAT tape changer and various CD Driveso Reverse Engineered communication protocols via RS-232 command logging to integrate new functionality into control applicationso Interfaced with encryption libraries and algorithms for piracy prevention at unauthorized facilitieso Designed and built a tape extraction and performance utility for in-house use, later packaged and sold to customers as a pre-mastering utility• Environment: Visual C++, Visual Basic, RS-232, Serial Communications, TCP/IP, Device Drivers, Custom Computer Hardware, Encoders, Decoders, Reed/Soloman Algorithm, Dongles, Install Shield, INI Files, Script Files, Registry Programming, Electron Microscopes, SCSI devices, Robotic Tape Changes (DLT/8mm), Umatic Tape Players, Oscilloscopes, CD and DVD theory, International Travel