SUGUNA PALANISWAMY
*****************@*****.***
Contact No: 978
Experience Summary
Having 5 years of experience in IT industry with strong emphasis in
all phases of software development including analysis, design, coding,
testing and implementation of applications in IBM mainframe environment
and also in real time production support activities.
IT Experience
. Worked as a Software Engineer in STERIA LTD (Client : AXA Insurance)
. Worked as an analyst programmer in SYNTEL LTD(Client: Wellpoint Insurance
and American Express Banking)
Domain Knowledge
. Health Insurance (Payer)
. Banking ( Accounts Receivables)
Skills
. IBM Technology COBOL, JCL, ISPF
. Mainframe tools CHGMAN, ENDEVOR,OPC, FILEAID,GENERATOR,
CONTROL-M,$AVRS,INSYNC,PLATINUM,SQL,
FILE MANAGER, JOBTRAC, JHS
(JOB HISTORY SYSTEM), INFOMANN,QMF, SPUFI
. Data Base DB2, VSAM
. Operating System OS/390, ZOS, Windows
. Other Tools Manage now
Education
. B.E., Electronics & Communication Engineering from Anna University.
. M.B.A., Human Resource Management from Anna University.
Project Experience
Steria Ltd.,
Software Engineer
Client: AXA/Friends Life
In September 2010 AXA UK sold a number of AXA Life strategic business units
(SBUs) to Resolution plc. The SBUs retained by AXA [Wealth Management, Sun
Life Direct, AXA Distribution Services, Bluefin, Bancassurance and
Architas] have been structured into a new organization called AXA Wealth
(AWL). The overall objective of the Separation project is to enable the
completion of the sale of prescribed AXA businesses to Resolution plc. The
project is mandatory by the terms of the agreement between AXA and
Resolution. AWL and FP are legally obliged to ensure that all outgoing
policy communication reflects the correct 'owning' Insurance Company by
01/11/2011. The main requirement of the (SLD) Brand & Outputs Project is to
enable all customer facing outgoing communications for KLM policies to
quote the appropriate owning company and associate brand details in terms
of Logo, Footer, Signature, Website, Address & Telephone no. As part of the
AXA Friends (Resolution) deal there is requirement to separate Friends from
AXA within 2 years. As part of the overall separation, there are
contractual requirements to remove reference to any AXA, Sun life or legacy
references (referred to as re-branding). The full branding change will
remove and replace references to the AXA company structure with the new FPH
company structure across all systems (all Business Units, Products & IT
Applications) and system generated outputs for the acquired book of
business.
Module: Pensions
A pension is money invested to provide an income when a person
retires. Unit Linked Pensions contracts enable the policy holder to choose
the type of investment he wants for his money. Unit linked policies do not
have bonuses declared as in a conventional contract (an exception being the
With Profits Fund). Instead, each policy holder buys units in particular
funds which he or she has chosen. The return depends on the performance of
the fund. Because the fund can fluctuate in value, there is potential for a
higher return. The price (value) of a fund varies according to the success
(or failure) of its underlying investment.
The ULP system provides a method of adding or removing units to/from
customer's accounts. To achieve this, the system uses on-line data entry
(and enquiry screens), batch input (data prep., IS2, etc.) and overnight
batch runs.
Key Contributions:
> Understanding the requirement of the client for designing the
specifications, developing the system and subsequently
documenting the requirement.
> Designing and coding using COBOL & DB2, writing JCL to execute the code
for testing and delivering the final results.
Syntel Ltd.,
Analyst programmer
Client: AMEX - American Express
American Express is a Global Travel, Financial and Network service
provider. Founded in 1850, the company serves individuals with charge and
credit cards, traveler's checks and other store value products. Through its
family of corporate card services, AMEX helps companies and institutions to
manage their travel, entertainment and purchasing expense.
This project is undertaken for American
Express based in Phoenix. Enhancement & Maintenance of the credit cards
provided by Corporations to their employees for their business expenses.
The corporations purchase these cards from AMEX, which are referred as
Corporate Cards.
Module: Card Maintenance/Corporate Account Receivable System
(CM/ CARS)
Main functionality of CM is to set up and maintain corporate
card i.e.,
< Setting up of new account,
< Renewal of accounts,
< Generation of plastic cards,Etc.,
CARS produces Unbilled data (Daily sent data) and
Billed data. It maintains daily incoming charge activities (i.e., debits,
credits, adjustments and remittances), cycle (monthly) accounts status,
account aging, and generates different types of billing/report files.
CARS DAILY:
The CARS Daily process edits and reformats the detail financial data
captured by FINCAP. It
accumulates an account's corporate financial activity (for a business
process day) and stores
the detail in the detail media databases. The accumulated dollars are
stored in the Balance
Forward segment of the corporate card database.
CARS CYCLE:
CARS cycle is the monthly billing system for the American Express Corporate
Card within the
US and the Corporate Dollar Card within Latin America. Each month, every
account is billed
in one of ten executions of this process called cycles. The CARS cycle
process produces all
the financial transaction files, for input to all the Corporate Card
Billing Systems and financial
reporting, for balancing transactions billed (CARS Cycle) to transactions
received (CARS
Daily). This processing updates card members NACH and Balance Forward
information based
on cycle bill dollars and generates delinquency charges based on account
aging status. CARS
Cycle builds detail and summary files for input to interfacing systems.
CARS Statementing:
The CARS Cycle system allows corporate clients to receive billing
statements in a variety of
ways, including Enhanced Country Club Billing (ECCB) or "regular" billing
statements, similar
to personal card billing statements, and "fan-fold" billing statements
containing summary and
detail information.
Key Contributions:
> Monitoring batch jobs in production support, solving issues and
abends in minimal possible time.
> Monitoring the Queues in MANAGE NOW, and working on the tickets
in time to
achieve customer satisfaction.
> Understanding the requirement of the client for designing the
specifications, developing the system and subsequently
documenting the requirement.
> Enhancement of the existing system when required.
Client: WELLPOINT - BCBSGa
WellPoint is the nation's leading health care provider serving the needs
of millions of medical members nationwide. WellPoint's Blue-licensed
subsidiaries and their affiliates provide a comprehensive range of group
and individual health benefits, life, and disability products. WellPoint is
a Blue Cross or Blue Cross Blue Shield licensee in the following 14 states
- California, Colorado, Connecticut, Georgia, Indiana, Kentucky, Maine,
Missouri, Nevada, New Hampshire, New York, Ohio, Virginia, and Wisconsin. A
wide range of products is offered by WellPoint's subsidiaries throughout
the United States. WellPoint has grown with consistency and reliability in
the industry. This performance is the result of strong internal growth,
strategic expansion and an approach to managing and growing the business
that is guided by a commitment to leadership, innovation and social
responsibility.
Module: Blues
Preparing inventory for the VSAM to DB2 conversion proposal, which
can
facilitate smooth migration of Q/Care to Enterprise system.
Key Contributions:
> Involved analysis of requirements & analyzing existing programs.
> Preparation of Project estimation.
Module: Production Support
This project involves the monitoring of QCARE nightly batch cycle
where the QCARE business data will be processed in the batch mode. All the
business data collected during the business day time will be processed in
the nightly batch run. The online region will be brought down during this
batch run and the region has to be brought up before 6:30 AM EST which the
SLA that SYNTEL has signed with WellPoint.
Key Contributions:
> Monitoring batch jobs for production support, solving issues and
abends in minimal possible time.
> Making sure that the QCARE online region is brought up before
6:30 AM EST to meet the SLA and achieve customer satisfaction.
> Training the new team members with the processes involved in
monitoring the nightly production running and effectively
solving the production abends.
Module: Finance
Q/Care Finance module is a sub module to the Q/Care, which takes care
of the billing related issues, like the premiums to be paid by the groups
(organization) or individual members to the WellPoint with in the Premium
time. It also manages the online interaction for providers. The Finance
module is further divided into sub modules.
Q/Care Remittance
835 Transaction - Health care payment and remittance advice used to
make a payment, send an explanation of benefits remittance advice, from
WellPoint directly or via a financial institution in the form of Electronic
Remittance Transaction (ERT) and Electronic Fund Transaction (EFT) using
the 835 transactions under the HIPAA guidelines.
Q/Care Billing Process
Q/Care finance Billing process is the process of generating the
premiums to be paid by the group (Group Bill) or by the individual members
(Direct Pay) using the Group Bill sub system or the Direct Pay sub system.
The Invoices are generated and are sent to the customers helping them pay
the premiums according to the plan chosen.
Key Contributions:
> Remits Reprocessing, Testing, Coding, Monitoring the DEV0 and
DEV3 batch run in Control-M, solving the balancing issues in 835
Transaction.
Module: EDI Gateway
Health Insurance Portability and Accountability Act (HIPAA) mandated
sweeping changes in the approach healthcare industry electronically
communicated between entities like providers, payers, hospitals and
sponsors. HIPAA adopted ANSI standard transaction 270/271 for Eligibility &
Benefits, 276/277 for Claims Status, 278 for Pre Auth & Referral, 837 for
Claim billing information, 835 for Billing and payment of claims through
remits and 834 for Consumer insurance enrollment information. Client
undertook a number of projects to meet HIPAA requirements. A Gateway is
proposed to handle all inquiry transactions that are capable of
communicating using HIPAA transactions. Client had developed a local format
for every HIPAA transaction to ease the file processing logic. Client had a
strategic decision to use these local formats for all-internal processing.
EDI Gateway - Electronic Data Interchange (EDI) Common Gateway system is
developed to handle the following inquiry transactions as stated by HIPAA,
arriving at clients systems and to provide response to them. In WellPoint
EDI at Georgia we receive claims and process these claims and also provide
the remittance information for those claims. I have worked and delivered
successfully following major maintenance projects at EDI:
Project1: EDI Batch
This project deals with the batch transactions : 837 for Claim billing
information, 835 for Billing and payment of claims through remits and 834
for Consumer insurance enrollment information.
Key Contributions:
> Remits Extraction and Reprocessing, LDLA Audit, PMM Document,
System Integration Testing and Solving the SR's (Service
Request).
> Understanding the requirement of the client for designing the
specifications, developing the system and subsequently documenting the
requirement.
> Designing and coding using COBOL, writing JCL to execute the code for
testing and delivering the final results.
> Enhancement of the existing system when required.
> Creation of test plans for both new and modified programs and carrying
out unit testing as per the requirement.
> Documenting the changes, doing code reviews and preparing test plans for
maintaining the quality of the delivery.
Project2: EDI Real-time
This project deals with the real-time transactions : 270/271 for
Eligibility & Benefits, 276/277 for Claims Status, 278 for Pre Auth &
Referral.
Key Contributions:
> Monitoring the jobs related to the module.
> Solving the abends during the bottleneck situations.
> Co-ordination with the Support operations, to inform regarding
the issue situation.
> Sending BX-reports, weekly reports and monthly reports
> Involved in real time production support activities by
monitoring the batch scheduler (CTM) error queue and suggesting
permanent solutions if needed.
Project3: EDI Shutdown
The scope of this project is to consolidate the Legacy EDI Gateways in
California, Georgia and New York. When this initiative is deployed, a
single Enterprise EDI Gateway will exist for all states/brands and provide
enterprise-wide trading partner solution. Implement to assign Enterprise
DCN to each claim received via Enterprise and to make sure uniqueness. To
stop the current GA process and handle files received from EEG.
Due to accelerated EDI consolidation there no more exists separate
gateways for Georgia. So a shutdown was planned which involved the
strategies, personnel, procedures and resources necessary to shutdown the
applicable gateway following the implementation of the AEC.
Key Contributions:
> Participated in thorough impact analysis.
> Prepared the list of impacted jobs, that needs to be shutdown.
> Prepared the jobs that need to be transitioned to Enterprise
EDI.
> Prepared the entire flow for 837, 835, 270/271, 276/277, for
Enterprise EDI.
> Analyzed the dependencies of the applications as well as jobs in
Control-M.
> Shutdown was made without impacting any other systems.
> Documented the plan and the progress.
> Took proactive measures not to cause any flaws in shutdown.
> Communicated with onsite effectively through mails and
communication log.
Responsibilities:
* Involved analysis of requirements & analyzing existing programs.
* Preparing Technical program Specifications document.
* Involved in preparation of unit test plan.
* Coding the program as per the client specifications mentioned
* Unit testing of the changed programs.
* Attending Code Reviews, Test Reviews and status meetings
* Preparation of Documents for changed programs.
* Generating reports according to client's specifications.
* Interaction with the onsite coordinator.
* Following the quality procedures prescribed in the project.
PERSONAL DETAILS
Communication Address : 168 River Road,
Apt 122,
Andover,
Massachusetts -
01810.