Arumugam Perumal

Project Name - Roadside Assistance Travelers

Project Description :

To find out the claims which are rejected,approved and processed for roadside remittance

Roles and Responsibilities :

● Worked on developing QlikView dashboard

● Worked on Teradata database

● Worked on Agile methodology.

● Started working on the project from the scratch

● Gathered Requirement from the client necessary for creating Dashboard

● Worked on creating folder structure necessary to upload Dashboard to access point.

● Done Extracting, Transforming, Data Modelling using various Facts and Dimensions for snowflake and star schemas

● Created qvd’s and qvs’

● Done Unit, regression testing.

● Used Document analyzer to optimize the dashboard memory

Project Name -PI Billing

Project Description :

The objective of this project is to load data into database from sourve and develop and produce Dashboard through Qlikview for Business Insurance Billing Metrics related to Payments and Billing process to support Business Insurance line of Business within Traveler’s organization

Roles and Responsibilities :

● Worked on developing QlikView dashboard

● Worked on abinitio to create ETL jobs to fetch data and store in database.

● Worked on Teradata database to align table and migrate tables to higher environment.

● Worked on Agile methodology.

● Worked on creating folder structure necessary to upload Dashboard to access point.

● Followed all the standards in creating model and dashboard

● Worked on document analyzer to optimize the dashboard memory and migrated to access point

Project Name - Seat Management Tool

Project Description :

This database is used for Seat Management. It is used to find the seat details based on the floor and location wise. By using this tool, Seat Utilization will be calculated

Roles and Responsibilities :

• Developed List, Crosstab and chart report.
• Worked on Cognos Administration part in order to test the security level setting.
• Created reports using advanced features like Bursting and Drill through.
• Provided support to QA team during SIT.
• Support UAT and Production migration activities.
• Developed Cognos Active reports in report studio (Version 10.2.1).
• Developed Model in Cognos Framework Manager.

Project Name - Tech Currency

Project Description :

Basically it allows the business users from three LOBs(CORE,LEGAL,TIS) to access and monitor the quality of claim files

Roles and Responsibilities :

• Fix the reports which are upgraded from 10.2.2 to 11.0.7. Fix all JavaScript Issues and Cognos issues
• Develop the reports in Cognos as well as in qlikview and compare the performance
• Test the reports by comparing the report output with 10.2.2.