Peter Samuel Giles
Katoomba,NSW
Summary
With a proven track record at Macquarie Bank, I excel in ETL design and development, notably with DataStage and Pentaho Kettle, and am adept in stakeholder management. My expertise has driven significant enhancements in data warehousing and business intelligence, optimizing solutions that meet and exceed business objectives.
Overview
45
45
years of professional experience
1
1
Certification
Work History
Solutions Architect – Business Banking
Macquarie Bank
Sydney
01.2020 - Current
- Draft solutions to support Customer Data Right provisions for sharing of customer and account information with external financial organisations
- This utilised data eventing to provide real-time delivery of key data to our omnichannel data hub for external sharing
Technical Project Manager – Macquarie Card Services
Macquarie Bank
Sydney
12.2007 - Current
- In this role I was responsible for the delivery of a small data warehouse project for the Risk and Analytics business team
- This project used the WhereScape ETL tool to extract data from external system feeds, transformed the data into tables in a staging database and loaded into a reporting database in SQL Server 2005
- This data was then accessed by the business team using SAS Analytics
- This role covered a number of critical aspects: Managing a team of data warehouse developers, Reviewing the system design, Liaising with the business team for user acceptance testing, Managing the implementation via the bank’s internal infrastructure team
Solutions Architect – Business Banking
Macquarie Bank
Sydney
01.2014 - 12.2016
- Continue to provide solution designs in the area of Originations and Digital Banking to support the growth of the Business Banking division
Solutions Architect – Business Banking
Macquarie Bank
Sydney
12.2009 - 12.2014
- In this role I was responsible for the design of solutions on the Pivot platform for the Business Banking division of BFS
- Provide conceptual and solution design in the delivery of Information and Data Warehouses Systems to support business intelligence and compliance reporting projects such as Financial Claims Scheme, FATCA and BASEL III
- Experience in information lifecycle esp in: Dimensional Design, Data Modelling, ETL (Datastage), Business Intelligence Reporting (SAP Business Objects)
Project Manager – Merchant Services
Macquarie Bank
Sydney
05.2008 - 11.2009
- In this role I was responsible for the management of a team of ten internal IT professionals including: test team, infrastructure, release management
- This role covered a number of critical aspects: Application evaluation and selection, Network design, Application architecture, Integration between Call Centre, Dispatch and Payment systems, Vendor relationship management
- Management Reporting – Taxi Dispatch and Payments
- Once the core dispatch system was implemented within the business, one of my key roles was to establish an information reporting framework
- There were three main sources of information: Dispatch data (Oracle 9i), Payments data (Excel), Call Centre data (Excel)
IT Systems Manager
Lime Taxis
Sydney
07.2005 - 12.2007
- In this role I was responsible for a systems design and direction of the start-up business of Lime taxis for Macquarie Bank
- This role covered a number of critical aspects: Application evaluation and selection, Network design, Application architecture, Integration between Call Centre, Dispatch and Payment systems, Vendor relationship management
- Management Reporting – Taxi Dispatch and Payments
- Once the core dispatch system was implemented within the business, one of my key roles was to establish an information reporting framework
- There were three main sources of information: Dispatch data (Oracle 9i), Payments data (Excel), Call Centre data (Excel)
- Due to the budgetary constraints of the business, the architecture for the solution was based on open source applications such as: Pentaho Kettle for ETL, MySQL for data repository
- Business Objects XIr2 was chosen and implemented as the reporting environment to support the functionality required for the business to supply: Regular management reports for operational statistics, Ad-hoc query/reporting capability for operational requirements
Data Warehouse Architect
Macquarie Bank
Sydney
07.2000 - 07.2005
- In this role I was responsible for a design and direction of the data warehouse environment for the Banking Division at Macquarie Bank
- This evolved over a period of years with the following stages: Concept, Pilot – Industry Data, Release 1 – Management Reporting – Fees Reporting, Release 2 - Management Reporting – Loans and Deposits
- I produced a white paper identifying potential solutions for the current reporting issues such as lack of access to critical business data, lack of control and poor use of IT resources
- The recommendation was to proceed to pilot a focused subject area in a data mart solution
- With the success of the pilot, we recommended to establish a full data warehouse solution incorporating a corporate data warehouse with subject data marts for end-user reporting
- I was the design leader in the following decisions: ETL process/selecting an ETL tool, Selecting a BI tool after an extensive evaluation, Overall design for data warehouse and data mart/s
- The initial warehouse and data marts, along with specified reports were delivered on time and within budget for the first release
Project Manager
Macquarie Bank
Sydney
11.1999 - 07.2000
- In this role I was responsible for a number of projects including: Intranet/Documentation and Online Banking applications
- In particular: Intranet/Content Management
- Many divisions within the bank had set up intranets using the Bank’s existing Notes/Domino infrastructure
- For our group, it was clear that the bulk of the valuable information that was used to support the core business systems walked out the door each night
- In order to address this situation, we embarked on a plan to firstly design an information management system and then assign key staff members to document the key system areas and lastly conduct seminars to communicate this to the rest of the team
- My main contributions to this project were: Selecting and designing an environment that could be used effectively by different users, whether it is a remote connection, LAN connection or local to the support laptop
- Incorporating critical business data such as monitoring batch streams and transaction feeds to key clients
- Integrating new functionality to the existing infrastructure to enable better control and presentation of documents
- I.e
- Version control and automated conversion of source documents
Operations Manager
Macquarie Bank
Sydney
09.1998 - 11.1999
- During this period, I acted as Operations Support Manager for the critical business systems used by the Banking Solutions Division, which included mainframe and client/server platforms
- In May 1999, the existing mainframe retail banking system was replaced with the Pivot client-server application utilising PowerBuilder/Sybase
- I was responsible for establishing and leading the team, which supported this application across 200 business users
- In addition we also managed a complex batch job stream, which included numerous interfaces to both internal and external organisations
Team Leader – Development
Macquarie Bank
Sydney
05.1997 - 09.1998
- I acted as Team Leader for teams up to 3 people developing and supporting applications using a PowerBuilder/Sybase/UNIX environment in the Banking Solutions area of the bank
- My main contributions to this project were: Liaise with business representatives to capture and document business requirements, Design applications for the Direct Electronic Funds Transfer (DEFT) product, Manage all stages of development to ensure applications were delivered on time and budget, Communicate effectively with both IT and business on issues related to support of their systems
Analyst/Programmer (contract basis)
Government Superannuation Office
Queensland, Australia
01.1997 - 04.1997
- I was employed to re-develop their existing claims processing system from a DOS based application to a client/server MS Windows application using a SQL database
- This involved analysing user requirements, building conceptual and physical data models with S-Designor, and developing the application in PowerBuilder 5.0 using their existing Class Libraries and Framework
- My main contributions to this project were: Analyse, design and develop new modules for Claims Processing, Provide recommendations to the Office in revising their existing Class Libraries to make better use of service based architecture, Provide support and training for IT staff in effective ways of using the toolsets
Senior Analyst/Programmer (contract basis)
DST International (UK)
UK
07.1996 - 12.1996
- Company Overview: International hardware and software vendor
- I was brought in as technical consultant/programmer for the Back Office team in this software house
- This team was one of a number involved in the development of the GPS2000 system
- This represents their Global Portfolio System - an Asset Management System that was developed using a three-tier architecture
- The front end being developed using PowerBuilder, the Business Rules engine developed in C typically running on a UNIX server and an SQL database running on any number of platforms
- This product has been sold to clients with various environments including IBM AS400, DEC Alpha, SUN Microsystems
- Supported databases included Sybase System 10, ORACLE 7, Informix, and SQL Anywhere
- My main contributions to this project were: Design and develop new modules for Fee Processing and Unit Pricing, Identify areas of common functionality that could be moved to the Class Library, Liaise with the Technical Architecture team in resolving issues with the Class Library, Identify the issues in migrating existing applications to PowerBuilder 5 and implementing the process using the PowerBuilder Foundation Class structure, Support and advise existing users in effective ways of using the product
- International hardware and software vendor
Senior Analyst/Programmer (contract basis)
Thomas Cook Group Ltd (UK)
UK
01.1995 - 06.1996
- I was a key member of the team responsible for the design and development of the Foreign Exchange application in the retail Point of Sale system
- Initially based on PowerBuilder 3.0 and Sybase, this application was migrated to PowerBuilder 4.0 and Watcom for NT Version 4 in the latter half of 1995
- The objective of this project was to integrate all of the systems used in their retail outlets into a single POS, allowing information to be shared across all services
- It is anticipated that this will increase cross-selling opportunities, and provide a better service for Thomas Cook customers
- Before migration to PowerBuilder 4, all modules went through a redesign process to identify opportunities for performance improvement and ease-of use enhancement
- In the Foreign Exchange module I identified a number of areas, which lead to a 300% improvement in performance without major decrease in functionality
- Being a mission-critical application, the foreign exchange module focused on the following areas: client and server resiliency, multi-user transaction management, and optimum performance
Information Systems Consultant
Wang Australia Pty Ltd.
, Australia
01.1985 - 12.1994
- Company Overview: International hardware and software vendor
- I completed PACE database development course and VS System Performance course
- I was transferred to Wang Brisbane and seconded to Marketing Department for Australian Launch of Wang Image Integrated Systems (WIIS)
- I completed Image Product Training - Wang Lowell, Mass and was seconded to Wang Lowell for Quality Assurance testing on Wang OCR product
- I was presented with the Annual MVP award for outstanding contribution for 89/90
- I designed/developed/implemented Integrated Office imaging system for the Electoral and Administrative Review Commission
- I completed the Phase1 Business Process Management (BPM) course, UNIX Shell programming course, and UNIX system Administration course
- I completed the Phase 2,3 Business Process Management course
- As part of my role as pre-sales consultant, I was required to develop prototypes to reflect the requirements of clients
- This development extended across a number of environments including Visual Basic, SQLWindows, and Staffware
- International hardware and software vendor
Department Programmer
Australian National University
, Australia
01.1981 - 12.1985
- Company Overview: Economics Research
- Provided advice to department staff members about the facilities available in the University environment that was suitable to meet their specific need
- Liaised with the Computing Section staff regarding problems, suggestions, and maintenance issues arising from the use of the department's hardware
- Developed solutions for staff members using a variety of computer languages: BASIC, FORTRAN, and SIMULA
- Trained staff and students in the use of word processing and statistical packages
- Economics Research
Education
Bachelor of Applied Science - Mathematics and its Applications
University of Southern Queensland
01.1979
Senior Certificate -
Toowoomba State High School
Toowoomba01.1976
Skills
- ETL design and development
- DataStage
- Pentaho Kettle
- Report design and development
- Brio
- Business Objects
- Database – SQL
- Sybase
- MS SQL Server
- MySQL
- Development
- Java
- Unix Shell
- Data Warehouse Architecture/Development
- BI Tools
- Client/Server Development
- PowerBuilder
- SQL scripts
- Stored procedures
- Gupta SQLWindows
- Document Indexing system
- Cloud architecture design
- Data modeling
- Technical architecture
- Solution optimization
- Leading meetings
- Improving processes
- Selecting products
- Stakeholder management
Skillsprofile
4, 3, 4, 1, 3, 1, 5, 4, 4, 10, 4, 2, 4, 1, 3, 2, 3, 3
References
Available on request.
Education
1976, Senior Certificate, Toowoomba State High School, 1979, Bachelor of Applied Science (Mathematics and its Applications), University of Southern Queensland, 1985, PACE database development course, VS System Performance course, 1988, Wang Imaging Product Training - Wang Lowell, Mass, 1992, Business Process Management (BPM) Phase 1, UNIX Shell programming course, UNIX system Administration course, 1993, Business Process Management (BPM) Phase 2,3, Gupta SQLWindows Development, PowerBuilder Introduction, 1994, Advanced PowerBuilder Development, 1997, Powebuilder 5 Transition, 2000, Core Java Development, 2001, Informix Data Warehouse Design, DataStage Essentials, 2002, Business Objects Enterprise Reporting, 2015, TOGAF 9 Certified
Personal Information
- Available: One month’s notice
- Date of Birth: 01/01/60
Affiliations
- I volunteer for local Blue Mountains organisations like National Trust
- I enjoy regular sport like tennis and am an active member in my local club
Certification
- TOGAF 9 (2015)
Timeline
Solutions Architect – Business Banking
Macquarie Bank
01.2020 - Current
Solutions Architect – Business Banking
Macquarie Bank
01.2014 - 12.2016
Solutions Architect – Business Banking
Macquarie Bank
12.2009 - 12.2014
Project Manager – Merchant Services
Macquarie Bank
05.2008 - 11.2009
Technical Project Manager – Macquarie Card Services
Macquarie Bank
12.2007 - Current
IT Systems Manager
Lime Taxis
07.2005 - 12.2007
Data Warehouse Architect
Macquarie Bank
07.2000 - 07.2005
Project Manager
Macquarie Bank
11.1999 - 07.2000
Operations Manager
Macquarie Bank
09.1998 - 11.1999
Team Leader – Development
Macquarie Bank
05.1997 - 09.1998
Analyst/Programmer (contract basis)
Government Superannuation Office
01.1997 - 04.1997
Senior Analyst/Programmer (contract basis)
DST International (UK)
07.1996 - 12.1996
Senior Analyst/Programmer (contract basis)
Thomas Cook Group Ltd (UK)
01.1995 - 06.1996
Information Systems Consultant
Wang Australia Pty Ltd.
01.1985 - 12.1994
Department Programmer
Australian National University
01.1981 - 12.1985
Bachelor of Applied Science - Mathematics and its Applications
University of Southern Queensland
Senior Certificate -
Toowoomba State High School
Similar Profiles
Jack HeustonJack Heuston
Senior Operations Associate at Macquarie BankSenior Operations Associate at Macquarie Bank
Devendra LakhotiaDevendra Lakhotia
Senior Technical Business Analyst at Macquarie BankSenior Technical Business Analyst at Macquarie Bank
TIANYI WANGTIANYI WANG
Executive at Macquarie BankExecutive at Macquarie Bank
Jong Ho (Max) YoonJong Ho (Max) Yoon
Broker Support, Analyst at Macquarie BankBroker Support, Analyst at Macquarie Bank
Jack LucasJack Lucas
Receptionist at Palais RoyalReceptionist at Palais Royal