powerdesigner dataarchitect 6.0 download

Powerdesigner dataarchitect 6.0 download manual#
Powerdesigner dataarchitect 6.0 download software#

Ensured that the corporate standards are being enforced in order to make it easier for users to understand the data from one database to another.

Powerdesigner dataarchitect 6.0 download software#

Worked with Software Architects and Engineers to help them find the data they need from other systems within the company and to efficiently store their own data in a logical manner and ensure data integrity.Worked with Principle Architects, System Analysts, and internal business customers to discover the data requirements and create the data model as well as data mappings to exchange data with other systems.Managed team of 3 data architects Designed and implemented multiple phases of Data warehouse with data extracted from various OLTP systems like mortgage application on a C_tree structures, loan servicing data on Oracle and consumer loans from SQLserver, for a centralized pool of data to report from.Lead Architect in Designing Comprehensive Data warehouse Solution, from data to the presentation layer, to build and expose Activity/Productivity of Customer risk rating, Wire Processing data.

Powerdesigner dataarchitect 6.0 download manual#

Eliminated manual effort that had been in place on a monthly basis.

Architected framework for data warehouse solutions to Process wealth management information for OCC regulation.

Architected framework for data warehouse solutions to Loan Management System, wealth management Architected and maintained Erwin logical and physical data models for Loan Mis, load Vantage, Loan Quest, and Financial Call reporting Data warehouse projects.

Managed the data management team of Data architects by providing architectural solutions for databases.

Responsible and accountable for the enterprise data management team.

Designed and Identified the Master Data Management (MDM) strategy and components for HR, Vendor etc.

Designed the enterprise data warehouse and shared components for Human Resources, Financial, Transportation and Logistics, Real Estate, Tax, Business Continuity Planning, IT Metrics using Ralph Kimball Dimensional Methodology including Conceptual, Logical and Physical Data Model.

Established the enterprise data standards blueprint, physical and logical standards, physical database design, architecture guiding principles and design Informatica ETL and Business Objects (BO) Reporting architecture.

Designed EDW architecture, data acquisition methodology and shared services solution to TW management.

Partnered with Business users in defining reporting needs, key performance indicators (KPIs), conducted end user interviews for various functional areas like HR, Transportation, IT Metrics, Real Estate, and Tax.Developed the Enterprise Data warehouse (EDW) and Shared Services strategy and conceptual design.Implemented the enterprise shared services which is the most prestigious implementation for Time Warner enterprise and divisions of Time Warner includes (Warner Bros, HBO, Time, Corporate, TBS etc).

A bachelor’s degree in Computer science, Computer engineering, or a relevant field is considered mandatory.

The most sought-after skills include –strong knowledge of database structure systems and data mining, excellent organizational and analytical abilities outstanding problem-solving skills, good written and verbal communication skills, and data management skills. Other duties include overseeing the data migration process and recommending effective solutions to improve new and existing database systems. A well-written Lead Data Architect Resume mentions the following core duties and responsibilities – designing and implementing effective database solutions and models examining and identifying database structural necessities assessing database implementation procedures, and installing and organize information systems. A Lead Data Architect is hired to render advanced technical support in business analysis, data architecture, research experimentations, and integration capabilities including database management.