PROFESS IONAL SUMMARY

• 9 years of experience in providing Business Intelligence Solutions with IBM Cognos 10.2.1 Suite, IBM Cognos 8.4.1 Suite, and Cognos ReportNet.
• Experience in complete Software Development Life Cycle SDLC of simple to complex Business Intelligence projects.
• Specialized in working with BI Tools like IBM Cognos Framework Manager, Query Studio, Report Studio, Cognos Connection, Event Studio, and Analysis Studio.
• Extensive knowledge on Cognos Go Office and Cognos Analysis for Excel CAFE .
• Experience in working with Active Reports, Workspace Business Insight , and Workspace Advanced Business Insight Advanced .
• Experience in creating multi-dimensional models and building Power Cubes using Cognos PowerPlay Transformer.
• Experience in building complex Framework Manager models and publishing packages to Cognos connection.
• Strong in data warehousing concepts and knowledge on ETL mappings using Informatica tool.
• Experience in building various types of reports including List, Cross-tab, Chart, Repeater, Dashboards, Scorecards, and other irregular pattern layouts.
• Experience in Cognos Administration activities including installation, configuration, job creation, scheduling, creating exports and imports.
• Experience in writing PL/SQL queries, performance tuning, and troubleshooting in Oracle and DB2 systems.
• Excellent communication, interpersonal, and leadership skills.
• Prepared best practices on Cognos from the experiences learned on the various projects and played a key role in creating proof of concepts and winning projects.

SKILL SETS

EMPLOYER EXPERIENCE SUMMARY

Position: Project Lead

Responsibilities:

• Gather requirements from business team and processing those requirements.
• Create Analyze and Design documents per the client standards.
• Distribute work to both onsite and offshore team members and conduct meetings and review sessions.
• Build Framework Manager models by importing tables and views from the underlying data source.
• Create and publish packages to Cognos connection.
• Create proof of concepts on multi-dimensional modeling using Cognos Transformer and created PowerCubes.
• Create various types of reports including List, Cross-Tab, and Repeater and various types of chart reports including Column, Bar, Pie, Line.
• Participate in performance tuning of time consuming reports.
• Implement various techniques and functionalities including: various types of Prompts and Cascading prompts, drill-through reports, master-detail relationships, custom Joins and Set operations, bursting of reports, Multi-Lingual Reports, Conditional Reports, Grouping, Sorting, and Sections, Conditional Blocks and Conditional Variables.
• Create Dashboards and Scorecards per the business needs.
• Participate in writing manual PL/SQL queries when the situation demands.
• Participate in Unit Testing and SIT for the developed reports according to the test cases prepared.
• Participate in production support activities after post implementation.
• Conduct technical interviews to recruit new resources and knowledge sessions on the lessons learned.

Key Achievements:

• Successfully migrated more than 100 reports from .NET to Cognos 8 and Cognos 10.
• Developed a POC on Cognos 10 new features and functionalities, and successfully won a project for the company.
• Successfully integrated Cognos reports with .NET application and with Motio.

Skills Used: Cognos 10.2.1 Suite, Cognos 8.4.1 Suite, Motio, DB2 9, Oracle Exadata, .NET, Toad.

Position: Technical Specialist

Responsibilities:

• Gathered requirements from onsite team and was involved in analyze and design activities.
• Created reports like Simple List, Cross-Tab, and Chart.
• Wrote manual SQL queries when the Cognos built-in options failed to meet the requirements.
• Involved in Unit Testing and SIT.
• Created sample data in OpenPages application and cross validated results in Cognos.
• Published Cognos reports to OpenPages application.
• Involved in deploying reports from test region to production region.

Skills Used: Cognos 8.3 Suite, Cognos ReportNet, IBM OpenPages 5.0, Oracle 9

Position: Technical Specialist

Responsibilities:

• Gathered requirements from the client and coordinated with offshore team to process the user requests.
• Installed and configured Cognos application in Windows environment.
• Imported logical database tables/views from multiple sources and created Framework Manager Models with star schema layout.
• Creating multi-dimensional models and PowerCubes using Cognos Transformer.
• Created Joins, User Defined Filters, Calculations, Prompts, and Packages
• Created different types of reports including List, Cross-Tab, Chart, Drill-Through, Dash Board, and Scorecards.
• Implemented functionalities like Report Bursting, Conditional Formatting, Master-Detail, Table of Contents, and Bookmarks.
• Created project supporting documents in Define, Analyze, Design, Test, and Implementation phases.

Key Achievements:

• I automated the entire ABS Cognos reporting system, which reduced lot of manual efforts and saved cost and time.
• Created interactive reports, which allowed business users to directly execute the reports and get the results on demand according to their choice.
• Actively involved in finding a solution to get automated notification through IMR ticket in case of Cognos Report or Job failure.
• Received Best Performer award for providing excellent solutions in Cognos.

Skills Used: Cognos 8.3 Suite, DB2, Control-M, Mainframes

Position: Analyst Programmer

Skills Used: Cognos 8, SQL Server

Responsibilities:

• Installed and configured Cognos software in development servers.
• Prepared supporting documentation for the key features and functionalities of Cognos tool.
• Conducted technical trainings and brainstorming sessions.
• Conducted interviews for recruiting new resources.
• Attended training sessions on the new technologies and domains.
• Created proof of concepts for the upcoming projects.