Life Insurance Data

Ramarajan M

Mobile No: 890-***-****

Email:**********@*****.***

DOB : 20-05-1990

Summary

A skilled software professional with 4+years of experience in IT industry and worked in different aspects of designing and developing in BI solutions

As Associate Consultant in Gain Insights Solution Pvt .Ltd, having 2.4 years of experience in QlikView and Qlik Sense.

As Qlik Sense Developer in KBS Technologies Pvt .Ltd, having 9 Months of experience in Qlik Sense.

Currently I am working as a Consultant In PriceWaterhouseCooper India.

I am holding on B1 Visa for US.

Worked on various phases of BI solution development lifecycle, from gathering requirements to testing and support.

Insightful knowledge of business process analysis and design, performance measurement and quality.

IT Skills

BI OLAP Tools

QlikView, QlikSense, QlikSense Admin, Qlikview NPrinting, Qlikview Server, Qlikview Publisher, SAP connector,

Birst.

Informatica Basics.

Technologies

SQL, Html,css

Database

SQL Server 2008

Professional Experience

CLIENT : TATA AIG General Insurance

TATA AIG provides General insurance to individuals and corporates.

For Analytics, we have implemented QlikSense & Qlik Analytics Platform on top of Sybase, Oracle and SQL to provide Insights on Claims, RPU, CRM Subject Areas.

Environment:

Team Size: 4

Technology: QlikSense & Qlik Analytics Platform

Roles & Responsibilities:

Responsible for QlikSense Server Installation & creating Data Model

Migrating the Cognos, SSIS & Manual Queries into QlikSense Report.

Develop and design insightful visualizations

Admin Works like Server Up gradation Task Scheduling and user assignments

CLIENT : SBI LIFE INSURANCE

SBI Life Insurance having around 150 branches in India.

For Analytics, we have implemented QlikView & QlikSense on top of Oracle to provide Insights on Claims, Renewal, NB Subject Areas.

Environment:

Team Size: 6

Technology: QlikView & QlikSense

Roles & Responsibilities:

Responsible for overall Data Model

Develop and design insightful visualizations

Qlikview & QlikSense Admin Works like Server Configuration, Server Upgradation Task Scheduling and user assignments

Unit testing and defect Fixing.

CLIENT : Gabriel & Co(US):

Gabriel & Co manages Ecommerce business in US Market.

For Analytics, we have implemented QlikSense on top of Microsoft Dynamics to provide Insights on Sales, Finance Subject Areas

Environment:

Team Size: 2

Technology: QlikSense

Roles & Responsibilities:

Responsible for overall Data Model

Develop and design insightful visualizations

QlikSense Admin Works like Server Configuration, Server Upgradation Task Scheduling and user assignments

Unit testing and defect Fixing

QLIKVIEW PROJECTS:

CLIENT : INFRAHEDGE(a subsidiary of State Street Corporation)

PROJECT : Barclays Multi Management

This Project is helpful to reporting the day by day Profit and Loss Statement.

Team Size : 5

Technology: Qlikview11, MS SQL Server,Excel Files

Roles and Responsibilities:

Interact with onsite team in UK to understand client requirements and Build Data Model

Create the Data for the Application

Consolidate the Data

Developing the UI QlikView Application

Handling Qlikview ADMIN Works.

CLIENT : WIPRO INFRASTRUCTURE

PROJECT : Billing Analysis

This project is for the Wipro Infrastructure, Top level Managers and CEO Want to

See the Total Billing and Plant Wise Information and Future Projections .

Team Size: 2

Technology: Qlikview 10,SAP Report,SAP,SQL

QlikView Application Developed:

Billing Analysis - Dashboard, Billing Share %, Top Billing Analysis, Plant Wise Billing,

Billing Projection.

Roles & Responsibilities:

Build data model

Developing and documenting the QlikView Application

Handling QlikView ADMIN Works, Server Upgradation.

Scheduling tasks

Extracting Data from SAP Report and SAP Database.

CLIENT : WIPRO CONSUMER CARE & LIGHTING

PROJECT : Inventory Dashboard

This Project is for the Wipro Consumer care & lighting, The Plant Manager Want to See the Over All Inventory Trend, Stock Type Analysis and Ageing of the Material for each Material Analysis.

Team Size: 2

Technology: Qlikview10,SAP Report,SAP,SQL

QlikView Application Developed:

Inventory: Dashboard, Inventory Trend, Storage Location Analysis, Stock Type Analysis,

Ageing Analysis.

Roles & Responsibilities:

Build data model

Developing and documenting the QlikView Application

Handling QlikView ADMIN Works Scheduling tasks

Extracting Data from SAP Report and SAP Database, SQL Database.

Education

Bachelor of Engineering in Computer Science(Anna University, Chennai)

Contact this candidate