Grace Evangilin Ebenazer
*************@*****.***
PROFESSIONAL SUMMARY
* ***** ** ******* ********** in IT industry.
Successfully implemented and managed operations in offshore and on-site project delivery model
Expert in developing and coding of Batch applications using SAS, COBOL and JCL
Excellent Domain knowledge in Insurance, Health Care and Banking
Strong analytical & design skills including problem solving abilities with excellent communications skills.
Ability to handle multiple tasks and can work independently as well as in a team.
Strong experience to train and manage the team to deliver the work in a stipulated Time.
Possess Strong Soft Skills, such as Business, Global Communication and Presentation Skills.
Excellent Learning Skills on Future Technologies and result oriented person with excellent leadership skills.
SKILLS PROFILE
Project Models worked : SDLC - System Design, Development and Integration and Analytics
Domain knowledge : Insurance, Health Care and Banking
Programming Languages: SAS, JCL and COBOL.
Tools used : Mainframe, SAS, TSO/ISPF, Change man, Endevor, File-Aid and SAR.
Operating System : MVS/OS390 and Windows NT/XP.
SAS : SAS version 9.1.3
CAREER PROFILE
July 2011 – February 2015 Dun and Bradstreet (Chennai)
Project :
Analytics – Implementation and Fulfilment team
Position :
Senior Analyst – Offshore
Responsibilities :
Lead a four member team and Specific responsibility comprised the following
Investigative Reports done for change in CCS, FSS, Viability Ratings(US) and Canada Viability Rating over certain time period
Scoring Services run monthly, half yearly, quarterly, etc., Specific customers include GE, CSTEM, TCF, HSBC, etc.,
Canada Viability Rating Implementation including testing
Retro Validations
Bad debt reserve reports
SBFE (Small Business Financial Exchange) data analysis and reports on data
Data and Scores Append
Responsibilities done under MaxCV (Maximizing Customer Value) Project includes conversion of legacy codes in to standard system.
Code Conversion from SPSS to SAS for the UK marketing Models.
Optimization and testing of the UK marketing Models.
Optimization, code clean up and testing of the US scoring models.
Optimization and testing of NON US Sales and Employee Estimation
Developed Sales and Employee Estimation models
Added commentary codes to Canada CCS and FSS scoring models and tested the same.
Technologies Used : Base SAS, SAS Macros and JCL
June 2009 – June 2011 UST-GLOBAL (CHENNAI)
Project :
Retail Margin – ESI Project
Position :
Software Developer – Offshore
Responsibilities :
Specific responsibility comprised the following –
Gathering requirements from the business.
Designing, coding and testing of the SAS programs.
SAS coding involved:
Preparation of Integration test plan and test cases
Reviews for the deliverables.
Implementation and support.
Go live implementation and aftercare.
QC for the project
As a part of the WellPoint Account team, I was involved in the maintaining and improving the WellPoint university repository.
Description :
ESI have offered retail discounts greater than NextRx's current terms. ESI, through their higher discounts with the retail pharmacies than the terms being offered to WellPoint, will capture margin from our retail prescription volume. In order to realize the benefit of the buyer's improved retail pharmacy discounts, while our members are still on the NextRx adjudication systems prior to migration, ESI's pharmacy rates must be loaded into the NextRx's systems. NextRx's adjudication systems do not have the ability to differentiate the terms paid to the retail pharmacy from those billed to the health plan. As a result, loading the buyer's pharmacy rates into the NextRx's system would result in discounts to WellPoint that are greater than the contract terms; this alters the intended economics of the arrangement, as the buyer is unable to capture the retail margin.
Technologies :
Base SAS, JCL, FILE AID, SAR, Changeman.
April 2008 to Mar 2009 UST-GLOBAL (CHENNAI)
Project :
WellChoice Integration,
Position :
Software Developer – Offshore
Responsibilities :
Specific responsibility comprised the following –
Gathering requirements on the changes from client and onsite POC.
Designing, coding and testing of the programs
Direct communication with client and onsite POC through weekly conference calls and emails.
Preparation of Integration test plan and test cases
End to End testing
Reviews for the major deliverables.
Implementation and support
Go live implementation and aftercare.
QC for the project
The Project :
The Project involves a series of phases enabling Well Point to migrate existing clients in the Well Point Claims Processing System (ProServ) to Anthem Prescription Management Claims Processing System (ProPBM) and implementation of New Clients in the ProPBM. This involves the migration of Prior Authorization data, Historical Claims data, Group/Member Eligibility data etc. The ProServ system manages its client data in IMS DB & small part in DB2 and the ProPBM stores data in Oracle database for different clients. The project also incorporates new clients into the Anthem’s finance processing.
Since ProPBM uses Oracle DB, Informatica serves as an Interface between DB and Mainframes.
Empire (Well Choice) is one of the health care companies in the U.S. They were one of the competitors of WellPoint. Empire was a standalone company operating at New York, Kentucky. Empire was providing services only for its medical claims and its pharmacy related claims were taken by Caremark.
In the year 2006 WellPoint acquired Empire. As a result of merging with the NextRx, the empire decided to use the NextRx PBM for its pharmacy claims processing instead of Caremark. Hence all the members would be migrated from Caremark PBM system to NextRX PBM system. Therefore starting from 1-1-2009 implementation, all the members of empire will use NextRx as their PBM.
In the WellChoice, we would be checking whether the current system is capable of implementing one million members and if it’s not capable, the system is stabilized accordingly.
Technologies :
SAS, COBOL, JCL, FILE AID, Endavor and SAR.
Dec 2006 to Mar 2008 UST GLOBAL (CHENNAI)
Project :
NCI (New Client Implementation) Project
Client
WELLPOINT PHARMACY, WELLPOINT – ANTHEM
Position :
Software Developer – Offshore
Responsibilities :
Specific responsibility comprised the following
Analysis of High-level business requirements and identify the relevant functional and technical requirements.
Designing, coding and testing of the programs
Direct communication with client and onsite POC through weekly conference calls and emails.
Preparation of Integration test plan and test cases
End to End testing
Reviews for the major deliverables.
Implementation and support
Go live implementation and aftercare.
Performed as a Defect prevention Controller
Description :
WellPoint is the largest and leading publicly traded health care company that serves the needs of 34 million medical members in US and provides a broad range of medical and specialty products. WellPoint is included in the S & P 500 Index and its business strategies mirror commitment to offering choice and access to quality care to members and the public.
The Project involves a series of phases enabling Well Point to migrate existing clients in the Well Point Claims Processing System (ProServ) to Anthem Prescription Management Claims Processing System (ProPBM) and implementation of New Clients in the ProPBM. This involves the migration of Prior Authorization data, Historical Claims data, Group/Member Eligibility data etc. The ProServ system manages its client data in IMS DB & small part in DB2 and the ProPBM stores data in Oracle database for different clients. The project also incorporates new clients into the Anthem’s finance processing and Rebate Processing..
Technologies :
SAS, COBOL, JCL, FILE AID, SAR, Endevor, Table base and Changeman.
COURSES / WORKSHOPS ATTENDED
Year and Month
Title
Location
Organised by
July2006 – September 2006
Software Development Process
Requirements Engineering & System Design Overview
Reviews, Walkthroughs
C/C++
SQL,RDBMS,PL/SQL concepts
Mainframe concepts
Informatica basics
Trivandrum
UST GLOBAL
October 2007 – November 2006
SAS theory + Hands on
SORT utilities
File-Aid, Table base, Changeman
Unix Base
QC (Quality Controller)
CC (Configuration Controller)
DPC (Defect Prevention Controller)
Working in teams effectively
Trivandrum
UST GLOBAL
EDUCATIONAL PROFILE:
Bachelor of Engineering - Electrical and Electronics Engineering (affiliated to ANNA UNIVERSITY)
PERSONAL DETAILS:
Name : Grace Evangilin Ebenazer
Date of Birth : 21st Mar 1985.
Nationality : Asian
Languages Known : Tamil, Malayalam and English.
Gender : Female
Marital Status : Married
Passport Details : Z2516419, Valid till 1st September, 2024.
Visa Status : H4
Work Permit : H4 EAD
Address : 3215, Ravens Crest Drive, Plainsboro, NJ 08536
I declare that the information and facts stated above are true and correct to the best of my knowledge and belief.
[GRACE EVANGILIN E]