Professional Experience Client — XL Insurance (Hartford, CT) 6/2008 — Present Role — Business
Intelligence Solutions Consultant — Insurance Data Warehouse • Participate in information -
gathering sessions to determine and assess project requirements, identifying best - fit architecture solutions in line with enterprise data warehouse architectural standards • Work closely with the data modeler and the DBA in the design of the logical and physical data model • Create and maintain models for Cognos, performing extensive STAR Schema modeling to enable reporting decentralization and allow for user - driven ad - hoc reporting as well as drawing
upon SSRS and OBIEE reporting solutions • Strategize with the ETL team to identify the best case design strategy for ETL - related activities including ETL design patterns determination, load strategies, load timing and frequency, and data retrieval expectations determination • Participate in providing Rough order of Magnitudes (ROM) estimates in and out of release projects, estimating resource requirements and managing within determined time constraints • Assist in the development of security tools in Cognos 8 using LDAP and Active directory while holding responsibility for maintaining run books and project documentation in Sharepoint