Senthilkumar Ulaganathan

adcoqw@r.postjobfree.com

+1-248-***-****

Objective:

Seeking a challenging career where I can implement my innovative skills and develop myself professionally and effectively contribute towards the goals of an organization. Also anticipating a job where my strengths can be driven from my hard work and honesty. Professional Summary

● 9+ years experience in the IT industry out of which 5 years worked in USA and continued working in the USA

● Experience in IMS online screen creation, Testing and support.

● Experience in COBOL, PLI, SAS, REXX Development, Testing and deployment.

● Experience in DB2 Queries and IMS -DC call.

● Hands on experience in CICS.

● Experience in creating Dashboard, Alert, Report and Tickets on SPLUNK tool

● Hands on experience in REXX - Created few panels for our application to make our work easier.

● Hands on experience in SOAP Web services and RESTful web services.

● Hands on experience in JavaScript, Jquery, Spring-MVC framework and Spring Boot. Skill Set:

Languages PLI,EPLI, COBOL, C, C++, C#,

.NET,JAVA,REXX,SAS,JQUERY,HTML,XML

Database Db2, IMS, SQL

Other skills IMS-DC,CICS, GUI, SPLUNK,INFORMATICA, WINDOWS, MS-OFFICE,JAVASCRIPT

EDUCATIONAL QUALIFICATION:

Academics YEAR OF GRADUATION INSTITUTION

Bachelor of Engineering in

Electronics and communication

engineering

2008 ArulMigu Meenakshi Amman

College of Engineering,

Kanchipuram

Certification

● Certified in .NET and SQL at NIIT chennai.

● Certified in C and C++.

Achievements:

● Three times awarded as employer of month.

● Innovative ideas have been recognized by our client and awarded a couple of times as star performer.

Professional Experience

PROJECT : CRI LEGACY CONVERSION - WEB SERVICES

CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : JAN 2017 TO TILL DATE (USA)

Role : Programmer Analyst(Java Developer)

Description:

This project was started to convert the CRI part of legacy code into web services within our application. My Roles and Responsibilities:

● Converted the legacy code into Java.

● Code the existing CICS gateway program in our application to call the new web service

● Created the unit testing scenarios using JUNIT

● Unit Tested the new web services using SOAPUI tool.

● supported the System test

● Middleware - MuleSoft using anypoint platform

Environment : We developed the Coding using STS IDE for JAVA, and we unit tested the webservices classes using JUNIT and tested overall SOAP web services using SOAP UI tool. We used GITLAB to push the changes to server.

Languages JAVA

Databases DB2

Tools Handled IBM- RATIONAL DEVELOPER, SOAP UI,

STS,GIT,POSTMAN

PROJECT : AMP PORTAL DEVELOPMENT

CLIENT : HTC IN HOUSE PROJECT

EMPLOYER : HTC GLOBAL SERVICES

DURATION : FEB 2016 TO TILL DATE (USA)

Role : Programmer Analyst(Java Developer)

Description:

This is the IN-house HTC project. this is the website used to log the hours of HTC employees hour billing for each client and also contains the information about the each employer within HTC. My Roles and Responsibilities:

● Created the some of UI using JSP.

● Enhanced the existing UI page and fixed some of the issues.

● Created Rest and SOAP webservices to do the certain functionality

● This is the application based on SPRING-MVC framework

● Created the unit testing scenarios using JUNIT

● Unit Tested the new web services using SOAPUI tool and POSTMAN.

● supporting the page and other issues within this website.

● Middleware - Mulesoft using Anypoint Platform.

Environment : We developed the Coding using STS IDE and we unit tested the webservices classes using JUNIT and tested overall SOAP web services using SOAP UI tool. We used GITLAB to push the changes to server.

Languages JAVA

Databases Postgres

Tools Handled IBM- RATIONAL DEVELOPER, SOAP UI,

STS,GIT,POSTMAN.

PROJECT : VA HOH CHANGES

CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : JAN 2019 TO TILL DATE (USA)

Role : Programmer Analyst

Description:

This project was started due to the legal changes within the state of Viurginia, whenever the Head of household leaves the policy group for someone and someone from that household needs to be changed as head of household so the score will be changed and need to apply the credit neutral score for the new head of household in order to maintain the charges for renewal or backdated changes. My Roles and Responsibilities:

● worked on the low level design ( component specification)

● coded the online and batch program changes-

● Created the unit testing scenarios.

● Unit Tested the batch EDB (Job) and online program through online screens

● supported the System test

● Coordinated the issuance (includes technical and functional checkout) Environment:

This project is with mainframe platform where it involved PLI module changes and we have developed new scratch code using PLI standard and we enhanced some changes in some JCL (jobs) and we implemented SAS in some JCLS.

Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load library SFCOBB- Cobol module compilation macros within statefarm SHOWME- Macro for expanding formatted copybook structures. PREP - To review the JCL and looks for any error.

Languages PLI,JCL,SAS

Databases DB2, IMS

Tools TSO DB2, TSO FMDB2, TSO BMCDB2, TSO SPUFI, TSO APPTUNE, TSO CDCOPY, TSO SEND, TSO AUTHID,

TSO SHRFILES, TSO MQUERY, TSO FMBASE, TSO

BTSTSO, JES, SDSF, TSO ROVR, TSO IDZ, TSO CWF,

TSO RAJA,

MACROS PREP, SHOWME, SFPLIB, SFLB, SFCOBB

PROJECT : 80X-95O AUTOMATION

CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : APRIL 2018 TO JAN 2019 ( USA )

Role : Programmer Analyst( Lead Developer)

Description:

This project was started due to numerous 80x and 95O errors were produced in Household production application, where those errors need to be fixed by completing the EDB entries daily, so it will consume more no of operation time so we decided to automate those errors to complete the EDB entries. We have integrated this automation with one of the similar automation error. My Roles and Responsibilities:

● worked on the low level design ( component specification)

● coded the online and batch program changes

● Created the unit testing scenarios.

● Unit Tested the batch EDB (Job) and online program through online screens

● supported the System test

● Coordinated the issuance (includes technical and functional checkout) Environment:

This project is with mainframe platform where it involved PLI module changes,some Cobol Module changes and we enhanced some changes in some JCL (jobs) as per the requirement and we implemented SAS changes in some JCLS.

Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load library SFCOBB- Cobol module compilation macros within statefarm SHOWME- Macro for expanding formatted copybook structures. PREP - To review the JCL and looks for any error.

Languages PLI,JCL,SAS

Databases DB2, IMS

Tools TSO DB2, TSO FMDB2, TSO BMCDB2, TSO SPUFI, TSO APPTUNE, TSO CDCOPY, TSO SEND, TSO AUTHID,

TSO SHRFILES, TSO MQUERY, TSO FMBASE, TSO

BTSTSO, JES, SDSF, TSO ROVR, TSO IDZ, TSO CWF,

TSO RAJA,

MACROS PREP, SHOWME, SFPLIB, SFLB, SFCOBB

PROJECT : TEXAS WINDSTORM

CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : JAN 2018 TO APRIL 2018 (USA)

Role : Programmer Analyst(Lead Developer)

Description:

Texas windstorm project was started to charge the policy holder whose address in surcharge area. This was considered due to the natural disasters like any cyclones that damages the entire area. considering the risk of surcharge area the policy holders lives in those area will be charged more than normal rate. we had online screen changes, online program changes and batch program changes. My Roles and Responsibilities:

● worked on the low level design ( component specification)

● coded the online and batch program changes

● Created the unit testing scenarios.

● Unit Tested the batch EDB (Job) and online program through online screens

● supported the System test

● Coordinated the issuance (includes technical and functional checkout) Environment:

This project is with mainframe platform where it involved PLI module changes, screen format changes

(MFS)

Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load library SFCOBB- Cobol module compilation macros within statefarm SHOWME- Macro for expanding formatted copybook structures. PREP - To review the JCL and looks for any error.

Languages PLI,JCL

Databases DB2, IMS

Tools TSO DB2, TSO FMDB2, TSO BMCDB2, TSO SPUFI, TSO APPTUNE, TSO CDCOPY, TSO SEND, TSO AUTHID,

TSO SHRFILES, TSO MQUERY, TSO FMBASE, TSO

BTSTSO, JES, SDSF, TSO ROVR, TSO IDZ, TSO CWF,

TSO RAJA,

MACROS PREP, SHOWME, SFPLIB, SFLB, SFCOBB

PROJECT : CVAM - California vehicle Annual Mileage CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : FEB 2018 TO APRIL 2018 (USA)

Role : Programmer Analyst(Lead Developer)

Description:

This project was started to drop the telematics fields on the EDB screen and to drop the discounts on California state alone. for this project we had online screen changes, online program changes and batch program changes.

My Roles and Responsibilities:

● worked on the low level design ( component specification)

● coded the online and batch program changes

● Created the unit testing scenarios.

● Unit Tested the batch EDB (Job) and online program through online screens

● supported the System test

● Coordinated the issuance (includes technical and functional checkout) Environment:

This project is with mainframe platform where it involved PLI module changes and we have developed new scratch code using PLI standard and we enhanced some changes in some JCL (jobs) and we implemented SAS in some JCLS.

Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load library SFCOBB- Cobol module compilation macros within statefarm SHOWME- Macro for expanding formatted copybook structures. PREP - To review the JCL and looks for any error.

Languages PLI,JCL

Databases DB2, IMS

Tools TSO DB2, TSO FMDB2, TSO BMCDB2, TSO SPUFI, TSO APPTUNE, TSO CDCOPY, TSO SEND, TSO AUTHID,

TSO SHRFILES, TSO MQUERY, TSO FMBASE, TSO

BTSTSO, JES, SDSF, TSO ROVR, TSO IDZ, TSO CWF,

TSO RAJA,

MACROS PREP, SHOWME, SFPLIB, SFLB, SFCOBB

PROJECT : ARPM- AUTO RENEWAL PROCESS MANAGEMENT

CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : FEB 2016 TO JAN 2018 (USA)

Role : Programmer Analyst

Description:

Auto Renewal process management was used to apply the score correction and renewal score on the new business term policy and renewal policy. A renewal term can be on TOOF date or XDATE or might be suspended. we need to consider all these criteria on this project. we had only program changes online and batch program to make this requirement effective in production. My Roles and Responsibilities:

● worked on the high level design ( requirement gathering)

● worked on low level design ( component specification)

● coded the online and batch program changes

● Created the unit testing scenarios.

● Unit Tested the batch EDB (Job) and online program through online screens

● supported the System test

● Coordinated the issuance (includes technical and functional checkout) Environment:

This project is with mainframe platform where it involved PLI module changes and we have developed new scratch code using PLI standard and we enhanced some changes in some JCL (jobs) and we implemented SAS in some JCLS.

Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load library SFCOBB- Cobol module compilation macros within statefarm SHOWME- Macro for expanding formatted copybook structures. PREP - To review the JCL and looks for any error.

Languages PLI,JCL

Databases DB2, IMS

Tools TSO DB2, TSO FMDB2, TSO BMCDB2, TSO SPUFI, TSO APPTUNE, TSO CDCOPY, TSO SEND, TSO AUTHID,

TSO SHRFILES, TSO MQUERY, TSO FMBASE, TSO

BTSTSO, JES, SDSF, TSO ROVR, TSO IDZ, TSO CWF,

TSO RAJA,

MACROS PREP, SHOWME, SFPLIB, SFLB, SFCOBB

PROJECT : ECF - EXTENDED CUSTOMER FACTOR

CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : JULY 2015 TO FEB 2016 (USA)

Role : Programmer Analyst

Description:

ECF Project was started to apply loyalty customer discount and multicar discount to the existing policies of state farm. To apply these discounts we had program changes. These changes were generic and applicable to all the state offices of state farm. we had online and batch program changes to make this requirement effective in production.

My Roles and Responsibilities:

● worked on the low level design ( component specification)

● coded the online and batch program changes

● Created the unit testing scenarios.

● Unit Tested the batch EDB (Job) and online program through online screens

● supported the System test

● Coordinated the issuance (includes technical and functional checkout) Environment:

This project is with mainframe platform where it involved PLI module changes and we have developed new scratch code using PLI standard and we enhanced some changes in some JCL (jobs) and we implemented SAS in some JCLS.

Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load library SFCOBB- Cobol module compilation macros within statefarm SHOWME- Macro for expanding formatted copybook structures. PREP - To review the JCL and looks for any error.

Languages PLI,JCL,SAS,COBOL,STORED PROCEDURE

Databases DB2, IMS

Tools TSO DB2, TSO FMDB2, TSO BMCDB2, TSO SPUFI, TSO APPTUNE, TSO CDCOPY, TSO SEND, TSO AUTHID,

TSO SHRFILES, TSO MQUERY, TSO FMBASE, TSO

BTSTSO, JES, SDSF, TSO ROVR, TO IDZ, TSO CWF, TSO

RAJA,

MACROS PREP, SHOWME, SFPLIB, SFLB, SFCOBB

PROJECT : REFUND EFFORTS

CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : SEP 2014 TO JULY 2015 (USA)

Role : Programmer Analyst

Description:

This Refund effort will be executed to process the refund on backdated terms, sometimes if there is any code issue or data issue happened in EDB application we might calculate the premiums wrongly. To refund those miscalculated premiums state farm has created separate team to initiate the refunds on back dated terms through BATCH EDB. my role is to work closely with the refund team and make changes on the BATCH EDB program to process those refunds.

My Roles and Responsibilities:

● worked on the low level design ( component specification)

● coded the batch program changes

● Created the unit testing scenarios.

● Unit Tested the batch EDB (Job)

● supported the System test

● Coordinated the issuance (includes technical and functional checkout) Environment:

This project is with mainframe platform where it involved PLI module changes,COBOL changes and Stored procedure changes and we have developed new scratch code using PLI standard and we enhanced some changes in some JCL (jobs) and we implemented SAS in some JCLS. Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load library SFCOBB- Cobol module compilation macros within statefarm SHOWME- Macro for expanding formatted copybook structures. PREP - To review the JCL and looks for any error.

Languages PLI,JCL,SAS,COBOL,STORED PROCEDURE

Databases DB2, IMS

Tools TSO DB2, TSO FMDB2, TSO BMCDB2, TSO SPUFI, TSO APPTUNE, TSO CDCOPY, TSO SEND, TSO AUTHID,

TSO SHRFILES, TSO MQUERY, TSO FMBASE, TSO

BTSTSO, JES, SDSF, TSO ROVR, TSO IDZ, TSO CWF,

TSO RAJA,

MACROS PREP, SHOWME, SFPLIB, SFLB, SFCOBB

PROJECT : CANADA MIGRATION

CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : OCT 2014 TO JULY 2015 (USA)

Role : Programmer Analyst

Description:

This project was started to sunset the office of canada from state farm to some other company. State farm is no more holding the Canada offices. so all the policies term renewals will be in new company. In order to accomplish this we need to make changes to our online and batch program to obsolete some part of code, since the policy refund on the backdated terms will still happen within state farm. My Roles and Responsibilities:

● worked on the low level design ( component specification)

● coded the online and batch program changes

● Created the unit testing scenarios.

● Unit Tested the batch EDB (Job) and online program through online screens

● supported the System test

● Coordinated the issuance (includes technical and functional checkout) Environment:

This project is with mainframe platform where it involved PLI module changes,COBOL module changes and some Stored procedure changes we enhanced some changes in some JCL (jobs) and we implemented SAS in some JCLS.

Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load library SFCOBB- Cobol module compilation macros within statefarm SHOWME- Macro for expanding formatted copybook structures. PREP - To review the JCL and looks for any error.

Languages PLI,JCL,SAS,COBOL,STORED PROCEDURE

Databases DB2, IMS

Tools TSO DB2, TSO FMDB2, TSO BMCDB2, TSO SPUFI, TSO APPTUNE, TSO CDCOPY, TSO SEND, TSO AUTHID,

TSO SHRFILES, TSO MQUERY, TSO FMBASE, TSO

BTSTSO, JES, SDSF, TSO ROVR, TSO IDZ, TSO CWF,

TSO RAJA,

MACROS PREP, SHOWME, SFPLIB, SFLB, SFCOBB

PROJECT : TEXAS CONVERSION

CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : AUG 2013 TO SEP 2014 (INDIA-CHENNAI)

Role : SENIOR SOFTWARE DEVELOPMENT ENGINEER

Description:

Texas conversion project was initiated only for Texas offices where the texas policies were converted to new class categories after the parm effective date. Any renewal terms that is renewed into Texas conversion parm considered as converted policy terms. For this project we had online screen changes to indicate the agent or zones for conversion. we had online and batch program changes to make these requirements effective on Texas.

My Roles and Responsibilities:

● worked on the low level design ( component specification)

● coded the screen changes and program changes

● Created the unit testing scenarios.

● Unit Tested the screen changes and programs

● supported the System test

● Coordinated the issuance (includes technical and functional checkout) Environment:

This project is with mainframe platform where it involved PLI module changes,Screen change (MFS) and some stored procedure changes and we have developed new scratch code using PLI standard Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load library SFCOBB- Cobol module compilation macros within statefarm SHOWME- Macro for expanding formatted copybook structures. PREP - To review the JCL and looks for any error.

Languages PLI,JCL,STORED PROCEDURE

Databases DB2, IMS

Tools TSO DB2, TSO FMDB2, TSO BMCDB2, TSO SPUFI, TSO APPTUNE, TSO CDCOPY, TSO SEND, TSO AUTHID,

TSO SHRFILES, TSO MQUERY, TSO FMBASE, TSO

BTSTSO, JES, SDSF, TSO ROVR, TSO IDZ, TSO CWF,

TSO RAJA, XPEDITOR

MACROS PREP, SHOWME, SFPLIB, SFLB, SFCOBB

PROJECT : RATING SIMPLIFICATION AND PROCESS ENHANCEMENT CLIENT : STATE FARM INSURANCE

EMPLOYER : HTC GLOBAL SERVICES

APPLICATION : AUTO-EDB

DURATION : MAY 2011 TO AUG 2013 (INDIA-CHENNAI)

Role : SOFTWARE DEVELOPMENT ENGINEER

Description:

Within state farm, a policy holder can have different types of vehicles. Earlier to this project all the auto policies were rated in the same category. In order to differentiate those vehicles state farm came up with class categories that determines those vehicle types and policy types. To Simplify the rating this project was kicked by state farm. In this project we introduced many new screens which is subscreens of main EDB QUOTE screens. we had many program changes on this project that includes online and batch programs. My Roles and Responsibilities:

● worked on low level design ( component specification)

● coded the program changes for both online and batch.

● Designed the new online screens

● Created the Unit testing scenarios document for both batch programs and online screen programs.

● Unit tested the online and batch programs..

● supported the system test environment

● Coordinated the issuance.(includes technical checkout) Environment:

This project is with mainframe platform where it involved PLI module changes, Screen changes, Cobol module changes, SAS changes in JCL and REXX panel creation to make our environment setup easier and we have developed new scratch code using PLI standard. Tool utilities:

TSO DB2 MENU- It’s shortcut to BMC utility where you go SPUFI to run the Db2 query and you can go to catalog manager to view the DB2 Databases status,collections, packages and Plan binds etc. TSO FMDB2 - Tool used to query the Db2 table data - EDIT, COPY, VIEW options available TSO SPUFI - We run our own Db2 Query in SPUFI it will access our local tables. TSO Apptune- This tool is used to capture any db2 error that occurs in the application. This tool will be used when testing the IMS or Batch application.

TSO MQUERY- This is Statefarm tool used to update the production table data TSO AUTHID- This tool is used to check the access for the AUTHID TSO ROVR - Used for Deployment activities

TSO BTSTSO- This tool is used to simulate the IMS screen as it is in production. but still we need to allocate IMS databases and set up DB2 binds and PLAN binds as well. SFPLIB- PLI module compilation macros within statefarm. SFLB- it will link the PLI program and creates the load

Contact this candidate