SUMMARY

• 10 + years of IT experience with expertise in Analysis, Design, Development, Implementation and Testing Environments in Various Business Intelligence systems and Application Development.
• Extensively worked on Cognos BI Suite components like Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Workspace Advanced, Transformer, Metric Studio, PowerPlay, Impromptu, Impromptu Web Reports, Cognos Upfront and Cognos Portfolio Briefing Book.
• Extensively worked on Qlikview Dashboard and Qlikview AccessPoint.
• Having good experience in Cognos Administration, Qlikview Administration, Access Management, Maintenance, and Content Migration
• Having good Knowledge of Cognos installation and Configuring of Cognos App Servers and Web Servers
• Designed and developed extensive QlikView reports using combination of charts and tables reports.
• Publishing and Deploying the Dashboards based on business requirements.
• Developing Set Analysis to provide the custom functionality in QlikView Applications.
• Worked on RDBMS like Oracle, SQL Server and DB2.
• Good knowledge on ITIL process and Service Management tools like Service now, Service Center, Lotus Notes on Incident/Change/Problem/Access management activities
• Experienced in performance tuning of reports, trouble shooting, capacity planning, availability, and performance monitoring activities on Cognos systems
• Capable of handling multiple tasks and priorities; self - motivated and displays initiative.
• Experienced in all the stages of the System Development Life Cycle from Scoping, Risk Analysis, Scheduling, Effort Estimating, Requirement, Design and Development through Deployment of various Data Warehouse and BI projects.

TECHNICAL SKILLS

IBM Cognos BI Tools: Cognos BI version 10.2/8.X (Framework Manager, Transformer, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Workspace Advanced Cognos Connection ), Cognos Series7.x/6.x (Impromptu, Transformer, Power play and Access Manager, Impromptu Web Reports, Cognos Upfront and Cognos Portfolio Briefing Book)

QlikView BI Tools: QlikView 11/8 (QlikView Desktop, QlikView OCX, QlikView Server, QlikView Publisher)

Databases: Oracle 11g/10g/9i/8i/8.0, DB2 UDB 8.0/7.0, SQL Server 2005/2008.

PROFESSIONAL EXPERIENCE

Confidential, Houston Texas

Module lead

Responsibilities:

• Gathered & analyzed the end-user business requirements.
• Imported metadata from multiple data sources to build a model and publishing packages in Framework Manager to the Cognos server.
• Worked with relationships (cardinality) between query subjects to better represent the logical structure of the business and the user requirements.
• Created list reports, cross-tab reports and chart- reports using multiple queries in a single report.
• Created various Report Studio reports using calculations, filters, prompts and conditional formatting, drill through.
• Business Intelligence development including Reports and Dashboards, Mobile Solutions, Management Reporting
• Creation of / approval of project documentation including Functional, Technical specifications, Test Scripts Conducting code reviews
• Designed and developed extensive QlikView reports using combination of charts and tables.
• Publishing and Deploying the Dashboards based on business requirements.
• Developing Set Analysis to provide the custom functionality in QlikView Applications.
• Creation of different types of reports such as master/detail and crosstab for trend analysis
• Presentation of concepts and results from his/her area of functional responsibility
• Responsible for training end user community on the newly developed / enhanced environment
• Preparation and execution on Test Plans/Test cases for reports
• Responsible in interacting with client for business requirements on enhancements.
• Involved in the design of the report format and in the preparation of the specification documents for the reports.
• Providing Weekly Status Reports, project artifacts to stakeholders.
• Quality Assurance such as Peer Review by another Team member & Final Inspection by other application team member on deliverables.

Environment: Cognos 10.2, Cognos Framework Manager, Cognos Transformer, Report Studio, Query Studio, Qlikview 11.2, Qlikview AccessPoint, Oracle, DB2.

Confidential

Module lead.

Responsibilities:

• Responsible in interacting with Onsite Counterparts for business requirements for reports & dashboard.
• Creating data model based on the source for Dashboard.
• Creating model by defining proper relationships in Framework Manager.
• Development and Testing of QlikView Dashboard.
• Development and Testing of Cognos Reports using Cognos 10 BI.
• Administration of Production environment, monitoring, issue resolvement.
• Onsite Co-ordination by providing Weekly Status Reports to both Internal/External management.
• Quality Assurance such as Peer Review by another Team member & Final Inspection by other application team member on deliverables.
• Coordinate and Communicate with client and maintaining delivery timelines and quality
• Manage and maintained the documentation for the reporting team in an offshore /onsite model

Environment: Cognos 10BI, Cognos 8BI, Cognos Framework Manager, Report Studio, Query Studio, Cognos Impromptu, Cognos Transformer, Datasatge, Oracle 10g

Confidential

Senior Software Engineer

Responsibilities:

• Interaction with Business Analyst for understanding requirements through specification prepared by them and document RFS, technical design documents.
• Designed and developed the Cognos Framework Manager Models and Packages which can cater the reporting needs of the business.
• Conducting technical review of the projects.
• Developed various reports using Cognos 8 report studio.

Environment: Cognos 8BI, Cognos Framework Manager, Report Studio, Query Studio

Confidential

Senior Software Engineer

Responsibilities:

• Through study of requirements of business and the functionality of each module.
• Through understanding of the report specifications and if necessary discussing with colleagues for optimum process
• Understand the Business needs and report specifications, based on that universes and packages are designed and developed the cross-tab and list reports.

Environment: Cognos 8BI, Cognos Framework Manager, Cognos Transformer, Report StudioQuery Studio, Informatica, Oracle

Confidential

Senior Software Engineer

Responsibilities:

• Migration from Cognos ReportNet 1.1 to Cognos 8.3
• Going thru’ Report Specification Documents and Understanding the User Requirements
• Troubleshooting the Cognos 8.3 Development & maintenance problems.
• Creating model by defining proper relationships in Framework Manager.
• Creating Package and Publishing it in Cognos Connection.
• Creating various Kinds of reports like list, cross tab in Report Studio.
• Creating various types of prompts in the prompt page.
• Doing Unit testing of Reports based on the Report requirement specification.
• Maintenance and support for Power play cubes
• Granting access to the reporting users through Access Manager.

Confidential

Technical consultant

Responsibilities:

• Going thru’ Report Specification Documents and Understanding the User Requirements
• Creating model by defining proper relationships in Framework Manager.
• Creating Package and Publishing it in Cognos Connection.
• Creating various Kinds of reports like list, cross tab in Report Studio.
• Creating various types of prompts in the prompt page.
• Doing Unit testing of Reports based on the Report requirement specification.

Environment: Cognos 8BI, Cognos Report net, Cognos Framework Manager, Report Studio Query Studio, Cognos Transformer, Oracle

Confidential

Software Engineer

Responsibilities:

• Going thru’ Report Specification Documents and Understanding the User Requirements
• Creating model by defining proper relationships in Framework Manager.
• Creating Package and Publishing it in Cognos Connection.
• Creating various Kinds of reports like list, cross tab in Report Studio.
• Creating various types of prompts in the prompt page.
• Doing Unit testing of Reports based on the Report requirement specification.

Environment: Cognos Report net, Cognos Framework Manager, Cognos Transformer Report Studio, Query Studio, Oracle

Confidential

Software Engineer

Responsibilities:

• Going thru’ Report Specification Documents and Understanding the User Requirements
• Creating model by defining proper relationships in Framework Manager.
• Creating Package and Publishing it in Cognos Connection.
• Creating various Kinds of reports like list, cross tab in Report Studio.
• Creating various types of prompts in the prompt page.
• Doing Unit testing of Reports based on the Report requirement specification.

Environment: Cognos Report net, Cognos Framework Manager, Report Studio, Query Studio Cognos Transformer, Cognos Impromptu

Confidential

Software Engineer

Responsibilities:

• Going thru’ Report Specification Documents and Understanding the User Requirements
• Creating model by defining proper relationships in Framework Manager.
• Creating Package and Publishing it in Cognos Connection.
• Creating various Kinds of reports like list, cross tab in Report Studio.
• Creating various types of prompts in the prompt page.
• Doing Unit testing of Reports based on the Report requirement specification.

Environment: Cognos Report net, Cognos7.1, Informatica, Oracle