SUMMARY:

• Confidential 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.
• Confidential has the experience and knowledge to lead and perform comprehensive responsibilities throughout the systems development life cycle from conception to deployment.

TECHNICAL EXPERIENCE:

• Source to Target / ETL Mapping
• Logical Modeling
• ERStudio
• Oracle
• SQL
• Data Profiling
• Physical Modeling
• ERWin
• Teradata
• Abinitio
• Data Quality
• Star Schema
• PowerDesigner
• DB2
• Netezza
• Waterfall
• Relational modeling
• Perl
• MS SQL Server
• DataFlux
• JAD Sessions
• DDL
• PHP/MySQL
• Sybase
• MS Project
• Agile
• ODS
• COBOL
• MS Access
• Visio
• EDW
• C

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Data Architect

Responsibilities:

• 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.
• Mapped MDM to Enterprise Data Warehouse.
• Mapped Enterprise Data Warehouse to Presentation Layer.
• 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.

Confidential, Chicago, IL

AML Specialist

Responsibilities:

• 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.

Confidential, Libertyville, IL

Data Architect

Responsibilities:

• 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.

Confidential, Chicago, IL

Data Architect

Responsibilities:

• 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.

Confidential, Bloomingdale, IL

Solution Architect

Responsibilities:

• 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

Confidential, Downers Grove, IL

Project Architect

Responsibilities:

• 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

Confidential, Chicago, IL

Data Architect

Responsibilities:

• 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.

Confidential, Bensenville, IL

Database Modeler

Responsibilities:

• 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.

Confidential, Chicago, IL

Data Architect

Responsibilities:

• 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.

Confidential

Riverwoods, IL March 2008 to November 2009

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

Confidential, Riverwoods, IL

Lead Data Architect / Data Modeler

Responsibilities:

• 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.

Confidential, Mount Prospect, IL

Data Architect

Responsibilities:

• Utilized IBM Business Data Warehouse 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 ( Confidential ), MS Access, MS Project, PERL. Applications: Mortgage, Auto Loans.

Data Architect

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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

Confidential

Responsibilities:

• 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.

Confidential

Data Modeling Consultant

Responsibilities:

• Utilized IBM Business Data Warehouse ( Confidential ) 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 ( Confidential ), MS Access. Applications: Mortgage, Auto Loans, Refund Lending.