Quality Assurance Analyst
Dublin, Ireland
Final project was a .net migration for IPSI's new client Swiss Life International. I tested the ETL process, on a pilot basis 1st, then on all policies, products, clients, agents, etc. I confirmed allowed source data was suitably cleaned up for the extraction, the required data changes added for the new platform and finally it was correctly loaded for a daily batch to work. Also tested the obfuscation process for all personal identifiable data, for Luxembourg regs. In addition, I also helped with the testing of build functionality including Change Requests from the client re Surrenders, Fund Level Fees, Client Maintenance, NB processing, Control Record Configuration, General Ledger Postings, Agent Commission & Fees, Withholding Tax Calculations for the different EU jurisdictions depending on investor tax residency.I worked on a project to introduce an investment protection rider for IPSI’s main client, AXA MPS. We SIT tested code changes to enable clients to select an investment strategy add-on for investment products. This involved making input files to load investment performance and product scenarios, outputs for AXA’s other stakeholders, with their inputs loaded back into the Mainframe system to updates and create warnings or investment changes. Scripts were in Excel and written based on my analysis of the business and functional requirements. I was involved with estimation of testing as well as conducting face to face meetings with the stake holders including the Italian client co. We used JIRA for defect tracking and script management. 1st IPSI project was testing the migration of an existing client (Darta) from mainframe onto a SQL server db with a .Net front end. I had to use IBM utility functionality to interrogate the mainframe data which was replaced using SQL Server 2008 R2 on the new db.