Wayne Thomson Email & Phone Number

Melbourne, Victoria, Australia

Manage AWS components such as EC2 instances, S3 buckets and all AWS related services. Modify and write source, base & extract pipelines using DBT Modelling, modifying python, .yml scripts ,using GILAB to store the code repository, CI/CD, Kubernetes, Docker Control, using VS code to deploy scripts into Gitlab. Developed automation scripts to automate the deployment of cloud infrastructure using cloud Formation Templates to transfer data across the SDLC (DEV/UAT & PROD). Running Airflow Orchestration jobs for batch processing. Administering the Redshift database using MS Beaver for running PL/SQL queries to do quality checks on source and target data that has been transformed and loaded in the Redshift database.

Worked on a Oracle Cloud Project for 3 years with PWC, written & Designed the Oracle reporting Strategy for the department which is being used till today. Written & maintain all reports relating to Oracle Transactional Business Intelligence (OTBI), BIP (Business Publisher reporting), Tableau Reporting, Ms Power Bi, OACS (Oracle Analytical Cloud) and OBIEE (Oracle business Intelligence Enterprise Edition). Unix Shell scripting, Toad 11g and 9.0, Ms Beaver.

Responsible to build DET’s reporting capability using Oracle OBIEE and OACS together with ODI as the ETL tool to bring in various set of data from the source systems into the warehouse. Worked with the Project Manager to engage a team to identify and collate business requirements, build and manger the data warehouse. Provided all the administration for business Intelligence, including setting p of users, managing security and liaising with the business to develop a Procurement reporting dashboard. After which, I supported and trained staff to use the Dashboards and reports provided..

Strong reporting skills in OBIEE with various versions, including Modelling of the .RPD file and using ETL Tools such as Dac & Informatica as Oracle Data Integrator (ODI) was not in use at that time. Design & develop various data sets using the .RPD file with WebLogic server & console. Very strong reporting skills in creating discoverer EUL and materialized views, including nightly batch feeds from the source systems into the target system or data warehouse. Additionally, developed custom Discoverer reports were needed requiring creating custom database views, functions, and routines with Oracle Apps sub-ledger structure. Converted the entire Web Reports into Discoverer 11g ReportsOracle Reports 6iI played a key role in Administration, modifying reports done in Oracle 6i, written reports to print the four government departments Fortnightly Payroll, which was previously done in a printing press.

Melbourne, Victoria, Australia

Experience in Complete Software Development Life Cycle (SDLC), RDBMS (Oracle Cloud, Oracle 12.3.2, 11g/10g/9i), SQL and PL/SQL. Design and development of complex packages, stored procedures, functions etc., using PL/SQL, can also write Unix scripting, Knowledge of Toad 11g and 9.0, SQL Developer on various versions. Design, development, delivery and maintenance of technological solutions to meet business needs. Specifically, by: - • Providing ownership/accountability for the investigation of user requirements/problems and for developing technology solutions in accordance• Owning and delivering design specifications, including detailed design specifications• Developing, maintaining, testing programs according to detailed technical, functional and non-functional specifications• Contributing to the development of systems documentation and providing system support by providing fail and fix application support.