- Design and Develop analytical reporting based on IBM Cognos BI. - Design and Develop ETL mappings and workflows based on Informatica PowerCenter and SSIS - Design and Model OLTP, datawarehouse and data masters based on star-schema principles - Developing solution architecture using client requirements and transforming into conceptual data models including implementing logical and physical DW/datamart data models, identifying data sources and metadata. - BI and DW data management, modeling, integration, start-schema and relational reporting models, enterprise data management policies, procedures, compliance and risk management. - Design and development of data model, cleansing routines, transformation, processes and technology management for master and meta data, data security