Steve Hosking Email & Phone Number

Gold Coast, Qld, Au

Sydney, New South Wales, Australia

Brisbane, Australia

- Integral part of the Well Operational Status & Supply Loss Tracking project team designing and building a customised solution to quantify and track gas deferments for Origin's Integrated Gas wells, to assist the business with identifying opportunities to maximize well asset value and reduce operational costs.- Worked closely with key business SME's (Production Engineers, Production Planners, Panel Operators etc.) to define and categorise suitable deferment codes for well shutdowns/turndowns/workovers, artificial lift issues and/or well underperformance for other reasons.- Analysis & definition of automation opportunities for well operational status and supply loss tracking code assignment based on well and artificial lift operational status codes and raw PI/SCADA & PSS alarm data from wells.- Analysis of opportunities to align manual data capture with existing business processes.- Logical data model development- Mapping of data between new and existing systems for backward compatibility- Functional requirements gathering- Solution designMajor Achievements:- Worked closely with the business SMEs analysing all types of well gas deferments and defined all suitable deferment codes and definitions achieving cross-asset agreement between the three Integrated Gas assets at Origin.- Defined a model of deferment codes with their relationship to Well Operational Status, and suitable reporting layer categorisations.- Defined supply loss allocation logic to handle multiple codes at once.- Defined auto coding logic from PI & PSS alarm data.- Defined the Logical Data Model and the Data Standard.- Defined appropriate data mapping between existing and proposed systems.- Aligned categorisations to the most suitable well gas targets.- Aligned any manual data capture opportunities with existing business processes.

Sydney, Australia

- Proactively monitor system performance, especially in relation to nightly batch processing of crucial meter read data (IoT collection, processing & distribution).- Detailed analysis of system processing throughput and performance, to identify degradation or improvement opportunities.- Build data interfaces and ad-hoc SQL based reports as requested by the business.- Automation of repetitive tasks.- User support for application issues as required.- Support application upgrades, server patching activities.- Liaise with the third-party application vendor (Itron).- Agile Scrum environment.- PL/SQL Development.Major Achievements:- Significant performance improvements to the system to facilitate processing of a 500% increase in meter data, which allowed overall batch processing performance to stay well within crucial customer SLAs.- Established application server health monitoring application/scripts/reporting.- Established proactive application and database maintenance routines to maintain optimum performance and throughput for nightly batch processing.- Developed data interface between metering system and business system for device events.- Developed REST API interface between metering system (Oracle) and DWH (BIP) for end-of-batch triggers. Technologies: - Oracle 12, PL/SQL, PowerShell, Python, SQL Developer, PL/SQL Developer, Itron Enterprise Edition (IEE Metering application), Actian PSQL, IIS, Windows Servers, XICOMM Service Mode.

Sydney, Australia

- Led a small team of systems analysts, BI EDW professionals, and integration developers in a programme of work to improve data quality & synchronization between student management and enrolment applications.- Proactively monitor integration between applications, used by over 2000 schools state-wide.- Deep and extensive analysis of data quality & synchronization issues to identify underlying root causes.- Recommend and facilitate changes for internal and external applications to improve data integration, quality and synchronization.- Ongoing enhancement of data quality & synchronization monitoring reports.- Develop ad-hoc tools to assist with analyzing data issues and generating data patches.- Automation of repetitive tasks where possible.- Chair technical data quality & synchronization working group meetings.- Participate in business-level data quality working group meetings, providing appropriate technical input and updates.- Participate in business-level working group meetings for an enterprise-wide MRD project. - Liaise with the third-party application provider.- Change Management tasks including attending CAB.- Mentoring less experienced colleagues.Major Achievements:- Established proactive monitoring routines and associated documentation to identify data quality & synchronization issues.- Refined and enhanced data quality monitoring reports to improve results: to highlight data synchronization issues and remove false positives.- Identified many root causes for integration issues affecting data quality and facilitated appropriate changes with integration and application teams to fix.

Sydney, Australia

- Development of enhancements and bug fixes for Origin’s electricity trading, position and risk management systems.- Operational application support (BAU) to investigate and resolve day-to-day issues as they arise; following ITIL incident, problem and change management procedures.- Participate in after-hours support rota for the entire portfolio of electricity and gas trading systems that operate 24/7.- Out of hours upgrades/implementations.- Liaise with outsourced infrastructure provider.- Agile/Kanban environment with daily stand-ups and weekly retrospectives.Achievements:- Significant performance enhancement of crucial end-of-day process that transfers data between trading systems.- Solved issue with futures strip split pricing errors to conform with ASX rules.- New report to assist finance with end-of-month processing of accruals and actuals to interface to Oracle Financials.- Database table partitioning for meter data to improve performance and maintainability.- Analysis and resolution of reliability and performance issues with transfer pricing processes, which deal with extremely large data sets.- Migration of web application from on premise server to the cloud, using AWS (EC2) and CI/CD with TeamCity.- Development of an interface to automate the update of FPP prices.- Development of external interface to the ASX for downloading daily files using SFTP, AWS Lambda, Golang & Team City.- Solution design for snapshot processes to monitor daily trading data interface and valuation processing.- Development of new technical skillsTechnologies: - C#, .NET, Golang, Oracle 11, PL/SQL (packages, procedures, functions, triggers, DB links etc), SQL Server, DBA skills, AWS (EC2, RDS, Lambda, Cloudwatch), Cloud, TeamCity, CI/CD, Git / Bitbucket, scripting, Allegro ETRM, JavaScript, TFS, TOAD, SQL Developer, Node.js, Redux/React, JIRA, Confluence, Agile/Kanban, Service Oriented Architecture (SOA), Microservices.

London, England, United Kingdom

- Perform analysis, design & full life-cycle development for enhancements, bug fixes, and project based work.- Provide 3rd level application support, root cause analysis and issue resolution, whilst using enterprise ITIL processes and tools. Investigate and resolve overnight batch process failures.- Perform data modeling and database design.- Develop and maintain application data interfaces with numerous internal and external systems.- Conduct technical peer reviews of colleague’s work.- Mentor new and/or less experienced team members.- Liaise with business users to define application functionality and design. Business areas covered: Commodities Trading (Crude and Oil Products), Freight Trading, Operations and Logistics, Shipping, Contracts, Deal Confirmations, Demurrage, Foreign Exchange, and Finance.- Liaise with offshore teams around the world to resolve infrastructure related issues.- Communicate application issues, changes and releases to senior level management, stakeholders, and user base.- Coordinate the end-to-end UAT process, which involves writing test plans, facilitating access to testing systems, and engaging relevant business users.- Technologies: Oracle, PL/SQL (packages, procedures, functions, triggers, DB links etc), DBA skills, Powerbuilder 12.5, Linux Shell scripting, Java / JEE / IBM Websphere, Tibco, EMS/JMS, Visual Source Safe, HP Service Manager 9, SQL Navigator, COBOL, TSO, ISPW, DB2, XML, Web Services, Citrix, SAP Interfaces.

London, England, United Kingdom

- Perform the analysis, design and full lifecycle development of the Shell Trading global network of enterprise trading and shipping applications. - Provide 2nd level BAU support, root cause analysis and issue resolution for existing applications. Development of bug fixes as required.- Work closely with business users to define application functionality and design.- Develop interfaces with numerous internal and external applications, including SAP, Intercontinental Exchange, Lloyd's of London, Navarik, MS Exchange and other Shell systems.- Implement a Message Processing System for sending faxes (via MS-Exchange) and the processing and storage of vital confirmation receipts against the relevant oil deal. - Technologies: Oracle Enterprise Server 10 (including PL-SQL, Oracle packages and procedures), PowerBuilder 8.0 & 6.5, PowerBuilder Foundation Classes (PFC), Java, JEE, WebSphere Application Developer, Tibco, EMS/JMS, UNIX Shell scripting, COBOL, DB2 Stored Procedures, TSO, ISPW, Sybase Transact SQL, SQL Navigator, Rational Clear Case, Rational Clear Quest, MS Visual Source Safe, Sybase Object Cycle, Visual Basic, Web Services, Citrix, Sybase Adaptive Server 11.9.2 (including Transact-SQL and stored procedures), Microsoft Exchange Integration using Collaboration Data Objects (CDO 1.2.1).

London, United Kingdom

- Perform user interface design and development to allow modifications of predicted ratings. Implement changes to database tables and stored procedures as required.- Write help documentation for newly developed windows.- Make modifications to existing data window reports.- Technologies: PowerBuilder 6.5.1, PowerBuilder Foundation Classes (PFC), Sybase Adaptive Server 11.9.2 (including Transact-SQL and stored procedures).

Sydney, Australia

- Perform the analysis, design and full lifecycle development of a new project to process applications lodged by registered training organisations.- Work closely with business users to define application functionality and design. - Conduct demonstrations of prototypes to business users and management.- Perform application development in PowerBuilder and PL-SQL stored procedures and packages.- Make changes to database tables, triggers and indexes as required. Write data migration scripts and document changes.- Perform the analysis, design and development of a web site to lodge applications online and view previous application history.- Technologies: PowerBuilder 6.5.1, PowerBuilder Foundation Classes (PFC) Oracle Enterprise Server 7.3 (including PL-SQL, Oracle packages and procedures), Forte 4GL, Dreamweaver 3, HTML, JavaScript, Visual Source Safe, Object Cycle, Tool for Oracle Application Developers (TOAD).

Sydney, Australia

Client: Victims Compensation Tribunal- Team leadership and project management of technical resources for three enhancement projects, valued between $50K and $100K each.- Work closely with business users to define application functionality and design. - Manage all stages of the software development lifecycle from analysis, design and development to delivery, training and maintenance of the Compensation and Restitution Workflow Automation System (CARES).- Technologies: PowerBuilder 6.5.1 & 7.0.1, Sybase Adaptive Server 11.5.1 & 11.9.2, Transact SQL Stored Procedures, Sun Solaris 6.0, shell scripting, Windows NT 4, Windows 95, Word Basic, Visual Basic for Applications.Client: Tower Life Insurance- Migrate the functionality of three C applications running on Solaris workstations to PowerBuilder, including the integration of an Oracle database, an Open Image database (Sybase ASE) and an application.- Technologies: PowerBuilder 5.0.4 & 7.0.1, Sybase Adaptive Server 10, Oracle Enterprise Server 8 (including PL-SQL, Oracle packages and procedures), Open Image 2.2.2.2, SQL ProgrammerClient: Coca-Cola South Pacific- Perform enhancements, maintenance and support of the enterprise wide Purchase Order system.- Technologies: PowerBuilder 5.0 & 6.5.1, Oracle Enterprise Server 7.3.

Master, Applied Finance, (Distinction Average)

- Investments - Corporate Finance - Financial Instruments - Financial Risk Management - Legal Risk in Finance - Applied Portfolio.

Bachelor, Information Technology, (Credit Average)

- Introduction to Computing Studies - Logic, Probability & Statistics - Mathematics 1 - Discrete Mathematics A - Computer Organisation 1.