Brief information about the project:

  • Customer base: more than 30 million people
  • Sales: up to 500,000 parcels per month
  • The size of advertising activities: sending to 4 million emails per month
  • Database size: more than 300 GB
  • The number of tables in the database: about 300
  • The number of system users: around 500

    Ladies and gentlemen, all screenshots that you see on this page relate to a test version of the project.


    The project is developed on the client side (the browser) only under Internet Explorer, this is because with the fact that at the beginning of the project (2005 year) only IE had the extended object model which allows you to use features such as behaviors, ActiveX, XMLHTTP, additional opportunities for display tables, scrolling content in DIVs, and more. The content of the project pages was completely dynamic and created in the server. PHP and HTML was used only for the initial layout of the main window. Once loaded, the page has been updated via ActiveX. The web server used Oracle Apache. For the system have been demand strict requirements for the reaction time for operator actions, so it was decided not to use the middle tier on the web server, and build pages in PL/SQL on the database side.
    Despite the fact that the project worked in the browser, we were able to significantly improve the response time of the interface compared to the old system which was written in MS Access. Operators of mass input per working day could enter more than 1000 orders that was 40% more than in the old CRM.
    At the initial stage of development, a decision was made about creating your own set of components to the browser interface. First the protocol was designed for data exchange based on XML, which allows you to dynamically build the web-pages on the client side, then created the grids, the input windows, the main and context menus, tabpages, etc. In parallel on the server side was created database objects (types): CLIENT, ORDER, BATCH, SHIPMENT, ACTION etc.
    My idea of business scripts, applied in the project REVELATION for the Ukrainian branch of ESCC was brought to its full logical conclusion. For the creation of blocks of PL/SQL was created the scripts designer, which were given to the company managers, and which allowed to bring a large number of program code from areas of responsibility of developers. The use of scripts is not limited to marketing, they were used almost in all parts of the project, which allowing to flexibly manage production processes.
    A CRM system not only served customers database and took orders, it consisted of a large production unit, which managed the production of: sending mail through Russian Post and alternative suppliers. The volume of sendings was so high (up to 30,000 shipments per day), so all post documents were formed also through the modules of the project.
    The project was planned so that it could serve not only the Russian Federation but and other countries. Had experience with Ukraine, Belarus and Kazakhstan.
    Production reports
    For support of production processes the project part is implemented by using MS Access. Mainly in this environment was implemented, almost all production reports, part of which was formed by the Printing Department of company, and the other part was printed in the production lines. MS Access was chosen for these purposes because he had a very powerful reporting tool, can easily connect to the CRM of the company and allows printing of documents in large volumes (tens of thousands). In addition, the report layout in the case of incorrect markup could be easily corrected without involvement of the programmer. This is sometimes done at the weekend employees of the Printing Department, especially often such problem happens when you print on the printing forms that have the wrong markups.
    Many years in the parcels assembly has a practice of determining the weight of the parcel based on the data about goods in the project catalogue (in CRM) on the basis of the obtained values was used for calculation of postal rate of the shipment, which was printed in the address label and reporting documents. Almost always, the weight differed from the calculated and the the parcel was weighed again, and the data entered into the address label by hand and it was extremely uncomfortable. I developed the technology for automatic weighing for the company. On the assembly line was established electronic scales connected to the computer. After weighing the data on the weight of the parcel was sent to the program based on MS Access which was used for recalculation of the postal rate and were used for printing address labels.
  • Add Comment