Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Network Power<100 people
Roles
✔️100%
IT
👍100%
Sales & BizDev
🧑🔬100%
Engineer
Geos
Work Background
Trace3Sr Data Architect
Jun. 2023 - May. 2024Knoxville, Tennessee, United StatesConsultant to Polen Capital
o Sr Data Architect for the client Polen Capital. Created developer standards,
architected new data structures for the data in Snowflake.
o Oversaw international data engineers.
o Coordinated with data review team (Data Guild) to ensure that design standards
were followed.
o Designed pipelines to load data from various sources into the Snowflake
environment.
Consultant to Winland Foods
• Coordinated documentation of existing packages which loaded data into Power BI environment for use after divestiture of Winland Foods from their former parent company
• Created a framework for testing and evaluation of the data
• Worked with WF architects to develop modern warehousing structures
Consultant to Gray, Inc
• Restructured Azure environment
Consultant to Polen Capital
• Sr Data Architect, coordinating updates to Snowflake Environment
QHR Healthcare Affiliates, LLCSr Data Architect
Jun. 2021 - Feb. 2023Franklin, Tennessee, United StatesOversaw data operations for this company that supports small hospitals. Oversaw team that developed data warehouse, designed transactional database for revenue recovery. Maintained legacy databases. Interacted with development teams and the business analysts. Developed and maintained data model for all segments of the business.
• Designed data structures for healthcare claims processing – ingestion of and creation of transmittal information for healthcare. (835, 837, 276, 277) • Designed HL7 (FHIR) Processing structures
Evolta LLCSr EDW Architect
Feb. 2021 - Jun. 2021RemoteFulltime 2/2021-6/2021, part time 6/2021 - 3/2023 as needed
Migrating on-prem data sets to data lake (parquet) in Azure using Azure Data Factory, sourcing from sql server, flat files, mySql & Salesforce. Developing automated processes to respond to upstream schema changes. Taking datalake data to consumable data mart and developing dimensional model. Developing Data Dictionary for users. (ADF, Parquet, Python, Azure Sql, MySql, Salesforce)
apHarmony Inc. - Custom Software DevelopmentSr Data Warehouse Developer
Jul. 2020 - Dec. 2020RemoteMisumi USA - Creating US data warehouse for this parts manufacturer. Developing a data warehouse in Amazon Redshift. Completed 5 data marts, others forth coming.
Involves moving data from MySQL and SQL Server sources. Using Talend, SSIS and internal ETL tools. Table definition, views, scheduling and requirements analysis.
OSGSr Data Architect
Oct. 2019 - Mar. 2020Addison, TxSolis Mammography (Addison, Tx) 10/2019- Present Sr Data Architect & Modeler. Developing data dictionary for EMR data housed by this client. Developing process and warehouse for this provider. Modeling EMR data and architecting Datawarehouse. Initial project was to feed data to dash boards in Tableau. 2nd Project was to extract de-identitfied data for a national research firm from their undocumented EMR system. (SSIS, SQLServer 2017, erwin, Tableau, PostgreSQL)
Provision HealthSr SSRS Architect
Oct. 2019 - Jan. 2020Knoxville, Tennessee AreaWorking with the leader in Proton Therapy, developing reports to help them better understand their client profile and improve business processes (SqlServer 2017, SSRS, SSIS)
OSG Sr Data Warehouse Architect
Mar. 2019 - Sep. 2019Destin, FL / Remote Knoxville, TNCDK Global/ eLead1One (Destin, FL) - building a data warehouse for reporting and analytics. 3/2019-9-2019
Participated as a data warehouse architect for this developer of Dealer Management Software for the automotive industry. Initial DW consisted of call center records and CRM records. DW is populated continuously, via ETL packages developed for this process. Contact Center records come via a third party database in MySQL. CRM records are from SQL Server. Role included requirements gathering, meeting with stake holders and outside vendors. Supported development of dealership reporting in SSRS. Created cube for incident response system to allow for management to identify delays in response. (SQLServer 2017, SSIS, SSRS, SSAS)
Oxford Global Resources / Atlantic Health SystemSenior Data Engineer / ETL Architect
Aug. 2018 - Apr. 2019Morristown, NJ / Remote in Knoxville, TNDeveloping process to import data from Insurance claims to data warehouse for analysis. Conversion of 500m records for analysis sourced from different insurers and medicare. Client is a large northeastern health care provider, desiring to utilize insurance information to evaluate practice procedures, health care patterns and risks.
TEKsystemsSr. Data Architect
Mar. 2018 - Apr. 2018Knoxville, Tennessee AreaSupported a project with Team Health. Developed data model and ETL translations for migrating a vendor supported project from off site to internal. Created data mart, validated load queues, and established protocols. Worked with internal Data Architects on naming and modeling standards. (SQL Server 2017, ERWin, Oracle, Netezza, OnBase, SSIS, MicroStrategies)
TekSystems/University of TN System - Office of Information TechnologySenior Database Architect Consultant
Oct. 2017 - Oct. 2017Knoxville, Tennessee AreaThis was a 3 week contract reviewing existing Data Warehouse implementation and identifying areas that should be of concern from the security viewpoint and creating an action plan for the client to follow.
Premier Staffing Partners / ORAU, ORISEData Warehouse Architect
Mar. 2016 - Sep. 2017Oak Ridge, TNInitial project was designing a Data Warehouse to characterize program effectiveness for Scientific Apprenticeships at various laboratories.(Sql Server 2014, SSAS 2014, SSIS, Tableau, QlikSense) Developing a data warehouse for division wide performance metrics. Extracting data from Oracle, OBIEE and other sources for this project. . Redesign of primary data flow for the Scientific Assessment/Workforce Development division for ORAU, including overhaul of existing data structures, creation of new structures and procedures and design of migration paths for the legacy data. This design was the preparation for creation of a data warehouse with one source of truth. Functioned as production DBA, established publishing procedures, implemented CIS benchmarks, created security monitoring and identified performance issues from the development group. Implemented CIS Sql Benchmarks and created policies and procedures for development, publication and access for all levels of database access with in the contractor. Created auditing process that will adjust servers to be within compliance. Reviewed non standard implantation of servers and access, creating a change process to bring these with in the ORAU accepted standard for DOE based computers.
Boyle Consulting ServicesSr Data Warehouse Architect / Database Consultant
Apr. 2014 - Sep. 2018Knoxville, Tennessee AreaCurrent Projects Include:
- Discharge instructions and analytics for a medical website, Anytime Pediatrics (MsAccess, SQL Server) Recent Projects Include:
- Resolving clustering issues for SQL Server Cluster in a VM environment for an Automotive parts manufacturer.
- Restructuring an HR database to accommodate multi-Tennant data.
- Improving performance of Dynamics AX instance for a local retailer. - Previous project was refining data warehouse cubes for Sandia National Labs. Complex SSIS packages and MDX queries for integrating cubes from various parts of the organization. Additionally working on converting legacy reporting to SSRS by creating complex stored procedures to support business logic. - Designed data model, data warehouse and ETL processes to aggregate IDX and VOW data from the 895 MLS systems in the US. Data for each of these systems have unique characteristics that are preserved in data model, while standardizing the majority of the data for statistical analysis in the Data Warehouse. In this approach, the client’s business analyst matches fields from the origin database to the standardized db. Additional outflows from this process include populating legacy tables based on a rules based matching algorithm. For many of the markets, updates are every 15 minutes. Business Intelligence is used to predictively model data changes based on historical statistical patterns to identify data issues.
- SQL Server Performance support for American Pools (2012, SAGE)
- Manufacturing Company Scheduling system
- Changes to Legal Services Company process tracking software
- Upgraded import process for rail road accounting firm
TEKsystems / SCI Consulting / ORNLContract BI Developer
Sep. 2012 - Dec. 2012Oak Ridge National LabContracted to develop scheduled SSIS jobs for the BI process at ORNL. During the duration of this contract, I have been asked to provide techical guidance to the Oak Ridge National Lab as they migrate from a collection of SSIS packages that provide periodic updates to their data warehouse, to a full scale ETL process that incorporates SSIS, SSRS and SSAS to provide better management information to senior management. (SSAS, SSIS, SSRS, 2008r2)
Self Employed Database ConsultantBI Architect / Database Developer - Architect
Jul. 2011 - Aug. 2019Knoxville, TN AreaFull design cycle services for companies. Consulting work includes design specification, data modeling, database design and interface development. Performed Database Consulting work for various companies around Knoxville and throughout the US. Projects have included a data replication and reporting services project for a medical services company, a data import from a 3rd party db for the same firm, a reporting project for an accounting firm, a data import from AdvantageFx for the same firm & a test records database for a nuclear testing company .as well as a hospitality management program, ETL Process for Crime stats and a scheduling / student management program for a music school. Provided a performance review for a media fulfillment company in Nashville. Currently working on an expanded reporting services and data warehousing project for a regional retailer and doing a contract for a training and certifications DB. Additional recent project was to simplify the transfer process between a client's shipping software, their inventory management software and Amazon Merchant Services. What was a highly manual process is now an automated hourly process.
Self Employed Database ConsultantBI Architect / Database Developer - Architect (Continued)
Jul. 2011 - Aug. 2019Knoxville, Tennessee AreaClients have included:
Safety and Ecology Corporation - Knoxville, TN (SqlServer 2008r2)
Home Educating Family Publishing - Nashville, TN (MySQL, PhP)
BARMETRIX - Washington, DC (SQL Server 2008r2)
Net3IT - Knoxville, TN (2008r2, SSIS, SSRS, AWS)
ProvisionHP (SSIS, 2008r2, SSRS)
ServPro (MS Access 2010)
AMS Corp (2008r2, SSIS)
Knox County Sheriffs Office (SS 2008r2, SSIS)
A local public accounting firm, (AdvantageFx Db, 2008r2, SSRS)
A payroll services company (2008r2, Access)
A hospitality reservation company. (MySql PhP)
Joy of Music School (SQL Server 2012, Access)
AiMedia Solutions (VB.net, SQL Server)
ORNL (SSIS, SSRS, SSAS)
Vocera Care Transition (SQL 2012 Enterprise, SSIS 2012, SSRS 2012, BIRT, HL7)
Auralation Music (FilemakerPro)
The White Stone Group (2008r2)
Claris Networks (2008r2)
AltarD State (2012, 2008r2, SSIS, SSRS)
Mountainside Coal Company (2012, Access, Lightswitch)
Grigg Industries - (ShipWorks,InflowInventory, AmazonMerchant)
A Local Realtor's office (Sql 2012, MS Access)
Net3IT - Microsoft Analytics AX Reporting Skills - Utilized SQL Server 2000-2012, SSIS 2005-2012, SSRS 2005-2012, SSAS 2008-2012, BIRT, HL7, MS Access, SQL Partitioning, ETL, Data Warehouse Design, ShipWorks, InflowInventory
RecruitWiseContract Database Administrator (DBA) for City of Oak Ridge
Jul. 2011 - Apr. 2012- Development of a program to manage the processes of the OR City Clerk, including the election of Boards and Commissions, meeting scheduling, attendance records, document recording and personel management.
- Software needs analysis and integration using SqlServer & SharePoint2010
- Migration of SqlServer 2000 servers to 2008r2, creating SSIS packages and recofiguring sql server.
- Redesign of packages which pull data from the AS400 and import this data into SQL Server
- Various MSAccess interfaces to the SQL Server data, Including time entry, utility billing and meeting scheduling
CoreLogic MarketlinxDB Team Lead / Architect / Sr SQL DBA
Oct. 2001 - Jun. 2011Knoxville, Tennessee AreaDevelopment Database Team Leader (SQL Server 2000, 2005, 2008, SSIS, ETL)
-Lead 7 development DBAs, providing architectural support, procedures, and reviewing change requests to the system for impacts to performance. Coded stored procedure, SSIS packages and designed Server environments to include various replication strategies, clustering and large scale systems (24+ processors). All design work must follow high concurrency design protocols, as some of these systems will have 15000+ concurrent users. -Lead development effort and designed ETL system that continuously updated 3.5m records from a third party warehouse, utilizing a custom data control. System was designed and coded to adjust to changes in source data structure, and realign to this new structure. The system could update up to 450k records per day, in addition to providing users on the system (2500+ concurrent users) fast responsiveness from the DB.
-Provided oversight to products external to our core product (MLS System) including supervising Java development effort.
-Maintained confirguration manangement for the database environment. Development Team Manager (TSQL, SQL SERVER, VS 2010) -Lead 2 teams of 5 software developers, DBA, QA staff and Customer Relations staff to support 13 major contracts (4 of the 5 largest in the company). Responsible for technical decisions for these contracts as well as personel development and project delivery. Senior Architect -Coordinated development decisions for entire development organization
-Lead definition effort for configuration management
GoTrain.NetIS Manager
Jan. 2000 - Oct. 2001-Recruited and Managed development staff of 6 developers and 1 Network administrator, providing mentoring and leadership for this group of various skills.
-Designed and developed 2 lifecycles of the Corporate Distance Learning Center, evolving it into the GoTrain Training Academy. This is a full featured training administration system for assigning requirements to a learner and keeping track of learner progress.
-Created eCommerce interface, allowing non-traditional GoTrain customers to purchase courses online. -Designed and lead development effort for GoTrain CourseWare, allowing customers to develop custom courses for use on GoTrain.
-Interfaced with large corporate customers for integration of their learner data into GoTrain.net
-Developed MAPI application to notify learners automatically their upcoming/overdue training requirements.
-Extended middle tier application for interfacing the data to the web.
TeneraManager Information Technology
Jan. 2000 - Oct. 2001Tenera was the parent company for GoTrain.net.
Sobran, IncSoftware Engineer / IT Manager
Jan. 1999 - Jan. 2000Oak Ridge, TNSobran's IT Group was sold to Tenera in January 2000 -Project Manager - Position Opportunity System for Sempra Energy Systems
-Senior Developer – Corporate Distance Learning Center, (GoTrain.net) -Project leader for ITRAC implementation for Loring AFB. (MapObjects, VB)
-Created OCX for use with ongoing project which uses MapObjects to ‘sew’ together GIS maps from multiple counties to create one seamless map. (MapObjects, VB)
Courthouse Retrieval SystemSenior Systems Analyst
Mar. 1993 - Mar. 1999-Created CRS PayPerView, (SQL, MS Access, VB dll, ASP) an e-commerce solution which allows for web users who are non traditional clients of CRS to purchase CRS services via Credit Card.
-Developed ListServe (SQL, MS Access, SQL Server) - a web based application for extracting data sets from CRS data for the list services division of CRS. Features include automated invoicing, prequery cost estimating, automated periodic data extraction and email delivery of data
-Converted main company database from dBase to Access, redeveloping all update programs and conversion routines.
-Developed Millenium (ASP, VBA, VB, IIS4) - a web based application for accessing CRS Data using Microsoft SQL, Visual Basic and Java
-Integrated third party Foxpro based DataEntry Program into CRS data entry structure
-Lead design team for the development of Information Support System, (xBase) which provided for the integration of property data, graphics and census data for all Real Estate parcels in six states
Analysis & Measurement ServicesSystems Programmer
Jan. 1992 - Mar. 1993-Developed in house and commercial applications in C for institution of AMS testing procedures. Programs spanned data acquisition, analysis, qualification, presentation, human interfaces and interaction with the IEEE488 bus.
-Participated in development of AMS Quality Assurance procedures for software and for Noise Analysis.
-Worked with both DOS text based interfaces and Windows GUIs.
-Developed a graphical database of sensor information • Program for noise analysis using univariate auto-regressive modeling
• Ascii to binary compression utility for consolidation of R&D files. Target group was 45,000 files which were using 2.5 g of drive space. 72 % compression achieved
• Program command shell which ran various DOS based AMS noise analysis programs. Included an expert mode which "learned" new programs and required parameters
• Response time calculation program for drop testing of control & shutdown rods in nuclear power plants, events which occur in 150-220ms
Living Faith Church, Joliet IlAdministrator
Jan. 1990 - Dec. 1990Joliet, IllinoisAs church administrator, I was responsible for the financees, overseeing the facility, and providing an avenue for programs to succeed in this church of 450.
Boyle Consulting ServicesConsultant
May. 1989 - Oct. 2001Joliet, Il / Knoxville, TNTennessee Tape & Label: QA Database (MS Access), Training database (MS Access), Advanced Label Sequencing Program (VB)
Ted Russell Nissan: Sales Commission Database (VB), Customer Satisfaction Db(MS Access) Crane Valve: (FoxPro) Developed a Job Costing system for their Nuclear Valve Division facility near Joliet. BASF: Formulation database (MS Access)
King Pharmaceuticals: Sample Dispensing Database (MS Access)
Worldwide Discipleship AssociationCampus Staff
Jan. 1988 - Dec. 1989I spent time raising support to be on staff for this campus ministry, at the University of Auburn
Intch is a Professional Networking App for the Future of WorkSee more people like Bob on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
453430 people
18
Technologist, Project/Program Manager
24
Data Scientist Intern @ Newell Brands
16
Program Manager @ DISH Network
35854 people
24
Data Scientist Intern @ Newell Brands
42
Senior Mining Engineer @ Riot blockchain
16
CEO/Data Engineer and Consultant @ Propeltech Services LLC