Roy Mitchell
Harper,TX
Summary
Senior Information Architect with expertise leveraging data architecture, data warehouse, and solution architect technologies to solve retail, financial, and customer demographic business problems. All contractor positions were short term less than 12 months for specific projects and roles in some cases called in to complete a project due to the previous contractor's inability.
Experienced with project management, overseeing various construction phases from initiation to completion. Utilizes strong organizational skills to ensure project timelines and budgets are met. Track record of effective communication and collaboration with team members and stakeholders.
Overview
27
27
years of professional experience
1
1
Certification
Work History
Contractor - Senior Data Modeler / Data Architect
Ascension (Bank)
Harper, Texas
09.2024 - 05.2025
- Online Transactional Bank General Ledger Model using VISIO for data model representation
- Modeled several data models for legacy reengineering project
- Analyzed and designed party model from legacy data
- Designed Master Data Dictionary format to prepare bank model conversions
- Modeled legacy conversion table structures supporting conversion to new General Ledger (SQL Server)
Contractor - Senior Data Modeler / Data Architect
APEX SYSTEMS (United Natural Foods Inc.)
11.2023 - 04.2024
- Dimensional Model for retail distribution data using Erwin for data modeling
- Analyzed and designed party model from legacy data
- Data Quality profiling and Data Lineage to comply with Data Governance guidelines
- Designed Master Data Dictionary format to prepare Grocery model conversions
- Modeled SAP conversion table structures supporting conversion from 5 different accounting systems (Data Bricks)
- Assist other duties and tasks as needed for model conversions
- Managed multiple projects simultaneously while maintaining strict adherence to deadlines and budgets.
- Coordinated timely delivery of materials and resources to job sites, preventing delays in project timelines.
- Consulted with customers to assess needs and propose optimal solutions.
- Established long-term relationships with clients, resulting in increased repeat business.
- Implemented changes requested by designers, owners, or inspectors to conform to specifications or updated demands.
Senior Data Modeler / Data Architect
Vistra Corporation
05.2022 - 07.2023
- Installed and configured Erwin for data modeling
- Installed, configured, and curated Alation Data Catalog on AWS for Data Governance
- Produced training sessions for Catalog users: Administrators, Stewards, and Analysts
- Designed Sensitive personal information (SPI) interface in Data Catalog (Alation)
- Documented and established Data Architecture standards
- Documented modeling standards for Review Board
- Participated in Architectural Review Boards and Disaster Recovery Review Board
Contractor - Senior Data Modeler / Data Architect
Judge Group
10.2021 - 03.2022
- Review current systems for enhancement
- Design road maps for current and target state
- Data lineage maps to trace SOR to all provisioning repositories
- Develop new Design based on requirements vetted by stakeholders for Snowflake environment
- Review database design and improvements (Erwin) – Dimensional Data Modeling
- Propose data solutions and architectural techniques based on Agile methods
Contractor - Senior Data Modeler / Data Architect
Apex Systems
03.2021 - 10.2021
- Review and modify models created by architects
- Design Fact and Dimension tables for financial services
- Review database design and improvements (Erwin) – Data Modeling
- Review processes and propose improvements: Database Design Snowflake
- Propose data solutions and architectural techniques based on Agile methods
Contractor - Senior Data Modeler / Data Architect
Judge Group
06.2020 - 02.2021
- Reverse engineer physical models to modify existing schemas and create logical models
- Review and modify Azure models created by developers
- Review database design and improvements (Erwin) – Data Modeling
- Review AWS processes and propose improvements: Cloud, Micro Services, Database Design
- Data Governance: review lineages, validate documentation, and assist stewards
- Gather data requirements for analytical and transactional ODS
- Propose data solutions and architectural methods
Application Development – Senior Data Modeler
Bank of America
09.2017 - 03.2020
- Impact Analysis to incorporate data into ODS (Oracle)
- Review Python code to document processes
- Generate ETL Specs for SQL deployment
- Review database design and improvements (ER/STUDIO) – Data Modeling
- Analyze ETL specs for Big Data conversion
- Performed SQL Server 2016 new feature analysis and recommend feature adoptions
- Reverse engineered physical models to modify existing schemas
Contractor - Senior Data Modeler
Signature
05.2017 - 09.2017
- Impact Analysis to incorporate Mortgage data into ODS (Oracle)
- Create ETL Specs
- Conduct requirement gathering sessions
- Review database design and improvements – Data Modeling
Senior Data Modeler / Data Architect
General Motors Financial
08.2015 - 05.2017
- Lead lease originations data architect data warehouse implementation
- Analyze data requirements and gaps for Originations Data Warehouse (Oracle, ER/STUDIO, and Erwin)
- Create ETL Specs for Informatica Mapping documents
- Produce physical data model and logical data model (ERD, Data Vault, Dimensional)
- Conduct requirement gathering sessions
- Assist OLTP design, modify data warehouse for new origination application
Senior Data Modeler / Data Architect
Cognizant Technology Solutions
09.2014 - 08.2015
- Analyze data requirements and gaps for Enterprise Data Warehouse Teradata 13 and Erwin
- Finalize Fact and Dimension Mapping documents
- Dimensional Data Modeling and Design physical data model, and improve logical data model
- Improve data architecture, roadmaps, and guidelines
- Hadoop consultant training
Data Architect and Modeler at Bank of America
Contractor
10.2012 - 01.2014
- Analyze data requirements and gaps for Star Schema and ODS using Sql Server 2008R2 and Power Designer
- Data Modeled telephony Star Schema and ERD (Erwin).
- ETL and data integration design using SSIS packages
- Data analysis using SQL and other methods
- Improve data architecture, roadmaps, and guidelines
Senior Data Warehouse Architect
Electronic Transaction Systems
05.2012 - 10.2012
- Analyze data requirements and gaps for Operational Data Store in Oracle using ER/Studio
Information Architect at First Tennessee
Independent contractor
01.2012 - 05.2012
- Analyze data requirements and gaps for Operational Data Store in DB2 using Erwin and ER/Studio
- Design logical data model for Credit Card data sources using Erwin
- Re-design physical data model for ODS using Erwin for DB2 database
- Gap and data analysis for several account related requirements using the above models
- Logical and physical modeling components of the BDW (Oracle)
Data Modeler/Architect Contractor at Waste Management
Manpower
04.2011 - 12.2011
- Analyze data requirements and gaps for Customer/Reporting Data Warehouse using ER/Studio PostgreSQL
- Develop LDM/PDM Operations Data Warehouse (ERD) in 3NF and Data Mart (Star Schema) with ER Studio - Netezza
- Coordinate data integration and migration to facilitate Data Warehouse re-platform
- Develop mapping documents, SQL, Stored Procedures, and Packages for ETL and reporting
- Assist BI development on Microstrategy during report analysis and creation
Lead Data Modeler/Architect Contractor at Capital One
Pyramid Consulting
08.2010 - 04.2011
- Analyze data requirements for financial Data Warehouse ER/Studio and Erwin - Teradata
- Coordinated Enterprise Data Model and standards convergence
- Review Architecture and recommend alternative model methods, data integration, and architectures – Oracle to Teradata
- Coordinate Data Model activities with Business, ETL, and BI groups
- Migrated data structures from Oracle and SQL Server to Teradata
- Mentored MDM Strategies: Data Provisioning, System of Record, and Reference Data
Data Architect/ Senior Data Modeler Contractor at Bank of America
Zero Chaos
07.2009 - 08.2010
- Financial Data Analysis to determine data variance and quality for data mart (Sql Server)
- Designed Work Effort data structures for Sql Server OLAP data mart (SQL Server)
- Designed logical/physical models in PowerDesigner, designed database on Sql Server
- Designed physical Star Schema model for BI reporting (conformed and non-conformed dimensions with some snowflakes)
- Migrated data structures from SQL Server to Oracle
Data Architect/ Senior Data Modeler
Foot Comfort
05.2004 - 04.2009
- Specialty Foot Comfort ceased operations
- Designed expense tracking system and analytical reporting allowing next day reports.
- Implemented Retail Shoe Physical Data Model from the Logical Data Model in Erwin.
- Designed Teradata database for analytics for expense, inventory, and product data.
- Designed inventory tracking system saving $52K on special orders.
- Developed and maintained data dictionary and used Erwin to create data model.
- Designed and implemented Teradata data mart for budget and performance reporting.
Database Manager / Senior Data Modeler
First American (Formerly Transamerica Real Estate Tax Service)
04.2001 - 05.2004
- Largest tax service in nation merged into First American
- Established standards and guidelines for data warehouse design and Sql.
- Improved ETL process by coordinating Informatica developer and architects.
- Re-organized departmental functions: rapid response and operational methodologies.
- Runtime improvement reduced direct costs, through better query management and efficiency.
- Conducted data warehouse design reviews and adopted better query analysis techniques.
- Increased AS400 Data Warehouse runtime with better index structures. (DB2)
- Created Tax Service Data Dictionary and Logical Data Model with ERWIN.
Data Warehouse Solution Architect / Data Modeler
Fujitsu-ICL
01.2000 - 04.2001
- E-Commerce division phased out with collapse of Internet Providers
- Created Logical Data Model and Physical Data Model for data warehouse with ERWIN.
- Developed and implemented data integration plan for SYBASE upgrade.
- Designed SqlServer and Oracle Logical and Physical Data Models.
- Database architect for Star schema data mart (ORACLE and SYBASE).
- Data modeled and SYBASE DB for Fujitsu web-based system.
- Lead Database team of three people for a database web project for Print and Graphic services.
Data Warehouse Architect/ Data Modeler
NCR
06.1998 - 01.2000
- Financial and Retail largest data warehouses
- Three financial projects: Warehouse design, data mapping, and extraction.
- Produced end-to-end architecture mapping/design covering multiple business units.
- Teradata Database Administrator for supporting financial data warehouses.
- Collected data sources and business requirements to facilitate a Banking Data Warehouse.
- Developed Cognos cubes for Marketing and Loan Analysis Data Marts.
- Created Data Dictionary with ERWIN to facilitate the Logical Data Model.
Education
Bachelor of Science (BS) - Mathematics
Valdosta State College
Valdosta, Ga06.1970
Master of Science Management (MSM) - Public Administration
Florida International University
Miami, Fl12.1976
Skills
- UNIX
- ORACLE
- TERADATA
- ERWIN
- AZURE
- PostgreSQL
- SQL SERVER
- DATA BRICKS
- ER/STUDIO
- AWS
- DB2
- SNOWFLAKE
- Power Designer
- Problem-solving
- Attention to detail
- Time management
- Customer service
Certification
Microsoft, Oracle 9i, Oracle 10G and Linux certifications
Accomplishments
- Developed and implemented enterprise data governance standards, policies, and guidelines.
- Coordinate activities between business and technology for hundreds of projects.
- Cloud processes modified to conform to best practices.
- Multi-database architectural implementations (Oracle, DB2, Teradata, SQL Server, Netezza, Snowflake, Data Bricks)
- Implemented Data Warehouses and data architecture for projects exceeding $30 million.
Timeline
Contractor - Senior Data Modeler / Data Architect
Ascension (Bank)
09.2024 - 05.2025
Contractor - Senior Data Modeler / Data Architect
APEX SYSTEMS (United Natural Foods Inc.)
11.2023 - 04.2024
Senior Data Modeler / Data Architect
Vistra Corporation
05.2022 - 07.2023
Contractor - Senior Data Modeler / Data Architect
Judge Group
10.2021 - 03.2022
Contractor - Senior Data Modeler / Data Architect
Apex Systems
03.2021 - 10.2021
Contractor - Senior Data Modeler / Data Architect
Judge Group
06.2020 - 02.2021
Application Development – Senior Data Modeler
Bank of America
09.2017 - 03.2020
Contractor - Senior Data Modeler
Signature
05.2017 - 09.2017
Senior Data Modeler / Data Architect
General Motors Financial
08.2015 - 05.2017
Senior Data Modeler / Data Architect
Cognizant Technology Solutions
09.2014 - 08.2015
Data Architect and Modeler at Bank of America
Contractor
10.2012 - 01.2014
Senior Data Warehouse Architect
Electronic Transaction Systems
05.2012 - 10.2012
Information Architect at First Tennessee
Independent contractor
01.2012 - 05.2012
Data Modeler/Architect Contractor at Waste Management
Manpower
04.2011 - 12.2011
Lead Data Modeler/Architect Contractor at Capital One
Pyramid Consulting
08.2010 - 04.2011
Data Architect/ Senior Data Modeler Contractor at Bank of America
Zero Chaos
07.2009 - 08.2010
Data Architect/ Senior Data Modeler
Foot Comfort
05.2004 - 04.2009
Database Manager / Senior Data Modeler
First American (Formerly Transamerica Real Estate Tax Service)
04.2001 - 05.2004
Data Warehouse Solution Architect / Data Modeler
Fujitsu-ICL
01.2000 - 04.2001
Data Warehouse Architect/ Data Modeler
NCR
06.1998 - 01.2000
Bachelor of Science (BS) - Mathematics
Valdosta State College
Master of Science Management (MSM) - Public Administration
Florida International University
Similar Profiles
KAFIA DHHAIBAKAFIA DHHAIBA
Credit Analyst at BANKCredit Analyst at BANK
Malvika PathakMalvika Pathak
Senior Manager at BankSenior Manager at Bank
Shubham SinghShubham Singh
Banking Customer Service Representative at BankBanking Customer Service Representative at Bank
James LivelyJames Lively
E-shopper at HEBE-shopper at HEB
Donielle WolfeDonielle Wolfe
Paraprofessional at Harper Independent School DistrictParaprofessional at Harper Independent School District