Business Intelligence (Cognos)

Rishu Malpani

Email:

************@*****.***,

************@*****.***

Mobile No: +91-880*******

Professional Experience

Cellos Software Ltd.

Tenure : Nov 2013–Present

Location : Gurgaon

Designation : Senior Cognos Developer

IBM India Pvt Ltd.

Tenure : Nov 2010–Nov 2013

Location : Bangalore, NCR

Designation : Application Developer

Accenture

Tenure : Aug 2009–Nov 2010

Location : Bangalore

Designation : Software Engineer

Present Address

163, Din Apartments,

Sector -4, Plot-7,

Dwarka,

New Delhi - 110075

Personal Details

Date of Birth : 17th July,1986

Sex : Male

Nationality : Indian

Languages known : English, Hindi

Professional Experience Summary

5 years 9 Months (till May 2015) of experience in data warehousing and business intelligence field as certified Cognos BI 8 and 10 Report Author.

Worked as Analyst, Developer and a Lead

Presented and assisted senior management in forming future roadmap for

Analytics team.

Certified Cognos BI Report Author

Worked in different domains – Telecom, Oil and Petroleum, Health, Automobile etc.

Adept at phases of the Software Development Life Cycle including Requirement Analysis, Programming, Design & Construction, Testing, UAT.

Acquired working knowledge of SAP BI integration with Cognos using Bex queries. Also worked on Big Data (Netezza Database). Proficient in SQL, Databases, Data warehousing, Business process knowledge in automating complex reports

Demonstrating technical proficiency in a high paced production environment & exercise judgment within defined procedures & practices to determine appropriate action

A systematic, organized, hardworking team builder with an analytical bent of mind; reliable as a fully contributing, responsible & accountable member of task/project teams.

Developed and presented dashboards to the top management of the client

And had direct client interaction.

Possess strong fundamentals of Cognos 8.3/8.4/10 Report/query studio Cognos Framework Manager, Business Insight, ANSI SQL, Oracle 10g/9i, and basic Unix Commands. Also have basic working knowledge in Cognos Transformer.

Education

Jaypee University of Information and Technology, Electronics and Communication Engineering, Guna, Madhya Pradesh – CGPA 6.5(71.41%),Year -2009

Delhi Public School Dwarka,New Delhi, 12th Class (CBSE) – 74%,Year -2004

Ramjas School RK Puram, New Delhi,10th Class(CBSE) – 78.2%, Year- 2002

Technical Training & Certifications

1.Trained on Tableau and have done basic exercises

for POC.

2.IBM certified Report designer Cognos 10 BI

Reports and Cognos 8 BI Reports

3.Pursued IBM training in Cognos 8 BI in 2009

4.Pursued training in Datastage in the year 2009

5.Pursued training in Unix in the year 2009

TECHNICAL SKILLS

Operating Systems

Windows XP, Windows 7, Windows Server 2008

Technologies

IBM-Cognos 10, IBM-Cognos 8, SAP BI, IBM Cognos Transformer, IBM Cognos Administrator

Development Tools

Framework manager, Report Studio, Query Studio, Cognos Workspace,Cognos Insight, Architect

System Development

Analysis, Design, Development & Debugging

DBMS / RDBMS

Netezza,DB2,SQL Server 2005/2008, Oracle

Internet Technology

HTML, JavaScript, CSS

PROFESSIONAL EXPERIENCE

@ Cellos Software Limited

Project: Cellos Analytics

Client: Bharti Airtel

The CELLOS Analytics system is telecom based product which provides an efficient solution to the task of collecting per-customer data services meta-data suitable for inclusion in Customer Experience Management systems, operational performance improvements, network, and business insights. It is built on latest big data management technologies.

CellOS Analytics helps operators monetize mobile broadband, improve CEM, manage traffic intelligently, optimize network resources, and provides OTT/application visibility. It gives an integrated, real time view of network, subscriber, application and device behavior. The solution is integrated with IBM Netezza and Cognos.

Role: Senior Cognos Developer/Module Lead

Responsibilities:

Involved in the entire project life cycle from analysis, installation, development, testing, production and end user support

Cognos Portal Customization,Security implementation using CJAP

Developed models and published packages in Cognos connection using Framework Manager

Used Framework Manager to model metadata from different data sources and published packages to Cognos Connection

Involved in setting up security in Framework Manager

Involved in building dimensional model using framework manager

Developed Reports like list, chart, cross tab, cascading, burst,Master–Detail, Drill Through in Report Studio

Developed Dashboards, Complex Reports having many calculations, child reports, HTML items etc. in Report Studio

Experience in creating Ad-hoc reports using Cognos Query Studio

Creating and setting privileges on Users/User Groups

Prepared User documentation to train users and functionality of each report

Directly providing support as Team Lead to the Cognos BI Reporting department in the areas of software/application architecture, development, design, and independent analysis and problem resolution.

Assuring quality and customer service while leading and driving advanced/complex development tasks and projects to successful completion.

Responsible for preparation of documentation for the design plan, review specifications for modifications, integrating components and testing.

Providing technical leadership for enterprise application technology while estimating and evaluating the effort/schedules & providing training to the team on project architectures as well as on the software applications

Analyzing client requirement and designing concept document of requirement. Involved in the construction,quality assurance, support, all client communication; coding, unit testing and defect fixing

Performance Tuning of Cognos at various levels.

Used JavaScript and JQuery in Cognos screens

Developed dashboard which refreshes every 5 minutes automatically

Tried different tools like Tableau, ESRI Maps.

Installed Cognos on Windows Server with DB2 as Content Manager

Customized Cognos Connection, Report Studio, Query Studio.

Enhancement of existing reports based on user's change requests or Intake requests.

Fixing existing defects in existing reports as ‘n’ when basis.

Modifying existing Cognos Framework model (Relational) when required.

Performing data mapping for new Cognos Reports or Framework Model enhancement.

Keeping track of defects rose by BO/Testers and assign them to team members for resolution.

Mentoring resources with less experience in team.

Adding users to Cognos domain/Bank domain so that they can access cognos reports and control their access using security module.

Performing cognos admin job such as creating data source, maintaining environments, maintaining/creating schedule etc.

Provide Production support job when needed.

Updating and presenting Weekly Status Report(WSR) for Cognos Team to senior management

Performing the daily leadership job for Cognos Team (6 members) which includes job assignments, conflict resolution in team, handling on-boarding/off-boarding process for the team, providing solution for any unresolved query etc.

Technical Environment: Cognos BI 10.2.1, Framework Manager, Report Studio, Query Studio, Netezza, Probe 1.0

@ IBM India Pvt Ltd

Industry – Telecom

Developed various complex report and charts and dashboards

Developed cubes and executed them regularly so as to show daily data.

Tested report and cube data with AQT

Installed and configured Cognos and DB2 client

Prepared tutorial on Analysis Studio and presented to MD of the client and also taught the same to business user

Created Audit Tables

Worked on 60-70 reports on my own

Industry – Oil and Petroleum

Documentation – Business Requirement Document, Integration Specification Document, Report Design Document, Requirement Traceability Matrix, Test Cases, Test Plans,Observation Log for SIT and UAT, Closure Report for SIT and UAT.

Consolidation of user requirement for the usability of KPIs and Reports for concerned departments

Analyzing and Consulting the client on Logical and Functional use of Reports and KPIs and the data to be displayed

Developed style-guide to be used across all reports and KPIs

Developed SQL tables for organizing the data for respective reports and KPIs

Developed DMR or Relational Model, as per the requirement, in Cognos Framework Manager

Developed various kinds of Charts( Line, Bar, Pie, Progressive, Gauge etc.) and reports (List, Crosstab) compliant to style-guide in Cognos Report Studio

Developed Tab-Page to display each KPI in tab-form and all reports in one tab for respective departments

Developed Dashboard to be used as the first page which showed all KPIs

Development and modification of Packages and models on SAP BEx Queries in Cognos Framework Manager

Researched and resolved various technical challenges in SAP-Cognos integration

Led Business Readiness Review, Product Delivery Review, Code Delivery Review and Test Readiness Review with Testing Team

Led System Integration Test(SIT) and User Acceptance Test(UAT) of Cognos Reports and KPIs with the Client

Deployed the Reports and KPIs in Quality Analysis Environment(QA Environment) and Production

Closure of severity-1 issues at the time of SIT which was acknowledged by the client. Closure of all the other observation on or before proposed time.

Presented and suggested the client on the modifications which can be applied for better usability

Educating the client on the use of reports and KPIs and on the maintenance of data

Consulting with client over the logic and functional rechange

Led couple of modules like Manual( Flat-File Data source) and SAP-Cognos Integration for departments like Security, CSR, Human Resource, Quality Management

Delivered Human Resource and Quality Management KPIs and reports before time which was acknowledged by Delivery Head and Project Manager

Gained Hands-on experience on SAP BI.

Part of taking interviews for the project

Organizing of events for the team

Industry – IT (Project – Cognos Service Factory)

Developed reports in Cognos 8 Report Studio reports using client's specifications.

Created various query calculations, filters, logical statements to get the desired data in the report.

Analysed existing requirements and consolidated the reports for effective and efficient reporting.

Analysed Framework Manager Packages to build the reports.

Analysed and validated various complex report which were already developed

Edited the database view for the report development

Improved the efficiency of various complex reports to approx. 50% which were already developed by the client.

Migrated reports from cognos 8.3 to cognos 8.4

Maintained Unit Test Plan, technical Specification & Release Note. Performed review activity for client deliverables.

Attend Daily Status call and interacted with Client

Was Quality Analyser for the team and helped the team to deliver 0 defect reports to the client.

Industry – Insurance

Redeveloped Cognos Series 7 Impromptu reports in Cognos 8 BI Report Studio.

Analysed XML, SQL code from Impromptu report to develop reports in Report Studio.

Redeveloped Cognos 7 Transformer Models to Cognos 8 Transformer Models. And checked the scope of each data source in the model

Involved in Unit Testing and documented all test cases

@ Accenture

Industry – Health Care

Migrated Cognos Series 7 Impromptu reports to Cognos 8 BI Report Studio.

Analysed FM Model to explore the joins and tables and to understand the model structure for getting enough expertise to complete the report development.

Analysed XML, SQL code from Impromptu report to develop reports in Report Studio.

Developed Complex & Freestyle Reports

Involved in Unit Testing.

Industry – Automobile (Client Location)

Developed Complex/Free style/Invoice reports in Report Studio in this migration project from Series 7 to C8.

Migrated Series7 Transformer Model to Cognos8 Transformer Model.

I have analysed xml built from the migration utility to build the C8 reports.

Calculations in Transformer Model and Package Publishing.

Developed reports in Report Studio include list reports, Drill through reports, cross tab reports with conditional formatting.

Application of different functionalities like filters, Value prompt, Date prompt, Text Box prompt, Cascading Prompts to retrieve relevant data.

Incorporated Page breaks and Conditional blocks as per the client specification.

Performance tuning of reports using sub queries, master-detail relationship, by changing the properties of the Query such as Auto Group & Summarize, Processing, Execution Method and Use Parameter Info.

Maintained Unit Test Plan, technical Specification & Release Note. Performed review activity for client deliverables.

Accomplishments & Interests

Star of the Month Award given by the client in 2012-13.

Recognition for delivering 2 modules before time in 2012-13

Rewarded for quick delivery of given task and quick understanding in 2010-11

Organizer of various events in the team

Participated in various events in the organization like dance, fashion show etc.

House-Captain and Prefect at Under-Grad Level

Basket-Ball Captain in inter-House Competition

Won various certificates for different sports in senior school like Basketball, cricket, Relay Race

Contact this candidate