Sr Cognos Consultant

7/2008 - Present

Individual Contributor

• •Involved in developing RWA and Top failure analysis reports with interacting business users and gathering report requirements. •Created business specifications and data requirements and Detail design specifications. •Used Framework Manager to build models, packages and publish packages to the cognos Server. •Created Complex Reports & Simple Reports using Report Studio and Query Studio. •Created multi page reports according to business requirements. •Generated/updated various reports List Reports, Cross-tab Reports, Chart Reports with ranking, and Drill -Through Reports using Report Studio. •Customized the reports/data by adding filters at Framework and Report level. •Created Private and Public Folders in Cognos Connection. •Created prompts, Calculations, Conditions, Filters using Report Studio. •Created Query Prompts and Prompt pages. •Developed reports using Conditional blocks & Conditional Variables. •Extensively utilized HTML and JavaScript in report development. •Worked with master-detail reports, formatting, conditional formatting, multi-query reports, Render Variables. •Scheduled Reports and Jobs to run periodically. •Developed Standard templates in Report Studio for developing reports. •Performed Unit testing for all developed reports. •Extensively used TOAD to run SQL queries and validate the data in reports. •Created Dashboard reports to show Dealer wise failures in Tabular, Summary and Charts. •Involved in pilot session of RWA report application and with the users. •Worked with the Cognos Support Team to resolve the issues. Environment: Cognos8.3 (Cognos Connection, Report Studio, Query Studio, Framework Manager), Oracle9i, SQL, Teradata, TOAD, Windows XP, HTML, JavaScript.

11/2007 - 6/2008

Baxter Healthcare Inc,

Individual Contributor

• •Used Framework Manager to build models, packages and publish packages. •Built models containing query subjects, query items, and namespaces from imported metadata. •Created complex reports using Report Studio. •Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Master Detail Reports Using Report Studio. •Created prompts, Calculations, Conditions, Filters using Report Studio. •Created Query Prompts, Developing Prompt pages and Conditional Variables. •Scheduling and Distributing Reports through Schedule Management in Cognos Connection. •Worked with master-detail reports, drill-through, prompts, complex calculations, formatting, conditional formatting, Crosstab, multi-query reports, charts. •Created Dashboard reports to show sales summary for Territory business manager and Area Directors. •Extensively used SQL and TSQL. •Created Models based on the dimensions, levels and measures required for the analysis. •Implemented package level security, created groups & roles and granted individual users to access Cognos. •Created Ad-hoc reports using Query Studio. •Closely worked with ETL designers to refine data and metadata. •Analyzed the existing Siebel Analytics reports and developed in Cognos. •Worked in offshore/onsite model and responsible for onsite/offshore coordination. Environment: Cognos8.3 (Report Studio, Query Studio, Metric Studio, Cognos Connection, Framework Manager), SQL Server 2005, Oracle9i, SQL, Siebel Analytics 7.5, Windows XP.

2000

Master Degree

Osmaina University

• Computer Science