| · 6 Years of IT experience with expertise in Analysis, Design, Testing, Development, and Implementation of various Software applications and generation of reports using Various Databases. · 5 Years of experience in Cognos OLTP/OLAP/Data Warehouse reporting tools Impromptu Administrator, Access manager, Impromptu Web Reports (IWR), PowerPlay Web Reports (PPES), Upfront, Scheduler, Cognos Reportnet1.1, Cognos Power Play Enterprise Server 7.x, Power Play Transformer 7.x and Cognos 8.3/8.4 BI series (Report Studio, Query Studio, Analysis Studio, Event Studio) · Sound Knowledge on Reporting by using Report Studio Tabular Objects, Tabular SQL, Customized Prompts, Conditional Formatting and Complex Layouts – Cross tabs and sub reporting, bursting, multi-prompt reports with drill-thru capabilities. · Expert and expertise on Cognos 8 Framework Manager to creating Models for reporting – Creating Business Layers, Hierarchies, folders and Cognos Connection. · Modified Power Cubes by adding new Dimensions, Levels and Measures Designed, developed and implemented Cubes for various analysis/reporting purposes. · Having good Experience implementing Cognos Security at report level. · Solid understanding of data warehousing, OLTP and OLAP concepts. · Experienced in Data Mining, Multidimensional Data Analysis using Power Cubes. · Data modeling experience using Dimensional Data modeling, Star Schema modeling, Snowflake modeling, FACT and Dimensions tables, Physical and logical data modeling using ERWIN 4.0. · Working knowledge of designing multidimensional architecture for Extract, Transform, and Load environment with Informatica, Data Stage and Cognos tools. · Extensive experience in creation of ETL mappings and transformations using Informatica Power Mart / Power Center to move data from multiple sources into target area. · Worked extensively with complex mappings using expressions, Routers, Lookups, ERP source qualifiers, aggregators. · Expertise in Business process modeling, Data analysis and Business Requirement gathering. |