Job Search Status
Open to workDesired start date: Flexible
Desired Job Title
Enterprise Data Architect / DesignerWork Type
ConsultingPart TimeFull TimeLocation Preference
RemoteHybridLocation: Kansas City, MO, US
Open to relocation: No
Open To Work
ALAN F. STEINBRECHER
Enterprise Data Architect
Kansas City,MO
Work Preference
Summary
- Open to new, interesting, challenging, and innovative horizons.
- Proficient with working on business intelligence, systems analysis, business rules, process and functional requirements, data analysis and architecture within data warehouse reporting and transaction processing environments.
- Practice full Scaled Agile Framework (SAFe), SDLC systems analysis, data modeling, design, coding, and testing with CASE tool methodologies using DIMBOK and BIZBOK frameworks.
- Practiced and applied DIMBOK framework principles of data governance, data stewardship, data quality, and data and metadata management.
- Performed Data Modeling and Design within various DBMS environments including Kafka, Oracle, DB2, Informix, Microsoft SQL Server, SAP, Azure Data Lake, Azure Databricks, Azure OpenAI.
- Identified, collected, maintained metadata using IBM InfoSphere Information Governance Catalog and Alation Metadata Catalog Repository.
- Maintained corporate Data Governance policies for confidential, proprietary, sensitive, and personal data for consistency.
- Introduced and implemented a POC to use Azure OpenAI ChatGPT with Retrieval-Augmented Generation (RAG) to create an intelligent application for metadata management and standardized naming based on ISO ISO/IEC 11179-5:2015. Designed a fully normalized LLM data model to use with RAG.
Skills
- Corporate Information Engineering and master data
- AllFusion Gen by CA
- Data Governance compliance and guidance
- CA ERwin, AllFusion Erwin, Power Designer, Hackolade
- Process & Data Driven Design/Architecture
- MS SQL Server, Oracle, DB2, Teradata, Azure, SAP, HTML, XML, JSON, JAVA, Kafka
- SAFe Agile, iterative and incremental, sequential
- IBM InfoSphere Information Governance Catalog
- Alation Metadata Repository
- Full System Development Lifecycle
- Cobol, IBM C/370, Fortran, Pascal, C
- Process & Data Analysis Business Rules Analysis Systems Analysis & Design
- Managed and worked ServiceNow project requests submitted for data modeling projects
- PL/SQL Developer Oracle SQL Developer
- TOAD for Oracle Developers
- ServiceNow management of Development work requests
- Azure OpenAI ChatGPT with Retrieval-Augmented Generation (RAG)
- Azure Medallion Data Architecture design and data modeling with bronze (raw), silver (validated), and gold (enriched) layers
- AI Retrieval-augmented Generation (RAG) database design
- Conceptual, Logical, Physical data modeling
- MS Visual C, Borland C, Visual Basic
- SAP, DB2, Teradata, Marklogic, GitHub, Kafka
Education
BS - Data Processing
Washington University
Saint Louis, MOBA - Design
Southern Illinois University
Carbondale, ILAffiliations
- Alliance Francaise de Kansas City, Kansas City, MO
- - Webmaster. Jan, 2009 to May 2013
- - Vice President. Aug, 2001 to Aug, 2003
LANGUAGES
English - Native Fluency
French - Native Fluency
Work History
Senior Data Modeler/Architect - Data Design Team at BNSF Railway
BNSF Railway
12.2015 - 03.2024
- Data Modeling, Design, Data Architecture and implementation of DDL across multiple enterprise application domains within various DBMS environments including Oracle, DB2, Informix, Microsoft SQL Server, SAP, Azure Data Lake, Azure OpenAI using Retrieval-augmented Generation (RAG), Data Bricks.
- Conducted joint sessions with business and development teams to perform modeling, application analysis, data design as well as identify feasibility, requirements, business rules, and data dependencies.
- Conducted Process and Data design sessions across a variety of business domains including operational, financial, legal, compensation, health, retirement, human resources, job assignments, and compensation.
- Created Conceptual, Logical, and Physical data models based on business requirements and rules within a wide range of enterprise business data domains.
- Curated as well as cataloged project and application metadata for each data design project including; Business Logical Data Element Names and their definitions, Approved Business Data Element Abbreviations and their definitions, Existing and Approved Physical Data Element Names and their definitions.
- Collaborated with Database Administrators and Product Owners during the process of building, testing, and implementation of data structures within various business data domains.
- Collaborated with Database Administrators and Product Owners to identify roles and access grants for application users that they needed to perform their jobs.
- Used TOAD to reverse engineer databases into Physical data models.
- Managed and worked ServiceNow project requests submitted for data modeling projects.
- Synchronized Metadata captured during data modeling projects with IBM InfoSphere Information Governance Catalog (IGC) and Alation Metadata Repository.
- Used IBM InfoSphere Information Governance Catalog (IGC) and Alation queries to generate metadata reports of application domain tables and columns to verify completeness and quality of metadata definitions.
- Identified, collected, maintained metadata using IBM InfoSphere Information Governance Catalog (IGC) and Alation Metadata Catalog Repository for modeling projects on multiple enterprise application platforms. Maintained corporate Data Governance policies for confidential, proprietary, sensitive, and personal data for consistency.
- Worked as the dedicated modeler/architect with a Modernization Project Team during the past five years.
- Successfully implemented a modernized database architecture that provided greater features and functionality than what previously had been provided in the legacy system.
- Implemented temporal (business and system time) data architecture for the modernization project.
- Submitted a proposal for a Proof of Concept to use OpenAI to implement a manual process of metadata management.
- Analyzed and segmented the POC manual process into elemental processes, data domains, and business rules.
- Used the POC analytical results to create OpenAI data set files with tightly and highly vectored cross references of data and process components.
- Implemented Retrieval-Augmented Generation (RAG) custom data within a Large Language Model (LLM).
- Successfully demonstrated the capability of obtaining accurate responses when issuing prompts against the custom data sets and Large Language Model.
Consulting Data Architect at BNSF Railway
COMFORCE , Inc.
05.2013 - 12.2015
- Participated in Joint Application Design sessions to identify user requirements for all Revenue Accounting Contracts processed within the Liability Rating System of the Revenue Modernization project.
- Data Modeling, Design, Data Architecture and implementation of DDL across multiple enterprise application domains within various DBMS environments including Oracle, DB2, Informix, Microsoft SQL Server, SAP.
- Created Conceptual, Logical, and Physical data models based on business requirements and rules. Used TOAD to reverse engineer databases into Physical data models.
- Created and proposed a Data Strategy detailing a phased analysis and design approach for the creation of a set of Data Deliverables required to produce a logical data model of the Liability Rating System.
- Created and vetted each of seven Data Strategy Deliverable Document Specifications with the Enterprise Information Management Team. Each specification detailed the required scope, content, approval process, and ownership for each Data Deliverable.
- Created, vetted, and revised with business SMEs each of the seven initial Data Strategy Deliverables. Each deliverable included the identification of the current and target states of data as well as associated processes.
- Created the initial versions of the Conceptual Data Model, Business Context Entity Matrix, System Context Entity Matrix, System Context Diagram, Data & Process Flow Diagram, and Business Process/Data Entity Matrix (CRUD).
- Collaborate with EIM Data Architects & Modelers regarding the integration of the Data Strategy within the context of an overall Enterprise Data Architecture.
- Contributing member of BNSF's Enterprise Information Management team of Data Architects tasked with the development and implementation of a Data Modeling and Design Methodology within the context of an Enterprise Data Architecture.
- Provide data modeling support for Remedy Work Orders including validation of requirements and approach, creation or modification of data model structures, DDL code creation, updates and additions to the enterprise metadata repository, and compliance with enterprise naming standards.
- Synchronized Metadata captured during data modeling projects with IBM InfoSphere Information Governance Catalog (IGC) Repository.
Data Analyst/Contractor at YRC Freight Worldwide
Computer Enterprise, Inc.
12.2012 - 03.2013
- Modified, expanded, and completed a logical data model based on table and view structures within PeopleSoft DB2 source database as detailed within an HR reporting requirements documentation. Integrated metadata to the model from the source spreadsheets as well as older HR subject area data models.
- Created data mapping of PeopleSoft HR source tables aligned with HR logical data model and requirements.
- Reverse engineered PeopleSoft HR subject area DB2 tables and views using ERwin Data Modeler 8.2. Saved models as DB2 and created versions of each in MS SQL server 2012.
- Used TOAD to reverse engineer databases into Physical data models.
- Managed and worked ServiceNow project requests submitted for data modeling projects.
- Synchronized Metadata captured during data modeling projects with IBM InfoSphere Information Governance Catalog (IGC) and Alation Metadata Repository.
- Converted ModelMart 4.1.4 models to ERwin 7.2 then to ERwin 8.2. When the conversions failed due to corruption in ERwin 4.1 or ERwin 7.2, I forward engineered the model into SQL and reversed engineered into ERwin 8.2.
Data Architect/Consultant Sub-Contractor
Computer Enterprise, Inc.
08.2011 - 02.2012
- Participated in EDW BI Assessment and Recommendation interview sessions with upper level financial and operational management, direct reports, and financial reporting analysts for projects including; a major health care management organization in the Kansas City area, as well as a major health nutrition and services provider in the Omaha area.
- Activities included documentation of the existing state of adhoc reporting, identification of reporting gaps within the existing and mostly manual reporting environment, identification of operational areas that need process improvement, identification of future reporting needs, scoping and prioritization of reporting needs, and recommendation of a phased approach for initiating a formal DW BI environment.
- Prepare estimates for level of effort required for reporting requirements, analysis, design, development, testing, implementation and maintenance.
- Prepare RFP for ETL and BI reporting tools criteria.
- Participated in as well as contributed to the preparation and presentation of a PowerPoint summarization of a BI DW Recommendation that included a matrix of current and future reporting needs, high level diagram of current state manual data and process flows, attributed and non-attributed conceptual data model, a BI justification ROI matrix, a baseline BI organizational structure, a baseline BI Architecture, as well as a phased implementation recommendation including a proof of concept phase.
Data Architect/Analyst within Data Management group at CenturyLink Telecommunications
ECCO Select
02.2009 - 11.2010
- Provided analysis, design, data mapping support for the Enterprise Data Warehouse - Business Intelligence OLAP data mart for Local Service Request reporting and compliance. The EDW LSR (Local Service Request) data mart incorporated the use of Oracle's Change Data Capture technology.
- Worked with another data architect to identify and validate the integrity of the ETL data flow from the OLTP source tables into our staging and subsequently into our reporting tables. The validation process of ETL data flow was based upon previously identified business rules associated with the creation of Local Service Request activities captured during the business requirements definition phase of the project. Prepared data mapping documents detailing the source to target population of ETL processes including sample SQL statements for data access, which were distributed to the ETL development team to guide the Informatica ETL coding process.
- Incorporated the design of a set of tables for the purpose of exception processing in order to insure the completeness of transaction data and thereby facilitate resolving upstream process errors as well as reporting anomalies identified by members of the LSR reporting team.
- Analyzed, architected, designed, and modeled data as well as processes (based upon Salesforce.com and Truecomp.com data) of the Enterprise Sales Performance Data Mart, and Integrated Reporting Data Mart (which included a Trouble and Service ticket Data Cube) within the Enterprise Data Warehouse.
- Associated activities included user and functional requirements analysis/definition, 3NF and dimensional data modeling (ERwin), source data research and identification, source to target data mapping, attribute metadata capture and reconciliation, and preparation of transaction and data/process flow diagrams. Data modeling and DDL generation environments included Oracle 11i, DB2, Informix, and MS SQL Server 2000.
Data Analyst within Enterprise Data Management group
Commerce Bank
06.2006 - 03.2008
- Provided requirements and data analysis/design support for the Customer Intelligence Initiative OLAP data warehouse and data marts.
- Performed data modeling, forward and reverse engineering of databases, and OLTP source to target data mapping.
- Performed requirements analysis, meta data documentation of associated data, as well as capture and document data business rules and definitions.
- Performed data quality analysis and profiling, researched and documented source data life cycles.
- Provided PowerDesigner and ERwin application SME as well as maintenance support.
- Data modeling and DDL generation environments included DB2 and MS SQL Server 2000.
Data Analyst/Consultant at IBM/Sprint PCS Call Center Data Warehouse OLAP Reporting Project (E2E-Seabiscuit)
Silicon Valley Systech, Inc. (INFIX IT, INC.)
05.2005 - 08.2005
- Performed process and data analysis of call center application design.
- Participated in business requirements analysis sessions with subject matter experts and clients to identify data requirements.
- Wrote and ran SQL queries against reporting databases to perform data quality analysis.
- Created and reverse engineered data models (Oracle) of source ODS as well as test and production reporting databases into ERwin.
RAD Analyst/Consultant at Sprint
Information Technology Group, LLC.
04.2004 - 07.2004
- Analyzed computer service request documentation and determined estimated levels of effort associated with applications supported by data management.
- Performed analysis of the existing feasibility estimation processes and documented data flows.
- Created non-attributed conceptual data model, as well as normalized and attributed logical data models.
- Prepared estimation extracts as well as modified and ran MS Access feasibility estimation reports used by the RAD (Requirements Analysis Design) group.
- Maintained database extract files to populate spreadsheets and Access tables.
Data/Process Analyst-Consultant at Disney. Data Governance Team within Disney's Business Intelligence group
CIBER, Inc.
01.2003 - 02.2003
- Supported Product and Services application redesign within a closed loop CRM data warehouse environment.
- Identified business rules and functional requirements detailed within a third party technical design.
- Created logical and normalized data models of associated data entities and attributes.
- Performed data gap analysis between business rules, functional requirements, and data models.
- Identified data governance issues of consistency of data usage and integration issues within the technical design which resulted in enhancements to the design.
Sprint's Data Management Group. Data Analyst III, Lead Data Analyst, and Project/Team Leader
Sprint Long Distance
01.1999 - 03.2002
- Designed and maintained relational and multi-dimensional data models for various data warehouses.
- Lead analysis sessions with users and created conceptual as well as logical attributed and normalized data models.
- Forward and reverse engineered DDL/SQL of Oracle, MS SQL Server, and Teradata databases.
- Provided PC hardware, software, Oracle client, ERwin and ModelMart SME support to Kansas City DAs.