RESUMÉ OF

DENNIS DALUSONG

PROFESSIONAL PROFILE

Was employed in Accenture BGC as an AS/400 RPG 4 Developer. Worked in Rustan’s Supercenters as an RPG Programmer. Was assigned in BMC Software Solutions as an IT Consultant(Part Time). Was assigned in Robinsons Retail Holdings Inc. as an RPG Developer. Worked in IBM Philippines and Client is Advance Auto Parts(AAP). Worked as an IT Consultant(Part Time). Connected in IBM Philippines, client was Abbott Laboratries. Worked at Canon (Philippines). Was assigned at Aeon Credit Technology Systems, Inc. Was also assigned at Waltermart as an RPG Developer. Prior to this, worked at Misys Philippines Inc. under RCG Information Technology as Trainor Assistant. Previous programming assignments at OCBC Bank in Kuala Lumpur, Malaysia and with ITCT and RCG IT. Had comprehensive training on the software Synon 2/E. Responsibilities included system analysis, coding, development, modification and unit testing of programs. It also includes technical documentation for any changes made to a new and existing program. Work on the system ICMS(Integrated Costumer Management System for PLDT(Philippine Long Distance Telephone Company) and Bayantel.

TEN (10) years of RPG/AS400 experience.

TWO (2) years of COBOL/AS400 experience.

TECHNICAL SKILLS

Hardware PC Compatibles, AS/400

Operating Systems Windows 9x/2000/NT 4.0/XP,Windows Vista,Windows 7, OS/400

Database SQL

Languages / Development Tools RPG/400, CL, PDM, SEU, DFU, RLU QUERY/400, RPG ILE, XML, Aldon, COBOL/400, SQL, Silverlake Integrated Banking System(SIBS)

EMPLOYMENT HISTORY

Accenture 01/03/2019-to 12/31/2019

Uptown Tower 2

36th St corner 9th Avenue

Bonifacio Global City

AS/400 RPG 4 Developer

Client is Caterpillar Inc. (CAT)

Familiarization of the flow, systems specification and functional flow of the system

Under Liquid Hub Team

Projects that were done:

-Machine Order Backfill

-CAT Daily

-CAT Parts ASN Interface Enhancement

-New Billing Type Codes will be added in SPM Invoice

-Carolina Test D09 & Q09 - Impacted Objects

-Custom CTR Report - Sprint 2

-Cumulative ASP to J.A. Riggs Test Environment

-Cashman Test Environment

-PartStore Proforma Enhancement

-Parts Team to Review Cashman Equipment

-Production PORT 234 Proforma Part store Enhancement

-Prep Task for DBSi 5.0 October 2019 Cumulative ASP to Mustang Tractor and Equipment

Cobol/400, RPG Free Format, and SQLRPGILE were used in object analysis, development, support, functional & technical description, debugging and retrofitting source codes from TEST Environment to PROD and vice versa.

Environment

AS/400, SQL/400, RPG ILE, RPG Free Form, SQLRPGLE, Aldon

Rustan’s Supercenters, Inc. 03/01/2018-to 11/15/2018

4th floor Morning Star Center

347 Senator Gil Puyat Avenue, Makati City

AS/400 RPG Programmer

Maintenance and Support of JDA Software in Retail and Merchandise .

Investigation/Development/Support of the following modules:

1.Auto delete of physical file members

2.Enhancement of Printer output in Purchase Order & Transfer Files

3.Checking of Status 9 and replace all slot in Loc 6 and pattern with Loc 2

4.SKU’s with problem in Transfer Creation

5.E3 Purging of Files

6.RF Multi Tramsfer Objects

7.CAS Reports(JDA Document_Receiver Report, JDA PO with EY Comment, JDA_RTV_EY Comments)

8.Clean up of E3 Libraries

9.Enable & Disable of User Profiles

10.Fixing of MSGW status error

11.System Error – Pork Primal Skirt/Trimmings – SR Ticket

12.RF Multi Transfer Objects

13.Maintenance of List of new JDA Users

14.Investigation of VAT/NON-VAT PO’s

15.System Error – Not generate Child TRF in picked status SKU by the kilo

16.Clean up of AS400 files

17.Enrollment of WC / SWE Stores with Specfic Meat Costing System

18.Creation of Inventory Batch name

19.TRF inquiry

20.Lost with TRF error

Environment

AS/400, SQL/400, RPG ILE, RPG/400

BMC Software Solutions 04/03/2017-to 2/15/2018 AS400/IT Consultant(Part Time)

Home Based

Technical documentation of Control-M iSeries Agent and Workload Automation.

Support and Maintenance if there are issues and queries regarding to the software (Control-M iSeries).

Environment

AS/400

Robinsons Retail Holdings Inc. 11/02/2016 to 3/15/2017

110 E. Rodriguez Jr. Avenue, Quezon City

AS/400 RPG Developer/Support

Function is Maintenance and Development of JDA Software and are as follows:

1. INV176(RPG) - Input UPC Code - MAINT

- Add SYSTEM NAME(JSYSNM) = 'RLX' and display 'SKU Maintenance'.

- If REFERENCE NUMBER(JREFNO) = 'TESTSTYLE',

add SYSTEM NAME(JSYSNM) = 'RLX' and display 'Style Maintenance'.

2. BYRPGM01(RPGLE) - Buyer Code Maintenance Program - DEV

- Update Buyer Name in file BYRFLE(Buyer Code Maintenance) once found in TBLBYR(TABLE FILE: BUYERS)

3. AUTREP(RPG400) - Auto Replenishment Maintenance - MAINT

- Change S0STAT from 'A' to 'I' if User ID is search and if status is 'I' in Auto Rep.

Maintenance and Auto Rep. Inquiry.

4. CCNSO(RPG400/RPGLE) – Concess Stock Order – DEV

- Creation of Concess Stock Order Menu.

- In progress.

5. Other Adjustment Confirmation – Added routine to check if the store is closed in Store Entry Validation

IBM Philippines (Contractual) 02/24/2016 -to 9/09/16

2nd floor, UP Ayala Technohub, Commonwealth Ave Diliman

Quezon City

Application Developer – AS/400 IBM System i

Client is Advance Auto Parts.

Familiarization of the Supply Chain, consisting of the terminologies used, Host Inventory Management, Callback and OverStock, Corporate Logistics, Inventory Accounting, Replenishment of ASR(Advance Store Replenishment)/AWR(Advance Warehouse Replenishment).

Merchandising and POC Financial is also being supported.

AS/400 CL commands and administration are being done.

On call support is being done during weekends.

Standard Operating Procedures are being processed in Merchandising, POC Financial, and Supply Chain and are as follows:

MERCHANDISING

1.AAP-IBM MerchDev SOP AAMS USer Creation v1.0

2.AAP-IBM MerchDev SOP AMS Login v1.0

3.AAP-IBM MerchDev SOP AMS Password Reset v1.0

4.AAP-IBM MerchDev SOP Maintenance Threshold Limit v1.1

5.AAP-IBM MerchDev SOP MAINTPUSH & MAINTPUSHD v1.1

6.AAP-IBM MerchDev SOP Monitor DUEPOGS Jobs v1.0

7.Add or Remove UPCs from SKUs

8.Add records to files MMMNUUSR

9.job, BNKTAP,File DEPRECOVR in library SAVEFILES already exists

10.job, DBA.SQL.000235.IMPORT_DUEPOGS_FROM_AS400_SSIS_DMW_DB

POC FINANCIAL

1.Customer Transaction History Instructions for Archived Data

2.Customer Transaction History Instructions

SUPPLY CHAIN

1.AAP-IBM SupplyChain SOP - Create and send Warehouse transfer ATS to legacy WMS

2.AAP-IBM SupplyChain SOP Incorrect DC for store in ASR

3.SOP - Create and send Warehouse transfer ATR to legacy WMS

4.SOP - Job errors - E3_PRJCTNS in MSGW - Advance1

5.SOP-DCINVF PDQ on order update

6.SOP-DCINVF WHS on order update

7.SOP-Regenerate ASN by changing To Location

8.SOP-Resend overstock returns to store

9.SOP-Trailer will not close

10.TDFX and USETAX Run process

Environment

AS/400, SQL/400, RPG ILE

BMC Software Solutions 02/02/2015-to 2/15/2016 IT Consultant(Part Time)

Work From Home

Help IT transform into Digital Enterprise.

Creating Manuals for iSeries(Technical Documentation).

Support and Maintenance if there are issues and queries regarding to the software (Control-M Workload Automation(Control-M/Agent for iSeries).

Environment

AS/400

IBM Philippines (Contractual) 09/18/2014 -to 01/15/2015

2nd floor, UP Ayala Technohub, Commonwealth Ave Diliman

Quezon City

Application Developer – AS400 Admin Support

Familiarization of the software and system used.

Client is Abbot Labs. Support BPCS System used.

Creation of User Profiles, Passwords, and Supplemetal Groups

AS400/TurnOver Configuration

Maintenance of Abbott ITSM Ticketing and Access Recertification

Restore files and move objects to DR Production

BPCS Menu Setup, CSR Program Updates

Monthly Report Automation

Deactivation of User Profiles

Robot Job Scheduler

DASD Clean Up(ASP)

On-call support

Environment

AS/400

Canon Marketing(Philippines) (Contractual) 10/21/2013 -to 8/15/2014

7th floor, Commerce & Industry Plaza, Campus Ave. Corner

Park Ave. McKinley Hill, Fort Bonifacio

Taguig City

RPG Developer

Familiarization of the software and system used(RAMBO System).

Maintenance of EDI System(Daily monitoring and updating of the errors encountered within the Users)

Do programming, debugging, testing, enhancements of the System.

Creation of the Email support in End-Month Reports, to hasten the flow and eliminate manual processing.

Environment

RPG 3, RPG ILE, AS/400

Aeon Credit Technology Systems, Inc.(Contractual) 3/16/2012 -to 7/2/2012

703 Philplans Corporate Center

1012 Triangle Drive corner 10th & 11th Ave

Taguig City

Junior Software Consultant

Familiarization of the software and system used in Credit Service System.

Maintained/fix existing modules in the System of Aeon Indonesia.

Modified/Enhanced/Tested Credit Card Indonesia Phase 1(Expansion + Basic Customization)

Developed/programmed the FTP Subsystem.

Maintenance of the Application Process and Card Embossing(Judgement & Closing).

Documented the FTP User Interface Manual System.

In Phase 2, designed the process flow of Limit Change Fee.

Environment

RPG 3, RPG ILE, AS/400

Waltermart 9/05/2011 to 1/31/2012

Global Quest Consulting Group, Inc(Contractual)

6th floor

Munoz, Quezon City

RPG Developer

Extracted JDA files from MMS/JDA(Output CSV files).

Upload to ARC programs and files.

Upgrade AS400 Ver from V5R4 to V6R1

Upgrade to ILE, fixing the length of the files

Modified printer file INV041P1-LIST TRANSACTIONS FROM INVTRN.

Modified display file JGD005FX-Posting to SL by Detail Screen.

Creation of subfile to program JGD005SX-Posting to SL by Detail(5 parm -arcode).

Development of printer file for CAS Requirements - Sales Journal.

Environment

RPG 3, RPG ILE, AS/400

Misys International Banking System

RCG INFORMATION TECHNOLOGY(Contractual) 5/22/2011 TO 08/26/11

Trainor Assistant(TA)

Checking of Exercises of the trainees and assisting/guiding them if there are queries raised by the students.

Includes CL, RPG3, & RPG4 exercises.

OCBC Bank 6/09/08 to 03/08/09

iTAC MSC Outsourcing Sdn. Bhd (Contractual)

9th Floor Menara OCBC

18 Jalan Tun Perak

Kuala Lumpur 50050

Malaysia

Analyst/Programmer

Was assigned in interfacing of Bank Trade System using RPG ILE. System is WebFITAS Menu using .XML and Dimensions. Functions also included creation of Eview files, support in FITAS interfacing, XML files, CCRIS, and using the system Dimensions.

Support in Access Matrix.

Validation of Contract Financing, GL, ABC, Fast Track, MIS, & NPL Interface files.

Support also in Loan, Deposits, GL/CIF Modules.

Knowledge of Silverlake application, especially on Loans, Fitas, Trade Finance, Remittance, & Treasury.

Experience in system design and program analysis.

Investigation and performing root cause analysis and recovery.

Interfacing of files using connect/direct.

In the SIBS application, provide regular feedback and status of issues.

Environment

RPG ILE, AS/400, Silverlake Integrated Banking System(SIBS)

Misys International Banking System

RCG INFORMATION TECHNOLOGY(Contractual) 11/2004 to 05/2008

IT Consultant

System analysis, coding, development, modification and unit testing of programs.

Technical documentation for any changes made to a new and existing program.

Was assigned at the development and maintenance of Bank of America and Luxembourg Bank using RPG ILE.

Uploading and downloading of files using FTP (File Transfer Protocol).

Was assigned also at Misys doing bug fixing.

Developed programs to meet new business requirements.

Debugged existing programs to ensure correct system validation.

Modifies modules to include additional validation programs.

Done Unit testing and documentation.

Provides systems support.

Test the system with the users.

SIBS Core Banking System was used in the maintenance of Loans & Deoposit, Trade Finance, Remittance & Payment, Credit & Debit Card, and Electronic Banking.

Environment

RPG ILE, AS/400, Midas, Equation, Silverlake Integrated Banking System(SIBS)

PLDT Pasig

ARCHON CONSULTING(Contractual) 01/2001 to 11/2004

Programmer/ Consultant

Integrated Customer Management System – Pldt Pasig (ICMS)

Generated and automated daily and weekly report of all posted and unposted CT(Connect/Disconnect Text Plan) and IU(New install wirh CPE) Service Orders requesting for activation of PLDT Hype.

Generated an automated weekly report of all Value Plus Plan Subscription.

Burf Adhoc Report Mothers Day Promo.

ICMS Per Telno – COGNOS.

RBG Cycles – COGNOS.

Rectified the program in generating Final Demand Letter(FDL) and Final Account Letter(FAL).

Automation of misc en/el pre-jumpering with or without linecard deletion.

Developed software modifications

Environment

RPG/400, AS/400, ICMS Software. COGNOS Impromptu 6.0 Administrator. SIBS

Philippine Axa Life Insurance 10/99 to 12/2000

Technical Consultant - AS/400RPG Developer

Conducts QA on project outputs and reviews end-user requirements and design system specifications.

Design, develop, modify and successfully execute system and programs according to specifications.

Create, perform and execute unit tests, ensuring programs meet specifications, identifying problems and making recommendations and necessary program adjustments.

Conducts users’ training for system familiarization prior to system migration to live environment.

Prepares comprehensive program/technical documentation.

Updates management regarding project status

Environment:

RPG/ILE, AS/400

PLDT Makati

RADIX Systems Corporation 03/98 to 06/1999

Programmer

Primary responsibilities include - programming and function testing. Radix, being a software development house specializing in AS/400 and PC/LAN applications, was assigned in different development projects in both fields of expertise.

Responsible for the development of the following module of Personnel Information System (In-house). Handled the employee master file of active and inactive employees who are assigned to different clients; Report Layout Utility (RLU) was used in printing the employee master file. Page subfile was used in displaying the records. Also analyzed and designed the system.

Involved in the development and enhancement of the Integrated Customer Management System (ICMS) – PLDT to the new version that will adapt the needs of the users. Makes specification using standard format of ICMS. Remediation was done in the new version of the ICMS (3.3). The old version (2.3) was understudied and File Transfer Protocol (FTP) was done in downloading the data to AS400 system. Y2K conversion was done in the old version. Parallel testing was done for both systems.

Resynch the ICMS I 5.0 (BAYANTEL) modules into release I 5.1.

Was involved in the documentation of the Capella System using the Help Panel Group (HLPPNLGRP). Review the overall flow of the system.

Developed for the General Payroll System (in-house) handled the file maintenance of the 13th Month/Bonus Pay transactions; Print the 13th Month Register System Documentation. Page sub-file was done in the file maintenance. Report Lay-out Utility was used in the reports. Took charge in the system design.

Design, develop, modify and successfully execute system and programs according to specifications.

Create, perform and execute unit tests, ensuring programs meet specifications, identifying problems and making recommendations and necessary program adjustments.

Conducts users’ training for system familiarization prior to system migration to live environment.

Prepares comprehensive program/technical documentation.

Updates management regarding project status

Environment

AS/400, RPG/400, CL, COBOL/400

Ayala Systems and Technology Inc.

INFORMATION PROFESSIONAL INC. 05/97 to 02/98

Programmer

Responsible for training, programming and testing of different programs. IPI being a consulting firm was assigned in different projects specifically in the field of RPG/400 & AS/400.

Involved in the modification of reports from O-Specs to Report Layout Utility (RLU). Enhancements and testing were also done for Report Generation and File Maintenance (in-house).

Understudied the (JDE) JD Edwards and file maintenance (Ayala Sytems and Technology Inc.) software where report generation was done. Modifications, enhancements and testing of files were done.

Environment:

RPG/400, AS/400

TRUK TRANSPORTATION CO., INC 10/94 to 10/96

Programmer

Development/ Maintenance of Payroll System and Maintenance of the General Ledger, Accounts Receivable and Accounts Payable using Clipper.

Environment:

RPG/400, AS/400

JACKBILT CONCRETE BLOCK, INC. 12/92 to 08/94

Programmer

Development of the Inventory and Research & Development System and Maintenance of the Payroll and General Ledger Systems using Clipper.

GALAXY BURGER(Franchise) 06/01/2009 to 2/15/2012

Part time

Initially monitors the daily flow of running the business by checking the inventory and sales at the end of the day which was eventually delegated to a staff .

Store visits and audit from time to time.

EDUCATION

Bachelor of Science in Computer Science

AMA Computer College

PERSONAL DATA

Residence Address: 123 A. de Leon Street, 9th Avenue, Grace Park, Caloocan City 1403 Philippines

E-mail Address: adjnt1@r.postjobfree.com

Residence Phone: +632-***-**** (Philippines)

Mobile Phone: +639**-***-**** (Philippines)

Contact this candidate