Robert Gavila - Programmer, Artist, Writer

Robert Gavila
20-23 43^rd Street
Astoria, NY 11105
(Home) 718-956-1991 (Cell) 917-916-1991
rgavila@compuserve.com

Programmer and project manager with extensive experience in managing and coding projects from inception to completion. Strong background in pharmaceutical industry and technical aspects of design and printing. Expertise in conceptualizing, developing and delivering intranet products to streamline operations.

Core programming skills include:

Ten years supporting/modifying JDEdwards (World) ERP applications (RPGIII/ CL)
Javascript/HTML/LotusScript coding within Lotus Notes 5.0 environment
Java/XML/Common Gateway Interface with C
Extensive Visual Basic for Applications coding within MSExcel and MSAccess

Core application skills include:

JDEdwards World ERP (G/L, Fixed Assets, SOM, AR, AP)
Microsoft Office Suite (MSExcel, MSAccess, MSWord, Powerpoint, MSProject)
Domino R5 Notes Application Development
Percussion Powerflow
Adobe Photoshop 7.0.1

M.Z. Berger, Queens, NY (February, 2007 - Present)
International Merchandising Company

Designed and coded a workflow process within JD Edwards, from sales order processing, through purchasing, work orders, receiving, shipping, and invoicing.
Supported JDEdwards "World" 8.1 modules

Argy Associates, Queens, NY (April, 2005 - January, 2007)
Software company (sole proprietorship)

Consulted on a JDEdwards "World" project for an international merchandising company. (September, 2006 through January, 2007)
Created the EZXFoundation ™ code base for open source application program development.
Designed MySQL database for security aspects of browser-based applications.
Designed and coded PHP/Javascript/HTML/CSS and MySQL programs for designing and managing a secure intranet application suite.
For Crossover Comics, performed all aspects of digital prepress for the production of a 44 page comic book: scanned artwork, processed in Photoshop 7.0.1, and created output files for professional printing service.

Sanofi-Aventis, Inc., New York, NY

1988 - 2005

Supply Chain Systems Project Manager (2000 - 2005)
Responsible for maintenance, modification, and support of JDEdwards World ERP Supply Chain modules (Sales Order Management, Inventory, EDI, Warehouse Management System).

Created a suite of Visual Basic applications to convert newly migrated SAP financial data to Paris HQ reporting format within my last two weeks with the company. I met a critical deadline during a period of extremely scarce resources, despite not having any direct responsibility for this objective.
Extended the functionality of JDE User Defined Code tables to allow tracking of products with intelligence-coded lot numbers, reducing time to prepare profit-elimination reports to Paris HQ.
Served as an adjunct resource in an HR web-enabled workflow project, utilizing Extreme Programming (XP) methodologies to achieve all primary deliverables on a timely basis.
Conceptualized, coded, and persuaded adoption of two sales force automation products utilizing existing intranet technology to save company outside fees while also streamlining operations.

Business Systems Analyst (1997 - 2000)
Responsible for maintenance, modification, and support of JDEdwards World ERP Financial modules (General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Fixed Assets).

Assisted the sales force automation staff by coding executable programs in C to remotely patch Windows Registry errors in hundreds of newly delivered laptops, easing the adoption of new technology by the sales force.

Accounting Manager (1994 - 1997)
Responsible for month end close, consolidations, and reporting to Paris headquarters. Recruited, trained, and supervised a staff of seven accountants.

Designed, coded, and implemented a VBA/Excel based solution to automate booking of the payroll entry.
Conceptualized and coded a VBA/Excel utility to upload spreadsheet-based journal entries to the JDE G/L. Reduced accounting staff headcount with new efficiencies.

Fixed Assets Systems Specialist   (1991 - 1994)
Supervised the listing and tracking of fixed assets within the MSA fixed assets system.  Prepared year-end fixed assets tax packages.

Accounting Supervisor   (1990)
Trained and supervised three accountants.  Assisted in preparation of managerial reporting and month end estimates.

Accountant   (1989 - 1990)
Responsible for coding various payables, booking general ledger entries, month end close, balance sheet analyses and various reconciliations.

Marketing Administrative Assistant   (1988 - 1989)
Responsible for typing various reports, marketing plans, and correspondence utilizing Wang and WordPerfect word processors and graphing software, arranging flight and hotel accommodations, and other administrative duties.

Prior to 1988
Previous work history includes eight months as a bookkeeper for a footwear importing company (E.S. Originals, New York, NY), and a year on various word-processing assignments for temp agencies.  Earlier work history includes eight years as a haircutter, and four years working alternatively as a musician, bus driver, clothing salesman, yellow cab driver and private limousine service driver.

Education:

Bachelor in Business Administration (Accounting major), 1995
Magna Cum Laude (Graduated in top 6 percent with 3.68 GPA)
Bernard Baruch College, New York, NY

Certificate in C Programming for Windows/ DOS, 1998
New York University, New York, NY

Associates in Applied Science in Computer Programming, 1989
Department award for highest grade point average (3.86)
Queensborough Community College, Bayside, NY

Additional information:

Consulted as a pay scale analyst for the St. John's Preparatory School Teacher Association (2002 and 2005). Currently studying ASP.Net 2.0 and Visual Basic.Net. Project Management Institute member since 2004. Self published comic book writer and artist.

Top of Page
Education
Experience