MAPICS and AS/400 development

SUMMARY: Self-motivated, detail oriented information technology professional, with solid knowledge in ERP MAPICS XA. I have more than 10 years of experience working with manufacturing companies in modules such as: IFM (GL, AP, AR), COM, CAS, PUR, EC, PDM, Inventory (IM), and MRP among others. I have experience in monthly and yearly closing. Expertise in Query/400. I have developed programs around MAPICS, with RPG programming language.

Works extremely well under pressure and has great time management skills.

PROFESSIONAL EXPERIENCE

Consulate General of Colombia in Houston, TX May 2005- June 2016

Administrative Assistant

Prepare and present financial and operational reports to the Colombian government

Create and execute the budget of the consulate

Responsible for the customer service department

I helped Colombian people with document and immigration problems and visited them in jail in order to provide passports and other documents to be able to return to Colombia.

Responsible for the daily and monthly backups

Vendor management and service contract

I was responsible for performing and reporting the physical inventory of the consulate

Coordination and purchase of office equipment

Documentation improvements made to the processes of the company

Maintenance of LAN Network and upgrade of antivirus and new software

Run daily reports, monthly closing and distribute reports to end-users

Coordinate, manage and contribute to the daily operation and processes

Problem solving and troubleshooting

Monthly and yearly bank reconciliation

Yanbal de Colombia Bogotá, Colombia 2003- 2004

System Programmer – ERP MAPICS

Permanent end-user support

Responsible of the maintenance and update new versions of MAPICS.

Support and troubleshooting of different MAPICS modules such as IFM (AR, AP, GL), IM, PUR, MRP, MMA, COM.

Creating program specifications and requirements to develop the program solution in RPG, RPGIII, RPG400, and some ILE

Coordinate the annual physical inventory counts of the company, through the inventory module MAPICS and perform inventory cycle counts to ensure accuracy

Developing software using RPG and Database of MAPICS, and all the AS400 development tools

Manage the security of the system and MAPICS (CAS), including designing of roles and permissions of the users. Updated permissions and passwords

Apply PTF’s of New versions of MAPICS

Prepare financial, accounting, customer and sales reports for management

Expertise in Query/400

Monitor daily reports and duties to report anomalies according to the schedule

Newell Sanford S.A Bogota, Colombia 1992-2003

System Programmer 1996-2003

Responsible for the full-cycle testing of the new modules

Upgrading new versions of the ERP

Coordinate the annual physical inventory counts of the company, through the inventory module MAPICS and perform inventory cycle counts to ensure accuracy, and resolve discrepancies

In charge of the end-user training for the new modules, and upgrades of the ERP; this included creating of training material, and managing of courses

In charge of customer service environment

Computer Operator 1992-1996

Operate AS400

Backup and restore data, as needed or scheduled

Responsible for the daily, monthly, and yearly backups

Run daily reports and background jobs to distribute to end users

Operate and maintain a large variety of PC’s

Organize and maintain tape library, including off-site storage

Troubleshoot with AS400 support

Apply and install PTF’s and upgrade to the system AS400

Printer troubleshooting

Received support calls from other operators, application support and developers

Realized Queries and reports to present to area managers and company management

EDUCATION

University Jorge Tadeo Lozano, Bogota, Colombia

Bachelor of Business Administration Management of Information Systems May 1997

SKILLS

RPG IV, ILE, ERP MAPICS, Operation AS400, Microsoft Office, Windows

Contact this candidate