Palak Debnath

Mob : 224-***-****

E-Mail: ab8azx@r.postjobfree.com

Career Objective

To work in a challenging environment that enhances my skills and

personality without compromising the objectives of my Employer.

Profile Summary

. 6.9+ Year Exp. In Airlines domain

. Hands-on experience in C, C++, Pro*C, Oracle SQL, PL/SQL, Unix

Shell Scripting/Linux/AIX

. Hands-on experience with design, development, customization and

implementation

of Airline software applications

. Hands-on experience with Trading System Software.

. Experience on C/C++/Pro*C application Production Support.

. Hands-on experience with BullsEye Scanner application.

. Working knowledge of Revenue Management, Baggage Handling, and

Cargo Applications.

. Possesses good diagnostic, troubleshooting and problem solving

skills.

Skills

. Platforms Worked: HP-UX, IBM AIX, Suse Linux/ Red Hat Linux,

Solaris.

. Language: C, C++, Pro*C, SQL, PL/SQL, Core Java

. Scripting Language: Unix Shell Scripting

. Other Utilities: Oracle, Visibroker 6.5, MQ-Series, POSIX, Purify,

gdb, dbx

. Tools: SVN, RCS, Rational Rose

Work Experience

6 Years and 9 months.

Project Profile

RCM Professional Services - Middle layer (Apr 2012 - Till date)

Operating System: Sun Solaris

Programming Language: C, C++, PLSQL, Pro*C

Scripting Language: UNIX Shell Script, AWK Scripting

Database: Oracle 10g

Client Name & Work Location: RCM Informed, San Francisco USA

Project Description

The project involves maintenance & Enhancement activities of 3

applications:

. Middle Layer(ML)

. RCM Staging Outbound(RSO)

. Online Transaction Repository(OTR)

ML: Downloads Live trade feed data from the Bloomberg Interface being

used by RCM. The application is extremely critical and should be up and

running 24 * 7. Trade comes from various regions which include San

Francisco, Honk Kong, Asia Pacific, London etc. This downloaded data get

stored in Middle Layer database and is later used by other RCM

applications to carry out various processing. The application is built on

C, C++, Pro*C, PL/SQL over UNIX environment and uses Oracle as a

Database.

RSO: RCM Staging Outbound to capture data from Bloomberg and process for

custodian & further tracking.

OTR: Online Transaction Repository captures data from Bloomberg and keeps

in presentable format. Analysis of problems reported by business users in

the OTR reports. This is a T & M project and consists of 7 members.

Responsibilities

. Supporting the Middle Layer application

. Delivering a suitable fix and action plan for the problem that is

reported

. Availability of Applications

. Assisting users in getting their task done

. Enhancing the Application with new features to increase customer

productivity

. Performance tuning

. R & D Work

. Co-ordination with other teams

Revenue Management System - Orion (Aug 2009 - Apr 2012)

Operating System: IBM-AIX

Programming Language: C, C++, PLSQL, Pro*C

Scripting Language: UNIX Shell Script, Orchestrate Scripting, AWK Scripting

Database: Oracle 11g

Other Utility: Orchestrate, RCS

Client Name & Work Location: United Airlines, Chicago USA

Project Description

Revenue Management is the art of maximizing profit generated from a

limited capacity, over a period of time by ensuring that companies have

the right prices in place for all their products/services, to all their

customers, through all their channels, all the time.

RM plays crucial role in industries where:

. Demand is limited and immediately perishable

. Customers book capacity ahead of time

. Prices are changed by opening and closing predefined booking

classes

. Uncertain Demand forecasts

. Segmented Markets

United Airlines does their revenue management through the application

Orion Inventory System.

The ORION Inventory system is the most sophisticated yield management

application in the airline industry. It was designed to maximize revenue

by setting optimal seat inventory levels, utilizing path-based demand

forecasts, network optimization, and allowing frequent updates to the

passenger values in concurrence with pricing actions. ORION stores

voluminous data as well as historical bookings, actual bookings, and

forecasts of future demands. The ORION system is accessed through a

windows-based, graphical user interface (GUI) tool.

ORION is comprised of three subsystems:

. Passenger Valuation

. Demand Forecasting

. Network and Flight Optimization

Responsibilities

. Involved in the development of Orion project. Designed and

developed Passenger Valuation model in C++.

. Involved in Orion Informix to Oracle migration and code changes.

. Enhanced Demand module with PL/SQL code.

. Ported Orion application from AIX5 to AIX6.

. Design, Coding and Unit Testing.

. Bug fixing

Baggage Sortation System Migration (Aug 2008 - Jul 2009)

Operating System: Red Hat Linux, Suse Linux, Hp-UX

Programming Language: C, C++

3rd Party Library: POSIX Thread Library

Scripting Language: UNIX Shell Script, AWK scripting

Database: Oracle 10g

Other Utility: SVN, Apollo

Client Name & Work Location: United Airlines, Chicago USA

Project Description

United handles thousands of bags every day at its check-in counters and

has to ensure timely loading of these bags onto the correct aircraft and

ensure that it reaches the correct destination. In the process it needs

to track the bag at various points of the journey so as to ensure that it

can trace the bag in case it is reported as not received by the

passengers. United achieves this through a combination of systems

consisting of Apollo, Baggage Sortation System (consisting of application

gateways), Sorter system (consisting of scanners and a system of conveyor

belts) and scanners at baggage claim section.

The Baggage Sortation System (BSS) is collectively formed by BAG

(BullsEye Apollo Gateway), BUG (BullsEye Utility Gateway) and BIG

(BullsEye Internet Gateway) application gateways. When scanner scans a

bag tag then this information goes to Apollo through BAG. On the other

hand when a scanner scans a mail tag then it goes to Mail Scanning

application through BUG. BIG works with BUG to process late mail. As a

whole Baggage Sortation System consists of multiple bag-tag scanners, a

system of conveyor belts to sort the baggage to corresponding flights'

piers, PLCs (programmable logic controllers) and small computers. BAG

facilitates the communication between BullsEye Scanner and Apollo.

Responsibilities:

. Performed analysis of technical requirements based on Object

Oriented Programming.

. Application Design Document preparation.

. Performed code Migration for C++ module BAG from HP-Ux to Suse

Linux box.

. Performed code Migration for C++ module BUG from HP-Ux to Suse

Linux box.

. Performed code Migration for BIG from HP-Ux to Suse Linux box.

. Performed documentation, development and testing for all three

Legacy applications.

ISM: International & Domestic Mail Application (May 2007 - Jul 2008)

Operating System: Hp-UX

Programming Language: Pro*C, PL/SQL

Scripting Language: UNIX Shell Script, AWK scripting

Database: Oracle 10g

Other Utility: RCS

Client Name & Work Location: United Airlines, Chicago USA

Project Description

The Postal service tenders mail to United at a designated tender point.

Mail is tendered in handling units to mixed destinations. United is

responsible to sort mail to specific flights . This application takes

mails from US Postal Service and sorts these to the appropriate flights.

Domestic Mail Application helps United to deliver the mails to

destination point.

Responsibilities:

. Have been actively involved in the architecture of this project.

. Deciding of the interfaces which can be connected through this

application.

. Involved in the study of different modules which is required for

this project

. Application Design Document preparation.

. Have been involved in developing MQ interface with ISM application.

. Introduce new repots for ISM performance in Pro*C, PL/SQL.

. Performed documentation, development and testing during the full

life cycle of the core mail application development, including

preparation of user guides.

Gift Card Redemption(Feb 2007 - Apr 2007)

Operating System: Windows 9X, XP

Programming Language: VC++

Other Utility: SVN

Client Name & Work Location: United Airlines, Kolkata India

Project Description

Gift Card Redemption for UAL - FastRes is an MS Windows based client

server application used for reservation and ticketing, updating various

information like PNR, baggage, flight information tracking etc. The front

end interacts with Apollo mainframe system, DB2, Oracle and retrieves /

updates required reservation information. The basic requirement of the

project will be to allow customers to redeem UA gift cards (available

from 3rd part vendors / UAL portal) while purchasing tickets via United

Reservations. This is to provide the ability to query the vendor for gift

card balance, utilize the balance to pay for tickets, and also accept

multiple FOP (including more than one gift card) to purchase tickets.

Responsibilities:

. Performed analysis of technical requirements.

. Development of the front-end modifications of existing FastRes

application.

. Testing & Debugging.

CIIMS: Centrally Integrated Information Management System (Aug 2005 - Jan

2007)

Operating System: Red Hat Linux, Suse Linux, Hp-UX, IBM-AIX

Programming Language: C, C++, Core Java

3rd Party Library: POSIX

Scripting Language: UNIX Shell Script, AWK scripting

Database: Oracle 10g

Other Utility: PVCS

Client Name & Work Location: Unisys, Kolkata India

Project Description

The CIIMS is a middleware bus that plays an essential central role in

Airport Operations by providing a common integration framework for all

the Airport subsystems. The primary responsibility of the CIIMS is to

manage the physical transfer of data between connected systems in an

efficient, reliable and event driven fashion. The physical implementation

of the CIIMS middleware bus involves placing CIIMS components, provided

in the form of a software development kit (SDK), within each integrated

system or application, which then uses the bus backbone for interacting

with other connected systems. These purpose built CIIMS components carry

out the processes of establishing connectivity with the CIIMS, extracting

or receiving relevant data, and passing this data traffic to the message

bus.

Responsibilities:

. Have been actively involved in the architecture of this project.

. Deciding of the interfaces which can be connected through this

application.

. Developed the core-messaging component, "CIIMS Messaging

Component", in C++.

. Developed the Software development kit (SDK) in C++. The CORBA

client portion of CIIMS, which is used by the subsystems to

communicate to CIIMS.

. Developed client application in Core Java.

. Preparation of test plans and test scripts of different components

of CIIMS.

. Performed technical analysis, design and documentation, development

and testing tasks during the full life cycle of the core messaging

component development, including preparation of user guides.

Academic Qualification

. BTech, CSE from University Of Calcutta, Kolkata, India (2005)

Contact this candidate