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
