William Shanahan
Maroochydore,Australia
Summary
Highly experienced and solution-focused Software Consultant with over 20 years of expertise in designing, developing, and implementing robust technical solutions. Proven track record across diverse environments, with deep specialisation in Oracle Database technologies, PL/SQL, Oracle APEX, and data migration. Adept at leading teams, optimising performance, and delivering complex projects, particularly within the Telecommunications and Energy Utilities sectors.
Overview
27
27
years of professional experience
Work History
Migration Analyst (Contract)
Energy Queensland
Brisbane, Australia
01.2025 - 06.2025
- As a Senior Developer on the Development team, I was involved in the end-to-end design and development of the Data Migration solution. The solution was specifically designed to extract, transform, and load (ETL) customer meter data from our legacy TOHT system. This project leveraged advanced Oracle database features and complex PL/SQL scripting to ensure a reliable and efficient data migration process
- Executed the migration of several Terabytes of customer data, utilizing PL/SQL and Shell scripts within a complex Oracle database environment.
- Worked in the full migration lifecycle, from mapping document preparation to the design and build of extraction scripts, staging, and load processes, ensuring data integrity.
Senior Data Engineer / Technical Lead
Suncorp
Brisbane, Australia
11.2022 - 01.2025
- Designed and developed robust data engineering solutions for the Insurance industry.
- Led the Regulatory Reporting Development Team as Technical Lead, overseeing critical data delivery and ensuring compliance.
- Developed high-performance solutions using PL/SQL and Oracle APEX, significantly improving reporting efficiency.
- Provided key technical leadership on multiple financial and data migration projects, including a significant migration to ExaCC, ensuring seamless transitions.
Senior Consultant
DXC
Brisbane, Australia
11.2018 - 11.2022
- Developed custom software solutions for Energy Market clients using PL/SQL, Perl, and Oracle Forms.
- Implemented critical system changes in response to AEMO Market rule updates (related to TOHT), ensuring regulatory compliance.
- Contributed to Web-Services Development using Oracle 12 Native Web Services and Glassfish, enhancing system interoperability.
Team Leader / Senior Oracle Developer
VAS-X
Sunshine Coast, Australia
07.2016 - 11.2018
- Managed and led a team of 12 Oracle Developers, optimizing workload distribution, ensuring timeline adherence, and tracking project deliveries.
- Mentored and coached junior team members, fostering skill development and enhancing overall project efficiency.
- Continued hands-on development, writing complex code in PL/SQL and Oracle APEX.
- Designed and implemented a new Accounts Receivable solution within the billing system, streamlining financial processes.
- Played a pivotal role in the successful migration of 500,000+ customers to VAS-X's new billing system.
- Developed Web Services using Glassfish and SoapUI for external integrations.
Senior Developer/Architect (Contract)
Inmarsat
London, UK
04.2011 - 06.2016
- Contributed across various project lifecycle roles including architect, team leader, designer, and developer.
- Developed critical applications using SQL, PL/SQL, Perl and EPM.
- Delivered complex financial reports for Revenue Recognition, supporting critical business decisions.
- Identified and implemented significant performance improvements (e.g., reducing query times by 30%) by analysing SQL statements and Oracle AWR reports.
Migration Analyst (Contract)
TalkTalk
London, UK
09.2007 - 03.2011
- Served as billing system subject matter expert for the migration of three legacy billing systems into TalkTalk's Singleview Billing System.
- Participated in critical on-site migration events, including extended hours and weekends, ensuring successful and timely transitions.
- Executed extensive data cleansing on source system tables, improving data quality prior to migrations.
- Designed and delivered a suite of financial reports to the TalkTalk business, supporting financial analysis.
Billing Designer/Financial Reports (Contract)
Virgin Mobile
Wiltshire, UK
06.2006 - 07.2007
- Designed and developed new Oracle solutions tailored for Virgin Mobile Business.
- Implemented complex PL/SQL solutions and significant database changes, including new tables, views, indexes, constraints, triggers, partitioning, and SQLLDR.
Senior Developer/Team Leader
Intec/ADC/Saville Systems (now CSGi)
02.1998 - 06.2006
- Progressed from a graduate role to Development Team Leader, managing workload, timelines, and deliveries for a team of up to 8 developers.
- Customized the Singleview Billing product for clients across the Asia/Pacific region from the Brisbane office.
- Travelled extensively across Asia/Pacific to support critical go-live releases, ensuring smooth system deployments.
- Designed and implemented billing applications on a Unix Environment using Perl and PL/SQL with Oracle database.
Education
BSc (Hons) - Mathematical Science/Computing Studies
National University of Ireland
GalwaySkills
- PL/SQL and SQL
- Oracle APEX and Forms
- Perl and Shell scripting
- Singleview billing system
- VBNet and VB Script
- Oracle database management
- Microsoft SQL Server and Access
- Toad and SQL Navigator
- Performance analysis and tuning
- Version control with GIT
- Project management with PRINCE2
- Agile methodologies
- Job scheduling with CONTROL-M
- Oracle Cloud services
- Azure cloud solutions
- TechnologyOne financial software
- SOAP UI testing tools
- SAP integration techniques
- Oracle 12 web services
- Tuxedo application server
- Enterprise performance management
Timeline
Migration Analyst (Contract)
Energy Queensland
01.2025 - 06.2025
Senior Data Engineer / Technical Lead
Suncorp
11.2022 - 01.2025
Senior Consultant
DXC
11.2018 - 11.2022
Team Leader / Senior Oracle Developer
VAS-X
07.2016 - 11.2018
Senior Developer/Architect (Contract)
Inmarsat
04.2011 - 06.2016
Migration Analyst (Contract)
TalkTalk
09.2007 - 03.2011
Billing Designer/Financial Reports (Contract)
Virgin Mobile
06.2006 - 07.2007
Senior Developer/Team Leader
Intec/ADC/Saville Systems (now CSGi)
02.1998 - 06.2006
BSc (Hons) - Mathematical Science/Computing Studies
National University of Ireland
Similar Profiles
Corby WilsonCorby Wilson
Apprentice Linesperson at Energy QueenslandApprentice Linesperson at Energy Queensland
Melissa St JohnMelissa St John
Senior Line Standards Engineer, Overhead Standards at Energy QueenslandSenior Line Standards Engineer, Overhead Standards at Energy Queensland
Catherine TaylorCatherine Taylor
Market Transactions Officer at Energy QueenslandMarket Transactions Officer at Energy Queensland
HARSHKUMAR PatelHARSHKUMAR Patel
Delivery Driver at Australia Post OfficeDelivery Driver at Australia Post Office
WARREN ELLISWARREN ELLIS
Sale Consultant at Lydia Kirn Real EstateSale Consultant at Lydia Kirn Real Estate