PROFESSIONAL SUMMARY:

• Cognos Certified Professional with 8 Years of total IT industry experience analysis, design, testing, development and implementation of client/server applications.
• Worked as Architect and designer for multiple successful BI projects with extensive involvement in data warehousing which includes data model design and build to help reporting and hands on work in all functionalities of reporting using Cognos.
• Expertise in full life cycle and Methodology including Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using Cognos Suite 8/10/11.
• Experience with user interviews, creating business requirement documents, functional requirement documents and report mock - ups.
• Recent experience with new functionalities of Cognos 10, like Workspace and workspace advanced.
• Expertise in Cognos 10/11 BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Query Studio, Business Insights and Business Insights Advanced, Work Space and Work Space Advanced).
• Expertise in Framework Manager Modelling (Relational and DMR) and Complex Report building with Report Studio.
• Sound Skills in Dash Board Report Development from both relational and dimensional sources in Cognos 8 and Cognos 10.
• Extensively worked on designing, building and testing of Active reports which vary from small to large in size.
• Experience working with cube designer to build Dynamic Cubes.
• Experience creating scorecards in metric studio, scheduling agents in Event Studio.
• Strong experience in Business Analysis, Data Analysis, Data Modelling and Erwin in Data Warehousing environment.
• Experience in Transformer model design, Power play cube building. Experience with auto-partitioning and Time Based Partitioning to improve cube rebuilding performance. Implemented incremental update and scheduling for power play cubes.
• Experience migrating from Cognos 8 to Cognos 10 and Cognos 10 to Cognos Analytics.
• Experience in Installation and configuring the Cognos 8/10 and CRN environment and implementing third security tools Tivoli directory Server and Sun One with Single Signon.
• Extensive experience in Multiple Relational Databases including SQL SERVER, ORACLE, TERADATA and DB2.
• Experience with ETL tools like Informatica and Data stage.
• Experience in interacting with end users to gather requirements for reporting and training them on ad-hoc reporting using query studio and analysis studio.
• Coordinated with the client representative to resolve any functional and technical issues faced by the project team.
• Excellent interpersonal and communication skills, technically competent and result-oriented with strong problem-solving skills.

TECHNICAL SKILLS:

Cognos Tools: 8.1/8.2/8.3/8.4/10.1.1/10.2.2/11.5 Suite (Framework manager, Report Studio, Analysis Studio, Cognos Connection, Event Studio, Query Studio, Business Insights and Business Insights Advanced)

Operating Systems: Windows 2016 Enterprise Server, XP, 2000, UNIX

Databases: SQL Server 2014/2005/2008, Oracle 9i/10g/11g, DB2, Teradata 9

Servers: Application Servers (WAS, Tomcat), Web Servers (IIS, IHS)

PROFESSIONAL EXPERIENCE:

Confidential - New York NY

Cognos Consultant

• Involved in Data Warehouse design and development.
• Developed metadata models, cubes, dynamic cubes, reports and dashboards, tested Cognos content and provided end user training in a small environment as part of a large group.
• Updating the existing Framework Manager and creating new Framework Manager models.
• Created reports with multiple pages and multiple tabs with out of the box interactive features for more user friendly data analysis.
• Used java script to change date and value prompt functionality and include frames and scroll bars in report pages and tabs.
• Trouble shooting issues with existing reports and creating, scheduling and bursting new reports.
• Utilized ticketing tools like UNICENTER and JIRA for resolving user issues - run reports, hide/disable reports, refresh PowerPlay cubes, maintain and modify existing schedules and security modifications.
• Supported Production Environment 24/7 for uninterrupted BI reporting by maintaining applications and server infrastructure.
• Updating the folder structure and Portal tabs in Cognos connection.
• Updated security setup from existing open to all setup to subject area wise setup.
• Recreated reports built using SSRS and Microsoft Excel in Cognos.
• Created Dynamic cubes using Cube Designer.
• Created reports using MDX with Dynamic cubes as source.
• Interacted with end users to understand reporting requirements in detail and how the reports impact the business process.
• Involved in upgrading Cognos version 10.2.2 to Cognos Analytics (11.5)
• Tested and fixed report discrepancies between both versions of Cognos.

Environment: Cognos 10.2.2/11 - Framework Manager, Report Studio, DQA, Cube Designer, Oracle 11, SQL Server 2014 (SSIS, SSRS, SSAS)

Confidential - Pennington NJ

Sr. BI Developer

• Maintaining Cognos environment, developed metadata models, cubes, dynamic cubes, reports and dashboards, tested Cognos content and provided end user training in a small environment alone.
• Involved in upgrade of Cognos version 8.4 to 10.2.1. Used life cycle manager to test the content.
• Worked on New multi-server installation for newer version of Cognos, used Netscaler for load balancing and created alias for end user URL.
• Analyzed the requirements and created Models, connecting various data sources, reports, sub queries, creating users, scheduler and joins using Framework manager.
• Initiated Enterprise Data Warehouse design and development based on the reporting requirements gathered from multiple user interviews all over the country.
• Involved in Data model design for the Data Warehouse and DataMart to support the Cognos Dashboards and Active reports.
• Worked with a team of consultants to develop the Metadata model and Dynamic cubes using Framework manager and Cube designer.
• Lead the team of consultants for the development of 2 Dashboards which are intended to meet the analytical needs of executives from 2 departments of the company.
• Built active reports for the users who will be offline most of the time.
• Created non-standard Audit reports to understand the interactivity of the users with the dashboards and conducted another round of interviews with random users to obtain more feedback and enhance the dashboards.
• Supported the existing operational reporting which contains reports bursted to non-executive users and Packages used by the users for ad-hoc reporting.
• Created multiple dashboards for respective subject areas using workspace advanced.

Environment: Cognos 10.2.2 - Framework Manager, Cube Designer, Report Studio, DQA, Workspace Advanced, Teradata 9, MS SQL Server 2012.

Confidential - Hartford CT

Sr. Cognos Developer

• Working as a lead solution designer, involved in end to end tasks of SDLC of a business intelligence solution, which includes requirement gathering, feasibility analysis, solution design, analysis and design of Cognos work, development testing and rolling out.
• Guided and helped peers and developers including off-shore team with design and best practices of Cognos solution.
• Worked as part of the data modeling team in designing Data warehouses and project specific data marts and made sure of achieving data structures optimal for building Cognos solutions on top off.
• Spent most of the time on feasibility analysis and solution design which involves generating requirements for ETL team to provide tables/columns using business rules to avoid implementing them on Cognos reports for better performance, deciding the type of solution (dashboard/self-service etc.; based on the requirements) to be developed and best practices to be fallowed.
• Involved in the entire build phase making sure of developers fallowing the design and best practices.
• Used Cognos framework Manager 10.1.1 for metadata modelling. Fallowed layered structure as per IBM standards. Used pass-through SQLs in framework manager for better performance and elimination of aggregations in report studio.
• Developed dashboard solution for operations using heavy JavaScript code for superior user interactivity like toggle between frames based on mouse click, in page prompt selections and controlling concurrent and sequential query running in report studio.
• Developed complex reports like Conditional Block Reports, Drill-Through Reports, Master-Detail Reports, Burst reports and Multilingual Reports using Report Studio and Query Studio.
• Used Cognos Mash-up services URLs to embed the Cognos generated output in a portal.
• Worked on enabling self-service capabilities for end users using Cognos cubes. Used Cognos Transformer 10.1.1 to design and build cubes.
• Worked with Business objects Excelcius for one dashboard solution.
• Participated and contributed to knowledge sharing sessions and technical forums for understanding and helping resources across platforms to understand new and existing business capabilities and technologies.

Environment: Cognos 10.1.1, Framework Manager, Report Studio, Query Studio, Analysis Studio, Business Insights, Transformer, Teradata 9, Oracle 11g, SQL Developer, Teradata SQL Assistant, Excelcius.

Confidential - Novartis, NJ

Cognos Developer

• Leading a team of 10, 6onsite and 4 off-shore. Coordinating the onsite-offshore model.
• Actively involved with the entire BI life cycle- report requirements gathering, documentation (business and functional specifications), analysis of existing resources, report and model development in Cognos Framework Manager, testing reports (QA and data validation), production (migrating reports from QA to production) and maintenance (job and scheduling).
• Participated discussions regarding Data model design and ETL Approach.
• Designed architecture the Cognos work process for the project.
• Created and published packages for different subject areas, using Data Source Query Subjects, Model Query Subjects and Stored Procedure Query Subjects in Framework manager.
• Built a Framework Manager model for ‘Guided Analytics’ and trained users with use of Query Studio.
• Created list, crosstab and Chart reports and implemented drill-though conditions and Master-Detail relationships.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports. Customized prompts using HTML Items.
• Used Union, Intersection, joins between queries in report studio.
• Built power play cubes in Transformer, for dimensional analysis.
• Implemented data level security in cubes using user group Custom views.
• Worked intensively on On-Demand reporting environment and used tabular SQL.
• Enhanced report performance by tuning the reports using filters, prompts, sorting and grouping as and when required.
• Monitored daily, weekly and monthly jobs and also involved in creating jobs and schedules as required.
• Worked on scheduling the weekly and monthly auto-rebuild of the cubes. Implemented incremental update.
• Developed several Dashboard reports using MDX with multiple pages having cube as data source.
• Implemented Drill-up and Drill-down with advanced options.
• Created Active reports with different data decks and data cards.
• Deployed reports, models and cubes from Dev. to Test and Prod environments.
• Worked on Unit testing and data validation of various reports that were developed in Cognos.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Carried out performance tuning of reports, both on data base side and Cognos report and modeling side.
• Used Business Insights and Business Insights Advanced to arrange individual reports into dashboards.

Environment: Cognos 10, Report Studio, Metric Studio, Query Studio, Business Insights, Transformer, Oracle 10g, PL/SQL Developer.

Confidential, IL

Cognos Developer

• Lead a Team of 5, 2 onsite and 3 Offshore. Coordinated onsite and offshore teams.
• Analysed Business Requirements and created Functional specifications.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Participated in integration of various data sources like Oracle, SQL server and MS access into staging area.
• Involved in Designing Models using Framework Manager and deployed packages to Reporting Servers.
• Used some complex macros and published them to Cognos portal through Framework Manager.
• Implemented row level security using table views and parameter maps in Framework Manager.
• Created Various Dashboard Reports for different Business Areas based on Power play Cubes and DMR’s.
• Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports.
• Created List Reports, Cross Tab Reports and Drill Developed Power play cubes and published them to Cognos portal
• Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source.
• Scheduled reports to run on a monthly, weekly, and daily basis using Cognos Connection Scheduler.
• Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection.
• Tune Server Performance includes: Organizing dispatchers, setting processing capacity, and setting queue.
• Created Jobs and Distribution lists in Cognos portal for Scheduling.
• Created reports in HTML format for easy navigation of data from web browser.
• Worked on Cognos Administration in assigning Users, Groups, User roles with access permissions.
• Deployed packages, folders, Reports and content store from a Development environment to Test and then to Production environments.
• Created Technical specifications and performed unit testing of the reports.
• Trained end users on using query studio and analysis studio for ad-hoc reporting.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.

Environment: Cognos 8.3/8.4.1 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), SQL Server 2005/2008, Windows XP, UNIX, Server 2008 and Windows NT.

Confidential

Cognos Developer

• Installation & Configuring the Cognos 8.4 on windows Environment.
• Worked on framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.
• Created and maintained Cognos packages in Framework Manager.
• Developed a detailed conceptual model for the company's sales and marketing arm using ER/Studio
• Modelling sources included existing reports, data structures, and XML schemas.
• Mapped conceptual model concepts to existing systems and data structures, as well as to newly-implemented ERP suites
• Expertise in deploying packages and reports to Production environment and handling production issues.
• Creating the OLAP Power play cube and publish the cube to the Cognos Portal using Frame work Manager.
• Created and maintained Cognos jobs.
• Worked on Go office tools.
• Customized Cognos portal and worked on some XML files to build the customized Cognos portal.
• Created, refreshed and supported Cognos Transformer models and cubes to support Claims operations.
• Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.
• Developed Standard Reports, Charts, Drill Through Reports, Master Detail Reports, Bursting Reports and Multilingual Reports Using Report Studio and Query Studio
• Experience in writing with HTML/Java Script in Cognos report studio reports as per the requirements.
• Implemented Third Party Security with LDAP and created users and user roles.
• Created Various Dashboard Reports for different Business Areas based on Power play Cubes and DMR’s.
• Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
• Developed and modified Power Play reports and graphs with different layouts according user requirements.

Environment: Cognos 8.3/8.4 Suite (Cognos Connection, Framework Manger, Report Studio, Query Studio, Analysis Studio), Teradata, BTEQ, Cognos Access Manger, Windows XP, UNIX.