Cognos Developer/Consultant

Srunaj

Email:ac9y53@r.postjobfree.com

(Skype): Srunaj

Mob: +1-416-***-****

SUMMARY

Around 8 years of experience as Cognos and TM1 Administrator and Cognos BI Developer

Extensively worked on content (reports, packages, dynamic cubes, active reports) migration from Cognos 10 to Cognos Analytics(11)

Expertise in BI Application Migration

End to End Testing of BI reports comparing the business specifications provided by the Business Analysts

Configuring alerting systems like Centauri, Sitescope, and Concord for monitoring the BI environments.

Setting Multi-Tenancy for the applications

Experience with Impact study analysis and implementation of Cognos 8.4 to Cognos 8.4.1FP2 upgrade and migration of code from 8.4 to 8.4.1FP2

Installation and configuration of Cognos 10.1,10.2, 11 on Windows and Unix servers.

Deployment Management – Planning and execution of weekly Deployment of code from DEV to SIT, SIT to UAT, UAT to Pre Prod and Pre Prod to Prod

Created Project Plan and scheduled for major upgrade of Cognos 8.4 Application and Servers adding load balancing to the environment.

Experience in optimization using load balancing and distributed hardware infrastructure

Excellent experience in client interaction and understanding business application, business data flow and data relations from them

Solved customer security issues as well as created a process to extract user information from security application for easy access.

Created Disaster Recovery documents in the event of a disaster.

Designed and developed OLAP Cubes and Reports using Powerplay Transformer for UNIX.

Expertise in PL/SQL, SQL for Analytics, Star Schema Design, SQL and PL/SQL Tuning and Cognos BI/Web Reporting Development and Support.

Designed and developed Framework manager 8.x modeling, which includes creating regular dimensions, measure dimensions, resolving multi-grain multi-fact, loop joins, relationships and appropriate use of determinants.

Creating new users for Control M.

OBIEE application maintenance and migrating RPDs, Web catalogs and DAC migration from DEV to STAGE and STAGE to Prod environments.

Business Objects application maintenance and creating a regular back up of the reports and universes.

TM1 installation and integrating the application with Cognos BI application.

Extensively worked on design and development of reports using Cognos 8.x Report Studio which includes use of Cognos 8.x features like cross tab indentation, MDX functions, complex list reports, charts, conditional formatting, multiple prompt pages, etc...

Excellent analytical, communication, interpersonal skills and self-driven.

EDUCATION

Masters in Computer Science from Sheffield Hallam University

Bachelor of Engineering from JNTU, Hyderabad.

Intermediate (+2) from Board of Intermediate Education

AISSCE from the Central Board of Secondary Education.

Technical Skills:

Cognos BI Tools

Cognos Analytics, Cognos 10.2.1,10.1.1,10.2,8.4.1FP2,8.4.0,8.3, 8.2 BI, 7.1 MR2 (Report Studio, Query Studio, Analysis Studio, Event Studio, Metric Studio and Framework Manager, Transformer for UNIX 7.1 MR2, Powerplay Enterprise, PowerPlay Web, Access Manager, Netscape Directory Server (LDAP)

Databases

Oracle 9.2.x/10G, SQL-Server 2000/2005, Teradata Warehouse, DB2, SAP BW

Operating systems

IBM AIX, Solaris, Windows

ETL Tools

Oracle Warehouse Builder9.2, Custom ETL (Pl/Sql 9i/10g), Informatica 6.2.x, Data Stage

Languages

SQL, PL\SQL.

Oracle Tools

SQLPlus, TOAD,

Scripting/Scheduling

Power Shell, SQL.

Web

HTML,

Other Tools

Clear case, Clear quest, SVN, JIRA, Qlik View, VM Ware Service Manager

Experience

Boehringer Ingelheim.

Cognos/TM1 June 2015 – June 2019

Developer/Admin

Cognos upgrade from Version 10.2.1 to Cognos Analytics 11.0.12

Setting up Multi-Tenancy for various Business units on same application.

Handling BISM (Business intelligence Service Manager) requests on a daily basis

Installation of new Cognos 10.2.1, Cognos 10.2.2 instances for the new clients

Extensively worked on design and development of reports with Cognos report builder

Develop/design models, import data and publish with IBM Cognos Framework Manager (FM)

Working with IBM support in resolving the application software bugs

Coordinating with business clients across the Globe in case of application downtimes or maintenance

Performance tuning of application/reports with increase in application loads

Schedules monitoring and helping business clients in distributing the schedules over non-peak periods

Creating Documents for the users across global in different languages (working with translators) for the better use of tool

Creating TM1 server instances and helps the users with deployments.

Migrating QVDs amd QVWs for Qlik View users

Windows performance tuning and security administration

Application upgrades/migrations to a new version or deploying the existing one on new hardware

Change management and documenting the tasks accomplished using ITEMS (SAP Documents Repository)

Environment: Cognos10.21, 10.2.2, Cognos 11, Windows2008, 2012, Oracle, ActiveDirectory

Office Depot March 12 – Jan 2015

Cognos Developer/Administrator

Promoting the Cognos packages, reports, jobs from Dev to QA and once tested then to Prod following the SDLC process

Design and development of reports using Cognos report builder

Developed Framework manager 8.x modeling package

Monitoring the performance of Cognos environment ensuring 100% availability of the system

Working with the IBM support on BI Server Limitations and providing the requested information and work towards the closure of the issues

Installing the Hot fixes provided by the support and documenting the roll back procedure for the activities performed

Creating new jobs, scheduling the jobs, setting the parameters for reports, creating report views as per the user requirements

Performing Health check of the Data stage and Cognos applications and sending out report to the top-level management on a daily basis

Code migration of Data stage jobs to the production environment.

Adding additional dispatchers to the production farm depending on the increase in user requirements

Working with the external DB teams, Windows Admins, LDAP Team, in case of any Data source connection issues, IIS issues, disk space issues, memory issues and user provisioning issues

Environment: Windows 2003 & 2008 serves, IIS 6 & IIS7, Active Directory, Terradata, Oracle, Cognos 10.1.1 &

Cognos 10.2

Qualcomm

BI Application Administrator July 11- March 12

On-Call support: Level-1 support for varied BI applications (COGNOS-BI, TM1, BO, OBIEE, HFM)

Primary role is to perform all Cognos Admin activities and secondary is the provide admin support to other BI (OBIEE, HFM, Qlikview, BO, Cognos TM1) applications

Install, configure, POC and review of Cognos 8.4.1, 10.1 BI, on Windows Server 2003/2008 platform

development of reports using Cognos report builder

IBM SR management and resolution with the help of Cognos Support team using Cognos Support secondary ID.

Cutover type version upgrade from 8.4.1 to 10.1 of Cognos BI Suite

Scheduled and unscheduled application maintenance activities.

Setup and Administration support to OBIEE. Scheduling / triggering of OS and application level activities using Control-M scheduler.

Install and configuration of Splunk (log indexer) agent on Windows and Unix servers.

Configuring and maintenance of BI applications using monitoring systems (Site Scope, Centauri, Sysedge (e-Health), Splunk)

Creating a regular backup of the Control-M tables.

Report development using Cognos Report Studio

Creating global filters for the reports on a dashboard.

Team building activities.

Environment: AIX 5.3/6.1, Cognos 10.0, Cognos 8.4.1 FP2, Windows 2003 and 2008 servers, Microsoft IIS, IBM HTTP Server, Oracle 9i, Oracle 10g

Contact this candidate