Customer Service Project

GANAPATHI KRISHNAMOORTHI

**, ******* ******, *** # *

Jersey City,

New Jersey, 07306

Mobile no : 201-***-****

Email :

***********@*****.***

Career Objective:

Seeking a challenging career in an organization that hones learning

and creativity, provides exposure to new ideas and widens my knowledge

spectrum to achieve high echelons in the organization.

Summary

. Over 8 years of total IT experience with 5 years of experience in

Health Insurance industry.

. Over 3 years of Onsite experience with Onsite - Offshore coordination

model.

. Over 20 months of experience in Big data and Hadoop Ecosystem.

. Significant experience in Pig, Hive, Map Reduce, Hbase, Flume and

Sqoop.

. Hands on experience in installing, configuring and using Apache Hadoop

ecosystem components like HDFS, Mapreduce, Hbase, Zoo Keeper, Oozie,

Pig, Hive, Sqoop and Flume.

. Experience in Big Data analysis using PIG and HIVE and understanding

of SQOOP and Puppet.

. Excellent experience in Hadoop command shell commands.

. Experience in developing customized UDF's in PIG Latin.

. Wide and in-depth knowledge of HDFS concepts like HDFS federation,

HDFS high availability, core-site properties, mapred properties, Rack

awareness and data locality.

. Solid understanding of the high volume, high performance systems.

. Considerable experience and knowledge in Core Java.

. Strong experience in writing complex SQL queries and stored

procedures.

. Basic Knowledge of UNIX and shell scripting.

. Good knowledge in integration of various data sources like RDBMS,

Spreadsheets, Text files and XML files.

. Strong knowledge and experience in Agile methodology and working with

Scrum projects.

. Experienced in development, enhancements, maintenance and production

support projects.

. Vast functional knowledge in Case installation, Plan building and

Claims processing in the Group Insurance industry.

. Worked in projects involving vital functional areas such as Insurance

classes, coverage information, plan amendments, coverage provisions,

rating benefits, calculating rates for the enrolling member /

dependents, Explanation of benefits, Cost of benefits, claims

adjudication, claims payment, monthly capitation and eligibility

information in Group Insurance.

. Notable experience in the financials side of insurance. Immense

knowledge in receipt vouchers, maintenance checks, disbursements,

monthly trial balance reporting and general ledgers.

. Certified Associate of Life Management Institute (LOMA ALMI Certified)

. Worked as a Team Lead managing a team of four members for four years.

. Started my career with Mainframes and wide experience in COBOL,PL1,

DB2,Stored procedures, JCL, VSAM, IDMS, CICS, Syncsort and tools like

FileAid, Changeman.

. Well versed with DB2 stored procedures to connect Open systems with

Mainframes.

. Primarily involved in coordinating with clients and open system teams

to walk thru requirements, design interfaces, development, integration

testing, implementation planning and implementation support.

. Vast experience in quality activities including internal, external

project audits, project management reviews, project metrics reporting,

balance score cards, conducting mile stone reviews and status

reporting.

Project Summary:-

Name of the Project : Data analytics and HDFS data migration

Client : Guardian Life Insurance

Corporation of America

Duration : From Oct'12 till date

Guardian has most of its functional data residing in Mainframes. However

for data analysis and initiate proactive measures to expand business,

Guardian wanted to move the backend data to HDFS and implement hadoop

framework. The logs of customers using Guardian anytime is loaded into HDFS

for detailed analysis. The data analysis in the HDFS is conducted by use of

MapReduce, Hive and PIG jobs based on which census reports were generated

to implement new member features.

Pig and Hive queries were able to produced key findings concerning the

member including their geography, designation, social status and age group

were key factors in designing Guardian growth strategy for the upcoming

fiscal periods. Similarly key findings about the plan holders including the

size range of the plan holders, plans sold and income group were utilized

to improve the business prospects.

Role : Hadoop developer, onsite coordinator

.Responsibilities:

. Supported installation and configuration in cloudera hadoop on a 35

node cluster.

. Responsible for building scalable distributed data solutions using

Hadoop.

. Handled importing of data from various data sources, performed

transformations using Hive, MapReduce, and loaded data into HDFS.

. Used SQOOP and ETL to load data from VSAM and sort files to HDFS.

. Used Flume to collect, aggregate and store the web log data onto HDFS.

. Wrote PigLatin scripts to run ETL jobs on the data in HDFS.

. Used Hive to do analysis on the data and identify different

correlations.

. Developed and tested in a pseudo distributed cluster in Cloudera

environment.

. Developed Mapreduce jobs to do periodic data analysis about the member

trends and interests.

. Used Hadoop shell commands to move data between local and HDFS and

vice versa, alter permissions, replication factors and properties.

. Loaded part of the data into Hbase and ran queries for analysis of

member census.

. Loaded Hbase tables into Hive and ran various HiveQL queries on it.

. Monitored and managed the Hadoop cluster through Cloudera Manager.

. Installed Oozie workflow engine to run multiple Hive and Pig jobs.

. Managed core, dfs and mapreduce configuration files and made different

parameter changes to support data usage patterns.

Environment: Cloudera Hadoop, MapReduce, HDFS, Hive, Pig, Sqoop, Flume,

Hbase, Java (jdk1.6)

Name of the Project : Claimfacts and Customer service

Client : Guardian Life Insurance

Corporation

Employer : Computer Sciences Corporation

Duration : Dec'09 to Oct'12

Claimfacts is a claims processing application where the medical, dental,

disability and life insurance claims that are initiated from the CICS

environment are routed to batch where in the claim adjudication and

validation process happens. Payment checks are printed in overnight batch

and mailed out to the members. Number of reports including Cost of

Benefits, Explanation of Benefits, Flexible spending account and Lifetime

accumulation reports are prepared and distributed by this system.

Customer service

This is a subsystem of Claimfacts application that operates in real time,

interacts with web based applications like Guardian Anytime portal, Siebel

portal and Claims BPR and fetches vital information pertaining to claims,

members, dependents, providers, benefits and eligibility. Customer service

refers to the core claimfacts system to fetch the data and transfers the

data to other systems via middle ware thru CICS transactions.

Trident

A subsystem of Claimfacts application that holds the dentist information

and processes the capitation every month and mails out the reports to the

dentist office.

Clearing house for Dental Xchange

Guardian developed a clearing house project for an external vendor called

Dental Xchange which is a network of providers. The eligibility information

for members were sent out from CICS via MQ to the web portal. The data

transfer was made to comply with HIPAA 837 format. As a second phase, claim

information for members and providers were made available for the vendor

using the same interfaces.

Role : Offshore Lead / Onsite coordinator

Responsibilities:

. Participate in all requirement walk thru meetings and coordinate with

business users at onsite.

. Conduct interface meetings with impacted teams and develop Interface

Design Agreements

. Develop CICS-IDMS programs using TSQ and MQ concepts.

. Develop CICS-DB2 programs to access TRIDENT tables.

. Develop CICS and batch programs to access VSAM files to fetch claim

information.

. Maintain EOB, COB, capitation, check generation batch jobs and make

changes as per the business requirement using COBOL, DB2, JCL, DFSORT,

VSAM, IBM Utilities, FTP and GDGs.

. Support integration testing across the impacted systems and resolve

defects in IBM Rational Clearquest.

. Prepare the implementation plan in MS Excel and conduct implementation

review meetings with all the stakeholders.

. Provide implementation and post production support.

. Prepare weekly status reports and maintain project activities excel

sheet to log every task, with its associated effort, ChangeMan

package, status and timelines.

Name of the Project : GIS Accounting Application

Client : Marsh Reinsurance Broker (UK)

Duration : Mar'09 to Dec'09

Global Information System is a vital part of the insurance legacy

application which deals with accounting of the insurance transactions

pertaining to claims and premiums. The payments are accounted by creating

and applying vouchers of different types say receipts, maintenance and

disbursements, through GIS and the log for the payments are maintained. The

enhancements requested for the improvement and betterment of business like

automating manual payment processes were developed and implemented. The

credits and debits are balanced and imbalances are investigated and

resolved.

Role: Team member

Responsibilities:

. Worked in production support of GIS application.

. Monitored and fixed job abends in the GIS accounting feeds to other

subsystems and vendor systems.

. Supported the online GIS environment and coordinated with various

teams to resolve outages.

. Tracked and monitored the ticket queues and prepared the defect

metrics for the project.

. Worked in enhancing the receipt vouchers, maintenance checks and

disbursements CICS screens accessing VSAM and IDMS.

. Developed batch and online PL1 programs for ledger feeds accessing

IDMS database.

. Changed core functional accounting areas involving financial

accounting of Marsh with other insurers.

. Resolved the monthly trial balance issues and general ledger issues

and automated the trial balance process.

Name of the Project : Energy conservation and Optimization

Client : Colruyt (Belgium)

Duration : Dec'05 to Mar'09

Energy Conservation and Optimization is a pure development project which

was devised to save energy and thereby money for the firm. The energy

consumption across the machines in shops and buildings of the firm was

measured using energy meters and loaded to servers every five minutes.

These readings are retrieved and processed in mainframes and the cost of

energy consumption was calculated. Huge statistical results were arrived at

and they are uploaded to the warehouse which in turn is used to study the

pattern and reduce energy consumption. Processing real time readings from

meters was a challenge and the results were impressive.

Roles: Developer / Onsite Coordinator

Responsibilities: Analysis, Design, development, unit testing, support user

testing and provide implementation support.

Accomplishments:

. Won the Star Performer Award in Computer Sciences Corporation in

2012-13.

. Won the Best Performer Award in Tata Consultancy Services in

2007-08.

Yours Sincerely,

Place: Jersey City

GANAPATHI KRISHNAMOORTHI

Contact this candidate