Innovatum Success Stories
System: Bar code Mfg. and Distribution
Platform(s): AS/400, PC
This system uses remote, hand held, RF computers to allow operations personnel to perform all distribution and shop floor transactions on the plant floor, as the physical transactions occur. It communicates real-time with an AS/400 and BPCS, sending asynchronous transactions as they occur using the TCP/IP Sockets protocol. No emulation is employed, in order to keep response times very fast, yet there is no middle-tier (e.g. NT) required, thus simplifying system support. The system runs in a 24×7 operation, supporting the following functions: P.O. Receiving; Put-Away, Transfer, Dispatch and Replenishment; QA Sample Adjustments; Customer Order Picking; Manufacturing Issues and Receipts; Shop Order Material Pegging; System-directed, shortest-path Cycle Counting; and full bar code label production throughout the process. Both the client and server functions were designed, coded, and implemented by Innovatum.
System: Customer Returns
To overcome the tremendous burden of paperwork and manual communications required to process customer returns of pharmaceutical products, this system automates the customer lookup, historical direct and indirect pricing, billing, and regulatory requirements of the process. (As a quick aside for those unfamiliar with this industry, customers may typically return products up to 2 or 3 years of when they were purchased and receive full credit. In many cases, the return is from a retailer which is not even a customer of the manufacturer. In these instances, an historical link must be established between wholesalers and retail buying groups in order to credit the wholesaler for a pass-along to the end customer). The system also creates automated “action items” that get attached to each return based on its contents. These serve as electronic to-do lists for various individuals in the organization, obviating the need for phone calls or faxes in order to close out the return. This system was designed and developed by Innovatum staff.
Project: SAP to BPCS Bridge
Platform(s): AS/400, NT
The ENDO Pharmaceutical company which had been spun off from DuPont Pharma, needed to continue utilizing DuPont’s Atlanta Distribution Center (ADC). ENDO was implementing SAP as their order entry system, while the ADC was managed by BPCS software. Real-time interfaces were established communicating order data from SAP to BPCS, and updating SAP with shipment information. Software design and implementation was handled by Innovatum personnel. Protocols and training were developed in conjunction with ADC and ENDO management teams.
Project: ERP Implementation
Joined a team of 12, including Managers, Programmers, and Consultants in implementing the BPCS Customer Service suite of modules. Was given responsibility for constructing two custom modules. The first was the Standing Order System which created 4000 repetitive BPCS orders a week with minimal human intervention. The second was a drug consignment module which included lot traceable history, inventory management, automated billing, and re-supply based on pre-set order points. Tasks included complete design, programming, and supervision of five contractors. Once the above modules were complete, we were asked to coordinate the implementation of the Logistics Pro distribution system. Tasks included design, programming, and coordinating in-house and software vendor resources. New interfaces were written, and BPCS programs modified. Consequently, we were able to update orders into Log Pro automatically, and to perform unattended BPCS confirmation when a shipment was closed in Log Pro. All programming was performed in AS/SET and RPG. At the conclusion of the project, our personnel were retained to provide support and to train DuPont Merck programmers.
System: Patient Registration and Billing
Platform(s): AS/400, NT, UNIX
Performed analysis, design, and programming as part of Dana Farber’s institution wide team to upgrade patient registration systems. Specialized in updating of insurance database residing on AS/400, with registration data maintained on the VAX and communicated through TCP/IP. Acted as Quality Assurance Coordinators for final stages of the project. Modified and enhanced Keane Med patient accounting modules. Managed a project team of six Senior Programmer Analysts in completely revamping the Institute’s Billing System as mandated by the Uniform Billing 92 requirements.
Project: Pre-cutover Performance Testing
Prior to a major BPCS implementation, we were hired by our client to perform a major study simulating the on-line and batch loads that would be seen on the client’s AS/400 systems. Developing automated on-line scripts which manipulated multiple terminal sessions, along with building ROBOT batch job schedules, we were able to simulate over a week of usual- and peak-load performance data for the customer. As a result of the study, the client decided to make an accelerated purchase of a hardware upgrade which averted a major delay in customer service responsiveness with their systems