CERTIFIED
PROFESSIONAL
Mallikarjun
*******@*****.***
Objective
Looking for the great opportunity to work as a cognos developer for a reputed company
Summary of Experience
Over 3 years of experience with Business Intelligence tools like Cognos 8, ReportNet
(Report Studio, Query Studio, Analysis Studio, Framework Manager, PowerPlay
Transformer)
Experienced in Creating and publishing packages using Framework Manager and
generated different kind of reports including List, Cross-tab, Conditional Blocks in
Report Studio
Performed Administrative and Deployment Activities in Cognos Connection
administration tools
Experienced in Creating Dashboard reports.
Experienced in creating Dimensionally Relational Modeling (DMR) in Cognos 8
Worked on PowerPlay Transformer to Create Multi-dimensional Models and Cubes
for reporting in Analysis Studio
Expertise in Life Cycle Development of Reports and Multidimensional Cubes
Excellent ability to gather and understand business requirements and translate into IT
solutions with the use of Cognos
Very good communication, analytical skills and fast learner on new technologies.
Technical Skills
CERTIFIED
PROFESSIONAL
Education
Bachelor of Technology in Computer science from Kakatiya University, India
Master’s degree in Computer Science from Eastern Illinois University, USA
CERTIFICATION
COG – 112 IBM COGNOS 8 BI Author
Accomplishments
Delivered Ad-hoc Reporting Capability to higher management and business users at
Ditan
Successfully delivered several canned Reports at Ditan
Delivered Dashboard Report with Drill Through capability on Portal Page
Professional Experience:
Client: HDFC, INDIA. May‘06 – July ‘07
Position: Cognos Consultant
As part of the maintenance and reporting team, I was involved in the development/modification
of Financial Reports using Cognos 8 and ReportNet. The scope of this project was to create
reports for the Accounting Department to be able to analyze the company’s financial
performance at any specific point of time.
Responsibilities:
Involved in gathering business requirements and converted them into technical specifications
Designed New Models in Framework Manager and published Packages to Cognos
Connection
CERTIFIED
PROFESSIONAL
Created the Business Layer and Presentation Layers for Ad-hoc reporting and
Professional reporting
Implemented Object Level and Data Level Security in Modeling
Enhanced the existing reports with better formatting for a better presentation to the end users
Designed and developed new Multi-Page, Multi-Query reports to address business logic
Developed more than 80 reports - List, Cross-tab, Drill through, Master-detail, Chart
which involved Multiple Prompts, Conditional formatting, Filters, and Multi - page,
which resulted in significant decrease of man-hour requirements while increasing the
accuracy and amount of data presented
Worked on various performance enhancements for the existing as well as the new reports
Worked with the Administrator to fine tune the performance of the reports in production
environment
Assisted in Migrating Cognos 7 series content and ReportNet content to Cognos 8.2
Involved in the end user training sessions on Query studio, and Cognos Connection
Environment: Cognos 8.2, Cognos ReportNet, Framework Manager, Report Studio, Query
Studio, Analysis Studio, Transformer, MS SQL Server 2000, and Windows 2003 Server
SagarSoft Inc. India May 2005-Apr 2006
Position: Cognos Developer consultant
SagarSoft is a specialist software provider of Pre-integrated Solutions and Outsourcing Services.
The project involved designing and implementing a Workforce Management product on
centralized platform to better manage the performance of people in an organization.
Responsibilities:
Worked with Business Units to define Business strategy and create a centralized
reporting capability for users to perform Analytical and Ad-hoc Reporting for business
applications and provide accurate information available to decision makers
Used Cognos ReportNet as the web reporting solution of choice by conducting product
demonstrations and improve business performance at all levels of their enterprise
Used Cognos Connection for organizing, Security, Scheduling and Distributing reports.
Worked in Building HR Model and Publishing Packages in Framework Manager to the
ReportNet server.
Created various reports containing Filters, Calculations, Prompts and Conditions
using Cognos Report Studio.
Development of Ad-hoc Reporting interfaces using Cognos Query Studio.
Responsible for Scheduling, Deployment, and Maintain Security in ReportNet.
Worked with the administrator to Fine Tune the Performance of the reports in
production environment.
Used Cognos Transformer to built multi-dimensional Cubes and used it in Cognos
Power Play to built Graphs and Charts of Customer data. Created Models based on the
Dimensions, Levels and Measures required for the analysis.
CERTIFIED
PROFESSIONAL
Environment: COGNOS ReportNet 1.1 (Framework Manager, Report Studio, Query Studio,
Cognos Connection), COGNOS 7.2 (PowerPlay Transformer, PowerPlay Enterprise
Server, PowerPlay Web, Access Manager, Upfront), Oracle 9i, and Windows 2000.
Client: Citi Bank, INDIA June 2004-Apr 2005
Position: Cognos Consultant
Citibank is the consumer and corporate banking arm of financial services giant Citigroup.
Citibank serves standard banking fare to consumers and small businesses, offering deposits,
loans and also offering insurance and investment products. The bank’s online service is a leader
in its field, claiming around 15 million users. As part of the maintenance and reporting team, I
was involved in the development/modification of Financial Reports using Cognos Series 7
Impromptu and ReportNet. The scope of this project was to create reports for the Accounting
Department to be able to analyze the company’s financial performance at any specific point of
time.
Roles and Responsibilities:
Involved in gathering business requirements and analyzed the reporting requirements.
Created standard and Ad-hoc reports using Cognos Impromptu. Designed catalogs and
defined User Classes, Security and Privileges.
Created Lists and Cross-tab reports with Drill-through functionality.
Created Multidimensional reports by implementing Multi Dimensional Cubes using
Power Play and Transformer.
Drill-through from Cognos cubes to ReportNet reports.
Used Bursting options on some reports to deliver data into different Regions
Provided Security for Cubes of various User classes. Used Date Wizard to create time
dimension in Transformer for creating cubes and Power Play reports.
Environment: ReportNet 1.1,Cognos Impromptu Admin/User 7.0, Impromptu Web reports,
Power play Transformer, Power play for Web/Windows, PPES, Pl/SQL, Oracle 8i, DB2 UDB
6.1