Jay Quincy Allen
www.linkedin.com/in/jayquincyallen
North Potomac, MD
adnbd4@r.postjobfree.com
Database Architecture and Engineering Manager
Engaged leader and manager of database and software engineers. Skilled in relational and dimensional database modeling, data warehousing architectures, master data management and data governance. Experienced software and database architect of enterprise class systems focusing on availability, cost of ownership, compatibility, scalability, performance, and security. Evangelist for a top-down (Inmon) architecture in master data management and multi-source system data warehousing environments.
Professional Experience
ICF (Arlington, VA) October 2019-March 2021
Data Architect
As Data Architect, participate as a member of the Digital Service Center (DSC) team for the NCI and the Technology & Architecture Group (TAG) for ITG. The DSC forms the enterprise architecture group, implementing the enterprise architecture reference traditional model framework of TOGAF (the Open Group Architecture Framework).
Centric Consulting (Cincinnati, OH) 2019
Data Architect
Develop and extend data warehousing environments using an anchor modeling framework. Provide recommendations for improving performance and lowering cost of ownership within the data warehousing landscape.
Datamyx, a Deluxe Company (Boca Raton, FL) 2016 – 2018
Manager of Data Engineering
Manage team of four data engineers developing databases and ETL processes using Microsoft SQL Server 2012-2017, SSIS, and C#
Advance and monitor professional development plans for data engineers.
Promote Agile methodologies and ceremonies.
Evangelist for best practices in data governance, database, and ETL development
Manage data ecosystem that processed over 20TB of consumer marketing data monthly.
Develop and implement plans for the elimination of technical debt.
Implement and promote standards for development, including best practices for naming conventions, code formatting, database, and ETL architecture.
CSL (Boca Raton, FL) 2014 –2016
Data Architect
Data architecture, modeling and engineering for master data management and a global enterprise data warehouse
Architecture: Top-Down
Develop operational data store for master data management and enterprise data warehousing.
oData modeling with ER/Studio
oPhysical Data warehouse implementation on Oracle 12c
Research and provide recommendations for enterprise data management and decision support systems.
ETL development with SAP Data Services and custom replication using Oracle Golden Gate.
Coordinate the activities of the data governance group.
Adama Systems (Miami Beach, FL) 2009 –2014
Owner/Managing Partner
Boutique software and database development firm specializing in master data management, data warehousing, application development, and EDI implementations.
Manage software developers working on applications developed with ASP. Net, C#, and SQL Server.
Provide recommendations on the selection and configuration of appropriate hardware, storage, and related software systems.
Direct the analysis, modeling, design, and physical implementation of enterprise OLTP applications. EDI systems, master data management solutions and data warehouses
Project manager and lead for client’s data governance teams
Promote the development of corporate information factory (Inmon) architecture for master data management and data warehousing.
Develop logical and physical data models, ETL scripts, metadata definitions, and programmability of database systems and developed data warehousing ecosystems using Microsoft SQL Server, Integration Services, and Analysis Services.
Clarium Management Group (Fort Lauderdale, FL) 2009
Manager of Applications and Database Development
Managed software and database developers working on applications developed with ASP. Net, C# and SQL Server
Provide leadership for software and database architecture on projects related to CRM, ERP, HRMS, Logistics, Finance, and Accounting
Conduct data capacity planning, life cycle, duration, usage requirements, and feasibility studies.
Collaborate with project managers and business unit leaders for all projects involving enterprise data.
Assess and determine governance, stewardship, and frameworks for managing data across the customer’s organization.
Develop and promote data management methodologies and standards.
Stratapult (Winston Salem, NC) 2008 –2009
Data Architect
Responsible for conceptual, logical, and physical modeling of data warehouses using dimensional modeling techniques.
Manage up to four contracted developers, perform code reviews, supervise database and ETL architecture.
Design and develop T-SQL procedures and SSIS packages for ETL processes exchanging data with Informix and AS400/DB2
Health Benefits Direct (Deerfield Beach, FL) 2006 –2008
Systems Architect
Senior systems architect for the development of a suite of applications serving the workflow of insurance agents, including quoting, lead data processing, sales and customer relationship management.
Manage database administrators, software and database developers.
Perform code reviews and provide mentoring on database and application architecture.
Access Diabetic Supply (Deerfield Beach, FL) 2005 –2006
Enterprise Systems Architect
Develop long-term strategic goals for enterprise data architecture vision and standards in conjunction with data users, department managers, clients, and other key stakeholders.
Manage database and systems administrators.
Tropical Shipping (Riviera Beach, FL) 2003 - 2004
Database Administrator
Perform analysis of logical and physical data models, index tuning, analysis of stored procedures and recommendations for performance enhancements.
Design and develop a business continuity and recovery plan utilizing transaction log shipping.
Self-Employed Full Time Independent Contractor and/or Consultant 2001 – 2005
Software and database architect, developer, and consultant for applications development, data warehousing, and master data management for clients such as:
IVAX Advanced Test Products Boundless Manufacturing
PMG Securities Pediatrix Medical Web Services
Citrix Car Spa, Inc. Broward County Sheriff’s Office/17th Judicial Circuit Court
Car Spa 2000 – 2001
Software Developer
Maxim Group 1997 – 2000
Software Developer
Software and database architect, developer, and consultant for applications development, data warehousing, and master data management for clients such as:
American Express Caterpillar Finance Corporation
Bellsouth Business Systems Bosch Automotive Motor Systems
Columbia/HCA Fruit of the Loom
Georgia Department of Transportation 1986 – 1996
Various Roles
Education and Leadership
Georgia State University - Bachelor of Arts, Philosophy of Science
Served in public relations for the State Olympic Law Enforcement Command (Atlanta, GA)