SUMMARY

• Experienced leader and Data Warehouse Architect / Big Data Architect / Project Manager with over 20 years of experience in Enterprise Data Warehousing and Business Intelligence / Analytics. Excellent communicator with strong business acumen and significant hands - on and leadership experience - both strategic and tactical. Experience includes employment with Fortune 500 companies and business consulting services.
• Whether you are looking to implement a new solution or modernize an existing Data Warehouse or Big Data solution, for the last 20 years I have made it my business to help organizations implement modern solutions and avoid costly rework and missed opportunities.
• Investing in Data Warehousing and Analytics is an expensive undertaking and has significant risks without a well structured program and well defined roadmap. This is even more important today with ever increasing database options and my experience can help you deliver an advanced architecture that will meet your business needs well into the future.
• Business Intelligence Solutions, Data Warehousing Solutions, Big Data, Analytics, Data Virtualization, Data Quality Solutions, Data Integration Solutions, Financial Management Solutions, Customer Relationship Management Solutions, Data Governance, BI Governance, Systems Integration, Government Program Administration, Corporate & Operations Strategy, Project Office, Quality Process Leadership, Business Process Re-Engineering and Application Development.

PROFESSIONAL EXPERIENCE

Data Warehouse Architect/Big Data Architect/Solution Architect

Confidential

Responsibilities:

• Provided technical direction and support for t he DP OPS and iPaaS (App Support) programs including a number of data warehouse and reporting applications as-well-as a diverse set of COTS applications for Confidential ’s SDD IT department. Support environment includes Informatica, DB2, Oracle, Business Objects, Oracle EBS, and a number of medical systems.
• Responsible for researching and architecting a Big Data and Cloud solution to store Electronic Health Care Data. The proposed solution brings together advanced Big Data and In- Memory data base technology to manage petabytes of data for Confidential ’s Legacy D ata Repository (LDR.)
• Databases and cloud solutions evaluated included Cloudera, Hortonworks, Databricks, Spark, MemSQL, Exasol, Teradata, DB2, Oracle, SQL Server, Elasticsearch, MongoDB, CouchDB, Azure, AWS, MilCloud, etc. Confidential ’s EHR and EMR health systems are being modernized and include requirements for a Data Lake and on-demand access to data for clinical, legal and analytical needs. Users required SAS, R and SQL for Analytics.
• Department of Justice ( Confidential ) in establishing a Financial Data Warehouse. This role was a hands on role with both WebFocus and Oracle 12c, including the full SDLC (Requirements, Source Analysis
• Dependent Data Mart Design, Source to Target Mapping, Database Construction, Report Design and Report Build.)
• Provided enterprise architecture support for M&T Bank’s Customer 360 Initiative. The Data Warehouse architecture brought together today's best practices and technology with a Data Lake and way forward utilizing a Big Data Architecture for the Enterprise Data Warehouse. The Customer 360 program included implementation of and Enterprise Party Hub (Informatica MDM), a full Cloudera Hadoop implementation
• This included end-to-end performance testing with Informatica for sourcing data into the Hadoop and a Teradata Data Warehouse. The program also included Tableau for Business Intelligence and SAS for Campaign Management and Marketing.

Confidential

Enterprise Data Architect/Data Warehouse Architect

Responsibilities:

• Provide d leadership for the data management team at the enterprise level as well as specific projects and programs. He lead a team of both onshore and offshore data modelers and supported a number of data migration and data warehouse projects.
• He led the implementation and configuration of the FISERV InformEnt data warehouse. He has supported numerous requirements utilizing an agile approach for enhancing OneMain’s primary loan transaction processing system.
• Directly involved in developing solution designs for both enterprise application integration and data warehouse solutions.
• He was responsible for data management standards such as data governance, data warehousing, data modeling, ETL, metadata management, etc. He is responsible for architecting, developing standards and supporting the implementation of Big Data and NoSql solutions, including Green Plums MPP database, Hadoop and MongoDB.

Data Warehouse Architect/Bigb Data Architect/Strategy Development

Confidential

Responsibilities:

• Worked with a team of senior architects and DoD clinicians and personnel to evaluate key systems and data repositories for the DoD’s Military Health Systems (MHS.) MHS is one of the largest health care providers in the world and includes the TRICARE program. They also maintain the largest database (EHR) on Oracle at 400 TB. The team was responsible for providing a comprehensive analysis of the MHS application interfaces (AHLTA, CHCS, TMDS, Essentris) and databases and focused on optimizing the use and flow of information through the systems from beginning to end.
• The work involved a comprehensive analysis of MHS’s numerous data repositories (CDR, CHCS, Essentris, Medical Data Reposito ry (MDR), M2, Health Service Data Warehouse (HSDW) and TMDS ); resulting in a plan detailing how to address current challenges.
• Analysis and recommendations included governance and the use of advanced Massively Parallel Processing (MPP) Data Warehouse, Big Data, NoSQL and Data Virtualization technologies. The team was responsible for evaluating a broad range of new database technologies and solutions to develop the to-be architecture for MHS data and information flow.
• Developed a comprehensive BI Strategy and BI reference architecture for the Confidential and worked with Confidential ’s leaders on planning and requirements.Provided leadership on the implementation of SharePoint as a DoD Enterprise Service, including the evaluation and role of SharePoint Business Intelligence capabilities that enable integration of BI solutions within SharePoint.
• Under a separate engagement lead the reverse engineering of Confidential ’s Revenue and Ridership Data Warehouse (RRDW).lead the data profiling, data modeling and development of 33 ETL Mapping Specifications for 12 data sources that required reverse engineering hundreds of separate UNIX, SQL, C and awk components. The RRDW had evolved over 10 to 15 years and included more than 200 tables.

Program Manager/Data Management

Confidential

Responsibilities:

• Baltimore Office, Business Development and Program Management. Task Order ( Confidential DBA IDIQ.). The Confidential Central Data Administration (CDA) Team works within the Confidential Enterprise Databases Group (EDG) and provides strategic direction, data administration support services, and governance across the Confidential enterprise
• The team's primary responsibility included enterprise data administration support as-well-as logical and physical data modeling for Confidential applications, including the Confidential Integrated Data Repository (Teradata Data Warehouse.) Responsibilities under the Confidential CDA Task Order included: Enterprise Data Administration Services
• Enterprise Data Group (EDG) Tool Support, Data Administration Standards, Data Model Management, Business Intelligence, Data Warehousing and ETL, Messaging, Data Governance, Metadata Management, Master Data Management, Enterprise Content Management and Enterprise Architecture.
• The Confidential Central Data Administration team won Confidential ’s annual team award for outstanding customer service in 2008 and the team received superior customer survey results from the client. Business development responsibilities included tracking opportunities, building teaming relationships and proposal development in order to grow Confidential in Maryland’s North/East Corridor.

Deputy Program Manager/Business Intelligence

Confidential

Responsibilities:

• The strategic direction and leading the Office of Confidential 's Business Intelligence (BI) Program. team has received multiple awards and recognition from the command and admiral for successfully delivering Business Intelligence and Data Governance to Confidential . The program succeeded where others had failed and provided Confidential with reliable metrics and the single-version-of-the-truth needed to manage end-to-end operations across departments. The Enterprise Data Warehouse and BI solution provided an architecture and approach with needed flexibility to support Confidential ’s business of Procuring Science and Technology in a changing environment.

Data Warehouse Architect/Managing Consultant/Project Manager

Confidential

Responsibilities:

Leading and managing Business Intelligence (BI), Data Warehouse, and Customer Relationship Management (CRM) initiatives, including large technical infrastructure implementations. Responsibilities included project management, proposal development, data architecture & data modeling, data warehouse & BI solutions architecture, data governance & data quality reporting, metadata strategies, and hands-on data analysis and mapping. Projects included requirements in Basel II Credit Risk Management and Customer Data Integration with clients in Insurance, Banking, Retail, and Investment/Finance.

Data Warehouse Architect/Project Manager

Confidential

Responsibilities:

• Extensive BI, data warehouse, project management and hands on experience. provided his clients expertise in data warehousing, business intelligence, analytics, data mart integration, and program/project management. Co-Authored: "Quality Assurance in Data Warehousing"

Confidential

Data Warehouse Architect

Responsibilities:

• Establishing world-class data warehouse architecture and managing activities from evaluation and design to implementation and migration to the new Enterprise Data Warehouse (EDW). The initial application ROI was $6.2 million annually and was a key business initiative toward continued double-digit business growth and maintaining a competitive advantage.

Confidential

Data Warehouse Architect/Business Intelligence Lead/Project Manager

Responsibilities:

• leading the implementation of a massively parallel (MPP) data warehouse environment and the use of leading-edge technologies for reporting and analytics. Solutions included Marketing and key-performance-indicators (KPIs) for tracking Charge Card transaction processing.

Confidential

Project Manager/Lead Programmer Analyst

Responsibilities:

• leading decision support projects involving RDBMS (DB2) and Multi-Dimensional Database (MDDB) technology. He led a Rapid Application Development (RAD) team in establishing the first On-line Analytical Processing (OLAP) application in the insurance industry. Solutions provided over 500 executives, managers and analysts with consistent information needed to successfully manage a large P&C Insurance Company and increase the company’s stock price nearly 400% over 5 years. He was actively involved as a conference speaker as an early adopter and supporter of OLAP technology.