Cognos Technical Lead

GOPINATH GARAPATI

PROFESSIONAL SKILLS OVERVIEW

Corporate Performance Management consultant (Cognos TM1 / BI Lead Consultant/Developer ) with 8.11 years of experience of applications development/Support and maintenance for financial reporting, budgeting / forecasting and financial consolidation solutions for customers in domains like Finance, Retail, Life sciences, Banking, Finance and Insurance using IBM Cognos TM1 and IBM Cognos BI.

Have extensive working knowledge on different technologies IBM Cognos TM1 9v and 10v

Architect, Perspectives, TM1 Web, TM1 Contributor, Performance Modeler,

CAFÉ,TM1 Operation Console,Tm1 Top,TM1 Server/Client Installation /Configuration

Also extensively worked on third party Cube wise tools like

Vizier ( TM1 Turbo Integrator editor), Cube spy (TM1 Monitoring tool),

TM1 Extend for Excel, TM1 Pulse (TM1 Monitoring tool).

Being IBM Cognos TM1 developer certified professional, worked extensively on IBM Cognos TM1 server installation/configurations, Designing, Developing, Administering, Deploying and Maintaining TM1 Dimensions, Cubes, Dynamic Subsets, Views, Rules (maintaining XRU files), Reports, TI Processes and Chores, Creating multiple Rollups in dimensions using XDI’s and TI’s and Optimizing the order of dimensions in TM1 cubes, Sound knowledge on developing TI scripts and load data in cubes.

Being IBM Cognos BI certified professional, worked extensively in designing, developing and scheduling BI reports using IBM Cognos BI tools (Framework Manager, Report studio, Event studio, Event studio & Event studio) and also worked extensively with Cognos GO Office in designing and developing Dynamic PPT’s and Excel sheets using Cognos BI reports as backend.

Organizational Experience

Lead Consultant TM1 & BI

Jan 2016 – Till date

Teamsoft Technologies, LLC.

(Client: GREY GROUP, NY)

Lead Consultant

MAY 2014 - Jan (1.7 Years)

GENPACT

Senior Associate

AUG 2009 – Apr 2014 (4.8 Years)

COGNIZANT Technology Solutions

Associate Consultant

JUNE 2007 – Jul 2009 (2.1 Years)

NELITO Systems Pvt, Ltd.

(Tata Consultancy Services)

Education

Masters of Computer Applications (MCA - 2003-2006), from Osmania University, Hyderabad.

Technical Skills

Primary Skills

IBM Cognos TM1 9v (9.5.2), 10v (10.1.1 and 10.2.2)

(Architect, Perspectives, TM1 Web, TM1 Contributor, Performance Modeler)

IBM Cognos BI Tools

(Framework manager, Report studio, Analysis Studio and Event Studio)

IBM Cognos Go Office (Excel & PPT)

Tools Used

Vizier, Cube spy, Tm1 Top, TM1 Pulse, TM1 extend for excel

Netezza workbench, PL\SQL developer, Toad, IBM Data stage 8 PX

Magic (Ticket tracking tool)

Domain Skills

FP & A (Finance), Pharma, BFS, Insurance, Retail and Planning, budgeting and forecasting.

Certifications

IBM Cognos TM1 9v Developer

IBM Cognos TM1 10.1 Developer

IBM Cognos BI Author certified

IBM Cognos Meta Data Modeling (Framework Manager)

Awards & Recognitions

Received GOLD and SILVER Awards from Assistant Vice President for excellent contribution towards Genpact Corporate TM1 projects deliverables, maintenance and competency activities

Finance BPA Extra Mile award for the year of 2011 and 2012 from Global Head BPA and FRA, Switzerland.

“Late Night Award” from Finance & Administration IT, Switzerland.

Award from Global Head Finance BPA for the efforts on 2012 BUDGET process to close.

And many appreciations from TM1 application manager and IT head and from other finance business owners in Pharma and Corporate fiancé users.

Roles & Responsibilities

Administration

Up-gradation of TM1 servers from 10.1 to 10.2.2 versions

Installation of TM1 Servers, Tm1 Operations Console, Tm1 Applications, and Cognos Analysis for Excel (CAFÉ) and apply patches to these components with 10.2.2 version.

Worked on TM1 Disaster Recovery and backup/restore processes for the server installation and the Tm1 business data

Worked on Administration part in Cognos BI Connection includes Data source connections, DL and contacts, Content administration, Dispatcher and services, Security (Users, groups & roles) and Capabilities.

Worked on configuration issues with IBM product team (PMR’s) for bug fix resolutions.

Installation and upgrades of Cognos applications across multiple environments

Design and deployment of Cognos application / hardware architecture

Understand/execute release/change management processes for changes to business applications

Take ownership of a problem and communicate status / risks to manager regarding solution delivery

Worked on configuration issues with IBM product team, Defining migration methodology.

Worked on Environment stability by Integrating with existing company security infrastructure.

Lead the testing team successfully conducted Unit testing, System testing, Load testing activities.

Application deployment through Web sheets approach.

Development Environment

Managing software development including design, development & troubleshooting of applications; conducting gap analysis including validation of needs in conjunction with onsite & offsite teams.

Undertaking development & testing, defect & issue management for software applications; conducting reviews of codes & test cases and analyzing change requests / enhancements

Participate in full development lifecycle within Cognos reporting suite, from developing business requirements to change management processes and ensuring changes are properly tested and migrated to production.

Interfacing with clients to gather business requirements; conducting system analysis and finalizing technical / functional specifications & high level design documents for the project

Developed End-to-End TM1 model by creating TM1 objects such as Dimensions, Cubes, Rules, Tis, Web sheets, Contributor applications as per the requirements using Architect, Perspective, TM1 web, TM1 contributor and Performance Modeler.

Application deployment through Web sheets approach.

Automated the data loading activities by using Oracle scripts using TI processes.

Work with TM1 server in different authentication modes and be able to switch modes Tm1 configuration to operate in these different modes, Native security, ldap, Cognos Business Intelligence security integration.

Worked on creating/maintaining front end Cognos BI reports and jobs with TM1 model as a source.

Designed & developed multiple Report studio reports using various templates like list, cross tab, repeaters, various charts, filters, summaries, and Prompts for set of reports.

Lead the testing team successfully conducted Unit testing, System testing, Load testing activities.

Successfully deployed Application to Production by coordinating with App-Sec and Info-Sec teams.

Modeled FM with Physical, Business and Presentation Layers.

Participate in integration, performance, and user acceptance testing for TM1 and BI solutions.

Collaborate with outside team members and management by gathering information and understanding the business needs and objectives to produce deliverables.

Support/Maintenance Environment

Monitoring the outstanding issues of the projects and ensuring quality & timeliness of deliverables.

Identify, troubleshoot, and resolve application issues and code defects; escalates as appropriate

Participate in continuous process improvement activities and initiatives in Cognos TM1 and BI models

Provide maintenance, support and enhancements to TM1 Web and Application servers

Provide technical assistance with troubleshooting reports/models/cubes by responding to user queries.

Reviewing & approving test cases and results of critical projects; providing post-implementation, application maintenance and enhancement support to the client with regard to the product / software application

Working on Cognos TM1 and BI (integration) project includes BI reports as frontend and TM1 models as backend

Working on enhancements and supporting Cognos TM1 and BI 10.2.2 financial models.

Security Integration with Cognos BI security (CAM).

Execute and monitor Cognos Jobs and fixing errors.

Created, Report views, new reports in Report studio and working on many enhancements in the reports.

Extensively working on reporting requirements in Cognos BI reports by implementing logics in TM1 as a backend.

Respond to and resolve access and performance issues for our business users

Automated the data loading activities by fixing processes errors during data loads in TI processes.

Taking care of support activities and automating the cube backup, security activities.

Enhancements to Dimensions and Cubes as per Client Requirements.

Enhancements to TM1 reports based on the existing excel reports.

Daily/Monthly/Yearly Support activities: Month/Quarter/Year end Rolling forecast and Budget data loads in to Tm1 model (YTD Actuals/Plan/Forecast data).

Analyze and troubleshoot TM1 issues in production, working on Performance Tuning TI processes, Rules and Reports, Create and schedule batch scripts which backup TM1 data directories, Define user groups in TM1 and implement security on Dimensions, Cubes and Applications etc.

Dealing with User access management model by providing user securities.

Support to ad-hoc queries/issues raised by customers.

No#

Client

Project Type

Role

Technology

Duration

1

GREY Group

NY Finance Model application development & Support.

Sr. Cognos TM1 Developer

Cognos TM1 10.2.2

Cognos BI 10.2.2

Jan 2016 – Till Date – GREY Group -New York

2

GE Corporate

Revenue Forecasting (ROOT)

TM1 Lead Consultant

Cognos TM1 9v, 10.1.1, 10.2.2

(Architect, Perspectives,

TM1 Web,

TM1 Contributor,

TM1 top, Operation Console, Vizier,

Cube Spy,

TM1 extend for Excel,

TM1 CAFÉ,

Performance Modeler

Installation/Configurations), Oracle R12

May 2014 – Jan 2016

GENPACT

3

GE Corporate

CMT Digitization

4

GE Corporate

Cognos TM1 10.2.2 Upgrade

5

Kaiser Permanente

TM1 Finance development & Support

TM1 Offshore Lead and Developer

Jan 2014 – May 2014

Cognizant

6

Novartis AG

IBM Cognos TM1 Finance application development & Support

Sr. Cognos TM1 Developer

Oct 2010 – Dec 2013

Cognizant

7

WWL (Wallenius Wilhelmsen Logistics)

Long Term Strategy (LTS) planning application

TM1 Developer

Jul 2010 – Sep 2010

Cognizant

8

Amex

E-Acq WAS 6 Migration.

Associate Cognos Consultant

Cognos BI 10.2.2

(Report studio,

Analysis studio,

Event studio,

Framework Manager,

Cognos connection),

IBM Cognos Go Office (Excel & PPT)

Oracle11g

Nov 2009 – Apr 2010

COGNIZANT

9

Pfizer

Go Office reports – Oncology C Reports

Associate Cognos Consultant

Aug 2009 – Oct 2009

Cognizant

10

Nielsen Online

ADR ( Ad Relevance )

Cognos Consultant

Feb 2008 – July 2009

TCS

11

Nielsen Online

Measurement Science

Sep 2008 – Jan 2009

TCS

12

FSA(Financial Services Authority) UK

GABRIEL – BI (Mandatory Electronic System)

Jan 2008 – Aug 2008

TCS

13

Hibernian Insurance (AVIVA)

Direct Data Warehouse Reporting Information

June 2007 – Dec 2007

TCS

Contact this candidate