Data warehouse and business intelligence architectures that...
·	leverage existing technology investment
·	scale vertically and horizontally to maintain performance as loads increase
·	can be extended to meet changing business needs
·	use the right tool for the job - one size doesn’t fit all
Result: The best price-performance ratio and a roadmap for growth.

·	an iterative methodology with immediate, tangible results
·	end-to-end expertise, from source data to front-end tools
·	effective management of people, technology, and projects
Result: Complex projects that are on time, on budget, and meet business objectives.

·	systems that people enjoy using every day to make better decisions
·	transforming labor-intensive data gathering and reporting into “insight at your fingertips”
·	looking forward instead of only being able to look backward
Result: Powerful and useful decision support.

·	replaced underperforming system with hybrid SMP/MPP architecture, increased performance 12x, doubled warehouse size to 3 billion fact rows
·	new architecture supports 15x more concurrent users
·	new architecture saved over $1.5 million
Result: Reduced out-of-stocks, reduced customer migration and defection. System paid for itself in under a year.
Tools: Custom ETL, Netezza, MicroStrategy

·	prototyped DW/BI system in 90 days using open source tools
·	parallelized ETL to load millions of rows within short windows
·	analytic and marketing products for automotive, financial services, travel, and wireless industries
·	advanced predictive analytics with behavioral targeting
Result: Competitive advantage on demand for Fortune 50 clients.
Tools: Custom Java ETL, MySQL, Oracle, Java (J2EE) UI

·	conformed complex dimensions merging multiple sources including sales, marketing, budgeting, demographics, surveys, and competitor data
·	high-performing cubes for forecasting, time series, product lifecycle analysis, price elasticity modeling, and trade flow analysis
·	automated processes saved weeks of manual effort
Result: Breadth, depth, and power unique in the industry.
Tools: Custom preprocessing, ETI, SAP BW, Oracle, Cognos

·	merged 40+ data marts into one authoritative, reportable warehouse
·	advanced data profiling improved data quality
·	MPP system improved performance and increased the number of supported users
Result: Consistent, accurate reporting across the enterprise.
Tools: Informatica, Teradata, SAS, SAS BI

·	dashboards, deployed over the web and Blackberries
·	drill down and through to get the right information
·	advanced pattern-of-care, revenue management, and compliance metrics
Result: Better patient care and higher reimbursement rates.
Tools: DTS, SQL Server, MS Analysis and Reporting Services, C#

·	extended existing warehouses to resolve complex financial and accounting issues
·	agile development produced results in weeks, not months
·	innovative architecure leveraged existing “spread-marts”
Result: Consistent, accurate, enterprise-wide reporting.
Tools: Informatica, Oracle Financials, Hyperion, Business Objects