SUMMARY:

• Around 8 years of IT experience in analysis, design, development, implementation and testing of Business Intelligence applications using Cognos products.
• Extensive experience working in Cognos 10.x BI Suite (Framework Manager, Cognos connection, Report Studio, Analysis Studio, Query Studio, Business Insights and Business Insights Advanced).
• Extensive experience working on Cognos Tools - Cognos 8.x Suite (Report Studio, Analysis Studio, Query Studio and Cognos Connection), Cognos Report Net 1.1, MR3, Cognos 7.x Suite (Impromptu, Impromptu catalogs, Impromptu Web Reports-IWR, Power Play Transformer and Power Play Windows/Web, upfront)
• Expertise in Cognos TM1 v10.1 and v10.2.
• Developed various Complex reports using Cognos 8, ReportNet, PowerPlay and Impromptu
• Experience in Data Modeling- Relational, Multidimensional and DMR (dimensionally-modeled relational) modeling in Framework Manager.
• Good communication skills with strong ability to interact with end-users, customers, and team members.
• Good analytical, problem solving and interpersonal skills.
• Ability to work effectively in a team as well as individually.

TECHNICAL SKILLS:

Programming Languages: C, Java scripts, Exposure to Java, J2ee and C++

Reporting tool: Cognos 10.2&8.x Suite, Cognos EP Series 7i (Cognos Impromptu, Transformer, Power play, IWR, Upfront, Power play Enterprise server), Cognos ReportNet 1.1 MR3., Cognos TM1

Statistical tool: SPSS, eviews

Databases: Teradata, SQL Server, DB2, Oracle

Operating Systems: Windows, Unix/Linux

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, PA

Sr. Cognos Developer

Responsibilities:

• Analyzed existing solution containing cubes, reports, and materialized views and worked with the functional team to create technical documents.
• Created complex DMR models using framework manager and helped create Materialized views.
• Created complex reports using report studios and Cognos workspace advanced.
• Created unit test documentations to test the Cognos solution.
• Worked with the testing team using HP Quality Center to close and clarify defects/enhancements.

Environment: Cognos 10(Framework Manager, Report Studio and Query Studio), Cognos 8.4 suite (Framework Manager, Report Studio, Analysis Studio, Query Studio), Oracle 9i (SQL, PL/SQL), Cognos TM1 9.5/10.1.

Confidential, DE

Sr.Cognos Developer

Responsibilities:

• Designed and developed TM1 Models/Solutions to meet user requirements using hierarchies, structures and processes
• Designed and developed interfaces between TM1 and Relational Databases
• Created cubes and maintain load processes
• Built and maintained templates and web sheets
• Monitored performance and implemented improvements as necessary
• Worked closely with business users to understand the requirements
• Built Framework Manager Model, and established the cardinalities to suit the business needs.
• Implemented security for Data access, Object level access and Package access.
• Developed and Published Packages in Framework Manager - Connecting and testing the data source, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.
• Define Global Drill through Definitions and established drill-through from Cognos 8.4 analysis Studio to Cognos 8.4 Report Studio.
• Developed Reports using Conditional Formatting, Cascading Prompts and Report Bursting.
• Design and implement reporting interface utilizing Cognos impromptu reports and Cognos cubes.
• Generated IQD files to feed Powerplay Transformer Models to create Multidimensional cubes to generate Powerplay reports.
• Developed Models based on the dimensions, levels and measures required for the analysis.
• Executed scripts to refresh the cubes on a daily and weekly basis.
• Published Cubes and Reports to Upfront through Power play Enterprise Server.
• Designed Power Play reports to provide summarized results by measures and dimensions.
• Design and Built Power Play Cubes and worked on Performance Tuning.

Environment: Cognos 10(Framework Manager, Report Studio and Query Studio), Cognos 8.4 suite (Framework Manager, Report Studio, Analysis Studio, Query Studio), Oracle 9i (SQL, PL/SQL), Cognos TM1 9.5/10.1.

Confidential,NJ

Cognos TM1 and BI Consultant

Responsibilities:

• Worked with IT Development team to ensure feasibility of design and clarify user requirements. Also worked with the team to create POCs.
• Worked with Data Architects to create a solution roadmap, based on cross-organizational planning and forecasting tool using Cognos TM1.
• Created ETL (Extraction, Transformation & Loading) processes using TurboIntegrator in Cognos TM1 performing business rule mappings of relational data into dimensional model.
• Designed dimensions, hierarchies, attributes and cubes, creating cubes and cube rules associated.
• Involved in creating TurboIntegrator (TI) programs to process data, writing system documentation.
• Performed Data Analysis and developed Data Mapping documents for ETL projects.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data. Worked with the business team to gather business requirements and prepare High Level design, detailed level design documentation.
• Performed Requirement Testing, Unit Testing and User Acceptance Testing
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Validated reports based on Functional Requirements.
• Involved in designing and Preparing Test Scenarios, Test Plans, Test Cases and Test Data.
• Checked the reports for any naming inconsistencies and to improve user readability.
• Used Mercury Quality Center for Bug Tracking, Reporting and Analysis.
• Developed test cases for deployment verification, report testing.
• Performed requirements testing, system and integration testing as well as UAT.

Environment: Cognos TM1 9.4, Cognos BI, Oracle, SQL Server, Informatica 8.6, Datastage, Mercury Quality Center, MS Excel, QTP, Windows XP

Confidential, Danbury, CT

Sr. Cognos Developer

Responsibilities:

• Installation and configuration of the Cognos 10.2 in Development environment.
• Gathered report requirements from Business Users and converted them in to technical documents
• Experience in building models using Framework Manager & creating simple to complex reports in Report Studio.
• CreatedPackagesandDMR modelsinFramework Managerby importingmetadatafrom different data sources with use of data modeling.
• Used CognosFramework Managerto create different views (Database View, Business View, Presentation View) using SQL Server Database.
• Involved in Deploying cubes, packages and Reports from Development to Production environment.
• Designed & Implemented List, cross tab, chart, drill through, master-detail and complex reports with Multiple Pages/Prompts in Report Studio.
• Created multi-page reports based on multiple master queries to show the data on different pages when the master record changes in a report using Report Studio
• Created reference queries and increased performance by preventing the execution of individual queries within reports.
• Performance tuning of the reports implemented by creating summarized tables, views and appropriate indices.
• Developed Dash board reports to display all the information related to environment using Summary reports.
• Developed complex reports using Cognos Version 10.2 using Crosstab having different calculations, data items and customized Page Formatting.
• Customized data by adding no. ofprompts, Filters, Calculations, SummariesandFunctions.
• Created Master Detail reports, drill through and custom prompting reports, and Scheduled reports for efficient resource utilization.
• Created documentation for the complete project life cycle and mentored the End Users and Provided the Technical Support.
• Providing training for users.
• Worked on testing.

Environment: Cognos 10.2 (Framework Manager, Query Studio, Report Studio, Metric studio, Event Studio, BI, BIA), Oracle 11.2,SQL Sever

Confidential

Cognos Consultant/ Data Analyst

Responsibilities:

• Involved in all phases of development life cycle including requirements gathering, analysis, design, development, implementation, debugging, documentation, and testing.
• Created Framework manager models and packages practicing best modeling techniques keeping long term aspects like knowledge transfer, maintainability etc. in perspective.
• Developed new reports using Report Studio which includes Cross tab, master-detail reports, drill-through, prompts, bursting reports, charts.
• Designed and developed models to create cubes in Transformer for OLAP analysis. Also involved in enhancing existing cubes.
• Created complex reports using cubes in Analysis Studio.
• Scheduled and Distributed reports using Schedule Management in Cognos Connection.
• Documented business requirements, work instructions, how-to user manuals, power user manuals and best practices at various levels.
• Provided training to business users on Cognos Query Studio, Report Studio and navigation through the Cognos Portal.
• Worked with Business Units to define Business strategy for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Streamlined mechanism for both standard and ad-hoc report requests.
• Created Incident/Service request tickets in HP Service Center.
• Constantly worked with business users, onsite and/or offshore technical team to ensure deliverable quality and deadlines (SLAs) are met.
• Deployed packages, folders and content store from a development environment to test and then to production environments.
• Closely worked with ETL team to design data marts by understanding user requirements.
• Created KPI reports and assisted business users analyze data.
• Used Cognos Connection for organizing, security, scheduling and distributing reports.
• Extensively developed complex Ad-Hoc reports by writing SQL queries to pull data from multiple data sources.

Environment: Cognos8 BI Suite (Framework Manager, Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Connection), Cognos EP Series 7.3 (PowerPlay, Transformer, Impromptu, PPES, Upfront, MS Office 2003 Suite, SQL Server 2000, Oracle, Windows XP.

Confidential

Cognos Developer

Roles and Responsibilities:

• Helped in gathering requirements for reports and Analysis Studio Packages.
• Creation of proof of concept cognos objects for security implementation.
• Creation of Framework Manager Model.
• Creating Ad-hoc packages, Analysis Studio Packages and challenging report studio reports involving crosstabs and charts.
• Preparing user guides for Query Studio, Analysis Studio
• Providing training for users.
• Worked with migration team in creating documents for deploying Cognos objects in testing and production environments

Environment: Cognos 8, Report Studio and Ad hoc and Analysis Studio Packages, Teradata

Confidential

Cognos Developer

Roles and Responsibilities:

• Gathering requirements for reporting
• Creation of the framework manager model
• Creating Ad-hoc packages, Analysis Studio Packages and challenging report studio reports involving crosstabs and charts
• Guiding reporting team in creating reports

Environment: Cognos 8, Report Studio, Query Studio and Analysis Studio, Teradata

Confidential

Cognos Developer

Roles and Responsibilities:

• Gathering requirements for reporting
• Creation of the framework manager model
• Creation of report Studio reports
• Writing test cases for testing of reports
• Handling all cognos related functions in the project
• Providing User training

Environment: Cognos Reportnet 1.1, Teradata