TRAVEL BUSINESS APPLICATIONS
|
Versions : Enterprise.
|
Position : Senior Software
Engineer.
|
|
Client : National Travel and Tourism.
|
Team
Size : 20
|
|
Tools: InstallShield,
Microsoft Tools-VB.Net, DB2/MSSQL, IIS Server.
|
Client Environnent : Microsoft Tools-VB.Net, DB2/MSSQL, IIS Server.
Project Description: Travel business applications developed for Oman’s
biggest travel agency along with other IT Services. The applications supporting
thousands of customers everyday including In-house and corporate users are:
Ticketing System: A complete system
compatible for managing ticketing services for Corporates, In-house customers and
Individual clients. The application includes all Stock, Sales, Refunds,
Discounts, Commissions, Sub-Agents, MIS and Reports.
Tours System: A complete system
that includes Inbound, outbound, Holiday Package modules and other sub modules
that include Ticketing, Tours and Holiday packages, Reports and MIS.
Cargo System: A Client and
web-based application to manage and support cargo services for the corporate, In-house
customers and other individual clients.
BSP Reconciliation
System:
A Client-Server based application to manage and reconcile ticketing business
processes between travel agents and BSP for Air-India along with accounting
modules with reports and customer support modules.
Accounting Application: A DB2 database on AS/400 system
with support to different Microsoft versions to manage accounting system of the
client company.
ANYSHOTCS (UMS Solution Client-Server based)
|
Versions : Enterprise, Standard, Lite.
|
Position : Team Manager.
|
|
Client : Yeungjin Mobils
Pvt. Ltd., Daegu.
|
Team
Size : 15
|
|
Client Environment : VB.Net, ASP, FarSpread, MSSQL, Oracle10g, MySQL, InstallShield
|
Project Description: This is a Unified
Message Service Client program developed to send SMS, Fax Message, Voice
(Record) Message, Research Message (MSTG), SMS PLUS, Text to Voice (TTS),
Multimedia (MMS) through telecom company (KT Xroshot,
South Korea). It generates statistics reports, and displays TTS preview module,
SPAM Filtering, Online registration. This Client program works on telecom
provider engine interfaces like SDK, JRobot and AnyRobot Engine.
SPO Client (SUPREME PROSECUTOR’S OFFICE)
|
Versions : Standard.
|
Position : Team Manager.
|
|
Client : SUPREME PROSECUTOR’S OFFICE, Seoul.
|
Team
Size : 5
|
|
Tools: ASP, VB 6.0, MSSQL, Third party tools and FarSpread.
|
Project Description: It is a package to generate fir, reports and investigation documents for Korean police
department. It also manages registration or Updating crime history, department
hierarchy management and manages branch offices along with options to report
main head quarter about the details of crime investigation reports.
UMS ONLINE (UMS SOLUTION)
|
Versions : Enterprise, Standard, Lite.
|
Position : Team Manager.
|
|
Client : Yeungjin Mobils
Pvt. Ltd., Daegu.
|
Team
Size : 15
|
|
Tools: JSP/Java,
HTML/XML/JavaScript, Eluon, MSSQL/Oracle/Mysql, Apache Tomcat server.
Microsoft Tools: Asp/JavaScript, MSSQL/Oracle, IIS
Server, TOAD, ABCUpload & Nanumi Imageplus.
|
Project
Description: Online
UMS solution to send SMS, Fax Message, Voice (Record) Message, Research Message
(MSTG), SMS PLUS, Text to Voice (TTS), Multimedia (MMS) [audio/video/image
attachment support and Reserved Messages. Supports online generation of
statistics reports, results, account details, billing, fax receiving status,
address book and Online administration. These online sites work on all popular
telecom provider engine interfaces like SDK, JRobot
and AnyRobot Engine. This was developed and
maintained in Java technologies as well as Microsoft technologies as per
client’s requirements. It enables user-customization of images, audio and video files to send as MMS and Fax using FTP. Main
modules included:
AllimiUms: A module to track
fax receiving from Xroshot telecom server to the
client server, create fax cover, reporting using hangul files and alerting to
concerned user automatically.
Admin Module: A web-based
Application created to manage and customize member database by administrator
supporting options like spam and timer for message queue.
AnyRobot Engine: A Java based module developed on
MSSQL, MYSQL and ORACLE database with support to windows/Linux versions to work
in collaboration with Anyshot Client program for our
partners KT telecom services. Trigger module was created to support auto
delivery and calculations in this engine on database. Also, configured
and managed licensing Xroshot JRobot and
SDK Engine for all clients.
UMS-YJC: A Java-based UMS
solution to send sms, fax and manage accounts among
staff of different departments of Yeungjin
University.
YMSUBIZ: An official web
portal for Yeungjin Mobils
co. Ltd. with company profile, administration module, current projects,
organization details, summarized marketing products and other details.
DBMATE for Oracle (Database Monitoring, Tuning & Administration Tool)
|
Versions : Enterprise, Standard, Trial.
|
Position : Team Manager.
|
|
Client : DBMate Development Center, South
Korea.
|
Team
Size : 10
|
|
Tools: Java 1.6 (Core, Swings, JDBC, JavaBeans,
Servlets) on Borland JBuilder, JSP, VC++, JChart
Libraires, Zelix class master, Oracle 9i/10g,
InstallShield, Tomcat6 and XMail Server on
Linux RH9/Fedora Core5.
|
Project Description: A powerful tool to monitor the performance, tune the
issues and manage the objects. Real time monitoring of multiple database
instances using graphs, charts and tables. It is
capable of logging critical performance statistics for real time and historical
problem solving, Alarm, E-mail, SMS/VMS (South Korea only) event alert
mechanism to support DBA, Drill down architecture for in-depth analysis and
problem solving and has more than 30 support tools specially designed for
Oracle consultants & DBA. This tool has option to monitor single as well as
multiple instances of databases. DBMate supports
Oracle DB Version 7.3.x, 8.0.x, 8.1.x, 9.2.x and 10g on Windows NT, Linux, Sun
Solaris, Compaq Tru64 Alpha, IBM-AIX and HP-UX.
Anyshot Base Engine Package
|
Versions : Enterprise, Standard, Trial.
|
Position : Team Manager.
|
|
Client : Yeungjin Mobils
Co. Ltd, Daegu.
|
Team
Size : 5
|
|
Tools : InstallShield,
JRE1.5, MSSQL, AnyshotCS program, SDK Engine and Support files.
|
Project Description: A multi-setup scripting program
to setup .net framework, Install MSSQL Express, create SDK database and tables,
install Java run-time, setting up SDK Engine, Installing Anyshot
client program with customized settings.
Responsibilities:
· Strong experience in
N-tier e-Business applications using J2EE (Core Java, Swings, JSP, Servlets,
JDBC, XML, JMS), HTML, JavaScript, VB.net, VB6, ASP, MSSQL, MySQL and Oracle.
· Role involved into
System study, Design, Database
Administration, Coding and Development and support of all parts of
application at a position of Team Manager (Team Leader).
· Strong experience
with database development, Java [OOPS.], SQL [Proficient in tuning tools,
Enterprise Manager, Query Analyzer, Query Tuning, Index Tuning, Replication,
Backup, stored Procedures].
· Managed the
coordination of service provision unit communications both internal and
external.
· Role involved in
coding and writing PL/SQL packages, database objects, Views, Triggers and
Stored procedures. Involved in extensive handling on MSSQL 2000, 2005/Express
versions, Oracle 9i/10G, Mysql 4/5 Versions,
optimizing, tuning, Backups, Language support for applications, DB Transfers,
Recovery, etc.
Responsible for
entire SDLC and Sound documentation skills. Participated in the development of
the system model, including designing input formats, database design and
process control measures needed to help control the development of the system.