Alvin Ray Joseph Y. Amacio
Software Engineer
Muntinlupa City
Summary
Worked extensively on the development of SOFGEN's Avaloq Visualizer Add-ons, including writing technical specifications and executing test cases. Handled data migration from Oracle i-Flex Flexcube system to the latest release of the Fidelity Information System (FIS) Systematics System at the Philippine National Bank (PNB). Handled Relationship Management (RM) for Philippine National Bank (PNB) and Overseas using Oracle. Expertly managed to migrate Relationship Management (RM) for Allied Bank Corporation (ABC) and Allied Savings Corporation (ASB) using PostgreSQL. Create and Execute Test Cases and Audit trail for the ERSTE Bank Migration Project. Detail-oriented, organized and meticulous employee. Works at fast pace to meet tight deadlines. Enthusiastic team player ready to contribute to company success.
Overview
8
8
years of professional experience
4
4
years of post-secondary education
Work History
Senior Software Engineer
Sofgen Limited Holdings
06.2019 - 03.2020
06.2019 - 03.2020
- Execute test Cases for the ERSTE Bank Migration and created Audit Trail (using vb.net)
- Handle migration process using Batch File (stitching of migrated T24 files).
- Handle quantity reconciliation.
Software Engineer
Sofgen Limited Holdings
06.2012 - 02.2018
08.2017 - 02.2018
- Assigned to help a team, for enhancement of a data migration tool - (SMM - SOFGEN MIGRATION MANAGER).
08.2014 - 08.2017
- Data Migration from .dmp file to FIS, November/2015 - AUGUST/2017 (PNB - Philippine National Bank and Overseas)
- Data Migration from an existing Oracle i-Flex Flexcube system to the latest release of the Fidelity Information System (FIS) Systematics
- Handle RM PNB and Overseas
- Analyse the mapping doc for data mapping, data conversion and mapping clarification.
- Execute test cases, raising issues and keep a track of all the changes in queries.
11.2015 - 05.2017
- Data migration from .dmp file to the latest release of the Fidelity Information System (FIS)
- Assigned to migrated RM ASB from a flat file (.dmp file) source through Postgres Enterprise Manager/pgAdminIII
- Responsible for Import/Export data, create views and tables from flat file data (.dmp file and csv) and connect to WILF (migration tool) for data mapping and migration
- Performing data cleansing through PostgreSQL and data conversion using c# through WILF.
- Checking migrated data (EBCDIC) through Hex Editor to inspect data based on mapping criteria, data position and length
- Create Documentation for RM ASB pre-run and migration process.
11.2015 - 03.2017
- Data migration from .dmp file to the latest release of the Fidelity Information System (FIS)
- Assigned to migrated RM ABC from a flat file (.dmp file) source through Postgres Enterprise Manager/pgAdminIII
- Performing data cleansing through PostgreSQL and data conversion using c# through WILF.
- Responsible for Import/Export data, create views and tables from flat file data (.dmp file and csv) and connect to WILF (migration tool) for data mapping and migration
- Checking migrated data (EBCDIC) through Hex Editor to inspect data based on mapping criteria, data position and length
- Create Documentation for RM ABC pre-run and migration process.
08.2014 - 11.2015
- Data Migration from an existing Oracle i-Flex Flexcube system to the latest release of the Fidelity Information System (FIS) Systematics
- Assigned to migrate IMPACS
- Handled Savings Account and ALS (Advance Lending System)
- Performing data conversion from Flexcube to Flat File (EBCDIC, ASCII, CSV) through C#
- Preparing queries in SQL on joining tables to be migrated and their columns with mapping criteria based on mapping documents provided
06.2014 - 08.2014
- Assigned to customize OMD Sheets on creation of Objects (Person, BP, Container, Position, MACC) for employees and clients
08.2012 - 06.2014
- One of authors of technical specification Phase 1
- Member of ongoing development through Phase 1
- Assigned to JavaScript and CSS side of development
- Provided test cases including some system test cases for Phase 1 and Phase 2
- Executed test cases for cycles 1 to 3 of Phase 1
- Completed final version of technical specifications for Phase 2
Education
Bachelor of Science in Information Technology -
Philippine Christian University
1648 Taft Avenue Cor Pedro Gil St., Manila P. O. B 01.2008 - 03.2012
Skills
Windows /7/10undefined
Place Of Birth
Hall in Tirol, Austria
Personal Information
Date of Birth: 03/19/89
Projects
Data Migration for ERSTE BANK, 06/01/19, 03/01/20, Execute test Cases for the ERSTE Bank Migration and created Audit Trail (using vb.net). Handle migration process using Batch File (stitching of migrated T24 files). Handle quantity reconciliation. Sofgen Migration Manager, 08/01/17, 02/01/18, Assigned to help a team, for enhancement of a data migration tool - (SMM - SOFGEN MIGRATION MANAGER). Data Migration - Philippine National Bank, 08/01/14, 08/01/17, Data Migration from .dmp file to FIS, November/2015 - AUGUST/2017 (PNB - Philippine National Bank and Overseas). Data Migration from an existing Oracle i-Flex Flexcube system to the latest release of the Fidelity Information System (FIS) Systematics. Handle RM PNB and Overseas. Analyse the mapping doc for data mapping, data conversion and mapping clarification. Execute test cases, raising issues and keep a track of all the changes in queries. Data Migration - Allied Savings Bank, 11/01/15, 05/01/17, Data migration from .dmp file to the latest release of the Fidelity Information System (FIS). Assigned to migrated RM ASB from a flat file (.dmp file) source through Postgres Enterprise Manager/pgAdminIII. Responsible for Import/Export data, create views and tables from flat file data (.dmp file and csv) and connect to WILF (migration tool) for data mapping and migration. Performing data cleansing through PostgreSQL and data conversion using c# through WILF. Checking migrated data (EBCDIC) through Hex Editor to inspect data based on mapping criteria, data position and length. Create Documentation for RM ASB pre-run and migration process. Data Migration - Allied Bank Corporation, 11/01/15, 03/01/17, Data migration from .dmp file to the latest release of the Fidelity Information System (FIS). Assigned to migrated RM ABC from a flat file (.dmp file) source through Postgres Enterprise Manager/pgAdminIII. Performing data cleansing through PostgreSQL and data conversion using c# through WILF. Responsible for Import/Export data, create views and tables from flat file data (.dmp file and csv) and connect to WILF (migration tool) for data mapping and migration. Checking migrated data (EBCDIC) through Hex Editor to inspect data based on mapping criteria, data position and length. Create Documentation for RM ABC pre-run and migration process. Data Migration from Oracle i-Flex Flexcube to FIS, 08/01/14, 11/01/15, Data Migration from an existing Oracle i-Flex Flexcube system to the latest release of the Fidelity Information System (FIS) Systematics. Assigned to migrate IMPACS. Handled Savings Account and ALS (Advance Lending System). Performing data conversion from Flexcube to Flat File (EBCDIC, ASCII, CSV) through C#. Preparing queries in SQL on joining tables to be migrated and their columns with mapping criteria based on mapping documents provided. Amanah Raya via Mesiniaga, 06/01/14, 08/01/14, Avaloq Implementation. Assigned to customize OMD Sheets on creation of Objects (Person, BP, Container, Position, MACC) for employees and clients. Tools and Add-Ons - SOFGEN Avaloq Visualizer Add-ons (TAD_SAVA), 08/01/12, 06/01/14, One of the authors of the technical specification Phase 1. Member of the ongoing development through Phase 1. Assigned to the JavaScript and CSS side of the development. Provided test cases including some system test cases for Phase 1 and Phase 2. Executed test cases for cycles 1 to 3 of Phase 1. Completed the final version of the technical specifications for Phase 2.
Disclaimer
I hereby declare that the details furnished above are true and correct to the best of my knowledge.
Timeline
Senior Software Engineer
Sofgen Limited Holdings
06.2019 - 03.2020
06.2019 - 03.2020
08.2017 - 02.2018
11.2015 - 05.2017
11.2015 - 03.2017
08.2014 - 08.2017
08.2014 - 11.2015
06.2014 - 08.2014
08.2012 - 06.2014
Software Engineer
Sofgen Limited Holdings
06.2012 - 02.2018
Bachelor of Science in Information Technology -
Philippine Christian University
01.2008 - 03.2012
Similar Profiles
Jonathan BlandonJonathan Blandon
Lab Analyst at Sofgen PharmaceuticalsLab Analyst at Sofgen Pharmaceuticals
Miangellys MarreroMiangellys Marrero
Manufacturing Technician at Sofgen PharmaceuticalsManufacturing Technician at Sofgen Pharmaceuticals
Lin Yanping (Libby)Lin Yanping (Libby)
Assistant Manager (finance) at Roxy-Pacific Holdings Pte Ltd (formerly known as Roxy-Pacific Holdings Limited)Assistant Manager (finance) at Roxy-Pacific Holdings Pte Ltd (formerly known as Roxy-Pacific Holdings Limited)
Nathan LloydNathan Lloyd
Intern at FOCOL Holdings Limited: Bahamas Utilities LimitedIntern at FOCOL Holdings Limited: Bahamas Utilities Limited
Kyle Matthew GuerreroKyle Matthew Guerrero
Sales Manager at Bisco Industries, IncSales Manager at Bisco Industries, Inc