SUMMARY:

• Eight years Experience in analysis, design, development of Data warehousing applications using with Cognos and strong Business knowledge of Retail, Financial, Pharmaceutical and communication projects and implementing the complex business rules into systems that helps an organizational upgrades to the best of my capabilities.
• Excellent knowledge and over Five years of working experience with Cognos tools - Cognos 10.x, Cognos 8.x, Report Net v1.1 MR2, Active Report, Workspace, Workspace Advance, Impromptu, Power play, Impromptu Web Reports (IWR), Power Play Enterprise Server (PPES), Power Prompts, Macros, Upfront, Notice Cast, Access Manager, Visualizer, Cognos Query and Architect.
• Experienced in Installation, Configuration, Monitoring the Cognos 10.x,8.x, Cognos Report net and impromptu on Windows platforms.
• Experienced in Designing, Creating and Maintaining Models and Cubes in Framework Manager, Report Net and Power Play Transformer, Catalogs in Impromptu.
• Thoroughly documented the steps, provided production support and training to end-users for Cognos Report net, Power Play and Impromptu modules.
• Self-motivated and possess excellent critical thinking ability, good interpersonal and communication skills.

TECHNICAL SKILLS

BI Suite: Cognos 10.x,8.xCognos 6.x/7.x (Impromptu, Power Play, Transformer, Architect, Access Manager, IWR, Upfront, PP Enterprise Server), Report Net 1.1 MR2 (Framework Manager, Cognos Connection, Cognos Configuration, Report Net Report\Query Studio).

Database: MS SQL Server 2008, DB2, Oracle8i/9i/10g/11g, Netezza

DB Tools & Utilities: SQL*Loader, TOAD.

Operating Systems: Windows 98/NT/ 2003/2008

Reporting Tools: Tableau, Escalate Reports, Retail Ideas, Crystal Reports

Web/App Servers: IIS 7.0, Java Web Server2.0, IBM Web Sphere, Web logic

PROFESSIONAL EXPERIENCE:

Confidential, PA

BI Cognos System Engineer

Roles & Responsibilities:

• I am involved in gathering the report specifications by interacting with the users.
• I analyzed the data requirements in order to develop the reports by interacting with the users from time to time.
• Prepared proper documentation and gathered report specifications in order to develop new reports and also to enhance the existing reports.
• Have interacted with the users and enhanced the reports from time to time to meet the user demands.
• Created new Query Subjects and arranged in different Folder Structure for Business View in Framework Manager.
• Modified the existing model by adding required query items, query subjects and model filters to meet the report specifications.
• Used Parameter maps in FM to create Global filter.
• Published Packages to Cognos Connection for report development using Report Studio and Query Studio.
• Build Dashboards Using Workspace and Workspace Advance, Created Active Reports using Report Studio.
• Created List Reports, Cross-tab Reports, Chart Reports and Master Detail Reports using Report Studio.
• Created Ad-Hoc reports using Query Studio.
• Created Multi Page Reports based on Master queries to show the data on different pages when the master record changes in the report.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Created List reports, Group reports and Cross tab Reports with drill through functionalities.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Deployed individual reports from Development environment to Production environment using Import and Export in Cognos Connection.
• Developed detail and summary Reports for drill through functionality.
• Used Governors settings to limit retrieval of large text items, limit the number of records to control the number of rows a user can retrieve, to limit the number of tables a user can retrieve in a report and to limit the query execution time for different User groups.
• Experience in creating reports using drill-through and drill down functionalities.
• Created Power Cubes using Power play Transformer from different Data sources and IQD.
• Involved in Graphical presentations like Pie chart, Bar charts were created for analysis and statistical information.

Environment: Cognos 10.x,8.x,CRN 1.1 MR3,Cognos Series 7(Imp 7.3, Upfront, PP 7.3, PPES, Access Manager), SQL Server, Oracle 11g, Netezza, Active directory server.

Confidential, NJ

Cognos Developer

Roles & Responsibilities:

• I am involved in building and maintaining the FM model in Framework Manager, by gathering the requirements from end users and database administrator to support the reporting requirements. Involved in projects from the proposal phase through project completion.
• Create Model to best standards by creating various joins between query subjects and also resolved parallel joins, ambiguous joins and recursive joins between them.
• Create model query subjects, data source query subjects, various embedded calculations and filters to meet the reporting requirements in the Model.
• Published the Model to Cognos Connection.
• Set the Security in Cognos Connection for various users limiting them access to Query studio, Report studio, Consumers.
• Develop various complex Reports using Child tabular models and Tabular SQL.
• Create multiple page reports and used various prompts and conditional blocks to meet the report specifications.
• Create some complex calculations in Report studio and developed some ad-hoc reports in Query studio.
• Involved in configuring multiple server installation for test environment.
• Tested the reports to meet the user requirements and resolved any issues.

Environment: Cognos 10.x,8.x,Cognos Series 7(Imp 7.3, Upfront, PP 7.3, PPES, Access Manager), SQL Server, Oracle 9i, Active directory server.

Confidential, NJ

Report Developer

Roles & Responsibilities:

• Develop various complex Reports using Child tabular models and Tabular SQL.
• Create multiple page reports and used various prompts and conditional blocks to meet the report specifications.
• Create some complex calculations in Report studio and developed some ad-hoc reports in Query studio.
• Involved in configuring multiple server installation for test environment.
• Deployed the Package from development to test environment.
• Tested the reports to meet the user requirements and resolved any issues.
• Environment: Cognos 8.x, SQL Server, Active directory Server.

Confidential, NJ

Cognos Data Modeler/Report Net Developer

Roles & Responsibilities:

• I am involved in building and maintaining the FM model in Framework Manager, by gathering the requirements from end users and database administrator to support the reporting requirements. Involved in projects from the proposal phase through project completion.
• Create Model to best standards by creating various joins between query subjects and also resolved parallel joins, ambiguous joins and recursive joins between them.
• Create model query subjects, data source query subjects, various embedded calculations and filters to meet the reporting requirements in the Model.
• Published the Model to Cognos Connection.
• Set the Security using Series7 and provided Single Sign-on.
• Develop catalogs with Impromptu administrator for use with Cognos impromptu reports and Impromptu web reports and Power Play cubes. Assist users in setting up and accessing reports.
• Set the Security in Cognos Connection for various users limiting them access to Query studio, Report studio, Consumers.
• Develop various complex Reports using Child tabular models and Tabular SQL.
• Create multiple page reports and used various prompts and conditional blocks to meet the report specifications.
• Create some complex calculations in Report studio and developed some ad-hoc reports in Query studio.
• Involved in configuring multiple server installation for test environment.
• Deployed the Package from development to test environment.
• Tested the reports to meet the user requirements and resolved any issues.
• Also supported existing Impromptu Reports by doing some enhancement and worked on Cubes to meet specific requirements of the user.

Environment: Report Net 1.1 MR2, Cognos Series 7(Imp 7.3, Upfront, PP 7.3, PPES, Access Manager), SQL Server, Active directory server.

Confidential, PA

Cognos/ReportNet developer

Responsibilities:

• I was involved in gathering the report specifications by interacting with the users.
• I analyzed the data requirements in order to develop the reports by interacting with the users from time to time.
• Prepared proper documentation and gathered report specifications in order to develop new reports and also to enhance the existing reports.
• Had interacted with the users and enhanced the reports from time to time to meet the user demands.
• Migrated several existing Cognos Impromptu Catalogs into XML files and imported the XML files as data sources into Cognos Report Net.
• Created new Query Subjects and arranged in different Folder Structure for Business View in Framework Manager.
• Modified the existing model by adding required query items, query subjects and model filters to meet the report specifications.
• Published Packages to Cognos Connection for report development using Report Studio and Query Studio.
• Created List Reports, Cross-tab Reports, Chart Reports and Master Detail Reports using Report Studio.
• Created Ad-Hoc reports using Query Studio.
• Created Multi Page Reports based on Master queries to show the data on different pages when the master record changes in the report.
• Created Query Prompts, Calculations, Conditions and Filters in the reports.
• Developed Prompt Pages and Cascaded input Prompts to display only the selected entrees in the report.
• Created List reports, Group reports and Cross tab Reports with drill through functionalities.
• Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Deployed individual reports from Development environment to Production environment using Import and Export in Cognos Connection.
• Developed detail and summary Reports in both Imp 7.3.
• Used Governors settings to limit retrieval of large text items, limit the number of records to control the number of rows a user can retrieve, to limit the number of tables a user can retrieve in a report and to limit the query execution time for different User Classes.
• Has used various Prompts like File pick list, Catalog pick list, and Report pick list in developing the Reports.
• Created Catalogs, Organizing folders, Calculations, Conditions, Prompts using Impromptu administrator.
• Published Impromptu Web Reports and Power Play Multi Dimensional Cubes to upfront using Cognos Server Administration.
• Responsible for Scheduling Impromptu Web Reports as per users Requirements and other ad hoc basis.
• Experience in creating reports using drill-through and drill down functionalities.
• Automated tasks using Cognos Scheduler, Macros and Cognos Script Editor.
• Created Power Cubes using Power play Transformer from different Data sources and IQD.
• Involved in Graphical presentations like Pie chart, Bar charts were created for analysis and statistical information.

Environment: Cognos Report Net 1.1, Cognos Impromptu 7.3, Cognos Power Play, Cognos Transformer, Enterprise Server, Access Manager, Oracle 9i.