Robert Gavila

2023 43rd Street

Astoria, NY  11105

(Home) 718-956-1991 (Cell) 917-916-1991

robertgavila@cs.com

 

JDE World Programmer/Business Analyst

 

SUMMARY:

 

An IT Professional with twenty-nine years of experience applying technology to business needs.  Coded JD Edwards World solutions for twenty-one years.  Applied VBA in Excel to bridge gaps in system functionality. Programmed QlikView 11.20 in support of finance, sales and marketing.  Excellent technical, communication and interpersonal skills.

 

EXPERIENCE HIGHLIGHTS:

 

M. Z. Berger, Queens, NY

Programmer/Analyst  (January, 2007 – April, 2019)

Coded custom solutions in JD Edwards World (8.1) to support business needs:

       Wrote a Vendor Managed Inventory System to support Canada Shoppers Drug Mart business

       Supported HK-based Direct Import and International business by adding linked SO-to-Work Order-to-PO functionality in JDE

       Supported top level managements strategic initiatives with enhanced consolidated inventory reporting

       Added custom reports in QlikView intranet reporting system

       Upgraded and maintained QlikView system

       Bridged gaps in financial reporting with custom downloads into Excel VBA solutions

 

Argy Associates, Queens, NY          (April, 2005 – January, 2007)

       Consulted on a JDEdwards World (8.1) assignment. Assumed responsibility for projects in process   Completed various projects in progress.  Accepted a full-time position after four months.

       While on a sabbatical, studied PHP/Javascript/HTML/CSS and MySQL programs for designing and managing a secure intranet applications

 

Sanofi-Aventis, Inc., New York, NY                                                            1988 – 2005

 

Supply Chain Systems Project Manager (June, 2000 – March, 2005)

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

       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.  Assumed full responsibility of maintaining and expanding this LotusScript/HTML/Javascript-based project after it went into production.

       Coded and supported various Visual Basic and VBA applications, servicing diverse areas, such as production planning, daily sales and financial reporting.

       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 (September, 1997 – May, 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 (November, 1994 – August, 1997)

       Responsible for month end close, consolidations, and reporting to Paris headquarters.  Recruited, trained, and supervised a staff of seven accountants.

       Utilizing VBA/Excel, designed, coded, and implemented solutions to automate booking of the payroll entry and upload spreadsheet-based journal entries to JDE G/L.  Reduced accounting staff headcount with new efficiencies.

       Set up Automatic Accounting Instructions (AAIs) for JDEdwards Fixed Assets module during a migration from MSA Fixed Assets System.

 

Fixed Assets Systems Specialist (January, 1991 – October, 1994)

       Supervised the listing and tracking of fixed assets within the MSA fixed assets system.  Prepared year-end fixed assets tax packages.

 

Accounting Supervisor (April, 1990 – December, 1990)

       Trained and supervised three accountants.  Assisted in preparation of managerial reporting and month end estimates.  Trained as an end user on JDEdwards World version 6.5.

 

Accountant (June, 1989 – March, 1990)

       Responsible for coding various payables, booking general ledger entries, month end close, balance sheet analyses and various reconciliations.

 

Prior to 1988:

            Various non-IT related positions.

 

EDUCATION:

            Bachelor in Business Administration (Accounting major), Magna Cum Laude

            Bernard Baruch College, New York, NY                                                                       1995

 

            Certificate in C Programming for Windows/ DOS,

            New York University, New York, NY                                                              1998

 

            Associates in Applied Science in Computer Programming,

            Queensborough Community College, Bayside, NY                                            1989

 

MISCELLANEOUS:

Studied project management in study groups using Project Management Institute materials.  Completed a water-harvesting project in Obinagu, Nigeria, via board membership in Water for Life in Africa (waterforlifeinafrica.org), a non-profit organization based in Queens, New York.  Programmed a commercial educational app in iPhone IOS (Objective-C).