I have over 25 years of IT Consulting experience implementing Computer systems in South Africa, United States, United Kingdom, Netherlands, Italy, Germany, Monaco, Switzerland and Hong Kong. As a consultant at Sotheby's, New York for almost 13 years I led the customization and implementation of their Auction processing system at European and Asian locations - requiring language, currency, taxation and European Union regulation changes. I also led the Direct Marketing effort, having designed and implemented a Data Warehouse and an automated free-form entry selection tool. According to management, the tool increased Auction attendance at world-wide locations. I have since designed a web-based tool, a youtube demo can be viewed at: http://www.youtube.com/watch?v=RfZSdnfZuss .
August, 2007 -
WEB-BASED ORDER ENTRY: Responsible for designing, coding and implementing the following Web-to-Mainframe interfaces : Order Create, Payments, Credit Analysis, Goods in Transit and Credit Card Refunds. XML messages exchanged via MQSeries. All interfaces written in Ideal/Datacom/DB, Cobol/Datacom/DB or CICS/Datacom/DB.
AMERICAN EXPRESS CREDIT CARD: Responsible for Accounts Receivable changes to accept American Express credit card payments. All programs written in Ideal/Cobol/Datacom/DB.
April, 2006 - June, 2007 Consultant
CONVERSION FROM IMS TO COBOL DATACOM (SQL): Responsible for the conversion of all batch reports from an IMS Database to Cobol/Datacom/DB SQL option.
COMBINED CLIENT NAME AND ADDRESS: Implemented a combined Client Name and Address procedure that retrieves all roles related to a Policy and, assigns an Address of preference to each role. Developed using Cobol/DATACOM/DB SQL option. Duties included providing guidance and training in Datacom/DB.
May, 2005 - December, 2005 Consultant
SUPPLY CHAIN - LIFT OPERATIONS: Design, Code and test Warehouse Lift Operations for a Supply Chain System. The system provided Lift Operators with the ability to perform Putaways, Letdowns, Inventory transfers, Bulk Picks and lookups for Slot, License plate and Product information. All functions selected off the Lift Operator menu. Screen entry is made via a scanning device or keyboard entry. I wrote the entire system in CICS/DATACOM/DB.
February, 2004 - May, 2005 Consultant
FINANCIAL SYSTEMS: Enhancements to numerous sub-systems written in Cobol/Datacom/DB. Also worked on a rewrite of the CONTRACT PRICING SYSTEM in Ideal/Datacom/DB, Cobol and CICS.
December, 2003 - February, 2004 Consultant
PROMOTIONAL ALLOWANCE: Lead Developer, responsible for 9 developers. The system tracks Purchases from Vendors and calculates rebates acquired based on sale contracts negotiated by the Marketing Department. Developed using IDEAL/DATACOM/DB, COBOL and CICS.
June, 1989 - September, 2003 Consultant
CLASS ACTION: US Justice Department Responsible for designing, coding and implementing a Commission Claims system for a Class Action suit. Commissions paid or received 9 years was extracted, transformed and loaded, from worldwide systems current and defunct into a DATACOM/DB. A tape of ownership and settlement records were generated for an outside vendor to process payments. Developed using IDEAL/DATACOM/DB, COBOL and CICS.
DIRECT MARKETING: Responsible for designing, coding and implementing a Direct Marketing system to promote sales at worldwide locations. The main design components : A Data Warehouse using the dimensional model approach. Nightly batch Data Warehouse population routines. A free-form entry screen to select clients demographic, geographic or historical for marketing campaigns. A built-in interpreter and code generator I designed and coded translated free-form entry to executable Ideal/Datacom/DB code. Response Tracking. Electronic output routing FTP/SMTP to worldwide locations. Campaign Management. Developed using IDEAL/DATACOM/DB and COBOL. Languages : IDEAL/COBOL
Previously marketing campaigns were generated by an IT person, requiring 1 - 5 days. With the new system, the Marketing department generated campaigns in 5 to 30 minutes, on-line. In addition, campaigns could be merged, purged and fine-tuned on-line targeting a precise market segment at low cost. Management credited this system with boosting sales/attendance at worldwide Auctions. I have since developed a web-based version using VBScript, ASP, Java script, SQL and XML, following is a link to a YOUTUBE presentation :
http://www.youtube.com/watch?v=RfZSdnfZuss
DATA CONVERSION and CLEANSING :
STARS: A worldwide Auction system New York, London, Amsterdam, Milan, Paris, Monaco, Zurich, Geneva, Munich and Hong Kong. The main components : Property from Receipt to Sale. Property Transfers in worldwide locations. Inventory. Billing. Special features : 7 languages. Multiple currencies. Domestic and Foreign taxation. Import/Export documentation. Electronic report routing via SMTP. I participated in all phases of project development .I was solely responsible for system implementation in Europe and Asia. Extensive changes were made to accommodate the new EU VAT Value added Tax which was in its infancy and very fluid at the time. Developed using IDEAL/DATACOM/DB, COBOL.
CONSIGNOR PAYABLES: An Accounts payable system maintaining accrued charges for consigned property, payments for sold property and, outstanding balances. As part of the reconciliation process, an interface was developed to extract Accounts Receivable data to maintain outstanding balances this situation is unique to the Auction business as a Buyer could be a Seller as well. Participated in all phases of project development. Developed using IDEAL/DATACOM/DB, COBOL. Catalogue Subscriptions System generates catalog fulfillment based on categories subscribed and upcoming sales events. The system included Billing and Catalog Promotion components .I participated in all phases of project development. Developed using IDEAL/DATACOM/DB and COBOL.
CATALOGUE SUBSCRIPTIONS: System generates catalog fulfillment based on categories subscribed and upcoming sales events. The system also included Billing and Catalog Promotion components. I participated in all phases of project development. Developed using IDEAL/DATACOM/DB and COBOL.
February, 1989 - June, 1989 Consultant
ENCONTER CLAIMS: This system matches patient claim data received on tape against patient s history and other criteria to determine validity. Exceptions are highlighted and reported on. Developed using IDEAL/DATACOM/DB.
PROVIDER REPORTING: Corrected and implemented all Health Care Provider reports. Developed using IDEAL/DATACOM/DB.
April, 1984 - January, 1989 Consultant
REGISTERED BOND INTEREST DISBURSEMENT TICKLER: Responsible for the design, coding and implementation. Using a date selection screen, users enter disbursement date parameters. The system tracks disbursement cycles, calculates the projected date and triggers interest payment orders. Developed using IDEAL/DATACOM/DB, COBOL.
REGISTERED BOND INTEREST DISBURSEMENTS: Responsible for the design and implementation. This system manages interest payments to bond holders based on holdings. Tracks deposits by Bond Issuer, maintains balances and projects check mailing dates to bond holders based on geographic regions. Developed using IDEAL/DATACOM/DB, COBOL.
CHECK RECONCILIATION: Responsible for design, coding and implementation. Using tapes containing checks cashed and cleared through the Clearing House, the system tracks check movement and produce a Bank Reconciliation statement. All exceptions are reported on. Developed using IDEAL/DATACOM/DB, COBOL.
BOND CERTIFICATE INVENTORY: The subsystem maintains issuance and re-order of bond certificates, prints Bond certificate forms using user pre-defined print templates. Developed using IDEAL/DATACOM/DB, COBOL. Prior to 1984 South Africa
Prior to 1984 (South Africa)
C.G. Smith Mills , Durban , South Africa Order Entry The main components : Local , Rail and foreign order entry Back order tracking . Billing . Inventory . Sales Reporting . Management functions . Developed using Mantis , Cobol and TOTAL Database .