Rama Kota

Sr. Cognos Consultant

ac3ri5@r.postjobfree.com

408-***-****

On - (GC)

SUMMARY

Around 9+ years of extensive experience in analysis, design and development of Business Intelligence applications using Cognos products.

Expertise in Cognos Analytics / Cognos 11.0,Cognos 10.1 (Report Studio, Framework Manager, Business Insight, Business Insight Advanced), Cognos 8 BI suite (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, Power Play studio), Report Net 1.1, Transformer, Cognos suite 7.x (Impromptu catalogs, Impromptu Web Reports, Upfront) and Power Play Enterprise Server.

Experience in Data Modeling- Relational, Multidimensional and DMR (dimensionally-modeled relational) modeling in Framework Manager.

Followed Best Practices for dimensional and relational data model using Framework Manager.

Experience in building and maintaining Powercubes in Transformer using relational, DMR and OLAP packages as data sources

Developed various Complex reports using Cognos 8, ReportNet, PowerPlay and Impromptu

Performed Query optimization and improved report performance through use of index, aggregate tables and drill-thru functionalities.

Expertise in installation, configuration and administration of Cognos products in a distributed multi-server environment.

Working and coordination with overseas (ETL) teams. Involved in administration in Cognos Connection and security implementation among Cognos Applications. Performed administrative roles in Cognos Connection and set security permissions, configured and maintained users, groups and roles using Cognos Administration.

Good communication skills with strong ability to interact with end-users, customers, and team members.

Good analytical, problem solving and interpersonal skills. Ability to work in a team environment or work independently and handle multiple tasks concurrently.

SKILLS

BI Tools IBM Cognos 8.x BI (Report Studio, Query Studio, Framework Manager, Cognos Connection, Analysis Studio, Event Studio, PowerPlay studio), Cognos 10.x, (Report Studio, Framework Manager, Business insight), Cognos 11.04 ReportNet 1.1, Transformer, Cognos suite 7.x (Impromptu catalogs, Impromptu Web Reports, Upfront)

Programming skills SQL, PL/SQL

Scripting Languages JavaScript, VB Script

Databases Oracle 9i/10g/11g, SQL Server 2003/2005/2008, DB2

Tools and Utilities SQL Developer, TOAD, Erwin, Microsoft Visio, Rational Requisite Pro

Operating Systems Windows, UNIX

Web Servers Microsoft IIS, Apache 6.0/7.0, Apache 2.0

Educational Qualification

Bachelor of Engineering, Electronics and Communications (BE) 1994

Andhra University –Visakhapatnam-India

Master of Business Administration (MBA)-Marketing 1997

Vishwakarma Inst of Management - Pune -India

Diploma in International Business (DIB)- 1997

Symbiosis Inst of Foreign Trade-Pune India

WORK EXPERIENCE

Pitney Bowes-(WIPRO's client)-Shelton CT Nov-2017-Current

Lead Cognos Consultant

Application Maintenance and Support (AMS): Maintain health of Cognos Production Environment(10.2) and modify the frame work model based on the Hana Views and Oracle Data bases.Also involving in migration to Cognos Analytics version (11.07).

New York Community Bank (NYCB) Cleveland -Ohio April-2016 - Sept-2017

Sr Cognos Consultant

Top Lending Reports: Designed, modeled and developed reports like top lending reports with monthly trend, with display of ratio of Top lender to total and summary charts using Cognos Analytics version (11.04).

CD Promo: Designed and Developed report on CD Promotion which provides graphical representation of how a CD promo is doing in state wise, region wise and Branch wise etc in multiple tabs, with custom interactivity and provide summary at a glance. (Recent project)

Loan Hub:

Converting SAS (Data Flux) reports to IBM Cognos 10.2.2. Reports.

Designed and modeled Complete Frame Work model in Cognos 10.2.2 based on start schema for migrating reports from Data Flux to Cognos 10.2.2 and adding security.

Enhanced the reports readability using color coding display and conditional formatting

Recreation of Data flux reports to Cognos 10.2.2, and Migrating reports from Cognos 10.2.2 to Cognos Analytics or Cognos 11.0

Involved / assisted the admin in the environment set up

Designed and created Consolidated Stress Report (for a Previous 3 month period) summarizing 90 validation reports.

Documenting the FM model and Reports.

Environment : Cognos Analytics / Cognos 11, Cognos 10.2 -Frame Work Manager, Report studio, Work Space advanced, Oracle 11 g,Toad

Teradata -Cleveland -OH Nov-2015 -Feb-2016

Cognos Sr Developer

PRISM Project (American Greetings):

In design phase -Involved in design and Creation of FSD and Technical Documents for their American Greetings client. Created FSDs for their standard reports, FSD/Technical documentation for Framework Manager Model for their standard reports, Adhoc reports to their upcoming PRISM Project.

General Motors IT -Austin TX May-2015 - Sept 2015

Cognos Sr Developer

ISAR Project:

Working on Migration of reports from Cognos 7.4 to Cognos 10.2,

Worked on conversion of impromptu catalogs, to Framework packages, created DMR Models and published and used packages to develop reports using Report studio, created model for adhoc reports.

Designed security for Framework Models,

Involved in Data base model converting 21 databases to single database.

Interacted with ETL team in creating data mapping document for conversion of relational data base to Dimensional model.

Environment : Cognos 7.4,Cognos 10.2 -Frame Work Manager, Report studio, Work Space advanced, Oracle 11 x,SQl developer, Erwin Modeler 7.3,Erwin modeler 9.3.

HNI Corp - Muscatine -Iowa

Cognos Sr Developer. Nov-2014 -Mar -2015

Working on cognos 10.1 - Creating new cube from scratch,

Modifying existing cube based on IQDs as data sources.

Interacted with overseas ETL team for modifications in the data ware house to suit the cube requirements.

Profitability Cube:

This profitability cube provides the data in the necessary view.

Worked with HON management division for their profitability projection based on analysis of current and past data.

The cube is based on a complex IQDs based on Oracle as database. And data input from the management team is using csv files.

Interacted with offshore ETL team to create process to load the csv file data that is supplied by business.

ITSM Cube: It is service level ticket management system.

Created from two MSSQL data bases - 1. Support works db and 2.Eclipse db.

Used IQD as data source, in transformer created custom measures for the IT management department based on the analytics data that is needed. Created multiple date dimensions and multi level dimensions.

Created custom views and provided user level security to users.

Environment : Cognos 10.1 -Frame Work Manager, Report studio, MS SQL, Oracle 11 x,SQl developer,Toad

Square Two Financials : Denver -CO. June-2014 - Oct-2014

Cognos Consultant(Cognos Sr Developer)

Working on Cognos 10.2.1 - Upgrading the project -

S2F is Asset Management Company generating revenue through distribution and management of debt assets in the form of delinquent accounts from variety of institutions.

An Agile working environment,

Creating new Cubes Replacing Cube's current data source to Packages sources using transformers.

Replacing multiple cubes with single cube.

Creating complex Framework Models, trouble shoot models which involve cross joins, create Reports for Data sources to replace IQDS and Client reports.

Creating security for cubes,by creating custom views and Apexes based on branches and franchises.Created users, groups

Security : Provided security using LDAP Active Directory.

Applied security and provided specific access for the cubes designed.

Created Dash boards for the Management Team using report studio.

Created and modified reports for a data Source for the Cubes using report studio.

. . . .

Environment : Cognos 10.1 -Frame Work Manager, Report studio, Oracle 11 x,SQl developer,Toad, Cognos Power Play Transformer, Query Studio

Office of State Courts Administration :Jefferson City -MO. -- Feb-2014 - June-2014

Cognos Consultant.(Cognos Developer/Admin)

Project Up gradation :

Responsibilities:

Total upgrade of the project from cognos 8.4 to latest cognos10.2.1.

In a distributed environment. Validate the reports and fix the issues.

Responsibilities:

Installed and Administering IBM Cognos 8.4 and Cognos 10.2/10.1.1 in Windows 2008 R2 - Single –Tier, Multi-tier environment.

Installed Service pack1, Service pack 2 and Hot fix in distributed environment.

Migrated IBM Cognos 8.4 content to Cognos 10.2.1 environment.

Participated in capacity planning -servers, software’s, licensing and collaborated on architectural design of hardware requirements, networks and security.

Secured the IBM Cognos BI Environment with Authentication provider such as LDAP.

Installed and Configured the desktop tolls (Transformer, Frame work Mananger, Powerplay client and IBM Cognos Insight)

Involved in load balancing of gateways and performance tuning setting in cognos portal.

Thorough understanding of IBM Cognos Dispatcher & Services and Java (JVM) and Query services Memory Management.

Liaising with IBM Cognos software support to troubleshoot issues, including enable tracing and capture log files.

Scheduled reports in Cognos Connection based on the reports to run Daily, Weekly or Monthly basis.

Support Cognos production environment for large scale user base and collaborate with team members to identify best practices.

Participate in system, integration, performance, and user acceptance testing for systems.

Trained business super users to develop/use reports using Report Studio, Query Studio, and Cognos Insight.

Worked with IBM team to resolve the environment issues.

Environment : Cognos 8.4, Cognos 10.1 -Frame Work Manager, Report studio, Oracle 11 x,SQl developer,Toad

University of Michigan, I Sept2012 – Jan-2014

Sr. Cognos Developer

Description:

University of Michigan is a world class research university and global leader in health, law and public policy. Michigan is a highly decentralized institution comprising three campuses located in Ann Arbor, Michigan. It is the oldest of the 15 public universities in the state of Michigan.

Responsibilities:

Involved in Designing DMR models with Relational Data using Framework Manager and deployed packages to the Report Servers.

Implemented Framework manager security for Data access, Object level access and Package access based on the Organization Level. Worked as Cognos Report Writer - Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio and created scorecard reports using the Metric Studio.

Worked on bug fixing and enhancements to existing Cognos reports in Report Studio& models in Framework Manger and development of any new Reports.

Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.

Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.

Worked on Analysis Studio to develop multi-dimensional reporting. Analyzed Business requirements from the analysts.

Involved to analyze and map data from source systems to target operational data stores and data marts (Data warehouse).

Developed Reports using Conditional Formatting, Cascading Prompts, optional prompts and Report Bursting.

Developed reports using System Development Kit (SDK) with help of Java team using java scripts and Eclipse at the back end.

Customized Reports using HTML and JAVA SCRIPTS.

Upgrade the report and packages version of COGNOS from 8.4 to 10 and Participate in the regression testing and unit testing.

Customized Cognos Connection with appropriate reports and security measures.

Implemented Security with LDAP and Group level security in Cognos Connection Portal.

Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts in Report Studio.

Created reports with Optional filters and custom prompt pages (using HTML and JavaScript) in Report Studio.

Created Drill through reports from Dashboard to all summary/Trend reports, Trend reports to Summary reports and Summary to Detail reports.

Developed Dash board reports to display all the information related to environment using Summary reports.

Environment: Cognos 10 (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Analysis Studio, Cognos Transformer and Event Studio), JavaScript and HTML, Oracle Data Integrator(ODI),Oracle Database 10g, Cognos Windows 7 Professional, XML and HTML.

Solar Turbines,San Dieago,CA Mar 2011–Aug 2012

Cognos Developer

Description: one of the worlds’s leading manufacturers of industrial gas turbines, play an important role in the development of oil, natural gas and power generation projects around the world. Headquartered in San Diego, California, USA, Solar Turbines Incorporated, a subsidiary of Caterpillar Inc. Work in many areas including production, processing and pipeline transmission of natural gas and crude oil and generation of electricity and thermal energy.

Responsibilities:

Gathered the reporting issues from the users and analyzed user requirements.

Involved in migrating metadata and reports from Cognos 7.4 to Cognos 8.2 using utilities.

Assessed the scope for migration and used different approaches of Lift & Shift, Compress & Optimize wherever necessary for migrating cubes and catalogs.

Created multiple data source connections for importing different data sources into Framework Manager.

Created multiple paged, multiple-query reports using multiple prompts for showing selective data on user input.

Designed relational and DMR models in Framework Manager and published packages to Cognos.

Implemented data security, object security and package security in Framework Manager.

Creating list reports, cross-tab reports and chart reports using multiple queries in a single report, drill- through reports and conditional formatting to highlight the business needs.

Created multi-query and ad hoc reports in the report studio and query studio and developed many complex reports for financial analysis.

Used detail, summary and context filters for making the reports more specific.

Used conditional formatting, conditional styles and Style variables to render reports for different user needs.

Created calculated columns to measure the Gross Profit, Net Profit, and Burden in terms of Revenue.

Created a toggle report that swaps a report layout as list or chart.

Developed monthly Product Sales Trend, Transactions History and Backlog reports filtered by regions in Analysis Studio.

Created Sales analysis and summary reports for current year and previous year using Analysis Studio

Scheduled reports in the Cognos Connection portal to use off-peak hours effectively.

Environment: Cognos 8.2(Framework Manager, Query Studio, Report Studio, Analysis Studio), Cognos Connection, Transformer, Cognos 7.4 (Impromptu, PPES, Upfront, IWR), Access Manager, MS SQL Server 2005, migratetoc8, deploytoc8

KK Associates - Bank Client, Nov 2009 – Mar2011

Cognos Developer.

Description: BA is a financial institution, serving individual consumers, small and middle market businesses, corporations and Governments with a range of banking, investing, asset management and other financial and risk management products and services. The Company provides a range of banking and nonbanking financial services and products .through five business segments: Consumer & Business Banking, Consumer Real Estate Services, Global Banking, Global Markets and Global Wealth & Investment Management

Responsibilities:

Analyzed Business requirements from the analysts.

Customized Cognos Connection with appropriate reports and security measures.

Implemented Framework Manager Security for Data access, Object level access and Package access based on the Organization Level.

Implemented Star Schema Grouping and Dimension Hierarchy in Framework Manager Model.

Modeled metadata from Oracle data source for use in Report studio and Query Studio using Framework Manager.

Upgrade the report and packages version of COGNOS from 8.0 to 8.1 and Participate in the regression testing and unit testing.

Created Database Layer, Intermediate layer and Presentation Layer, defining appropriate relationship between query subjects and Fact Table in Framework Manager.

Designed models &cubes in Cognos 7.2 Transformer using existing IQD’s from Framework Manager.

Worked on Analysis Studio to develop multi-dimensional reporting.

Environment: Cognos 8.0/7x Bi Suite (Framework Manager, Cognos Connection, Query Studio Report Studio, Metric Studio, Transformer and Event Studio), JavaScript and HTML, MS Visio Standard 2003, Impromptu 7.4, Cognos Power Play 7.3, Cognos Transformer 7.3, Oracle 9.2i client, VB Script, SQL and PL/SQL, IIS, Windows XP Professional.

MTV Networks, NY Jun 2007 – Oct2009

Cognos Developer

Description: MTV Networks operates a leading portfolio of cable TV channels anchored by its music video networks MTV, VH1, and CMT. A total of some 170 branded channels, the company reaches 640 million households in more than 160 countries. MTV Networks also produces movies through MTV Films. MTV Networks is a unit of media giant Viacom.

Responsibilities:

Interacted with the Business users for requirement gathering.

Installed & configured Cognos component such as the ReportNet.

Created the list, cross tab, repeater and Drill-through reports, master-detail reports, prompts, complex calculations, formatting, conditional formatting, Bursting reports, charts and created the reports in different formats like PDF, XML, HTML and CSV.

Created Cascade Prompts, Bookmarks, Query prompts, Filters, and Multilingual Reports Using Report Studio.

Used Cognos Connection for organizing, security, scheduling and distributing reports.

Created various IQD packages in Framework Manager and from this IQD integrated to power play transformer to create various models and cubes.

Used Transformer with a variety of sources and combined them into Multi-Dimensional Cube.

Configured access manager namespace in Cognos connection and created new users and user groups in access manager.

Provided technical assistance, training and mentoring to Users and Business Partners

Environment: CognosReportNet 1.1 MR3 (Framework Manager, Report Studio, Query Studio), Oracle 9i, SQL Server 2000, SQL, PL/SQL, Windows XP/NT

Citizens Bank, RI Apr 2006 – May 2007

Cognos Developer

Description: Citizens Bank a RBS CITIZENS FINANCIAL GROUP, INC. is a $126 billion commercial bank holding company. It is headquartered in Providence, R.I., and through its subsidiaries has approximately 1,400 branches, more than 3,600 ATMs. Royal Bank of Scotland is the parent company.

The Company provides various commercial and consumer banking products and services like Commercial lending, Asset Financing, Capital Management, Treasury and Investment management services etc.

Responsibilities:

Worked on Cognos framework manager to import metadata from multiple data sources and to create subject oriented business models, create and publish packages to Cognos 8 server.

Implemented Security with LDAP and Group level security in Cognos Connection Portal.

Creating relationships between query subjects to better represent the logical structure of the business and the user requirements.

Creation of procedures, views, tables and functions according to business requirements in Oracle.

Involved in Creating IQD files from Report net and designed Power play models in Transformer

Involved in Migrating metadata and reports from Cognos 7 to Cognos 8 using utilities.

Authored Reports using Report Studio and trained end users in building Ad-hoc reports using Query Studio.

Created Dash board reports to get all the information from other reports.

Production Support, which involves solving user problems.

Environment: Cognos Report net 1.1 MR2 (Framework Manager, Query Studio, Report Studio), Impromptu 7.2, Power Play Enterprise Server 7.2, Transformer 7.2, Informatica 7.0, Oracle 9i, T-SQL, XML and HTML.

Reliant Energy, Houston, TX Jun’ 2005 – Mar 2006

Cognos Consultant

Description: Reliant As part of NRG Energy - provides electricity and energy services to retail customers, including homes, businesses, manufacturing facilities, government entities and institutions across Texas. Reliant is engaged in the supply of energy, services, and sustainable products to retail customers in competitive markets through multiple channels and brands supplied by NRG Energy.

Responsibilities:

Involved in designing data model and report design.

Understanding functional specification and preparing technical spec.

Created report net models, queries according to standards

Created and publishing packages to Cognos connection.

Created the user roles in cognos connection.

Built Power Play Reports in Report Studio by replicating the power play functionality in Report Studio using dynamic Measure selection, Dynamic Sorting, ranking.

Created Dashboard Reports by translating data into visually rich presentations using different types of charts, and other graphical elements to show multiple results together.

Customize the Cognos connection portal using existing portlets and customized tabs.

Worked on complex reports using Static Prompt and MDX functions and union conditions.

Used Cognos Office Connection to publish the reports in Power point and format them for business presentation.

Created the Dashboard reports using Report Studio.

Authoring reports in report studio according to requirement by implementing many features like prompts, conditional formatting.

Scheduling the monthly reports with saved prompts using Job Wizard.

Designed transformer model (dimension map, facts (regular/calculated)).

Created batch files (macros) to refresh the cube monthly.

Deployed the cube from Testing Environment to Production Environment using Batch script.

Environment: Cognos 8.2 BI, Report Net 1.1, Framework Manager 1.1, Cognos Report Studio 1.1 DB2.0, Report Studio 1.1/8.2,Transformer 7.2/8.2, Cognos XML, Generic/Cognos JavaScript.

Contact this candidate