SUMMARY

• Having 8 years of experience in Analysis, Design and Development of Business Intelligence Projects and software development life cycle (SDLC).
• Strong knowledge and experience in OLAP tools such as Cognos Series 7 and Cognos
• 10/8.4 /8.3 and experience with ETL tools like Informatica 9.5.
• Expertise on a range of Data Warehousing products such as: Cognos 8 BI, Cognos Report Net, Impromptu, Impromptu Web Reports, OLAP cube development using Cognos Power Play and Transformer, and implementing security using Cognos Access Manager.
• ETL development utilizing Informatica Power Center (Designer, Repository Manager, Workflow Manager, and Workflow Monitor), Oracle 11g/10g/9i, PL/SQL and SQL. Extensive experience in BI Modeling/Report Authoring using Cognos 10.2/8X Suite, Cognos Report net 1.1, Cognos EP Series 7.1/7.2/7.3 .
• Sound knowledge on reporting using Cognos 10.2/8.4 Report Studio.
• Strong Experience with developing Framework Manager models (Layers Architecture, security, IQDS - Sources of Transformer, Packages).
• Strong experience in Developing IQD’s (Multidimensional sources) using SQL.
• Strong Skills in developing multidimensional models in Power play Transformer and building cubes, Implementing Security, Cube Groups, Views.
• Design, develop and maintain Cognos Reporting solutions and Power Play (OLAP cube reporting) both for client and web versions of software.
• Implemented Security using Cognos Access Manager, Directory Server and Active Directory.
• Deploying models and reports from Staging to Production and administering users/groups/roles.
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes.
• Experienced with migration of Cognos code (reports/models/ frameworks) from one environment to another and Installation of migration utilities imcat2xml, migtoc8 and migde ploy.
• Experience with multitiered BI environment and experience with Cognos Go Dashboard.
• Sound Skills on Developing Score Card Applications using Metric Manger and Metric Studio.
• Creation of Relational and DMR models using Framework manager.
• Experienced with Multiple Relational Databases including Oracle, Teradata, MS SQL Server and DB2.
• Excellent knowledge on data warehousing concepts Star schema, Snowflake Schema and worked on both OLAP and OLTP databases.
• Excellent communication and interpersonal skills. Ability to work effectively in a team as well as individually.

TECHNICAL SKILLS

Business Intelligence Tools: Cognos 10.2 (Framework manager, Cognos Connection, Report Studio, Query StudioAnalysis Studio, Dynamic Cubes, Power playWorkspace, Workspace advanced, TransformerScheduler, Portal Administration),Cognos SDK, Cognos Report Net 1.1(Framework Manager, Report Studio, Query Studio)Cognos8.X, Cognos EP 7 series (ImpromptuPower play, Upfront, transformer, Access Manager, Report Administration).

RDBMS: Oracle 11g/10g/9i, MS SQL Server2008/2005,DB2 and MS Access, Teradata 13/15.

ETL Tools: Informatica 9.5

Programming Languages: C, C++, Java, SQL, PL/SQL

Web / Scripting: HTML, JSP XML, Java Script

Operating Systems: Windows 95/98/2000 Server, XP, NT, 2003 server and UNIX

Other Tools: SAS 9.4, Toad, SQL Developer, SQL Assistant.

PROFESSIONAL EXPERIENCE

Confidential, CO

Sr.Cognos Developer

Responsibilities:

• Design, develop, and support of the overall Cognos Framework report model.
• Developed and maintained existing SAS reporting while working on migration to Cognos.
• Design and develop Business Intelligence reporting solutions (reports).
• Developed Reports using Conditional Formatting and Cascading Prompts. Developed List, drill through, master detail, chart and complex reports which involved Multiple Prompts, Filters, multipage, multi query reports against multiple databases.
• Trained Business users on various Cognos BI tools.
• Created SAS reports to provide solutions in timely manner for data which is not available in database.
• Monitored adhoc analysis using SQL and performed dimensional analysis using MDX functions in Report Studio.
• Calculated measures and dimension members using MDX, statistical formulas, and other user defined functions for complex reports using Report Studio.
• Developed filters, calculations, prompts, conditions, and created various reports, using Report Studio for users.
• Worked with Teradata Database V13 and involved in ETL team discussions.
• Developed AdHoc Reports using Cognos Workspace Advanced, Query Studio, Active Reports using Report studio and Dash Board Reports using Cognos Workspace which is part of Cognos 10.2 suite.
• Developed portal tabs to show report on Cognos connection.
• Used bursting options and scheduled reports to run at a different time to send email to users.
• Worked on Cognos Reports in Excel and power point using Cognos Go Office and CAFE.
• Developed Multidimensional models (cubes) using Transformer.
• Developed models in framework manager and created reports to use them as source to transformer (to build cubes).
• Extensively worked on cube refreshing on monthly basis & worked on Data Validations.
• Collaborate with Data Architect/DBA to develop/optimize the Star schema model for the Cognos reporting tools (Power Play and Report Studio) and maintain optimal reporting tables and views within Cognos.
• Interacting with the IT team and End users on a regular basis for resolving issues pertaining to the reports.
• Develop and maintain technical documentation.
• Involved in deployment to UAT and Production.

Environment: Cognos 10.2 Suite (Cognos Connection, Framework Manger, Cognos Workspace advanced, Cognos Workspace, Report Studio, Query Studio, Analysis Studio), SAS 9.4, Teradata13, Power play cubes.

Confidential, CO

Sr. Cognos Developer

Responsibilities:

• Developed Standard and Dashboard Reports, Charts, Drill through Reports, Master Detail Reports and Burst Reports using Report Studio and Query Studio.
• Created Conditional Blocks, Filters and other prompts for dynamic selection for users
• Scheduled and Run Reports through Schedule Management in Cognos Connection Used SQL Server Management Tool to check the data in the database as compared to the requirement given.
• Developed Cognos Framework report model and reports as per the requirements.
• Involved in effort estimation based on the complexity of the business and the report design.
• Understand the security model and implemented the RowLevel Security according to the requirements.
• Developed and Published Packages in Framework Manager Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Worked with Relational Database MS SQL and involved in ETL team discussions.
• Worked with Global Drill through Definitions to drill through from analysis studio reports to report studio reports.
• Developed portal tabs to show report on Cognos connection.
• Used bursting options and scheduled reports to run at a different time to send email to users.
• Develop and maintain technical documentation.
• Developed Multidimensional models (cubes) using Transformer.
• Developed models in framework manager and created reports to use them as source to transformer (to build cubes).
• Worked on cube refreshing on weekly basis & validating the data.
• Developed work estimates for assigned tasks, assessed constraints and dependencies, escalate and resolve issues in a timely manner.

Environment: Cognos 10.2 Suite (Cognos Connection, Framework Manger, Cognos Workspace advanced, Cognos Workspace, Report Studio, Query Studio, Analysis Studio), Sql Server 2008,Power play cubes and Windows 2007 Server.

Confidential, WI

Cognos Developer

Responsibilities:

• Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Created various report types like list reports, cross tab, charts, Dashboards. that cover the entire range of enterprise reporting requirements.
• Schedule management - Daily, Weekly, Monthly, and Quarterly and Yearly reports.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Worked as Production support to the project been implemented.
• Developed and Published Packages in Framework Manager Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Developed Dash Board Reports using Cognos Workspace.
• Deployment of reports from Development to Production.
• Extensively worked on cube refreshing on monthly basis & worked on Data Validations.
• Production Support and Troubleshoot/Test issues with existing reports and cubes.
• Monitored adhoc analysis using SQL and performed dimensional analysis using MDX functions in Report Studio.
• Worked with Relational Databases Oracle and MS SQL and involved in ETL team discussions.
• Interacting with the Cognos support team and creating & following up the cases in the cognos support site.

Environment: Cognos 10.2 Suite (Cognos Connection, Framework Manger, Cognos Workspace advanced, Cognos Workspace, Report Studio, Query Studio, Analysis Studio), Sql Server 2008, Oracle 10g/11g, Power play cubes and Windows 2007 Server.

Confidential, CA

Cognos Developer

Responsibilities:

• Worked with Business Intelligence Team involving Upgrade of PeopleSoft version 8.8 to 9.1 and Cognos 8.3 to 8.4.1 and test the reports in different environments and resolving issues pertaining to the reports.
• Design and develop Business Intelligence reporting solutions (reports, cubes).
• Developed Standard and Dashboard Reports, Charts, Drill through Reports, Master Detail Reports and Burst Reports using Report Studio and Query Studio.
• Created Conditional Blocks, Filters and other prompts for dynamic selection for users
• Scheduled and Run Reports through Schedule Management in Cognos Connection
• Used SQL Server Management Tool to check the data in the database as compared to the requirement given.
• Trained users on Query Studio for AdHoc Reporting and involved in documentation.
• Creation of Dash Board Reports using Report studio MDX Functions and adding it to the portal page using HTML Items.
• Design, develop, and support of the overall Cognos Framework report model.
• Developed Multidimensional models (cubes) using Transformer.
• Developed models in framework manager and created iqd’s to use them as source to transformer (to build cubes).
• Extensively worked on cube refreshing on monthly basis & worked on Data Validations.
• Collaborate with Data Architect/DBA to develop/optimize the Star schema model for the Cognos reporting tools (Power Play and ReportNet) and maintain optimal reporting tables and views within Cognos.
• Developed work estimates for assigned tasks, assessed constraints and dependencies, escalate and resolve issues in a timely manner.
• Responsible for Lead testing efforts Ensure issues are identified, tracked, reported on and resolved in a timely manner Communicate needed changes to development team

Environment: Cognos 10.2/ 8.4.1 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), DB2,Oracle 10g/11g, Power play cubes and Window 2007 Server.

Confidential

Cognos Developer

Responsibilities:

• Involved in Requirement gathering from Business Users and Developed Technical Documentation for the Business and Team.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements
• Created various report types like list reports, cross tab, charts, Dashboards. that cover the entire range of enterprise reporting requirements.
• Used various functionalities in report studio like drill throughs, conditional formatting, parameter displays, Conditional blocks, Bookmarks, Render Variable, applied Javascripts in HTML items
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Worked as Production support to the project been implemented.
• Developed and Published Packages in Framework Manager Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Involved in effort estimation based on the complexity of the business and the report design..
• Created Special Categories, User Class Views, Securities. implemented Time Based Partition cubes to support incremental update..
• Design & development of the reports using Cognos 8 Report Studio, Query Studio and Analysis Studio.
• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Modifying the existing reports based upon the change request by the user.
• Creation of Dash Board Reports using Report studio MDX Functions and adding it to the portal page using HTML Items.
• Understanding the existing security structure of the company and implemented organizational security for cognos environment (Folders, Models and Reports etc). Implemented SSO between the company internal portal and Cognos.
• Added Data Security, Object and Row level Security according to the requirements.
• Involved in deployment to UAT and Production.
• Troubleshoot Cognos Server Environment for the better performance.

Environment: Cognos 8.4.1 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), Cognos SDK, Oracle 10g/11g, Power play cubes and Windows 2003 Server.

Confidential

Cognos developer

Responsibilities:

• Got involved in key functional areas like Compliance, Rate, Registration, Collections and Monetary.
• Involved in understanding the Business needs and Customer requirements by participating in the Design Phase, user requirement gathering.
• Analyzing the specifications provided by the clients and Developing specification documents for reports as per client requirements.
• Designed the Framework Manager Model with all the necessary joins, filters and calculations for reports.
• Developed and Published Packages in Framework Manager Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Involved in effort estimation based on the complexity of the business and the report design.
• Understand the security model and implemented the RowLevel Security according to the requirements.
• Developed Reports using Conditional Formatting and Cascading Prompts Developed List, drill through, masterdetail, chart and complex reports which involved Multiple Prompts, Filters, multipage, multiquery reports against multiple databases.
• Resolving the Performance issues of the Reports. implemented security for Data access, Object level access and Package access. interacting with the End users on a regular basis for resolving issues pertaining to the reports.
• Migration of Cognos code (reports/models/ frameworks) from 8.2 to 8.4.
• Testing reports using review checklists (SQL Scripts) for Quality Assurance before delivering to the end users.
• Installation and Configuration of the servers in Distributed environment (Web, Application and Data servers).
• Administering the Servers - Installation, configuration, roles, Privileges and Performance Tuning of the Servers.
• Understanding of Cognos BI security model and implement the security (Data Security, Object and Row level Security) according to the requirements.
• Managing Multiple Dispatchers, Content managers and Content Store in Multiserver environment.
• Responsible for back up Cognos 8 BI data and tune the Cognos 8 BI Environment.
• Troubleshoot the server Environment by using logs.
• Provide operational support for Cognos servers. (Recover servers in case of any failures/shutdown).
• Testing the report by comparing data with Line of Business (LOB) data by using DB2 (AQT).

Environment: Cognos 8.2/8.4 suite (Framework Manager, Report Studio, Analysis Studio, Query Studio, Metric Studio), Power play Transformer, Power play cubes, Oracle, DB2, Clear Quest and Serena Dimensions.

Confidential

Cognos developer

Responsibilities:

• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Developed and Published Packages in Framework Manager Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects.
• Implemented security for Data access, Object level access and Package access.
• Created User Groups, Roles to implement the Cognos Security, using Directory Server Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Developed List, cross tab, drill through, master detail, chart and complex reports which involved Multiple Prompts, Filters, multipage, multi query reports against multiple databases.
• Used filters for efficient data retrieval.
• Share point reports maintenance and Schedule management for the daily email reports.
• Creation of Power Play models and cubes Using Power play Transformer and Testing the report by comparing data with Cube data by using power play web explorer and the validity of the data it retrieves from the database.
• Migrating Power play Client HTML reports that are tabular and pivot oriented and convert them to pictorial/dashboard oriented reports for executive management sales.
• Experience with conditional blocks and conditional layouts.
• Creating Dash Board Reports from cube using Report studio MDX Functions and adding it to the portal page using HTML Items.
• Modifying the existing report based upon the change request by the user.
• Customizing Cognos Connection Portal based on user specifications.
• Created business models based on power cubes, published to the portal and created daily, Monthly reports based on published package.
• Generated IQD files in Framework manager and designed Power play models in Transformer as sources of Metric Extracts.
• Developed Metric Extracts in Metric Designer as a Cube Sources.
• Developed Scorecards, Metric Types and Metrics in Metric Studio.
• Loading data into Metric Studio from Cube Sources.
• Deployment of reports from Development to Production.
• Production Support and Troubleshoot/Test issues with existing reports and cubes.
• Migration to the Cognos 8 platform in a distributed environment (reports/cubes/models/IQD’s).
• Interacting with the Cognos support team and creating & following up the cases in the cognos support site.

Environment: Cognos 8.2 suite (Framework Manager, Report Studio, Analysis Studio, Query Studio), Power play Transformer, SQL Server 2005, Power play cubes.