Data Warehouse Specialist

Deloitte--Interacted with business users to gather business requirements and designed functional and technical requirements documentation.\r\nCreated Cognos 8.4 Framework Manager models including relationships, filters, aggregations, rollup processing, calculations, organized folders, merged query subjects, aliases, shortcuts, database layer, business layer, presentation layer, and have setup data/object security and successfully published the packages. Created Star Schema Models in Frame work manager\r\nIBM--Creating Sales Pipeline Report for different Brands of IBM for the Higher Management of Europe and North America for different Sales Stages and different Quarters as per there requirements. Work with sales operations teams to analyze pipeline and revenue trends.\r\n\r\nManage a team that collates data sets and arrange the data for reporting in COGNOS and driving efficiency through automation.\r\n\r\nISU--Assigned the groups to Cognos Default User Roles based upon the roles they are supposed to carry or the focus group they belong.\r\nWorked on Data Modules and Data Sets creating from different packages\r\n• Imported spreadsheets and uploaded cognos and created reports out of it \r\n• Experience in analyzing and integration of various data sources to create data marts\r\n• Experience in using advanced visualizations in Cognos 11.10 for creating advance dashboards and workspaces\r\n• Used Framework Manager Model to define data sources, model data from multiple sources, created and published Packages and created reports for different subject areas\r\n