SUMMARY:

• Around 8+ years of extensive experience in analysis, design and development of Business Intelligence applications using Cognos products.
• Expertise in 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, PowerPlay studio), ReportNet 1.1, Transformer, Cognos suite 7.x (Impromptu catalogs, Impromptu Web Reports, Upfront) and PowerPlay Enterprise Server.
• Experience in Data Modeling - Relational, Multidimensional and DMR (dimensionally-modeled relational) modeling in Framework Manager.
• Used Best Practices for dimensional and relational data modeling 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 on a team environment or independently and handle multiple tasks concurrently.

TECHNICAL SKILLS:

BI Tools: IBM Cognos 8.x BI (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, PowerPlay studio), Cognos 10 (Report Studio, Framework Manager, Business insight), 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: and Utilities: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 -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 - Muscatine -Iowa

Cognos Sr Developer

• This profitability cube provides the data in the necessary view.
• 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.
• ITSM Cube:
• It is service level ticket management system.
• Created from two MSSQL data bases - 1. 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:

• 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:

• 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, MI

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 targetoperational 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, 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

Confidential, RI

Cognos Developer

Responsibilities:

• Worked on Cognos framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Implemented Security with LDAP and Group level security in Cognos Connection Portal.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Creation of procedures, views, tables and functions according to business requirements in Oracle.
• Involved in Creating IQD files from Report net and designed Power play models in Transformer
• Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Created Dash board reports to get all the information from other reports.
• Production Support, which involves solving user problems.

Environment: Cognos Report net 1.1 MR2 (Framework Manager, Query Studio, Report Studio), Impromptu 7.2, Power Play Enterprise Server 7.2, Transformer 7.2, Informatica 7.0, Oracle 9i, T-SQL, XML and HTML.

Confidential, Houston, TX

Cognos Consultant

Responsibilities:

• Involved in designing data model and report design.
• Understanding functional specification and preparing technical spec.
• Created report net models, queries according to standards
• Created and publishing packages to Cognos connection.
• Created the user roles in cognos connection.
• Built Power Play Reports in Report Studio by replicating the power play functionality in Report Studio using dynamic Measure selection, Dynamic Sorting, ranking.
• Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.
• Customize the Cognos connection portal using existing portlets and customized tabs.
• Worked on complex reports using Static Prompt and MDX functions and union conditions.
• Used Cognos Office Connection to publish the reports in Power point and format them for business presentation.
• Created the Dashboard reports using Report Studio.
• Authoring reports in report studio according to requirement by implementing many features like prompts, conditional formatting.
• Scheduling the monthly reports with saved prompts using Job Wizard.
• 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.

Environment: Cognos 8.2 BI, Report Net 1.1, Framework Manager 1.1, Cognos Report Studio 1.1 DB2.0, Report Studio 1.1/8.2,Transformer 7.2/8.2, Cognos XML, Generic/Cognos JavaScript.