Architecting, Planning and Implementation of end-to-end Data Warehouse and Business Intelligence systems utilizing best practices from Data Architecture, Data Integration and Data Management areas.
oEstablish data standards and templates to improve quality and integrity of data
oDesign Backup and Recovery Policy for the Enterprise Data warehouse (EDW).
oIntegration of diverse data sources with the EDW.
oDeveloping Analysis Model for the business subject areas.
oDeveloping OLAP cube models.
oIdentify and understand Source Data Systems. Map Source System Data to EDW Data Model.
oDesign and develop extraction, transformation, and load (ETL) processes.
oDefine and capture Meta Data and rules associated with ETL processes.
oQuery Tuning for performance.
oUse Business Intelligence tools and OLAP to generate cubes and analytical reports on large volumes of data
Defining Strategy and Architecture for systems involving Data Warehouse, ETL, BI Reporting, Data Marts, ODS, Data Governance, Data Quality, Meta Data Management etc. Assist in effort estimation for new projects/proposals.
Develop and implement standards, procedures and best practices for data maintenance, reconciliation and exception management.
Lead small to medium size projects, and manage the execution by planning project activities, assigning tasks to team, tracking and monitoring the tasks, and working with close coordination with the project manager.
Demonstrate technical leadership