Raed Figueroa Email & Phone Number

Madrid, Community Of Madrid, Spain

Floriana, Malta

Project Name: Business-Combined Insurance Product Line (Core System Configuration) ⚫ Configured the Issuance and Reinsurance modules of the Core System for the development of the new insurance product called Business-Combined. This new insurance product is composed of 17 Product Lines amalgamated into one insurance policy ⚫ Developed several Oracle program packages, procedures, and functions for the customization of the Core System with accordance to the business user requirements ⚫ Setup different variable information applying the business logics to be used for Underwriting, Claims, Reinsurance, Coinsurance and Treasury/Accounting Processes ⚫ Conducted several meetings/interviews with the Business Users for data gathering and clarifications in the product configuration; Worked closely with Product Development Unit Analyzed the business requirements and identified these scenarios in the existing Core System Functionalities ⚫ Created Functional Documents for documenting the Business-Combined Issuance and Reinsurance configurations ⚫ Performed system walkthrough to MAPFRE EURASIA Regional Heads, Core System Experts based in Madrid, Spain, and to MAPFRE Malta Business Managers/Users ⚫ Generated several test scripts for the system and regression testing together with the business users, using an excel template and HP Quality Centre Tool ⚫ Prepared SQL scripts for the deployment/releases of the Business-Combined Issuance configurations to the other Core System Environments such as Integration, PreProduction and Production; Used Plastic SCM tool for the release management of the programs ⚫ Documented Change Request Document for bug fixing of several existing core system programs and uploaded it to HPSM tool, assigning to different Development Teams (outsource) ⚫ Consulted some specific business use cases to the Core System Team experts for the alignment of the new requirements to the standard core system functionalities

Makati, National Capital Region, Philippines

⚫ Assisted scrum teams as needed, whether through direct project work or through incident support and resolution.⚫ For Service Desk escalations, full details have been gathered and included for clarity and ease of resolution from the scrum teams with a focus on reducing additional follow-ups after the initial escalation.⚫ For direct project work, regularly attended in scrum meetings and assigned tasks to be completed in the expected time frames. ⚫ Abled to resolve all issues from beginning to end, following up regularly on unresolved incidents, and keeping stakeholders informed and involved. ⚫ Escalated the issues outside the current knowledge to other CSO team members or appropriate scrum teams for additional guidance. ⚫ Resolved incidents in a timely manner with ongoing communication with CSO managers for outstanding issues and with the entire CSO team for widespread issues. ⚫ Effectively supported all releases for which assigned as release/deployment assistant manager. ⚫ Coordinated the teams and provided sufficient communication to CSO managers and other stakeholders at all times.⚫ Provided backup support, feedback/suggest improvements as necessary, to the release process after releases were deployed.⚫ Effectively assisted deployed applications for which were assigned as the deployment assistant manager.

Muntinlupa City, National Capital Region, Philippines

Project Name: BDO Insurance Policy Batch Uploading⚫ Involved in several meetings both held at BDOI and MAPFRE-Insular offices with Business Heads and Users ⚫ Designed the BDOI Uploading Program Flow of Processes Created the technical specifications for the three subprograms under this project: Uploading, Return File Generation and Monthly Report ⚫ Analyzed the eight delimited files generated from BDOI System and mapped the Policy Issuance fields between Tronweb Core System and the eight BDOI delimited files ⚫ Developed PL/SQL packages for the ETL Processes: Extract the information from eight BDOI Files, transform/convert some fields that the core system understands, and load the policy data in Tronweb batch process table before running the policy batch program ⚫ Created several test cases for User Acceptance Test ⚫ Assisted the business users and created the BDOI Uploading Manual for user reference Deployed and maintained the program in the Production EnvironmentProject Name: MAPFRE Insular Insurance Corporation Official Receipt⚫ Designed the Official Receipt (OR) using Jasper Report ⚫ Analyzed the Tronweb Core System tables for the extraction of Receipt Information needed in the receipt report ⚫ Developed PL/SQL packages, procedures, and functions for data manipulation/ handling (XML Generation) ⚫ Created and designed new tables based from the business user’s requirements ⚫ Created test cases on different scenarios of the Official Receipt Printing and Reprinting ⚫ Deployed and maintained the program in the Production EnvironmentProject Name: Migration of Agents and Sub-agents⚫ Analyzed and mapped the Agent and Sub-agent fields between the Legacy System and Tronweb Core System ⚫ Developed PL/SQL script for data processing and created several oracle functions for the transformation and conversion of some Agent and Sub-agents fields ⚫ Gathered new business requirements from the users for the enhancement of Agent/Sub-agent Module ⚫ Deployed in Prod

Pasig, National Capital Region, Philippines

Double Master'S Degree, Master In Big Data & Business Intelligence + Master In Digital Business

European Qualification Framework Level 7

Executive Mba, Business Administration And Management, General

European Qualification Framework Level 7

Award In Project Management, Project Management

European Qualification Framework Level 6

Bachelor Of Science - Bs, Computer Engineering

Bachelor Of Science - Bs, Computer Engineering