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 managementÕs 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).