The background of BVJ's founder, Bruce A. Bednarski, is varied and diverse and includes working as a consultant for Digital Equipment Corporation developing SQL procedures for the Business Manager's Workbench to collect and process both revenue and certified order information, storing it in an RDB database containing a data warehouse data model, roll the information up along various dimensions using MS Access to prototype RDB SQL stored procedures. The process also included developing a pivot table of year over year, month over month and week over week to show current over last year comparisons. Thus, enabling business managers to make better decisions on current and future product directions.

Provide information on current Profit and Loss data of interest to a business product manager or their upper management for the following dimensional roll ups/drill downs:

• Organizational structure up to Corporate Level
• Product Structure including product items, aggregations, groupings to all products
• Time in terms of weekly, monthly, quarterly or yearly with information keep up to two years for comparison to prior year's data
• Geography, from country to territory, to area up to world wide
• Customer Data from individual sites to corporate levels
• Monetary data from cost of goods, internal organizational uplifts to actual sales amounts.

This is so the business managers can ask and obtain answers to the following types of questions:

• How well did my group do for each product we manage on a world wide basis as compared to same time period last year?
• How well did we do for all products by geography?
• How much revenue did we take in from each corporate customer?

Obtain information from legacy systems (called legacy not because they may be phased out but because they are existing systems we have to work with) on a weekly basis:

• Revenue feeds
• Certified Orders
• Costs of goods
• Updates to dimensional references

Roll up the data into three major levels, each in a separate data warehouse database:

• Raw Data
• Intermediate level information
• Summary Level

If you would like to discuss your project needs with us please call us today at 978-458-4107.

This page, and all contents, are
Copyright © 1999-2005, Bruce A. Bednarski of BVJ Company, Inc.
All Rights Reserved.

Better Value Joined
www.bvj.com
Joining-Information-People-DataBases & Businesses
Click here for more information.