Patrick Scott Email & Phone Number

Netherlands

Johannesburg Area, South Africa

Senior OBIEE Developer

Gauteng, South Africa

Responsibilities• Analysing Business Requirements• Developing development specifications• Documenting all Business Processes• Managing IT projects wrt Time, Cost and Resources• Managing development process through the full Software Development Lifecycle• Liaise with customer wrt to project progress as well as support upon completion of projectsDual Responsibility as Senior JD Edwards Developer as well as Lead Consultant Primavera Analytics and Reporting:Primavera / Oracle Business Intelligence EEBusiness Intelligence, Analytics and Reporting – Analysing business requirements and development of the required reports and analytics based on data originating from several of the Primavera Suite of applications as well as including data from data sources not catered for by standard Primavera Analytics. Modification of the OBIEE Repository and Configuration of Primavera P6 ETL to meet customer requirements.Development of the required SQL scripts to enable reporting and maintenance of Primavera.Trainer Oracle University – Presented various courses for Oracle University (2015-present)JD EdwardsAnalysis and Design –Business analysis, interpretation and specification of client requirements. Creation of Functional and Technical specifications for bespoke developments including a variety of system bolt-ons integrated into the JD Edwards framework.Integration Systems – Analysis, design, specification and development of JD Edwards integration into 3rd Party products including Advanced Planning and Scheduling products, functioning across local and wide area networks.JD Edwards Development – Started as a junior developer and progressed to senior developer on various teams. Application, reporting and financial reports developed across all JD Edwards modules.XML Publisher – Developed customised business documents including Invoices, Statements, and Letters of Demand etc using Embedded XMLP in JD Edwards.

Gauteng, South Africa

Implementation of Oracle’s Advanced Planning SystemSpecific focus on the Production Scheduling (Discrete) module of the APS Solution.Training of Production personnel in the use of the software.Set up of the system to fit business processesEstablishing and implementing Key Performance Indicators to facilitate and measure effectiveness of the APS Implementation.Business Process Redesign.Demand and Production Planning and Scheduling

Middelburg Area, South Africa

Development and Implementation of Supply Chain StrategyDevelopment of executive level key performance indicators to address the four main divisions’ influence on finance, customer service, inventory and efficiency. Develop and implement a system to prioritise customersSelection of Companies to participate in pilot supply chain programs as well as execution of programs.Project with the suppliers in the Ford Supply Chain to increase visibility, improve understanding and improve forecasting accuracy throughout the chain.Development and implementation of an automatic Scheduling system.Project used the Aspentech’s Broner Production Scheduling Module to automate plant scheduling. Project terminated before completion due to change in company ownership requiring a change in production philosophy.Execution of ad hoc Supply chain projectsImprove material flow through installation of electronic tracking and tracing equipment. Capex being evaluated presently, awaiting approval.Discipline to be addressed through Small Group Activities with plant personnel.Investigation into the forecasting process for raw material purchasing to identify risks and propose improvements.

Graduate Diploma In Engineering (Industrial), Engineering/Industrial Management

Bsc Eng (Metallurgical), Metallurgical Engineering

Matric