Here are examples of WCI's work in these industries:

Finance
Real Estate
Retail/Supply Chain/Manufacturing
Telecom
Energy
Healthcare

Finance Industry Examples:

• Consolidations, Business Planning Systems, Consolidation Automation, Executive Dashboarding, Trading Support Systems, Fund Analytics.
• Deployment of Asset Management Dashboard to hundreds of operational users.
• Design ETL process for metric schema, including 15 sources from multiple platforms.
• Develop multi-level security model for user access and reports/metrics.
• Develop ETL process to combine two DB2 source systems into a standardized star schema.
• Develop trend models to identify potential future risk.
• Train client staff on BI system and architecture.
• Provide pilot sessions to Board of Directors.

Real Estate Industry Examples:

• Complete real estate reporting system that consolidates all production real estate source systems into single data warehouse/mart.
• Reporting system, responsible for all data delivery from day-to-day analysts needs to month/year end reporting.
• Create investor reporting packages on a monthly basis that are delivered to individual investors.
• End-to-end executive dashboard encompassing all aspects of real estate investments from aggregate investment performance with drill down capabilities into investment details to high level fund and investment goals.
• Highly customized dashboard front-end. Integrated security layer used to create personalized views of relevant and/or authorized data.
• SKU level forecasting, Flash Sales, P&L Analysis, Supply Chain Analytics, Merchandising Reporting, Sales Analytics, Accounting, Wireless to handhelds, ROLAP.
• Executive Dashboarding for multiple business units spanning multiple countries.
• Sales Intelligence, CRM Solutions.
• Design and implement sales and marketing data mart for 40+ countries, with 25 sources, on SQL Server.
• Develop, define and standardize company key metrics.
• Drill-down capabilities from dashboard to transaction level. Layered security model (Application and DB level).

Retail, Supply Chain, and Manufacturing Industry Examples:

• SKU Level Forecasting, Flash Sales, P&L Analytics, Merchandising Reporting, Product enhancements.
• Sales Analytics, Sales Intelligence, CRM Solutions.
• Supply Chain Analytics, Accounting Wireless to handlhelds, ROLAP.
• Executive Dashboarding.
• BI reporting components embedded into product offerings.

Telecom Industry Examples:

• HR Warehousing
• P&L Data Warehousing
• Inventory Control Reporting
• Publishing Systems Reporting

Energy Industry Examples:

• Analysis of Seismic, Drilling, and Exploration data
• Inventory Control, Choke Modeling
• Upstream and Downstream Pipeline Analysis
• Real Time Reporting for Energy Trading, Trading System Design
• Supply Chain, Consolidations
• ERP Business Intelligence Analysis

Healthcare Industry Examples:

• Health care reporting system covering all aspects of hospital data from financials to quality of care
• Sales and Marketing Analysis, System Integration, ERP
• Customer-facing Executive Dashboards for sales, inventory turn and order fulfillment.
• BI roadmaps for multi-department rollouts.
• Merged source data from BAAN, Sales Automation, Drug Manufacturer Data, Call Center, and Custom Web Order Entry systems.
• Implement Oracle Financials GL, AR, AP, BOM, Inventory, OE and Warehouse.
• Train users on Reporting environment and coach groups on data access and business logic.
• Extremely strict security layer to ensure that hospital executives can only view data related to hospitals in their security layer.
• Healthcare-specific metrics used to analyze all hospital related data specifically geared towards market share and financial analysis, financials and average length of stay, quality of care, and safety.

Back to top