Domain:
Airline Industry

Description:
A multi-tier, multi-module web based back-office system designed for airline operators’ back-office staff and some reporting modules for customers. The system followed IATA standards and used sales & flight data from a variety of global systems including Sabre.

My Role:
Writing/Modifying Queries, Packages, Stored Procedures, Triggers, Views, etc.
Performance Tuning through query/procedure code analysis & modifications.

Domain:
Airline Industry

Description:
A multi-tier, multi-module web based back-office system designed for airline operators’ back-office staff and some reporting modules for customers. The system followed IATA standards and used sales & flight data from a variety of global systems including Sabre.

My Role:
Writing/Modifying Queries, Packages, Stored Procedures, Triggers, Views, etc.
Performance Tuning through query/procedure code analysis & modifications.

Domain:
Insurance

Description:
A two-tier Client-server architecture based back-office system designed for Underwriters & Claim Processors of the Client (Argo Group, USA).

My Role:
Writing/Modifying Packages, Stored Procedures, Triggers, Views, etc.
Deployment of database objects on multiple test environments using Unix Shell Scripting.

Domain:
Financial / Stock Markets

Description:
A Client-server architecture based back-office system designed primarily for Brokers & Foreign Institutional Investors of Indian Stock Exchanges (NSE and BSE), to streamline their back-office equity operations from various branches so that it can be done in a systematic and organized manner

My Role:
Writing/Modifying Stored Procedures, Triggers, Views, etc.
Performance Tuning through procedure code analysis & modifications.
Impact Analysis, etc.