We provide IT Staff Augmentation Services!

Lead Data Warehouse Architect Resume

MA

SUMMARY

  • Database / Data warehouse architecture, data modeling, and ETL technologies
  • Master data management (MDM) and data governance policies and implementation
  • Project leadership - business process analysis, design, and development
  • Agile Database Design methodology
  • Excellent interpersonal, verbal and written communication skills

PROFESSIONAL EXPERIENCE

Confidential, MA

Lead Data Warehouse Architect

Responsibilities:

  • Evaluated UHC architecture, and provided an architectural roadmap to integrate the newly acquired companies’ complex databases
  • Reverse engineered existing databases into physical data models; built/published the data dictionaries
  • Designed the data warehouse model using Kimball methodology, and recommended the Bus Architecture
  • Developed source-to-target mappings and data transformation logic, including calculations
  • Mentored technical resources in BI-related architectural issues and best practices.
  • Generated, executed, and versioned SQL scripts (DDL) to create databases, tables, views, indexes, constraints, etc
  • Collaborated with key IT stakeholders to ensure solutions meet projects’ information requirements and fit within the broader enterprise architecture context

Confidential, MA

Data Architect

Responsibilities:

  • Designed data models and XML schemas, ensuring adherence to defined corporate standards and definitions, for both transactional systems and data warehouses in the personal and workplace investment sectors
  • Participated in the development and maintenance of corporate data architecture, data management standards, data dictionaries and data element naming standards and conventions for multiple computing environments
  • Provided consultation to applications development, database administration, business analysts, and client areas in resolving questions during the translation from logical to physical database structures.
  • Led development teams, both local and offshore, and coordinated Joint Application Design (JAD) sessions with cross-functional business leaders
  • Designed and delivered complex data cleansing and loading processes

Hire Now