Cognos BI Expert - 15+ yrs DW/ETL/ReportNet
Resume:
Srini
Cognos Consultant
**********@*****.***
Summary
Certified Cognos Consultant with over 15 years of in-depth and comprehensive experience in design, development, Testing, Security and Support for Data Warehousing, and Client/Server projects.
Expertise in designing and developing Business Intelligence solutions in Data Warehousing/Decision Support Systems using Cognos12/ 11/10.2/8.4/8.3/8.2/8.1.
Experience in ReportNet securities and 3rd party tools such as Access Manager, LDAP, and Active Directory.
Expertise in OLTP/OLAP technologies, developing Cognos Framework Manager modeling using Star Schema and Snowflake Schema in all modeling types.
Thorough understanding of software development life cycles (SDLC) designing, developing and implementing enterprise scale information management applications, reporting and handling multiple projects.
Experience using ETL Tools Informatica PowerCenter, Informatica PowerMart, in data mart life cycle development, design, development and testing of ETL procedures using Informatica.
Experience in Integration of various data sources like Oracle, DB2, SQL Server, MS Access, Flat Files into a Staging Area
Good experience with Micro strategy working with Desktop, Architect and Web.
Strong problem-solving skills, ability to develop strategies for clients and provide detailed documents to clients.
Good hands-on experience with PeopleSoft EPM
Extensive Experience on Production Support and Troubleshoot/Test issues with existing reports and cubes.
Experienced in gathering of User requirements and responsible to provide efficient end-user training and designing report specifications.
Certifications:
IBM Certified Designer Cognos 10 BI Reports
Cognos 8 BI Author v2 Certification Program Cognos Report Net Modeling Product Professional Cognos Certification
Cognos Report Net Product User Cognos Certification Program
Impromptu Series 7 Administrator Cognos Certification Program
Education:
Master of Computer Applications
Technical Skills
BI TOOLS
Cognos 12,Cognos 11, Cognos10.2 and 8.x Suite, Report Net 1.1/1.0x, Cognos- Impromptu 7x/6x, SSAS/SSRS/SSIS, Micro strategy 10.4, Tableau desktop, Tableau Server, Data Manager, SQL*Plus.
DATABASE
ORACLE 8i/9i, MS-Access7.0/2000, SQL Server 2000,DB2,Teradata
OPERATING SYSTEMS
UNIX 5.0, Windows XP/NT/2000 and MS-DOS
ETL Tools
Informatica 8.0/8.3/8.5.1/7.1/6.2/6.0
WEB SERVERS
IIS, Netscape Enterprise Server, IE
APPLICATION SERVERS
Apache Tomcat, Web sphere application server(WAS 6.0)
Professional Experience
Project # 1
Client: Hyatt Hotels, CA. Jan 2023 – Till date
Role: Senior Cognos Analytics 11 Consultant
Responsibilities:
Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
Migrating models, packages, and reports from Development to Quality Assurance and from Quality Assurance to Production environments.
Implemented Cognos best practices, documenting Reports, Framework Manager, and server-side architecture in accordance with company policies and standards.
SQL tuning and coordination with the database administrators on production issues.
Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
Experience with Cognos administration and MotioPI environment management
Experience with Service Now Incident Management for Cognos applications.
Developed complex CPS reports and a self-service package for users to create ad hoc reports.
Experience in Cognos administration and infrastructure, including managing multiple data sources in Cognos connection.
Provided technical support to customers, participated in the AWS dress rehearsal.
Created Ad hoc Excel Reports helping verify business requirements and data quality issues, along with Cognos Reports.
Worked on Cognos Administration in assigning Users, Groups, and User roles with access permissions.
Environment: Cognos Analytics 12,Cognos 11, MotioPI 3.2,oracle12c (SQL, PL/SQL), SQL Developer
Project # 2
Client: Nisum Technologies, CA.
Dec 2020 – Dec 2022
Role: Senior Cognos Analytics 11 Consultant
Responsibilities:
Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
Migrating models, packages, and reports from Development to Quality Assurance and from Quality Assurance to Production environments.
Implemented Cognos best practices, documenting Reports, Framework Manager, and server-side architecture in accordance with company policies and standards.
SQL tuning and coordination with the database administrators on production issues.
Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
Experience with Cognos administration and MotioPI environment management
Experience with Service Now Incident Management for Cognos applications.
Developed complex CPS reports and a self-service package for users to create ad hoc reports.
Experience in Cognos administration and infrastructure, including managing multiple data sources in Cognos connection.
Provided technical support to customers, participated in the AWS dress rehearsal.
Created Ad hoc Excel Reports helping verify business requirements and data quality issues, along with Cognos Reports.
Worked on Cognos Administration in assigning Users, Groups, and User roles with access permissions.
Environment: Cognos Analytics 12,Cognos 11, MotioPI 3.2,oracle12c (SQL, PL/SQL), SQL Developer
Project # 3
Client: Bank of America, SFO CA
Nov 2018 – Dec 2020
Role: Senior Cognos Analytics 11 Consultant
Responsibilities:
Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
Worked closely with clients to understand, gather and documented business requirements.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
The ability to interact professionally with a diverse group, including executives, managers, and LOB.
Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
Developed Dashboards, List, cross tab, drill through, master-detail, chart, Active reports and complex reports which involved Multiple Prompts in Report Studio.
Involved in Requirement Analysis, Functional Design and Technical Design.
Analyzed the reporting requirements and created various mockup dashboards
Created various report services and Dashboard documents using freeform SQL to achieve the desired output.
Performed thorough testing of Micro strategy Reports against the Database using manual.
Environment: Cognos Analytics 11, Micro strategy 10.4, oracle10g (SQL, PL/SQL), SQL Server, MySQL, Oracle 10g, Flat files, Toad, SQL Developer
Project # 4
Client: Novel Tek Systems, Pleasanton CA
June 2016 – Nov 2018
Role: Senior Cognos Analytics 11 Consultant
Responsibilities:
Created Cognos Data Modules within Cognos Analytics 11 by combining SQL Server Data with external excel feeds to support Dashboards.
Created projects, designed models for reporting and created & published packages in Framework Manager from various data sources.
Worked closely with clients to understand, gather and documented business requirements.
Deep experience with the design and development of Tableau visualization solutions.
Background in installing and upgrading of Tableau server and server performance tuning for optimization.
Administered user, user groups, and scheduled instances for reports in Tableau.
Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
Defined best practices for Tableau report development.
Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
Preparing Dashboards using calculations, parameters in Tableau.
Understanding of relational database structures, theories, principles, and practices.
The ability to interact professionally with a diverse group, including executives, managers, and LOB.
Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
Developed Dashboards, List, cross tab, drill through, master-detail, chart, Active reports and complex reports which involved Multiple Prompts in Report Studio.
Design and creation of Multi Dimensional Cubes using Transformer, so that all key performance indicators can be analyzed.
Unit testing, Integration testing and system testing of the reports in Development, Performance and production environments.
Participated in the process of Identifying BI tools for the future.
Involved in Requirement Analysis, Functional Design and Technical Design.
Developed the mapping specifications from the business requirements and the data model. Involved in data modeling and design of the data warehouse.
Created Informatica Mappings to load data using transformations like Source Qualifier, Sorter, Aggregator, Expression, Joiner, Filter, Sequence, Router, Update Strategy, Lookup transformations.
Developed and documented Informatica mappings and Informatica sessions as per the business requirement.
Created Materialized views for summary tables for better query performance.
Created reusable sessions and executed them to load the data from the source system using Informatica Workflow Manager
Extensively worked in the performance tuning of mappings, ETL procedures and processes.
Perform unit testing at various levels of the ETL.
Extracted client information data and history from Flat files, Oracle, SQL Server transformed and loaded into Oracle staging area.
Loading of data from different source systems into Oracle Target database.
Environment: Cognos Analytics 11, Cognos 10.2.2 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Tableau Desktop 7.0, 8.0, 8.1, Tableau server, Oracle 9i,oracle10g (SQL, PL/SQL), Teradata, SQL Server,MySQL,Informatica Power Center/Power Exchange 8x, Oracle 10g, Flat files, Toad, SQL Developer
Project # 5
Client: Intel, Santa Clara CA
Nov 2014 –May 2016
Role: BI Developer
Responsibilities:
Involved in gathering the functional requirements for financial budgeting, forecasting and related reporting and analytics requirements.
Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos 8.4.
Good exposure on using OLAP cubes from framework manager and other OLAP sources to use them as data source in Cognos connection.
Involved in Designing models using Framework Manager and deployed packages to the Report Net Servers
Implemented Framework manager security for Data access, Object level access and Package access.
Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager in ReportNet
Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
Environment: Cognos 10.1.1 and Cognos 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Tableau Desktop 7.0, 8.0, 8.1, Tableau server, Oracle 9i,oracle10g (SQL, PL/SQL), Teradata, SQL Server, Toad, SQL Developer
Project # 6
Client: Bank of America, Concord CA
Oct 2012 – Oct 2014
Role: BI Developer/Admin
Responsibilities:
Installed and configured various components, such as the Framework Manager, Content Manager on multiple server environment.
Developed and maintained Development, UAT and Production server.
Worked on complete migration project from Cognos 8.4 to Cognos 10.1.1.
Installed Cognos 10.1.1 on multiple server environment with up to 10 dispatcher and 4 gateways for all three environments (DEV, QA/UAT and PROD)
Cloned the content store on to new oracle schema prior to couple of days of migration to Cognos 10.
Developed and Implemented Best Practices (Development Standards, Modeling Standards & Security Model).
Installation and Configuration of Cognos BI Server and Power Play Transformer on Windows Sandbox.
Involved in gathering the functional requirements for financial budgeting, forecasting and related reporting and analytics requirements.
Developed Multidimensional Models in Power-Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos 8.4.
Good exposure on using OLAP cubes from framework manager and other OLAP sources to use them as data source in Cognos connection.
Worked extensively on migration project of security from Access Manger to LDAP.
Created Autosys job to automate the cube build process and report schedule on completion of data load.
Modified Power Cubes by adding new Dimensions, Levels, Categories, measure and debugging the cube build issues.
Worked extensively on MDX to extract the different level and cell data from dimensional packages in report studio.
Created Dashboards using combination of List, Crosstab, and Graph and Map reports and pushing them to all used portal tab.
Used JavaScript’s in Cognos Report Studio to achieve complex and accurate dashboards and reports.
Developed user acceptance documentation and placing Screen shots of actual Report and tested report in documentation.
Extensively worked on SQL, created joins between huge tables to map the columns from multiple tables.
Tracked the weekly bug or issue report updates from the developers in the form of the QA Error Log.
Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
Led team meetings, providing status and defining go-forward approach based on achievable results.
Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
Extensively worked on call support by coordinating and maintaining offshore team.
Worked extensively using Hints to Achieve the Performance and Tuned SQL Queries and Stored Procedures, improved the performance of the reports.
Provided Production support through problem analysis and resolution to correct deficiencies.
Developed Balanced Scorecard and executive dashboards, as means for measuring activities and outcomes for effective performance management.
Involved in review sessions and demos with business users and draft design/solution.
Responsible for various tasks including user communication, follow ups, reports and Power cubes development, testing, document preparation and moving components into different environments.
Used Cognos Metric Designer to populate the application by transferring information from relational and dimensional data sources.
Used Metric Studio score cards extensively to track the Finance and sales Metrics such as revenue, margin and customer growth.
Trained power users to use Query Studio for Ad-Hoc reporting and Analysis Studio.
Environment: Cognos 10.1.1 and Cognos 8.4 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metric Studio and Event Studio), Tableau Desktop 7.0, 8.0, 8.1, Tableau server, Oracle 9i,oracle10g (SQL, PL/SQL), Teradata, SQL Server, Toad, SQL Developer
Project # 7 JAN 2009 – Sep 2012
Client: CGI,Salem OR
Sr BI Developer
Responsibilities:
Analyzed Business requirements from the analysts.
Customized Cognos Connection with appropriate reports and security measures
Worked on Analysis Studio to develop multi-dimensional reporting.
Worked with Global Drill- through Definitions to drill through from analysis studio reports to report studio reports (MOLAP – ROLAP)
Designed Power Play reports to provide summarized results by measures and dimensions.
Created custom prompted reports in Report Studio, Bursting reports to different user groups.
Involved in Designing models using Framework Manager and deployed packages to the Report Net Servers
Implemented Framework manager security for Data access, Object level access and Package access.
Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
Involved in migration of catalogs, reports from Cognos Series 7/CRN to Cognos 8 using Migration Utilities.
Modeled metadata from SQL Server data source for use in Report studio and Query Studio using Framework Manager in ReportNet
Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects within Tableau Desktop.
Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
Created dashboard using parameters, sets, groups and calculations.
Created drill down and drill up in worksheets.
Involved in creating a dual-axis bar chart with multiple measures.
Created report schedules on Tableau server.
Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
Converted charts into Crosstabs for further underlying data analysis in MS Excel.
Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
Transferred technical knowledge specific to Cognos tools and the existing data model to other team members.
Scheduled Reports using Cognos Connection.
Migrated Cognos 7.3 Catalogs and Reports to Report Net1.1 MR2.
Developed Framework Manager Models with Physical layer and Presentation Layer to cater the various businesses needs (Folders, Filters, and Macros)
Implemented Third Party Security with LDAP and use those in creating Data Level, Object Securities in Framework Manager Models.
Developed Complex Report Studio Reports using Bursting, Tabular Objects.
Created Drill- through reports and Customized Reports with Prompts (List. Cross tab).
Prepared User documentation to train users and functionality of each report.
Production Support which involves solving user problems.
Securing Cognos Connection and setup Report Net security by assigning users to the groups and roles defined in Cognos Namespace.
Creating IQD files from Report net and designed Power play models in Transformer.
Involved in building the complex cubes and optimizing the cube creation.
Publishing cubes and created Power play Reports for the web users.
Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.
Responsible for overseeing the Quality procedures and Software configuration management related to the project.
Environment: Cognos 8, Reportnet1.1 MR2, Tableau Server v6/v7, Tableau Desktop v7/v6, DB2, Oracle 9i, mySQL, windows 2000, UNIX 5.0.
Project # 6 Aug 2007 – DEC2008
Kaiser Permanente Information Technology, Pleasanton, CA
Sr BI Developer
Responsibilities:
Designed Functional Requirement Specifications for report development, modified relationships between different database tables and building models using Framework Manager.
Customized Cognos Connection with appropriate reports and security measures
Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level.
Used
Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.
Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.
Created Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.
Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.
Trained the end users to effectively use the reporting tool to build and customize their ad-hoc reports.
Developing Prompt pages and Conditional Variables
Scheduled and Distributed Reports through Schedule Management in Cognos Connection
Created Cognos reports, prompts and layouts integrating with Java Script.
Designed models by mapping business needs using Power Play Transformer and created multi dimensional cubes, cube groups, Power Play reports
Designed multidimensional models using Transformer.
Involved in Deploying reports, cubes and packages from Development to Production environment.
Maintained the packages and reports in development, test and production environment.
Environment: Cognos 8.2 and 8.3 (Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos Report Net 1.1 MR2 (Framework Manager, Report Studio and Query Studio), Informatica Power Center/Power Exchange 8x, SSIS Oracle 10g, Flat files, Toad, SQL Developer, Cognos PowerPlay 7.2, Cognos Transformer 7.2, Oracle 9i, oracle10g (SQL, PL/SQL), SQL Server,DB2,Teradata
Contact this candidate