Johnes Ruta

** ******* ******

New Haven, CT ****5

iPhone 203-***-****

adm3hl@r.postjobfree.com azothgallery.com

RESUME'

Business Analyst Consultant: Supply Chain Logistics Analysis and Management. Relational

Database Design since 1978, specializing in corporate applications, Business Rules Analysis

and implementation: Full Project Life-Cycle Manufacturing Requirements & Resource

Planning. Order Management systems: Sales, Marketing, Purchasing, Shipping/Distribution/ Delivery Logistics. Liaison/coordinator of I.T. Applications development with the needs of company department managers and members, providing users with feasibility, methodology estimations, training, & efficiency planning. Point Of Sale Retail

Technology Desktop Support: Software Technical Analyst & Troubleshooter.

Electronic Data Interface process; Data Warehousing; Statistical Forecasting; Distributive, Manufacturing, and Engineering logistics. Systems integration, conversions, implementations.

Documentation analysis and archiving.

Software History:

PROGRESS Relational Database; Test Partner. Advanced Printer Drivers. Ticket Tracking Systems.

AS/400 Relational Databases: BPCS, PRISM, BCA (Butler-Curlis Associates), MANUGISTICS. Windows Client Access, Attachmate, binary conversions. MS Office: Excel, Word, ACCESS database.

Automated Design utilities: STAR SCHEMA Business data flow; Micrografx Flow Chart. DREAMWEAVER CS3, Website Builder; PHOTOSHOP; HTML Code; JAVA Script.

Skilled writer and researcher: Pro-active communication personality. Art curator & consultant since 1988. Managing Editor of the arts newspaper “The Entertainer,” 1972-1978.

Hardware History: IBM AS/400, IBM S/36/34; DEC PDP/11 systems; WANG 2200/VS Virtual Memory System; Data General ECLIPSE and NOVA III; Burroughs B600 Mainframe. External & Internal MODEM TROUBLESHOOTING, Dialup & Network Adapters.

Languages: AS/400 RPG/ILE, RPGIII CL, DDS & SUBFILES; TCP/FTP; PDM; OS/400, SYNON:

OPNQRY syntax, PDP/11; MICOS Interactive BASIC, Burroughs 12-base Assembler.

Subway International HQ, Milford, CT. Diversified Employment Services, (07/2005 – 06/2008)

POS RETAIL TECHNOLOGY SUPPORT HELP DESK Technical Analyst & Troubleshooter: Franchisee Sales Transmissions; On-line Menu Updates; External & Internal MODEM TROUBLESHOOTING, Modem Initialization Strings. Dialup & Network Adapters. DSL Routers. Ports designations; automated Email. Advanced Printer Drivers. PC Networking. Integrated Major Credit-Card, Gift-Card, & Loyalty Card processing. TCP/IP IP & DNS, LAN. SOFTWARE INSTALLATIONS: SUBSHOP V2005, V2007, V2008, Subway Payment Manager. HOME-OFFICE. REMOTE ACCESS, HYPERACCESS. AliCommLite Communications; PROGRESS Relational Database.

R.T. Vanderbilt, Inc. East Norwalk, CT. (Permanent position; 08/2000-04/2001, 01-03/2002) Senior Programmer/Analyst. BCA Platform Sales and Demand Order Entry system enhancements & legacy problem

resolution: 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 accounting procedures and applications. AS/400 e-Mail interface with Purchase Order Maintenance: automated C.S.R. e-Mail Notification where late P.O. arrival affects Sales Order' product availability. Production Planning Scheduling Analysis Report: Inventory & Demand manufacturing scheduling AS/400 data extract transfer to Windows EXCEL Spreadsheet. ISO-9001 Procedures Auditing observer.

Kodak Polychrome Graphics, Norwalk, CT. (IBM Global Services, Consultant; 11/1998-04/2000.) Senior Programmer/Analyst Interface Detail Design for start-up of Eastman Kodak & Sun Polychrome Chemical Co. to market advanced Digital-to-Graphics Plates, digital-to-film Transfer systems, chemical and film products. Organized & programmed AS/400 setup of Order Management Distribution Database and Supply Chain Planning & Management cycle for Warehouse Inventory, Demand Forecasting Units, & Available-to-Promise Qtys, Recommended-M.O.-Shipments and Procurement transactions. EDI process interfacing Kodak & Polychrome parent Legacy platform databases via TCP/FTP RMTSYS code, and Binary data conversions via MS Attach mate & Client Access, for Manugistics data Replenishment inflow & PRISM database Order Entry Demand & Distribution logistics. Performed “IBM End-To-End Testing” Methodology, and data flow contingency planning.

WendyGell.com Design, Inc. Guilford, CT. (Business Partner / Manager; p.t.: 1997-2005) Retail Website Design & Development: Physical & Image Inventory Management, Customer Database Control, Shopping Cart.Business Development of retail Market Accounts, On-Line Accounts, and Tele-Markets (QVC, HSI). Order, Inventory, and Distribution Logistics Manager. Quick Books Invoicing and Accounting Management. Manufacturing product development, and engineering requirements outsource liaison/coordinator.

AzothGallery.com Web Development Consulting Service (04-2001-Present): samples: http://pangbornties.com/ SHOPIFY Retail website of fashion designer Dominic Pangborn. http://FethiMeghelli.com/ Fethi Meghelli, New Haven printmaker.

Connecticut Department of Protection and Advocacy (Contractor, 2004) Windows Network Operating System troubleshooter. Connecticut voting site Surveyor for Handicap Disabled Access.

Loctite Corporation, Rocky Hill, CT. (Nemeth Martin Associates, Consultant; 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. Personally designed and implemented a Tariff Bill of Materials Subsystem to automate NAFTA Indented-Item Costing for Preference-Criteria calculations & Certificate of Origin reporting.

United Distillers/ Guiness, Inc., Stamford, CT. (Howard Systems, Consultant; 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 data with incoming Beverage Data Network input. Account history to generate

a Comprehensive Fact Table for on-line COGNOS analysis, itemized by element accounting categories. 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, Senior P/A Consultant;08/1996-02/1997.) AS/400 Point Person: Business Rules development:Utilized Star Schema design tool for team implementation of Data Warehousing system on a BPCS Pharmaceuticals Inventory database. 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 Consultant; 05/1996-08/1996) Medical accessories supplier. Implemented an AS/400 BPCS based Material QualificationSheet database with maintenance and subfile inquiries. Automated a process for determining MultiVac Packaging Seal sizing tolerances; created Month-End Profitability Analysis, and item composition flagging metrology for Parent/Child parts hierarchies.

Raymond Aerospace Engineering, Inc.(KAMAN), Middletown,CT. (Super Systems, Senior P/A Consultant; 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; Alphabetic Parts Descriptions. Wrote and implemented conversion methodology & programs AS/400 to Western Data Systems manufacturing Contract Commitments, Purchase Order Requisitions, Labor Transactions.

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 Diagnostic Related Group cross-indexing structure and statistical applications for this major convalescent facility.

Louis Dreyfus Corporation, Wilton CT. (Permanent position, 7 years; 10/1986-05/1993.) Senior Programmer/Analyst, personally designed, 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. 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. Revamped Futures & Statistics System, and. Corporate General Ledger Chart of Accounts for IRS tax applications, & Inter-Office Settlements.

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

Health Systems International / Puter Associates, 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 ICD-9 Diagnostic Related Group code system. Utilized task block architecture control software, and remote debugging. PDP/11 Assembler Language DEC Mini.

Independent ART CURATOR: Gallery Directorships: New Haven Free Public Library 2005-2015; The York Square Cinema Gallery, New Haven, CT, 1988-2005. Playhouse-on-the-Green, Bridgeport, 2003-2007. Art Juror honoraria: Housatonic Museum, Clinton Art Society. Associate Curator: Galley RIVAA & Octagon Gallery, Roosevelt Island, NYC, 2009-present. Creator & co-curator of “Ten Narratives” traveling 10-person group exhibition: Umbrella Arts, 317 East 9th St. NYC. Arts East New York, Brooklyn, Gallery RIVAA & Octagon Gallery, POP 2.0, South Norwalk, CT. Naumann Gallery, North Branford; Hygienic Arts Co-op,

New London; Madison Art Cinemas; Good News Cafe', Woodbury, CT; Solo Juror & Curator: “Hope” group exhibition, 14th Street Y, NYC, 11/02/2012. Guest speaker on Art Criteria, Fairfield County Art Association, 2007.

MANAGING EDITOR: “The Entertainer,” a weekly arts newspaper, Stratford, CT, 1972-1978: supervisor of Contributing Columnists; Chief Copy Editor; Advertising Sales & Management; Computer generated copy Paste-up Design & Production Manager; Theater Critic.

Independent scholar. Creator & sponsor of Symposia on the histories of Art, Architecture, & Science; 5/2001, 11/2001, 06/20/2004, 12/02/2007, 10/24/2010, 04/26-27/2014. Program Committee Co-Chair: ARTISTS’ CONGRESS 1999: 18-month planning for informational convention sponsored by The New England Artist Trust, (New Bedford, MA), and the Arts Council of Greater New Haven; member: Steering Committee. One year of creative writing and independent cultural study: Europe, 1966. Attendance at historical conferences: Cesky Krumlov, CZ, 1995; Prague, 1997. Granada, Spain, 2007; Ortigia, Sicily, 2013.

Board Memberships: The William Meredith Foundation, VP Board Member & Technical Support, dedicated to the promotion of poetry, public culture, and the life works of the U.S. Poet Laureate, 1980-84.

The William Kent Charitable Trust, Trustee, dedicated to the works of the sculptor and print-maker, and to the benefit with annual cash grants to elder artists.

Cable Television Advisory Council, 2008 Mayoral appointee New Haven Representative #2, reporting to CT PURA.

Education

Stone Academy of Business, Hamden, CT. 1977 Certificate in Computer Programming Accounting Principles & Applications. RPG, COBOL, IBM Assembler.

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

Advanced Technology Solutions, North Haven, CT. 2004 Certificate: Net Data Boot Camp., Visual Studio.

Southern Connecticut State University, New Haven, CT. 1965-1973,

Major: Comparative World Literature, Drama, Poetry. Writing. Minors: Anthropology, History.

Contact this candidate