Summary
Peter Lamb has over twenty years of experience in information systems consulting. Peter started working in the field of information systems while completing a degree at the University of Toronto, and has continued since then, primarily in Canada, but also for periods in the United States and Africa. Working with numerous clients has provided a wide range of experience and exposure to a variety of technologies and approaches. It has also necessitated the ability to work with people of different backgrounds, being able to join existing teams comprised of client staff and other consultants. Finally, it has involved working with a wide range of business users to develop requirements, and assist in application utilization.
As an independent consultant based in Toronto, Peter is primarily involved in system design and development using relational database tools, particularly ORACLE. For the last ten years his work has concentrated on the design and development of planning systems, large data analysis repositories and data warehouses. This has involved data architecture, design and application database administration responsibilities. Areas of concentration include:
• data modelling
• systems analysis and design
• data warehouse development
• database administration and tuning
• project planning and project management
• design and build using Kalido Dynamic Information Warehouse technology
• design and build using Kalido Master Data Manger technology
• design and modelling using Oracle Designer
• development using the suite of ORACLE tools
Employment History
Peter is currently engaged in information systems analysis consulting, operating as an independent contractor. He normally works as part of teams made up of both client staff and consultants from other companies. Typically, he contracts directly with the primary client as opposed to working through agencies. He also works on behalf of Kalido Inc. as an associate consultant when requested. He has arranged and managed other independent consultants to work on specific project teams as requested by clients. In the past, Peter has worked approximately 50% of the time from his own office, spending the remainder of time at client sites, although this changes depending on the needs of specific projects. Peter’s recent clients are located in Canada, United States and Belgium. Projects include:
Anheuser-Bush InBev:
• Primary data architect responsible for the design of master data management application for Labatt Breweries of Canada. The application uses Kalido MDM technology to bring together data from multiple applications into a single master data repository for consistent use, supporting both operational and analysis requirements. In the initial phase, this cross-functional repository was comprised of 150 categories integrating information from SAP, Oracle ERP, HRIS and a number of legacy applications. A second phase extended this application to comprise over 300 categories.
• Primary data architect responsible for the design of a cross-functional enterprise data warehouse for Labatt Breweries of Canada. The data warehouse itself was built using Kalido DIW in conjunction with Informatica on an Oracle database with Cognos as the BI Reporting tool. Responsibilities included:
o Confirming requirements with business representatives
o Defining the data model
o Designing and writing back end ETL processes specifications for both reference and transactional data, drawing information from multiple sources including Oracle ERP, Manugistics, and custom applications
o Setting standards for data warehouse design and ETL development
On delivery the data warehouse was composed of more than 40 dimensions comprised of over 200 hierarchies. One hundred and sixty measures were defined in approximately 100 separate fact data sets. Subject areas included financial, commercial and supply chain information, all sharing common dimensions where applicable. Since that time, the warehouse has expanded to seventy dimensions and double the number of fact data sets and measures.
• Primary data architect responsible for the Kalido design and implementation of a global BI solution for Anheuser-Busch InBev. The warehouse brings together multiple subject areas from a variety of source systems to present a consistent picture of financial and commercial data conformed to global hierarchies.
Other Kalido Projects:
• Data architect engaged to assist Abbott International in the design and implementation of a master data solution to support financial hierarchies shared between multiple applications.
• Consultant engaged to assist Abbott International in the modelling and design of a financial data warehouse using Kalido DIW with Cognos as the BI Reporting tool.
• Consultant engaged to assist EMC, a Boston based company, in the implementation of data warehouse using Kalido. This very large project involved a number of resources from multiple consulting firms including Kalido. Peter’s role was specific to defining and implementing non standard Kalido processes to support very large dimensions (normally more than 10 million entities). He was also involved in optimization and tuning with the application DBAs.
• Consultant engaged by Hewlett-Packard to support the Kalido implementation of a reference data hub. The reference data hub is designed to feed dimensional data for a number of data warehouse applications.
• Consultant engaged to assist Cinergy, a Cincinnati based company, in their use of Kalido in building a data warehouse application. The work focused on their processes for code control and promotion as well as managing their development and test environments.
Earlier Projects:
• Primary data architect responsible for the design of a Manugistics integration with Oracle ERP and a Kalido data warehouse for Labatt Breweries of Canada. Much of this project involved defining a master data management repository to support the definitions and translations required to support planning in Manugistics.
• Responsible for the analysis and design, using Oracle Designer 6i, followed by the co-ordination of implementation, of a data warehouse of sales information. The database was implemented in Oracle 8 under SUN/SOLARIS. Although a variety of analysis tools have been used against the warehouse, it was also built to support direct RAM access from Oracle Sales Analyzer. The application to maintain and support the warehouse was written using Developer 2000 and 6i tools.
• Design and implementation of Oracle form libraries and templates to allow consistent form development across multiple applications. Applications were able to be implemented under Windows, MOTIF or on the web using the Oracle 9iAS server.
• Responsible for the analysis and design, using Oracle Designer 2000, followed by the co-ordination of implementation, of a national system to collect sales, distribution and production data from multiple sources, and organize it for sales forecasting and production scheduling. Actual forecasting and production scheduling was done outside of the database using a number of analytical applications. The Oracle database and application was designed to support measurement and analysis, including functions to assist in supply chain management.
• On behalf of the Canadian Society of Nephrology, a project to identify the requirements analysis and recommend selection of a clinical information management and analysis package targeted for use in dialysis centres and hospitals across Canada.
• The design, prototyping and later development, with the assistance of two other independent consultants, of a distribution system in PROGRESS for Reebok Canada.
• The design and development, with a large team made up of in house staff and two outside consulting firms, of an ORACLE based distribution system for a La Brasserie Labatt in Montreal, Canada.
• A project involving work with a medical research team for the pharmaceutical company Ortho Biotech to prototype a drug dosing and analysis package. The package was designed to assist physicians in prescribing a newly released drug. The prototype was written using PROGRESS to run under DOS or UNIX operating systems.
Data Architecture and Data Warehousing Solutions
Peter Lamb - Resumé
© Copyright Peter J. Lamb & Associates
