Ms.S.RANJANI IYER +91-979*******

Professional Summary

a)Offshore Professional Summary

Have 5.3 years of experience in the IT industry.

Hold a BACHELOR’S DEGREE in ELECTRONICS & INSTRUMENTATION.

Worked in 3 projects with insurance domain as Graph talk developer using prolog and core java and analytics related reporting tools such as qlikview and tableau.

As a part of the analytics project, involved in trainings in Big data and extracting data from impala database and building reports.

Worked on POC’s to extract data from various sources – online & offline dbs. Online dbs include the impala drivers using pig scripts and offline sources include the excel or cvs files.

Conducted knowledge transfer activities to the peer members.

Worked as a SOLUTION ARCHITECT in lean analytics platform.

Worked on preparing estimations, understanding documents, HLD, LLD, Test case reports for every change requests from the customer.

Conducted meetings on overall insurance product development and strategic planning to accomplish within the team and stipulated time.

Created training materials for policy management system modules in insurance as well as admin activities of tableau server.

Worked on Data analysis focusing various domains like healthcare, telecom and retail.

Worked on data analytics and built reports such as

i.Customer churn report for Club Mahindra Holidays (retail)

ii.Virgin patient treatment completion (healthcare)

iii.Lead propensity report for AT&T( telecom)

iv.Building reports for warranty analytics.

v.Building reports for order forecast.

Currently working in Banking domain, with the World Bank being the client, as a tableau developer and few jobs as tableau admin, My role as an associate deals with interacting the client, gathering the requirements, analysis and replicating them in a report, providing demos and publishing to production server . Thereafter dealing with any prod issues or prod requests occasionally.

b)Onsite Professional Summary

Visited Client location in Mumbai on deputation for one year in SBI Life insurance, Belapur to play a role as TECHNICAL COORDINATOR.

Resolved production issues, attended business meetings as well as involved in month end activities.

Involved in creating patch up snippets/queries as per the requirements.

Technically coordinated with the offshore members and accomplished in bug less and timely delivery.

Worked on policy management systems mainly on death claim module and payment mechanism module.

Awards and Achievements

Certified in Principles of Life Insurance and practices of Life insurance- Insurance Domain from Insurance Institute of India (III).

Received “BRAVO” award for the defect less delivery in minimal span of time.

Involved in the development of policy servicing modules like death claim, lapsation, payment mechanism and surrender which has been appreciated by the client for the efficient design.

Promoted from Developer to Technical Coordinator in SBI Life Project.

Client Appreciation from World Bank client for error-free delivery.

Experience Details

Organization

Designation

Duration

Tech Mahindra (previously Mahindra Satyam)

Team Member

June/2011 –Oct 2013

Technical Coordinator

Oct/2013 – July/2014

Solution Architect

July/2014- July/2015

Cognizant Technology Solution

Technology Specialist ( BI

Developer)

Sep/2015- Till Date

Skills

Primary Skill category

Tableau, SQL

Sub Skills

Core Java, Pig

Secondary skills

Graphtalk

Domains

Insurance, Retail

Trainings

Type

Title

Location

Organized by

Duration

Technical Education

Java-J2ee

MSLW - Hyderabad

Tech Mahindra

4 Months

Technical Education

Insurance basics

CMS- Chennai

SBI Life Team

2 Weeks

Technical Education

Graph Talk developer

CMS- Chennai

SBI Life Team

2 Months

Technical Education

Information Security and management (Insurance domain)

Mumbai – Belapur

SBI Life Team

2 days

Technical Education

Hadoop

Chennai

Training Institute

2 months

Certifications

Certified in Principles of Life Insurance and practices of Life insurance- Insurance Domain from Insurance Institute of India (III).

Preparing for Tableau Desktop Certification (Version 9.2)

Project Details

Project Profile#1: SBI LIFE PMS NOV ‘2011 – JULY 2014

Project Domain

Policy Management System

Sub Domain

Policy administration and maintenances.

Client

SBI Life Insurance Co Ltd

Organization

Tech Mahindra

Location

Offshore: Chennai

Duration

Offshore: Nov/2011 – till date

Onsite : Oct/2013 – july2014

Environment (with skill versions)

Languages:

C++, Prolog and Graph talk developer 3.4.0

Softwares:

VNC viewer 4.1.2, Graph talk Developer 3.4.0

Database:

0racle 11g

Tools:

Propalms TSE 7.0, WinCVS 2.1.1.1

O/S:

Windows Xp, Vista and Windows 7

Project Description:

SBI Life PMS project is a policy management system which deals with the new products and maintenance of the policies of the customers. The whole business is handled in Indigo using Graph Talk Developer 3.4.0 and the GUI is handled in portal using Web Logic 8.1 and Oracle 11g.

Contribution:

Involved in all phases of Software development life cycle.

Extensively worked with death claim and payment mechanism in month end activities.

Involved in Development of various change requests, problem tickets and production issues and optimizing the existing code.

Involved in the Knowledge transfer of various module session to the team members.

Project Profile#2: LEAN ANALYTICS JULY’2014 – AUG2015

Project Domain

Retail

Sub Domain

Lean Analytics – BI

Client

POC & Club Mahindra Holidays

Organization

Tech Mahindra

Location

Offshore: Chennai

Duration

Offshore: July/2014– Aug/2015

Environment (with skill versions)

Languages:

Pig/ sql

Softwares:

Tableau 8.3 (Desktop/Licensed)

Database:

Impala,ODBC

Tools:

Putty, MS Excel, qliksense

O/S:

Windows 7

Project Description:

Lean Analytics Platform involves in development of a software tool which focuses on predictive analysis and help the customers to take smart business decisions. The product has a user friendly GUI built on java and various KPI definitions are given as input . The KPI are mapped to the fields which are previously hardcoded at the backend using R script. The specified formulae are applied and the table is constructed with Boolean values. For the visualization reports, the pig script interacts with the tables and loads the fields in the reporting tool. Finally, the report is presented to the user which works dynamically if the values are changed . This project follows agile methodology.

Contribution:

Worked as Tableau developer building dashboards according to the customer information.

Contributed both as a developer /admin on building and publishing reports.

Played as a shadow resource on data analysis .

Involved in status calls, open house meetings, and knowledge transfer to respective team members.

Extracting data using pig scripts .

Project Profile#2: WORLD BANK AUG2016-TILL DATE

Project Domain

BFSI

Sub Domain

IBRD and IFC division

Client

World Bank

Organization

Cognizant Technology Solutions

Location

Offshore: Chennai

Duration

Offshore: Aug/2016 – till date

Environment (with skill versions)

Softwares:

Sharepoint, Tableau 9.2

Database:

ODBC

O/S:

Windows 7

Project Description:

The World Bank consists of two divisions –IFC and IBRD. The tableau reports are developed for both divisions from offshore. The process followed is agile methodology. The team builds the applications for World Bank customers for internal use across multiple branches. The IBRD majorly focusses on providing loans targeting Reconstruction and development purposes such as health/education. A CORE IT application is built which is accessed across different parts of the world. The CORE IT (Country Offices resources and Information IT Portal), retains the information of IT assets, country offices, head offices of IBRD & IFC regions . This same information is built on tableau to provide easy coverage and understanding to the users. Similarly many other reports were developed based on day to day requirements ( Agile Project).

Contribution:

Worked as Tableau developer building dashboards with client interactions.

Contributed both as a developer /admin on building and publishing reports.

Taken up responsibility for fixing prod issues (Support member for Tableau).

Creative and interactive dashboards were developed.

Member of Center of excellence team, providing solutions to peer members in tableau.

Taken part in live demos & conference related to tableau server /desktop related

Provided demo to clients on a weekly basis for any updates in designs.

Education

Degree and Specialization

College / School

University/ Board

Percentage in %

Year of passing

B.E E&I

SRM Valliammai Engineering College

Anna University

70.4

2011

HSC

Chinmaya Vidyalaya Higher Secondary School

State Board

78.1

2007

SSLC

Padma Seshadri Senior Secondary School

Central Board (CBSE)

78.0

2005

Personal Details

Particular

Details

Name

S.RANJANI IYER

Email ID

acw3z5@r.postjobfree.com

Contact Number

+91-979*******

Date of Birth

03-07-1989

Nationality

Indian

Linguistic skills

English,Hindi,Tamil

Declaration

I hereby declare that the information furnished above is true to the best of my knowledge.

Yours truly,

S. Ranjani Iyer

Contact this candidate