Responsible for program direction, oversight and overall contract P&L for CMCS MACBIS development effort. Overseeing the agile development of both MACPro and T-MSIS systems on the AWS cloud, implementing business process re-engineering and big data processing services through a combination of devops-based best practices and cloud-scale data architectures and tools.

Managing Director of T-MSIS and Analytics Warehouse task orders. During initial transition in phase, responsible for JOA and Transition Plan to complete transfer of T-MSIS Operational Data Store and Warehouse. Currently engaged in staffing and ramping up a forty-member technical team.

CMS IDR Project – Data Acquisition ServicesMr. Maxwell offers 20 years of experience and is currently responsible for oversight and coordination of the data warehouse/business intelligence group. He is accountable for all data warehouse systems to ensure that all business objectives are met. Demonstrates advanced, technical knowledge and ability to multitask and coordinate across all levels of the development life cycle. Mr. Maxwell is an expert in a majority of the field’s technical concepts, practices and procedures to include Teradata, Informatica, and Microstrategy with transferable skills and demonstrated experience in Teradata SQL and performance tuning. He relies on extensive experience and judgment to plan and accomplish goals. Mr. Maxwell leads and directs the work of others demonstrating a wide degree of creativity and latitude. Reports to top management. Performs a variety of leadership and program delivery tasks to include:• Bid support;• Requirements analysis and management;• LOE;• Staffing;• Functional Specification design;• Development and delivery of quality-tested software; and• Maintenance and support.

Responsible for system architecture and technical design of ETL processes to load Medicare claims (Parts A & B). Led a team of six technical specialists across all phases of design, development and deployment of best-of-breed (Informatica/Teradata) technology, loading six terabytes of claim history data into an industry first Integrated Data Model.• Designed best-of-breed ETL architecture using Informatica pushdown technology (8.1.5) with Teradata. Oversaw the development and deployment of an end-to-end Informatica ETL solution which enjoys the benefits of Teradata scalability and Informatica metadata and speed of deployment;• Designed Informatica workflows and pushdown mapping logic, partitioned transformation logic between Powerexchange/PowerCenter/Teradata pushdown;• Loaded Part A and Part B claims from 2006 forward; and• Tuned and optimized database configuration and application SQL.

Responsible for system architecture and technical design of ETL processes to load Medicare claims (Part D). Led a team of eight developers using Teradata/Informatica/Cognos tools in all aspects of data warehouse design and development – extract, transform and load processes, aggregate design, virtual data mart design, reporting and data extract development, performance tuning.• Determined business requirements, decided technical requirements, designed and developed system architecture and ETL processes;• Loaded Part D claims to Staging using Teradata MLOAD, FLOAD. Transformed in Staging using BTEQ and SQL transformations;• Tuned and optimized database configuration and application SQL; and• End to end technical responsibility for the entire ETL and BI systems.

Led a team of three ETL developers and two report developers, implementing a warehouse of mail processing operational transactions with a diverse and complex cross-organization set of subject areas to include Retail POS, General Ledger, Financials, facilities, Supply Chain Management, Human Resources, Fleet Maintenance, and numerous logistical “moving the mail” subjects such as Product Tracking, Network Operations, and Delivery.• Designed the ETL process to use Fastload, BTEQ, Unix shell scripts;• Maintained and tuned Teradata Production and Development systems;• Managed SQL query optimization (explain plans, collect statistics, Primary and Secondary indexes, temporary tables, join indexes); and• Created FastLoad, FastExport, MultiLoad, BTEQ scripts for ETL.

Responsible for development of ETL processes using Teradata utilities and Unix shell scripting. • Loaded 100 Node, multi-terabyte system with retail transaction data on a nightly batch cycle.• Gathered, documented, and analyzed user requirements for the Retail Data Mart;• Designed ETL system, including Process specifications, Source to Target mappings, and development of Teradata BTEQ scripts, views, stored procedures;• Performance tuned ETL Batch jobs, Reporting and Ad-hoc SQL; and• Designed and built complex aggregates with delta change updates across rollup, OLAP, and complex custom attribute logic.