Project System

Rajesh Janardhanan

Professional Experience

* ***** ********** ** *** & 9.5 years experience in TPF

Mphasis an HP 8 years 7 months 21st Nov 2005 - till date

company

Aviation 1 year 2 months 20th Sep 2004 - 18th Nov 2005

Software

Development

Consultancy

(TCS), Chennai

US Technology 1 year 6 months 24th Mar 2003 - 17th Sep 2004

Resources

(Trivandrum)

IBS Software 1 year 10 months 1st Jun 2001 - 23rd Mar 2003

Services

(Trivandrum)

Roles and Responsibilities

Mphasis an HP Project Lead and Application Technical Lead of

company SHARES TPF Team (Reservations). Responsible for

application support for the clients and technical

solutioning for the Reservations Team. Provide SME

support for TPF Tools for all applications in

SHARES system.

Aviation Team Member for the offshore development team of

Software Singapore Airlines. Module leader for the

Development Reservations team

Consultancy

(TCS), Chennai

US Technology Technical Lead of offshore team for various US

Resources, clients like Mazda Motors of North America,

Trivandrum WellPoint Health Care Networks, International

Trucks & Engines etc.

IBS Software Team Member of Offline maintenance group of TPF

Services, Offline applications for EDS, Switzerland

Trivandrum (erstwhile Atraxis AG).

Training Manager of the team

Control-M administrator of the team (Real Time

monitoring of the Production System)

Project Summary - Mphasis an HP company

Production System Maintenance (Ongoing Support)

This involves the maintenance of the SHARES Reservation system.

Responsibilities include solving incident logs and subsequent load

coverage. Clients include Continental Airlines, America West, Virgin

Atlantic, G2 Switchworks, FlyBe etc.

Technology: TPF Assembler, SST

Project - Modify MVT messages to include Delay Code and Time (May

2006)

This project will provide US Airways with the ability to include

Delay code and time (in hours and minutes) in outbound MVT FLIFO

messages. When building the outbound MVT message, SHARES will add a

new line starting with DL (delay time) right after the ED (Estimated

Departure time) or EA (Estimated Arrival time) line, in case the

ED/EA time is later than the original time.

Technology: TPF Assembler, SST

Project - Expand MVA Variable Availability Table (Apr 2006 - May

2006)

In the current system, a maximum of 255 IATA Numbers can be stored

for a single Source item in the MVA Table. The first 50 IATA Numbers

are stored in the Source Item Record and the remaining 205 IATA

numbers are stored in the IATA Number Extension Record. Each Source

Item Record can have one IATA Extension Record linked/indexed to it.

This enhancement provides CO the capability to add more than 3000

IATA Numbers for each Source Item.

Technology: TPF Assembler, SST

Project - US-HP PNR migration (July 2006 - Dec 2006)

This project involved migration of PNRs from Sabre system to SHARES

system as a result of the US Airways-America West Airlines merger.

My task involved converting VCR data, FQTV data and FQTU data coming

from Sabre system to SSRTKNE, SSRFQTV and SSRFQTU formats

respectively in SHARES. The conversion programs were done in the

SHARES MVS Offline system.

Technology: MVS Assembler, Xpediter

Project - FLIFO Reason Code & Early/Late Code for US Airways (Jan

2007 - Jul 2007)

This project involved processing Reason Codes from US Airways' FOS

(Flight Operating System) and converting them to Reason Descriptions

and storing the FLIFO information in SHARES. It also involved

computation of Early/Late code for the FLIFO messages. I was

involved in designing the modifications required, development and

testing of incoming FLIFO messages from US Airways' FOS.

Technology: TPF Assembler, SST

Project - EADM (EDS Product) (Jul 2007 - Jan 2009)

This product will enable the users to handle electronic documents

(EMDs) purchased by a passenger during reservations. The EMDs will

be stored along with the passenger's PNR and can be used by the

passenger for availing various services provided by the airline

during his travel. I was involved in creating the Business Design,

Technical Design, Development & Testing.

Technology: TPF Assembler, SST

Project - Partial PNR Divide for SSR INFT (Aug 2008 - Oct 2008)

Before this project was implemented, whenever Partial PNR Divide was

done on a name with an infant,having an associated SSR INFT item,

the Infant name was not properly adjusted in the child PNR. This

project ensured that the correct Infant names are associated with

the passenger after the PNR divide process.

Technology: TPF Assembler, SST

Project - New Availability Flight Selection Logic for US Airways

(Mar 2009 - Dec 2009)

This project involves the implementation of a new Flight Selection

logic for Availability Displays. Few of the functionalities to be

implemented as a part of this project are:

Rearrange the availability display to show the best flight/trip with

various controlling parameters. The flight/trip with shorter total

enroute time and its board/off match with the requested airport

entered from the input entry is considered the best trip.

Select more valid connection flights for the same originating flight

in order to display more flight/trips.

Give the operational flight higher display priority than the

codeshare marketing flight.

Introduce new forward and backward search range rather than using

the existing forward and back search time defined in the marketing

record in order to display more flights departing at the requested

date.

Technology: TPF Assembler, SST

Project - EMD Presence in Face of PNR (Mar 2010)

EMD is stored in the same record where the ETKT TKNE information was

also stored. During PNR display, this record need to be checked to

see if EMD exists and indicate so in the face of the PNR.

PNR Queue Enhancements (Apr 2010)

A client wanted major enhancements to the Queue process in SHARES.

These involved restructuring the entire SHARES queueing process to

cater to all the requirements. This functionality was to be

activated only for one carrier and so had to be isolated from the

other carriers through an application switch.

Project - EMD Out of Sync indicator (May 2010)

When an EMD is originally issued for a particular name or segment

and if that name or segment is later changed by an agent or TTY, the

EMD becomes out of sync with the PNR. The agent was unaware of this

since there was no indication in the PNR face. This project

identifies the Out of Sync condition during any name or segment

change and indicates the same in the AAA. During PNR display, this

indicator is read and a message is displayed on the face of the PNR

for the agent to easily identify and take corrective actions.

FLIFO Display Changes (Jun 2010)

A client wanted a completely redesigned structure of the FLIFO

display. These involved restructuring the entire SHARES FLIFO

display process to cater to all the requirements. This functionality

was to be activated only for one carrier and so had to be isolated

from the other carriers through an application switch.

Dynamic Schedule Updates (Jul 2010 - Aug 2010)

OAG has come up with a new Dynamic Schedule product. Currently a

feasibility study on plugging in this product with the existing

SHARES' SSM package is being done. This product if implemented can

reduce a lot of OA schedule update happening through the weekly SSIM

file and also the SSMs sent by individual carriers to SHARES.

Continental Airlines - United Airlines PNR migration (Aug 2010 -

Feb 2012)

PNR migration from Continental Airlines PSS & United Airlines PSS:

CO & UA merged as one carrier and moved into new partition as UA.

All PNRs in both CO and UA were merged and migrated into the new

partition in the HP SHARES system. I was involved in the project

from the beginning till the actual cutover in Feb 2012. I worked on

both TPF and MVS offline portions of the project to convert the PNRs

from S/UA Apollo format to SHARES format.

TPF 4.1 to zTPF conversion (Aug 2010 - Dec 2011)

This involved supporting the Systems conversion from TPF4.1 to zTPF.

US Network Optimization (Oct 2012- till date) -ongoing support

US Airways wanted to implement Revenue Management functionality to

optimize their network revenue. SHARES already had this capability

but US wanted to restrict this functionality only to certain agent

AAAs. This project involved creating a bypass functionality based on

the AAA and sine-in and allow Origin-Destination (O&D) only for the

selected AAAs.

This project also involved enhancing a MVT Bulk Upload utility so

that US Revenue Management team can update the online tables on a

daily basis. This was achieved using a MVT feed FTPed to SHARES MVS

and loading it online. The status of the daily runs were sent to US

RM using MQ series.

This project also involved sending Inventory notification messages

through MQ series.

Coding was done in Assembler & C++

Interface with Sabre Availability Manager (Apr 2013 - Till Date)

This project involved interfacing with Sabre's product (Availability

Manager) for Availability and Sell requests from SHARES. XML

messages are used for the query and response processing. Coding for

the interface was done in TPF-C++ using the IBM XML APIs. The XML

APIs are used for building XML documents for the query and to parse

the XML response messages. This was the first project in SHARES

which used these APIs in application programs. I was involved from

the start of the project to create a POC for C++/XML and then into

Design, Development and Implementation.

US Airways / American Airlines PNR migration (Feb 2014-Till Date)

This project involves migration of US Airways PNRs to the American

Airlines system hosted in Sabre. This project has been initiated

recently for the US-AA migration. I am involved in studying the

requirements proposed by Sabre and coming up with a design to

capture the required PNRs and transmit them to Sabre.

Project Summary - Aviation Software Development Consultancy (TCS)

1) MHA Black Box

Singapore Airlines needed a system to screen all passengers

travelling on their flights. SIA will send the list of passengers

before each flight departure to the MHA blackbox. This blackbox will

send back a list containing the statuses of the passengers.

Singapore Airport Authorities will perform security checks on these

passengers based on their status. The project included creating a

driver module which will route all entries to appropriate programs.

Other programs include adding, modifying, deleting and displaying

passport details of passengers who comes for check-in at near

departure time

Technology: TPF Assembler, TPFDB

2) E-Ticketing for SILKAIR flights through Amadeus

Before this project was implemented, SILKAIR did not support

E-ticketing through Amadeus. Since E-Ticketing was getting very

popular, travel agents around the world needed to book E-Tickets in

SILKAIR through CRS. This project provided support for E-ticketing

for SILKAIR through Amadeus. I was involved in the integration

testing phase of this project. TTY messages were simulated in SQ

Kriscom system to create PNRs. Simulated EDIFACT messages in Kriscom

were used to process issue, reissue, revalidate, refund and

system-cancel of SILKAIR E-tickets.

Technology: TPF, Assembler, EDIFACT, TTY

3) Qantas Availability Display System (QUADS) Enhancements -

Availability Entry Modification - Feasibility Study

The current QUADS availability display system has options to display

the availability based on a specific date and board/off point. A

feasibility study was done to modify the existing entry to include

flight selection based on specific date, board/off point as well as

connecting city and/or carrier code. The packages reviewed were

Routing Determination, Flight Selection, EASL/WEASL condition

checks, Selection Level processing and Connection Analysis.

Technology: TPF, Assembler

4) QUADS Enhancements - Free text comments

Before this project, the free text comments displayed when a booking

is done, after the booking information, are categorised by

date/period, frequencies, flight numbers and classes/compartments.

As a result, free text comments that are of a higher priority may

appear below those that are of a lower priority. The goal of this

project was to allow privileged agents to maintain booking

information based on priority codes. The existing free text comments

database was converted to a more structured one with option for

specifying priorities based on a segment pair or an aircraft type.

Carriers currently supported are SQ and MI, but provisions are done

for future expansion to incorporate Interline E-Ticketing. I was

involved in the technical design phase of the project, which mainly

involved mask building, mask validation, driver program design and

database addition/updation/deletion/display.

Technology: TPFDB,HLASM,SST

Project Summary - US Technology Resources (P) Ltd

1) Incentive Reconciliation Validation

Mazda Motors North American Operations (MNAO) required a module

which would validate the data in a dataset arriving into their

system from Minacs. The data has to undergo more than 20 validations

before it could be accepted for further processing. The module was

written in Assembler and most of the validations were done against

data residing on DB2.

Technology: High Level Assembler/DB2

2) Wellpoint Medical Decision Support

The primary aim of this project was to revamp an existing unix shell

script into 7 different scripts with restart logic. The jobs would

fetch data from an Oracle database and dump them to a unix file.

This file would be read by assembler programs which will then

process the data based on rules and generate outputs to different

client systems. The jobs are scheduled using a mainframe scheduler

which triggers each job based on the return codes from previous

ones.

Technology: HP Unix/ High Level Assembler/CTRL-M

3) Wellpoint Healthcare Quality Assurance IT

This project involved the support of the GNQ system of Wellpoint

Health Care networks. The main task was to create a user health

evaluation program for the state of Wisconsin (BCBS group). This

system involved the enrolling of members to a state-sponsored health

care programme. The system would periodically evaluate the fitness

of the members by sending questionnaires and suggesting preventive

care techniques. Online programs were used to feed data to the IMS

databases based on the responses sent by the members. Batch jobs

would calculate risk levels based on internationally preset fitness

parameters and inform/advise the members to take on early

precautionary measures.

Technology: High Level Assembler, IMS

4) International Truck & Engine Corp - Vehicle Delivery System

ITE is a major truck manufacturing company in the US which caters to

the needs of almost any industrial giant in the country. The project

involved re-designing the existing Vehicle Delivery process to

integrate the mainframe system to a new Web based system. This new

system would be used by dealers across the country to track orders,

invoices, deliveries and payments. Some of the functionalities in

existing Assembler modules were reproduced as COBOL programs for

modularity and maintenance effectiveness. New DB2 tables were

designed to take data from the web which would be used as input for

processing by night-running batch jobs in the ITE mainframe.

Technology: High Level Assembler, COBOL, DB2

Project Summary - IBS Software Services (P) Ltd

General Message Post Processing & Teletype message Logging

Online system (TPF) writes messages data on to different general

files on a daily basis. The logging program reads the general files

every second and writes the new messages logged, to specified date

files. These files will be used by online users to search for a

particular message.

Technology: High Level Assembler

General Message Post Processing & Teletype message Retrieval

The Retrieval program was intended to retrieve TTY (Teletype) and

QMS Messages from the daily and historical files located in the Host

System and stored in general files. For this a time driven program

searches periodically for a user entry. When a user entry is found

it initiates the retrieval programs which search the daily and

historical files based on the search criteria. The retrieved

messages are written on to another general file which will be read

by the online programs and displayed on to the user's

terminal/printer

Technology: High Level Assembler

Res RMC RCC Update

Online program puts data onto a general file (TPF/MVS interface).

The offline program will read this general file and create an

extract table. Date validations are done by the program to check the

validity of the flight schedules. Before populating the extract

table it does the conversion of flight frequencies from binary to

hex format.

Technology: High Level Assembler

Flight Statistics Entry validation & File update

The flight statistics entry generates flight statistics for a

station or for all stations in the airline network for a particular

date. The flight statistics contains the basic information about the

load carried by the flight including both passengers and cargo. The

project involved validation of the user entry and retrieval of

flight statistics based on the airline station code.

Technology: High Level Assembler

Sine-in table update

The Sign-in table contains information about the agent duty codes.

The project involved validation of the user entry and updation of

the sine-in table.

Technology: High Level Assembler

Technical Expertise

Expertise in IBM mainframe High Level Assembler

Expertise in TPF C/C++

Expertise in IBM TPF, Assembler, SPMs, TPFDF, SST, TPF Toolkit, VM

Excellent knowledge in Software Development Lifecycle

Excellent knowledge in quality processes

Skill Set

Operating Systems

IBM TPF v4.1 / zTPF

MVS OS 390, Z/OS

Languages

High Level Assembler (HLASM)

TPF C/C++

JCL

Databases

TPFDB

DB2

Schedulers

Control-M

Configuration Tools

EZLIB

VCON for TPF

Plasma (Endevor)

CVS (Concurrent Version System)

Debuggers

SST for TPF

CMSTPF

Xpediter

TPF Toolkit Debugger

Other Tools

Microfocus Mainframe Express

Education/Training

Graduation 1994 - 1998 B.Tech Degree in Mechanical

Engineering, University of Kerala (77.6%)

Post Graduation 1999 - 2001 M.Tech Degree in Industrial

Engineering, University of Kerala (75%)

Mainframe 2001 ER&DCI, Trivandrum on High Level Assembler,

Training JCL, COBOL

Undergone Internal trainings on HLASM, MVS, TPF,

SAS, CTRL-M & REXX at IBS Software Services

TPF Training At ASDC, Chennai (SPMs, TPFDF and SST)

Personal Information

Passport Number F8000251

Date of Birth 29th December 1976

Marital Status Married

Contact Number +1-562-***-**** / 562-***-**** / 785-***-****

E-Mail ******.***********@**.***

******.***********.***@*****.***

Contact this candidate