PROFESSIONAL PROFILE:

Having 8 years of experience in Business Intelligence and DWH/Database Applications on multiple domains. Strong abilities and Hands on experience in analysis, design, testing, development and implementation of client/server and web applications.

• Having 8 years of experience with Cognos Tools such as Cognos 8.4/8.3/8.2 Suite, Cognos Reportnet 1.1.MR3, Cognos Impromptu 7.x, Cognos IWR 7.x and Analysis Tools such as Cognos Transformer & Power Play 7.x, Access Manager and Server Installation & Maintenance.
• Knowledge on Cognos 10 BI.
• Developed logical models providing Business Relations implementing to Starschema and Snowflake schema concepts.
• Knowledge on ETL tools such as Informatica, Data stage, SSIS.
• Hands on Experience with Framework Manager Modelling (DMR and Relational) and Complex Report building with Report Studio.
• Expertise in Developing reports using Query Studio, Report Studio and Analysis Studio.
• Experience with Cognos Software Development Kit (SDK).
• Expertise in working with Transformer model and Building Power play cube.
• Writing PL/SQL Stored procedures as per the reporting requirements.
• Excellent Team Coordinating Skills with the Development Teams and Deliverable dates.
• Expertise in developing Database Schemas such as Star Schema and Snowflake Schema, which are used in relational, dimensional and multidimensional modelling.
• Experience in various industry sectors such as Insurance, Healthcare, Pharmaceutical, Telecom and Manufacturing.
• Strong Experience on Installation & Configuring the Cognos 8.4 BI Environment.
• Expertise in Upgrading from previous versions of Cognos 8 to Cognos 8.4.
• Sound Skills in SQL Scripts using Oracle, SQL Server 2005.
• Strong problem solving skills, ability to develop strategies for clients, and provide detailed documents to clients.
• Working experience in OLAP analysis and cube development.
• Extensive experience in Multiple Relational Databases including SQL SERVER, ORACLE.
• Strong knowledge on Installation & Configuring the Cognos 8/7i tools in distributed Environments on windows/Unix.
• Implemented Security using Third Party LDAP sources (Sun One, Tivoli) and Cognos Access Manager.
• Deploying Models and reports from Staging to Production and administering users/groups/roles.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.
• Excellent Team coordinating Skills with the Development Team and Deliverable dates.
• Excellent team player at all levels with ability to perform independently. Exceptional communication, analytical, presentation and problem solving skills.

Proficient at developing and implementing training programs to enhance the efficiency, competency and motivation levels of the employees in line with organizational objectives. A keen communicator with problem solving & analytical abilities.

TECHNICAL STACK

Operating Systems : Windows 2003 Enterprise Server, XP, 2000, UNIX
Databases : SQL Server2005, Oracle 9i/10g.
Cognos Tools : Cognos 8.4 Suite, Cognos 8.3 Suite, Cognos 8.2 Suite, CRN 1.1 MR3, Cognos EP Series 6.3 (Power play Transformer, Power play Windows/Web, Impromptu, Upfront, Metric Manager, Metric Studio, Event Studio), Cognos Access Manager, SDK
Servers : Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

Cognos Certifications:

• IBM Cognos 8 BI Professional Certification Program.

Education:

• Bachelor of Technology, Electrical and Electronics Engineering.

EXPERIENCE DETAILS

Confidential,
Parsippany, NJ Dec 09 – Till Date
Sr. Cognos Developer
Responsibilities:

• Installing & Configuring the Cognos 8.4 on windows Environment.
• Worked closely with Business users to understand and analyze business requirements.
• Developed Specification and Design documents based on Mainframe reports.
• Creating the Relational Model using Cognos Framework Manager.
• Import the database objects to the Framework manager model and set the cardinality between them as per the business requirements.
• Created Business View and Import View, defining appropriate relationship between dimensions and Fact Table in Framework Manager.
• Developing the List Reports, Cross tab Reports, Drill through Reports Using Report Studio and Query Studio.
• Developed complex reports using Dynamic Grouping in Report Studio.
• Adding business rules by defining different kinds of calculations and filter.
• Creating Users, Groups and Roles and assigning the permissions.
• Administering the Cognos portal using the user security.
• Applying the security to display Objects based on the user security.
• Unit testing and system testing of the reports in Development and test environments.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Provided high-level technical support for both immediate and long term issues.
• Scheduling the reports using Cognos SDK.
• Lead the team to automate existing manual reporting using Cognos as well as develop new reports.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Cognos 8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, SDK), Cognos Access Manger, SQL Server 2005, SSIS, Windows 2003 Server.

Confidential,
Wilkes-Barre,PA Apr 08 – Nov 09
Sr. Cognos Consultant
Responsibilities:

• Installing & Configuring the Cognos 8.3 on windows Environment.
• Upgraded the Cognos 8.3 to Cognos 8.4.
• Worked closely with Clients and Business users to understand and analyze business requirements and creating the Framework manger model.
• Designing the logical model that conforms to star schema concepts, different views (import, business, external) as per Business requirement.
• Working with the confirmed dimensions.
• Creating the Determinants for the imported materialized views.
• Import the database objects to the Framework manager model and set the cardinality between them as per the business requirements.
• Created Business layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Developing the List Reports, Drill Through Reports, Master Detail Reports and Multilingual Reports Using Report Studio and Query Studio.
• Scheduling the Cognos Reports using the Cognos SDK.
• Developed complex reports which involved Multiple Prompts in Report Studio.
• Adding business rules by defining different kinds of calculations and filter.
• Creating the Bar charts and list reports using Cognos Report Studio and Analysis studio.
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Deploying the reports and package from Development to testing, Testing to Production environments.
• Administering the cognos packages using the user security.
• Publishing the powerplay cubes to the cognos server using the framework manager model.
• Creating the reports using Report Studio and Analysis Studio for the powerplay cubes.
• Created new page in the cognos connection and embedded the different reports in the same page.
• Applying the security to display data based on the user security.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Trained Users on Query Studio for Ad-Hoc Reporting.

Environment: Cognos 8.4 Suite/Cognos 8.3 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), Power Play Transformer 8.4, Cognos Access Manger, Oracle 10g, Windows 2003 Server, Cognos SDK.

Confidential,
IL (Offshore from HCL) Oct 07 – Jan 08 Cognos Consultant
Responsibilities:

• Worked closely with Clients and Business users to understand and analyze business requirements and participated in requirements gathering.
• Developed Technical specifications, data identification and also recommendations on the preferred solution for development and deploy efficient BI solutions.
• Developed Report specifications based on Siebel Analytics Reports.
• Installing and configuring the Cognos 8.2 on Windows Environment.
• Creating the DMR (dimensional model) using the Frame Work Manager.
• Ensuring clear query paths by resolving ambiguous relationships.
• Analyzed and defined joins to build Framework Manager Models and Packages.
• Added Business rules and Security to the package and Published the package to the Cognos ReportNet server
• Developed Dash Board reports in Report Studio.
• Administer Security in Reports based on the user role.
• Performance Tuning and load balancing of complex reports.
• Writing the SQL scripts as per the business requirements.
• Writing the PL/SQL Procedures as per the requirements.
• Dimensional Modelling of 8BI Packages.
• Creation of OLAP Transformer Cubes from IQD’s /Cognos Connection Package.
• Customizing user class security views in Cube by user classes / Roles.
• Batch script automation for Power Cube refresh.
• Reporting Powerplay cubes in Analysis Studio and Conditional formatting of Cube Reports in Report Studio 8.
• Developed the reports using analysis studio.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Testing the reports in SIT (System Integration testing) and UAT (User Acceptance testing).
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Environment: Cognos 8.2 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio, Metric Studio), Cognos Access Manger, Windows 2003 Server, SQL Server2005, Tomcat/Apache,

Confidential,
UK (Offshore from Cognizant)
EDMR Cognos Wave 3 Mar 07 – Oct 07
Cognos Consultant
Responsibilities:

• Designed models using Framework Manager and deployed packages to the Report Net Servers
• Implemented Framework manager security for Data access, Object level access and Package access.
• Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager. Model.
• Created Dashboard reports using the Cognos Report Studio and Metric Studio.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Extensively worked on Analysis Studio to develop multi dimensional reporting.
• Writing the Batch script to update the cube on daily basis.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Moved Packages and reports from development to QA and then Production servers.
• Developed Power Play Reports based on the cubes and published to Report Net Server.
• Deployed Cognos OLAP Cube from Testing Environment to Production Environment using Batch script.
• Involved in writing Stored Procedures and functions in Oracle PLSQL.
• Trained the end users effectively to use the reporting tool, to build and customize their ad-hoc reports.

Environment: Cognos 8 BI, Cognos 8BI Report Net, Framework Manager , Oracle 9i , Report Studio ,Transformer 7.3, Analysis Studio , Cognos XML, Generic/Cognos JavaScript, BATCH SCRIPT.

Confidential,
UK (Offshore from Cognizant)
EDMR Cognos Wave 1 & 2 July 06 – Mar 07
Cognos Consultant
Responsibilities:

• Involved in designing data model and report design.
• Understanding functional specification and preparing technical spec.
• Created reportnet models, queries according to standards
• Build Import and Business Views in Framework Manager Model.
• Added Business rules and Security to the package and Published the package to the Cognos Report Net server
• Created the user roles in cognos connection.
• Created the Dashboard reports using Report Studio.
• Authoring reports in report studio according to requirement by implementing many features like prompts, conditional formatting.
• Developed the Cognos OLAP cube using the Powerplay Transformer.
• Designed transformer model (dimension map, facts (regular/calculated)).
• Created batch files (macros) to refresh the cube monthly.
• Deployed the cube from Testing Environment to Production Environment using Batch script.
• Writing the test cases for SIT (System Integration testing) and UAT (User Acceptance testing).
• Testing experience in SIT (System Integration testing) and UAT (User Acceptance testing).
• Prepared Multi lingual application design document using HTML DB.
• Developed Multi lingual application using HTML DB.

Environment: Cognos Report Net 1.1, Framework Manager 1.1, Cognos Report Studio 1.1 DB2.0, Report Studio ,Transformer 7.3, Cognos XML, Generic/Cognos JavaScript, BATCH SCRIPT,SQL Server 2000

Confidential,
CA (Offshore from Techysoft) May 04 - June 06
Cognos Consultant

• Published the customer authored, requested Cognos OLAP reports to upfront
• Published the Impromptu reports to upfront by creating new reportset.
• Granting and revoking IWR report access to user classes from IWR-Report Administration and Upfront
• Monitoring weekly scheduled IWR reports in upfront and IWR-Server Administration
• Filtering cubes and building new cubes (Time Based partitioned) during year end.
• Installing and configuring Cognos applications (Impromptu, Powerplay) on Citrix servers and desktops remotely.
• Grant and revoke access to Powerplay and IWR reports in upfront.
• Monitoring Cognos (PPES, Upfront and Report server) services.
• Access manager administrator (adding users, user signon, user membership, user’s datasource access).
• Resolving reports (Impromptu, Powerplay and Reportnet) data discrepancy issues.

Environment: Cognos Powerplay 6.3, Transformer 6.3, Powerplay Enterprise Server, Upfront, Impromptu Administrator 6.3, Access Manager, Oracle