PROFESSIONAL SUMMARY:

• Over 8 years experience in analysis, design, development and implementation of business Intelligence solutions using COGNOS
• Hands on experience in Cognos 10.2,10.1 and 8 (Query Studio, Report Studio, Analysis Studio, Metric Studio (Score - carding), Framework Manager, TM1 Architect, Cognos Connection and Cognos Series 7.x(Cognos ReportNet 1.1, Cognos Impromptu, Cognos PowerPlay Transformer, Cognos Scheduler, Cognos Access Manager, Upfront)
• Strong Experience in creating and publishing packages in Framework Manager
• Strong complex reporting skills - complex Drill-through, Discontinuous Cross-Tabs, Summary Reports,Bursting reports
• Strong understanding of dimensional modeling of Star Schemas, Snow-Flakes Schemas methodologies for building enterprise data warehouses.
• Extensively used Cognos 10i product suite in recent projects.
• Expert in Production Support
• Strong experience in Cognos ReportNet Framework Manager, Report Studio.
• Knowledge of Cognos Metrics Manager, Notice Cast, Decision Stream.
• Extensively used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring.
• Installed and configured various components, such as the Framework Manager and Content Manager.
• Expert knowledge in COGNOS BI Series Impromptu, Impromptu Web Reports, Upfront Portal, Access Manager and Power Prompts.
• Strong experience in Dimensional Data modeling, Star Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling.
• Involved in the full Project Life Cycle of the Data Warehouse Project.
• Exposure to client interaction and user-requirement analysis.
• Trained Business users for Ad-Hoc reporting
• Have excellent problem solving, time management skills, communication skill, good organizational skill, self-motivated, hard working, ability to work independently or cooperatively in a team and eager to learn.

TECHNICAL SKILLS:

Cognos Suite: Cognos BI (10.2,10.1, 8.1, 8.2, 8.3 and 8.4) Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio, Cognos Report Net1.1(MR1, MR2, MR3)/1.02(Query Studio, Report Studio, Framework Manager), Cognos Impromptu, Power Play Transformer

ETL: Informatica PowerCenter, Power Mart, Data Stage, DTS, SQLServer Integration Services.

Databases: Oracle 11G,10G/9i/8i/, SQL Server 2005,SQL Server2000, DTS, DB2, MS-Access.

Languages: SQL, PL/SQL, UNIX Shell scripting.

Operating Systems: Windows2000/XP, DOS.

Other Tools: TOAD, SQL Loader, Maestro, Appworks

PROFESSIONAL EXPERIENCE:

Confidential, Akron, OH

Senior Cognos developer/Modeler

Responsibilities:

• Expert in report development using Report Studio, Analysis studio and Query studio
• Developed complex Reports, Charts, Drill through Reports, Master Detail Reports and Bursting Reports using Report Studio and Query Studio
• Scheduled and Distributed Reports through Schedule Management in Cognos Connection.
• Performanced Tuning of reports in Report Studio
• Assisted in maintaining data integrity, including consistent naming conventions used in databases
• Gathered Business requirements from end users and managers and Translate business requirements into effective reporting solutions
• Created prompts, Calculations, Filters, Developing Prompt pages and Conditional Variables using Report Studio
• Created Chart palettes with company branding colors
• Developed interactive Dashboards using in-report prompts, custom portal pages and inter-portlet communication techniques
• Authored various types of reports in Report Studio using dimensional (Cube & DMR) and Relational data sources
• Successfully designed and implemented security on different levels including object and row level security
• Created complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases
• Implemented report bursting to distribute reports effectively in report studio
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases
• Strong Cognos Development skills in report studio 10.2,10.1,8.4
• Build prototype reports based on initial business requirements
• Created complex Dashboards in Report studio for various departments to enhance performance metrics
• Interacted with Development and Management Teams.
• Expert in framework manager.
• Involved in gathering Business Requirements for New models
• Developed and Published Packages in Framework Manager, Connected and tested the data source, created Database layer, Relationship layer and Presentation layer, defining appropriate relationship between query subjects
• Strong skills developing DMR models in Framework Manager and dimensional reports in Report Studio
• Reversed engineered the Framework Manager Model to remove the redundant tables and folders
• Implemented security in Framework Manager Packages & Reports
• Implemented Data & Object security in Framework manager models
• Used Framework Manager to build models, packages and publish packages to Cognos Connection.
• Developed filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio for users
• Created Metadata Modeling by using multiple databases in Cognos 10 BI Modeling
• Created standalone and Embedded filters in Framework manager
• Used Analysis studio to drill down on cubes and perform business analysis
• Used Cognos Connection to administer and scheduling reports to run
• Communicated report development progress and issues to management and team members.
• Assisted in end user acceptance testing and unit testing
• Exceptional ability to quickly master new concepts and technologies
• Capabled of working in groups as well as independently with excellent communication skills
• G ood in troubleshooting with quick turnaround in fixing the issues
• Strong functional and technical analysis skills

Environment: Cognos 10.2, 10.1, 8.4, BI Report Studio, Query Studio, Analysis Studio, Business insight, Event studio, Framework Manager, Workspace, Cube Designer, TM1 Architect, Performance modeler, Turbo Integrator, perspective, Cognos Connection, Cognos, SPSS, Impromptu, Cognos Transformer, Cognos SDK, Access, Cerner, Misys, Excel, Oracle 12g, 11g,10g/9i, MS SQL Server 2012, 2008, 2005, DB2, Maestro, Cognos Data Manager 10.1,Toad, Data manager, Data stage,Windows, Informatica 9.5, Crystal reports, Ultipro, ERWIN, UNIX, Redhat Linux, Tableau

Confidential, San Diego, CA

Cognos Developer

Responsibilities:

• Involved in Designing and Created various Projects in Framework Manager
• Create various packages using framework manager in ReportNet
• Imported the Metadata from Third Party tools like ERWin.
• Created filters within the Model for improving performance of the Model.
• Developed new reports in Report Studio upon requests from business users
• Created Dashboards for a better understanding of the business performance metrics
• Used Analysis studio to drill down on cubes and perform business analysis
• Expert in Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio
• Used Cognos Connection to administer and scheduling reports to run at various intervals as well as the ReportNet Server.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Bursting Reports and Multilingual Reports Using Report Studio.
• Provided day-to-day support for all COGNOS Report studio users.
• Communicated report development progress and issues to management and team members.
• Ensured compliance with standard software development practices, processes and enterprise standards
• Cognos 8.4 to Cognos 10 Migration
• Assist in end user acceptance testing.

Environment: Cognos 8.4,10.1 BI Report Studio, Query Studio, Analysis Studio, Framework Manager, Cognos Connection, Cognos Power Play, Cognos Transformer, Cognos SDK, Access, Excel, Ultipro, Oracle 10g/9i, MS SQL Server 2012,2008,2005, Teradata, Maestro, Windows, Informatica, ERWIN, UNIX, Redhat Linux

Confidential, Chicago

Cognos BI Consultant

Responsibilities:

• Involved in Installation and Configuration of Cognos 8 BI on the Server.
• Interacted with End Users for Business Requirements
• Created Various Complex and Simple Impromptu Reports and published reports to Upfront. Involved in Creation of Simple Reports using Cognos Query.
• Created various Cubes in Power Play Transformer and Created Various reports related to Cubes in Analysis Studio and Cognos Power Play.
• Created Models in Frame work manager. Created various filters and calculations in framework manager models.
• Expert Migrating catalogs into report net using migration utility
• Expert in Migration of Impromptu Reportset to Cognos ReportStudio
• Worked on Security in Access Manager, created users and grant them necessary permissions.
• Worked on Security permissions in Cognos Connection portal at Package Level, giving permissions to end users for report studio and query studio, Object Security at Frame work Manager Level.
• Scheduled Reports using Scheduling Management. Configured Email Server Information at Production and Development Servers.
• Deployed Models and reports from Development Server to Production Server using Content Administration.
• Improved Performance of Reports and Trouble Shooting of various issues at Servers, Cognos Connection Portal and reports.
• Used Data Stage to Perform ETL process.

Environment: Cognos8 BI MR2, Toad 9.0.1.8, Oracle 9i, Cognos Series 7 Version 2, Impromptu 7, Power Play 7, Access Manager 7, Data Stage