Chad Mckee Email & Phone Number

Us

Reston, Va, Us

Information Architect contracted to the United States Department of Agriculture - Risk Management Agency (USDA-RMA) as the Enterprise Data Architect. Introduced Agile Data Warehousing and the Data Vault design pattern to integrate will with their software development methodology and deliver the Agency's first data warehouse.As a member of the Enterprise Architecture Team, defined the technical roadmap using TOGAF. Specifically responsible for defining the current, target and transitional data architectures.Research emerging technologies and design patterns such as data virtualization, Hadoop, and microservices, perform proof-of-concepts and make recommendations for updates to the target state.Review and approve database designs and mentor staff.Review and refine database standards.

Database operations, database development, data architecture, data integration, business intelligence, management.Created and communicated database development, data architecture, and database change management best practices and standards.Lead the effort to document the existing database systems consisting of over 350 entities and 8,000 attributes. Published the ERDs with table/column level descriptions and business definitions to the intranet portal using Embarcadero tools.Created the next-generation transactional data architecture that includes multi-lingual support.Configured and deployed the Reporting Services portal for internal self-service reporting. Created over 30 reports for the business users resulting in a 70% decrease in ad-hoc data requests to IT.Documented all incoming and outgoing data feeds and brought them under the Data Services Team. Created ETL development standards and frameworks and have moved most of those processes into SSIS with full logging and exception reporting.Developed the data warehousing architecture that can scale to multiple terabytes with near real-time, parallel updates while decreasing the ETL development efforts related to transactional schema change by 50%.

Us

Enterprise data architect, data integration, business intelligence, database development, management.Designed and developed our company’s first operational data store to provide near real-time, integrated data to our applications and reporting systems allowing us to offload reporting from the transaction systems. This resulted in a 70% reduction in server load during peak transaction periods and up to a 95% reduction in response time for several reports.Created HNTB’s first cube using Microsoft SQL Server Analysis Services in order to give power-users the ability to perform ad-hoc analytics.HNTB Lead for the Microsoft Technology Assistance Program during which we worked with Microsoft’s engineers and developers to create a complete BI solution using all of the latest products in Microsoft’s Business Intelligence stack.Implemented “Business Dimensional Modeling” to enable the business and technical teams to communicate effectively about business entities, hierarchies and entity interaction/relationships.As the primary technical resource, implemented Oracle Business Intelligence 10g (Enterprise Edition).Architected and created WCF web data services using C# which enables developers across the company to access integrated, enterprise data for their applications.Implemented the standards and procedures for creating External Content Types (Business Connectivity Services) to consume data services and expose enterprise data to Sharepoint and Microsoft Office applications.Created and implemented the standards and procedures for developing ETL using SQL Server Integration Services (SSIS).Created template SSIS packages that incorporates standardized logging and exception processing and implements dynamic configurations so that packages can be moved from environment to environment without manual modification.

Nashville, Tennessee, Us

Plan and prioritize DBA resource allocation and clearly communicate schedules with project managers, production support personnel and upper-management.Reorganized the 10-person DBA team from client-specific roles to specialty-specific roles (i.e. Development, Administration, Database Development, Data Quality) resulting in increased project throughput from 2004 .Manage and maintain production and test SQL Server database servers.Responsible for creating and enforcing database change control, table/column/stored procedure naming conventions, and best practices.Design and implement the enterprise data warehousing architecture.Introduced ERwin and Model Manager for data architecture, schema versioning and documentation resulting in increased change control and greater understanding of the data structures within the 70+ IT employees.Relational and dimensional data design using ERwin.Code complex stored procedures and triggers using TSQL.Instituted database storage capacity trending and planning.Performed optimization and tuning on our company’s largest database resulting in a reduction of the average CPU utilization of 60% and average memory paging by 50%.Converted over 200 ETL jobs from a combination of DTS, stored procedures and programs to a consolidated data integration platform (IBM-Ascential DataStage).

Administered Oracle 8i/9i, Informix 7.x/9.x and SQL Server 2000 databases in AIX and Windows environments.Installed and configured Oracle 9i on AIX including spatial components.Performed data and stored procedure conversions between Informix and Oracle, and between Informix and SQL Server 2000.Wrote data extraction transform and load routines using a combination of DTS, SQL Loader, Perl, Javascript and/or VBScript.Completed data design and documentation using tools such as ERwin and Visio.Wrote complex queries and stored procedures for Oracle, Informix and SQL Server databasesEngineered software that utilizes statistical analysis to derive market value for residential properties from comparable sales data.Developed software utilities that span multiple database platforms to provide IT departments with schema documentation and definitions as well as allowing clients to automatically update database configurations.

St. Louis, Mo, Us

Short internship while I finished school after leaving the Navy

Washington, Dc, Us

Tomahawk, Harpoon, NATO Seasparrow, TAS.USS Nicholson (DD982) - 1992-1997NAS Jacksonville - 1997 - 2000