SUMMARY:

• Senior accomplished Cognos BI Developer with 9 plus years of experience in design, development, testing, implementation and documentation of business, financial and technical applications in client/server and web based Business Intelligence environments.
• Extensive experience in Cognos Tools such as Cognos 11 Analytics, 10.2.1 BI suite, 10.2.0 BI Suite, 10.1 BI Suite, Cognos 8 BI Suite (Framework Manager, Cognos connection, Report Studio, analysis Studio, Query Studio & Event Studio) Cognos Report net 1.1.MR3, Cognos Impromptu 7.x, Cognos IWR 7.x and Analysis Tools such as Cognos Transformer & Power Play 7.x.
• Experience in Designing models using Framework Manager and deploying packages to the Report Servers.
• Experience in Sales Reporting and worked on ERP and CRM systems.
• Created cubes using TM1 perspective by defining measures and dimensions as required by business.
• Created multiple rollups in a dimension and complex calculations by using TM1 rules.
• Worked on various TM1 functions for Microsoft visual basic.
• Migrated objects from OBIEE to cognos analytics.Cre
• Upgraded from cognos 10 to cognos 11 analytics.
• Retested report contents and performed comparisons testing in between the versions while upgrading to cognos 11.
• Installed and configured cognos 11, created content store and verified all hardware requirements are met.
• Experience in Framework Manager Modeling (Database Layer, Business Layer, Presentation Layer).
• Sound working knowledge of building Complex reports, Burst Reports, Drill Through reports, Cascading Reports, Cross Tab Reports and Summary Reports. Created complex reports, drill through reports, dashboards using report studio.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Experience in developing multi - dimensional model design and cube building, security using Cognos Transformer.
• Used Cognos Connection for scheduling and bursting reports across the Business segments.
• Created complex dashboard reports in cognos 11.
• Installation of various Cognos tools in Distributed Environment (Development, Test and Production).
• Involved in migration from Cognos EP Series 7 (7.3 and 7.4) to Cognos 8 BI latest version 8.4.
• Experienced in performance tuning and optimizing of the reporting solution.
• Created Drill through, drilldown, sub reports and nested data regions in SSRS.
• Experience in writing SQL, PL/SQL, Oracle, Teradata, Stored Procedures, Functions, Packages as per business requirements.
• Knowledge in working on Extraction, Transformation and Loading (ETL) using Informatica 8.X.
• Strong knowledge in data warehousing concepts (Star schema, Snow Flake Schema, Fact constellation schema).
• Proficient in building front-end BI applications according to specifications.
• Strong analytical, conceptual, and problem-solving abilities.

TECHNICAL SKILLS:

• Cognos 11 Analytics (11.0.6),
• 10.1,10.2,10.2.BI Suite (Framework Manager, Cognos Transformer,
• Cognos connection,
• Query Studio,
• Report Studio,
• Analysis Studio),
• Cognos 8.1, 8.2, 8.3, 8.4,
• CRN 1.1 MR3,
• Cognos TM1 10.2.0,
• Cognos TM1 9.5.2,
• Cognos EP Series 7.x
• (Power play Transformer,
• Power play Windows/
• Web, Impromptu, Upfront)
• SSRS, SSIS, SSAS
• C, C++, Core Java, HTML, JavaScript, SQL server 2008/12, PL/SQL.
• MS SQL Server 2005/2008,
• Oracle 9i/10g, 11g, IBM DB2,
• MS Access, Teradata.
• Informatica PowerCenter 8.1/8.6, Cognos 8 BI Data Manager.
• IIS, Tomcat, Apache.
• Active Directory,
• Sun One Directory,
• Apache Directory.
• Windows XP/VISTA, UNIX.
• MS Office, QTP.

PROFESSIONAL EXPERIENCE:

Senior Cognos BI Developer

Confidential, NJ

Responsibilities:

• Developed various framework manager models based on business requirement and published packages to cogon’s connection.
• Worked on various complex reports from the scratch level to meet user requirements at various levels such as trade, position, desk and sub desk.
• Created reports based on TM1 cube as a data source for better performance.
• Created models in the transformer and published cubes to cognos connection.
• Worked on complex dashboards that are directly used by executives.
• Optimized the performance of the reports by tuning database query.
• Assisted users in creating TM1 web and TM1 reports.
• Created temporary views, subsets using turbo integrator.
• Upgraded from cognos 10.2.0 to cognos 11.0.6, upgraded content store in the process.
• Resolved validation and configuration issues in the process of upgrade from cognos 10 to 11.
• Involved in regression, unit, performance and user acceptance testing at various stages before used by the business.
• Created advanced cube reports in cognos analysis studio..
• Used Motio CI in order to deploy reports and models to various environments, as well as for versioning.
• Using and understanding the prolog, epilog tabs in turbo integrator process.
• Created complex business calculations in TM1 using rule editor.
• Designed and built cognos powerplay cubes.
• Worked on complex conditional formatting, calculations and created active reports for users so that they can use them on the go.
• Created drill through within the same report as well as drill through pointing to a different report, Worked on master-detail functionality as well.
• Worked on reports with various objects such list, crosstabs, charts, repeater tables which involved using conditional blocks and layout component reference.
• Used java scripts to create tab buttons within the reports and provide commentary functionality within the reports.
• Experience in writing SQL, PL/SQL, Oracle, Teradata, Stored Procedures, Functions, Packages as per business requirements.
• Created complex stored procedures and pipeline functions that are accessed by the report for pulling summary level records and detail level rejects.
• Worked extensively on various dimensional functions such as tuple, children, caption, ancestors, descendants and so on.
• Involved in administering data source connections and checking if dispatchers and query services are working properly.

Environment: Cognos 10.2.0(Reporting studio, Analysis studio, Query studio, workspace advanced, Cognos connection, Framework manager, powerplay Transformer, Administration), Cognos 11.0.6 Analytics, Cognos TM1 10.2.0(Perspectives, Turbo Integrator, Architect, Performance modeler), TOAD, Oracle 11g, SQL server 2012, Teradata 14.10, Windows 7.

Senior Cognos BI Developer

Confidential, FL

Responsibilities:

• Created complex reports including multiple pages and queries to calculate closing cost involved in closing contract.
• Created multiple adhoc reports for deeding and documents compliance department.
• Created source packages for reports and published packages based on them.
• Upgraded from cognos 10.1 to 10.2.1, involved in configuring the content store and validating the reports.
• Created Projects, Namespaces, Models and Packages using Cognos Framework Manager and deployed packages to Cognos Connection.
• Used sql as a source, based upon which reports were generated.
• Use TM1 rule editor to create and edit various business calculations.
• Created and arranged different TM1 rule statements and performed complex calculations for cubes at different level.
• Implemented security socket layer (ssl) protocol on web server hosting cognos BI gateway.
• Created multiple dashboard reports involving drill through, master detail functionality, as well as applied conditional formatting.
• Created cubes in TM1 architect by using subset editor, dimension editor.
• Created SSRS reports in report designer and report builder.
• Created report specifications based on user requirement and then developed and implemented business intelligence solutions.
• Created active reports for the users such that they can be consumed by them through ipads or their mobiles.
• Managed all activities and schedules on daily basis, monitored and restarted dispatcher when required.
• Created multiple lists, crosstabs and charts reports with filters, calculations, summaries, prompts and functions.
• Created reports based on dimensional functions such as ancestor, closing period, period to date, aggregate and so on.
• Optimized the performance of the reports, created multiple prompt pages and conditional variables.
• Used java script in order to change the prompt controls in report studio.
• Involved in unit, functional, regression, performance and acceptance testing while in different stages of report design and development.

Environment: Environment: Cognos 10.1.0,10.2.1(Reporting studio, Analysis studio, Query studio, Business insight, Cognos connection, Power play Transformer, Frame work manager, Administration), Cognos TM1 9.5.2(architect, performance modeler), SSRS, SQL server 2012, Oracle 11g, Windows 7.

Senior Cognos BI Developer

Confidential, PA

Responsibilities:

• Created source iqds in order to build OLAP cubes through power play modeling tool transformer.
• Worked on designing complex dimensional models by creating various dimensions, measures and calculations in transformer.
• Worked on various impromptu reports and power play (.ppr) reports in cognos 7.
• Created multiple complex reports for the top management, which are firm based, fund based and has overall sales and redemptions.
• Configured access manager to set up an authentication source, which defines the servers, and data sources that users can access.
• Did perform upgrade from cognos 7.4 to 7.5 v and configured the products using configuration manager and also installed cognos fix packs.
• Involved in migration from cognos 7.5 to cognos 8.4 and then to cognos 10 version and verified the corresponding reports.
• Deployed dimensional cubes to cognos connection and then published them as packages to be used for reporting.
• Interacted with the business users, documented their queries and reporting needs.
• Created multiple reports adhoc reports using query studio based on user’s request.
• Worked with decision stream an ETL tool to load and transform the data such that it is suitable for reporting.
• Created complex dashboards in cognos 10 business insight with a combination of lists and crosstabs.
• Created various monthly, weekly and quarterly reports in reports studio by creating parameterized filters and prompts.
• Created Projects, Namespaces, Models and Packages using Cognos Framework Manager and deployed packages on Cognos Connection.
• Created folders, filters, prompts, and complex financial calculations in Framework Manager and Report Studio.
• Created active reports in report studio which are highly interactive and can be consumed by the user offline.
• Developed stored procedures and user defined functions using PL/SQL

Environment: Cognos 10.1.0(Reporting studio, Analysis studio, Query studio, Business insight, Cognos connection, Power play Transformer, Frame work manager), Cognos 8.4, Cognos 7.4,7.5(Impromptu, power play, decision stream, Upfront), IBM DB2, SQL server 2008, Oracle 10g, Windows XP/7)

Senior Cognos BI Developer

Confidential, MI

Responsibilities:

• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, Multi-query, Cubes in Report Studio.
• Created custom prompt reports and dashboards in Report Studio.
• Involved in Query Optimization, Creating Query Prompts, Developing Prompt pages and Conditional variables.
• Worked on reports, which are based on Sales packages and dealt with ERP AND CRM systems.
• Developed standard Templates for various kinds of reports.
• Added prompts and filters to modify existing reports to accommodate change in user requirements.
• Created professional reports in Report Studio and ad hoc reports in Query Studio.
• Created dashboards (crosstabs and charts) to display the business details from different aspects and using different representations.
• Modified the existing reports by adding required prompts to comply with changes in the business requirements.
• Created simple to complex reports as well as Dashboard like reports using Report Studio by applying various concepts and functionalities such as drill-through, conditional reporting, block, tables, master-detail, charts, various calculations and joins using tabular sets and tabular models
• Worked on Cognos 10.1 Report Studio to build multiple crosstab, list and chart reports.
• Created folders, filters, prompts, and complex calculations in Framework Manager.
• Involved in design and development of joins, filters and calculations in Packages within Framework Manager.
• Worked on Relational Models in order to built multipage prompts and complex crosstab reports.
• Created complex reports such as Customer Invoice, Bookmark, Product Analysis and Multi-Prompt reports.
• Created complex custom queries to optimize the Report Studio report performance.
• Created Drill through from Analysis Studio to Report Studio Reports.
• Created new calculated columns which are not present in the published packages.
• Used Cognos Connection for scheduling and bursting reports across the Business segments.

Environment: Cognos Suite 10.1(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager, PowerPlay Transformer), Oracle 10g,DB2, Teradata, Windows XP.

Cognos BI Developer

Confidential, CA

Responsibilities:

• Gathered business and functional requirements, estimated time, designed, developed and implemented Business Intelligence solutions.
• Design, Develop and Implement end-to-end Business Intelligence Solutions.
• Developed Summary and Detail Reports.
• Created Database Tables and Loaded Data from Excel Sheets and Feeds.
• Creating Query Prompts, calculations, Conditions & Filters, Prompt pages and Conditional variables.
• Developed standard Templates for various kinds of reports.
• Creating New Jobs and Data sources in Cognos Connection.
• Implemented data and user level security in Cognos Connection.
• Developed Standard Reports, Charts and freestyle reports using Report Studio.
• Created Packages in Framework Manager Modeling tool.
• Created Views and imported into Framework Manager.
• Created IQD files using Framework Manager.
• Optimized the performance of Impromptu Reports.
• Created Groups and Assigned Roles using Cognos user classes.
• Extensively Used JavaScript in the Summary Report to provide a customized Functionality based on the business requirement.
• Deployment of the Cubes to Development and Production Servers.
• Organized the metadata as per the requirement in Folders and Namespaces in Framework Manager.
• Published Packages to the COGNOS 8.4 server using Framework Manager
• Implemented the Security at data and object level in Framework Manager.
• Installed and Configured the Cognos Power play Transformer
• Designed the Dimensional Models for transformer and Power Play cubes using PowerPlay. Explored the cube data using the Report Studio and Analysis Studio.
• Created Multi-dimension cubes using Power Play Transformer to create reports in Power Play
• Designed and developed Weekly Power Cubes.
• Documented user guide and trained business in Query Studio and Analysis Studio for creating adhoc reports.
• Coordinate with Offshore team and ensure all the Data warehouse work products are developed with high quality.

Environment: Cognos Suite 8.4(Report Studio, Query Studio, Analysis Studio, Cognos Connection, Framework Manager, PowerPlay Transformer, PowerPlay Web), Oracle 10g,DB2, TOAD, PL/SQL, Windows 2003.

Cognos BI Developer

Confidential, MI

Responsibilities:

• Involved in the Installation of Cognos 8.3 and up gradation of Packages from Frame Work Manager, Reports from Report Studio from Cognos 8.2 to Cognos 8.3.
• Schedule various reports Using Schedule Management used in Cognos Connection.
• Created various IQD packages in Framework Manager and integrated them to PowerPlay transformer to create various models and cubes.
• Providing Cognos access by assigning roles and maintaining security for auditing purposes.
• Created roles in Cognos connection and Access permissions were given to users.
• Experienced with SSIS DTS packages for Import and Export mechanisms.
• Coordinating with business users to understand the business rules and working with data warehousing team.
• Testing the developed reports for final deployment.
• Created complex reports in Report Studio such as conditional, dashboards and drill through reports.
• Customized data by adding the Prompts, Filters, Calculations, Summaries, Functions and Conditional formatting.
• Developed Multi-page reports, List reports, Charts, Drill through and Master-detail reports using Report Studio.
• Involved in Installation and configuring Framework Manager and its components on Windows.
• Developed the Metadata layer by importing the required objects into Framework Manager
• Documented self developed reports and Framework Manager (FM) Models as well as supported them.
• Organized the metadata as per the requirement in Folders and Namespaces in Framework Manager.
• Published Packages to the Cognos 8.3 server using Framework Manager
• Created IQDs by externalizing the Query Subjects in Framework Manager.
• Implemented the Security at data and object level in Framework Manager.
• Created various reports using Cognos functionalities like Sub-Queries, Slice and Dice, Drill Down, Functions, Cross Tab, Master Detail and Formula's.
• Designed the Dimensional Models for transformer and Power Play cubes using PowerPlay. Explored the cube data using the Report Studio and Analysis Studio.
• Scheduled the reports in Cognos Connection and distributed them via mail.
• Responsible for creating test plan documents and documented the test results.

Environment: Cognos 8.3 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio, Event Studio and Metric Studio), Cognos Transformer, Cognos PowerPlay, PowerPlay Enterprise Server (PPES), Cognos Access Manager, Brio Intelligence 5.0, Oracle 10g, Windows NT/2000

Cognos Developer

Confidential

Responsibilities:

• Created different filters and calculations in Framework Manager that can be effectively used while reporting.
• Created simple list reports, cross-tab reports, Drill through reports using Report Studio.
• Using conditional Blocks to implement conditional formatting.
• Creating scorecards and dashboards.
• Created burst reports and made them available to appropriate users resulting in saving lot of time and effort.
• Develop single select and multi select cascading prompts.
• Participated in user meetings to understand the reporting need.
• Interacting with client on regular basis.

Environment: Report Net 1.1, Informatica power center 7.1.1, Oracle 9i, Windows NT