Teresa A. Landicho

**** ***** **

Oceanside, Ca *2056

650-***-****

adg9nl@r.postjobfree.com

SUMMARY

Extensive experience as a programmer/analyst in the real estate, insurance, manufacturing and retail industries. Upgraded systems, customized enterprise resource systems (ERP), performed integration and system conversions. Flexible, cooperative, patient and calm. Very proficient in customizing and maintaining and writing conversion programs for ERP software (15+ years of J.D Edwards, 7+ years of PRISM and KRONOS).

SKILLS

Languages

Proficient in: RPGIII/IV/ILE/Free, Control Language and COBOL, CGI Programming on the IBMi Familiar with: Fortran, Java, XML

Software

Database: DB2/400, Microsoft SQL Server 2008

Platforms: AS400/iSeries/IBMi,net.data, Microsoft Windows® 2007, 2000, NT, XP, 7, 8, - All version ERP and other Systems: JD Edwards World A7.3, 8.1, 9.1, PRISM, KRONOS TimeKeeping, EDI

(Inovis), Patrick Townsend FTP Manager,

Report Writers: MSSQL Reporting Services, BCD EZ-Pickins, BCD Catapult, BCD Spool Explorer, Showcase Strategy, Crystal Reports, BCD Sequel Viewpoint, DataImport. inFormDecisions’ Designer, iMap, iDoc, iMail, and iFax Others: CGIDEV2, Websphere, DBU, MS Word, Excel, Powerpoint, Access, Project, Visio, CreatePrint and CreateForm; SoftLanding TurnOver, Aldon Harmonizer and Analyzer, Hawkeye Pathfinder, Faxstar, ROBOT Scheduler, ACMS Lifecycle

Operating System upgrades, hardware upgrades, data conversions, program/system interfaces, daily user support, Sarbanes-Oxley Compliance, EDI, Disaster Recovery Testing EXPERIENCE

JDE Programmer/Analyst 11/18/2013 – 04/17/2020

Curves Jenny Craig, Inc.

5770 Fleet St., Carlsbad, Ca 92008

Supports JDE World A91: Finance-AR, AP, GL, Sales and Purchasing, Inventory, Distribution, EDI (Outgoing Purchase Orders, Incoming PO Acknowledgement, Incoming Invoices), Recurring Billings for Jenny Craig and Curves Centers, all over the US, Canada and Australia. Sole JDE Support for 2+ years.

Supports scheduled download and upload of data from Sonic (Siebel) for Corporate Centers inventory, sales, orders, etc and sales from the internet (JCAH or Jenny Craig At Home) into and out of JDE.

Subject matter expert for forms designing and forms printing using inFormDecisions’ software both on PC and iSeries (JDE reports like checks, invoices, pick list, Purchase Orders, etc printing on forms in the iSeries).

Subject matter expert for Patrick Townsend FTP Manager

Most recent projects calls for RPG free CGI programming for company’s intranet (Franchiser ordering, reports, inquiry programs)

Programmer/Analyst III 9/27/2010 – 11/8/2013

Lactalis American Group

2376 South Park Ave., Buffalo, NY 14220

AS/400 Support for Prism and JD Edwards World A73

Wrote programs to received payment data from EDI to JDEdwards A/R System.

Wrote programs to create records for JDEdwards A/P Systems (ledgers) and G/L Entries for payments to vendors made through wires.

Wrote programs to receive payment data from Customers through wires/EDI and convert them to cash receipts/payment records and journal entries in JD Edwards

Wrote all programs for the scanner gun and redesign some screen programs to make it run in a scanner gun to production lines, movement of products from one location to another.

Designed and created the Telecommunication System where invoice data from telecommunication vendors (Sprint, AT&T, Verizon, etc) come through EDI (Gentran) and automatically created vouchers and journal entries in JD Edwards. This also provided a visibility of employees' usage of phone lines assigned to them for management.

Does all other assignments from the manager every now and then (like writing small reports, ad hoc screen programs, etc.)

Consultant to Frontier Communications, Inc. 11/30/2009 – 09/22/2010 Computer Aid, Inc

Assigned to projects for new Systems in the AS400

Assigned to the new Project Verizon Acquisition. Played an important role in this project:

wrote several programs that became the backbone and critical points of the whole system (an xml parser that produced the main file for data for processing in the all parts of the project, wrote all the programs to write the XMLs to be sent back to the various requesting URLs (firm order confirmation xml, billing notice xml, provisioning completion notice xml, rejects xml, cancellation notice xml, TOS2USOCS xml, etc)

Volunteer – September, 2009 – 11/28/09

Huntsville Hospital Auxilliary

serving as a volunteer worker at the Medical Mall (Pre-Test section) and the Seniors' Horizon Consultant to Walt Disney World - November 17, 2008 – February 7, 2009 CIBER, Inc.

Supports the Disney DPMS (Disney Property Management System) which are data and programs used on reservations, check-in, etc of 30 Hotels and Resorts on 14 AS400s. All programs are locally written.

Systems Analyst (Contractor) - March 21, 2008 – November 13, 2008 Apex Systems Incorporated

Contractor to Baxter Healthcare Corporation

7511 114th Ave. N, Largo, FL 33773

Supports JD Edwards World 8.1 and Kronos Timekeeper

Supports and maintains the locally written systems (JD Edwards compatible/format) such as Electronic Workbench for Manufacturing Defect, other small reports and screens.

Used TL Ashford Barcoding to create/design, print shipping and manufacturing barcodes.

Helps maintain and troubleshoot RF scanners.

Adheres to all environmental, health and safety SOP’s, equipment, policies and procedures, including any department specific requirements.

Creates complex prototypes. Code, test, debug, document, and implement complex software applications.

Senior Programmer/Analyst - 2006-2007

Papyrus, Inc., 500 Chadbourne Rd. Fairfield, Ca 94533

Supports and maintains the JD Edwards’ World v. A7.3 Distribution and Sales, Financial (G/L, A/R and A/P)

Writes/Maintains/Supports Interfaces to JDE and the POS systems (ex. processing of daily stores sales and posting to the G/L).

Daily user systems support. This called for talking intensively with users to define what they need, come up with a possible solution to their need, construct the solution, define the test metrics, let them test the solution, let them approve it and then implement the solution. Uses skills in system designs, programming and using several software tools (BCD EZPickins and BCD Catapult, Help Systems ROBOT and other tools available to create reports and/or automatically emailing to Executives, Regional Managers, Vendors, Customers, etc.).

Writes/Maintains/Supports Interfaces to E-Commerce website (processing of orders and sends down data to the Warehouse Management System, sending back order status to the website, sending product data, inventory levels, etc to the website)

Writes/Maintains/Supports Interfaces to EDI System.

Does other duties assigned by Manager.

Senior Programmer/Analyst - 1997-2006

Catellus Development Corporation, 201 Mission St. San Francisco, Ca

Supports and maintains the JD Edwards’ World v. A7.3Job Costing, Financial (G/L, A/R and A/P), Property Management, Asset Management.

Maintains/Codes Interfaces between JD Edwards Modules in World v. A7.3. and other software including EZ-Pay (for AP Check printing), payroll, wire transfers data to BofA, etc.

Undertakes several conversions of data from/to JD Edwards World v. A7.3 and the AS400 to other software/platforms (i.e. Oracle, MS Excel, etc.)

Uses SoftLanding’s Turnover for Change Management tool.

Maintains Document Imaging Software for A/P, Property Tax and Property Management using IBM Content Management and Ascent Capture

Takes annual disaster recovery test at a Sungard hotsite.

Assists Director to implement Sarbanes-Oxley compliance in the iSeries database/security.

Assists JD Edwards World v. A7.3 users in the proper use of the system. Solves user problems as they come along.

Daily user systems support. This called for talking intensively with users to define what they need, come up with a possible solution to their need, construct the solution, let them test the solution and let them approve it and then implement the solution. Uses skills in system designs, programming and using several software tools (BCD EZPickins and BCD Catapult, Help Systems ROBOT, Showcase Strategy. etc) to create reports and JD Edwards CASE for file updates, new file creations, etc

EDI: Positive Pay system format file using JDE Data according to BofA File Formatting. FTP the file to the PC and use the internet to send data to BofA.

For R&D, configured the AS/400 HTTP server (using CGIDEV2 and Websphere in the AS400) and re-coded some self-written screen programs to web-enable them based on CGIDEV2 programming.

Participated in the software upgrade of JD Edwards from A6.2 to A7.3. Regularly did the Cum upgrades until the present Cum 9

Installed Code400 and VARPG software on the desktop for testing and self use.

Assists the Director in the quarterly AS/400 system maintenance (installs operating system upgrades, PTFs, new license programs, etc.)

Maintains vendor software to make sure that they work in our environment and that the installed version is up to date.

Senior Programmer/Analyst - 1996-1997

Atkinson Company of California, 1100 Grundy Lane, San Bruno, Ca

Supports and maintains the JD Edwards’World v. A6.2 Job Costing, Financial (G/L, and A/P), Payroll and Human Resources Systems

Participated (a team of 2) in the upgrade of JD Edwards from A6.2 to A7.3 Systems Analyst - 1991-1996

Kraft Foods, Inc., 100 Halcyon Drive, San Leandro, Ca

Maintained the existing local systems: Crew Scheduling, Payroll, Sick Pay Systems, General Ledger and Sub Ledgers, Cost Accounting, Finished Goods, Raw Materials and Packing systems, Shipping/Warehouse Systems.

Supported the local use of and local interfaces to the Corporate common systems: PROS

(Purchasing, Receiving and Ordering system), Corporate Inventory Accounting system, Quality Control Systems, etc.

Supported and maintained PRISM (Marcam’s): Resource Planning, Management, etc.

Developed, installed and maintained the Barcode System: Sending data from/To the production floor from/to the AS400, from the shipping department from/to the AS400, using barcodes, scanning guns and RF signals.

Acted as the only support person for the AS400 for the San Leandro plant for about 2 years, thereby, acting also as the sole IS contact person for the Plant.

Took charge of the AS/400 model upgrade from B50 to Model 310;

Took bi-annual disaster recovery test for AS/400

Supported the daily operation of the AS/400

Acted as the backup person for the PC and Network Support Programmer Specialist - 1982-1991

PMI Mortgage Company, 601 Montgomery St, San Francisco, Ca

Participated in the conversion of all systems from the System/38 to native AS/400. Also played a major role in overseeing the parallel runs between the AS/400 and the System/38.

Used Aldon’s Harmonizer and Analyzer as change management tools. .

Specifically took charge of the conversion of the G/L and A/P Systems, Premium Accounting System; Supported the Computer Associates’ General Ledger and Accounts Payable Systems which are all coded in COBOL.

Responsibilities includes coding interfaces between these systems and other systems in the AS/400, installing upgrades, insuring integrity of data, etc.

Participated in the major redesign of the entire insurance system which includes design, coding and testing the new system’s database and the design, coding, testing and implementation of the new Pricing System.

Programmer - 1981-1983

Williams-Sonoma, Inc., North Point, San Francisco, CA

Provided the technical support for the maintenance of all mail order programs including inventory system

And Rewrote the inventory system from RPGII to RPGIII for the System/38 to use the new technology of POS

EDUCATION

University of the Philippines

Quezon City, Philippines

B.S., Economics, 1976

TRAINING

2013 Microsoft (Campus Linc, Amherst, NY)

Implementing and Maintaining MSSQL Reporting Services MSSQL Server Management Studio

2009 Ciber, Inc. Online University

Crystal Reports

2000 JD Edwards Costa Mesa, California

ONEWorld Software Common Foundation

Contact this candidate