SUMMARY:

• 8+ years of IT experience with expertise in Analysis, Design, Development, Customization and Implementation of various Software applications and generation of reports using various Databases.
• Over 5+ years of experience in Cognos OLTP/OLAP/Data Warehouse reporting tools.
• Good Hands on experience of Cognos 8 SDK.
• Well Experienced with the Metadata & Teradata modeling using the Framework Manager, Creating Reports, Models, Packages, Multilingual Packages.
• Highly proficient with Cognos 8, 10 (Framework Manager, Report Studio, Query Studio, Powerplay Studio and Analysis Studio).
• Expert in the development of Projects, Packages and Reports using ReportNet 1.1MR1, and ReportNet 1.1MR3, Cognos Connection, Framework Manager, ReportStudio and Query Studio.
• Experienced with upgrading ReportNet 1.1MR1, 1.1MR2/1.1MR3 to IBM Cognos 8.3/8.4.
• Designed Dashboard with multiple Tabs.
• Good working knowledge of data warehousing concepts and ETL
• Developed reports with ability to perform online sorting .
• Developed cube models in TM1 and creating TM1 scripts using Turbo Integrator.
• Created dimensions with hierarchies and attributes based on business requirements using TM1.
• Developed Reports that gives the user the ability to choose a column and then apply filter to it, using Stored Procedures in ReportStudio.
• Constructed Dynamic Reports that gives users the ability to choose the columns to be displayed on the report page using JavaScript code and HTML.
• Expert in Development of Conditional Blocking and Conditional Formatting Reports.
• Expert in Development of Drill through Reports.
• Redirecting Different Users to Different Databases using the Parameter Mapping Technique in the Framework Manager.
• Experienced with creating IQD’s in Framework Manager to Use in Cognos PowerPlay.
• Creating Bursting Reports using the Bursting table in ReportStudio.
• More than 4years of Experience in Cognos Suite, Cognos EP7 Series Impromptu, Cognos PowerPlay, Cognos Transformer, Cognos Impromptu Web Reports , Upfront, Power Play Enterprise Server and PowerPlay Web Reports , Cognos Visualizer, Access Manager.
• Expert in the development of Impromptu Drill through Reports.
• Well Experienced with customizing Impromptu catalogue by adding calculations and filters at the catalogue level.
• Experience migrating reports from ReportNet to Cognos 8
• Excellent Knowledge of Creating PowerPlay Transformer Models and Cubes.
• Good working knowledge of data warehousing concepts and ETL
• Strong understanding of relational database structures, dimensional data modeling DMR, and SQL
• Experienced with Multiple Relational Databases including Oracle7i/8i/9i, MS SQL Server, MS Access and DB2.
• Experienced in Designing of Multidimensional Architecture for ETL environment with Cognos.
• Strong Experience with Unix/Solaris and Windows 95/98/NT/XP.
• Advanced expertise in MS Excel spreadsheets.
• Excellent Communication Skills and a good team player.

TECHNICAL SKILL:

Cognos 10.1.1,,8.4, 8.3, 8.2, ReportNet 1.1MR3, 1.1MR1, Cognos Connection, Business Insight, Business Insight Advanced, Query Studio, Report Studio, Analysis Studio, PowerPlay Studio, Framework Manager, Map Manager, Cognos PowerPlay Transformer 8.4, 8.3, 7.4, Macro Script Editor, Cognos EP Series Impromptu, Upfront, IWR, Report Administration, PowerPlay Web, Oracle 10g/9i, SQL Server 2000/7.0, DB2, Teradata, MS Access, C, C++, SQL, JavaScript, HTML, Window 95/98/2000/NT4.0/XP, UNIX (Sun and HP).

PROFESSIONAL EXPERIENCE:

Confidential, Raritan, NJ.

Senior Cognos Developer

Responsibilities:

• Involved in the entire project life cycle from evaluation, installation, and development, testing to production of end user reports.
• Participated in gathering requirements from the end users.
• Working with clients one to one to understand the Requirements.
• Designed URS (User Requirement Specification), FRS (Functional Requirement Specification) and SDS (System Design Specification) Documents.
• Responsible for cube update, load using scripts in TM1 Turbo Integrator .
• Creating Reports in Report Studio, Query Studio with TM1 Cube as data source.
• Developed Model Design Document by referring to the Requirements.
• Created Report Design Documents .
• Worked with multi - dimensional sources by importing them in the Framework model and creating Reports out of it.
• D esigned star schema and dimensional model using Framework manager .
• Dimensional Modeling using Relational Data Sources in Cognos8.
• Development of Framework Manager Model considering the underlying database schema model and the reporting requirements.
• Developing cube models in TM1 and creating TM1 scripts using Turbo Integrator.
• Designed and developed the multi-dimensional model using Power play Transformer .
• Build and Published the Cubes to Cognos 8 connection.
• Worked in all phases of the software development lifecycle, with an emphasis on requirements elicitation, documentation, and communication.
• Working with TM1 Cube data using Data Slices and data Snapshots.
• Externalizing the Query Subjects to create IQD’s in Framework Manager.
• Coordinated with database team to create Stored Procedures for a set of reports, which invoke Stored Procedure, to get executed and return the required result set.
• Created joins, unions and calculated query items in the model to meet the requirements.
• Define the Macros for the Stored Procedures and test the procedures in Framework Model.
• Creating dimensions with hierarchies and attributes based on business requirements using TM1.
• Defined the usage properties, cardinalities and filters for the query subjects in Framework Manager .
• Created and published the Packages to the Cognos connection .
• Developed Simple and Complex reports using Report Studio and Analysis Studio .
• Developed more complex reports using Report Studio.
• Used JavaScript code to copy the prompt values from value Prompt to the Textbox Prompt with concatenating the values separated by commas in order to pass as a single String to database.
• Added HTML button on the report in order hide and show the List and Crosstab reports.
• Added some more tabs to the Portal and replace the default messages from the portal with the Client specific.
• Involved in writing of System Scripts to the reports for the testing.
• Participated in peer-to-peer testing of reports.
• Participated in Team Reviews and Status.
• Testing the reports generated with the database for correctness of data by writing SQL Queries.
• Prepared Installation Qualification Document.
• Deployed from Development to Staging and from Staging to Production using Deployment Import and Export method.
• Done QA testing of Cognos 8 reports.
• Participated in the Knowledge Transfer Sessions.

Environment: Cognos 8.4, Cognos 10.1.1 , TM1 Cubes, TM1 10.1.1, Report Studio , Query Studio, Analysis Studio, Cognos Framework Manager , Power Play Transformer , JavaScript, HTML, Oracle9i/10g,Teradata, PL/SQL Developer, Toad, Windows NT and Windows 2000.

Confidential, Berkley Heights, NJ.

Cognos Sr. Developer

Responsibilities:

• Involved in the entire project life cycle from evaluation, installation, and development, testing to production of end user reports.
• Participated in gathering requirements from the end users.
• Working with clients one to one to understand the Requirements.
• Designed URS (User Requirement Specification), FRS (Functional Requirement Specification) and SDS (System Design Specification) Documents.
• Developed Model Design Document by referring to the Requirements.
• Created Report Design Documents .
• Worked with multi-dimensional sources by importing them in the Framework model and creating Reports out of it.
• D esigned star schema and dimensional model using Framework manager .
• Dimensional Modeling using Relational Data Sources in Cognos8.
• Development of Framework Manager Model considering the underlying database schema model and the reporting requirements.
• Designed and developed the multi-dimensional model using Power play Transformer .
• Build and Published the Cubes to Cognos 8 connection.
• Worked in all phases of the software development lifecycle, with an emphasis on requirements elicitation, documentation, and communication.
• Externalizing the Query Subjects to create IQD’s in Framework Manager.
• Coordinated with database team to create Stored Procedures for a set of reports, which invoke Stored Procedure, to get executed and return the required result set.
• Created joins, unions and calculated query items in the model to meet the requirements.
• Define the Macros for the Stored Procedures and test the procedures in Framework Model.
• Defined the usage properties, cardinalities and filters for the query subjects in Framework Manager .
• Created and published the Packages to the Cognos connection .
• Developed Simple and Complex reports using Report Studio and Analysis Studio .
• Developed more complex reports using Report Studio.
• Creating Test Cases and writing SQL code to test the reports using Toad.
• Used JavaScript code to copy the prompt values from value Prompt to the Textbox Prompt with concatenating the values separated by commas in order to pass as a single String to database.
• Added HTML button on the report in order hide and show the List and Crosstab reports.
• Added some more tabs to the Portal and replace the default messages from the portal with the Client specific.
• Involved in writing of System Scripts to the reports for the testing.
• Participated in peer-to-peer testing of reports.
• Participated in Team Reviews and Status.
• Testing the reports generated with the database for correctness of data by writing SQL Queries.
• Prepared Installation Qualification Document.
• Deployed from Development to Staging and from Staging to Production using Deployment Import and Export method.
• Done QA testing of Cognos 8 reports.
• Participated in the Knowledge Transfer Sessions.

Environment: Cognos 8.2, 8.3, 8.4 Report Studio , Query Studio, Analysis Studio, Cognos Framework Manager , Power Play Transformer 8.2, 8.3, 8.4 , JavaScript, HTML, Oracle9i/10g,Teradata, PL/SQL Developer, Toad, Windows NT and Windows 2000/ 2003.

Confidential, NYC

Senior Cognos Developer

Responsibilities:

• Installation and configuration of Cognos 8 Report Studio and Framework Manager.
• Involved in the Requirement Gathering from end - users and design Business Requirement Documents.
• Design Star - Schema out of Report Requirement Documents.
• Developed Meta - Data Model using Framework Manager, Create and Publish Packages .
• Imports Tables, Views and Stored Procedures from Different Database Schemas.
• Created Joins , Unions and Calculations in the Model.
• Used Parameter Maps to select the Columns dynamically onto the report page with Prompts.
• Created Model Presentation Layer to be used by Adhoc users and Logical Layer to be used by Report Studio users.
• Scheduled various reports using Schedule Management used in Cognos Connection .
• Generate Views out of Reports and set different Parameters for each View.
• Created a Job to Run the views and Schedule the Job to Execute for Every week.
• Generated Reports with Conditional Blocking and Conditional Formatting.
• Developed reports with ability to perform online sorting.
• Created reports using JavaScript in which to sort the column when clicked on the header of the column.
• Developed Reports that gives the user the ability to choose a column and then apply filter on it, using stored procedure and report studio.
• Constructed Dynamic reports that give users the ability to choose the columns to be displayed on the report page.
• Created various IQD package in Framework Manager and from this IQD, integrated to PowerPlay Transformer to create various models and cubes.
• Did Bursting of Reports using Burst tables and Busted Cross tab Reports using Master - Detail Relationships Report Studio.
• Developed advanced reports using Report Studio and Adhoc reports using Query Studio.
• Integrated the existing security with Cognos 8 Security.
• Developed standard templates in Report Studio for developing reports.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Provided Training and End User Support with my report and also knowledge transfer.
• PowerPlay Reports.
• Created Multi-Dimensional reports using Power Play.
• Created power play models and cubes using Transformer (Power Play).
• Drill down , slice and dice and change displays.
• Converted Business requirements into RDD (Report Design Document) for Construction.

Environment: Cognos 8, Framework Manager, Query Studio, Report Studio, Cognos Connection, Content Manager, JavaScript , HTML, Windows 2003 server, SQL Server 2000 and Oracle 9i, SQL Server Management Studio. Toad for Oracle.

Confidential, AL

Cognos ReportNet, Cognos 8 BI Developer

Responsibilities:

• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports
• Generated Complex reports in Cognos 8 report studio including Drill Down reports from DMR modeled Framework model
• Created Dashboards to present critical company data in a single report
• Created list reports & cross tab reports Active reports by using Cognos 8.
• Distributed reports to various agents using Bursting.
• Upgraded reports from ReportNet to Cognos 8
• Used IIS(Internet information server) web server for configuration and management
• Migration of reports and catalogs from Cognos series ReportNet to Cognos 8
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used Union/Join objects in Report Studio
• Experience in developing Framework Manager Models and analyzed those models in analysis studio
• Gathered and analyzed business requirements from users and business community
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements
• Created Sophisticated Reports and Portal page Dashboard reports by using Report Studio
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports
• Developed Healthcare Complex Crosstab reports in Analysis studio
• Extensively worked with List Reports and various formats of report generation e.g., PDF, XML etc
• Monitoring Cube updates, monitoring the performance of the Power Play cubes, Star Schema, Snow Flaks Schemas
• Created 3 different reports that included report functionality such as prompt pages, cascading prompts, conditional filters, Power Play cubes etc

Environment: Cognos 8 BI, Cognos Connection, Cognos office Connection, Report Studio, Business Insight, Business insight Advance Query Studio, Analysis studio, Frame Work Manager, SQL,XML and Windows XP.

Confidential

Cognos Developer

Responsibilities:

• Involved in the entire project life cycle from evaluation, installation, and development, testing to production of end user reports.
• Participated in Requirements gathering.
• Designed star schema and dimensional model using Framework manager.
• Used Framework Manager in developing multi-tier metadata models including OLAP structures.
• Used Framework Manager to create query subjects from different sources and publish packages to the Cognos server.
• Created joins with queries in Report Studio to generate the required Report queries
• Used JavaScript and HTML in designing the reports with more usability.
• Coded conditional formatting to mask data that did not meet minimum requirements and patient information that was not to be revealed to all users.
• Analyzed and optimized native queries generated by Cognos during report generation.
• Designed and configured Cognos security framework.
• Created Multidimensional reports in Analysis Studio to compare physician performance.
• Used Event Studio to effectively create and manage agents.
• Created Export Archives to deploy reports and packages from development to test environment.
• Troubleshooting and tuning of existing reports.
• Developed PL/SQL stored procedures and functions for measure calculation using PL/SQL Developer
• Documented functional and technical designs and user guides.

Environment: Cognos ReportNet, Cognos EP Series 7.3(PowerPlay, Transformer, Upfront, Access Manager, PowerPlay Enterprise Server (PPES), ReportNet 1.1, Informatica 7.1, JavaScript, HTML, Oracle9i, Windows NT.

Confidential, IL Aug

Cognos Developer

Responsibilities:

• Gathered and analyzed business requirements from users and business community.
• Developing Framework Manager Models and analyzed those models in analysis studio.
• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.
• Generated Complex reports in Cognos report studio including Drill Down reports from DMR modeled Frame work model.
• Created Dashboards to present critical company data in a single report.
• Created list reports & cross tab reports using Cognos.
• Upgraded reports from MR1 to MR3.
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Created Sophisticated Reports using Report Studio.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Converted reports from Micro-strategy to Cognos
• Designed URS (User Requirement Specification), FRS (Functional Requirement Specification, SDS (System Design Specification) and Report Design Documents.
• Designed star schema and dimensional model using Framework manager.
• Dimensional Modeling using Relational Data Sources in Cognos.
• Development of Framework Manager Model considering the underlying database schema model and the reporting requirements.
• Designed and configured Cognos security framework.
• Externalizing the Query Subjects to create IQD’s.
• Involved in writing of System Scripts to the reports for the testing.
• Participated in peer-to-peer testing of reports.
• Participated in Team Reviews and Status.
• Testing the reports generated with the database for correctness of data by writing SQL Queries.
• Prepared Installation Qualification Document.

Environment: ReportNet 1.1MR3, ReportNet 1.1MR1, Framework Manager, Query Studio, Report Studio, Cognos Connection, Content Manager, Cognos Connection, Content Manager, Cognos EP Series 7.3 Impromptu 7.3, Cognos PowerPlay 7.3, Cognos Transformer 7.3, PowerPlay Enterprise Server, JavaScript, HTML, Windows 2003 Sever. SQL Server 2000 and DB2.