We provide IT Staff Augmentation Services!

Cognos Lead Admin Resume

0/5 (Submit Your Rating)

San Diego, CA

SUMMARY

  • Around 9 years of experience in IT includes extensive Functional and Technical experience in, Data Modeling, Business Intelligence (BI) and Customer OLAP, product development and Reports Generation.
  • Expert in Business Intelligence Applications using Cognos Tools such as Cognos 8BI, Report Net (Framework manager, report studio, query studio and Analysis studio.
  • Hands on Experience with Framework Manager Modeling (Physical Layer, Business Layer, Packages), Complex Report building with Report Studio and Cognos Administration
  • Expert in Cognos 8.x, Cognos10.x installation, Configuration and Maintenance on multi server environment
  • Expertise in Cognos tools such as Cognos (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection)
  • Worked on Framework Manager, Analysis Studio, Query Studio and Report Studio for Model and Report design in Cognos BI version 7.1, 8.4, 10
  • Knowledge on installation and configuration of Tableau 9.x server, Tableau 9.x desktop and Tableau 9.x server work versions.
  • Involved in creating database objects like tables, views, procedures, triggers, and functions.
  • Good Knowledge in Enterprise Data warehousing (EDW) concepts.
  • Knowledge in developing Tableau data visualizations and dashboards using Tableau Desktop
  • Knowledge in developing Tableau workbooks from multiple data sources using Data Blending
  • Knowledge in Creating action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
  • Knowledge in Developing visualizations using sets, Parameters, Calculated Fields, Dynamic sorting, Filtering, Parameter driven analysis.
  • Designed and implemented data cubes using OLAP services, Cognos Impromptu, and Power Play, Analysis Studio to facilitate executive, management and end user reporting Expertise in OLTP/OLAP technologies, developing Cognos 8 Framework Manager Modeling using Star Schema and Snowflake Schema
  • Involved in installation, configuration and upgrade of COGNOS ReportNet 1.1 MR3.
  • Extensively used Framework Manager, Query Studio and Report Studio for model design, ad - hoc reporting and advanced report authoring.
  • Involved in designing of Relational and Multidimensional databases.
  • Designing and implementing Multi-Server Cognos BI Architecture.
  • Good knowledge in implementing Distributed server installation / environment of Cognos BI suit applications.
  • Installing and Configuring Cognos BI products such as IBM Cognos gateway, Cognos BI application server, Cognos Content manager.
  • Implementing Cognos security such as Cognos roles and Groups.
  • Knowledge on hosting Cognos BI suit applications on cloud platforms like Amazon Web Services (AWS).
  • Creating Data source connections for Oracle, SQL server, Teradata and CIS databases.
  • Taking Content Store export back up.
  • Deploying reports, publishing Framework manager package, Transformer cube models from DEV to UAT and UAT to Production.
  • Publishing and configuring Cognos Dynamic cubes.
  • Implementing RAVE visualization
  • Troubleshooting Cognos issues, creation and follow up of PMRs with IBM.
  • Installing IBM fix packs and interim fixes
  • Developing proof of concepts and configuring Audit reports.
  • Monitoring Cognos schedules.
  • Implementing best practices for deployment.
  • Knowledge on BI applications like Qlikview 11.x, Tableau and ETL tools like SSIS and Informatica 9.5.
  • Knowledge in creating mappings using ETL tools like MSBI-SSIS and Informatica.

TECHNICAL SKILLS

BI Stack: Cognos 10.1.1, Cognos BI 10.2.1, Cognos BI 10.2.2, Report Studio, Framework Manager, Power Play Transformer 7.3 MR2 and Cube DesignerETL Tool MSBI - SSIS, Knowledge on Informatica9.x, Scheduling tool Control M

DBMS & Data Mining: Oracle 9i/11g, MS SQL server 2005, Teradata 12.0, TOAD

Operating System: Windows XP/ 2008/2003/2000/ NT

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Cognos Lead Admin

Responsibilities:

  • Maintain Cognos server environment, including portal and security administration
  • Develop and maintain Cognos content using Query Studio, Report Studio, Analysis Studio and Event Studio
  • BI Administrator / Professional responsible for maintaining the Framework Manager projects and administering the security and web environment
  • Use Report Studio to create and distribute the full spectrum of report types, including complex andMulti-source reports
  • Involved in gathering business and functional requirements from Business and functional users.
  • Involved in project plan and road map meetings on weekly and quarterly basis.
  • Ability in coordinating with different application teams as per the requirements.
  • Maintenance and trouble shooting of Cognos OLAP environment.
  • Work with LDAP/Active Directory if Cognos users are maintained in the directory.
  • Involved in creation of Simple to medium level complex mappings in Informatica.
  • Involved in scheduling the jobs in Control M tool.
  • Maintain Cognos Roles and groups within Cognos environment
  • Closely worked with Cognos Support in fixing the issues & in identifying the product bugs.
  • Manage Cognos content using Cognos Administration
  • Deployed Data from one Environment to Another Environment
  • Prepare the Project Plans for Upgrade from Cognos 8.4 to Cognos 10.2
  • Involved in troubleshooting and testing the reports at database level using SQL queries.

Environment: Cognos 10.2/10.1.1 , Report Studio, Framework Manager, Cognos Administration, Informatica, Control M

Confidential, Burbank, CA

Cognos Developer / Administrator

Responsibilities:

  • Engaged in installation, configuration and maintenance of Cognos Administration tool using Cognos 10 BI
  • Involved in high level project plan meetings and designed road maps for BI Application upgrades.
  • Co-ordinated meetings between different application teams for project implementations.
  • Established user groups, roles and assigned privileges, implemented level of Security in Cognos connection.
  • Involved in moving reports packages across different Cognos environments like from Dev to TEST and TEST to PROD environments.
  • Providing support to Cognos end users. Managing offshore team. Interacting with Business Partners, Vendors, Other Teams
  • Created Data Sources Connections as per the requirement of Business Users.
  • Manage software upgrades, patches and back-up as needed. Work with Level 3 support, Development team to provide application support and bug fixes as needed Experience in administering Cognos EP applications and environment.
  • Monitoring the health checkup of Cognos development, testing and production environment.
  • Closely worked with Cognos Support in fixing the issues & in identifying the product bugs.

Environment: Windows 2008, Cognos 10.2.1 (Report Studio, Query Studio, Cognos Workspace Advanced, Framework Manager), Teradata

Confidential, Burbank, CA

Cognos Developer / Administrator

Responsibilities:

  • Involved in implementation of ETL SSIS process for loading the data into Data warehouse.
  • Involved in creation of ETL mappings in the packages using different transformations.
  • Efficient in understanding business logics and applying them.
  • Involved in performing Cognos Administration and Maintenance tasks on Cognos server.
  • Involved in giving access to users to Cognos connection.
  • Involved in adding users to Cognos roles and groups.
  • Involved in deployment of packages from development to production environments.
  • Involved in Scheduling and Maintaining the Schedules of the reports.
  • Involved in designing Frame Work Models, importing the Meta data from the Data source tables.
  • Involved in gathering/refining requirements from the client for developing reports.
  • Generated various kinds of reports like List and Cross tab in Report Studio.
  • Applied different types of Calculations, Filters and Conditions.
  • Applied different types of prompts like text box prompt, value prompt, select and search prompt, date prompts, cascading prompts etc.,
  • Worked with Condition Variables to highlight the data based on report requirements.
  • Worked with Sorting, Ranking, Conditional Formatting.
  • Created drill through reports and master detail reports.
  • Dealing with the performance issues if the report takes much time to execute.
  • Scheduled the reports according to user requirements and business needs.
  • Testing Reports using review checklists for Quality Assurance.
  • Involved in deployment of the reports from development server to production server.
  • Interacting with end users on a regular basis for resolving issues.

Environment: Cognos 8.2, Microsoft SQL Server, Oracle SQL, DB2, MSBI - SSIS.

Confidential

Cognos Report Developer / Administrator

Responsibilities:

  • Involved in designing Frame Work Models, importing the Meta data from the Data source tables.
  • Involved in gathering/refining requirements from the customers for developing reports.
  • Generated various kinds of reports like List and Cross tab in Report Studio.
  • Applied different types of Calculations, Filters and Conditions.
  • Applied different types of prompts like text box prompt, value prompt, select and search prompt, date prompts, cascading prompts etc.,
  • Worked with Condition Variables to highlight the data based on report requirements.
  • Worked with Sorting, Ranking, Conditional Formatting.
  • Created drill through reports and master detail reports.
  • Dealing with the performance issues if the report takes much time to execute.
  • Scheduled the reports according to user requirements and business needs.
  • Testing Reports using review checklists for Quality Assurance.
  • Involved in deployment of the reports from development server to production server.
  • Interacting with end users on a regular basis for resolving issues.

Environment: Cognos 8.4, Oracle SQL, SQL Server, Microsoft VSS, Citrix, Lotus Notes.

Confidential

Cognos Report Developer / Administrator

Responsibilities:

  • Understanding existing business model and customer requirements.
  • Involved in creating of Framework Manager Metadata models and publishing of packages.
  • Involved in design & development of multiple reports using various templates like list reports, cross-tab reports and chart reports.
  • Created a series of templates, drill-through reports, reports with individual prompts and filters and sectioned reports.
  • Extensively used cascading prompts, drill-through, summaries, conditional formats, grouping and association features to generate efficient and user-friendly reports.
  • Managed scheduling of reports, maintenance of public and individual folders, distribution lists, users, groups and roles using Cognos connection.

Environment: Cognos8, SQL Server, Oracle SQL.

Confidential

Cognos Report Developer / Administrator

Responsibilities:

  • Created List and Cross tab reorts in Report Studio.
  • Created Pie charts, bar charts for graphical representation of the business.
  • Used Calculations, Filters and Conditions.
  • Applied different types of prompts like text box prompt, value prompt, select and search prompt, date prompts, cascading prompts etc.,
  • Used Sorting, Ranking, Conditional Formatting.
  • Created drill through reports and master detail reports.
  • Checking the reports if its execution time is more.
  • Scheduled the reports according to user requirements and business needs.
  • Worked in deploying the reports from development server to production server.

Environment: Cognos8, SQL Server, Oracle SQL.

Confidential

Cognos Report Developer / Administrator

Responsibilities:

  • Developed List Reports, Cross Tab Reports and Drill through Reports with filters, prompts and calculated columns.
  • Creation of standard filters, calculations and conditions.
  • Applied different types of prompts like text box prompt, value prompt, select and search prompt, date prompts, cascading prompts etc.
  • Developed Complex Reports having many calculations in Report Studio.
  • Peer reviews have been done once after report development.
  • Testing Reports using review checklists for Quality Assurance.
  • Interacting with onsite co coordinator on a regular basis for resolving issues.

Environment: Cognos8, SQL Server, Oracle SQL

We'd love your feedback!