Our experience in data processing from multiple streams into a single corporate database for use by purchasing, procurement and marketing.
I came to data conversion between 2000 to 2004 where I was integrating
multiple streams of corporate data and into a single database. With hindsight, the project could have gone differently, but with the resources available, the result was considerable.
Purchasing Data Processing
We spent four years working in a large international computer production company, managing a significant database. The purpose of the database was to consolidate forecast sales data for the Purchasing Department to negotiate medium-term supply contracts.
The challenge was the import of this data from multiple diverse unstable sources. We developed systems to standardise and inject up to 20 sources at a time into a central database.
The database had several other functions, notably to maintain item purchasing prices for use by Procurement to place supplier orders. Also, the database received significant volumes of production data to crosscheck forecast data.
Our systems serve as operational groupware and as industrial models before the implementation of larger structured systems. The database served as a repository and analysis model for a later transition to Peoplesoft ERP.
We remained involved in the project throughout the transition to Peoplesoft. We continued the day-to-day data, functional analysis of the Purchasing module in PeopleSoft and building interfaces from the legacy database. Once the new systems in place, we built reporting systems on Cognos.
Functional Requirements Analysis
We use UML techniques for functional requirements analysis, operational contexts through use cases and relational data structures using class diagrams. Our involvement can take different forms. We can be involved in modelling initial business requirements with business actors, in data modelling, data processing or on a consultancy basis.
Do not hesitate to contact us if you have data migration or bespoke systems developments projects. Please contact us to discuss the data conversion projects that you may have. See also services to digitise video and audio sources,