Application Development Us Citizen

BHASKAR REDDICHERLA

**** ***** **** ******, ******** city, MD

Employment status : US Citizen

Objective

Seeking a professional position in the areas of design and application development, which utilizes my technical expertise and problem solving skills.

Summary

Over 20 years of experience in SDLC and implementation of business applications in MVS Mainframes Environment.

Strong in design and development of software applications using IBM Mainframe, IMS, DB2 and COBOL.

Extensively worked in Insurance, Manufacturing, Transportation, and Welfare domain applications.

Expertise in using Dynamic SQL and stored Procedures.

Worked as Lead in different areas of SDLC.

Extensively involved in running Batch programs in production environment, migrating programs to test and production and control M scheduling.

Trained in and exposed to IBM 3090, IBM ES/9000 standards.

Expertise in using Dynamic Sql and Stored Procedures.

Good Programming and Communication Skills with excellent work ethics, easy adaptability to demanding time schedules coupled with positive user interaction and excellent team spirit. Exceptional ability to quickly master new concepts.

Coordinated with other Analysts working in government agencies like FACTS, PEIA and MMIS regarding the project work and enhancements.

Worked extensively in Production Support and Batch on Call.

Skill Set Experience

COBOL 20 years of experience with COBOL, including 7 years with MF COBOL

DB2 20 years of experience with DB2 in a large scale system, in coding SQL’S

for batch and online programs, wrote stored procedures, including 16 years with

DB2. .

CICS 17 years of experience with CICS in a large-scale system, including 6 years

With CICS ver 3.1, 2 years with CICS ver 4.1.

JCL 16 years of experience with TSO/ISPF, JCL in a large scale system.

TSO 17 years of experience.

TELON 12 years of experience.

INSTALL-1 2 years of experience.

PRINCETON 2 years of experience.

CHANGEMAN 15 years of experience

PANVALET 4 years of experience

QMF & SPUFI 16 years.

PLATINUM 10 years

MAINFRAME EXPRESS & COOLBIZ 4 years.

Technical Skills

Hardware: IBM 3090, IBM PC/586, and IBM ES/9000.

Operating Systems: MVS / ESA, Z/OS, DOS, UNIX, Windows XP/2000/NT/98/95.

Languages: MF COBOL, VS COBOLII, FORTRAN.

Databases: DB2 (V9.0), DB2 UDB, ORACLE, SQL SERVER, SQL.

OLTP: CICS, TELON (V3.0).

Others: VSAM, PL/1, JCL, QMF, BASIC, SPUFI, TSO, C, C++,CLIST, PLATINUM, INTERTEST, AS400, UNIX, CHANGEMAN, FILE-AID, INFORMATICA, TERADATA, ABEND-AID, XPEDITOR, REXX, MOBIUS, QUALITY CENTER, HP SERVICE CENTER, CA-7, MSOFFICE, SAS, SAR, PANVALET, MAINFRAME EXPRESS, IMS DB/DC, JAVA, J2EE, STARTOOLS (V7.4), MVS, JCL, BMC UTILITIES, IBM UTILITIES, REMEDY, FILE MANAGER, EXPEDITOR, CLARITY, BUSINESS OBJECTS, TIBCO, FILENET, XML, ERWIN, SQL,INFORMATICA,ORACLE,COOLBIZ, CONTROL –M, XPEDITER, MQ SERIES, MF DIALOG, DB2CONNECT, COOLGEN, EASYTRIEVE PLUS, TDD, PDD,WEBSERVICES, OMNIPAY, OMNIPLUS,HARVEST,WEBSPHERE and MS VISIO.

Professional Experience

HOUSING URBAN DEVELOPMEMT Nov 2023 – July 2025

Sr Programmer Analyst/ Technical Lead

CACI, Washington DC

The HUD Central Accounting Program System (HUDCAPS) for purposes of disbursing previously obligated funds for section 8 tenant-based rental assistance (Housing Assistance Payments and Administrative Fees). A PHA’s HUD-held Housing Assistance Payments (HAP) reserves may be requested (or may be automatically disbursed) to address emergency situations, including where families are at risk or terminations of assistance or where PHAs cannot afford to pay their contractual Housing Assistance Payments to Owners.

Responsibility:

Interacts with management and team members, monitoring and communicating the progress.

Involve in gathering detailed requirements.

Key tasks included communication of project status, issues, development and unittesting.

Working as Senior mainframe developer.

Worked on Production support tickets.

Developed and enhanced Mainframe applications using Coolgen.

Worked on tickets and promote code in Endevor..

Worked on Coolgen's debugging tools to identify issues in the generated code and ensure everything works correctly.

Designs systems and programs to meet complex business needs.

Assists management in preparing time estimates and justification for assigned tasks.

Measured project performance against planned and accommodating necessary adjustments to keep the project on schedule.

Software Environment: Mainframe,JCL, Cobol, SPUFI, QMF, Coolgen,REXX, CICS, DB2, File Aid, Websphere and Endevor.

STATE OF MISSOURI

Medicare Med adv Apr 2022 – Oct 2023

Sr Mainframe developer

The aim of the project is exchange the Medicare info for several customers to CMS on regular basis..

Responsibility:

Interacts with management and team members, monitoring and communicating the progress.

Involve in gathering detailed requirements from the users.

Key tasks included communication of project status, issues and risks.

Resource allocation for various modules and resolution of various issues.

Worked as Senior mainframe developer.

Worked on Production support tickets.

Worked on claims processing.

Worked on Adhoc tickets.

Worked on 837P, 837I, 835 File transfers to CMS.

Managed stakeholder expectations as well as scope changes through change control process.

Designs systems and programs to meet complex business needs.

Assists management in preparing time estimates and justification for assigned tasks.

Measured project performance against planned and accommodating necessary adjustments to keep the project on schedule.

Worked on coding DB2 tables using spufi.

Prepares detailed specifications from which programs are developed and coded.

Provide technical and functional guidance to the team members.

Ensures programs meet quality standards and technical specifications.

Performs technical analysis and component delivery.

Developed Business Logic Using Coolgen's modeling tools to define business processes and rules.

Excellent technical and analytical skills, with extensive experience and knowledge of Natural/ADABAS and IBM Mainframe Systems and newer experience with SQL Developer and Oracle SQL Developer, some Visual Studio.

Worked on informatica workflows to convert mainframe reports.

Managed identification, resolution and escalation of project risks and issues.

Conducts quality assurance activities such as peer reviews.

Track and resolve issues found during QA testing and identifying root cause of the problems.

Ensured end to end project success through out the SDLC process.

Made recommendations to top management on individual and team performances during performance appraisals.

Software Environment: Mainframe NATURAL, ADABAS, JCL, VS Cobol II, SPUFI, QMF, File Aid, RDX, Coolgen, Xpeditor, Endevor, Java, JDBC, MS Office, MS Visio, SharePoint, IBM Content Manager On Demand (CMOD V8.3),Informatica

STATE OF MARYLAND

Department of Human Resources Apr 2010 – Mar 2022

Customer Automated Resources and Eligibility System (CARES)

Medicaid Management Information Systems-MMIS

Technical Lead

The aim of the project is to implement Temporary Assistance for needy families, Medical Assistance and Supplemental Nutrition Assistance Programs of SSA.

Responsibility:

Interacts with management and team members, monitoring and communicating the progress.

Involve in gathering detailed requirements from the users.

Key tasks included communication of project status, issues and risks.

Resource allocation for various modules and resolution of various issues.

Works on Interface between CARES and MMIS.

Working as Senior mainframe developer.

Worked on TANF, SNAP programs.

Worked on PEBT,SEBT programs.

Working as Control-M Scheduler.

Worked on claims processing.

Worked on several customers and recipients.

Worked on monthly recon MMIS file.

Works on processing MMIS monthly files and creates necessary reports for the Users.

Managed stakeholder expectations as well as scope changes through change control process.

Designs systems and programs to meet complex business needs.

Assists management in preparing time estimates and justification for assigned tasks.

Measured project performance against planned and accommodating necessary adjustments to keep the project on schedule.

Worked on coding DB2 Stored Procedures.

Worked with Informatica mappings.

Worked on ADABAS files.

Worked on modifying Natural programs.

Worked on Interface with DMV files on Traffic information system.

Prepares detailed specifications from which programs are developed and coded.

Provide technical and functional guidance to the team members.

Ensures programs meet quality standards and technical specifications.

Performs technical analysis and component delivery.

Worked on IMS DB heirarchu tables.

Worked on IBM CMOD version 8,3 for batch programming and generate notices.

Managed identification, resolution and escalation of project risks and issues.

Conducts quality assurance activities such as peer reviews.

Design, install, configure, and manage WebSphere Application Server environments

Worked on Modelling the user interface (UI) for applications using Coolgen's GUI tools.

Worked on Coolgen to automatically generate the necessary code for the application, including the backend logic and user interface code.

Track and resolve issues found during QA testing and identifying root cause of the problems.

Ensured end to end project success through out the SDLC process.

Made recommendations to top management on individual and team performances during performance appraisals.

Software Environment: Mainframe MVS, CICS, JCL, VS Cobol II, SPUFI, QMF, File Aid, RDX, IMS DB, Xpeditor, Changeman, Coolgen, Natural, Adabas, Toad, Java, JDBC, MS Office, MS Visio, SharePoint, Clarity, WEBMETHODS, IBM Content Manager On Demand (CMOD V8.3),OPTIM,IOMNIPLUS, Coolgen, ADABAS, NATURAL, Informatica, ORACLE, REST/SOAP API, CICS Transaction gateway, TDD, PDD, Webservices,ServiceNow, Websphere and Control-M.

STATE OF INDIANA

Indiana Support Enforcement Tracking System (ISETS), Indianapolis, IN Nov 09 – Mar 10

Technical Lead

Indiana Department of Administration sought the services of System integrators to develop an automated data processing and information retrieval system to comply with the standards of the Family and Support Act of 1988. Basically dealing with Child support with directions from Child support Bureau.

Role :

Involved in Study, Design, Development and maintenance of existing applications that were developed in COBOL.

Involved in migration of software using change management tool Endevor.

Worked extensively on Stored procedures.

Worked on LOAD and UNLOAD utilities for data retrieval.

Worked on BMC utilities for Adhoc reports.

Involved in the production on-call support.

Developed online/batch programs using COBOL, DB2, VSAM and CICS.

Created JCLs for executing batch jobs.

Involved in testing of all the existing Daily, Weekly, Monthly, Request and Yearly Batch Job JCLs in QA and UAT environment.

Involved in Job scheduling activities using CA-7.

Involved in executing QA cycle and monitoring the cycle if any abend occurs.

Involved in transferring the files to and from the host using FTP utility.

Resolving the production problem logs that were created by the business users.

Created Test plans for the code conversions and did testing before it goes to the Quality Assurance team.

Involved in Unit, System & Integration testing for new applications.

Involved in creating documentations for testing.

Involved in writing Technical Design and Functional specifications based on the recent changes with the Business logics, which is the part of the billing maintenance.

Involved in writing COBOL MQ series programs.

Involved in fine tuning the existing DB2 Stored Procedures.

Involved in the software infrastructure changes testing during the weekends.

Environment: IBM S/390, OS/390, IBM Enterprise COBOL for z/OS and OS/390 3.1.1, JCL, DB2, CICS, VSAM, Telon,Changeman, Expeditor, QMF, DB2 Catalog Manager, SPUFI, Fileaid, CA-7,

Syncsort, SQLserver,Toad, Production Support for Batch Jobs.

Nationwide Insurance, Columbus (OH) Mar ’09 – Oct ‘09

Technical Lead

Claims Processing System (Commercial lines):

Nationwide Insurance develops and sells a diverse range of products, including Fire personal lines, Auto personal lines, and Commercial lines. The Company sells its products through nationwide agents. Unaffiliated entities that sell NI products to their own customer base include independent broker/dealers, brokerage firms, and financial institutions. Nationwide Insurance Company supports processing of claims in all the states of USA.

Claims Processing System (CPS) will process the Claims for Nationwide Insurance. CPS new claims and subsequent activity on the claims. CPS is the hub of the claims systems, providing claims data for most Nationwide systems as well as many external systems. This claims data is needed to support claims management as well as statistical and financial reporting. CPS also has interface with Claims Support System (CLASS) and Call Center Application (eCCAp). CLASS was built to support Claims Reps and field claims managers. CLASS cannot be used without CPS because it has no capability to set up new claims, to process recovery activity (salvage, subrogation, contributions) or to correct statistical errors. eCCAp was built to support the Livewire unit. eCCAp provides an alternate means of input to CPS in setting up most new claims on personal lines policies, CPS also supports new commercial claims and special situations on personal lines claims, but runs in a PC environment. However, eCCAp has no permanent storage of claims and it does not provide data to external systems. CPS receives new personal lines claims from eCCAp and sends new claims and subsequent activity to CLASS.

CPS stores and manages all of the claim information that is passed to it from various systems and interfaces

Responsibilities:

Analyzing system and creating technical design document.

Developed key modules, test plans, test scenarios. Prepared the complete test environment, include data preparation/verification preparation. Executed the system test runs, verified results and helped the client in approval process for each program.

Provide active and efficient ongoing system support by resolving all trouble tickets arising to client satisfaction. Delivered high quality work with practically no tickets returned for rework.

Coded stored procedures for online and batch programs.

Worked on DMV vehicle and traffic information exchange system.

Worked on Managing premium collection, invoicing, and payment processing in Ingenium tool. .

Worked on Batch programs in IBM CMOD and stored PDFs

Worked extensively on SOA Techniques

Worked on IMS DB programs.

Worked on Teradata utilities.

Performed complete impact analysis on system software due to suggested modifications/ enhancements and prepared detailed design documents identifying program and database design changes required for successful implementation of change module.

Worked extensively in XML for transferring the confidential customer’s data from one repository to another, user to user for getting tests results, etc.

Tracking the software from Dev region till the implementation.

Following the whole SDLC process for standard compliances.

Environment: VS COBOL- II, JCL, DB2(V9), Z/OS, VSAM, BATCH, CHANGEMAN, FILE-AID, RDX, SYNC-SORT, INFORMATICA POWER CENTER 8.1, INFORMATICA POWER EXCHANGE 8.1 (META DATA REPOSITORY, DESIGNER, TERADATA, SERVER MANAGER), ORACLE 8.X, ERWIN 3.2.5, IBM ANIMATOR, XPEDITOR, EASYTRIEVE, FAULT ANALYZER, HARVEST, TEST DIRECTOR, IBM UTILITIES, QTP, SAR, XML, MQ SERIES,JAVA, UNIX, BMC UTILITIES, J2EE, MF DIALOG, SOA, MS VISIO and CA-7, REST/SOAP API, WEBMETHODS,SQLSERVER, IBM CMOD, IMS DB,

SYNCSORT, DB2CONNECT, HP SERVICE CENTER, INGENIUM, WEB SERVICES, OMNIPAY, DOCUMERGE, OMNIPLUS,EDI, PRODUCTION SUPPORT FOR BATCH JOBS.

STATE OF OHIO

OPERS(Ohio Public Employees Retirement System ) Jan ’07 – Dec 08

Senior Programmer Analyst:

OPERS - Ohio Public Employee Retirement System has over 3000 employers and one of the best-run retirement systems in the United States. All public employees in the State of Ohio contributes a percentage of their earnable salary into OPERS, and their employers will also pay at a rate set by the board of OPERS. OPERS will invest these contributions and pay retirement, disability and health care benefits to the members at the retirement. It has got good tracking system on customer calls and also sends the correspondence letters to their Employers.

Employer Re-write Project

The nature of work involves the Enhancement, Maintenance, Development and testing. OPERS used to send the correspondence letters to all of their Employer’s main contact only and this was not effective process as it was not able to address it to a particular employer contact. This project gave the solution for this. It accepts multiple contacts with different addresses from an employer. The employer correspondence can be sent to the employer contacts based on the defined hierarchy’s and the type of a letter.

Tops Project

The nature of work involves the redesign of the system, which was in FOXRPO. The nature of the work involves development and testing.

HBL-562 Project

The nature of work involves the Development and testing. Each public employee contributes a percentage of the earnable salary, set by the public employees retirement board, not greater than ten per cent of the earnable salary. The head of each state department, institution, board and commission and the fiscal officer of each local authority shall deduct from the earnable salary of each contributor on every payroll.

A penalty shall be added when such report, together with warrants, checks or electronic payments to cover the total amount due from the earnable salary of all employees, is filed thirty or more days after the last day of such reporting period.

In the past, this penalty was charged at five per cent of the total member contribution amount of the report. HBL - 562 changed this penalty from a fixed five per cent to graduated scale.

GL Subsidiary project

The goal of this project is to provide the ability for finance staff to validate summary level transactions posted to the general ledger with the transaction detailed maintained in the subsidiary systems. The project would establish a direct link between subsidiary system transaction details and the general ledger summary level journal entries created from these transactions.

Responsibilities:

Analysis of the specifications provided.

Understanding of Business & it's requirements

Performing Impact analysis and Documentation.

Preparing Pseudo code for new Programs and Enhancements as well.

coding the Programs/modules as per the specifications.

Coding the Report Programs.

Fixing the production problems (PIR).

Coding the MANTXT Customer letter programs.

Coded new online programs in INSTALL/1 using MANTXT

Changed existing programs in INSTALL/1

Worked extensively on MANTEXT commands and Control instructions in INSTALL/1.

Worked on Performance tuning for DB2 programs.

Worked on DB2 Explain to increase the sql performance

Coding the Extract Programs to down load into spreadsheets via FTP.

Changing the existing programs as per the new project specifications.

Preparing Spufi's to insert and update the data according to requirements.

Preparing Spufi's to create spreadsheets in excel for different user requirements.

Coding new jcls for the jobs.

Expedited the programs extensively to figure out the bugs.

Preparing the test plans & Spufi's for evidence of the results.

Preparing the UTR documents using Green Bar.

Knowledge of OMNI tool.

Work on Production issues and fixing after debugging, testing.

Unit Testing, System Testing, Integration Testing & User Acceptance Testing & Sign - Off.

Prepare Migration Check list for production move.

Performing the reviews in each phase of the work.

Weekly Status Reporting to Management.

Participation in Team meetings and Defect preventive meetings.

Environment: COBOL, JCL, TSO, Z/OS, CICS, DB2 Ver(8), ENDEVOR, VSAM, ELIXIR, BATCH, JAVA, J2EE, FILE-AID, INSTALL-1, MANTXT, XPEDITOR, EASYTRIEVE, PRINCETON, JAVA, J2EE, DB2CONNECT, MS VISIO, BMC UTILITIES, JAVA, J2EE, MS OFFICE,OMNIPLUS,OMNIPAY, Toad, PRODUCTION SUPPORT FOR BATCH JOBS and CA-7.

Nationwide Insurance, Columbus (OH) Nov ’05 – Dec 06’

Lead Programmer Analyst

Policy and Rating (Personal lines):

The purpose of the NAPS System is the overall maintenance of insurance policies. it keeps track of all modifications done to insurance policies (namely additions, updates and deletions). It attempts to provide a framework for auto processing and other systems which can evolve into corporate systems supporting corporate customer approach to Nationwide’s insurance processing. Billing functions will be split out into a separate billing system (CBS), which will be capable of evolving into a corporate billing system.

Responsibilities:

Unit testing of Developed COBOL code with IBM Animator

Involved in the Design, development and testing of different AUTO projects

Used Test Director to test the application scripts.

Analyzing the requirements and getting clarifications for the Enhancements by direct communication with the clients and business analysts.

Prepared the detailed design and development of the programs from the scratch. Co-ordinate the Reviews and Walk through.

Development of the programs from the scratch. Co-ordinate the Reviews and Walk through.

Prepare Test Plan Specification and traceability matrix and conduct unit and regression testing in various testing environments.

Fixed production defects.

Changed programs batch and online

Worked om integrating with other systems like CRM, third-party vendors, and actuarial software in ingenium..

Worked to send the data from NAPS to AOA.

Made changes to the jcls during the database updates

Coordinated with different systems on different prod defects.

Work with Production Control Team for solving production bugs and tickets that are raised by application teams.

Worked as Production on call support primary contact.

Environment: VS COBOL- II, JCL, IMS DB/DC, DB2, BATCH, CHANGEMAN, VSAM, ELIXIR, FILE-AID, DB2CONNECT, SYNC-SORT, IBM ANIMATOR, XPEDITOR, FAULT ANALYZER, TEST DIRECTOR, HARVEST, QTP, SAR, MS VISIO, MF DIALOG, HP,INGENIUM, DOCUMERGE,SERVICE CENTER, PRODUCTION SUPPORT FOR BATCH JOBS, MOBIUS, OMNIPAY, EDI, OMNIPLUS, COOLGEN and CA-7.

Liberty Mutual Insurance, Indianapolis (IN) Sep ’04 – Sep ‘ 05

Lead Programmer Analyst

Regional Agency Markets (RAM): Commercial lines Management System (MECCA)

The purpose of the Mecca team is to provide the insurance data to BMV’s of different states.

Commercial Lines Policy Admin and Management system component. Manages reinsurance, policy detail including history, transaction management including automatic renewals, productivity reports and policy issuance and controls.

This system works in coordination with Personal lines (PLS) which exchanges policy data. The Polices with New business, Renewals and Endorsements are send to different BMV's. The Workers comp data is send to different states like PA, NY, DE, MA and MN on a weekly basis. We provide quarterly policy second injury fund report to Connecticut state. And we also provide workers comp annual reports to KY..

Responsibilities:

Analyzing the requirements and getting clarifications for the Enhancements by direct communication with the clients and business analysts.

Worked as a lead analyst and coordinated with offshore team.

Prepare the detailed design and development of the programs from the scratch. Co-ordinate the Reviews and Walk through.

Development of the programs from the scratch. Co-ordinate the Reviews and Walk through.

Prepare Test Plan Specification and traceability matrix and conduct unit and regression testing in various testing environments.

Code SQL’s whenever needed by the business to provide necessary data and create reports

Fix production defects for all the BMV interface programs.

Involved in Performance tuning of complex sql’s

Involved in Tuning of Sql’s.

Worked on DMV traffic system interface.

Worked in DOCUMERGE for printing forms.

Messages are received using MQ calls.

Worked on Runtime improvements, Loads and unloads.

Coded programs batch and online

Worked on creating MOBIUS Reports

Worked in SAS to send the data from Mecca to other DMV’s.

Made changes to all the jcls during the upgradation

Coordinated with SAS team in upgradation of the SAS

Co-ordinate and manage the team at offshore.

Responsible for all Telon Batch and Online Agency and Client programs.

Work with Production Control Team for solving production bugs and tickets that are raised by other application teams.

Release coordinator for monthly releases and on call primary contact.

Environment: VS COBOL- II, CICS, JCL, DB2, VSAM, TELON, ENDEVOR, DB2 STORED PROCEDURES,

INFORMATICA POWER CENTER 6.1/7.1 (META DATA REPOSITORY, DESIGNER, SERVER MANAGER), ORACLE8.X, ERWIN 3.2.5, WinNT & UNIX,TERADATA, MQ SERIES, RATIONAL, CLEAR CASE, CLEAR QUEST, RUP, SAS, CA-7, FTP, XSTROBE, SPUFI, ISPF, QMF, VISIO, BATCH, XPEDITER, DB2CONNECT, EASYTRIEVE, FILE-AID, PRODUCTION SUPPORT FOR BATCH JOBS, FA4DB2, HP SERVICE CENTER, DOCUMERGE,MOBIUS and MVS OS/390

Forethought Financial Services(Batesville, IN) Feb ‘04 – Aug ‘04

Project: Migration from Mantis to COBOL

Role: Development and Maintenance

Involved in Analysis, Coding and Testing of MANTIS programs.

Batch & On-Line Production Support using Manage Now and Fixing the Production abends.

Develop and maintain MANTIS, CICS and batch applications accessing SQL database and VSAM files.

Modified and tested batch DB2, MANTIS programs and job streams.

Used concepts of MESSAGE QUEUING. Elementary Data Items, Structures

And Commands. Used different object types, queues managers, queues and

Channels. Coded MQ calls in COBOL programs.

Worked on INGENIUM tool.

Invoked application using triggers processing. Used remote applications to communicate in Distributed Queuing in an MVS environment.

Worked on INGENIUM tool in Policy management.

Worked on Automating claims processing, settlement, and reporting with Ingenium tool. .

Unit testing of Upgraded COBOL code with Xpediter/TSO and Xpediter/CICS.

Wrote I/O MODULES for Batch & online programs.

Developed and enhanced the programs as per the new business Requirements.

VSAM KSDS datasets were created for faster access.

Created and loaded test data using File-aid, SPUFI and QMF.

Provided operations support during batch process, problem resolution, production program moves, Create packages, Checkout, Stating, Promoting, Auditing, Freezing packages, installing into production with Change-Man.

Used IBM Utilities to allocate new datasets; catalog datasets; compress datasets, dataset information, and copy/move datasets, dataset Matching etc.

Joined tables by using co-related/nested sub queries to collect related information from more than one table by using SPUFI.

Worked on MQ queing in data retrieval from one system to other.

Worked on Unix shell scripting.

Worked on IT requests and solved them.

Did Manual testing and QA testing

Write dynamic SQLs by using QMF.

Worked on creating MOBIUS Reports

Created JCL to load and unload DB2 tables using IBM utilities.

Maintenance to COBOL reports, including use of SYNCSORT and JCL changes.

Created JCL framework to permit execution of client jobs.

Coded JCL’S using SAS for the data passage between different systems.

Environment: Windows 2000, JCL, FILEAID, OPC, COBOL, DB2, CHANGE-MAN, SAS, VSAM, CICS, INGENIUM, (Java-JDK1.2), MQ SERIES, Java script, HTML, SPUFI, TSO, QMF, SUPER CE, RATIONAL, VISIO, MANTIS, MOBIUS, CA-7, UNIX, PERL, LOTUS NOTES, and XPEDITOR.

STATE OF WEST VIRGINIA

Programmer Analyst: Deloitte Consulting (Jun ‘97 – Jan ’04)

Client: West Virginia State Department of Health and Human Resource Department.

Description:

RAPIDS is the Recipient Automated Payment and Information Data System. The function is to provide quality services in a manner that project, and assists families and individuals who are eligible for those economic, social and medical programs recognized by federal and state statutes. The RAPIDS PROJECT is a division of the Bureau for Children and Families, which manages the RAPIDS database system. The RAPIDS system (Recipient Automated Payment Information Data Systems) is West Virginia's eligibility determination and benefit calculation system. The RAPIDS data system calculates eligibility for state and federal assistance programs administered by the WV Department of Health and Human Resources, including Food Stamps, Medicaid, CHIP (Children's Health Insurance Program), cash benefits, welfare to work assistance, heating assistance, and emergency assistance benefits.

Data Exchange

Worked on several data exchange programs .This Sub-system exchanges data from several agencies. The frequency of the files varies like daily, weekly, monthly, quarterly etc

Responsibilities:

Participating in client requirement discussions.

Generating Ad-hoc reports to the users.

Worked extensively on Micro focus cobol.

Designing and modifying program specifications.

Impact Analysis done for the new requirements.

Worked on exchange of daily, weekly, monthly Recon files from MMIS.

Coding new and modifying existing online and batch programs.

Unit testing and Integration testing.

Worked on data transfer using XML.

Modifying Screens using TELON.

Developed Script files, which contains generalized script functions written in JavaScript, which are utilized

Contact this candidate