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.
