Oindrila Roy

Project: Health Care Client (Domain - MS PLAN, Application - WEBCCI -Policy Entry Reporting System - PERS )

Technologies Used: SQL, DB2, IDMS, JCL, CICS, COBOL, REXX, SPUFI, QMF, abend-aid-viewer.

Tools Used: Micro Focus Rumba, Service Now, Splunk, Zeke, endevor, xpeditor, IBM Data Studio, Eclipse IDE.

Responsibility:

• Proposed on End-to-End automation of Health plan edit process, which helped in 100% reduction in manual effort and 95% reduction in TAT.
• Modernized incident handling procedures, leading to a 25% reduction in average resolution time and improved system availability for critical mainframe applications supporting 9000,000+ active users.
• Have worked on a new batch process which sends data to downstream applications for a newly installed cases, as worked in PERS team.
• Handling schid monitoring (batch jobs), ABEND resolution, ADHOC requests.
• Works with the incidents, tasks which generally involves data validation and data correction if required so that it is processed by the system without any error.
• Configured & upgraded module code for application to decrease 40% daily issues.
• Have created jobs newly which generates a monthly and daily report which is uploaded to a server, JCL and DFSORT utilities and DB2 was used to create this job.
• Have developed jobs from scratch, where a daily report is sent to LEAP involving different tables, where data is inserted in MYSQL Database and it is reflecting in a real-time.
• Have written a Cobol module to remove erroneous records from the database which was run using a request batch jobs.
• Played role of SME for all kinds of client request on report pulling of customized request.