We provide IT Staff Augmentation Services!

Systems Consultant Resume

Dorado, PR

CAREER SUMMARY:

Have 26 years of experience in Manufacturing and Distributions environments; bilingual (English and Spanish). During these years I have work in United States and Puerto Rico. Have work with different ERP Systems that requires data migration, interface from one system to another, analysis, design and programming from the concept to live production.

TECHNICAL SKILLS:

MySql, PHP, JavaScript, CSS, Clarity, Progen Plus, Mapics Infor, Power Link, Integrator, Mapics XA, EDI (OB10), DDM Files, JDE World Software, Dream Writer, Prism, Kronos, HTML, SQL, SQLRPGLE, DDM files, IBM iSerries, IBM AS400, FTP, DB2, DDM, RPGFREE, SQLRPGLE, RPGILE, RPG IV, RPG III, RPG II, CLP, EDI, FTP, SDA, DDS, PDM, Query, DBU, RLU, BRMS, Turnover, Hawkeye, Microsoft Office Suite, (Excel, Word, Project, Visio, Outlook), Rumba/400, TL Ashford, Advance system utilities (TAATOOLS), as400 Job Scheduler, KRONOS, Client Access, Lotus Notes e - mail, Robot Help Systems, PRISM, BPCS, IBM System 38, IBM System 36, IBM System 34, IBM System 3, COBOL.

PROFESIONAL EXPERIENCE:

Systems Consultant

Confidential, Dorado, PR

Responsibilities:

  • develop on PHP, to be executed on an Intranet server, it shows fast and accurate, easy way for the employees to receive medical care by the internal Doctor.
  • Provide a Work in process Report showing all plant Work Order current completion status in a percentage base.
  • Electronic Purchase Order Approval project; was another project to control the flow of the approval process at Confidential .
  • New ERP System to replace the current AS400 PRMS system to Oracle R12 system than runs in corporate.
  • Give Support to the AS400 system and the current ERP PRMS system while the implementation is taking effect.
  • Created a WIP Analysis report showing all plant Work Order current completion status in a percentage base. It is submitted to the Confidential staff every Monday to monitor the progress of all products currently in process in the ERP PRMS system.

Consultant

Confidential

Responsibilities:

  • Develop a Dashboard Task Management (DTM) system Application to monitor all projects, request and problems that are submitted by the user community to the IT department.
  • Setup the AS400 Email capabilities to be able to sent reports from an IBM iseries (AS400) to any user on the Internet using SMTP configuration.
  • Upgrade JD Edwards from version 7.3 to version 9.2.1. Modify their In-house RPG Programs to the new version.
  • Develop a new RPG Program to adjust the invoice data into their current printing form. Did some mandatory data corrections using SQL.
  • Inventory Value; Active and Inactive Inventory; Mass Update to the Item Sales Class Code using an Excel Spread Sheet; Automatic “Base Price” update, using Cost Method; Cost of Service; Sales History Total by salesman for performance bonus. Purge JDE old history data. Download some of the AS400 table to Excel, for management Analysis.

Web Development using the following: PHP, MySQL, CSS, JavaScript, jQuery, Google Visualization graphics.

RPG Mainframe Specialist

Confidential, Jacksonville, Florida

Responsibilities:

  • Upgrade from XA to Infor; Corporate Support; Kan-Ban system transfer;Pectus replenishment; EDISystems, Sales Dashboard; TipQainterfaceusingFTP, Inventory control system; Cycle Count; Programming Naming conventions.

RPG Consultant

Confidential, Jacksonville, FL

Responsibilities:

  • Modify the In-House Systems around Mapics XA; Sales Order replenishment for all US sales representative; Kanban Implementation; Recall system for restricted countries; Contract System with price and discounts
  • Prepare validation documentation; Radio Frequency system (Intermec), using TCP/IP (5250) Protocol.

RPG Consultan

Confidential, Puerto Rico

Responsibilities:

  • Perform the necessary changes and new developments on their Distribution system BPCS and their In-house systems using Progen Plus; this includes the documentation as flowcharts.

RPG Consultant

Confidential

Responsibilities:

  • Support their ERP system perform changes and create new developments; prepare documentation for the final implementation to Production.
  • Meet with client; gather the requirements; design a prototype; develop and implement an In-house system to improve their evaluation process and functions of 4 areas of the government agency which is compose of Water, Air, Land and Scientific Assessment. 

Systems Analyst

Confidential, Jacksonville, FL

Responsibilities:

  • Research and identify needs for new technology. Improve the disaster recovery plans. Assist in the development of cost/benefit analysis and project schedules supporting inter-and intra-departmental needs. Setup the application and computer security profile for the user community. Supervise the programming staff.
  • Train and develop my subordinates in programming methods in accordance with the company procedures. Improve QA Recall System.
  • Configure the EDI module. Design new interface for the GL reporting system replacing “Hyperion” with Oracle. Implement the “Service Level Agreement” system, which is a tool to analyze Sales Service.
  • Prepare a flowchart of the overall Process from customer requirement to shipping, for the JDE One world project. Implement JD Edward security Group Profile.
  • Implement JDE Advance Pricing feature. Implement IBM PTF upgrades for the Y2K century change.

Hire Now