DATA WAREHOUSES
We provide precise design of data warehouse architecture and it's adjustment to user requirements. It assures standarization of an unlimited amount of data coming from various systems. This allows analyzes of data on different detail levels. We also offer connecting them to a wide variety of on-line reporting tools. Our experience in building warehouses for global companies is a solid warranty.
VENUS
Data warehouse reflecting sales company interests. Data will be entered through core application interface, web site or palmtop. Customers use web site to enter orders and rejects, merchandisers use palmtops to connect to the system. Palmtop software is prepared for off-line working and connections established in order to synchronize data.
Date: Jun'05 - Jan'06
Technologies: Java Servlet/JSP, Oracle 10g,J2EE
Geographical Information System for Eastern Europe (GIS)
This system reports business data in the graphical form. Data referring shipments, their geographical destination and effected payments are visualized in form of graphs on geographical maps.
Date: Nov'04 - Jan'05
Technologies: Java Servlet/JSP (Oracle 9IAS), Oracle,J2EE, Struts, Corda Server, SVG
GAR 2
This data warehouse system reports all charges and obligations of all customers enabling the analysis of payments punctuality
Date: Dec'04 - Mar'05
Technologies: Oracle PL SQL, Oracle Express, Oracle SA, Web Cartrige Component, ETL
Global Reporting System
Global system of data warehouses with over 1000 heterogeneous sources of data ( coming from the finance, account systems, order systems and diffuse delivers in about 100 countries. This system creates daily reports and data for OSA, WEB Excel tools for 15 000 users ( online, web, mobile, mail). Data is available on different details levels depending from the type of user.
Date: Dec'01 - Dec'03
Technologies: Oracle , Unix , XML, Express server, OSA, WebExcell
SDM
Data warehouse for a bank sales department accomplished in the CMMi methodology
Date: Nov'04 - Feb'05
Technologies: Oracle PL/ SQL, Micro Strategy, ETL
SDM Next release
Data warehouse for a bank sales department accomplished in the CMMi methodology. Project has been positively evaluated by KPMG consulting company
Date: Nov'04 - Feb'05
Technologies: Oracle PL/ SQL, MicroStrategy, ETL
ODM
Data warehouse for a bank Operations Department
Date: Feb'04 - Aug'05
Technologies: MicroStrategy, Oracle, Informatica
MCR
Data Warehouse system, which enables to analyze the exactness of quantity and quality of shipments from producing plants to warehouses and other target customers
Date: Nov'03 - present
Technologies: Oracle Pl/ SQL, HyperRoll,ETL
Global Business Plan
Inner corporate system, which enables users to track and create various reports on the preperation and introduction of new product and event initiatives on the market
Date: Nov'03 - Jan'05
Technologies: Java, JSP, Oracle SQL
Data Maintenance
Integration of SAP data with data from the Oracle data warehouses
Date: Apr'04 - present
Technologies: SAP, Oracle
