Data Warehouse Consultant
Spearheaded projects to design, develop and implement data warehouse tasks for areas such as mortgage consumer lending, auto finance, risk management, retail banking and wealth management systems.
- Handled analysis and reporting modules using SAS
- Managed data quality, profiling and governance tasks
- Hands on as well as sound knowledge of UDB, extensive SQL, PL SQL, DB physical modeling, Data analysis
- Defined the architecture and the various phases to create the data warehouse.
- Created the ETL architecture and provided strategy related to data cleansing, data quality and data consolidation.
- Created multi-dimensional data model (STAR Schema) and enhanced it to meet growing requirements.
- Interacted with business users on regular basis to consolidate and analyze the requirements and presented them with design results.