Portfolio
Here is a small sample of the type of projects which Organon Professional Services (OPS) has completed for our clients:
Decision Support System Development
MCMS - Managed Care Market Share DataMart
MCMS DataMart serves as a repository for market share data aggregated from several third party data providers. Analysts access this DataMart in a variety of ways, including rich online reports with customizable filters and time-series trending, pre-formatted spreadsheets with live links to the DataMart to allow instant updates, and MS Access databases for true ad hoc analyses.
This DataMart was a turn-key OPS solution, including hardware installation, database and report software configuration, and batch job creation. OPS worked closely with its client's IT staff to ensure the solution met corporate IT guidelines, and ensured that effective knowledge transition occurred so that the client's staff could maintain the solution.
DispenseMart - DataMart of Pharmacy Dispensing Activity
DispenseMart was built to enable an innovative rebate program for one of our clients. Individual pharmacies with high compliance to program goals (high generic utilization, for example) qualify for higher rebates. Measured compliance rates are used to drive customer behavior, set stretch goals, and enable salespeople to work through "what-if" scenarios with customers to reinforce program participation. In addition, DispenseMart has provided a rich analytical resource for the client, enabling product and program management teams to validate assumptions and directly measure market behavior.
DispenseMart imports text files on a daily basis from multiple data providers using automated ftp processes run from SQL Server jobs and using SQL Server 2005's BI tools. Custom code was developed to identify invalid files and to quarantine bad records. OPS developed a custom "Control Center" application to let non-technical client staff easily make decisions about quarantined records. These decisions are recorded by the application, so that subsequent records with similar conditions (for example, a new customer or item number) can be automatically loaded without further user intervention.
Supplier "Fee For Service" System
OPS developed a Supply Chain management application and supporting business processes to track several hundred supplier contracts, and to automatically calculate billing based on complex, multi-tier supply agreements. The project is integrated into the client's monthly close process, and includes a secure reporting portal, an administrative application to enter vendor contract information, and a process to automatically generate billing backup documents.
Deploying this application included the integration of data from several systems into an operational DataMart. The source systems included SAP, an enterprise data warehouse, and a locally-maintained database of contract parameters. OPS created scheduled jobs and used the AETL utility to create "hands-free" data loads into the DataMart.
Forecasting and Pricing Software
Competitive Pricing System
OPS has developed a database application that is used to monitor competitive prices for products offered in the client's marketplace. The application tracks product pricing trends, frequency of change, credibility of sources, and importance of source. This information is then presented to the individual responsible for making the decision whether to change an items contract price.
Monthly and Quarter Close Model
This SQL Server based financial modeling application extracts budgets, sales, and inventory data from the ERP system, and forecasts quarterly revenues and inventories. The information produced by the system is used to anticipate upcoming orders and manage daily on-hand inventory and shipments to budgeted levels.
Workflow Software
Salesforce.com implementations
OPS has developed Salesforce.com implementations for several firms in the pharmaceutical supply chain. These implementations have involved full backend integration of sales and product pricing, marketing campaign integration, and inside / field sales integration.
Campaign Builder
This application is a front-end to a Salesforce.com implementation for an inside sales organization of over 140 sales managers which offer product and price opportunities to pharmacists. The native Salesforce.com campaign offering lacked adequate workflow and backend integration. OPS developed a workflow enabled application that allows product marketing, pricing, sales operations, and inside sales to originate, approve and release marketing campaigns which include telemarketing scripts, key talking points, pricing, offering dates. The campaign builder application interfaces to purchase history to automatically select prospective customer based on likelihood to purchase the proffered items.
Customer Program Enrollment
This application serves as a central repository of customer enrollment in services offerings across all divisions of a multinational Fortune 50 company. Multiple acquisitions and joint ventures have led to disparate customer databases and computing platforms which has made it impractical to centralize customer information into a single ERP system. However, there was a strong need to present a consolidated view to customers. This application pulls information for over 40 customer service offerings from 8 divisional systems and presents a consolidated customer database for analytics and reporting.
Data Warehouse / Business Intelligence System Usability
OPS has developed a suite of tools to facilitate the creation of SQL Server based DataMarts. These tools provide functionality missing from the SQL Server development environment
Central Error Handler
This tool simplifies the process of monitoring the log files created by Business Intelligence load processes and centralizes reporting. The user interface is very easy to use and speeds problem identification and notification.
Validator
This application is a business-rule engine which centralizes the process of ensuring the data integrity of a DataMart or data warehouse. Validator applies business rules to data from source systems, identifying out-of-sync conditions, bad records, and new master data elements. Validator can be configured to send emails to business and system owners when it detects out of tolerance situations.
EDFC - Enterprise DataFlow Coordinator
This dependency management tool coordinates the extraction of data from disparate systems with multiple timing dependencies. EDFC interfaces with industry middleware and messaging tools (such as IBM MQ, MS BizTalk, MSMQ, etc.) and communicates with each individual system of record to ensure that data is extracted only after the system of record's local update process completes.
AETL - Automated Extraction, Transformation, and Load utility
This tool supplements the data loading functionality of SQL Servers DTS/SSIS components. AETL constantly monitors directories on the network for the presence of data files. When AETL detects a new file in a directory, it opens the file, pre-processes the format, and transfers it into a landing pad area in the SQL Server database for validation and loading.