SAP PowerDesigner | ER/Studio Data Architect | Data Modeling | Metadata Migration | Data Warehousing | Data Architecture | Automation | ER/Studio MetaWizard | ETL Mapping
• Assess the customer's PowerDesigner landscape, including CDM, LDM, and PDM models.
• Analyze model complexity, dependencies, custom properties, domains, scripts, extensions, and platform specific implementations.
• Identify migration risks, assumptions, constraints, and remediation requirements.
• Define migration approach, standards, governance, and quality controls.
• Lead pilot migrations to validate conversion feasibility and effort.
• Execute model migrations using ER/Studio MetaWizard and supporting tools.
• Define source-to-target mappings for metadata, domains, datatypes, relationships, keys, and custom attributes.
• Resolve conversion issues and implement remediation strategies for unsupported or customized constructs.
• Ensure consistency, traceability, and repeatability throughout the migration process.
• Design and execute reconciliation and validation processes.
• Verify structural integrity of migrated models, including entities, attributes, relationships, keys, and metadata.
• Identify and resolve migration defects, exceptions, and data modeling inconsistencies.
• Produce migration quality metrics, validation reports, and acceptance documentation.
• Design and develop automation utilities, scripts, macros, and accelerators to reduce manual effort.
• Leverage ER/Studio Automation Interface and related technologies to support bulk migration and validation activities.
• Establish reusable frameworks for future migration projects.
• Work directly with customer architects, data modelers, database teams, and project stakeholders.
• Facilitate migration workshops, discovery sessions, and technical reviews.
• Provide expert guidance on migration decisions, trade-offs, and best practices.
• Present findings, recommendations, and progress updates to leadership teams.
• Develop migration assets, templates, standards, and best practices.
• Create reusable migration playbooks and operating procedures.
• Mentor consultants and contribute to building organizational capability in metadata migration and data modeling modernization.
• 10+ years of experience in Data Warehousing, Data Architecture, or Enterprise Data Modeling.
• Strong hands-on experience with SAP PowerDesigner.
• Strong hands-on experience with ER/Studio Data Architect.
• Proven experience in metadata migration, model conversion, or repository modernization initiatives.
• Experience working with large and complex enterprise data models.
• Deep expertise in enterprise data modeling, metadata management, model conversion, automation, and stakeholder engagement.