In 1990 Sterling Software bought rights to develop and distribute EDITRAN, at that time three developers were hired to modify and develop EDITRAN which Sterling renamed Gentran. Bill Oskowski, one of the owners of Jigsaw Solutions, Ltd. was one of that original team hired to work on Gentran. Over the course of four and 1/2 years Bill worked on Gentran and became project lead for the Gentran Plus, Gentran 400 communications and Supertracs 400 products.
Ohio Bureau of Workers Compensation
(BWC) Health Partnership Program (HPP)
Michelle Oskowski also was employed as a Compuware consultant and became involved in EDI by being named team leader and lead technical analyst for the Ohio Bureau of Workers Compensation (BWC) Health Partnership Program (HPP). This program automated BWC claim processing using EDI to communicate with 60 Managed Care Organizations (MCO's) across the state of Ohio.One of the biggest challenges of this project was the state mandate that all 60 MCO's had to do certification testing during the same time period and all 60 MCO's had to go production the same day. The system has been in every day use at BWC since 1998 with few problems.
EC/EDI Line of Business
Both Michelle and Bill were involved in creating an EC/EDI line of business (LOB) in the Columbus Compuware branch. This process entailed educating the branch and management about the possibilities of EC/EDI in the Columbus market, giving a go/no go presentation to branch management and then creating/hiring a team to implement the concept. In the eighteen months that Michelle was line of business manager the LOB went from the initial two people to thirty people earning an estimated $3.1 million in annual sales.
The following are a sample of the projects and support efforts we have been involved in over the last decade
Designed and developed an Advance Program to Program Communications (APPC)/Advanced Peer to Peer Network (APPN) system that used AS/400 journals to propagate data throughout a national network of 14 AS/400's to ensure sales/purchasing pricing system data was in sync across the nation.
Designed and developed an AS/400 to NT to PC sales/pricing system that allowed pricing updates from sales personnel in the field collected on laptops to be propagated though out a nationwide network of 14 AS/400's. The system used PC dial up access to collect and collate the pricing data that was then transferred from the local NT machine to the regional AS/400. The data was then transferred via an APPC/APPN communication system through out the national network. The system also archived and restored PC information up on request and allowed dynamic updates for new PC software via the AS/400-NT network.
Supported an AS/400 based EDI wholesale pharmaceutical distribution system. Supported included AS/400 queries and SQL and featured reports and EDI processing alerts via AS/400 e-mails using Simple Mail Transfer Protocol (SMTP). The system also used ODBC to access and query against AS/400 DB2 data bases.
Converted the Ortho EDI system from Monsanto to Scotts after Ortho was purchased by Scotts. Centralized and expanded Ortho's distribution system via EDI and frame relay/FTP to simplify and stabilize Ortho EDI Van processing. Designed and implemented a SMTP e-mail pager alert system that allowed "hot batch" hourly processing to meet Ortho's business distribution requirements. System also featured a FTP/frame relay connection to a JDEdwards ERP package processing on an AS/400. The project also entailed converting, modifying and developing a number of EDI maps (please see the EDI section for details about the EDI transactions).
Designed and implemented the Bank One Refund Anticipation Loan (RAL) program. This project was developed on the basis that from the tax refund loan application at a remote loan office, verification through the IRS that a refund was due, credit check and loan approval or denial, total processing time was one hour or less. The system was based on an IBM main frame and used CICS/DB2 as the data base engine and to process the loan applications.
Performed as the lead technical analyst at Computer Sciences Corporation (CSC) on a project to first select a pool of vendors (5) from which to select a Unix EDI Translation system. The project entailed detailed questionnaires and interviews with software vendors, and then detailed scripted demonstrations of the software from the pool of the five finalists for selection of an EDI translation product. Was also heavily involved in developing and supporting EDI maps that were used to exchange rate information between Enron and other electric utility companies to facilitate deregulation (please see the EDI section for details about the EDI transactions).
The Jigsaw EC team is currently involved in supporting the EDI network we helped develop for Ortho. The team played an integral role in the effort to centralize Ortho's EDI processing, which entailed developing maps for purchase orders, invoices, advance ship notices and reverse purchase orders, for 12 agents, 4 warehouses and more than a dozen customers. Michelle was also involved in Y2K testing and implementation ().
Was involved in EDI mapping support for the SAP/Unix EDI implementation for the Scotts Company.
Jigsaw Solutions consultants have experience with the following;
IBM S/390 Main Frame IBM AS/400 NT Server 4.0 IBM RS/6000 AIX
Sun Solaris Windows 95 Windows 98 NT Work Station 4.0
Red Hat Linux 6.2