Project Data

DEVIKA M SINGARAKASI **** W Palm Drive, Apt#***,

*********@*****.*** Mount Prospect, Chicago,

C: 210-***-**** Illinois – 60056.

OBJECTIVE:

With over 10+ years of Work experience in Mainframe as an IT consultant and 1 year in Data stage and 2 years of experience as a Mainframe trainer. My main area of experience has been project delivery of various sizes. I have worked primarily in the domain of Health care life sciences and Insurance. My technology forte is IBM Info sphere Data stage Version 8.5, COBOL, JCL, VSAM, CICS,IMS/DB, IMS/DC and COOL: Gen and DB2.

EXPERIENCE SUMMARY:

I am an associate with System soft technology and working in Blue Cross Blue Shield of Illinois (BCBSIL) from October 2015.

Experience of managing team of 10+ resources across multiple locations.

Experience in effectively executing multiple projects up to $1.5 Million USD.

Experience in Project Management, estimation, risk management, planning and allocating resources, reporting stakeholders, managing issues.

Involved in Business Planning, proactively identifying opportunities for growth, competitor analysis and strategy, and working towards incremental revenue growth Quarter on Quarter

Extensive experience & knowledge on Waterfall & Scrum Agile SDLC process.

Extensive experience in all phases of Software Development life cycle including analysis, design, development and testing.

Experience in working with Insurance, Property and claims & Health care Domain.

I was an associate with TCS for the last 8 years, Since February 2007 to September 2015.

From October 2011 to September 2015. I have been debuted in United States, Worked various projects in USA.

I was working in IBM Global Services India Private Limited, Bangalore, Since August 2005 to January 2007.

I worked as a Trainer and also Project supervisor in Maples ESM Technologies, Chennai, since May 2003 to July 2005.

Posses’ good functional knowledge in Healthcare. I am well experienced in writing Program specification, Preparing Test Plan, Test Data and doing unit testing. I possess good Technical and Analytical skills and also coordinating with offshore and near shore to complete the assigned task.

EDUCATION:

Master of Computer Application (1999-2002), Madurai Kamaraj University, Madurai, Tamil Nadu, India.

Bachelor of Science (1995-1998), Madurai Kamaraj University, Madurai, Tamil Nadu, India.

Mainframe Training (Jan, 2003- April, 2003) from Maples ESM Technologies, Chennai, India

TECHNICAL SKILLS:

Hardware : IBM ES 9000

Operating Systems : MVS/ESA, Z/OS, Windows 98 and DOS

Software : COBOL, CICS, SAS, ETL and JCL

Database Environment : VSAM, PL/I and DB2

Tools/Utilities : Data Stage Enterprise Edition 8.5, File Aid, INTER TEST,

SPUFI, QMF, CEDF, Expeditor, Abend Aid, Endeavor, CA- 7,

Control-M and change man, VAGen, QMF, MS office,

Remedy, Mercury Test Director, Software Configuration

management (SCM) and CDF (IMS screen design).

Management Activities : Requirement analysis, Walk through, Estimation, Resource

Allocation, Monitoring & control of the project execution,

Quality management, risk management, communicating with

Stakeholders, team building activities and Contacting daily

Standup meeting.

PROFESSONAL CERTIFICATION/LICENSURE:

Mainframe

DB2 9 Fundamentals certification

AHM 250 (Health care Domain)

Hadoop and Big Data

IBM Certified InfoSphere DataStage 8.5

PROJECT DETAILS:

Client BCBSIL, Chicago, IL, USA. Oct’15 to till date

Project Claim Processing – stabilization

Database/Tools CICS, DB2, COBOL, Endeavor

Role Project Leader

Project Description:

HCSC is the largest customer-owned health insurer in the United States and fourth largest overall.

Plans are available for the following States Illinois, Montana, New Mexico, Texas and Oklahoma. BlueChip is HCSC’s premier claims adjudication application, receiving over 115 million claims per month. BlueChip determines eligibility and benefits for electronically- and directly-entered Institutional and Professional claims. This includes local claim volumes, National Accounts, Blue Card, as well as claims sent to, or received from, outside Adjudicators, such as Labor Funds, other BCBS plans, and the Federal Employee Program (FEP).

The BlueChip suite is comprised of 71 applications, utilities and functions. Real-time and Direct Data Entry (manual) claims are processed through the following functions: Registration, Eligibility, Document Begin, Claim Level, Service Level, Accums, Claim Release and Document End. Claims are subjected to various edits, before payment determination is made across all lines of business. Adjudication concludes with a batch processing cycle. BlueChip application components are being re-engineered as part of the CCSP program and also working on Modernized Accum conversion project where all the Data from VSAM file is been converted to XML format and passed to Java for further processing and end results are stored in a UI ledger.

Responsibilities:

Leading the entire offshore Claims Managed Augmentation team.

Project management tracking and lead status calls on a weekly basis.

Involved in staffing, team ramp up and task delegation within team.

Resource management, risk and issue tracking

High and Detailed Low Level Design Document Development, SME review and signoff.

Requirement Analysis and meeting the Business Associate for any clarification.

Coding based on the design document and getting the SME signoff.

Preparing Unit Test Plan and test data for unit testing.

Review with SME and get the signoff if everything is good.

Perform the integration testing to make sure all the modules are working as expected and provide the test result with SME for verification.

Client USAA, San Antonio, TX, USA. Oct’12 to Sep’ 15

Project Life System /Property and claims

Software COBOL, DB2, IMS, SCM, PL/I, Datastage and CDF (Front end)

Role Project Leader

Project Description:

Life is a Health insurance system. Which has Health, Annuity and Life products.

HAL is an insurance contract administration system used for underwriting, issuing, billing, maintaining, collecting, and claims for fixed annuity, life insurance and health products.

USAA Life Company began migrating from a vendor application to HAL in 1991 and concluded in 2001. HAL is the heart and soul for Life. It is a mainframe application (green screens) which was built to perform all contract maintenance. HAL was designed and implemented prior to the launch of usaa.com and any member self-service initiatives.

Customers/Users/Interfaces

ousaa.com/Portal - Web applications include the E-Commerce and Life components necessary to Support Life Co. on USAA.COM and Portal.

oForms and Documents (FAD)/Illustrations and Quoting (IQ) - generates Life sales packets and letters and supports the sales and marketing functions by delivering online quotes and illustrations.

oFront Office [by Accenture] - is an underwriter vendor system that manages underwriting cases automatically and allows for cases to be manually resolved.

oClaimfacts [by Trizetto] - is an automated Health claims processing system.

oRepetitive Payment System (RPS) - administrative payment system for Single Premium Immediate Annuities; also processes scheduled disbursements in support of annuities in a payout system.

oActuarial Valuation (ARCVAL) - is a valuation system that provides for the valuation of all types of life, annuity and health products.

oPolicy Exhibit/Valuation (PE/VAL) - creates the data feeds out of HAL and PolicyLink that feed ARCVAL

oSales & Informational Online (SIMON) - supports requirements of current sales environment; acts as the foundation system for the collection and use of contract data related to Life General Agency.

oStrategic Information Resources for Financial Marketing (SIRF) - collects sales and marketing data for Management Information Reporting (MIR).

oTindall & Associates Inc. (TAI)- Life Reinsurance System administers automated reinsurance processing.

oHIPAA Gateway - accepts Health Insurance Portability and Accountability (HIPAA) compliant claims data; it also formats the data for processing in Claimfacts

oPolicyLink - administers USAA’s Variable Products and Policies including Variable Annuity and Variable Universal Life product lines.

Responsibilities:

Communicating day-to-day activities with offshore and near shore assigning the task and making sure it is been completed on time.

Preparing the Analysis and Design document based on the requirements.

Worked on creating PL/SQL procedures.

Getting the Design document reviewed and approved from the review team.

Coding based on the design document.

Preparing Unit Test Plan for the small mod.

Preparation of Test data and Unit Testing.

Will also be supporting some of the systems like TAI in performing the system testing and coordinating with business to make sure their changes are available.

As part of the knowledge transition I supported the Data Stage jobs in control-M for Life system.

Also worked on updating the document in USAA WIKI page to make sure the information is up to date on SIMON(Sales & Informational Online), HRI (Health rate Increase) and LGA(Life General Agency).

Client Kaiser Permanente, Pasadena, CA, USA. Oct’11 to Sep’12

Project Foundation system – Production support

Software COBOL, JCL, VSAM, DB2 and COOL: Gen

Role Developer

Project Description:

Kaiser Permanente (KP) is America's largest not-for-profit health maintenance organization, serving more than 8.1 million members in 9 states and the District of Columbia. An integrated health delivery system, KP organizes, provides and coordinates members' care, including preventive care such as well-baby and prenatal care, immunizations, and screening diagnostics; hospital and medical services; and pharmacy services.

KP serves members in California, Colorado, Georgia, Hawaii, Maryland, Ohio, Oregon, Virginia, Washington, and the District of Columbia.

As a not-for-profit organization, KP is driven by the needs of their members and social obligation to provide benefit for the communities in which they operate, rather than the needs of shareholders. Social benefit activities include introducing new delivery and financing methods into the health care arena at large; and developing and sharing better ways to care for patients through clinical research efforts.

KP has Foundation System (FS), a national membership application, provides services in California region, and has been designed to handle complex health plan, products and benefits by using a more robust benefit format. Defines benefits using components that can be combined together in a variety of ways. Expands benefit categories to support a wide variety of health plan products. Separates the concept of services and co-payments. Provides additional detail on benefit offerings, including service specifications, co-payment tiers and thresholds.

This is an IBM Mainframe-based application developed using CA’s Advantage –Gen and COBOL II programming languages. The system runs under GUI and 3270 CICS for on-line transaction processing, and under MVS for nightly batch processing. FS uses IBM’s DB2 database.

Responsibilities:

Monitoring day-to-day support activities.

Involved in successful implementation of projects and production support.

Interacting with Foundation system client.

Analyzing cool: gen incident and giving solution for the problems.

Working on Adhoc-spufi request.

Running the job is non-production region based on request.

Client Kaiser Permanente, Portland, OR, USA. Feb’08 to Sept’11

Project Common Membership System

Software COBOL, JCL, VSAM, DB2

Role Developer

Project Description:

KP has Common Membership (CM) System, a national application, provides Georgia, Ohio, Colorado, Northwest, and Hawaii regions with the capability of maintaining group and member eligibility and demographic information and billing, collecting payments and reconciling their accounts. This is an IBM mainframe-based application developed in-house using COBOL II and IBM’s Visual Age Generator programming languages. The system runs under CICS for on-line transaction processing, and under MVS for nightly batch processing. CM uses IBM’s DB2 database

Kaiser Permanente uses the administration functions of the common membership system to record and track members, the contracts that entitle them to benefits, and the administrative details relating to them.

The membership application is the means of collecting, changing, displaying, and calculating information about members, the benefits they are entitle billing to pay for those benefits.

Responsibilities:

Monitoring day-to-day support activities.

Involved in successful implementation of projects and production support for [24/7].

Interacting with Common Membership client..

Preparing Unit Test Plan for the enhancement.

Changing the program according to the Request.

Preparation of Test data and Unit Testing.

Client Cigna Corporation, Hartford, CT, USA Feb’07 to Jan’08

Project Cigna Eligibility and Enrollment Delivery

Software COBOL, JCL, VSAM, DB2

Role Developer

Project Description:

Eligibility and Enrollment (E&E) Services is responsible for establishing and maintaining accurate individual enrollment records for participant that subscribe to one or more CIGNA

HealthCare benefits plans. This data is loaded into CIGNA HealthCare’s source systems and becomes the source of information for responses to member inquiries and for processing claims.

Responsibilities:

Writing Program Specifications based on Design and Functional specification.

Preparing Unit Test Plan for the Development.

Changing the program according to Program Specifications.

Preparation of Test data, Unit Testing.

Supporting Integration Testing & Acceptance Testing.

Client Horizon BCBSNJ, New Jersey, NJ, USA. Apr ’06 to Jan’07

Project Horizon BCBSNJ – Development and Enhancement

Software COBOL, CICS, JCL, VSAM, DB2

Role Developer

Project Description:

Horizon is a leading health care provider in New Jersey, USA, servicing 3.2 million members. IBM US has been providing services including AMS to Horizon BCBSNJ since 1994. This project contains different modules like Finance, EDI, Legacy, Reporting, BCL front end and BCL back end. We are handling Reporting, BCL Front end and Back end, which these modules contains different applications like BCL, ITS and CARS. In Reporting we are handing the module called Ad-Hoc Reporting. Ad-hoc reporting is a type of reporting where we are able to generate the reports based on the customers need. These applications getting Inbounds from various applications do further process to feed data to other applications. The work involves enhancement, support and implementation for Horizon.

Responsibilities:

Monitoring day-to-day support activities and handle the irregular work of schedulers.

Involved in successful implementation of projects and production support for [24/7].

Interacting with Horizon SME’s and users.

Changing the program according to Program Specifications.

Preparation of Test data and Unit Testing.

Client MEDCO Montvale, USA. Aug ’05 to Mar ‘06

Project MEDCO Healthcare–Development and Enhancement

Software COBOL, CICS, JCL, VSAM, DB2

Role Developer

Description of the Project:

This is an enhancement project to amend the Requirement mentioned in the Change Request. Was involved in Directs and Managed care applications. Currently we are preparing Test data for Integration and Development.

Directs is a type of Claim processing which is categorized to the following two types:

Standard Directs: This involves the receiving the Paper claims, adjudication by the Telepaid system, Processing of the claims and reimbursement.

Paid Directs: Members pay the full cost. If the cost in the paper claims submitted by the members and that given in the electronic claims submitted by the Pharmacist matches then the claims will be paid. Managed Care: Managed care is the cost effective and Preventive care.

Responsibilities:

Writing Program Specifications based on Design and Functional specification.

Preparing Unit Test Plan for the enhancement.

Changing the program according to Program Specifications.

Preparation of Test data, Unit Testing.

Supporting Integration Testing & Acceptance Testing.

Title Credit card Processing

Organization Maples ESM Technology Ltd, Pune

Duration 2 weeks

Environment OS/390, Z/OS, COBOL, JCL, DB2 and CICS

Role Project Supervisor

Description of the Project:

This project was developed by Xansa (India) Ltd., Pune. The normal Credit Card Processing goes through following life Cycle.

Customer Request for a credit card.

Credit History of the customer is checked. If it is good, credit card is issued.

All Master databases are updated with customer’s details. A billing cycle is fixed which is a day in a month when customer’s billing will be done. Credit limit is reached.

Physical credit card is send to the customer. Card is accompanied with a card carrier, which contains the details like customer name, address, account number, validity of card etc.PIN is generated and sent to the customer.

Once card and PIN are received, customer can do the transactions. Transactions can be of various types like credit, debit, reversal, charge back etc. The transactions are recorded in a table.

On the billing day, statement of transactions is generated. It can contain various messages, which are basically advertisement campaigns.

The customer has an option of paying the ‘Minimum Amount Due’. In this case, the remaining amount will attract the standard interest rate.Once the expiry date of any card is close, a new card will be generated and sent to the customer.

Title Library Management system

Organization Maples ESM Technology Ltd. Chennai.

Duration 2 weeks

Environment OS/390, Z/OS, COBOL, JCL, DB2 and CICS

Role Project Supervisor

Description of the Project:

The Indian Library Management system designed both in Online and Batch System. BMS macros are used to design the screens. A Private library tries to automate some of its activities to speed up the services rendered to the members. The members of its library are primarily middle aged who would like to spend their evenings usefully. The categories of books present in the library range from information technology to fiction.

The activities of library are identified to have the following entities.

Member - The people utilizing the resources in the Library.

Books - The main Knowledge resource.

Publisher - One who publishes the books.

Author - One who builds the knowledge resource.

After doing all the updating and modification we are preparing the report depending upon the page where the details about the member will be located as well as period wise report also be generated.

Title Quotation System.

Organization Maples ESM Technologies Ltd. Chennai.

Duration 2 Weeks

Environment OS/390, Z/OS, COBOL, JCL, DB2 and CICS.

Description of the project:

The Quotation System contains both Online and Batch System. Online System is developed using COBOL, CICS and DB2. BMS Macros are used to design the screens. Online System is used to key-in new Quotations, to update existing Quotations, to query an existing Quotation and to list all the quotations acquired by a Executive. The Batch System is developed using COBOL and DB2. JOBs are created as PROCs. Batch System is mainly used to send details of New Quotations to Production Department and to receive completed orders from the Production Department. Reports are also generated.

Contact this candidate