Skill:

Employment History:.

Confidential

Sr. Cognos BI Developer/Analyst

Responsibilities:

• Developed complex DMR and relational models in Framework Manager Model.
• Performed Cognos administrative tasks including security, user accounts, data migration, configuration, software installations and deployments.
• Expert in Cognos BI Administration
• Created filters within the Model for improving performance of the Model.
• Involved in Performance Tuning Deployment of Cognos Reports
• Worked on SQL server
• Developed reports using various functionalities like Drill through, Master Detail, Conditional Formatting, Conditional Blocks and multiple Prompts in Dash Boards.
• Created Models in Frame work manager. Created various filters and calculations in framework manager models
• Knowledge in Cognos BI 10
• Created Dashboards for a better understanding of the business performance metrics by using Business Insight Advance, Active Reports.
• Knowledge in designing, implementing logical data models
• Used Analysis studio to drill down on cubes and perform business analysis.
• Expert in Report Studio, Query Studio, Analysis Studio, power play, Event Studio, Metric Studio
• Used Cognos Connection to administer and scheduling reports to run at various intervals as well as the ReportNet Server.
• Worked on upgrading, installing and configuring IBM Cognos products is required
• Worked on relational database design and maintenance, data warehousing and SQL query languages.
• Bursting Reports and Multilingual Reports Using Report Studio.
• Provided day-to-day support for all COGNOS Report studio users.
• Communicated report development progress and issues to management and team members.
• Ensured compliance with standard software development practices, processes and enterprise standards
• Tested and validated the Report output against database to measure performance of reports.
• Managed Report Deployments from one Environment to another.

Environment:Cognos 10.1 BI Report Studio, Query Studio, Active Reports, Analysis Studio, Business Insight Advance, Framework Manager, Cognos Connection, Cognos Power Play, Cognos Transformer, Cognos SDK, Access, Excel, MSSQL 2008, SSIS

Confidential

Cognos BI Developer/Analyst

Responsibilities:

• Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various business's needs Folders, Filters, and Macros
• Design and Developed the Framework manager models using Store procedures, Relational tables, Viewsand published in to server.
• Knowledge in Cognos BI 10
• Knowledge in designing, implementing logical data models
• Performed Cognos administrative tasks including security, user accounts, data migration, configuration
• Designed Reports using most of the Report studio features Conditional Formatting, Conditional Page layout, Sections, page Breaks, Master-detail, Drill Through,Drill Down ,Drill Up .
• Worked on SQL server
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Deliver advanced/ complex reporting solutions such as Dashboards and Standardized Reporting including the bursting of reports using Cognos.
• Worked on upgrading, installing and configuring IBM Cognos products is required
• Expert in Cognos BI Administration
• Expert in Report Studio, Query Studio, Analysis Studio, power play, Event Studio, Metric Studio.
• Worked on relational database design and maintenance, data warehousing and SQL query languages.
• Created complex Dashboards withArea charts, Pie charts, Cross tabs and Multi prompts in Report Studio
• Used Analysis studio to drill down on cubes and perform business analysis
• Created Models in Frame work manager. Created various filters and calculations in framework manager models
• Expert in Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio
• Created prompts, Calculations, Filters, Developing Prompt pages and Conditional Variables using Report Studio.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Provided day-to-day support for all COGNOS Report studio users.
• Assist in end user acceptance testing.
• Worked on complex reports using Tabular Objects, Static Prompt conditions

Environment:Cognos 10.1 BI Report Studio, Query Studio, Active Reports, Analysis Studio, Framework Manager, Cognos Connection, Cognos Power Play, Cognos Transformer, Cognos SDK, Access, Excel, MSSQL 2008, SSIS

Confidential

Cognos Developer

Responsibilities:

• Actively involved with the business users and Development teams for gathering information for creating the Framework Model.
• Designed the Model according to the Business Requirements by creating a Presentation Layer.
• Worked extensively on creating the Model and publishing the package on Cognos Connection for Reporting purposes.
• Knowledge in designing, implementing logical data models
• Performed Cognos administrative tasks including security, user accounts, data migration, configuration
• Created Embedded/Standalone Filters within the Model for improving the performance of the Model
• Created Cube for Multidimensional analysis for BI Analytics Department for quick approach to drill-down and drill-up through various levels of data.
• Worked on SQL server
• Expert in Cognos BI Administration
• Developed Standard Reports, Charts, Drill-Through Reports, and Master Detail Reports using Report Studio.
• Developed Dashboard reports in Business Insight, Business Insight Advance and Active Reports.
• Created Query Prompts, calculations, Conditions Filters.
• Worked on upgrading, installing and configuring IBM Cognos products is required
• Developed Multi Page Reports.
• Knowledge in Cognos BI 10
• Expert in Report Studio, Query Studio, Analysis Studio, power play, Event Studio, Metric Studio
• Worked on relational database design and maintenance, data warehousing and SQL query languages.
• Developed Prompt pages and Conditional Variables.
• Created Models in Frame work manager. Created various filters and calculations in framework manager models
• Trained Users on Query Studio for Ad-Hoc Reporting.
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Created views in the SQL Database for complex reports.

Environment: Cognos 8.4 BI Suite, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis Studio, SAP BW, MS SQL Server 2005, Oracle 10g, Microsoft Access, Microsoft Excel.

Confidential

Cognos Developer

Responsibilities:

• Set-up, maintain, monitor, and support Cognos security groups and accounts.
• Created Various Complex and Simple Impromptu Reports and published reports to Upfront. Involved in Creation of Simple Reports using Cognos Query.
• Created various Cubes in Power Play Transformer and created various reports related to Cubes in Analysis Studio and Cognos Power Play.
• Created Models in Frame work manager. Created various filters and calculations in framework manager models.
• Knowledge in designing, implementing logical data models
• Knowledge in Cognos BI 10
• Worked on relational database design and maintenance data warehousing and SQL query languages
• Expert Migrating catalogs into report net using migration utility.
• Worked on SQL server
• Expert in Report Studio, Query Studio, Analysis Studio, power play, Event Studio, Metric Studio
• Performed Cognos administrative tasks including security, user accounts, data migration, configuration
• Expert in Migration of Impromptu Reportset to Cognos ReportStudio
• Worked on upgrading, installing and configuring IBM Cognos products is required
• Worked on Security permissions in Cognos Connection portal at Package Level, giving permissions to end users for report studio and query studio, Object Security at Frame work Manager Level.
• Scheduled Reports using Scheduling Management. Configured Email Server Information at Production and Development Servers.
• Expert in Cognos BI Administration
• Deployed Models and reports from Development Server to Production Server using Content Administration.
• Improved Performance of Reports and Trouble Shooting of various issues at Servers, Cognos Connection Portal and reports.
• Used Data Stage to Perform ETL process.

Environment: Cognos8 BI MR2, Toad 9.0.1.8, Oracle 9i, Cognos Series 7 Version 2, Impromptu 7, Power Play 7, Access Manager 7, Data Stage

Confidential

Cognos BI ReportNet Developer

Responsibilities:

• Involved in Installing and Configuring ReportNet Server, FrameWork Manager.
• Configured Cognos8 with Cognos 7 series Namespace to integrate security.
• Involved in understanding the Business in all Departments.
• Worked on SQL server
• Involved in Strategic Planning for Cognos ReportNet Framework Model.
• Worked on upgrading, installing and configuring IBM Cognos products is required
• Built Models and published Packages utilizing Framework Manager.
• Created database connections for different data sources.
• Expert in Cognos BI Administration
• Knowledge in designing, implementing logical data models
• Expert in Report Studio, Query Studio, Analysis Studio, power play, Event Studio, Metric Studio
• Worked on relational database design and maintenance, data warehousing and SQL query languages
• Performed Cognos administrative tasks including security, user accounts, data migration, configuration
• Created Reports Simple Complex using QueryStudio and ReportStudio for training purpose.
• Knowledge in Cognos BI 10
• Created Models in Frame work manager. Created various filters and calculations in framework manager models
• Created, organized and formatted reports, folders and other contents on Cognos Connection portal.
• Involved with Scheduling and Distributing Reports through Schedule Management in Cognos Connection.

Environment: Cognos ReportNet 1.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Microsoft Access, Excel, Appworks, Oracle 9i, MS SQL Server 2005

Confidential

Responsibilities:

• Developed and design an e-commerce Business infrastructure with Software Development Lifecycle, supply chain issues, and managerial functions with strategic planning.
• Created Models in Frame work manager. Created various filters and calculations in framework manager models
• Knowledge in Cognos BI 10
• Created a research project on the avoidance of Network Downtime, Focus on bandwidth management and load balancing in corporate networks.
• Expert in Cognos BI Administration
• Worked on SQL server
• Expert in Report Studio, Query Studio, Analysis Studio, power play, Event Studio, Metric Studio
• Worked on relational database design and maintenance, data warehousing and SQL query languages
• Performed Cognos administrative tasks including security, user accounts, data migration, configuration
• Research material contained variety of devices including load balancers, and algorithms.
• Worked on upgrading, installing and configuring IBM Cognos products is required
• Troubleshoot and maintain software utilities and programs.
• Knowledge in designing, implementing logical data models
• Prepared internal and external reporting materials for Senior Management meetings.
• Developed reports, charts, and project schedules required to support the Planning and Scheduling Team work.

Environment:Microsoft Access, Excel, MS SQL Server 2000