Mark Lofthouse Email & Phone Number

Melbourne, Vic, Au

Australia

Liquidity Ftp Project

Engineering lead responsible for technical development and BAU support.

o Analysis and documentation of UBank data.o Validation of migration data mappings and reconciliations.o Validation of testcases and steps.o Preparation of test data set for system testing. o System testing of ETL and reconcilations.

o Manage legacy system data discovery including development of strategy and documentation templates for discovery and source-to-target data mappings as well as developing an initial list of legacy systems for data discovery.o Perform source-to-target data mappings for Lending and Customer related tables in Oracle target.o Design and implement processes for transferring mainframe-based IMS, DB2 and flat file legacy data into a relational Oracle-based environment.

• Data analysis and solution design for interfacing of all retail and wholesale Banking products and cashflows into Kamakura Risk Manager (KRM) for: o Interest Rate Risk in Banking Book (IRRBB) Project o IRRBB/Liquidity integration Project• Also including testing, implementation and post-implementation support responsibilities.

• Design and development of MM & FI (fixed asset & project) data manipulation and load processes• Amendment of FI master data load processes. • Provided technical support to business and functional teams during testing phases, go-live and post-implementation.

• Design and development of processes to extract, transform and load all FI/CO master and transactional data.• Define source to target mappings for financial master data.• Design and development of miscellaneous data reports and update tools.• Provided technical support to business and functional teams during testing phases, go-live and post-implementation.

• Data analysis and design for interfacing of all retail and wholesale Banking products and cashflows into Kamakura Risk Manager (KRM).

• Product Specialist for interfaces associated with retail and wholesale Banking products.• Solution design of all FDB interface requirements including master data, lifecycle events, cashflows and their impacts on FDB primary objects and field level data mapping rules.• Specified detailed data requirements, structures and mapping rules for SAP data integration via ETL middleware layer. • Evaluation of SAP data interfacing techniques (ALE/IDOC, LSMW, batch file, direct BAPI call from ABAP).• SAP FDB configuration team leader.• Unit, module, integration testing and defect resolution

• FDB Team Lead during Bank Analyzer product evaluation, participating in the appraisal and recommendation process regarding the selection of SAP Bank Analyzer for the NAB Group.

• Provided SAP technical expertise regarding all techniques used for interfacing (EDT-External Data Transfer and Idocs).• Performed investigation and resolution of defects found during testing phases.• Solution design for interfacing products and lifecycle events to be interfaced into SEM. • Solution design for banker profitability including Mid-Month banker and economic cost/benefit calculations.• Performed verification of average balance and Funds Transfer Price rate calculation on retail banking products (eg. Variable Loans, Fixed loans, Term Deposits).• Solution design for Tivoli batch schedule for daily, weekly and month processing.• Unit, scenario and integration testing.

• Performed detailed technical design of interfaces between source systems and SEM datapool.• Performed review of all business development requests.• Planned work effort and timelines for development team.• Performed technical review of developed ABAP code.• Performed people management tasks for team members.

• Wrote interfacing strategy evaluating benefits of Idocs, BAPI, ABAP program interfacing methods in terms of volume, batch or online use and synchronous and asynchronous processing requirements.• Documented the design of the interface control and registration system.• Soution design and development of interfaces of project master data and planning data between TeamPlay and SAP using custom-built ABAPs, ALE/Idoc and LSMW processes.• Unit, scenario and integration testing for Financial modules.

• Performed initial project scoping and planning.• Detailed system design specification.• Plan and execute build tasks.• Master test plan and detailed test plan documents. • Execution of documented testcases.• Team leader and people manager for production support team.

• Implemented a new system to cater for the Banks Leasing & Lease Purchase products• Analysis of existing systems, establish business requirements, investigate and and produce a design specification.• Build, unit test and document all of the batch processing functionality.• Developed utilities to automatically document system from the code.• Develop and test migration of Contracts from the old systems to new system.• Plan and perform parallel testing of new and existing systems.

• Design, build, test & implement SDDS to automate the daily distribution of files (including reports, software) to the Banks network of High Function Workstations, LAN’s and 4700 Controllers. • TELON/COBOL /DB2 development.

• Performed production support for Leasing, Lease Purchase, Debtor Finance, Credit Cards Processing.• Implement small/medium size projects for Roadside Assist, Luxury Lease, core System Migration, Disaster Recovery.• CICS/COBOL/DL-I development.

• Performed development role in Overseas Customer Payments project.• IMS DL-I development.• Production support for International Banking Systems (Overseas Customer Payments, Inward Customer Payments, Letters of Credit, SWIFT, TINBICS). • IMS/DLI, IMS/DB2, CICS/DLI and CICS/VSAM development.

• Computer operations role in MVS, Application Support, CICS, IMS and Communications. • Specialised in ‘Front End’ systems which included the Bank's TANDEM POS and ATM networks and interchanges with other Banks as well as BITS and CONNEX.