SUMMARY:

• 10+ years of experience in SDLC (design, development, testing and implementation) of Cognos Business Intelligence applications.
• Have 10 Years of Total ITS Experience, 9 Years of experience in Cognos, 1 Years of experience in Tableau.
• Confidential Certified Designer, Developer, Administrator.
• Experience in the development of Data Warehouse Applications using Cognos 11.0.7 latest version, Cognos TM1, Cognos 10.2.1 Report Studio, Query Studio, Event Studio, Analysis Studio, Cognos Suite i.e. Cognos 8.4, Framework Manager, Dynamic Cubes, Transformer, Power Play and database MSSQL Server 2012 & Oracle 9i (SQL),
• Strong in developing Cognos Framework manager models and publishing the packages into Cognos environment using various data sources like Oracle and SQL Server etc.
• Developed models for implementing multi - dimensional reporting (DMR).
• Used stored procedures in Cognos Framework manager.
• Created multiple data source connection in order to read the data from multiple databases.
• Implemented security in Cognos Framework Manager by integrating with third party security namespaces like LDAP, Active directory to configure login mechanisms to apply package, object and data level securities.
• Worked on Cognos Work Space, Cognos Work Space Advanced for building the Dashboards.
• Worked on Active Reports & Rave Visualizations.
• Worked on building cubes using Transformer and implemented column based partitioning, time based partitioning for optimum performance.
• Created cubes using the existing multi-dimensional package to overcome performance issues.
• Experience in dealing with performance tuning of reports.
• Involved in Upgrading the Cognos 8.4 Reports to Cognos 10.2.1
• Sending Notification mails to the end users using Event studio.
• Worked on implementing the Macros in Framework manager and as well in Report Studio
• Created Jobs & Report Views in Cognos Connection for Scheduling Purpose and Burst the Reports based on Primary Key ID.
• Implemented various functionalities in report studio like Drill up & down, Drill through, Master Detail Relationship, Conditional Blocks, Cascading Prompts, Table of Contents, Repeater Tables, Calculations, Filters, Bursting, Variables and Java script etc.
• Implemented various functionalities in Framework manager such as Governors, Query set, Filters, Calculations, Joins, Scope, Hierarchies and Determinants.
• Worked on Deployment Process when moving the Reports from DEV environment to SIT
• Involved in finalizing the Report Specification and also preparing the Functional design documents, Mapping sheets & Unit test cases as per the Business Requirement.
• Worked on Dynamic Cubes for all the Fact tables which brought into Cognos environment.
• Created dimensions, cubes and processes using TM1 architect for Finance department
• Developed User Interfaces, Reports, Rules and Turbo Integrator processes using Cognos TM1 for Expenses, Revenues, Salary and Compensation, Headcount, Budget Variance and Summary
• Worked with creating Business Rules that perform calculations, such as average price, currency conversions, and price/earnings ratios in TM1.
• Validating data and Comparing in TM1 prospective excel and in TM1 web with Cognos Report Studio.
• Creation of rules using the rules editor and adding Business Rules to Cubes. Scheduling of TM1 process for data population.
• Integrated TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.
• Created Parameters & Maps for showing the results based on User id at run time.
• Worked on Tableau Desktop and published the Report the reports in Web using Tableau Server.
• Imported the Excel file Data in Tableau Desktop and designed work sheets and Created Dashboards.

TECHNICAL SKILLS:

BI Tools: Cognos 11.0.7, 11.0.5,11.0.4,10.2/10.1/8.0/8.2/8.3/8.4 Report Studio, Data Modules, Data Sets, Dashboards, Cognos TM1 10.2.2, Turbo Integrator, TM1 Architect, TM1 Web, Query Studio, Analysis Studio, Work Space, Cognos BI Suite 8.4, Framework Manager, Cognos 8.4, Cognos Go Office, Tableau

Databases: Denodo, Netezza, MS SQL server 2012/2008/2005/2000, Teradata, Oracle 11G/10g/ 9i/8i. DB2

Knowledge on: OBIEE, Boot Strap, Angular JS

Languages: C, C++, .Net

Scripting Languages: HTML 5, CSS, JavaScript, JQuery

Operating Systems: Windows XP, 7

PROFESSIONAL EXPERIENCE

Confidential, CA

Cognos/BI Architect

Responsibilities:

• Translate business needs for projects and broad scale initiatives into information solutions that improve business decisions.
• Promote and adhere to Data Management processes and procedures and provide input to the creation of data definitions, business rules and data access methods.
• Remain abreast of current and future Business Intelligence technology and BI analysis methods. Analyze and recommend new technology for use at VSP.
• Creating FM Model Package for to develop the reports.
• Develop Data Modules & Data Sets to create the Dashboard.
• Creating Dashboards in Exploration
• Identify the Bugs in Cognos 11 and raised PMR to Confidential .
• Involved in creation of Drill -Through and Master-Detail, Drill Up & Drill Down reports.
• Working on Active Reports to improve the performance of the Reports.
• Created Security for Managers, District Managers & Sales Reps.
• Involved in Performance Tuning of the reports.
• Identify opportunities for innovation and improvement of cross line of business, line of business, and division processes.

Environment: Cognos 11.0.7, Denodo, Netezza, JavaScript

Confidential, NC

Cognos Lead

Responsibilities:

• Worked on different streams like Key Measures, Monitoring & Testing and Enterprise Reference Data.
• Experience working directly with the business users for gathering requirements, manage scope and schedule.
• Involved in writing the Technical design documents and Unit testing documents
• Design and implementing Physical/Logical/Dimensional Layers in DMR Modeling.
• Implemented the Security (package, object and data level).
• Passing parameters to Stored Procedure from Framework manger
• Created the reports as per the business requirements
• Created various types of reports like List Reports, Cross tab Reports Chart Report & Master Detailed Reports as per the client requirements.
• Involved in creation of Drill -Through and Master-Detail, Drill Up & Drill Down reports.
• Prepared various reports using cascading prompts and value prompts in Cognos Report Studio.
• Developed reports based on conditional formatting.
• Created reports Views and scheduled in Cognos connection.
• Worked on Cognos Go Office to generate the reports in Power Point Version
• Created dimensions, cubes and processes using TM1 architect for Finance department
• Developed User Interfaces, Reports, Rules and Turbo Integrator processes using Cognos TM1 for Expenses, Revenues, Salary and Compensation, Headcount, Budget Variance and Summary
• Worked with creating Business Rules that perform calculations, such as average price, currency conversions, and price/earnings ratios in TM1.
• Validating data and Comparing in TM1 prospective excel and in TM1 web with Cognos Report Studio.
• Creation of rules using the rules editor and adding Business Rules to Cubes. Scheduling of TM1 process for data population.
• Loading and Maintain Data in Cube using Turbo Integrator. Optimize the Rule Performance by adding SKIPCHECK and FEEDERS.
• Integrated TM1 cubes with Cognos 10.2 and used as a source to build BI reports in Report Studio.

Environment: Cognos TM1 10.2.2, Turbo Integrator, TM1 Architect, TM1 Web, Cognos 10.2.1 Report Sudio, Cognos go Office, Javascript, SQL Server.

Confidential, NC

Cognos Lead

Responsibilities:

• Experience working directly with the business users for gathering requirements, manage scope and schedule.
• Involved in writing the Technical design documents and Unit testing documents
• Design and implementing Physical/Logical/Dimensional Layers in DMR Modeling.
• Implemented the Security (package, object and data level).
• Passing parameters to Stored Procedure from Framework manger
• Created the reports as per the business requirements for different university Plans
• Created various types of reports like List Reports, Cross tab Reports Chart Report & Master Detailed Reports as per the client requirements.
• Involved in creation of Drill -Through and Master-Detail, Drill up & Drill Down reports.
• Prepared various reports using cascading prompts, Text box prompts and value prompts in Cognos Report Studio.
• Developed reports based on conditional formatting.
• Created reports Views and scheduled in Cognos connection.
• Created cubes using the existing multi dimensional package to overcome performance issues.
• Used Windows Scripts to update the Cube in a timely fashion so that reports using the Cube will pick the latest data
• Created Worksheet using Tableau Desktop
• Created Dashboards using the worksheet developed in Tableau Desktop
• Publishing the Desktop Reports to Web using Tableau Reports.
• Created Visualizations as per the User Requirement

Environment: Cognos 10.2.1, Tableau 8.3, Teradata, Javascript, SQL Server

Confidential

Senior Cognos Developer

Responsibilities:

• Prepared the reports specification documents to meet the user requirements
• Involved in estimations of the reports for each Release
• Worked on Requirement gathering & understanding the requirement and implementing them in Cognos.
• Implemented the CxO Dashboard for Claims & Underwriting reporting users using Cognos Workspace Advanced.
• The Confidential Asset Solvency II QRT Reports deployed and changed as per the Confidential requirements.
• Design and implement Physical/Logical/Dimensional Layers in DMR Modeling.
• Implemented Dynamic Cubes for all the Fact Tables to improve the performance.
• Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.
• Creating the Dimensional Layer for implementing the DMR Concepts
• Setting the scope between dimensions and Measures
• Implemented the Security (package, object and data level).
• Created the Database Views to meet the critical reporting requirements and imported into FM.
• Created the reports as per the business requirements for different functional areas like (Compliance, Claims, Underwriting)
• Created Database connection so the same Report will automatically point to Confidential /APOLLO Database, So Confidential user will see Confidential Data in the reports and Apolli Users will see Apollo Data in the Report.
• Implemented drill-through and drill down/up functionalities into the same report
• Created complex Drill-through, Master-Detail, Conditional formatting and Cascading Prompts reports.
• Created Dashboard in Cognos Work Space and as well using Portlets.
• Implemented Security for different Groups.
• Created Dynamic linking in between the Reports
• Created Jobs and Report Views for Scheduling the Reports
• Created Worksheet using Tableau Desktop
• Created Dashboards using the worksheet developed in Tableau Desktop
• Publishing the Desktop Reports to Web using Tableau Reports.
• Created Visualizations as per the User Requirement
• Worked on Informatica for extracting the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Used Debugger to test the mappings and fixed the bugs.

Environment: Report Studio, Work Space, Analysis Studio, Javascript, Framework Manager, Tableau, SQL Server

Confidential

Senior Cognos Developer

Responsibilities:

• Interacted with client, onsite team for gathering the requirements.
• Analyzed the requirements with a technical insight and provided estimations for the work.
• Independently prepared Report spec documents.
• Responsible for developing / enhancing complicated Reports.
• Integrating these reports in a Dashboard and passing communication between these Reports in the Dashboard.
• Creating portlets for the user to Navigate to the Dashboard directly.
• Developed the Summary Reports and Detail Reports for Internal Business Process.
• Developed the reports using Crosstabs.
• Prepared the reports using prompts, cascading prompts, filters and variables in report studio.
• Used Drill Up and Drill down feature in the reports.
• Used Rendering based on conditions.
• Showing Trending Images in Crosstab measure based on Values shown in the Crosstab.
• Performed Conditional Styling for the numbers shown in the Crosstab.
• Designing drill through reports for analyzing the business performance.
• Created Jobs and Report Views for Scheduling Purpose.
• Moving the Reports from Test Environment to Production Environment.

Environment: Report Studio, Event Studio, Analysis Studio, Framework Manager, SQL Server

Confidential

Senior Cognos Developer

Responsibilities:

• Understanding the business requirements for the development of reports and designing the reports
• Involved in Creating / Updating Framework Manager Models
• Created Triggering Events by using Event Studio for automatic mailing the reports
• Developed list reports and cross tab and chart reports.
• Prepared the reports using prompts, cascading prompts, filters and variables in report studio
• Used Query studio for Ad-hoc Reporting and Report studio for Advanced Reporting
• Developed and Executed Test Cases.
• Used conditional formatting based on Threshold values.
• Used Rendering based on conditions.
• Designing drill through reports for analyzing the business performance
• Used JQUERY core library functions for the logical implementation part at client side for all the application.

Environment: Report Studio, Event Studio, Analysis Studio, Framework Manager, Teradata

Confidential

Senior Cognos Developer

Responsibilities:

• Analyzing the changes requested for the reports from the specification and identifying the gaps.
• Involved in Creating / Updating Framework Manager Models.
• Create complex reports in Report studio.
• Prepared various reports using cascading prompts, Text box prompts and value prompts in Cognos Report Studio.
• By using Event Studio attaching multiple report outputs to a single email
• Designing drill through reports for analyzing the business performance
• Preparing the Test cases for the reports based on the spec.
• Used conditional formatting based on Threshold values.
• Used Rendering based on conditions
• Created reports Views and scheduled in Cognos connection

Environment: Report Studio, Event Studio, Analysis Studio, Framework Manager, Oracle10g

Confidential, IL

Cognos Developer

Responsibilities:

• Used Report Studio to develop various types of reports like List Reports, Cross tab Reports Chart Report & Master Detailed Reports as per the client requirements.
• Involved in creation of Drill -Through and Master-Detail reports.
• Prepared various reports using cascading prompts, Text box prompts and value prompts in Cognos Report Studio.
• Created Drill up & Drill down in Reports
• Developed reports based on conditional formatting.
• Created reports Views and scheduled in Cognos connection.
• Preparing the Test cases for the reports based on the spec.
• Created reports Views and scheduled in Cognos connection

Environment: Report Studio, Query Studio, Oracle10g