We provide IT Staff Augmentation Services!

Data Architect (contractor) Resume

0/5 (Submit Your Rating)

Frisco, TexaS

SUMMARY:

  • Senior Information Architect with expertise leveraging data architect, data warehouse, and solution architect technologies to solve retail, financial, and customer demographic business problems.

TECHNICAL SKILLS:

Technology and Tools: MVS ALC Data Dictionary DB2 Teradata UNIX Cobol Data Repository SYBASE Cognos Windows C PDM ORACLE ERWIN AS400 SQL Server LDM INFORMIX Informatica s

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect (Contractor)

Responsibilities:

  • Design solution architecture and estimate magnitude of effort
  • Revise data architecture scope and improve upon project plans
  • Develop Information Technology Roadmaps and Governance policies and procedures
  • Data Provisioning and Metadata Repository strategic and tactical implementations

Confidential, Frisco, Texas

Data Architect

Responsibilities:

  • Conceptually designed the database system and application structures.
  • Designed expense tracking system and analytical reporting allowing next day reports.
  • Implemented Retail Physical Data Model from the Logical Data Model.
  • 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 data mart for budget and performance reporting.
  • Produced end - to-end architecture mapping/design using Teradata and SqlServer.

Confidential, Dallas, Texas

Database Manager

Responsibilities:

  • Established standards and guidelines for data warehouse design and Sql.
  • Improved intra - departmental functions: established meetings and technical reviews.
  • Re-organized departmental functions: rapid response and operational methodologies.
  • Runtime improvement reduced direct costs, through better query management and efficiency.
  • Designed Informatica extraction, transformation, and load rules for AS400 data warehouse.
  • Conducted data warehouse design reviews and adopted better query analysis techniques.
  • Increased AS400 Data Warehouse runtime improvements with better index structures.
  • Created Tax Service Data Dictionary and Logical Data Model with ERWIN.
  • Established standards and guidelines for data warehouse design and Sql.

Confidential, Dallas, Texas

Data Warehouse Architect

Responsibilities:

  • Created Logical Data Model and Physical Data Model for data warehouse with ERWIN.
  • Designed SqlServer, Teradata, and Oracle Logical and Physical Data Models.
  • Database architect for Star schema data mart (ORACLE and SYBASE).
  • Data modeler and SYBASE DBA for Fuji Film web based system.
  • Lead Database team of three people for a database web project for Print and Graphic services.

Confidential, Dallas, Texas

Data Warehouse Architect

Responsibilities:

  • Three financial projects: Warehouse design, data architect, mapping, and extraction.
  • Produced end - to-end architecture mapping/design covering multiple business units.
  • Confidential trained Teradata Database Administrator to support 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.

We'd love your feedback!