Summary
Overview
Work History
Education
Skills
Personal Information
Work Preference
Timeline
Generic

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

16
16
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

Education

BS (Bachelor of Science) - Electronics & Communication Engineering(ECE)

University of Kerala
India
01.2005

Skills

  • Programming languages: RPG/400, CL/400, ILERPG, SQLRPGLE, Cobol/400, Synon
  • Databases: DB2/400, PostgreSQL
  • Utilities/tools: SDA, PDM, SEU, QRY/400, DBU, MQ Series
  • Configuration control: Aldon, Turnover, SVN, Git
  • Workflow manager: robot
  • SQL

Personal Information

Title: RPGILE Lead Architect

Work Preference

Job Search Status

Not actively looking

Salary Range

$45000/yr - $200000/yr

Timeline

Senior RPGILE/Data Architect

FCBT
05.2018 - Current

Senior Technical Lead

Pharmerica
06.2017 - 04.2018

RPGLE PROGRAMMER

Frontier Communication
10.2014 - 06.2017

AS400 L3 Analyst

CVS Caremark
09.2012 - 10.2014

AS400 SUPPORT ANALYST

Sears Holdings Inc.
01.2012 - 09.2012

SOFTWARE ENGINEER

Marsh & McLennan Company
05.2010 - 01.2012

BS (Bachelor of Science) - Electronics & Communication Engineering(ECE)

University of Kerala
Ajay Vivek S. Pillai