Cognos / Tableau / TM1

Location:

Posted:

June 27, 2015

Resume:

Summary Profile:

Information Systems Professional possessing with 11 years of Business Intelligence experience leveraging in-depth technical and functional knowledge with good analytical skills to gather requirements, manage and successfully design and deliver suitable business solutions that meet business requirements and enhance efficiency and productivity.

Cognos Certified Product Professional

Full life cycle development experience in managing and delivery of complex BI solutions especially with Cognos

Certifications:

IBM Certified Designer – Cognos 8 BI Metadata Models

IBM Certified Developer – Cognos 8 BI Reports

Cognos ReportNet Product User

PowerPlay Series 7 Product Professional

Impromptu Series 7 Product Professional

Education:

Master’s Degree in Computer Applications (MCA) – Nagarjuna University – Jul 2000 to Jun 2003

Bachelor of Science (B.Sc.) – Nagarjuna University – Jun 1997 to Apr 2000

Intermediate - Board of Intermediate – Jun 1995 to May 1997

Xth - Board of Secondary Education – Jun 1994 to Mar 1995

Career Profile:

Domain

Client

Role

Dates

Reinsurance

AIG

BI Architect

Aug 2011 – Till Date

Services

ADP

Cognos Architect

Jun 2011 – Aug 2011

Pharma

Johnson & Johnson (J&J)

Cognos Architect

Mar 2008 – Jun 2011

Finance

Ameriprise Financial

Developer

Jun 2007 – Dec 2008

DaimlerChrysler Financial Services

Developer

Jan 2007 – May 2007

Aeronautical

GE Aeronautical Engines

Tech Lead

Feb 2005 – Dec 2006

Chemical

Badischie Analin Soda & Fabrics (BASF)

Developer

Nov 2003 – Nov 2004

Technology:

Cognos 10.2

Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Workspace, Workspace Advanced and Cognos Connection

Cognos 8.x

Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos Connection

Cognos BI 7 Series

Impromptu Administrator, PowerPlay Transformer, Visualizer, Upfront & Access Manager

Cognos Migration Tools

Migratetoc8, Deploytoc8 and impcat2xml

Cognos TM 1

TM1 Architect / Perspectives for MS Excel /Turbo Integrator

Tableau 8.3

Tableau Desktop, Tableau Server & Tableau Online

ETL Tools

Informatica 6.0

Databases & Tools

Oracle, SQL Server, SQL Plus, TOAD

Languages

SQL, PL / SQL

Configuration Management Tools

Share Point, eRoom, Microsoft VSS, PWC Quick Place

Operating Systems

Windows and UNIX

Others

MS Excel, MS Word, PowerPoint, MS Visio, MS Project

Professional Experience:

Employer: Techwave Consulting, Exton PA Jun 2011 - Present

AIG (American International Group Inc.) Aug 2011 - Present

BI Architect

Reinsurance Information management System (RIMS) is reinsurance reporting system designed to meet growing reporting needs for analysis. The system serves an easy tool for any and all Finance and Accounting departments to build reports for analysis. Summary reports were generated at Reinsurer, Treaty level and detailed reports at Policy & Claim level. Cognos reports are used for filing to General Ledger, Sub Ledger and are used for identifying Non Machines (Adjustments) for making manual entries in the Reinsurance system. Profit Centre reports are delivered to user’s inbox on Quarterly basis for CRS Close. Users are provided with Canned Reports as well as Self Service (Query Studio) environment for creating their own reports and sharing within the user groups.

Working closely with Business users & Business Analysts for Scope identification.

Developing Technical and Functional Specification documents.

Worked with Data team in designing Data warehouse to handle current & proposed reporting requirements.

Responsible for managing Cognos BI Environment and SPOC

Designed Framework Models and Reports with better performance approach and addressed performance issues in existing system.

Developed Self-service environment (Query Studio) enabling business users to generate simple reports for analysis & decision support

Created Dashboards in Tableau at Reinsurer / Policy level allowing business users to understand where the company is profitable / need attention.

Migrated Cognos dashboards to Tableau showing Year over Year comparison of different key metrics, Premiums Vs Losses, IBNR etc.,

Combined visualization into Dashboards & Published them to Tableau Server for business users use.

Prepared user stories to create compelling dashboards to deliver actionable insights.

Managed offshore and onshore development team and responsible for delivery

Responsible for post-production support via Service Now incident management system

Prepared detailed User Manual for Business User to use Cognos environment effectively.

Trained Business Users in using Self Service Environment to develop their own reports.

Environment: Cognos 10.2, Cognos 8.4, Tableau 8.3, Oracle, TOAD, eRoom.

Employer: Techwave Consulting, Exton PA

ADP (Automatic Data Processing) Inc. Jun 2011 – Aug 2011

Cognos Architect

Service Request (SR)

Automatic Data Processing (ADP) Inc. is a global provider of integrated computing and business outsourcing with headquarters in Roseland, NJ. ADP Offers a range of HR, Payroll, tax and benefits administration.

Service Request (SR) captures metrics like # of SR, # of Child SR’s, Resolution Time / Age of SR, TSLA (Time Since Last Activity) by Time, Divison, WorkGroup e.t.c., The purpose of this project is to migrate SR Reports from Crystal Reports to Cognos pulling data from NEW Siebel data mart.

Interacted with Business Users for better understanding of the requirements to enhance the reports as part of migration.

Interacted with data team for better understanding of the old and New Siebel databases design.

Developed Technical Report Specification documents.

Created Column level mapping document between Old SQL Server system and Siebel SQL Server Data mart.

Created Framework Manager Model based on Cognos best practices & Publish package.

Developed reusable components like Report Template & Classes.

Developed Cognos Reports in compliance with ADP reporting standards

Presentation to Business Users

Environment: Cognos 8.4, Crystal Reports, SQL Server, Siebel, SharePoint

Employer: TATA Consulting Services Ltd., Edison NJ Dec 2006 – Jun 2011

Ortho-McNeil Janssen Pharmaceutical, Inc. (a Johnson & Johnson Company) Jul 2009 – Jun 2011

Cognos Architect

Totality

Totality is the Healthcare Compliance (HCC) project which acts as unified platform for all health care professional related spending by Johnson & Johnson. Totality portal acts as approval workflow tool for the common spending like speaker training, ad board, and Institution Education Grants, Consulting Arrangements, Third Party transactions (Health Care Professionals expenses paid by third party) etc., TM1 cubes are used for analyzing history spend data of Health Care Professionals (HCP) for different type of transactions like Consulting Arrangements, Grants, Product Training and Global Expense Reporting System (gXRS - HCP Spend data on Meals, Travel & Lodging) & Forecasting

Totality Cognos report are broadly classified into three groups

1.State Reports: Filed to State & Federal government agencies for compliance with State reporting Transparency act.

2.Operational Reports: Help’s HCC & Totality Leads to arrive at their decisions

3.Transaction reports: Shows spend & payment details of Health Care Professionals (HCP)

Conducted work-shops and interviews with BU IT and Business Users for the requirements

Worked on Proof of Concepts in order to gain the approval from the business

Worked on Estimates, resource planning and developed Project Plan for Cognos 8.4 à Cognos 10 upgrade

Upgraded Cognos objects from Cognos 8.2 à Cognos 8.4

Developed cube in TM1 for analyzing HCP spend analysis & forecasting

Created dimensions using Dimension Editor (manual), Turbo Integrator

Created processes for loading data into cubes from Databases & Flat files

Created Chores for refreshing / Accumulating cube data, Saving data at regular intervals of time

Created complex rules for calculations and logic

Logical & Physical design of multi layered FM model, as per reporting requirements.

Developed / Reviewed reports in compliance with Johnson & Johnson reporting standards.

Designed & developed Dashboard reports to show $ spend by Business Unit (BU) –Year - HCP, gXRS dashboards to show HCP spend to physicians on different categories like Meals, Travel & Lodging & Detail reports etc.,

Implemented Security model at BU level meeting all the requirements, at the same time minimize the effort & time required for security administration.

Black Box (Peer to Peer Reviews) & White Box testing (Self Review) testing of Cognos Objects

Black Box Testing of Totality Application

Supported existing BI reporting solutions

Environment: Cognos 10, Cognos 8.4, Cognos 8.2, Cognos TM1 9.5 and Oracle, SharePoint, eRoom

Employer: TATA Consulting Services Ltd., Edison NJ

Ortho-McNeil Janssen Pharmaceutical, Inc. (a Johnson & Johnson Company) Feb 2009 – Jun 2009

Senior Developer

Research Concept Approval Process (ReCAP2)

The Research Concept Approval Process (RECAP2) reporting system which is focused on providing reporting and analytical capabilities to the Global Medical Affairs management and associates. It will serve to better organize, manage, and communicate the activities that generate clinical efficacy and safety data for marketed products or products pending regulatory approval.

This project had 1 Frame Manager Model and 12 reports (6 Dashboard & 6 Detail Reports).

Reports display various metrics of the research concepts. Users had the flexibility to specify filter criteria and re-run the reports. They can also view the detailed level data with the help of hyperlinks provided in the report & have hyperlinks to ReCAP2 application as well.

Interacted with Business users for gathering & understanding the requirements.

Responsible for Functional and Technical documents for the solution

Developed various training presentations and conducted class-room training to Business Users and Higher Manager in Cognos Navigation and Ad-hoc Reporting

Overall responsibility for implementation and deliverables

Hand’s on development on Framework Manager, Report Studio and Query Studio to demonstrate initial reports and proof of concepts

Designed & developed Dashboard reports to show pending concepts by workflow level –Region – Therapeutic Area, Average life of a concept by Region, country etc., & Detail reports.

Reviewed reports in compliance with Johnson & Johnson reporting standards.

Created hyperlinks to ReCAP2 application from Detail Reports for additional information.

Led Unit Testing, Integration Testing, IT UAT and UAT

Mentoring Cognos Developers and Modelers

Developed & Executed Cognos 8.2 to Cognos 8.3 Migration Project Plan.

Environment: Cognos 8.2, Cognos 8.3, SQL Server, PWC Quick Place, SharePoint

Employer: TATA Consulting Services Ltd., Edison NJ

DePuy (a Johnson & Johnson Company) Mar 2008 – Jan 2009

Cognos Tech Lead

DePuy Cognos 8 Migration

DePuy is an operating company of Johnson & Johnson. DePuy consists of four operating companies. DePuy Spine and DePuy Mitek two of the four companies desire to migrate from their existing Cognos applications to Cognos Series 8. DePuy Spine and DePuy Mitek are global organizations with headquarters in Raynham, Massachusetts. DePuy Spine works with leading clinicians, researchers, and thought leaders to develop innovative products that improve the care of patients with spine disorders. DePuy Mitek offers comprehensive and innovation solutions for a broad range of surgical needs.

DePuy Spine and DePuy Mitek desire to migrate from their existing Cognos applications to Johnson & Johnson shared (Manages Services for Cognos) Cognos Environment and to eliminate the dedicated environments. Some of the key benefits accomplished as part of migration are

1.Leverage the Johnson & Johnson’s Managed Services for Cognos (MSC) environment

2.Eliminate the dedicated Cognos environment & Desktop installations. This environment contains over 20 servers

3.Reduce the complexity and redundancy of Cognos framework objects

4.Reduce the number of reports

5.Enhance existing security and reduce security administration

Conducted work-shops and interviews with BU IT and Business Users for the requirements

Coordinated with offshore team to delegate the work.

Responsible for Functional and Technical documents for the solution

Reviewed Cognos Objects in compliance with Johnson & Johnson reporting standards before delivering.

Upgraded Report Net 1.1 FM models & Reports to Cognos 8.2

Migrated Impromptu catalogs to Cognos 8 FM models using Migration Tools

Re developed Impromptu reports in Cognos 8 environment

Published Cognos cubes to Cognos 8 portal

Re developed PowerPlay reports in Analysis studio

Enhanced the existing security model to reduce security maintenance

Implemented data level and object level security

Developed training presentations and conducted class-room training to Business Power Users and Higher Manager in Cognos Navigation, Ad-hoc Reporting, Analysis in Analysis Studio and basic reports in Report Studio

Environment: Windows 2000, Cognos 8.2, Cognos series 7 (Impromptu, Powerplay, Upfront, Access Manager), Oracle 9i, Oracle 10G, eRoom (EMC Corporation), Rational Clear Case (IBM Corporation)

Employer: TATA Consulting Services Ltd., India

Ameriprise Financial Jun 2007 – Dec 2008

Developer

Corporate Reporting Systems (CRS)

Ameriprise Financial provides a broad range of financial planning services for individuals and businesses. CRS technologies has a set of applications which supports all reporting needs related to business done by advisors for operational and analytical purpose. The main business unit supported by CRS is Field Management Reporting. Currently CRS generates 200+ Reports in a Month. Field force, Marketing, AMPF Corporate management and Business Support groups form the users of CRS.

Interacted with On-site lead for Clear understanding of the Requirements

Logical and Physical Design of the Cognos Report Net models

Developed reports as per the Business needs

Prepared and Executing test scripts for the reports.

Environment: Cognos 8.2, Windows XP, DB2 and Actuate, Microsoft-VSS (for source code control)

Employer: TATA Consulting Services Ltd., India

DaimlerChrysler Financial Services Jan 2007 – May 2007

Developer

Single Point Of Truth (SPOT)

DaimlerChrysler Financial Services (DCFS) provides financial services to DaimlerChrysler’s (DCX) wholesale and retail/lease customers. This module mainly concentrates on Dealer Credit.

The dealer credit acquisition process begins with the sales activity of gathering dealer information, reviewing financial information, and approval/disapproval of a loan. If the loan is approved, the dealer credit limit is established. The dealer credit maintenance process consists of a periodic review and analysis of the dealer’s financial condition, monitors dealer’s reserves, monitors cash management accounts, addresses dealer’s trouble situations, monitors the dealer’s inventory, and manages dealer transfer of funds.

The dealer credit liquidation process ends with the receipt of a final payment from the dealer or the liquidation of the loan in event of a default.

Interacted with On-site Team for Clear understanding of the Requirements.

Prepared technical design Docs based on Business requirement docs.

Developed / Modified ReportNet Reports to meet user requirements.

Prepared & Executed Test Cases.

Environment: ReportNet & Teradata, MS-VSS (for source code control)

Employer: Patni Computer Systems Ltd., India Jan 2005 – Dec 2006

GE Aeronautical Engines Feb 2005 – Dec 2006

Tech Lead

Platform Reporting

The purpose of this project is to implement a decision support system having statistics by Engine Platform, Engine Model, Customer type and Contract type regarding various functional areas that will enable the GEAE Engine Platform Management and Contract Program Managers to take their strategic decision accurately.

This project involves in creating Cognos reports to accurately display Engine Performance and Shop Visits statistics by platform, model & Customer / Contract level. Involved in different modules like Operational, Cost per $/SV, Line Of Sight (LOS) Scorecard modules.

Interacted with Client for Clear understanding of the Requirements.

Prepared Design Docs & Test Case documents.

Developed Impromptu Reports to meet user requirements.

Developed / modified Transformer Model to meet the Requirements at Visualizer Level.

Coding of the Visualizer for Customer Satisfaction.

Executed Test Cases for Impromptu Reports, PowerPlay Model and Visualizer Reports.

Presentation to the User.

Environment: Impromptu, PowerPlay & Visualizer, Oracle, MS-VSS (for source code control)

Employer: Lanco Global Systems Ltd., India Nov 2003 – Nov 2004

BASF Corporation (BADISCHIE ANALIN SODA & FABRICS) Nov 2003 – Nov 2004

Developer

BASF – COGNOS

BASF Corporation is the word leading chemical company and rated one in United States, in the NAFTA (North American Free Trade Agreement) region. BASF currently maintaining different databases like SAP, Oracle etc., and maintaining reports in MS Access, Cognos Impromptu. BASF want to migrate all of the reports to impromptu. Project is spanned across two phases.

1.Preparing Report specification documents and mapping documents for the reports in MS Access as well as the new reports that we are going to develop in Impromptu

2.Developing reports in Impromptu based on specification documents, Guidelines and Abbreviation list