Plaridel Sotero Jr Prado Email & Phone Number

Esquimalt, Bc, Ca

Paranaque City, Philippines

Website Building & Course Creation Helping business owners, coaches and course creators: * Establish the client's authority in his/her niche * Increase brand and offer awareness * Building a community * Generate Leads * Sell and Provide Next Step in the Customer Journey * Increase Retention and Customer Loyalty Strategy: * Attract (Drive traffic to the website) * Nurture (Personalize messages) * Convert (Make user take action)

Makati, National Capital Region, Philippines

• Assigned in AXA Philippines (Life and General Insurance and Investments) as Senior Engineer that utilizes RPGLE, SQLRPGLE, CLLE, QMQRY, SDA, RLU, DDS. Enhance Service Programs, Binding Directories and RPG Modules.• Apply the Regional Channel Management System (RCMS) Bancassurance Channel enhancement in accordance with the 2023 DAP Bancassurance changes to calculate variable compensation using a new formula depending on whether achieve all Key Performance Indicator (KPI) or not. • Create new Application Programming Interface (API) Update License for common use as inquiry and update information on Effective Date and Expiry Date by Agent Code or in each category and description.• Create user synchronization between Identity Access Managmnt (IAM) and Regional Channel Management System (RCMS) for UMC decommission based on the existing interface files – data selection, transformation details and interface to SFG.• Reverse Engineering Project on General Liability Insurance (GLI) Entries using SQL queries to retrieve transaction amounts for Report generation of the client by Policy and Plan levels.• Participates in application development, system design, debugging, interface points between various systems and code review. Documents code changes, requirements, functional specifications and technical specifications.

Makati City, Philippines

iBoost LimitedFile Reorganization and Historical Customer Accounts Optimization Projects• Assigned as Technical Consultant that utilizes RPGLE, SQLRPGLE, CLLE, QMQRY, SDA, RLU, DDS. Enhance Service Programs, Binding Directories and RPG Modules.• For File Reorganization project to manually tag an account for archive and being disregarded during End of Day run.• For Historical Customer Accounts Optimization project used to bulk check and validate the archive accounts that are still being processed and eventually tagged the accounts for deletion in order to optimize the End of Day run of the bank’s system.• Performs review on requirements, functional and technical design specifications, coding, unit/ system/function/regression test plans and test proper liaising with Expert Consultant to accurately estimate effort for the project deliverables and planning schedules, creates and maintains appropriate documentation in the areas of Development and/or Maintenance with minimal supervision, particularly for Equation Core Banking.• Ensures quality output and adherence to standards in producing complex, efficient, and quality codes but at the same time able to complete tasks as scheduled and within effort estimates.• Provides support for delivered software (includes analyzing, fixing, and reviewing complex problems) and identifies and escalates issues in a timely fashion, constantly aiming to initiatechange for the improvement of the project.

Bgc Taguig City, Philippines

– Hire Purchase System and Credit Card System - Authorization• Assigned as Project Lead utilizing Software Development Life Cycle (SDLC) process, using RPGLE, CLLE, Subsystem, Subfile in the Development, Integration, and User Acceptance Testing for: * Hire Purchase System – a loan system that allows customers to purchase consumer products without any credit card from its partner merchants and store affiliates. * Credit Card System – Authorization – authorizes the transaction that allows customers to purchase goods or services, perform cash withdrawals, or make an online purchase at their convenience.• Assists in application development, system design, debugging, interface points between various systems, and code review. Documents code changes and requirements. Participates in training to provide a source for continuing education.

Makati City, Philippines

• Provided system development and corrective maintenance as per client’s specifications and reported issues using RPGLE, CLLE, SDA, RLU, DDS, Subfile, Journalling, and FTP, particularly on:* SWIFT Message Management – whenever a SWIFT message is required, Equation SWIFT Interface extracts the necessary information from the Equation database and sends it to Message Manager, where it is formatted into a SWIFT message. The type of message to be sent is determined by Equation using the system-level and customer/account level settings the bank has defined.* Clean Payments – a type of remittance instruction, involving the transfer of funds to a beneficiary without conditions and enables you to process a range of domestic and international payments.* Retail Lending – Loans of standard types can be quickly and easily created, while you can also add loans that require greater flexibility or variation from the standard type. Flexible repayment schedules can be generated automatically or manually, listing the date and amount of repayments to be made against the loan.* Bank Fusion Equation and Desktop (Service Composer) – makes it easier for banks to develop services and then orchestrate them into comprehensive applications so you can bring the most innovative products to market quickly, to out-innovate your competition.* Customer Documents – established or altered by the use of parameters. The bank is able to define the format of the document by specifying 'background wording' and 'variable information' and their positions on the document.* Branch Teller – facility to define a branch to be a Teller branch, monitor the processing status of the branches that are running Branch Teller, specify the offline capability of the branches, and ensure that branch databases are kept in synch with the Equation database.• Follows department’s stated Software Development Life Cycle. Leads small scale projects to their completion. Performs QA tasks when necessary.

Libis Quezon City, Philippines

– Digital Telecommunications Co.Oct 2001 – Jun 2003• Coded programs using RPG-ILE, and CLLE in the Dev't and Support team that covers:* Customer Relationship Management – refers to practices, strategies, and technologies that a firm use to manage and analyze customer interactions throughout a customer's lifecycle.* Billing Support System – Data warehouse for all customers' records and their billing history where customer's statement of account is being generated.* Customer Provisioning – a specific address is being provided by the system as a basis if a port is available for installation of the line network.– Honda Cars PhilippinesMay – September 2001• Coded programs using RPGIV-ILE, CLLE for General Purchasing System to transact Purchase Requisition Maintenance and Purchase Requisition Issuance to request the purchase of materials and/or supplies to set off the purchasing process, Purchase Order Approval to validate a PO and pass the approval process, and then Request for Payment to pay the supplier.– Bayan TelecommunicationsMay 2000 – April 2001• Developed new programs using RPG-ILE, CLLE used in Credit Management – the process of granting credit to your customers, setting payment terms and conditions to enable them to pay their bills on time and in full, and recovering payments.– ABN-AMRO Savings BankJanuary 2000 - April 2000• Coded programs using CTD/2, CTR/2 for Bills Payment to cater different kinds of billers in accepting the billing bar code.– IBM Common Transactions for Tellering SystemsJune 1998 - December 1999• Involved in the development using CTD/2 and CTR/2 for Teller Totals, Printing of Passbook, Cheques, Receipts, Withdrawals, Account Opening, Bills Payment, Manager's Check and Cashier's Check transactions.– IBM Banking Development SystemSeptember 1997 - May 1998• Involved in the development of Deposits and Withdrawals, Teller Totals, Printing of Passbook, Cheques, Receipts, Manager's Check and Cashier's Check transactions.