Cost Controller and Data Analyst
Sonatrach
مجموع سنوات الخبرة :17 years, 0 أشهر
• Developed an analytical breakdown structure (WBS and CBS) diagram of Upstream Oil & Gas project based on ISO 19008-16 SCCS and best practices and rules stated in PMBOK, for CAPEX, OPEX & Project global costs using Mind Mapping & Brainstorming software (Project SYNCHRUM find me on LinkedIn)
• Developed an entire Cost Control System for Planning, Tracking, analyzing, Forecasting, Visualizing, and Reporting drilling costs using highly advanced MsExcel skills using VBA Macros, SQL Server, and PowerBI including Cost Tracker, Authorization For Expenditure (AFE), NPT Summary, Actual vs AFE, Days vs Depth, Cost vs Depth, Invoice Logger, etc, with automated Call-Off generator based on AFE figures, and automated Monthly & Yearly Drilling accruals (Project SYNCHRUM find me on LinkedIn)
• Supervised the cost control team for best practices and for the good use of the cost control system built by me (Fore-mentioned above)
• Prepared drilling Well AFE's and Cost estimating Drilling Campaigns
• Re-allocation of indirect costs to their proper cost centers within COA according to internal absorption conventions & Keys.
• Coordinated Cost Control tasks and responsibilities with stakeholders & shareholders
• Developed support Spreadsheet templates for the Drilling operations and logistics such as: Lookahead (Time Planner), Personnel & Equipment List, Load-Out List, Shipping Manifest, Bit Usage Report, and Swimlane flow charts and Gantt charts
• Track & Report Daily Drilling, Workover, & Rigless Costs (Rigless: Perforating, Fracturing, Well Testing)
• Control and monitor expenditures against commitments, budgets, and Invoices
• Liaise with drilling engineers to conduct AFE's (Well Operations Parametric Cost Estimates)
• Daily Analysis and Cost tracking of the Drilling operations and related costs
• Daily and Monthly forecast of drilling costs
• Analysis of the variances and discrepancies between budgets and achievements (AFE Vs Actual Vs Invoices)
• Monitor the financial and chronological progress of the drilling contracts in real time, and launch timely alerts against Over Expenditure and Expiry (Solution developed by me)
• Check the conformity and compliance of supplier invoices with respect to contractual terms and previously recorded costs within VOWD
• Progressive recording of drilling achievements and supplier invoices (VOWD)"
• Progressive recording of drilling cost achievements and supplier invoices (Value Of Work Done-VOWD)
• Supervise exchanges in cost data with the different structures of the organization and the decision makers, and contributed in internal problem solving and cost reduction
• Produced explanatory cost reports embedded onto End Of Well Reports
• Monitor & Report monthly & Yearly Drilling accruals to Finance Department
• Delivered on demand reports & analysis on both Ms Excel & Access to Drilling Manager
• Tracking and reporting Costs of drilling operations to the engineers and drilling superintendent
• Daily preparation of drilling and workover reports
• Storage and management of drilling data on behalf of the department
• Contribution to the preparation of the AFE (Estimated Cost of Drilling)
• Presentation of drilling cost dashboards and Key Performance Indicators (KPI’s)
• Conduct a large inventory campaign of wellhead equipment for two separate projects in coordination with Wellheads service company.
• Development of a successful methodology for the monitoring of the Casing and Tubing (OCTG) and completion modules on behalf of the Drilling and Finance departments
• Supply of the drilling rigs with material according to the operation planner (Time Planner) during the different drilling and casing phases.
• IT support to the drilling team and Workover