To approve a corporate merger the Federal Trade Commission required us to sell off a division to prevent having a monopolistic market share. To avoid software licensing complexities and for business continuity, the purchaser was allowed to be umbrellaed under our existing software license and remained hosted on our servers for two years. Environment was CA-PRMS Enterprise Resource Planning on an IBM I-series.
Created a new instance, updated key values while porting master files and transaction history data into the new instance. Scrubbed same data from old instance. Set security to prevent cross access. Hard due date or merger would be cancelled. Federal auditors inspected through process. Trickiest was incomplete transactions like a partially complete work order, AR unapplied cash or AP/PO partial match in receiving. Some of the most challenging fun I had in 30 years of IT
ETL ERP via SQL
To approve a corporate merger the Federal Trade Commission required us to sell off a division to prevent having a monopolistic market share. To avoid software licensing complexities and for business continuity, the purchaser was allowed to be umbrellaed under our existing software license and remained hosted on our servers for two years. Environment was CA-PRMS Enterprise Resource Planning on an IBM I-series. Created a new instance, updated key values while porting master files and transaction history data into the new instance. Scrubbed same data from old instance. Set security to prevent cross access. Hard due date or merger would be cancelled. Federal auditors inspected through process. Trickiest was incomplete transactions like a partially complete work order, AR unapplied cash or AP/PO partial match in receiving. Some of the most challenging fun I had in 30 years of IT
Erotic roleplay via SQL…
DELETE FROM wardrobe WHERE item = 'pants' AND owner = 'you';Oh noes, now my microcode is accessible, better apply a PTF and IPL