Summary

Overview

Work History

Education

Skills

Personal Information

Work Preference

Timeline

Ajay Vivek S. Pillai

Summary

Senior RPGILE/Data Architect with proven expertise in system performance optimization and API enhancement at FCBT. Skilled in RPG/400 and SQL, delivering effective solutions that boost operational efficiency and data processing. Strong problem-solving abilities lead to significant improvements in system functionality.

Overview

years of professional experience

Work History

Senior RPGILE/Data Architect

FCBT

Austin

05.2018 - Current

As a contract employee and currently a full-time employee of FCBT, I am working in the development and maintenance of the FCBT cardinal banking system.
Responsibilities:
Worked to understand the business logic in the cardinal application on iSeries and fulfill the user change requests.
Created the design and specifications for automating the restoration of libraries and environments from tape.
Worked on developing and enhancing external API function calls using XML interfacing.
Working on improving the system's performance by using multiple programming techniques and integrating multiple jobs into one stream.
Created UDFs and stored procedures for better performance functions.
Created multiple indexes, modified programs using modern SQL principles to increase program performance.
Worked both as an IBM I admin with the PTFs and in the operational aspects, including saves and restores of libraries.
Worked on the Databricks platform to ingest data from the IBMi tables to user reporting applications as part of the data warehouse modernization.
Environment: iSeries, RPG/400, RPGILE, DB2/400, AS400, Embedded SQL, Turnover, RPGILE free format, IBM RDI, XML, Databricks.

Senior Technical Lead

Pharmerica

Tampa

06.2017 - 04.2018

Pharmerica is a major player in the LTC medical care supplies. They develop and maintain the entire suite of screens and reports for clients including retirement communities and LTC nursing facilitates providing facility, residents, financial plan maintenance, drug fulfillment process with adjudication, financial reporting, invoicing/billing for the clients and other benefit care management practices.
Responsibilities:
Worked on implementing the Retrospective billing process which involved adding multiple screens and corresponding menu options to access the new screen functions.
Batch programs are created to process the data captured in an orderly manner to complete the full functionality for the billing project.
Designed and created new process to implement PVT billing transferred to SAP which involved creating multiple programs to send the resident, billing and Open A/R info corresponding to the facilities for the SAP activation is made as separate files to SAP thru FTP process
Environment: iSeries, RPG/400, RPGILE, DB2/400, AS400, Embedded SQL & Aldon, RPGILE free format, IBM RDI

RPGLE PROGRAMMER

Frontier Communication

Plano

10.2014 - 06.2017

As an employee of Anji Tech., Worked for Frontier Communications one of the biggest telecommunication companies. The project involves working in the Customer billing part. This includes converting the AT&T and Verizon historical as well as current billing/customer/plant data from more than 150 sources into frontier system. After conversion all the existing functions in the application needs to work as intended. Data of the range 30-40 GB of will be received per quarter which needs to be processed and converted into the host system within 12-14 hours window.
Responsibilities :
Converted the data extract received from AT&T, either in one of the format like Text/IMS unload/ CSV/flat files or as stream files into DB2 for further processing. There were custom commands as well as RPG programs created for the same. The programs are created, hence it can be reused for most of the formats/sources with minimum changes
Worked to improve the performance of the conversion engine using multi-threading and distributed processing
The existing billing/conversion programs have been modified to handle very large amounts of extract data during landing as well as to reduce the conversion run times by using embedded SQL and other data handling techniques
Worked on a wide range of RPGILE programs involving SQL and multiple modules which also handles various type/format of data with proper error handling/conversions
Worked on all the data/processing techniques for faster processing of huge amounts of data
Obtained lot of knowledge on the telecom billing/plant systems
Worked on programs which are having multiple levels of module/service program calls and validations
Worked on Java process using spring boot framework for address validation using external API’s
Environment: iSeries, RPG/400, RPGILE, DB2/400, AS400, SQL and Turnover, RPGILE free format, Embedded SQL, Java Spring boot, Python, X-Analysis

AS400 L3 Analyst

CVS Caremark

Richardson

09.2012 - 10.2014

As an employee of Wipro, Involved in the project RxClaim Adjudication for the client CVS Caremark, an American drug retailing company with a U.S. pharmacy chain. This provides pharmacy benefit management. RxClaim is the primary PBM application used by CVS Caremark. The PBM application handles millions of claims per months which generate lot of claim data for processing
Responsibilities :
Provided L3(Code enhancements/testing) for CVS PBM system – RxClaim Adjudication Part
Monitored and error fixing as part of production support of the modules moved
Generated reports using SEQUEL or WRKQRY for Users/Clients for their analysis or audit purpose Also automated the report so as to allow the business groups to directly generate them
Provided quick analysis/work around for high critical issues having very high financial as well as legal deadlines
Obtained a good knowledge of PBM systems including eligibility, plan set up, pricing, reporting and core adjudication (claim processing)
Worked in analyzing and finding the issues in complex claim processing/plan set up screen having lot of user exit points and external function calls
Environment: Synon ,iSeries, RPGILE, RPGIV (free format), Aldon, SEU, SDA, DFU, AS/400, Cobol/400, CL/400, SQL/400, ISDB, BODERICK, ABSTRACT, Maestro Job scheduler

AS400 SUPPORT ANALYST

Sears Holdings Inc.

Hoffman Estates

01.2012 - 09.2012

As an employee of Intellisoft, Worked for the project Kmart grocery system. The Kmart grocery system is part of the Super K format of the Kmart stores. The system has lot of interaction with external systems including mainframes, IRI Neilson (for marketing feedback), Catalina (for coupon generation). The various reports/transactions are sent to various stores via EDI.
Responsibilities :
Provided production Support for the batch jobs/online transaction processing of the grocery system under stringent SLA norms
Prepared critical job flow for the major jobs in the application
Coordinated with business groups and plan rolling releases, production moves, QA and System Testing
Environment: RPGILE, RPGIV (free format), iSeries, COBOL/400, CL/400, SQL/400 and Embedded SQL

SOFTWARE ENGINEER

Marsh & McLennan Company

Des Moines

05.2010 - 01.2012

As an employee of Lnt InfoTech, Worked on project EPSILON health and life admin system. Involved in the enhancement and maintenance of Epsilon, a Marsh consumer admin system for healthcare and life insurance. Some of the achievements in this project are as follows
Worked on completing the migration of policies from ACP (American college of Physicians) handled by GIA (Broker) to Epsilon and policies of AXA life and healthcare handled by Kanawha insurance to Epsilon. Worked on modifying the in-house claims processing system designed in RPG for new carrier adds and adding new functionalities using RPG
Worked on the actuarial report generation part of the AXA policies migrated to Epsilon. These programs were designed using multiple array structure for various break level reporting
Responsibilities :
Prepared detailed requirements specifications in consultation with users/demand
Developed and maintained batch applications having RPG IV, Cobol/400, CL programs with internal /external described printer files and physical/logical/join logical/flat files
Created new and modified online screens using sub files used by Admin/Accounting for policy date/financial transactions entry/updating
Used batch and interactive debugging methods
System Integration testing was used for most of the changes
Environment: iSeries, RPGILE, RPGIV (free format), Aldon, SEU, SDA, DFU, AS/400, Cobol/400, CL/400, SQL/400, ISDB, BODERICK, ABSTRACT, Maestro Job scheduler