|
| |
Data Warehouse Design, Development and
Implementation Consulting Services
Our
service goal is to provide supplemental consulting expertise within the Business
Intelligence / Data Warehouse operational area.
-
Provide best practices and coordination of activities between various
project leads within Enterprise Data Warehouse projects.
-
Provide design, development and implementation of Data Warehouse Development
Methodologies that include step by step activities, milestones,
deliverables, guidelines and templates.
-
Provide design and implementation of source to target mapping (Source to
Stage, Stage to ODS, ODS to Data Warehouse and Data Warehouse to Data Mart).
-
Provide overall project management of various IT and data warehouse
development initiatives.
-
Provide Scoping and Business Requirements gathering methodologies and
deliverables.
-
Provide design and implementation multiple data marts (independent data
marts) into a consolidated data warehouse.
-
Provide design, development and implementation of overall ETL data
acquisition and data delivery strategies utilizing various ETL Tools.
-
Provide design, development and implementation of data warehouse and data
mart modeling methods and practices.
-
Provide data sourcing architectures for FTP receipts, XML files, flat files,
DB2, Redbrick, Teradata, AS400 UDB, SQL Server and Oracle.
-
Provide design and implementation of data warehousing loading methodologies.
-
Provide design and implementation of multiple incremental data warehouse
update techniques and methods.
Specific experience includes:
-
Defined best practices and coordinating the activities of the various
project leads within the Enterprise Data Warehouse projects.
-
Designed, developed and implemented Data Warehouse Development Methodologies
that included step by step activities, milestones, deliverables, guidelines
and templates.
-
Designed, implemented and performed source to target mapping (Source to
Stage, Stage to Data Warehouse and Data Warehouse to Data Mart).
-
Overall project management of various IT and data warehouse development
initiatives.
-
Developed and implemented Global currency and data sourcing timing
architectures.
-
Established and managed Scoping and Business Requirements gathering
methodologies and deliverables.
-
Designed and implemented multiple data marts (independent data marts) into
consolidated data warehouse.
-
Architected, designed and implemented multiple Global Data Warehouses.
-
Developed and implemented overall ETL data acquisition and data delivery
strategies.
-
Developed and implemented data warehouse and data mart modeling methods and
practices.
-
Defined data sourcing architectures for FTP receipts, XML files, flat files,
DB2, Redbrick, Teradata, AS400 UDB, SQL Server and Oracle.
-
Established and implemented data staging architectures to handle like
subject areas from different sources, multiple days, dirty data and
reconciliation.
-
Established and implemented data warehousing loading methodologies.
-
Designed and implemented multiple incremental data warehouse techniques and
methods.
Specific domestic and global
data warehouse project experience includes:
-
Sales Analysis and Analytics
-
POS & Same Store Sales Analysis and Analytics
-
Cost of Sales Analysis and Analytics
-
CRM Analysis and Analytics
-
Order Management Analysis and Analytics
-
Financial Management Analysis and Analytics
-
Inventory Management Analysis and Analytics
-
Procurement & Spend Analysis and Analytics
-
Receivable and Collections Analysis and Analytics
-
Forecasting and Planning Analysis and Analytics
-
WEB Site Traffic Analysis
-
DEA Drug Seizure Analysis and Analytics
-
Pharmaceutical Drug Utilization Analysis and Analytics
-
Utility Utilization Analysis and Analytics
-
Construction Lending Analysis and Analytics
|
