
Case Studies: Insurance Business Process Development/Re-engineering
Client ''''' Situation	Personal lines insurance carrier, with multiple subsidiaries, product lines and distribution channels - $1.0+ billion in annual premium. Due to a Merger and Acquisition, client must reduce the cycle time for reporting quarterly and year-end financial statements (STAT and GaaP) from 35 days to 14 days.

Solution	Defined and Documented current Financial Reporting Process. Built workflow diagram showing all data inputs and outputs. Determined redundant and inefficient processes. Re-engineered Financial Reporting Process to maximize current technologies and resources.

Results	Helped client implement a Financial Reporting Process that eliminated 21 work days by multiple resources. Accomplished desired results without any monetary investment in technology.

Case Studies: Insurance Strategic Alignment & IT Effectiveness

Client	Personal lines insurance carrier, with multiple subsidiaries, product lines and distribution channels - $1.0+ billion in annual premium.

Situation	Assess business strategy and IT alignment and utilize a systems architectural approach to support distribution channels, reduce back-office costs, support diverse products, provide customer on-line account access and position the company to exploit emerging market opportunities.

Solution	Defined key business drivers. Conducted competitor and best practices analysis. Prioritized solution requirements. Identified architecture guiding principles and selected supporting technologies. Developed Business project budget and ROI analysis. Designed an implementation organization structure, including representatives of key business units and IT. Prepared multi-phased implementation and staffing plan.

Results	Helped client develop a clear business and IT alignment strategy, and transition plan. Significantly reduced project risks and expedited the pace in which the client will achieve business competitiveness.

Case Study: Law Enforcement Systems Architecture

Client	Indiana State Police, which maintains criminal history repository, providing background check services to local, state and federal law enforcement agencies, as well as background checks to the general public for employment, community/volunteer services and firearms licensing.
Situation	Improve record quality and completeness of statewide Criminal History database to improve thoroughness of state criminal background checks.
	Poor record completeness, accuracy and verifiability Desire to participate with other states and federal government as player in a national repository Potential to play a key role in an integrated state criminal justice information network Increase public safety and awareness through improved criminal history reporting at a state level

Solution	Improve identification methods via integration with a statewide electronic fingerprint system Enhance record completeness via integration with a statewide prosecutors' case management system Share records with other state and federal law enforcement agencies via integration to a national criminal history index Reduce the cost of state government labor by providing background check services online via the internet

Results	Criminal Disposition reporting increased 700% over two years All criminal record identities verified via fingerprints Booking information made immediately available to prosecutors and courts Criminal Histories and Background Checks shared with FBI Thousands of backlogged records eliminated; inputs are day-current

Case Study: Pharmaceuticals Distribution Systems Integration
Client	Distribution/Warehousing division of pharmaceuticals manufacturer. Functions include order processing and billing wholesaler customers and controlling a finished goods inventory.

Situation	Centralize customer service, order entry, billing and inventory control though a single integrated database system while maintaining the autonomy of three disparate warehouse facilities. Opportunities addressed:

	Need for a single, centralized inventory control database that is updated in real-time by local warehouse pick, ship, receive and put away functions. Required by the federal Drug Enforcement Agency to maintain accurate reconciliation of physical inventory counts to inventory control totals in the automated database. Potential for timely data interchanges to marketing, accounting and manufacturing functions of the company. Cut costs and improve performance of the distribution sales and warehousing functions of the company through the availability of timely and accurate data.

Solution	Alleviate backorder situations via automated requisitions to manufacturing based on re-order quantities set by inventory control. Reduce warehouse costs and improve customer service by recognizing backordered inventory at the time of receipt, allocating it to a backorder and notifying the warehouse to immediately ship the inventory rather than putting it away first. Recommend overstocked inventory items for promotional packages to encourage wholesalers to purchase larger quantities and assume some inventory control costs. Ensure legal compliance through strict inventory reconciliation, process monitoring and controls of Type II pharmaceuticals.

Results	Reduction of backorder-to-ship time Compliance with controlled substance inventory control laws Inventory balances available centralized and real-time Improved manufacturing lead times