The STA was responsible with supporting test planning, method and development of test cases, execution and evaluation of results for interfaces associated with major applications within Asset Servicing, namely Hiportfolio Eagle Pace, Performance & Reporting Analytics, PControl and other minor applications.Asset Servicing has a combination of in-house and vendor applications. The Test Analyst will be required to participate in System, Integration, End to End and facilitation of User Acceptance Testing.

This involved performing the following reconciliations and resolving reconciliation breaks in a timely manner:Cash and Security reconciliationPortfolio Valuation reconciliationUnlisted Securities market valuation exception reconciliationCash Trust review and sign off - review and approve daily yield calculation Improvements included introducing new procedures to check that daily applications and redemptions had been updated correctly in Hiportfolio and that the portfolio market values for the cash trust had been reconciled at the end of each business day between Simcorp and Hiportfolio.VFMC Insurance Trust - reconciliation of monthly valuation between VFMC and PriceWaterhouse. Measures introduced to improve the process include an Excel macro to sort and match the market values of policy and policy numbers between PWC and VFMC reports.

My original role was to assist with installing the Simpcorp Dimension investment system. After successfully implemented the Equities, Fixed Interest, Cash, Futures, Options, Call Money, Fund Certificates, FX Forward and Asset Liabilites modules, my role became that of a reconciliation analyst. This involved:Daily reconciliation of securities and cash holdings between VFMC and the custodian to ensure that investment holdings were reconciled between the two companies. This was to ensure that daily trades from the custodian had been updated into the Simcorp investment system correctly. Performing holdings reconciliation via the VFMC in-house Oracle database reconciliation tool.

Performed system and user acceptance testing for NCS application systems for HiPortfolio, PACE Datawarehouse and the Web-On Line Reporting Systems, which have been enhanced to meet MLC Investment Limited’s requirements.This role included:Planning and designing test cases for Accounting and Performance ReportsLook Through ReportingEffective Exposure reportsExecution of test plansDocumenting test results in the Quality Centre SystemDefect reportingProviding assistance/guidance to the project team (testing and development teams) in terms of NCS business procedures and application systems, e.g. HiPortfolio, PACE Datawarehouse and industry knowledgeTesting On Demand ReportingPerformance ReportsLook Through ReportingHiPortfolio to PACE interface testing Effective Exposure Market Values reporting Stress Testing Reports - Revaluation of portfolios based on a number of ‘what-if’ scenarios

To identify and provide business requirements to IT to build technology solutions that satisfy business needs in Hiportfolio and Pace Data Warehouse. I was part of the NCS project team which was set up to transition the master custody business of MLC Investments to NCS from State Street. My major responsibilities were:Performed gap analysis of the client’s reporting requirements in the operational, tax and accounting areas to determine if NCS core reporting application systems were able to meet the client’s requirements. If there were any major reporting gaps, NCS was to develop system solutions to overcome the gaps by writing detail business requirements and design specification for the enhancement of NCS systems. Assist testers with the preparation of test cases for system testing to ensure the delivery of business requirementsAssessed existing processes to identify enhancement opportunities to deliver improved efficiency for the business.

The main responsibilities of the position were: Business analysisIdentify, document, analyse, interpret and translate current business requirements for the Equities, Fixed Interest and Bank Bills securitiesData analysis and mapping from the existing application to PortiaDocumentation of the existing business processes and workflow from the front office deal execution to the back office settlementDesign functional and interface specification for the following areas:Deal import into PortiaSettlementsEx-interest processing for Australian Fixed Interest SecuritiesFixed Interest Analytics on International BondsGeneral ledger interface for transactionsAAS25 realised and unrealised profits and lossesCapital gains and superannuation taxCash interfaces.Portia with the front office system

Financial & Investment ManagementPreparation of Operating and Cash Flow BudgetAccounting and Financial ReportingTax management - PAYE, Prescribe Payment tax, Superannuation taxAdministration and accounting of direct property developmentMember of the Investment and Executive Committee

Successfully installed the HiPortfolio V6.2 Compliance, Effective Exposure and Performance Analysis Modules which involved the following phases:Planning the scope of the projectBusiness and test strategyDefined test casesIdentifying conversion issuesConduct testingThe compliance system ws used to monitored the Fund Managers' performance against the investment mandate in the following areas:Authorised and unauthorised investmentsRestrictions against country and currency exposureGearing and hedgingCompany and sector exposureIssuer exposure - fixed interest, equities, Discounted SecuritiesAsset allocation rangesCredit rating, duration, maturity, Derivative holdings & restrictions