Markham White

770-***-**** cell acwtxo@r.postjobfree.com

Business Intelligence Architect / Database Architect

Multiple Industry and Cross Functional Experience

Experienced information systems professional with more than 20 years experience in design, implementation and performance

improvement of complex ERP, CRM and data warehousing systems in healthcare, public health, manufacturing and financial

services environments. Proven ability to drive positive change, identify and resolve business and technical problems while

creating a positive and collaborative work environment. Impressive record of working with executive leadership and

delivering targeted solutions.

PROFESSIONAL EXPERIENCE

Centers For Disease Control Division of Select Agents and Toxins Contract (April 2015 July 2016)

Business Intelligence Architect

Responsible for design and implementation of database schemas, data migration, reporting and business analytics for

government program responsible for overseeing the possession, use and transfer of biological select agents and toxins. The

project represents a complete technology stack re-architecting and business process re-engineering effort designed to

modernize data collection and facilitate actionable information through data analytics. Required a Secret Government

Clearance.

Technical Environment: SQL Server 2012 database, SharePoint 2013, Integration Services (SSIS) and Reporting Services

(SSRS), Analysis Services (SSAS), PowerShell, Power BI, CA ERwin, Fiddler, LinqPad, SQL Diagnostic Manager, Red Gate

Suite, Visual Studio 2013, Team Foundation Server (TFS)

Bay Dynamics (January 2015 April 2015)

Database Architect

Worked on commercial systems designed to use predictive analytics focused on creating cyber security solutions.

Designed and built SSAS cubes, SSIS ETL packages and database schemas used to monitor corporate network

infrastructure.

Technical Environment: SQL Server 2012 database, Integration Services (SSIS), Analysis Services (SSAS), Visual Studio

2013, Team Foundation Server (TFS), JIRA

Greenway Medical Technologies Contract (April 2013 to January 2015)

Performance Database Administrator

Designed, developed and executed performance testing strategies for the largest EHR system initiative in the U.S. (8200+

Locations). This was a high transactional volume environment (12,000 connections) that demanded fast-paced solutions for

performance issues that arose from stored procedures, embedded SQL and Entity Framework queries. Built databases to

capture and report on performance using Dynamic Management Views (DMV). Developed SSRS reporting solutions for

KPIs used by upper management. Provided production database support for releases and issue resolution.

Technical Environment: SQL Server 2008 R2/2012 database, Integration Services (SSIS) and Reporting Services (SSRS),

Embarcadero E/R Studio, SQL Diagnostic Manager, Red Gate, PowerShell, Dynamic Management Views (DMV), Visual

Studio 2012, LinqPad, Fiddler, Entity Framework 4.0, Team Foundation Server (TFS)

L-3 Contract to Centers For Disease Control (November 2011 to March 2013)

Systems Architect

National Public Health Surveillance and Biosurveillance Registry for Human Health

Designed and built data collection and analytics to support efforts to catalog CDCs public health surveillance assets.

Recently completed an extensive review and validation process for all Registry information to document new activities,

updates to existing activities, and retired activities. The Registry is part of a nationwide approach to biosurveillance that

enhances the United States' ability to detect and respond to emerging health threats, as mandated by legislation and

presidential directives. Surveillance Subject Matter Experts (SMEs) are able to easily view and share information about

surveillance activities at CDC and can better coordinate their efforts to identify and implement appropriate prevention and

intervention strategies.

Technical Environment: SQL Server 2008 database, Integration Services (SSIS) and Reporting Services (SSRS),

Embarcadero E/R Studio, SharePoint 2010, InfoPath 2010, Visual Studio 2008 ASP.NET with C# and VB.

Childrens Healthcare of Atlanta Contract (July 2011 to October 2011)

Business Intelligence Architect

Performed B.I. systems assessment in preparation for large Data Warehouse initiative. Inventoried all database/file source

systems and documented significant data flows. Documented the major systems and ETL processes. Reviewed all current B.I.

reporting and evaluated its effectiveness for information delivery in organization. Based on existing capabilities and

organization competencies, a future-state Data Warehouse architecture was recommended to meet current and future

information needs.

Technical Environment: EPIC Clarity, Oracle 11, SQL Server 2005/2008 database, Integration Services (SSIS) and Reporting

Services (SSRS), Embarcadero E/R Studio, Visio 2010. SharePoint and InfoPath 2010, QlikView 10

Northrop Grumman Contract to Centers For Disease Control - Atlanta, GA (2003 to May 2011)

Database Architect/Developer

Division of Global Migration and Quarantine (September 2007 to May 2011)

System Architect for re-design of the Quarantine Activity Reporting System (QARS) OLTP system to provide enhanced

data access efficiencies, large scale potential and better reporting capabilities. Engaged leadership to gather functional

requirements and present the technical vision. Communicated both technical and functional requirements in SLDC

documentation that included Business Requirements, Technical Design and Deployment plan. Design tools included

Embarcadero E/R Studio, SQL Server 2008, SSRS and ASP.NET.

Conceived, designed and built reporting data mart (QARSDM) to provide management and medical officers with

Commercial Off-the-Shelf (COTS) ad-hoc analytical tools that enhance their ability to spot emerging disease trends.

Identified leaderships need for advanced reporting, then collaborated to define requirements by collecting presentations and

other work products. Technical stack was developed using SQL Server 2008 star schemas, ETL data loading using SSIS and

reporting with SSRS.

Designed and developed the Maritime Illness/Death Reporting System (MIDRS) which facilitates the entire cruise ship

industry to report the illness or death of passengers and crew through a single portal. Reports are then parsed and

electronically sent to the appropriate state health departments. Gathered and coordinated functional requirements across two

governmental agencies and the largest cruise ship lines. Generated the SLDC documentation, including Business

Requirements, Technical Design and Deployment Plan. Developed system using SQL Server 2005/2008 linked servers,

stored procedures, triggers and SSIS for ETL.

System Architect and Team Lead on the Quality Assessment Program (QAP) OLTP system, which ensures the quality of

the overseas medical screening examinations conducted by physician panel sites. Met with leadership and functional users

to gather technical requirements. Produced the SLDC documentation including Technical Design and Deployment plan.

Developed using Embarcadero E/R Studio, SQL Server 2008 stored procedures, triggers, views and audit tables.

Technical Environment: SQL Server 2005/2008 database, Integration Services (SSIS) and Reporting Services (SSRS),

Embarcadero E/R Studio, Classic ASP, ASP.NET, Visual Studio 2008.

Bio-Terrorism Division-Countermeasures Response Administration System (September, 2004 to September 2007)

As Database Architect / Database Administrator (DBA) / Database Developer, responsible for OLTP and reporting database

architecture used to track mass inoculation against terrorist-distributed diseases including smallpox, anthrax and flu. This

system is used by over thirty state and local jurisdictions. Used E/R Studio data modeling tools to generate scripts to automate

creation of all CRUD and auditing operations for the physical model. Wrote custom SQL triggers, stored procedures, views

and functions, which facilitated reporting, data extracts, as well as ETL to an operational data store. Performed capacity

planning analysis to forecast and plan for growth to support recording two flu vaccinations and patient demographics for every

person in the United States.

Technical Environment: MS SQL Server 2000, DTS, SQL Server 2005 database, Integration Services (SSIS) and Reporting

Services (SSRS), Java JSP, Hibernate, Eclipse with BIRT Reports, ASP.NET and Crystal Enterprise 10

Bio-Terrorism Division (January, 2004 to September, 2004)

Data Warehouse Database Architect, responsible for database architecture and ETL process definition for data warehouse

used for analysis on Bio-Terrorism case investigation and sample analysis. Responsibilities included data modeling and

generation of the physical database DDL. ETL process was constructed using MS SQL Sever stored procedures run as

scheduled batch jobs. Secondary transformations, error processing and final loading were done using Pervasive Business and

Data Integrator. This data warehouse was built to respond to emergency disease outbreaks to facilitate epidemiological vector

analysis. Conducted capacity planning for server and data sizing in order to accommodate multi-terabyte data stores.

Technical Environment: MS SQL Server 2000, DTS, Pervasive Business Integrator and Data Integrator, Crystal Reports

Enterprise 9

Bio-Terrorism Division/ Smallpox Pre-Event Vaccination System (February 2003 to September 2004)

Senior Database Administrator/Developer, responsible for database development and administration of system that tracked

smallpox vaccinations in the United States. This new system allows the CDC to track and allocate potential healthcare

respondents in case of a Smallpox Bio-Terrorism event. Designed and coded all the database elements. Stored procedures

were used for all CRUD, auditing and standard search operations. These stored procedures many times relied on custom

coded views and functions as data sources. This system collected approximately 40,000 Smallpox vaccinations of healthcare

workers in the United States.

Technical Environment: MS SQL Server 2000, DTS, Java, WebLogic, Struts, ASP.NET, Crystal Reports 9, Dell 2850

database server with 1TB of SAN storage

J.M. Huber Corp. Engineered Materials Division - Atlanta, GA (1997 to 2003)

Systems Integration Specialist/Manager/ERP Application Architect

Systems Integration Specialist to Oracle 11i ERP project (January, 2001 to February, 2003)

Responsible for implementation of an ERP system as a Functional and Technical Team Leader, integrating three separate

business units and eliminating four previous systems. The project included a redesign and standardization of all financial,

procure-to-pay and order-to-cash processes. Responsible for integration and data migration from legacy systems to Oracle 11i

applications and Oracle Financials systems using SQL and PL/SQL based tools. In this position, functioned as both a Subject

Matter Expert on the legacy financial systems and participated in coding many Oracle PL/SQL stored procedures to

accomplish data migration efforts. This new Oracle 11i ERP system positioned Huber to operate and grow the business more

effectively and allows for easy integration of future business acquisitions.

Accomplishments:

Year-Over-Year costs in raw material purchases were reduced 5%, distribution cost were reduced 10%.

Year-Over-Year SG&A costs were reduced 5%.

Reduced the number of days of sales outstanding (DSO) by nine days resulting in an incremental cash flow of $12 million.

Reduced number of Credit/Debit memos by 15%.

Identified over $600,000 of duplicate or incorrect freight bills in a single year which were being paid in the past.

Manager-Financial Applications Development and Support (August, 1999 to January, 2001)

Responsible for strategic planning and implementation of global data warehousing projects using web-based reporting and

analysis tools. Hired and managed a team of five systems analysts, developers, and report writers including performance

appraisal and career mentoring. After leading the technical team in the ERP implementation, I began to focus on production

of reporting artifacts to support day-to-day and strategic management decision making, the outgrowth of which turned into a

data warehouse system. Performed managerial and technical architecture duties as the Manager-Financial Applications

Development and Support. Was responsible for the department-level budget and resource allocation. The Kimball-based data

warehouse was constructed using Oracle 8i with PL/SQL based stored procedures performing ETL tasks and Brio Reporting

as a web-based front-end for management reporting. The data warehouse also included an operational data store that held the

three most current year's sales and financial data.

Accomplishments:

Integrated feeds from 14 distinct data sources including three ERP systems to provide global reporting and analysis of

price/volume/mix, variance, gross margin and prior year comparisons.

Data warehousing effort provided J.M. Huber's initial ability to perform global operational analysis by global business

leaders on three continents.

Developed global salesperson assignment and incentive database/application using Microsoft SQL Server 7.0

Operational DBA for Oracle 8i data warehouse serving global community on a 24x7 basis.

ERP System Architect (May, 1997 to August, 1999)

Functional and technical team architect for implementation of the ERP system: Adage. Served as architect for enterprise

system infrastructure including plants, warehouses, products, items, packaging, customers, and accounting systems.

Developed and managed the technical projects plan detailing the project's phased implementation, accounts receivable and

sales order migration. Managed Oracle database infrastructure for Adage ERP system.

Designed and developed interfaces from ERP system to Lawson Payables and General Ledger accounting systems, for

logistics, A/P and A/R transactions using UNIX/SQL. Created custom PL/SQL stored procedures to translate accounting

data from the ERP system's chart of accounts to Lawson's chart of accounts. Also created UNIX scripting to schedule many

ERP accounting processes.

Designed core accounting reports including cash reconciliation, aged trial balance and general ledger analysis. Developed

Oracle database triggers, views, and stored procedures to support reporting, and accounting controls.

Functional and technical liaison between sales and operations to maintain business process consistency per stated

implementation objectives. Developed consolidated revenue and volume reporting operational data store used for

operational analysis using Oracle 8i PL/SQL based stored procedures and views.

Technical Environment: Oracle 11i Applications, Oracle 7.3, Oracle 8.17, SQL*Plus, PL/SQL, AIX, KornShell,

SQL*Navigator, BrioQuery Explorer, BrioQuery Insight, BrioQuery OnDemand Server, BrioQuery Broadcast Server, ERwin,

SCT Adage, CA OpenRoad, Microsoft Access, Microsoft SQL Server 7.0, IQ Report Writer, IBM and EMC array with 1TB

storage

TheraTx, Inc. - Atlanta, GA

1995 to 1997

Senior Software Engineer/Team Lead

Managed functional and technical implementation teams for a web-based distributed PowerBuilder DSS/reporting project

utilizing Sybase stored procedures, PowerBuilder WebPB running on Sun Ultra Sparc 3000/4000 UNIX servers. Oversaw a

300+ site software deployment and system training.

Managed entire life-cycle development of a web-based, star schema design clinical reporting system, which provided

clinical personnel worldwide access to clinical outcome measurements, patient billings, and patient statistics to this $200

million business unit.

Designed and developed the respiratory therapy billing and clinical measures module of the clinical information system,

TheraSys Pro, using Sybase System 11.5 / stored procedures and Macintosh based 4th Dimension.

Designed and coded rewrite of corporate billing system using PowerBuilder 5 and Sybase System 11.5 stored procedures.

Technical Environment: Sybase System 11.5, Sybase Open Client CTLIB, PowerBuilder 5, Embarcadero DB Artisan, Andyne

GQL, 4th Dimension client/server, Powersoft PowerDesigner Data Architect/MetaWorks, KornShell

EDUCATION

Mercer University - Macon, GA

M.B.A., Finance, 1992 - GPA 3.75

Georgia College - Milledgeville, GA

B.A., Management, 1986 - GPA 3.5

TRAINING

Oracle University - San Francisco, CA

Data Warehousing Fundamentals

Data Warehouse Database Design

Oracle Database Administration

Hotsos Clinic Advanced Oracle Performance Diagnosis

Microsoft SQL Server/.NET in-house training, seminars and clinics

Crystal Reports

Hyperion/Brio

IQ/Objects

UNIX/ Shell scripting

Sybase database

Principles of Public Health

SharePoint 2010 Essential Training (Lynda.com)

SharePoint 2013 Essential Training (Lynda.com)

InfoPath 2010 Essential Training (Lynda.com)

SharePoint Designer 2010: Creating Data-Driven Web Pages (Lynda.com)

Microsoft Business Intelligence Stack in Depth (Lynda.com)

Power BI Features In Depth (Lynda.com)

TDWI The Data Warehouse Institute Onsite Training 2011

Data Governance Fundamentals

Master Data Management Fundamentals

Data Quality Fundamentals

Data Modeling Data Analysis and Design for BI and DW Systems

Dimensional Data Modeling Primer

Advanced Dimensional Modeling Techniques for Practitioners with Chris Adamson

SECURITY CLEARANCE

United States Government Secret Clearance Active to 2025

Contact this candidate