Service Sales

LEO PUBLICO

**** ****** ****** ** ***-** Mobile : 682-***-****

Arlington, Texas 76012

Email: ******@*****.***

HIGHLIGHTS OF QUALIFICATIONS

Information Technology Developer with over 20 years of ERP experience, strong hands-on functional system design and technical programming background in custom development, interfaces and maintenance of packages such as LSAMS, PRMS, WMS, BPCS, JBA, JDE World using SDLC, Agile-Scrum.

Advance skills in IBM AS400 / iSeries / System i (RPGIII, RPGIV ILE, RPGLE Free Format, CLP, SQL, FTP, DB2).

Proficient in web development (e-commerce) using PHP, MySql, Javascript, JQuery, Json, Ajax, CSS, HTML, Wordpress. Proficient on rendering single dynamic page.

Cloud computing knowledge in setting up and deployment of virtual server, web server (Apache and Nginx) and PHP application on Amazon EC2 and Google Apps Engine.

System administration of AS/400 System i such as user account management, security, configuration, OS installation, applying PTF’s and development of disaster recovery. Basic administration of Windows 2003/2008 servers.

TECHNICAL EXPERTISE

Hardware : AS/400 System I, Windows 2008 Server

OS : System i OS/400, Linux Ubuntu, Windows 8/7, Windows 2008 Server

Software : LSAMS, PRMS, WMS, BPCS, JDE World, JBA, Client Access, EDI, ERP, FTP, Lotus

Notes, Microsoft office, Outlook, Transform (Formscape), Trackwise

Languages: RPG ILE, RPG IV, RPG III, COBOL/400, CL, SQL Stored procedure, Java,

PHP, JavaScript, JQuery, Ajax, HTML, HTML5, XML, Excel Visual basic

Database : DB2, MySql

Utilities : SQL/400, PDM IDE, Rdi, RSE, Operation Navigator, Eclipse, Client Access/ODBC,

Data Queue, Journal, IFS, Adobe Dreamweaver, Photoshop, Eclipse, Zend Studio,

Zend server, PhpMyAdmin, PhpStorm, Surveyor, Implementer, Turnover, Hawkeye

WORK EXPERIENCE

Vantage Force Feb. 2016 - Nov. 2016

Senior Developer

Client: NationStar Mortgage (Coppell,Texas)

Technologies and Programming Tools: LSAM Mortgage Application, system i 7.2/AS/400 utilities, RPGIV/Free format ILE, Embedded SQL, PHP, Service programs and binding directories, Stored Procedures, Web Services, Rdi, Implementer, Surveyor.

Currently working on re-writing centralized Disbursement

Worked on retrofitting the customized changes to LSAMS base.

Assist QA to determine the root causes of program defects and provide resolution.

.

UST Global 2015 - 2016

Senior Developer

Client: Bank of America (Addison,Texas)

Technologies and Programming Tools: Mortgage Application, system i 7.1/AS/400 utilities, RPGIV/Free format ILE, Embedded SQL, Service programs and binding directories, Stored Procedures, Web Services, Turnover, SDLC: Agile-Scrum.

Lead/Developer – Managed projects and leading team members to develop security logs (audit log) for Mortgage Applications of employee’s activities when accessing customer personal information.

Designed, developed, unit tested all code modifications and prepared project documentation.

Coordinated with customers to identify and analyze business requirements.

TECSYS Inc, Canada 2014 - 2015 WMS Iseries Developer, R& D

Technologies and Programming Tools: WMS, system i 7.1/AS/400 utilities, RPGIV/ ILE/ Free Format, Embedded SQL, Service programs and binding directories, Stored Procedures, file DDL definitions, Web Services, and XML, Java, Target Process, SDLC: Agile-Scrum.

Enhancements of warehouse management system (WMS) for version 6.2.

Developed WMS interface to Mobile delivery management (MDM Android).

Developed formatted email notification to customers using embedded html in RPGLE.

Ciba Vision Sterile Mfg, Canada 2005 - 2014

Programmer Analyst

Technologies and Programming Tools: PRMS (ERP), all system i/AS/400 utilities, RPGIV/ ILE/ Free Format, Embedded SQL, Service programs and binding directories, Stored Procedures, file DDL definitions, FTP, Transform, Adobe X JavaScript, Excel Vba, Tibco data transfer, BOSS Warehouse.

Lead PRMS team of up to 8 members through the quarterly releases for enhancements, fixes, modification and validation of PRMS programs as well as coordinating business requirements. Ensured targeted deadlines were met and that systems were running efficiently.

Developed and implemented interfaces and data transmission to company’s affiliate worldwide for financial reporting, inventory planning and shipping information. Key initiatives:

Language: RPGLE, CLP, SQL (embedded and external), Excel Visual basic

Outbound advance shipment notice (ASN) via Tibco data transfer to Novartis SAP.

Inventory and sales order to Central Planning via custom FTP.

Financial reporting to Corporate via Excel Vba interface from PRMS database.Developed Excel Vba queries to extract information from PRMS which enables easy analysis and reporting.

Acted as Technical Lead in migrating to System i and PRMS version 10. Installed and configured System i operating system, TCP/IP network and PRMS software.

Developed disaster recovery procedure for System i and PRMS, wrote SOP’s as part of Gxp compliance.

Installed and configured Transform (Formscape) on Windows 2008 server to be used for printing forms from PRMS reports.

Implemented automated purchase requisition by sending PRMS requisition report to transform to create pdf and route it via email attachment to the requestor for review and approval by department head.

Developed the batch record creation in Adobe PDF using JavaScript and populated lot information from PRMS to ensure accuracy and efficiency.

Maintained PRMS and performed System i administration functions such as user account set up, back up, applying PTFs and software fixes from PRMS vendor.

Analyzed business requirements and wrote technical specifications.

Kraft Canada Inc. 2004

Programmer Analyst Consultant

Programming Tools and Technologies: All Iseries (AS/400 programming) utilities, RPG III/IV/ ILE/ Free Format, Embedded SQL, Service programs and binding directories, Prism COM, Aldon and ClearQuest change management, Visio.

Developed interfaces between Prism COM (order management system) and KARS (PeopleSoft A/R system) such as receivables, customer and credit management, payment from TRACER, G/L to McCormick dodge. Revised COM programs to remove JD Edwards Financials dependency.

Mother Parkers Tea and Coffee, Canada 2003

BPCS Programmer Analyst Consultant

Programming Tools and Technologies: All AS/400 programming utilities, iSeries, BPCS V8.1, ASSET, RPG III/IV/ ILE/ Free Format, Embedded SQL, Service programs, Client Access, Turnover, Microsoft Outlook, Office 2000.

Converted and modified sales, inventory, MRP, procurement and manufacturing programs into RPG IV, RPG ILE on AS/400 iSeries platform.

Cogeco Cable System, Canada 2002

Programmer Analyst

Programming Tools and Technologies: All AS/400 programming utilities, iSeries, Client Access, Shaware billing system, Abstract, Microsoft Outlook, Office 2000.

Analyzed and designed translation, wrote technical specification of Shaware billing system from French to English using ILE RPG on AS/400 iSeries platform.

Emplifi (formerly Mastech) in USA 1997-2002

Software Engineer

Client: Tree of Life in St. Augustine, Florida (July 2000 - December 2000, March 2001 - August 2001)

Programming Tools and Technologies: All AS/400 programming utilities, iSeries, Client Access, FTP, JDE One World, Amtrix messaging.

Participated in the development of interfaces (EAI) between JD Edwards One World, E3, PKMS and TM/TR using Amtrix, RPG IV on AS/400 iSeries platform.

Wrote interface specifications and developed interface programs using Amtrix, RPG IV and JDE one world.

Client: XPEDX (formerly Alling and Cory) in Rochester, New York (September 1998 - April 2000)

Programming Tools and Technologies: All AS/400 programming utilities, iSeries, Client Access, FTP, JBA, E3.

Maintained and enhanced JBA system such as Distribution, Sales and Financial accounting using RPG IV ILE on AS/400 platform.

Developed procurement interfaces between JBA and E3 via FTP process to send procurement orders and accounting information to Corporate headquarter.

Client: EDS (Automotive division) in Troy, Michigan (December 1997 - August 1998)

Programming Tools and Technologies: All AS/400 programming utilities, Client Access, Lotus notes.

Enhanced and developed procurement using COBOL and RPG III in AS/400 platform.

EDUCATION & PROFESSIONAL DEVELOPMENT

B.S. Aeronautical Engineering, Philippine School of Aeronautics.

Computer Science, Systems Technology Institute-Philippines.

Java, Humber College – Toronto, Canada (2003-2004).

Contact this candidate