PROFESSIONAL SUMMARY:

• 7 years of experience in analysis, development, testing and implementation of Business Intelligence applications using Cognos Suite products including extensive Functional and Technical experience in Data Modeling, Business Intelligence (BI) and Customer Online Analytical Processing (OLAP), Product Development and Production Support, Interactive Report Generation.
• Expertise on Financial, Pharmaceutical, Retail and Health care Domains
• Understands SDLC methodologies and best practices and how they apply to both OLTP and BI projects.
• Expertise in Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 7/ 8/ 10, Cognos ReportNet.
• Extensive experience in Cognos Tools such as Cognos 8 BI, Cognos Report Net, Report Studio, Query Studio, Analysis studio, Cognos Connection, Framework Manager, Cognos Impromptu 7.x/6.x, Cognos, Analysis Tools such as Cognos Transformer & Power Play 7.x/6.x.
• Experience in Installing and configuring Cognos (Gateway, Report Server, and Content Manager).
• Worked on PowerPlay Transformer 7.x/6.x for Data modeling of the corporate Data for building multidimensional cubes. Created cubes tailored for widespread distribution by using dimension views and user class views.
• Expertise in creating Dashboard reports in Cognos 8 and Cognos 10.1 for the senior management group in the organization.
• Excellent skills in advanced Report authoring which includes Conditional Formatting using Filters and Report Validation.
• Expert in creating List, Crosstab, Drill through Reports and Multidimensional Reports with cascading prompts, Macros, filters, calculations using Cognos. And generated different kind of reports including templates, multilingual reports using Query Studio & Report studio in Cognos BI Suite.
• Responsible for managing the Cognos security strategy for users/groups and provide BI publishing and Monitoring reports.
• Experience in SQL, PL/SQL, Stored Procedures.
• Interacting with the end users on a regular basis for gathering the requirements and resolving issues pertaining to the reports. Provided end user s.

TECHNICAL SKILLS:

Reporting Tools: IBM Cognos BI Tools (Framework Manager, Report Studio, Query Studio, Analysis Studio) v 7/8/10, Impromptu, Cognos Connection, PowerPlay Transformer, Cognos Report Net.

ETL Tools: Informatica 6.x, Data Stage, Cognos Data Manager

Enterprise Tools: Cognos Go Office, SQL Server Enterprise Manager, SQL Query Analyzer, SQL Developer, TOAD for Oracle

Programming: SQL, PL/SQL, HTML, XML, C, C++, JAVA

Databases: Oracle 9i/10g/11g, MS SQL Server, Netezza, MS Access 2000/07, DB2, Teradata.

Operating Systems: Windows NT, Windows XP/2000/2003, UNIX

Other Tools: Microsoft Office Suite 2003/2007

PROFESSIONAL EXPERIENCE:

Confidential, Topeka, KS

Sr. Cognos Developer

Responsibilities:

• Involved in gathering requirements, analyze the existing business requirements and interacted with business users.
• Developed various dashboard reports in Report Studio as per user requirements for them to make decisions on business users.
• Using Framework Manager to build metadata models, packages and publish packages to the cognos connection.
• Created Ad - hoc reports using Query Studio.
• Exposure to creating reports in Cognos 10.1.
• Designed and created Multi Dimensional Cubes using Transformer out of Framework Manager Packages so that all key performance indicators can be analyzed.
• Created Folders, Filters, Prompts, Calculations, and Functions both at package level and at report level based on the users’ requirements.
• Created Complex List, Cross tab, and Line Chart reports using Report Studio.
• Created joins, Unions between Queries, Conditional Blocks, Multiple pages, Master Detail, Variables and Drill through reports in Report Studio for much detailed information.
• Implemented Conditional formatting for highlighting rows and columns, and hiding individual rows.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Created reports having Filters, multiple Prompts (Select & Search prompt, Value prompt, Cascade prompt and Tree prompt).
• In Relational model created Dimensions in Framework Manager for Tree prompts in Cognos Report Studio.
• Deployed Reports & Packages from Development to QA and QA to Production using Deployment.
• Modified reports based on the feedback from QA testers and Users in development and testing environments.
• Worked on migration of Cognos 8.4 to Cognos 10.
• Worked on testing the reports in Cognos 10.
• Schedule the reports (daily and weekly basis) according to user requirements in Cognos. Create and maintain security levels for the reports.

Environment: IBM Cognos BI 8.4/10.1.1 BI (Framework Manager, Report Studio, Query Studio, Analysis Studio, Transformer), SQL Server 2008, Netezza, Data Stage, Windows 7

Confidential, Dallas, TX

Sr. Cognos Developer

Responsibilities:

• Interacting with Business Users for gathering Business Requirements to develop the report mockups. Coordinated the communication between onsite and offshore colleagues.
• Created metadata models using Framework Manager and created joins, deployed packages to the Cognos Connection Portal.
• Created many analysis Dashboards and ad-hoc reports for the business users.
• Preparation of documentation for Cognos Framework Manager Models and reports.
• Developed multiple page reports with page-breaks based on the first page of the report using Master-detail relationship and also developed List, Cross tab, Drill through, Chart and complex reports which involved multiple prompts and multi-queries.
• Created reports having Filters, multiple Prompts (Select & Search prompt, Value prompt, Cascade prompt and Tree prompt), Conditional rendering and Conditional formatting.
• Designed models by mapping business needs using Power Play Transformer and created multi-dimensional cubes, cube groups, Power Play reports.
• Involved in designing future reports, dashboards and scorecards.
• Built Stored Procedures using PL/SQL
• Deployed the packages and reports from development to test environment and test to production environment.
• Schedule the reports (daily and weekly basis) according to user requirements in Cognos. Create and maintain security levels for the reports.

Environment: IBM Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer), PL/SQL, Oracle 10g, Informatica.

Confidential, Mobile, AL

Cognos Developer

Responsibilities:

• Involved in requirements gathering, report design, report development, and components of the data warehouse.
• Created Power Play Reports by using Analysis Studio.
• Created Metadata modeling by using Framework Manager and published packages from Framework Manager to Cognos Connection Server.
• Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
• Created folders, filters, prompts and calculations in Report Studio/Query Studio and Framework Manager and customized data by adding calculations, Filters, Prompts.
• Developed various report types ranging from simple lists, crosstab, chart, through complex dashboards, drill-through, Master-Detail and Conditional formatting reports.
• Created complex, multipage reports involving prompts, Cascading prompts, Conditional rendering and Conditional formatting.
• Created dashboards for immediate visibility into key performance indicators KPIs for corrective action and rapid decision-making. Created Dashboard indicators.
• Developing Multi-Dimensional Analysis and building Financial Power Cubes using Cognos Power Play and Transformer and created the drill through reports for the cubes.
• Create and manage scheduled jobs.
• Develop clear and concise documentation on all work performed.

Environment: IBM Cognos 8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, PowerPlay Transformer), Oracle10g.

Confidential, Franklin Lakes, NJ

Cognos Developer

Responsibilities:

• Gatheird requirements from the user.
• Designed models using Framework Manager and deployed packages to the Cognos Connection Portal.
• Created financial reports in report studio.
• Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.
• Supported Business Users in generating Adhoc Reports using Query Studio.
• Created user groups and provided login credentials for end users.
• Involved in writing SQL queries and Stored Procedures.
• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query in Report Studio.
• Created reports that included ReportNet functionality such as prompt pages, cascading prompts, Conditional filters etc.
• Developed Dashboard Reports using Report Studio.
• Extensively worked on Analysis Studio to develop multi dimensional analysis.
• Created custom prompted reports in Report Studio, Bursting reports to different user groups.
• Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.

Environment: IBM Cognos 7/8 (Report Studio, Query Studio, Analysis Studio, Cognos Connection, Power Play Transformer), SQL Server 2000, Windows.

Confidential

Cognos Developer

Responsibilities:

• Used Cognos Connection for the design of reports using Cognos Reportnet1.1.
• Developed Reports with conditional formatting, Calculations, Variables, Filters and Prompts.
• Generated reports like list, tables, and crosstabs.
• Involved in creating, re-ordering, modifying and deleting prompts in a report.
• Created drill through reports to link two or more reports.
• Testing the reports for data accuracy and consistency.
• Run, view and analyze the reports in different format.

Environment: Cognos 7/8 BI Suite, Impromptu, Cognos Report net 1.1 and SQL Server 2000.