Cognos Lead Admin Resume
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