data architect

Dave is an Enterprise Data Architect, Data Modeler and ETL Designer delivering technical services which meet or exceed customer expectations in the areas of Operational database and Data Warehousing. His most recent work has been the Data Architect for the Enterprise Data Warehouse of a major financial institution. He excels in hands-on analysis, team and project leadership and modeling. He effectively works with analysts, DBAs, programmers, and managers to gather requirements, review data requirements, and perform walkthroughs. Dave has the experience and knowledge to lead and perform comprehensive responsibilities throughout the systems development life cycle from conception to deployment.

PROFESSIONAL EXPERIENCE

Northern Trust, Chicago, IL 01/15 to Present

Data Architect

Created Enterprise Logical Data Model for the Enterprise Data Warehouse for an international bank.

Created Enterprise Physical Data Model for the Enterprise Data Warehouse.

Created source-to-target ETL mappings.

Translated data requirements into database designs.

Participated in JAD sessions.

Data profiling and data quality.

Methodology: Waterfall

Technical environment included: ERStudio, Oracle, DataStage, SQL. Applications: MDM, Salesforce (SDFC), Charles River, Banking.

BMO Harris Bank, Chicago, IL 11/14 to 01/15

AML Specialist

Consulted data architects with improvements to the AML Party Database.

Participated in data quality issue resolution sessions.

Methodology: Waterfall

Technical environment included: Netezza, SQL. Applications: AML, Banking.

V.W. Credit Inc., Libertyville, IL 05/13 to 11/14

Data Architect

Lead data warehouse solutions

Created star schema data models for the Data Warehouse of an automobile credit institution.

Translated data requirements into database designs.

Leveraged partitioning and parallelism to process large volumes.

Created physical data model, DDL and Oracle tables.

Created source-to-target ETL mappings.

Data profiling, analysis and data quality using SQL, DataFlux and MS Access.

Methodology: Agile

Technical environment included: ERStudio, Oracle 11g, Sybase, MS SQL Server, SQL, DataFlux, Microsoft Visual Studio, Informatica. Applications: Data Warehouse.

Northern Trust, Chicago, IL 05/12 to 05/13

Data Architect

Created relational and star schema data models for Asset Reporting Data Mart for an international bank.

Translated data requirements into database designs.

Created relational models, dimensional models, physical models and DDL.

Consulted application and DBA teams on star schema strategy and design.

Created prototype accounting data model, DDL, SQL SCD-2 ETL programs to maintain tables.

Researched, demonstrated and documented the viability of IBM DB2 native stored procedures.

Validated surrogate key generation using SQL to provide detailed discrepancy reports.

Developed Data Virtualization specifications for Composite.

Technical environment included: PowerDesigner, IBM DB2 z/OS V9.1 NFM, SQL, DataStage. Applications: Asset Reporting Data Mart, Banking.

Bridgestone Retail Operations, Bloomingdale, IL 11/11 to 05/12

Solution Architect

Created high level design document for the Campaign Management System of a national retail company.

Developed detailed technical design documents.

Participated in design sessions.

Created physical data model, DDL and Teradata tables.

Created source-to-target ETL mappings.

Data profiling and data quality.

Technical environment included: Erwin, Teradata 13, SQL Server, Oracle, Visio

Dearborn National, Downers Grove, IL 05/11 to 11/11

Project Architect

Created project solutions architecture document for Pre-Sale Reporting Data Mart of an insurance company.

Created and presented Data Architecture anti-patterns / best practice document to client.

Created logical data model and traceability matrix.

Created physical data model and DDL.

Participated in JAD sessions.

Data profiling and data quality.

Technical environment included: Erwin, SQL Server, DataStage, Visio

Northern Trust, Chicago, IL 08/10 to 05/11

Data Architect

Created star schema data models for Risk Reporting Data Mart for an international bank.

Created source-to-target ETL mappings.

Translated data requirements into database designs.

Created dimensional models, physical models and DDL.

Participated in JAD sessions.

Data profiling and data quality.

Methodology: Agile

Technical environment included: ERStudio, Oracle, DataStage, Business Objects. Applications: Credit Risk Reporting Data Mart, Banking, Basel II.

US Cellular, Bensenville, IL 03/10 to 08/10

Database Modeler

Maintained operational, ODS and Data Warehouse data models for a cellular company.

Reviewed and validated technical design documents.

Designed and reviewed materialized views.

Reviewed developer SQL statements.

Facilitated database change control process.

Technical environment included: ERStudio, Oracle, Informatica. Applications: AMDOCs, Wireless Telecom.

Apex Systems Inc, Chicago, IL 11/09 to 03/10

Data Architect

Established Data Architecture diagrams / system flows for a national retail company.

Established Data Architecture Guidelines and Data Modeling Standards.

Created and maintained Consolidated Data Model for the Operational Data Store.

Developed standard process for data requirements and data modeling.

Translated data requirements into database designs.

Facilitated database change control process.

Created source-to-target ETL mappings.

Managed timelines, coordinated resources, facilitated project meetings, recorded and resolved issues.

Maintained meta data.

Technical environment included: ERWin 7.3, Teradata, Ab Initio, DatasStage, MS Project. Applications: Retail Data Warehouse.

Discover Financial Services, Riverwoods, IL 03/08 to 11/09

Solutions Architect

Participated as Lead Solutions Architect of Core Design Team representing 17 technology teams.

Worked closely with managers and developers.

Created high level design for Enhanced Credit Line project.

Created source-to-target ETL mappings and system flows.

Leveraged consolidated data within the ODS which included transactional data from source systems in a massively parallel environment.

Participated in natural work groups.

Sourced data for portfolio risk decision engines- Strata and Blaze.

ETL Developer.

Created help desk ticket inquiry intranet application.

Technical environment included: Ab Initio, Teradata, PHP/MySQL, MS Access. Applications: Data Warehouse, Strata, Blaze

Discover Financial Services, Riverwoods, IL 10/06 to 03/08

Lead Data Architect / Data Modeler

Promoted to lead Data Architect role. Managed day-to-day tasks for three data architects to complete two phases of the ODS project, which consolidated many transactional data sources in a massively parallel environment.

Created estimates, managed project plans and reported formal status to management.

Utilized Teradata Financial Services Logical Data Model (FSLDM) to create enterprise logical data models and the ODS.

Created data models for data marts used by Cognos.

Reviewed data requirements and models with analysts, DBAs and ETL programmers.

Created source-to-target ETL mappings.

Translated data requirements into database designs.

Created normalized logical models, dimensional models, physical models and DDL.

Led walkthroughs.

Participated in natural work groups.

Technical environment included: ERStudio, ERWin 4.1.4, Teradata, Cognos, Ab Initio, Oracle, MS Access, PERL, MS Project. Applications: Data Warehouse.

HSBC, Mount Prospect, IL 10/01 to 10/06

Data Architect

Utilized IBM Business Data Warehouse (BDW) to create enterprise logical data models, operational databases and data warehouses.

Contributed to the development of the Global Data Warehouse logical model.

Created normalized and dimensional models.

Reviewed data requirements and models with analysts, DBAs and programmers.

Led walkthroughs.

Reviewed DBA physical designs and created physical designs.

Created comprehensive enterprise data modeling standards.

Used MS Access to compare metadata.

Technical environment included: ERWin 4.1.4, DB2, MS Project, Oracle, IBM Business Data Warehouse (BDW), MS Access, MS Project, PERL. Applications: Mortgage, Auto Loans.

Data Architect - Auto Finance business unit

Based on the banking model, developed the logical data model and process models for the new loan servicing system. Data included customer demographics, account, financial and business events.

Led development of event data structure which was incorporated as the corporate standard. This was achieved through consensus on the proposed model and definitions.

Developed the Auto Enterprise Data Model, which included a high reuse of required loan servicing structures integrated with collections structures.

Managed timelines, coordinated resources, facilitated project meetings, recorded and resolved issues.

Technical environment included: DB2, Websphere. Applications: Auto Loans

Data Architect - Household Mortgage business unit

Based on the banking model, developed the logical data model for the new loan staging system, which was the boarding point for all purchased mortgages into the loan servicing system. Data included involved party, loan, customer demographics, due diligence, insurance.

In the same fashion, developed the Involved Party logical data model for the new external party reference system.

Managed timelines, coordinated resources, facilitated project meetings, recorded and resolved issues.

Consulted the Mortgage Enterprise data modeling project.

Technical environment included: Oracle, PowerBuilder.

Data Architect - HSBC Mortgage business unit

Based on the banking model, developed the Enterprise Logical Data Model. Data included loan application, application events, account, and customer demographics.

Managed timelines, coordinated resources, facilitated project meetings, recorded and resolved issues.

Technical environment included: Oracle, DB2, Datastage.

Knightsbridge Solutions, LLC 10/98 to 10/01

Data Modeling Consultant (client: HSBC)

Utilized IBM Business Data Warehouse (BDW) to create data models for new databases: relational and dimensional.

Reviewed data requirements and models with analysts, DBAs and programmers.

Led walkthroughs and normalized models.

Reviewed DBA physical designs. Used MS Access to compare metadata.

Technical environment included: ERWin 3.5.2, DB2, Oracle, IBM Business Data Warehouse (BDW), MS Access. Applications: Mortgage, Auto Loans, Refund Lending.

OLAP Consultant (client: major pharmaceutical company)

Created and maintained data loads for Essbase cubes (data marts).

Designed and created new Essbase cubes. Data source was JD Edwards ERP database.

Modified cubes to fit client goals.

Technical environment included: Essbase, SQL, DB2, AS/400.

Data Analyst Consultant (client: insurance company)

Analyzed referential integrity rules in Oracle database (constraints, functions, procedures, packages) and Sybase database (triggers, procedures) - discrepancies were reported.

Examined codes in each database, created analysis comparison reports.

Imported Sdesigner entity and attribute comments into ERWin using SQL and Sybase.

Used MS Access to investigate/perform most data analysis functions.

Technical environment included: Oracle7, Sybase, ERWin 3.5, DBArtisan, Windows 98, MS Access 97. Applications: Claims.

Data Analyst Consultant (client: credit card firm)

Identified data sources for the Risk Data Mart project.

Designed enhancement to current Metadata repository to include non-relational file information.

Created capture point of key information in MS Access: host processes, batch windows, record layouts, datasets, relational tables and cataloged legacy system documents.

Various pieces of information were cross-referenced in the Access relational database.

Mainframe skills utilized to analyze legacy data.

Technical environment included: IBM Mainframe, JCL, FILEAID, Syncsort, SAS, Windows 98, MS Access 97. Applications: Billing and Posting

EDUCATION

B.A. in Computer Science

Concordia University, River Forest, IL

Professional Education:

Advanced Teradata SQL

Complex SQL

Intro to AbInitio

Contact this candidate