I work project to create conceptual to physical schemas OLTP DMM plan, blueprint for an data design and work on OLAP ERM. Generate graphical diagrams to drill into to view detailed metadata. Using ERwind to crystal reports.Export reports to HTML and CSV and customize report.Improve lookup transformation performance of data. Work efficiently with Session Management, Mart Administration, Security, AD via LDAP, and Model Locking. Set app roles, Data Movement sources, Naming Standards,Partitions Functions, Relationships, Validation rules, create Trigger , Workload Groups and data type standards are integrated with models and support for SQL Azure. Select objects and properties for easy editing. Set Target SQL DBMS ( Oracle, SQL Server, DB2 for LUW, MySQL, Sybase, ODBC/Generic and Default SQL Server Data type). Set key Option NOT NULL or NULL.