Financial Analysis Software
Our client is a local cellular operator in Japan.
Alierra Software was to develop a system to analyze statistical data and generate different kinds of reports.
The system includes 2 levels: affiliate level and corporate level. The data from financial and engineering department is processed at the affiliate level, and the local statistical reports are created (available to the affiliates’ staff). The reports are then exported through Web Services to another database, which is accessed by the application of the corporate level. At the corporate level, the system generates complex statistical reports based on the data received from different affiliates. Complex reports are available to the headquarters staff only.
2-level architecture ensures the improved performance and safety
The use of Web Services allows to avoid direct access to the main database by applications of the affiliate level
Ability to generate accurate and timely statistical reports for analysis and decision-making
Tools and Technologies
MS SQL 2005
Crystal Reports – different types of records
ABC PDF 5 – displays report results
Third party components.
XML + XSLT
Efforts – 112 man/month; duration – 10 months.