Accounting Data Validation Automation Tool

Description

The desktop application that helps accounting team to find errors in enormous missives of data. Input files are just CSV files with different data. The errors can be found by applying special rules to the data and highlighting found errors in the appropriate table. For higher performance, data is populated to the database using “bulk insert”.
The rules engine was created from scratch. In addition, the sophisticated GUI tool to create rule was implemented.

Features

  • Load accounting data from CSV files;
  • Load data to the database using “bulk insert”;
  • Fetch data and apply rules to them;
  • Highlight and manage errors found in the data;
  • In the rules configuration tool: simple and advanced modes to create rules. Three-like user interface was used to configure complex rules. Human-readable rule text parser was implemented.

Technologies

  • Java
  • JDBC
  • Swing
  • XML Beans
  • MS SQL Server 2005

Implementation Status

Successfully completed. In production.

XCS eiConsole — Enterprise Application Integration IDE

Description

The XCS eiConsole is a graphical Integrated Development Environment created for the express purpose of developing, managing, and maintaining interfaces. The XCS eiConsole offers a better, faster, less expensive, and more intuitive approach that makes managing dozens or even hundreds of interfaces an order of magnitude easier. The XCS eiConsole delivers exceptional value to business and technical professionals alike.

Technologies

  • Java
  • JDBC
  • Swing
  • XML Beans
  • Axis
  • Bouncycastle
  • Jetty
  • SAXON
  • Xalan
  • JUnit
  • WSDL
  • Ant
  • HSQL DB

Implementation Status

In progress. In production.

XML Data Mapping Tool

Description

XML Data Mapping tool is a desktop application that is used to generate XSLT transformations that transform any data format to any other data format. Typically this is used to transform data from a proprietary format to any common industry format, such as HL7, ACORD, DTCC, HR-XML, OpenTravel, MISMO, etc. It can also be used to transform data to any proprietary format, a company’s own common model, other standards or even different versions or interpretations of a standard.

Features

  • Inbound support of the industry XML standards (ACORD, OpenTravel, HL7 etc.). Support metadata loading.
  • XSLT Debugger — embedded tool to debug XSL transformations.
  • Visual XPath editor — embedded tool to edit XPath expressions.
  • Testing of the XSLT transformations.
  • XML Schema editing mode.
  • Mode to map source format codes to target format codes.

Technologies

  • Xalan
  • Xerces
  • XML
  • XSLT
  • XPath
  • ACORD
  • DTCC
  • HL7
  • OpenTravel XML
  • HR-XML
  • MISMO

Implementation Status

Successfully completed. In production.

Backup Software for Service Providers

Description

Server side implemented as Web site (ASP .Net), web service (WSE2) and a few windows services. Web site is tools called Management Console which provides reporting functionality for users and various management functions for administrators. Client side is represented by Windows Client (.Net WinForms application) and Java Client (Swing application with small set of native tools).

Technologies

  • Eclipse
  • SVN
  • Ant
  • gcc
  • CruiseControl
  • Visual Studio
  • PowerShel
  • TargetProcess
  • TestComplete
  • ASP .Net
  • WSE2
  • .Net WinForms

Implementation Status

Successfully completed. In production.