Senior Consultant
CAP Technology
Total years of experience :14 years, 1 Months
PRINCE2 Certified Practitioner
Project management and consultancy across multiple projects, including:
Cloud computing and advisory
ICT Procurement
Business Intelligence
Data Analytics
Systems Integration
Information Management
Enterprise Architecture
IT Strategy
Process Improvement
ERP System Training
Responsible for the design, development and management of the upstream revenue model to simulate the gas supply chain, generate invoices and corresponding accounting journal entries for input into SAP.
This role involved:
· Real-time data analytics to provide empirical basis for intelligent business decisions
· Interpretation of complex gas sales, purchase and transportation agreements
· Extensive Excel VBA development to simulate the gas supply chain (volumes and cashflows)
· Automatic generation of accounting entries and interfacing with SAP
· Maintaining compliance with FCA controls
· Management of the process of decommissioning the model and transitioning to a long-term solution
Delivered projects for clients across several industries, including:
· Mining
· Oil and Gas
· Energy
· Public Sector
Experience in these industries covers the following areas:
· Systems analysis, design and improvement
· Business process analysis and improvement
· IT strategy
· Change Management
· Solution architecture (particularly for Oil & Gas)
· Project and Program reporting systems
· Solution option costing and Market scans
· Web application development (HTML5, cloud storage, UX)
· Management Operating System (particularly for Mining)
· Modelling in Microsoft Excel (advanced VBA experience)
· Performance management systems and processes
· SharePoint customisation
Project Management experience:
· Agile and PRINCE2
· Mentoring and onboarding of graduates
· Data analysis - advanced Access and Excel analytics to resolve discrepancies in financial data
· ERP system deployment and streamlining - designing RASCI matrices, writing new workplace policies and procedures, streamlining support route and audit trail of new ERP system.
· IT audit - ensuring all IT systems and controls were in accordance with standard industry practice and relevant regulations
Member of a team tasked with implementing a data import feature in an existing railway control database system.
Working with VBA in Microsoft Access, I successfully developed an add-on feature for the database system to simplify configuration, testing and deployment of railway signalling and control systems. The tool made extensive use of SQL, database table manipulation and management, and fail-safe functions with error-checking to ensure data formatting and structures were maintained during the import process.
Completed two months ahead of schedule and subsequently deployed on a major railway line in Hong Kong.
Content focuses on development of skills necessary to practice in the accounting profession. Have completed the necessary prerequisites for associate membership of the key Australian accounting professional bodies, Certified Practicing Accountants (CPA) Australia and the Institute of Chartered Accountants in Australia (ICAA).
This major provides a solid background in understanding how software is controlled on one or many computers, including security, networking and operating systems. A highly technical major, requiring strong conceptual and programming skills. Courses focus on programming, computer architecture, computer networks, networks programming, operating systems, distributed computing, systems security, as well as distributed software applications involving Internet applications and ubiquitous computing applications. Programming language experience: C, C++, Java, PHP, HTML5, CSS, VB, .NET, SQL Other experience: database design, systems design, information management, data analytics