Post Job Free

Resume

Sign in

IBM Cognos certified

Location:
Trenton, NJ
Posted:
September 09, 2016

Contact this candidate

Resume:

Mahesh Dani

Mobile # 973-***-**** e-Mail: acwjkd@r.postjobfree.com

SUMMARY

Certified IBM Cognos BI Designer with over 10 years of experience in the area of Framework Manager, Query Studio, Report Studio and Cognos Connection.

Excellent working knowledge in development, designing, Administration and deployment of Data Warehousing and Business Intelligence applications using COGNOS Suite 7/ 8/ 10.x.x and Cognos Report Net.

Capable Qlikview Developer with a proven record of corporate client satisfaction. Adept at handling multiple projects simultaneously. Able to adapt work approach quickly in response to evolving client needs.

Developed cubes with iqd's and have strong knowledge with Power play Transformer model design and Power play cube building and Power play reports.

Strong experience in Installing, Configuring, Monitoring and Management of Cognos on Windows platform.

Expertise in Framework Manager Modeling (Database Layer,Physical Layer, Business Layer) and creating Packages and Complex Report building with Report Studio.

Strong Experience in developing Business models and publishing packages using Framework Manager along with Cognos Connection in Cognos 10/8 and Report Net1.x.

Customized Reports and created portals using HTML and JAVA SCRIPTS.

Expertise in OLTP/OLAP system study, analysis, E-R Modeling and developing Database schemas like Star Schema and Snowflake Schema.

Developed and successfully deployed multiple initiatives with Executive Dashboards with charts and reports with easy navigation into subsequent reports by drill down feature.

Extensively worked on Data Extraction with Oracle (8i, 9i and 10g), SQL Server & MS-Access.

Experience in Deployment (Export, Import) using Framework Manager into Cognos Connection.

Implemented Security at different levels in Framework Manager and Cognos Connection to restrict access.

Expertise in version up gradations of Cognos suite such as Cognos 7.3 and Migrating Report Net reports and Impromptu into Cognos 8 BI.

Extensive one to one interaction with end users/Business analysts to identify their needs and wants, then translate the functional requirement into reporting requirements, design and business data flow.

Migrated the Framework Manager Models and reports from Cognos Report Net to Cognos8 BI.

Designed the Transformer model and built the cubes using Power Play Transformer, explored the Cube data using the Report and Analysis Studio.

Expert in all stages of Software development life cycle (SDLC) which includes requirement analysis, design, development, testing and documentation.

Strong troubleshooting and production support skills and coordination/ interaction abilities with end users.

Self-motivated and enjoy working in a technically challenging environment.

Possess excellent communication and interpersonal skills.

Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Actively involved in Change Management process for deployment approvals.

Provided Cognos training to Business Users.

TECHNICAL PROFICIENCIES:

Business Intelligence Tools

Qlikview 11,Cognos 10 & 8 Framework Manager, Report Studio, Query studio, Analysis Studio, Event Studio, Report Net 1.1(MR1/MR2), Cognos Connection, Cognos Impromptu Administrator, Impromptu User, Impromptu Web Reports, Cognos Power Play Transformer 7.x.

ETL Tools

Informatica, Datastage 8.7.

Databases

ORACLE 7.x /8i, 9i, 10g, DB2, MS SQL Server 2000, 2005 and MS Access.

Data Modeling Tool

Erwin 4.1, Transformer and Frame Work Manager.

Programming Languages

C, C++, SQL, PL/SQL.

GUI

Visual Basic 6.0, Toad, HTML.

Operating Systems

Windows 95/98/2000/2003/XP/2008 and UNIX.

Software Packages

MS-Office, Microsoft Word, Excel and Power Point.

CERTIFICATIONS:

IBM Certified Developer - Cognos 10 BI Metadata Models

IBM Certified Developer - Cognos 10 BI OLAP Models

IBM Certified Designer - Cognos 10 BI Reports

IBM Certified Designer - Cognos 8 BI Reports

PROFESSIONAL EXPERIENCE:

Bank of America - as Consultant Cognos Developer from Oct 2015 till date

Mphasis – as Module Lead from July-2007 till Oct-2015.

TechMahindra – Software Engineer from Sep -2006 till Jun-2007.

Keane India Ltd – Software Engineer from Jan-2006 till Aug-2006.

Project # 10

Project Title

OpLoss (Operational Losses)

Client

Bank of America

Role

Cognos Developer

Duration

Oct 2015 - Till Date

Project Description:

Project Objective is to Design and deploy a system with ability to capture, track, monitor and report operational losses, and support accurate, complete and timely reporting .This will facilitate the identification of Operational Loss drivers to better manage risks. It acts as single repository that enables continuous capturing and reporting of operational losses in a manner consistent with the loss impact on the books and records of Bank of America.

Responsibilities:

Currently performing Cognos Consultant role in Bank of America using Cognos 10.2.2 suit.

Developed and Support various Complex report types ranging from simple Lists, Cross-tabs, Charts by using different Functionalities like drill-through, Master-detail, conditional formatting, Multiple Prompts, Cascading Prompts, Conditional blocks Filters, multi-page, multi-query reports, Multi-tab reports using Java/HTML scripts, Dashboards, Drill up/Drill down .

Created Cube using Transformer and did incremental cube and cube Full build using xml’s scripts.

Worked on creating User groups in SIT and in UAT and provide user access to folders and reports.

Created Dashboard and portal using HTML for easily access of reports, cubes, ad-hoc report (created by Business users and client).

Created database layer by defining appropriate relationship between query subjects and Logical layer, DMR layer and business layer in Framework Manager.

Task management, coordinating with QA for testing activities, Co-coordinating with users for UAT and other teams like Cognos Admin, Database.

Lead the Cognos Framework Design, Development and Review of New and would-be development.

Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and Business logic underlying the requirement.

Review architecture and come up with solution for any performance/technical concerns.

Serve as SME (Subject Matter Expert) for technical issues on Cognos BI Platform.

Collected and Managed Business Requirements for creating the Cognos reports & cubes.

Worked extensively on Dashboards and portals.

Documentation of development and enhancement activities in functional and technical perspective.

Preparing analysis documents and submitting to client for code change.

Environment: Cognos Series 10.2, Oracle, Quality Center 11,Nexus 5, PVCS .

Project # 9

Project Title

BIR (Business Intelligence Reports)

Client

AIG

Role

Module Lead

Duration

Jul 2013 - Till Date

Project Description:

AIG has a number of different booking and processing systems worldwide to support the business. Its Home Office management receives premium & loss information through the only consistent method of collecting detail data on a worldwide basis, the Overseas General Insurance System (OGIS).

Global Portfolio Management (GPM) System also known as OGIS-EIS (Overseas General Insurance System - Executive Information System) is a new analytical reporting tool. The information is viewed in different formats such as Cubes, Dashboards and Reports. Users can generate required reports using different dimensions and measures. Implemented Drilldown/Drill up capability in dashboard. This helps business management to manage portfolios effectively.

Responsibilities:

Currently performing Lead/onsite coordinator role in Business Intelligence using QlikView/Cognos .

Reloading Qlikview report and publishing to server.

Developed and Support various Complex report types ranging from simple Lists, Cross-tabs, Charts by using different Functionalities like drill-through, Master-detail, conditional formatting, Multiple Prompts, Cascading Prompts, Conditional blocks Filters, multi-page, multi-query reports, Multi-tab reports using Java/HTML scripts, Dashboards, Drill up/Drill down .

Created Dashboard and portal using HTML for easily access of reports, cubes, ad-hoc report (created by Business users and client).

Created database layer by defining appropriate relationship between query subjects and Logical layer, DMR layer and business layer in Framework Manager.

Working closely with Cognos Admin team for deployment of Packages and Cognos reports.

Worked on Audit package which will trace each and every report executed by Users.

Working closely with Business Analyst and business users in requirement gathering, creation of FSD and TSD.

Effectively prioritize the tasks and assigning to the team members in a high-pressure business environment to meet tight deadlines expectations.

Task management, coordinating with QA for testing activities, Co-coordinating with users for UAT and other teams like Admin, Database.

Weekly status calls with Client and forecast analysis for future project tasks.

Lead the Cognos Framework Design, Development and Review of New and would-be development.

Develop and continuously improve BI practices within the organization.

Interacted with the Business users and documented their Query, Business and Reporting needs and Analyzed the data and Business logic underlying the requirement.

Train members and business users with Cognos.

Review architecture and come up with solution for any performance/technical concerns.

Serve as SME (Subject Matter Expert) for technical issues on Cognos BI Platform.

Setting up user access on data and user group within Cognos environment.

Collected and Managed Business Requirements for creating the Cognos reports & cubes.

Worked extensively on Dashboards and portals.

Documentation of development and enhancement activities in functional and technical perspective.

Preparing analysis documents and submitting to client for code change.

Environment: Cognos Series 7, 8.2 & 10.2, Qlikview 11, SQL Server, Oracle, Service Now, PVCS .

Project # 8

Project Title

Rate & AQI Monitoring Report

Client

AIG

Role

Module Lead

Duration

Aug 2014 - Till Date

Project Description:

Business is currently receiving Rate/Exposure Change information for different product lines (Property, Casualty, Financial Lines and Specialty) in excel sheets and is consolidating the data manually to produce the Rate Change reports " dashboards in excel (pivots). The reports are then distributed via email. Now this project is to reduce the manual intervention in consolidating and creating the dashboards as well as making it available online for easy access. Also provide an Analytic platform to the end users to create their own charts and reports.

Responsibilities:

Sound ability to interact with end users and craft clear technical requirements from business language

Excellent ability to translate client requirements into effective solutions in QlikView Applications.

Understanding source systems and customer requirements.

Creating and Managing Qlikview Reports Dashboards.

Publishing and Deploying the Dashboards based on business requirements.

Developing Set Analysis to provide the custom functionality in QlikView Applications.

Testing Applications, reports using review checklists, Data quality for quality assurance before delivering to the end users.

Reloading Qlikview report and publishing to server.

Created different Reports based on user requirements for business decision making.

Environment: Qlikview 11

Project # 7

Project Title

American International Underwriters (AIU)

Client

AIG

Role

Module Lead

Duration

Aug 2011 - Jun 2013

Project Description:

American International Underwriters has a number of different reporting systems worldwide to support the business. AIU data is spread over a wide range of applications and databases, with similar data being held in different formats. The current Management Reporting System application on Mainframe will be replaced by Chartis Management Reporting Cognos application to generate the Accounting and Management reports.

Responsibilities:

Analyze business needs and translate them into technical specs and maintain the information flow in the team.

Working closely with Business Analyst in requirement gathering, creation of FSD and TSD.

Reviewing the code and giving coding guidelines .

Loading data into Database using SSIS tool.

Extensively worked on Framework manager.

Effectively prioritize the tasks and assigning to the team members in a high-pressure business environment to meet tight deadlines.

Task management, coordinating with QA for testing activities, Co coordinating with users for UAT and other teams like Admin, Database.

Weekly status calls with Client and forecast analysis for future project tasks.

Documentation of development and enhancement activities in functional and technical perspective.

Trained Fresher on Cognos Tool.

Environment: Cognos 8.2/8.4, SSIS, SQL,Java

Project :6

Project Title

VCPS(Vehicle Content and Price System)

Client

General Motors(GM)

Role

Sr. Cognos Developer

Duration

Nov 2010 - July 2011

Project Description:

VCPS(Vehicle Content and Price System) is a global, cross functional tool with requirements to support Marketing, Order Fulfillment and Finance. The application allows users to create Market offers for different region, validate these Market Offers and analyze these details by generating various reports.

Responsibilities :

Analyze business needs and translate them into technical specs and maintain the information flow in the team.

Deployment of Reports and Package from one environment to other environment.

Worked closely with Team members in resolving Issues.

Working closely with Business Analyst in requirement gathering, creation of FSD and TSD.

Effectively prioritize the tasks and assigning to the team members in a high-pressure business environment to meet tight deadlines.

Task management, coordinating with QA for testing activities, Co coordinating with users for UAT and other teams like Admin, Database.

Daily status calls with Client and forecast analysis for future project tasks.

Working closely with Change Control management/ Release management activities and post release activities.

Documentation of development and enhancement activities in functional and technical perspective.

Environment: Cognos 8.2, SQL,Java

Project :5

Project Title

IFC (International Finance Corporation)

Client

World Bank

Role

Sr. Cognos Developer

Duration

May 2008 - Oct 2010

Project Description:

IFC (International Finance Corporation), a member of the World Bank Group, is a global investor and advisor committed to promoting sustainable projects in its developing member countries that are economically beneficial, financially and commercially sound, and environmentally and socially sustainable. Provide advice and technical assistance to businesses and governments.

This project contains more than 10 Application in Cognos which are widely divided into MIS and Non-MIS.I am the primary SPOC for Non-MIS applications like FMS(Fund Management System), TAAS (Technical Assistance and Advisory Services), AS (Advisory Systems),AML(Anti Money Laundering).

Responsibilities:

Used Framework Manager, Report Studio, Query Studio for Report design in Cognos BI version 8.2/8.4.

Expertise with Framework Manager in building models and publishing packages and reporting.

Expertise in implementing durable Layered Structure of the model taking Data Layer, Model Layer and Presentation Layer, and Implemented the changes made to the database into the Layered structure of the model by re importing query subjects in the Data Layer and remapping query subjects in the presentation layer.

Performed update object on the model query subjects for every change made to the entities in the database and remapped Query items and verify model functionalities.

Created packages combining data from multiple data sources using Framework Manager.

Synchronized objects based on the previously saved model and implement the newly added features to the model

Development of filters, calculations, and prompts, conditions, created various reports such as Simple List, Cross Tab, and Charts using Cognos Report Studio.

Responsible for the delivery of solution-oriented complex reports using Cognos* Report Studio.

Extensively used cascading prompts, drill-through, sub-reports, summaries, master detail reports, conditional formats, grouping and association features to generate efficient Crosstab and List reports reports.

Added JavaScript actionable items and HTML items on the reports.

Involved in the Cognos Administration using Cognos Connection for Data source creation, security implementation, scheduling and distributing reports and performance tuning.

Validating/Testing of the reports against database.

Addressing user queries/Issues and production issues. Work closely with other teams to get the information and resolve any issues reported.

Environment: Cognos 8.2 / 8.4,Toad, Windows Vista,Remedy,JIRA

Project :4

Project Title

Tyco Managed Maintenance

Client

Type Electronics

Role

Sr. Cognos Developer

Duration

July 2007 - April 2008

Project Description:

The Information Delivery Systems team develops, maintains, and supports Business Intelligence reporting and content driven solutions. These Business Intelligence Solutions summarize the transactional level information which is sent to the Data Warehouse (e.g., Sales, Purchasing, Inventory, Accounts Receivable), and combines it with Master data, to provide a view of the information that is meaningful and relevant to our business users.

This information is then made available via a set of Business Intelligence tools:

1. Analytical reporting via Cognos Analysis Studio

2. Standard batch reporting via Cognos Impromptu Web Reports (IWR)

3. Ad-hoc reporting via Cognos Impromptu.

Responsibilities:

Publishing reports to Upfront.

Manually running of IWR Reports in IWR Production.

Editing Catalogs like adding Columns, adding Folders as per the Business User Requirement.

Migration from Cognos 7.3 to Cognos 7.4.

Giving access to users for accessing the IWR reports.

Supporting for Business End Users in Cognos Impromptu (Upfront).

Environment: Cognos Impromptu 7.4, TWS, Toad, Windows 2000

Project:3

Project Title

Compucom

Client

Compucom

Role

Developer

Duration

Sep 2006 - June 2007

Project Description:

CompuCom Systems is a leading IT managed services provider that helps organizations maximize resources and achieve continuous improvement. Our unique Integrated Infrastructure Management TM (IIM) solution, coupled with our consulting and application services, enables clients to advance the effectiveness of their technology infrastructures, while driving down costs, improving quality, and expanding the e business value they derive from IT.

Responsibilities:

Analysis of the specifications provided by the clients.

Involved in client interaction to analyze the problems and to rectify them.

Created multidimensional models from multiple data sources using Transformer.

Imported the ‘IQD' files provided by the client created in FM into Transformer to construct a power cube.

Defined, created, published and maintained cubes using Powerplay Transformer.

Created reports in Powerplay.

Involved in Created FM Models.

Published Packages.

Involved in Created Reports in Report Studio using various prompts & condition blocks.

Environment: Cognos Impromptu7.3, Power play Transformer, Power play, Report Net 1.1, Cognos8, Brio, Win 2000, Toad.

Project:2

Project Title

Schneider Electrics North America (SENA)

Client

Schneider Electrics

Role

Developer

Duration

May 2006 - Sep 2006

Project Description:

Schneider Electric is a world-leading provider of innovative solutions for electrical distribution, industrial control and automation. For over 160 years, Schneider has successfully met many challenges through bold innovations and strategic business decisions. Schneider Electric's unique history delivers the power of the Modicon, Square D, Telemecanique and Merlin Gerin brands. These brands are responsible for innovations that include Square D's invention of the safety switch in 1915, Telemecanique's invention of the electrical

contractor in 1924, Modicon's invention of the PLC in 1969 and Merlin Gerin's invention of the

Multi-Nine circuit breaker in 1970. Today, Schneider's history of innovation continues. In This project we have given the North American Region .Hence, we have named it as SENA (Schneider Electric North America).

Responsibilities:

Creation of reports according to client requirement.

Involved in loading reports to Upfront.

Monthly and Weekly cube build.

Doing Production Support for Cognos..

Environment: Cognos Impromptu, Powerplay Transformer, Powerplay, Brio, Win 2000, Toad.

Project: 1

Project Title

BESTWESTERN INTERNATIONAL

Client

BESTWESTERN INTERNATIONAL

Role

Developer

Duration

Jan 2006 - April 2006

Project Description:

Based in Phoenix, Arizona, BWI is organized as a not-for-profit association. Unlike other hotel brands, BWI operates on a membership basis, with more than 4,100 independently owned and operated member hotels.

Responsibilities:

As a Team member

Creation of Reports in Cognos according to the client requirement.

Creation of Reports in SQR according to client requirement

Created List Reports, Group Reports and Cross Tab Reports with Drill Through and Drill Down functionalities.

Created Cubes using Powerplay Transformer for multidimensional (IQD) reports.

Communication with Client for knowing their Problems.

I had the responsibility of technical communication with the client includes, team skill and knowledge sharing.

Environment: Cognos Impromptu,PowerPlay Transformer,PowerPlay,Win XP,Oracle 8i .



Contact this candidate