SUMMARY:

• Around 9+ years of extensive experience in analysis, design and development of Business Intelligence applications using Cognos products.
• Expertise in Cognos Analytics / Cognos 11.0, Cognos 10.1 (Report Studio, Framework Manager, Business Insight, Business Insight Advanced), Cognos 8 BI suite (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, Power Play studio), Report Net 1.1, Transformer, Cognos suite 7.x (Impromptu catalogs, Impromptu Web Reports, Upfront) and Power Play Enterprise Server.
• Experience in Data Modeling - Relational, Multidimensional and DMR (dimensionally-modeled relational) modeling in Framework Manager.
• Followed Best Practices for dimensional and relational data model using Framework Manager.
• Experience in building and maintaining Powercubes in Transformer using relational, DMR and OLAP packages as data sources
• Developed various Complex reports using Cognos 8, ReportNet, PowerPlay and Impromptu
• Performed Query optimization and improved report performance through use of index, aggregate tables and drill-thru functionalities.
• Expertise in installation, configuration and administration of Cognos products in a distributed multi-server environment.
• Working and coordination with overseas (ETL) teams. Involved in administration in Cognos Connection and security implementation among Cognos Applications. Performed administrative roles in Cognos Connection and set security permissions, configured and maintained users, groups and roles using Cognos Administration.
• Good communication skills with strong ability to interact with end-users, customers, and team members.
• Good analytical, problem solving and interpersonal skills. Ability to work in a team environment or work independently and handle multiple tasks concurrently.

SKILL:

BI Tools: IBM Cognos 8.x BI (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, PowerPlay studio), Cognos 10.x, (Report Studio, Framework Manager, Business insight), Cognos 11.04 ReportNet 1.1, Transformer, Cognos suite 7.x (Impromptu catalogs, Impromptu Web Reports, Upfront)

Programming skills: SQL, PL/SQL

Scripting Languages: JavaScript, VB Script

Databases: Oracle 9i/10g/11g, SQL Server 2003/2005/2008 , DB2

Tools: SQL Developer, TOAD, Erwin, Microsoft Visio, Rational Requisite Pro

Operating Systems: Windows, UNIX

Web Servers: Microsoft IIS, Apache 6.0/7.0, Apache 2.0

WORK EXPERIENCE:

Confidential, Shelton, CT

Lead Cognos Consultant

Responsibilities:

• Application Maintenance and Support (AMS): Maintain health of Cognos Production Environment(10.2) and modify the frame work model based on the (SAP)Hana Views and Oracle Data bases.Also involving in migration to Cognos Analytics version (11.07).

Confidential, Cleveland, Ohio

Sr Cognos Consultant

Responsibilities:

• Designed, modeled and developed reports like top lending reports with monthly trend, with display of ratio of Top lender to total and summary charts using Cognos Analytics version (11.04).
• Designed and Developed report on CD Promotion which provides graphical representation of how a CD promo is doing in state wise, region wise and Branch wise etc in multiple tabs, with custom interactivity and provide summary at a glance. (Recent project)
• Designed and modeled Complete Frame Work model in Cognos 10.2.2 based on start schema for migrating reports from Data Flux to Cognos 10.2.2 and adding security.
• Enhanced the reports readability using color coding display and conditional formatting
• Recreation of Data flux reports to Cognos 10.2.2, and Migrating reports from Cognos 10.2.2 to Cognos Analytics or Cognos 11.0
• Involved / assisted the admin in the environment set up
• Designed and created Consolidated Stress Report (for a Previous 3 month period) summarizing 90 validation reports.
• Documenting the FM model and Reports.

Environment: Cognos Analytics / Cognos 11, Cognos 10.2 -Frame Work Manager, Report studio, Work Space advanced, Oracle 11 g, Toad

Confidential, Cleveland, OH

Cognos Sr Developer

Responsibilities:

• Involved in design and Creation of FSD and Technical Documents for their Confidential.
• Created FSDs for their standard reports, FSD/Technical documentation for Framework Manager Model for their standard reports, Adhoc reports to their upcoming PRISM Project.

Confidential, Austin TX

Cognos Sr Developer

Responsibilities:

• Working on Migration of reports from Cognos 7.4 to Cognos 10.2Worked on conversion of impromptu catalogs, to Framework packages, created DMR Models and published and used packages to develop reports using Report studio, created model for adhoc reports.
• Designed security for Framework ModelsInvolved in Data base model converting 21 databases to single database.
• Interacted with ETL team in creating data mapping document for conversion of relational data base to Dimensional model.

Environment: Cognos 7.4, Cognos 10.2 -Frame Work Manager, Report studio, Work Space advanced, Oracle 11 x, SQl developer, Erwin Modeler 7.3,Erwin modeler 9.3.

Confidential

Cognos Sr Developer

Responsibilities:

• Working on cognos 10.1 - Creating new cube from scratchModifying existing cube based on IQDs as data sources.
• Interacted with overseas ETL team for modifications in the data ware house to suit the cube requirements.
• Worked with HON management division for their profitability projection based on analysis of current and past data.
• The cube is based on a complex IQDs based on Oracle as database. And data input from the management team is using csv files.
• Interacted with offshore ETL team to create process to load the csv file data that is supplied by business.
• Created from two MSSQL data bases .
• Support works db and 2.Eclipse db.
• Used IQD as data source, in transformer created custom measures for the IT management department based on the analytics data that is needed.
• Created multiple date dimensions and multi level dimensions.
• Created custom views and provided user level security to users.

Environment: Cognos 10.1 -Frame Work Manager, Report studio, MS SQL, Oracle 11 x, SQl developer, Toad

Confidential, Denver -CO.

Cognos Consultant(Cognos Sr Developer)

Responsibilities:

• Working on Cognos 10.2.1
• Upgrading the project
• S2F is Asset Management Company generating revenue through distribution and management of debt assets in the form of delinquent accounts from variety of institutions.
• An Agile working environmentCreating new Cubes Replacing Cube's current data source to Packages sources using transformers.
• Replacing multiple cubes with single cube.
• Creating complex Framework Models, trouble shoot models which involve cross joins, create Reports for Data sources to replace IQDS and Client reports.
• Creating security for cubes, by creating custom views and Apexes based on branches and franchises. Created users, groups
• Security: Provided security using LDAP Active Directory.
• Applied security and provided specific access for the cubes designed.
• Created Dash boards for the Management Team using report studio.
• Created and modified reports for a data Source for the Cubes using report studio.

Environment: Cognos 10.1 -Frame Work Manager, Report studio, Oracle 11 x, SQl developer, Toad, Cognos Power Play Transformer, Query Studio

Confidential, Jefferson City, MO

Cognos Consultant (Cognos Developer/Admin)

Responsibilities:

• Total upgrade of the project from cognos 8.4 to latest cognos10.2.1.
• In a distributed environment. Validate the reports and fix the issues.
• Installed and Administering IBM Cognos 8.4 and Cognos 10.2/10.1.1 in Windows 2008 R2 - Single - Tier, Multi-tier environment.
• Installed Service pack1, Service pack 2 and Hot fix in distributed environment.
• Migrated IBM Cognos 8.4 content to Cognos 10.2.1 environment.
• Participated in capacity planning -servers, software’s, licensing and collaborated on architectural design of hardware requirements, networks and security.
• Secured the IBM Cognos BI Environment with Authentication provider such as LDAP.
• Installed and Configured the desktop tolls (Transformer, Frame work Mananger, Powerplay client and IBM Cognos Insight)
• Involved in load balancing of gateways and performance tuning setting in cognos portal.
• Thorough understanding of IBM Cognos Dispatcher & Services and Java (JVM) and Query services Memory Management.
• Liaising with IBM Cognos software support to troubleshoot issues, including enable tracing and capture log files.
• Scheduled reports in Cognos Connection based on the reports to run Daily, Weekly or Monthly basis.
• Support Cognos production environment for large scale user base and collaborate with team members to identify best practices.
• Participate in system, integration, performance, and user acceptance testing for systems.
• Trained business super users to develop/use reports using Report Studio, Query Studio, and Cognos Insight.
• Worked with IBM team to resolve the environment issues.

Environment: Cognos 8.4, Cognos 10.1 -Frame Work Manager, Report studio, Oracle 11 x, SQl developer, Toad

Confidential

Sr. Cognos Developer

Responsibilities:

• Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level. Worked as Cognos Report Writer - Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio and created scorecard reports using the Metric Studio.
• Worked on bug fixing and enhancements to existing Cognos reports in Report Studio& models in Framework Manger and development of any new Reports.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Worked on Analysis Studio to develop multi-dimensional reporting. Analyzed Business requirements from the analysts.
• Involved to analyze and map data from source systems to target operational data stores and data marts (Data warehouse).
• Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.
• Developed reports using System Development Kit (SDK) with help of Java team using java scripts and Eclipse at the back end.
• Customized Reports using HTML and JAVA SCRIPTS.
• Upgrade the report and packages version of COGNOS from 8.4 to 10 and Participate in the regression testing and unit testing.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
• Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.
• Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.
• Developed Dash board reports to display all the information related to environment using Summary reports.

Environment: Cognos 10 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Cognos Transformer and Event Studio), JavaScript and HTML, Oracle Data Integrator(ODI),Oracle Database 10g, Cognos Windows 7 Professional, XML and HTML.

Confidential, San Dieago,CA

Cognos Developer

Responsibilities:

• Gathered the reporting issues from the users and analyzed user requirements.
• Involved in migrating metadata and reports from Cognos 7.4 to Cognos 8.2 using utilities.
• Assessed the scope for migration and used different approaches of Lift & Shift, Compress & Optimize wherever necessary for migrating cubes and catalogs.
• Created multiple data source connections for importing different data sources into Framework Manager.
• Created multiple paged, multiple-query reports using multiple prompts for showing selective data on user input.
• Designed relational and DMR models in Framework Manager and published packages to Cognos.
• Implemented data security, object security and package security in Framework Manager.
• Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.
• Created multi-query and ad hoc reports in the report studio and query studio and developed many complex reports for financial analysis.
• Used detail, summary and context filters for making the reports more specific.
• Used conditional formatting, conditional styles and Style variables to render reports for different user needs.
• Created calculated columns to measure the Gross Profit, Net Profit, and Burden in terms of Revenue.
• Created a toggle report that swaps a report layout as list or chart.
• Developed monthly Product Sales Trend, Transactions History and Backlog reports filtered by regions in Analysis Studio.
• Created Sales analysis and summary reports for current year and previous year using Analysis Studio
• Scheduled reports in the Cognos Connection portal to use off-peak hours effectively.

Environment: Cognos 8.2(Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos Connection, Transformer, Cognos 7.4 (Impromptu, PPES, Upfront, IWR), Access Manager, MS SQL Server 2005, migratetoc8, deploytoc8

Confidential

Cognos Developer

Responsibilities:

• Analyzed Business requirements from the analysts.
• Customized Cognos Connection with appropriate reports and security measures.
• Implemented Framework Manager Security for Data access, Object level access and Package access based on the Organization Level.
• Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
• Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
• Upgrade the report and packages version of COGNOS from 8.0 to 8.1 and Participate in the regression testing and unit testing.
• Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
• Designed models &cubes in Cognos 7.2 Transformer using existing IQD s from Framework Manager.
• Worked on Analysis Studio to develop multi - dimensional reporting.

Environment: Cognos 8.0/7x Bi Suite (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Transformer and Event Studio), JavaScript and HTML, MS Visio Standard 2003, Impromptu 7.4, Cognos Power Play 7.3, Cognos Transformer 7.3, Oracle 9.2i client, VB Script, SQL and PL/SQL, IIS, Windows XP Professional.

Confidential, NY

Cognos Developer

Responsibilities:

• Interacted with the Business users for requirement gathering.
• Installed & configured Cognos component such as the ReportNet.
• Created the list, cross tab, repeater and Drill-through reports, master-detail reports, prompts, complex calculations, formatting, conditional formatting, Bursting reports, charts and created the reports in different formats like PDF, XML, HTML and CSV.
• Created Cascade Prompts, Bookmarks, Query prompts, Filters, and Multilingual Reports Using Report Studio.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Created various IQD packages in Framework Manager and from this IQD integrated to power play transformer to create various models and cubes.
• Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.
• Configured access manager namespace in Cognos connection and created new users and user groups in access manager.
• Provided technical assistance, training and mentoring to Users and Business Partners

Environment: CognosReportNet 1.1 MR3 (Framework Manager, Report Studio, Query Studio), Oracle 9i, SQL Server 2000, SQL, PL/SQL, Windows XP/NT