Created Models using star schemas and snowflake schemas, Packages using Framework Manager.
Designed the model based on the requirements for different subject areas and by analyzing the underlying data.
#Cognos page layers windows
Closely worked with data warehouse designers to refine data and metadata.Įnvironment: Cognos BI 10.1/10.1.1/8.4 Framework Manager, Cognos Connection, Query Studio Report Studio, Analysis Studio, BIA, Business Insight and Event Studio, SQL Server 2008, and Windows server.
Tuning the performance of the Cognos Cubes and publishing Cubes on to the Powerplay Enterprise Server.
Created Models based on the dimensions, levels and measures required for the analysis-using Transformer.
Created Drill down / Drill Up reports using Analysis Studio.
Created Dimensional Maps, Transformer Models, Power-Cubes and Drill through Developed Combine Filter, User-Defined Filters, Custom ranking using Analysis Studio.
Creating the Cubes based on the requirements and creating the drill through reports for the cubes.
Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Bursting reports, Crosstab, multi-query reports, charts.
Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
Created Custom Dashboard pages using Cognos Portlets.
Analyze and define mapping to build the Framework Manager Models Packages with Query Subjects and Query Items.
Involved in Design and development of filters, calculations and session parameters in packages within Framework Manager.
Created Query Prompts, Developing Prompt pages and Conditional Variables.
Created prompts, Calculations, Conditions, Filters, Multilingual Reports Using Report Studio.
Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio.
Created Diverse Cognos Reporting Solutions.
Used Framework Manager to build models, packages and publish packages to the ReportNet Server.
Team Player with ability to prioritize multiple tasks while meeting deadlines.
Strong Troubleshooting and production support skills and coordination/interaction and users.
Expertise in OLTP/OLAP system study, developing models and publishing packages using different schema concepts.
Involved in the entire BI lifecycle project development, including design, coding, testing and implementation and ongoing product support.
Strong Experience in User acceptance test, product support, version control and change management.
Experience in integration of various data sources, Multiple Relational Databases like Oracle, and Worked on integrating data from flat files, and XML files.
Good understanding of business process especially in the Financial and Insurance areas.
Experienced in designing of Relational and Multidimensional databases.
Mentored and trained users for the successful execution of the project.
Exposure to client interaction and user-requirement analysis.
Extensive experience in cognos model design accelerator in the frame work manager.
Extensive experience in building the time based partition cube, custom views, signons in cognos transformer.
Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
Worked on various tasks for delivering the transformed data to coordinated data marts, delivering metadata to Framework Manager and publishing data movement tasks to IBM Cognos Connection.
Extensive Experience in the User Creations, Group Maintenance, Security assignment.
Involved in gathering of business requirements Documented them technically with all phases of SDLC life cycle.
8 years of extensive Functional and Technical experience in Data Warehousing, Data Modeling, Business Intelligence BI, and OLAP, ETL tools, product development and Reports Generation.
Hands on experience in Cognos 10,8 Query Studio, Report Studio, Analysis Studio, Framework Manager, Cognos Connection, Business Insight, Business Insight Advanced.
Expert in Business Intelligence Applications using Cognos Tools such as cognos 8 BI, Cognos10 BI Framework manager, report studio, query studio and Analysis studio.
Worked on Framework Manager, Analysis Studio, Query Studio and Report Studio for Model and Report design in Cognos BI version 8.3.
Experience developing Metadata Models, DMR Models, and creating filters, prompts, calculations, summaries and functions in Framework Manager.