CURRICULUM VITAE Adrian Johnson

PERSONAL DETAILS

NATIONALITY British by birth (UK/EU Passport holder)

Mobile Tel: +44 (0-790******* Email: accakq@r.postjobfree.com

EDUCATION AND QUALIFICATIONS

1995 Computer Science & Mathematics

MASSEY UNIVERSITY, NEW ZEALAND

1993 Bachelor of Business Studies - Accountancy

MASSEY UNIVERSITY, NEW ZEALAND

INFORMATION TECHNOLOGY SKILLS

PeopleSoft Technical Experience (16 years)

. SQR, PeopleCode, Application Engine and Component Interface

. Crystal, XML Publisher and nVision report developer (fully trained to

advanced level)

. Application Designer (building menus, components, pages, records, views,

etc)

. Data Mover, Import File Manager and Integration Broker

. Advanced Query SQL development under Sybase, MS SQL Server and Oracle (to

10i) database platforms

. Development and maintenance of PeopleSoft PIA Web/Portal security under

PS ERP/FDM and EPM applications to version 9.0

ETL Data Warehousing / PeopleSoft Enterprise Performance Management (EPM)

. Informatica/PowerCentre Data Mapping Design and Batch processing

. ETL design of Data Loader Maps into Data Warehouse (DW) tables

. Balanced Scorecard (BSC) and Budgeting reporting reporting (Query and

Crystal)

. Configuration of BSC DW architecture

. Support and maintenance of ABM (Activity Based Management) application

PeopleSoft Project/Support Experience (10+ years in Financials ERP)

. PeopleSoft Financials: General Ledger, Project Costing, Asset Management,

Accounts Payable, Purchasing, Accounts Receivable, Billing, e-Procurement

and Expenses knowledge

. PeopleSoft HR: Self Service Project (ABN AMRO) and some HRMS technical

support (BDO)

. Involved in user acceptance and sign-off testing, building test cases for

new PeopleSoft implementations and upgrades and liaising with technical

teams to resolve any outstanding defects. Work instances include testing

customisations to interfaces from Legacy systems into GL/AP and SQR,

Crystal and nVision reports for batch and ad-hoc report analysis

. Providing training on nVision GL reporting and completing month-end batch

processes such as summary ledgers, year-end close, GL to subsidiary

journals and GL/AP reconciliations

. Gather user requirements for new customisations (e.g. Summary Ledger

reporting) then building design and test specifications. Experience

liaising with external consultants to complete necessary technical

implementation work.

. Liaising with end-user groups to identify Production defects with ERP

functionality (GAP analysis), documenting findings and reporting issues

to PeopleSoft Customer Connection for recommended bug fixes. Investigated

resolution and likely impact of fixes via internal customisations (for

upgrades) where PS fixes only available with future releases.

Other Application Skills

. SQL:TOAD/SQL+ (Oracle),SQL Advantage (Sybase) & Analyser/T-SQL(MS SQL

Server)

. Sound experience with using Microsoft Outlook, Lotus Notes and Visio

. Advanced MS Excel VBA skills with good general knowledge of MS Access

WORK HISTORY

Jul 2012 to April 2013 - ING (Brussels) - PeopleSoft Financials Developer

(AP e-Invoicing/Tax Statements 1-2 Projects)

Nov 2010 to Jan 2012- BDO (Baker Street, London)- PeopleSoft/Enterprise

Developer

Mar 2010 to Oct 2010 - ING (Prague) - PeopleSoft Reporting Consultant

(Technical)

Feb 2008 to Feb 2010 - LexisNexis (Croydon) - Technical Financial Systems

Accountant

Nov 2007 to Dec 2007 - ABN AMRO (Amsterdam/Amstelveen) -CRM/HR Developer

July 2007 - Technical Developer - ING Real Estate (The Hague/Den Haag) -

Technical Developer

Sept 2006 to April 2007 -Credit Suisse (Zurick, Switzerland)- DWH Developer-

Contract/Temp

May to Aug 2006 - Michelin Tyre Public Limited Company (Midlands)- EPM DWH

Developer

Jan 2005 to May2006 - GARTMORE plc (London)- EPM Developer/Analyst

Programmer

Oct 2000 to Aug 2004 - WELLINGTON CITY COUNCIL (Systems Accountant/ Tech

Developer)

Jan 99 to Oct 2000 - TOWER, Wellington New Zealand-- Systems Accountant

Mar 1998 to Dec 1998 - PRUDENTIAL ASSURANCE NZ LIMITED

- Systems Accountant Mar 98 to Dec 1998

- Assistant Systems Accountant Sept 1996 to Feb 1998

May 1995 to Aug 1996 - OTICON NZ LIMITED- Accounts Assistant

ING (Brussels) Jul 2012 - April 2013- PeopleSoft Financials Developer

project role building an inbound local e-Invoicing interface within

PeopleSoft Financials 9.1 AP module to maintain and build vouchers

generated from XML data provided by OB10 approved suppliers. Built AE

program to generate and email batches of pdf reports via XML Publisher.

Lastly, completed Tax Statements 1-2 Project customisations to generate

annual svd and xml extracts covering Internal ING vendors and Belgian and

Foreign external suppliers for annual submission to Belgian Government. Tax

Statements application based on AP and Travel and Expenses data to extract

fische files for Belgian Ministry.

BDO (Baker Street, London) From Nov 2010 to Jan 2012 -

PeopleSoft/Enterprise Developer

supporting BDO's Enterprise Systems Team with:

. 3rd-level ongoing Helpdesk Support of BDO's Financial Systems (incl.

PeopleSoft FMS, HRMS and RBS/RMS [customised in-house version of CRM])

. Involvement in adhoc PeopleSoft related Project Development (iXBRL

interface and Credit Control customisations)

. nVision report training and main report writer to BDO Finance users

ING (Prague) Mar to Oct 2010 - PeopleSoft Reporting Consultant (Solutions

Developer)

. Developing Crystal, Query, SQR and nVision Excel based reports linked to

VBA code

. Assisting with the development of system development life cycle and

integration processes in a version 9.0 PeopleSoft Financials

implementation across Czech and Slovak client sites.

. Documentation of functional requirements, technical design and

development work relating to reporting across all modules (including AP,

Billing/AR and GL)

. Investigating and resolving defects during system and User testing

. Providing support during initial application deployment (September -

October)

LexisNexis (Butterworths - Croydon): Feb 2008 - Feb 2010 - PeopleSoft

Financials Consultant

. Designed, developed and tested BACS AR interface using SQR, Application

Engine and PeopleCode

. nVision development for Bank Reconciliation module and month-end report

reconciliations

. Development and testing of Call Statistics interface reports via Access

. Online adhoc Financials training and Helpdesk support for AM, AR, GL and

Billing modules

ABN AMRO (Amsterdam/Amstelveen): Nov - Dec 2007: Technical Developer

. HRMS/CRM development using PeopleTools, PeopleCode, Component Interfaces,

Application Engines, integration Broker and SQR

. Applied customisations to employer/candidate Self Service modules

ING Real Estate (Den Haag Branch) - Technical Developer July 2007

. Designed and built Application Engine Interface within PeopleSoft

Financials 8.8 (under PeopleTools 8.45.18) to extract and export Ledger

Actuals/Budget/Forecast current and historical data to be uploaded into

Hyperion Essbase Cubes

. Built menu, components, pages, file layouts and records via Application

Designer to configure extraction process by Ledger Group/Sets, et al

. Designed and built Application Engine to generate extract and export file

allowing for periodic purges by instance using PeopleCode and SQL

. Generated components to build and publish new menu to Web Portal

IKEA- 24th - 30 April 2007 (while on contract with Credit Suisse Zurich)

. Assisted developer with designing and building SQR program to extract HR

data from PeopleSoft Benefits application into a flat file for loading

into US Parent systems.

Credit Suisse (Zurich, Switzerland) Sep 2006- Apr 2007- DWH Developer

(Contract)

. PeopleSoft/PL SQL Data Warehouse Developer for HR Reporting CS project.

. Designed and built an ETL tool to run under PeopleTools Application

Engine & Oracle 9i

. Translated ETL code into PL/SQL. via Oracle 9i

. Assisted migration of PS/ETL objects to testing/UAT and Production

environments via Serena Change Management and Kintana software

Michelin Tyre Public Limited Company (Stoke-on-Trent, the Midlands) May -

Aug 2006

EPM (Data Warehouse) Developer, DWH HR Project (Contract)

Company Information: International Tyre manufacturer and provider of travel

assistance services and lifestyle products

Responsibilities: Working on AIX platform with Oracle 8i and EPM 8.3

upgrading Informatica ETLs and PS Data Loader with PeopleTools 8.22 to load

data from HR 8.9. Assisted upgrade of existing reporting functionality

(SQRs and Crystals) from a source HRMS 8.3 to version 8.9. Upgraded

existing HR interfaces in SQR to comply with HR8.9 (PeopleTools 8.47),

documenting changes, troubleshooting and resolving upgrade issues as

required.

GARTMORE plc (Fenchurch Place, London) Jan 2005 - May 2006- Analyst

Programmer

Company Information: International asset management firm offering

specialist, added value investment products.

Key Responsibilities:

. Support of daily ESS (Enterprise Siebel Staging) fund sales data loads

and legacy Financials (ERP) refreshes via Informatica into PeopleSoft

ABM(Activity Based Management) application under Citrix software and

Oracle database platform for allocation and reporting by Actuals/Budget

reporting to cost/revenue pools

. ETL Informatica development within PS Enterprise Data Warehouse of new

monthly ETL batch loads by key projects for EPM Budget and Actuals

reporting (linked to ESS Siebel data feeders)

. 1st line PS FMS Helpdesk Support liasing with technical teams in India/US

as required

WELLINGTON CITY COUNCIL - Oct 2000 - Aug 2004

Systems Accountant /Technical Systems Analyst/Developer - PS Upgrade

Project Team

Client Information - Wellington City Council body providing public services

and collecting revenue (water & rates, parking fines, etc) on behalf of the

Wellington region

. Technical design, development and support of EPM version 8 Data Warehouse

(Balanced Scorecard and Budgeting) via Informatica/PowerCentre v 5 - 6,

creating daily/monthly ETLs for Financial and Budget refreshes

. Technical development and support of PeopleSoft Financials v8.4 re-

implementation under MS-SQL Server (including user customisations, data

migration)

. Assisted EPM application upgrade v8.3 to 8.8 and EPM/FDM Tools upgrade to

v8.44

. 1st line PS FMS (7.5 to 8.4) Support-GL, AP, PO, AR, BI, AM, PC and

eProcurement modules

TOWER, Wellington New Zealand Jan1999 - Oct 2000- Systems Accountant

Company Information: Key provider of financial (superannuation, pensions,

insurance and investment) products in both New Zealand and Australia

Responsibilities: Assisted with PeopleSoft 7.51 functional and technical

implementation and data conversion from Oracle Financials

Provided functional and some technical support for all PeopleSoft

applications (GL, AP, AM)

Day-to-day operational support of PeopleSoft application servers and

process schedulers in conjunction with DBA and Deloitte consultants

Key Projects/Achievements

. nVision Report Writer for Finance Department

. Assisted with data conversion from Oracle Financials database to PS

FDM7.5

. Development and support of external interfaces to PS Financials (GL

module)

. VBA development of Actual and Budget upload journal file and EFT bank

file generator from spreadsheet templates

PRUDENTIAL ASSURANCE NZ LIMITED Sep96 - Dec98- Systems /Assistant Systems

Accountant

Company Information: Financial and Insurance market leader (acquired by

Colonial in 1998)

Responsibilities: 1st-tier Support of PeopleSoft Financials v6 modules GL

and AP, with related mainframe accounting processes liasing with Prudential

Australia

Key Projects/Achievements: Assisted in development of interfaces to

PeopleSoft GL (v.6.01) via account translation tables. VBA development to

reformat AP Vendor list into user-friendly format.

EMPLOYMENT REFEREES

Available on request

Contact this candidate