AzothGallery.com
Johnes Ruta
(203) 387-4933
azothgallery@comcast.net

http://azothgallery.com/
WEB SITE SERVICES
Business References

Contact for Services

On-Line Resume'

Business Analyst in Relational Database design field since 1978, specializing in Corporate applications. Experienced in the functions of liaison in the coordination of I.T. Applications Development personnel with the needs of company department members handling Sales, Marketing, Order Management, Manufacturing Requirements Planning & Purchasing, Shipping/ Distribution/ and Delivery Logistics. Experienced with Accounts Payable & Receivable, and Corporate Financial applications. Experienced providing system users with feasibility and methodology estimations, training, and efficiency planning.

Business References

Web-Site Development: artist sites; on-line retail & automated order entry management; scholarly forums:

 

Business Resume'

Senior
Programmer/Analyst: Data Warehousing, Business Rules Analysis, On-Line Analytical Process,
Financial & statistical Forecasting, Distributive, Manufacturing, and Engineering logistics; with expertise in pro-active communication, systems integration, conversions, implementations, and documentation.

Skilled writer and researcher: art curator & consultant: The YORK SQUARE CINEMA GALLERY ; former Managing Editor of arts newspaper.

Software History:

Hardware History: Windows NT; IBM AS/400, IBM S/36 /34; DEC Minis; WANG 2200/VS Virtual Memory System; Data General ECLIPSE and NOVA III; Burroughs B600.

Languages: AS/400: RPG/ILE , RPGIII, CL, DDS & Subfiles; TCP/FTP; PDM; COBOL/400; RPGII; SYNON; OPNQRY syntax. PDP/11. MICOS Interactive BASIC. Burroughs 12-base Assembler.

 

RECENT CORPORATE WORK SUMMARY

WendyGell Design, Inc.
Guilford, CT.
(Business Partner and Manager, 1997 to present.)

 

R.T. Vanderbilt, Inc. East Norwalk, CT. Senior AS/400 Programmer/Analyst.

Kodak Polychrome Graphics, Norwalk, CT. Senior AS/400 Programmer/Analyst

DETAILED WORK HISTORY

www.WendyGell.com Design, Inc. Guilford, CT. (Business Partner and Manager, 1997 to present.)

Retail Website Developer and inventory image management, using DREAMWEAVER 4.0 & PhotoShop 6.0. Business Development of retail Markets and Tele-Markets (QVC, HSI). Order, Inventory, and distribution logistics Manager. Manufacturing product development, and engineering requirements outsource liaison/coordinator.

R.T. Vanderbilt, Inc. East Norwalk, CT. (Permanent position; 08/2000-04/2001, 01/2002-03/2002)
Senior Programmer/Analyst. BCA Platform Sales and Demand process. Order Entry process: Costing & Currency conversion for Sales Products and Misc Charges expense amounts; Combinable Quantities & Weights; Vendor Invoice matching of Estimated Charges; Journal Voucher Register transaction inflow alignment; Profit & Loss Statement. AS/400
e-Mail interface with
Purchase Order Maintenance: Designed & implement Automated
e-Mail Notification of
C.S.R.’s whose existing Sales Order’s product availability is affected by changes to P.O. Arrival Date and/or Line Item Quantity. Production Planning Report: Production Facility Product Inventory & Demand manufacturing scheduling.
ISO Procedures Auditing observer
. (RPGIII, CL, DDS printfiles, subfiles.)

Kodak Polychrome Graphics, Norwalk, CT. (IBM Global Services, contract; 11/1998-04/2000.)
Senior Programmer/Analyst Interface Detail Design for start-up combined venture of Eastman Kodak & Sun
Polychrome Chemical Co. to market advanced technology digital-to-graphics Plates, digital-to-film Transfer systems,
chemical and film products. Organized & programmed setup of Order Management distribution database and
Supply
Chain Planning
cycle for Warehouse Inventory, Demand Forecasting Units, & Available-to-Promise Qtys, Recommended-M.O.-Shipments and Procurement transactions, interfacing Kodak & Polychrome legacy platform
databases with Manugistics data Replenishment inflow & PRISM database Order Entry Demand & Distribution
logistics. Performed "End-To-End IBM Testing" methodology." (TCP/FTP, RPG/ILE, CL, DDS.)

Unilever-Chesebrough Ponds, Trumbull, CT. (Recupido Associates, P/A contract; 07/1998-11/1998)
Development, consolidation, and enhancement of batch job stream for Sales Order & Daily Shipment Transactions,
and Nightly Reports of Finished Goods, Stock & Item Balances, Pull Sheets, Skid Movements, and Intransits.
Consolidation of Payables Price & Freight Variance Reporting, & Invoice History. Y2K compliance. (RPG/ILE.)

BIC Corporation, Milford, CT. (Recupido Associates, P/A contract; 03/1998-07/1998.)
Systems integration Analyst for acquisition of Sheaffer Pen Company, incorporating Sales History generic
Part Number and numerical Item conversions, Customer/Bill-to/Ship-to hierarchy; utilizing User Defined
Codes tables. Analysis and development of Sales Market Forecasting; Commission Reporting; Rebate Calculation; Y2K compliance;
and implementation of source modification tracking. (RPG/ILE, CL, DDS, subfiles.)

Loctite Corporation, Rocky Hill, CT. (Nemeth Martin Associates, contract; 05/1997-03/1998.)
Senior Programmer/Analyst Chemical engineering applications for international producers of advanced industrial
and specialty adhesives: For the Quality Engineering Division, personally developed and implemented a World Wide Numbering relational database to 9 sublevels of chemistry formulations, interactive with their BPCS Item environment,
data throughput into an INDOC/INQAS database. Built subfile data inflow for offshore subsidiaries: maintenance and
inquiries of hierarchical Bulks, Chemical Raw Materials, PreMixes, Stock Solutions, Finished Goods & Kits packaging organization. Developed metrology formulations for weights and measures conversions. Also, personally designed and implemented a Tariff Bill of Materials Subsystem to automate NAFTA Indented-Item Costing for Preference-
Criteria calculations & Certificate of Origin reporting. (RPG/ILE, CL, DDS, Subfiles.)

United Distillers/ Guiness, Inc., Stamford, CT. (Howard Systems, contract; 02/1997-05/1997.)
Senior Programmer/Analyst BPCS Inventory Depletion System: On Line Analytical Process (OLAP) data
warehousing
to extract and correlate Customer and Product information with incoming Beverage Data Network
input. Updated account history to generate a Comprehensive Fact Table for on-line COGNOS analysis, itemized
by element accounting categories. Implemented realignment processes to multi-record-type system status and history
BPCS files. Implemented BPCS system feed from history to Sales Performance Management. (RPG/ILE, CL.)

Boehringer Ingelheim, Inc., Ridgefield, CT. (Howard Systems, contract; 08/1996-02/1997.)
Senior Programmer/Analyst Utilized Star Schema design tool for team implementation of Data Warehousing system
on a BPCS Inventory database. Business Rules development. Programmed AS/400 batch TCP/ FTP Protocol for
extracted flat-files data conversion of Customer, Product, Charge Back extended files, multiple business and Federal Abbreviation code tables to ASCII format for HP ORACLE environment.

Clinipad Corporation, Guilford, CT. (Super Systems Consulting, P/A contract; 05/1996-08/1996)
Medical accessories supplier. Created, programmed, and implemented an AS/400 BPCS based Material
Qualification Sheet
database
with maintenance and subfile inquiries. Automated a process for determining
MultiVac
Packaging Seal sizing tolerances; created new reporting for Month-End Sales and Profitability Analysis,
and item composition flagging metrology for Parent/Child parts hierarchies. (RPGIII, CL, DDS, Subfiles.)

Raymond Engineering, Inc.(KAMAN), Middletown, CT. (Super Systems, Sen. P/A contract; 05/1995-04/1996.)
Worked with department managers and users on all levels. Programmed DDS subfile inquiries and updates for
Inventory research requirements
for Manufacturer detail files, inspection transactions, units of measure tables,
Work Order and Traveler Receipts
, and for Alphabetic Parts Descriptions. Also wrote and implemented conversion methodology and programs from the IBM to Western Data Systems package for manufacturing contract commitments, purchase order history, requisitions, and for all labor transactions. (RPGIII, CL, DDS.)

G.E. Electrical Distribution & Control, Plainville, CT. (NYCONN Assoc. P/A contract; 03/1995-05/1995.)
Material Requirements Planning system for MAPICS processing of manufacturing orders, engineering change orders,
and bills of material, using bar-code data entry to a suspense file timed-release cycle. (RPGIII, DDS.)

Yale School of Medicine, New Haven CT. (NYCONN Associates, P/A contract; 11/1994-03/1995.)
Developed maintenance/inquiries for demographic, employee information, and appointment scheduling, utilizing
split-screen subfiles & pop-up-window selection. Constructed database descriptions, and decode utilities,
passing parameters for virtual data structure file access and packed decimal data. (RPG/ILE, CL, DDS, Subfiles.)

Shawmut Bank, Hartford CT. (Advanced Computing Techniques, P/A contract; 10/1993-10/1994.)
Letters of Credit: wrote and implemented applications conversions for interfaces of AS/400 software with
bank's mainframe computer for General Ledger transaction posting and Auto Balance comparison.. Developed
and implemented letters of credit Capital-Adequacy day-end and month-end processing flows. Data exchanged
with the mainframe environment via Network File techniques. (COBOL, RPGIII, CL, DDS.)

Jewish Home for the Elderly, Fairfield, CT. (Direct temp Senior P/A; 05/1993-10/1993.)
Enhancements & link reconstruction of Medical Records Dept. interactive data exchange system, utilizing ICD-9
(International Classification of Diseases) and Diagnostic Related Groups cross-indexing structure and statistical
applications for this major convalescent facility. Designed & installed a subfile-driven system log to track existing
medical records system errors requiring correction. User job description setup, and object and user profile
authorizations. (RPGIII, CL, DDS Subfiles.)

Louis Dreyfus Corporation, Wilton CT. (Permanent position, 7 years; 10/1986-05/1993.)
Senior Programmer/Analyst, personally responsible for the design, development, and implementation of
Livestock Facilities Management
on the AS/400: designed and managed a custom EDI distribution for
multi-site daily Transactions & Holdings Position. Met with the user community to determine their business
requirements, performed system analysis and enhancement design, developed programming specifications.
Created an Accounting Reconciliation between three data exchange locations. Also, enhanced Distribution
logistics for Grain Exporting Contracts, and Vessel and Barge Freight System. Converted systems from
RPGII on the IBM System/36 to the AS/400. Developed Futures and Statistics System. Revamped
Corporate
General Ledger Chart of Accounts for IRS tax applications, and for Inter-Office Settlements.
(RPGIII, CL, DDS, Subfiles.)

For Scheuer Textiles, a subsidiary of Louis Dreyfus Corp., was responsible for design and implementation
of a Textile Brokerage Management system, with applications for Broker Balance & Position Summary,
international Letters of Credit, Contract Settlements, Transaction Event master display and Archive Log, built
over SYNON extended virtual and span-access path data relations. (SYNON CASE Tool, AS/400.)

Forschner Group/ Victorinox, Shelton, CT. (Permanent position; 04/1984-09/1986.)
Senior Programmer/Analyst Responsible for IBM/36 commercial import Contracts and Settlements, Warehouse
Inventory & Receipts, Overseas Shipping Logistics, General Ledger, Purchasing systems, and Currency
Conversions. Unification project of three parallel companies' MAPICS OCL applications into one software system.

Peoples Savings Bank Bridgeport CT. (Real-Time Computer Consultants; 01/1981-06/1983.)
Project Leader for development and implementation of an Employee Savings Plan. Met with high-level
users to develop systems design. Analysis of programming specifications requirements. Payroll and Personnel
data-base applications enhancements. (Data General NOVA III screen interactive MICOS-BASIC.)

Bridgeport Regional Physical Therapy Center. (Real-Time Computer Consultants; 06/1983-04/1984.)
Implemented Accounts Receivable billing and Appointment Scheduling systems. (RPGII, OCL on IBM S/34.)

Health Systems International, New Haven CT. (Permanent position, 07/1979-01/1981.)
Programmer/Analyst Professional Standards Review Organization Medical Data management, and software
development of modular interactive systems and federal health care statistics applications. Implemented the
ICD-9
Diagnostic Related Group code systems. Utilized task block architecture control software, and
remote debugging. (PDP/11 Assembler Language on DEC Mini equipment.)

Northeast Data-Com, Wallingford CT. (Permanent position, 10/1977-07/1979.)
Programmed enhancements of intrastate Banking network; Savings Journal, Mortgage Interest Accrual, Installment
Loan, IRS earnings applications. (12-base Burroughs ASSEMBLER on B600 Mainframe.)

Education

New Horizons, New Haven, CT.2001, Certificate: Adobe PhotoShop 6.0.

Stone Academy of Business, Hamden, CT. 1977, Certificate. Computer Programming. Accounting Principles &
Applications.

Southern Connecticut State University, New Haven, CT. 1965-1973, Major: Comparative World Literature.
Minor: Anthropology.

Related Professional Experience
Managing Editor, "The Entertainer," a weekly arts newspaper, Stratford, CT, 1972-1978.
Independent art Curator, the York Square Cinema Gallery, New Haven, CT, since 1988.
Independent scholar: sponsor of Symposia on epistemology, and the histories of art, architecture, & science.
5/2001, 11/2001.
Planning Committee member, and program organizer of "Terra Continuum / Projects for a New Millennium" sponsoring civic-arts projects to build public awareness and knowledge of the arts, sciences, and technology in history and modern life; since 2001.