SUMMARY

• Over 8 Years of work experience in IT Industry in Data Analysis and Business Intelligence experience with complete SDLC.
• Major skills in IBM Cognos BI Reporting Development, Modeling and Administration.
• Experience in writing complex reports involving Drill - Through, Cascading Prompts, Crosstabs, Summary Reports, Audit Reports, Dashboard reports and advanced Visualizations using Cognos BI development studios.
• Has taken up various roles during my career involving application developer and modeler, requirement consultant, onsite coordinator and support associate.
• Develop Event studio agents / Batch Reports for different business scenarios and distribute them across user groups using Scheduling.
• Experience in working with business users to provide expertise in problem definition, requirements analysis and the general design and support of the BI System.
• Excellent analytical problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels and experience in providing noledge transfer with respectiveCognos to the associates.
• Experience in Databases like Oracle and SQL Server using TOAD & SQL Developer.
• Excellent team player with TEMPeffective documentation, presentation, communication and leadership abilities.

TECHNICAL SKILLS

Cognos BI Reporting: Professional report authoring, Workspace-advanced/ Report-Studio, Modeling, Migration.

Database Systems and Tools: Oracle v 8i, 10g, MS SQL Server 2005, MS Office 2010 Tools.

Operating System, Services: MS Windows, IIS.

Programming Languages: C, Java (Basics), Java Script.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Cognos BI Developer

Responsibilities:

• Involve in full project lifecycle from taking customer transition, requirement gathering, business analysis, design and build through to implementation.
• Discussing requirements with various Business Users and suggesting possible solutions to a given requirement leveraging noledge on system.
• Designing the metadata model using Cognos FM (with DMR functionality) and development of Cognos Report Studio Reports with drill up/down and drill-through functionality.
• Single handedly created the BI Dashboard and various Cognos reports used by Business for making critical decisions.
• Picked up extra initiative to don Cognos admin role which included promotion of Cognos reports across different environments, assigning access and roles to Users.
• The defects in UAT phase were recorded in a ticketing tool called Assembla. me was involved in keeping track of the defects raised by users, resolving them based on the priority as per their business impact and making sure that the ticket is closed once the issue is fixed.
• Interacting with the business users directly on daily basis to understand the issues they faced and fixing them up on priority.

Tools Used: Cognos Report Studio 10.2.1, Cognos Framework Manager, SQL Server 2008 R2.

Confidential, CT

Cognos BI Developer

Responsibilities:

• Involve in analyzing the requirements, understanding the functionality and accordingly documenting them for reference and future follow-through.
• Understanding the business requirement and implementing the logic in Cognos Framework Manager model while defining the relationship/cardinality between the tables.
• Involve in developing Cognos Dashboard/Reports using Report Studio and Query Studio.
• Running the SQL queries on the Database to check the consistency of data in Cognos reports and taking the necessary actions in case of any discrepancy/issue.
• Looking into the presentation part of the Cognos to make the reports more user-friendly and informative.
• Involve in preparing the Unit test plan and procedures for testing purpose.

Tools Used: Cognos Report Studio 10.1, Cognos Framework Manager, SQL Server 2008 R2.

Confidential

BI Developer

Responsibilities:

• Discussing requirements with various Business Users and suggesting possible solutions to a given requirement leveraging noledge on system.
• Ensuring accuracy in the information delivery, ad-hoc analysis and interactive dashboards with iterative user interactions based on their frequently changing requirements.
• Single handedly worked on many complex metadata model changes using Cognos FM and development of Cognos reports and dashboards.
• Develop Event studio agents and schedule the report output accordingly.
• Reports developed are lists, charts and crosstab reports which uses concepts like drill-through, calculations/totals, multipage rendering, cascade prompts, java scripts, Conditional formatting, Complex Joins for various business scenarios etc.
• Onsite coordinator and a single point of contact for the Business users for any BI related information.
• Responsible for data reconciliation and creation of ad-hoc BI reports for the users to fulfil their immediate requirements.
• Educating the users about the data granularity, usage of the reports.
• Implemented several New/Change requests from the Business during the UAT phase.

Tools: IBM Cognos 10.1, Netezza 7.0.

Confidential

BI Developer

Responsibilities:

• Understand the requirement and thereby creating the relationship between the tables imported.
• Responsible for importing tables from Oracle database into the Cognos Framework Manager.
• Involved in few report development activities and testing.
• Assigning security to the end-users.
• Involved in certain Production Support tasks related to validation of cubes and generating Cognos Impromptu report outputs.

Tools Used: Cognos Framework Manager V 8.4, Cognos Report Studio 8.4