Architect and Development lead commissioned to re-architect a highly visible executive level datamart within the RBC Dain Market Research group.
Participated in the business analysis and design of the Market Research Data Mart. This Data Mart supports 7 subject areas, centered around a client account, branching out to household and financial consultant. Each subject area supports aggregation, slowly changing dimensions, support of history in metric tables and full surrogate key structure.
Developer working on a Firstlogic (now owned by Business Objects) household application performing address correction and account consolidation based on name, address, phone and social security number.