My Projects.

  • 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.