Database Architect Data Warehouse

Anthony C. Checco

***** ********* ****** 303-***-****

Highlands Ranch, CO 80130 ****.******@*.***

Summary

Database architect/modeler/developer with twenty-five years of experience in designing and managing complex projects across various industries including manufacturing, mortgage, engineering, accounting, and biological software.

Employed in large and mid-size companies, state and local government, and non-profit organizations.

Seeking an Agile/Lean development environment to develop well performing, long-lived solutions that are easy, intuitive, and automated for the data consumer.

Employment History

Oldcastle Infrastructure September 2022 – April 2025

Senior Database Architect Full-time, permanent

Coordinated data integration for 2-4 simultaneous company acquisitions at a time, ensuring seamless transitions from the source ERP to the central Snowflake data warehouse.

Developed complex SAP queries for project tracking, sales, and labor analysis.

Led data dictionary project, improving metadata clarity in SQLDBM models.

Facilitated weekly review board, ensuring documented DDL changes in data warehouse.

Designed and implemented a unified reporting structure for management, enhancing data accessibility and driving informed decision-making across departments.

Led the integration of diverse ERP systems into Snowflake, achieving seamless data flow and reducing reporting discrepancies during acquisitions.

Coordinated efforts among engineers and architects to prioritize data mapping tasks, ensuring timely integration of multiple acquisitions with minimal disruption.

Spearheaded the migration of legacy systems to a unified Snowflake architecture, ensuring robust data integrity and streamlined reporting processes

Evolve Mortgage Services April 2018 – August 2022

Senior Database Architect Full-time, permanent

Led strategy to modernize databases, enhancing compliance and performance.

Designed and developed loan grading systems, achieving accreditation from top rating agencies.

Managed ETL processes, improving data reporting efficiency.

Directed a team of four, ensuring data integrity and security.

Collaborated with stakeholders to optimize data import/export processes.

Spearheaded the refactoring of critical databases, achieving compliance with ANSI standards and significantly enhancing data reliability and accessibility.

Designed and implemented a loan grading process, securing Standard & Poor's accreditation and improving trust in our financial products.

Orchestrated design meetings with cross-functional teams, fostering collaboration that led to the successful integration of diverse data sources.

Directed database modernization initiatives, resulting in enhanced compliance and improved system

Willis Towers Watson April 2016 – March 2018

Senior Database Architect Full-time, contract

Document current database structure for future development needs and to identify areas of improvement.

Create data import jobs to automate and streamline existing manual or semi-automated processes. Added more sophisticated error trapping and reporting.

Meet with business subject matter experts and product owners to translate the business strategies into concrete data and reporting requirements.

Determine and draw logical diagrams of the business relationships in the data and write the physical database structures in coordination with the software team.

Streamline language translation data used for globally distributed software. Every element of the application needed to be able to support ten or more languages.

Design flexible database structures for the executive compensation software to allow for multiple disparate regional data to be efficiently and accurately stored for reporting.

Reed Group January 2015 – April 2016

Database Architect / Manager Full-time, permanent

Enterprise Data Warehouse (EDW) work, including design for extending the structure, upgrading the process for better efficiency, training end users of the EDW, maintain design documents and data dictionaries.

Maintain and upgrade the ETL projects to load the data warehouse.

Create reports and data feeds for clients, including writing complex SQL code.

Import data via Amazon S3 services, Oracle, and Azure databases.

Maintain and monitor SQL Agent jobs for internal and external clients.

Work and coordinate with a wide array of groups within the organization.

Managing and upgrading the internal QA Audit Tool for the Call Center.

Started the automated testing council to research and recommend a roadmap for implementing an automated testing strategy.

Manage two database developers and provide training and mentoring.

Weyerhaeuser May 2005 – April 2010, March 2012 – December 2014

Database Architect/Modeler/Developer Full-time, permanent

Led a team in designing centralized databases, enhancing data integrity and access efficiency.

Streamlined ETL processes, improving data transfer speed and accuracy across systems.

Coordinated database resources for four applications, boosting project delivery timelines.

Managed daily Agile scrums, optimizing team collaboration and task completion.

Redesigned legacy databases, resolving performance issues and ensuring data integrity.

Analyzed user feature requests, translating them into actionable tasks, optimizing workflows and accelerating project completion.

Coordinated with software architects to ensure seamless database interactions, fostering a unified approach to application development.

Developed and maintained ETL processes, enabling efficient data migration to data marts and supporting timely decision making.

Facilitated daily scrum meetings, promoting agile methodologies and enhancing team collaboration for project success.

Led a team of four in database development, enhancing system efficiency and data integrity.

Coordinated resources for four customer applications, optimizing database interactions.

Streamlined ETL processes, ensuring accurate data transfer to data marts.

Redesigned legacy databases, resolving performance and integrity issues.

Facilitated Agile practices, improving project delivery and team collaboration.

Analyzed and streamlined database design, leading to substantial improvements in customer experience and enhanced data accessibility.

Managed a team of four in developing centralized databases, achieving marked gains in data integrity and operational efficiency.

Coordinated with software architects to optimize database interactions, fostering teamwork and improving project outcomes.

Designed and maintained ETL processes, ensuring accurate data transfer and supporting robust reporting capabilities.

Led daily scrum meetings, promoting agile practices and enhancing team communication to meet project deadlines.

Technical Skills

Create long-term architectural plans, roadmaps, and vision documents for greenfield and existing applications, coordinating with business management to meet strategic and tactical goals

Snowflake, SQLDBM, Python, SQL Server, Oracle, MySQL, SSIS

Knowledge of backend structures for ERP systems: JD Edwards, Microsoft Dynamics NAV, Microsoft Dynamics AX, Netsuite, SYSPRO and SAP

Manage development teams and provide technical training

Agile team leader, employing Lean, Scrum and Kanban

Visual Studio and C#

Design Patterns, Test Driven Design, Object Oriented design and programming

AWS services with S3

Education

Bachelor of Arts in Mathematics

Williams College, Williamstown, MA

Personal

1st Degree Black Belt and previous Instructor, American Taekwondo Association

Hobbies include hiking, photography, cooking, and artisanal sausage making

Contact this candidate