Manager Project

Vijay D Hegde

B-*** Admiralty Square, *th Main **th Cross, Indiranagar 2nd Stage, Bangalore - 560038

Mobile No: +91-900**-*****; Mail ID: *******@*******.***

A Commerce Graduate from Mumbai University and PGDBA from Symbiosis in Finance having total IT Experience of 11 years of which 8 years of experience in BI/DWH using Cognos BI Series 7/7.3, 8.4, 10.1.1, Hummingbird Genio ETL 4.7, Sybase, MYSQL. The scope of which includes documenting business requirement into Technical specifications, Design, Development and Implementation of work products using Cognos BI Series 7/7.3, 8.4, 10.1.1 tools.

COMPETENCY

All phases of Software Development Life Cycle (SDLC) including Client interaction, Requirement analysis & Feasibility study, Functional & Technical Documentation, Report/ Model development & Testing, Implementation and Maintenance.

Execute business requirements in a COGNOS environment, insuring data security, user friendly reports with "drill-through" features.

Communicating report development progress and issues to management.

Verify correctness and completeness of data model, data relationships, mappings, and definition.

Hands-on experience & expertise on Cognos BI Series 7/7.3 (Impromptu, Powerplay, Transformer, Power prompts, Scripting), Hummingbird Genio ETL 4.7, Sybase 12.5

Hands-on Experience in Cognos BI 8.4/10.1.1 (Framework Manager, Report Studio, Transformer, Query Studio, Analysis Studio, Lifecycle Manager).

Certified in Cognos BI 8 Metadata Models (Framework Manager), Report Author and Administrator.

ACADEMIC QUALIFICATION

Degree Name of Institute Board / University Year of Passing Percentage

PGDBA (Finance) Symbiosis, Pune Symbiosis, Pune 2007 61%

B.Com R.K.Talreja College Mumbai University 1998 74%

CERTIFICATION AND TRAINING

Trained in Cognos Enterprise Planning at Reiteach Oct-2006, Dublin, Ireland.

Trained in Business Object XRI2 and Informatica 8.6.1 at Accenture, Bangalore in 2009.

IBM Certified Developer Cognos 8 BI Metadata Models, Bangalore in 2010.

IBM Certified Cognos 8 BI Author, Bangalore in 2010.

IBM Certified Cognos 8 BI Administrator, Bangalore in 2010.

PROFESSIONAL ACHIEVEMENT

Received SPOT Award from Mphasis as recognition for my contribution to the EDSAT Project.

Received Award from IBM as recognition for my contribution to CHP and ABIS project.

PROFESSIONAL EXPERIENCE

Organization Designation Duration

NETAPP MTS4 (Project Leader) 09/May/20011 todate

IBM Sr. Consultant 06/Nov/2009 to 05/May/2011

Accenture Associate Manager 06/May/2009 to 04/Nov/2009

Mphasis an HP Company Project Leader 08/Apr/2005 to 04/May/2009

Hexaware Technologies Ltd. Sr. Software Engineer 29/Dec/2003 to 01/Apr/2005

TATA-AIG General Insurance Co. Programmer Analyst 28/Jan/2002 To 26/Dec/2003

Moneyman Software Senior Programmer 15/Oct/2000 To 25/Jan/2002

TECHNICAL SKILLS

Skills Work Experience Technology Awareness

Operating Systems Win 2K, Win NT, Win 95/98, DOS

Web Servers Internet Information Server

Application Servers MTS

Microsoft Technologies Visual Studio 6.0 (VB, ADO, ActiveX, ASP) Visual Sutdio.NET (VB.NET, C#, ASP.NET, ADO.NET)

Languages HTML, VBScript, XML, PL-SQL, T-SQL COM+, C, C++

Business Intelligence & Reporting Tools Cognos Series 7/ 7.3, Cognos BI 8.4, Cognos 10.1.1, Crystal Reports 8.5, Docucorp International 10.1 Business Object XIR2

Databases Oracle 8i, Sybase, SQL Server, Ms Access, MYSQL

ETL Tool Hummingbird GENIO 4.7 Informatica 8.6.1

Version Control Systems Project Version Control System (PVCS)

Special Methodologies or Technologies Rational Clear Quest

Domain Knowledge Banking & Insurance Storage

Planning Tool Cognos Planning 7.0

Management Tool Microsoft Project Plan

Agile Tool Rally

PROJECT PROFILE

Project Name OnCommand Insight Report (OCIR)

Client NetApp

Location Bangalore, India

Role Project Leader

Organization NetApp India

Period May 2011 to till date

Team Size Project : 14

Environment Software Language

Database

Tools

O/s SQL

MYSQL 5.4

Cognos 8.4/10.1.1 BI (Framework Manager, Report Studio, Query Studio, Transformer, LCM, Business Insight, Business Insight Advance)

Windows XP

Project Description

OnCommand Insight Report provides comprehensive reporting solution for entire NetApp storage

Infrastructure managed by NetApp manageability products.

The release drivers are:

Reporting infrastructure leveraging SANscreen DWH solution

Consolidation of data from multiple Operations Manager servers

Inventory, Health and Capacity data marts – Reports and dashboard

Task & Responsibility

Interacting with offshore Product Managers to understand OCIR requirements.

Leading the entire Offshore Reporting Team by providing technical support.

Demo the Cognos Framework Manager Model with onsite Modeler and discuss the logic implemented in the mode, issues and concerns.

Technical Contribution

Develop the reporting Model using Cognos Framework Manager for custom reporting which provides the customer the flexibility to design there own reports.

Design reports in Query Studio which allows the customer to modify the report as per there requirement.

Create Dashboard style reports using Cognos Viewer, Business Insight.

Give the reporting the “WOW” effect by customizing the login screen, providing themes to the report and designing graph using 3rd party tools like FushionCharts.

Developed single Cubes from multiple Data Marts for easy data access and analysis.

Rebranding of Cognos as per NetApp standards.

Unit Testing report using Cognos Lifecycle Manager.

Project Name ABIS (Accredo Business Intelligence System)

Client Accredo an Medco Co

Location Bangalore, India

Role Project Leader

Organization IBM India Ltd.

Period April 2010 to till date

Team Size Project : 7

Environment Software Language

Database

Tools

O/s SQL

Oracle 10g

Cognos 8.4 BI (Framework Manager, Report Studio), Ab Initio

Windows XP

Project Description

Accredo Business Intelligence System (ABIS) will be a comprehensive data management platform that will support analysis and reporting for all functional areas of Accredo. ABIS will empower users by giving them direct access to information they can use to make better decisions, create more effective plans, and respond more quickly to problems and opportunities.

Task & Responsibility

Interacting with onshore Business Analyst to understand Accredo’s Business Reporting requirements.

Guiding team in understanding the requirement and building the mock up reports using Cognos Report Studio 8.4

Incorporating changes as suggested by Business Analyst on delivered Mock up Reports.

Working closely with offshore Project Manager to design the project plan for reporting, updating development status, project and resource issues and recruitment of new resources for the project.

Technical Contribution

Technical guiding the reporting team in developing dash board reports which has Chart based report like Pie Chart, Bar Graph, Line Graph, List Report and Cross Tab reports.

Sharing and understand logic to implement dynamic based graph based on selected measure/s and dimension.

Implemented drill down report when user select the measure in the bar graph or one slice of the pie chart.

Used Render variable to hide and unhide graph or list report based on prompt selection.

Implemented Cascading prompt.

Implemented manual legend which will display only those measures that were selected by the user in the prompt screen for chart based report.

Designing Relational Model in Framework Manager.

Project Name CHP (Consumer Health Product)

Client Medco

Location Bangalore, India

Role Project Leader

Organization IBM India Ltd.

Period Nov 2009 to Feb 2010

Team Size Project : 7

Environment Software Language

Database

Tools

O/s SQL

Oracle 10g

Cognos 8.4 BI (Framework Manager, Report Studio)

Windows XP

Project Description

Consumer Health Product is a Reporting based solution which comprises of 11 Reports developed in Cognos 8.4 for Finance, Sales and Operation Department of Medco. These are graph based report showing e-commerce business information like comparison of Fullfillment Cost Vs Cost of Goods Sold, Gross Revenue, Net Revenue, Gross Margin, Product Margin and Contribution Margin, Comparison in terms of Revenue and Quantity order for New Repeat Customer, Cumulative Customer Quantity and Revenue, Visitors Conversion who has visited CHP site, Opened Cart and Placed Order, Phone Orders and Revenue Shipment of Orders etc.

Task & Responsibility

Design High Level Design Document.

Design and Develop Dimension Model in Framework Manager for Reporting.

Design and Develop Reports in Report Studio (Chart Reports, List Reports).

Lead Reporting Team in developing the report, making team understand reporting requirement.

Interacting with onshore Tech Lead with respect to technical aspect of the report and model.

Interacting with onshore Project Manager with respect to requirement understanding.

Technical Contribution

Implementation of java script to display glossary as tool tip in the report.

Used Render variable to hide and unhide graph or list report based on prompt selection.

Resolved loops issues in framework manager by creating shortcut of query subjects.

Design Relational Model in Framework Manager.

Project Name EDSAT (European Decision Support and Analysis Tool)

Client AIG Europe

Location Bangalore, India

Role Project Leader cum Offshore Coordinator

Organization Mphasis an EDS Company

Period Feb 2008 – May 2010

Team Size Project : 11

Environment Software Language

Database

Tools

O/s T-SQL

Sybase

Cognos BI Series 7.0/7.3, GENIO 4.7

Windows XP, Windows 2000 Server

Project Description

The goal of EDSAT project is to build a robust data warehousing system and a Management Information System using Cognos suite of products.

It will provide business users with access to up to date Insurance Information for decision making and analysis of the performance of business in various streams of insurance.

Task & Responsibility

Worked as Project Leader and was leading the team of 10 resources.

Project Planning and Estimation for new Development and Enhancement.

Managing all the ETL and Reporting/OLAP Requirement with respect to General Insurance like Claims Reporting (Claims Lifecycle Report, Productivity Report, Client Account Report based on Dun & Bradstreet Number, Payments, Recoveries, Expenses, Reserves, Open and Close Claim, GLI, NLI based Reports), Policy/Premium based Reporting (GPW, NPW, Reinsurance, UEPR), Quotation based Reports.

Review of Business Requirements Document from a techno-functional perspective.

Conduct meetings with business analysts and end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort.

Providing Knowledge Transition to team on EDSAT for offshore development and production support.

Technically guiding the team on Cognos and Genio ETL.

Offshore coordinator for Development Activity.

Updating onsite PM about current project progress, resource allocation plan, issues.

Attending BI-Weekly Call with Senior Onsite and Offshore Managers to update about development project, any issues related to offshore connectivity.

Responsible for designing multi-dimension modeling for cubes, designing flow of report and prompts, ETL transformation and mapping.

Technical Contribution

Developed Alternate Dimension based Cubes.

Provided Currency Conversion functionality.

Provided Measure level drill-through reports.

Provided pre-canned reports which were developed out of power cube and later deployed in Cognos Upfront by integrating with ASP Page (prompt driven).

Provided more than 1 drill-through report at cube level to generate the report for different currency.

Developed and published impromptu this was driven by Power prompt for dynamic prompt.

Developed Cognos Script to generate email based reports for country wise users distribution.

Written ETL scripts and transformation logic to load the data from OLTP to OLAP DB (Dimension and Fact tables).

Project Name EDSAT (European Decision Support and Analysis Tool)

Client AIG Europe

Location Dublin, Ireland

Role Sr. Cognos Developer/ Consultant

Organization Mphasis

Period Apr 2005 – Jan 2008

Team Size Project : 10

Environment Software Language

Database

Tools

O/s T-SQL

Sybase

Cognos BI Series 7.0, GENIO 4.7

Windows XP, Windows 2000 Server

Project Description

The goal of EDSAT project is to build a robust data warehousing system and a Management Information System using Cognos suite of products.

It will provide business users with access to up to date Insurance Information for decision making and analysis of the performance of business in various streams of insurance.

Task & Responsibility

Production Support involve daily checking of ETL Logs, Cube Build, receipt of file from different systems, preparing reconciliation excel sheet showing discrepancy with reasons between OLTP and DWH.

Design & Development of data model, data relationships, mappings, and definition, Cubes, ETL to meet the Business Requirement Document for new developments.

Communicating with Business Analyst and European End-user.

Supervising & mentoring other team member.

Technical Contribution

Developed Alternate Dimension based Cubes.

Provided Currency Conversion functionality.

Provided pre-canned reports which were developed out of power cube and later deployed in Cognos Upfront by integrating with ASP Page (prompt driven).

Provided more than 1 drill-through report at cube level to generate the report for different currency.

Developed and Published Impromptu which was driven by Power prompt for dynamic prompt and dynamically removing the columns, sorting from report.

Developed Stored Procedure based Impromptu Reports.

Developed Cognos Script to generate email based reports for country wise user’s distribution.

Written ETL scripts using Genio ETL and transformation logic to load the data from OLTP to OLAP DB (Dimension and Fact tables).

Project Name Claims Toolkit Reports (EDSAT)

Client AIG Europe

Location Dublin, Ireland

Role Sr. Cognos Developer/ Consultant

Organization Mphasis Software Solution

Period Jan 2006 – Dec 2006

Team Size Project : 3

Environment Software Language

Database

Tools

O/s T-SQL

Sybase

Cognos BI Series 7.0, GENIO ETL

Windows XP, Window 2000 Server

Project Description

Enable benchmarking and control of claim expenses by country / region and profit centre supporting improvement initiatives by local and regional claims management.

Enable reporting of paid indemnities facilitating measurement against a cost per claim benchmarks.

Identify old claims and focus examiners / management on clearance of same.

Establish capacity and productivity models to monitor workloads and clearance rates at an examiner / administrators level both locally and regionally.

Task & Responsibility

Review of Business Requirements Document from a technical perspective.

Conduct meetings with business analysts and end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort.

Designed de-normalized and summary tables to enhance reporting performance.

Extraction, Transformation & Loading of Data from Production Database

Designed Power Play Cubes & Reports to provide summarized results by measures and dimensions.

The new system provides claims management with greater flexibility in identifying potential issues and managing workflow processes more efficiently. It also enables claims technicians to monitor their file review performance by accessing monthly and year-to-date review scores.

Technical Contribution

Provided Currency Conversion functionality.

Provided pre-canned reports which were developed out of power cube and later deployed in Cognos Upfront by integrating with ASP Page (prompt driven).

Provided more than 1 drill-through report at cube level to generate the report for different currency.

Developed and Published Impromptu which was driven by Power prompt for dynamic prompt.

Developed Cognos Script to generate email based reports for country wise user’s distribution.

Written ETL scripts and transformation logic to load the data from OLTP to OLAP DB (Dimension and Fact tables).

Project Name SAS-CMR

Client Scandinavian Airlines

Location Mumbai

Role Coding

Organization Hexaware Technologies Ltd.

Period Dec 2003 – Apr 2005

Team Size Project : 12 Module : 1

Environment Software Language

Database

Tools

O/s PL-SQL, VB

SQL Server 2000

Cognos Impromptu Series 7.0

Windows 2000

Project Description

Existing Scandinavian Airlines systems had multiple in-house applications of different types. The applications were Mainframe Applications (Using Hierarchical & Relational Databases), Excel Applications, SQL Applications. The scope of the project was

Understanding and documenting the existing applications.

Designing the table structure in CMR database corresponding to the in-house applications.

Migration of data from the old system to CMR.

Generation of reports using Cognos Impromptu 7.0.

Creating the interface files for different applications using MS SQL 2000.

Creation of advanced VB applications for automated execution of the different jobs in CMR.

Creation of Maintenance Screens using VB.

Task & Responsibility

Migration from ASP, Mainframe Reports to Cognos Impromptu Series 7.

Setting up and configuration of Impromptu Web Server, publishing of Impromptu Reports

User Access Rights using Access Manager on the Impromptu Web Server.

Development of VB application for maintenance screens & emailing of Impromptu Reports to the users.

Technical Contribution

Developed Conditional Format based report (hide-show)

Extensively worked on UDF by creating Functions in SQL Server and calling them in Cognos Impromptu.

Worked in Impromptu based prompts (Picklist, Type-in).

Developed Stored Procedure based Impromptu Reports.

Project Name Strategic Suite of Systems (S3)

Client TATA-AIG General Insurance Co. (MEMSA Region)

Location Mumbai

Role Analyzing & Coding

Organization TATA-AIG General Insurance Co.

Period Jan 2002 – Dec 2003

Team Size Project : 25 Module : 2

Environment Software Language

Database

Tools

O/s Visual Basic 6.0, XML

Sybase, SQL Server 2000

Docucorp International 10.1, Ms Access, IBM MQ-Series 5.1, Crystal Report 8.5, Cognos 6.6, Genio ETL 4.0

Win NT

Project Description

S3 is a true client server based application which uses distributed processing and runs across multiple disparate operating systems. It is used for the Insurance Business and the Financial Accounting implications that follow.

Task & Responsibility

Development and maintenance of Cash Receipting System and Print Engine Module using Visual Basic and Sybase for MEMSA (Middle East, Mediterranean and South East Asia) Region.

Responsible for development of new reports, maintaining existing reports using Cognos BI Impromptu, Powerplay Cubes & preparing Genio script (ETL).

Development includes Study of Business Requirement, Impact Analysis, Preparing Software Requirement Specifications plan, Designing and Plan Execution.

Project Name Guarantee Export System (GES)

Client Credit Lyonnais (India)

Role Project In charge Onsite Co-ordination

Location Mumbai

Organization Moneyman Software

Period Oct 2001 – Jan 2002

Team Size Project : 1 Module : 1

Environment Software Language

Database

Tools

Web Server

O/s VB6.0, ASP, JavaScript, VBScript

Oracle 8i

Visual Interdev 6.0, Crystal Report 8.5, Ms Excess

IIS 5.0

Win 2k

Project Description

The Trade Finance Department of Credit Lyonnais deals in Guarantees in a mega volume, for this purpose the department used BAG sub module of ISBA (Banking Application based in Singapore) to capture the details related to Guarantees.

GES downloads all the Guarantees issued for the day in a flat file from BAG, which again will be uploaded to the local database and based on this information, different reports are be developed.

Some of the major cases handled by system are Guarantee Input Register, Amendment Register, Invocation Register, Expiry Letter for Normal/ Perpetual Guarantees, and Expiry Letter to Applicant, Mature Guarantee Statement, Invocation Paid / Unpaid Statement, and Guarantee Transformation Statement.

Task & Responsibility

As a Project In charge, I was individually involved in the Design, Development and Implementation of the system.

System study and information gathering from Trade Finance Dept.

Prepare the functional specification of the system

Define, design, develop and deliver flexible reports that meet business user needs

Project Name Bond Trading System (BTS)

Client Credit Lyonnais (India)

Location Mumbai

Role Project In charge & Onsite Co-ordination

Organization Moneyman Software

Period Oct 2000 – Sep 2002

Team Size Project : 2 Module: 2

Environment Software Language

Database

Tools

O/s VB 6.0, ActiveX

Oralce 8i

Crystal Report 8.5, Ms Excel

Win 2k, Win NT 4.0

Project Description

Credit Lyonnais is a Corporate Bank, which deals in Government Securities in huge volumes. All the process was manually captured by the users, so a client server based application BTS has to be developed to remove the hazardous of manual work.

BTS is an in-house developed which fulfills all the requirements of Credit Lyonnais regarding dealing in Securities right from Dealing to Accounting Entries. BTS covers different departments like Treasury, Back-Office, Finance Control & Auditors department, but it plays a major role for Back-Office Department.

Task & Responsibility

Review of Business Requirements Document from a technical perspective.

Conduct meetings with business analysts and end users to establish business rules, schedule deliverables and identify potential issues that could impact the development effort.

Design and Development.

Technical Documentation.

PERSONAL DETAILS

Name VIJAY DAYANANAD HEGDE

Date of Birth June 19, 1978

Marital Status Married

Passport Having Valid Indian PP. Valid Up to : 23/01/2020

Linguistic Proficiency English, Hindi Marathi and Kannada

Personal Skills Believe in teamwork.

Always ready to learn.

Set and achieve high standards at work and thrive on working under pressure.

Contact this candidate