Thursday 30 October 2008

Currently busy with...

Hi guys,

these days we are a little bit inactive on our blog. It seems to me that the economical crisis impacted even on our activities. Now we have to do more to maintain the levels of income as a year before. :) So, we are a little bit busy with projects.

So, since I am the representative of the IT part I will tell you in brief what I do. Then maybe on week-end we will have the report from Alex who represents creative design part. :)

Today there will be just text, no videos, no images... We are in design and development process.

Well, there are several projects that I am currently busy with at my primary work place. The first one is the application to manage order and sales simulations. Before the company we do the project for extensively used "unmanaged" Excel spreadsheets. Why unmanaged? Because every single simulation was created manually on four sheets with huge amount of information. Now that we work with SAP BPC (ex Outlooksoft) we keep on working in Excel but now every single sheet is 100% managed! :) B-)
So now we automate at maximum the process of simulation! :) All the data are stored in a central database, Excel becomes as a user interface to access the data in a correct way. :) The user makes selections of products, product types, production sites etc., get automatically generated templates for data input, inputs data with all the necessary data validation controls, the data is then passed to SPSS for optimization and returned to the user for eventual modifications.

The other project is the application to manage the company's where I work internal budget. This is quite a standard project also done by means of SAP BPC. Here the particular feature is that we are trying to overcome some natural limits of SAP BPC to create flexible applications.

And the last small project (small compared to the previous two, but not less important) is the creation of web-services and components to use in Excel to make it programmatically easily communicate with them. Very often our clients ask us to provide some interface to manage some simple tasks on the server like database optimization, update, file launch, data report etc. So, we traditionally provide interfaces based on Excel and program it to easily communicate with the web-services.
Therefore, if you have some applications and you want to stay in touch with them even when you are away (not away from Internet though) we will be able to help you. :)

Best wishes from YellowRiver,
Valera :)

No comments: