Ms.S.RANJANI IYER +** 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