Dauren Malik

Data Analyst & BI DeveloperFull Time

• Job Details:Led analytics work streams supporting business‑unit merge, leftover material clean‑up, warehouse optimization and demand/stock planning across 22 warehouses. Built automated tools, predictive models, and AI‑assisted catalogue search that reduced surplus and improved critical spare availability. Tools: Excel/VBA, Power BI, Power Query/M, DAX, SQL (SAP MM, JDE extracts), Power Automate, Power Apps (material disposition workflow), Azure Synapse / Data Lake, Python (forecasting, anomaly & duplicate detection), basic ML / NLP ingestion. Key Analytics & Automation Projects: - Inventory Harmonization Data Model: Conformed multi‑ERP SKU masters; SQL lookups mapped historical consumption to new global IDs; enterprise visibility across network. - Demand Forecast & Min/Max Reset: Python seasonal & probability models (Stock‑Out Probability) surfaced in Power BI; DAX what‑if parameters let planners simulate service level targets. - Leftovers Clean‑Up & Reorder Tool: Power Apps + Power Automate workflow to route surplus for redeploy/sell/scrap decisions; integrated reorder recommendations; manual process time reduced to 30%. - AI‑Powered Natural Language Item Catalogue Search: Prototype tool to process user text queries and return candidate materials / potential duplicates; improved request turnaround & reduced duplicate stock codes. - Warehouse Optimization Analytics: ABC/XYZ segmentation, velocity heat maps, and slotting analysis used to consolidate slow‑move 'silhouette' stock; unlocked ~$20M value. - Root Cause Analysis Pack: Automated drill‑downs on recurring stock variances, cycle count errors, and procurement lead‑time slips; fed continuous improvement backlog. - Automated KPI Cockpit: Turns, days on hand, stock-outs, critical spare risk; Power Automate alerts when projected on‑hand < safety stock or forecast variance >threshold. - Developed and delivered stakeholder workshops & data‑driven business cases (One TCO Inventory, Material Request Tool) to support strategic resource allocation decisions.

Data Analyst & BI DeveloperFull Time

• Job Details:Built integrated analytics to track system completion readiness, punchlist burn‑down, and turnover milestones for FGP construction, commissioning, and startup phases. Delivered near‑real‑time Power BI visibility and automated data flows that improved schedule fidelity and resource planning. Tools: Excel/VBA, Power BI (enterprise / RLS), Power Query/M, DAX, SQL (Oracle & SQL Server extracts; CSV/API ingestion), Power Automate, Power Apps (mobile punch updates), SharePoint/Teams. Key Analytics & Automation Projects: - System Readiness Dashboard: Unified mechanical completion, commissioning, punchlist, and turnover certificate data; S‑curves vs baseline; contractor & area drill‑downs. - Automated Data Flows: Daily CSV extracts via Power Automate triggered dataset refresh; cut manual data prep from ~6 hrs/day to ~30 min oversight. - Field Data Capture App: Power Apps interface for commissioning leads to update punch status in the field; improved data latency & completeness by ~20%. - Exception Alerts: Threshold‑based email/Teams notifications for critical path systems falling behind plan; supported daily startup readiness calls. - Asset Register Integration: Consolidated Asset Register, PM packages & equipment part lists for ~250K tags from engineering portals into readiness reporting and CMMS load prep. - Implemented Chevron maintenance philosophies & reliability strategies in data models (criticality, procedure mapping) to support transition to Operations. - Delivered CMMS / completion data training to Operations, Maintenance, Reliability & Engineering teams to drive adoption and data quality.

Senior Data AnalystFull Time

• Job Details:Led analytics enablement for national maintenance operations (camps, catering & accommodation facilities). Transitioned reporting estate from static spreadsheets to interactive, refreshable Power BI dashboards; introduced SQL data models, governed KPI definitions, and mentored junior analysts. Tools: Excel/VBA, Power Query/M, Power BI Desktop & Service, DAX, SQL, SharePoint feeds. Key Projects & Results: - Maintenance Performance BI Suite: Migrated 10+ legacy Excel reports into a Power BI semantic model (work orders, labor, materials, cost) with drill‑through to site, asset class, and vendor. - Automated Data Refresh Pipeline: Power Query + scheduled refresh + Power Automate ingest of regional uploads; eliminated most manual consolidation (≈10 hrs/wk). - SQL Data Extraction Layer: Parameterized queries against maintenance & procurement systems; incremental loads reduced refresh windows and improved data reliability. - Cost & Capacity Forecasting Workbook: Driver‑based Excel/VBA model projecting labor hours & consumables demand under seasonal scenarios; adopted in annual budgeting. - Data Quality Remediation: Cross‑functional scrubs (asset IDs, work type codes) reduced critical data defects by ~5%; improved KPI trust for leadership reviews. - Delivered recurring training & quick‑start guides (RU/EN) to site maintenance & finance users, increasing self‑service dashboard adoption and reducing ad‑hoc report requests. - Automated weekly & monthly stakeholder report distribution via Power Automate / Outlook; cut manual packaging effort >30% and improved on‑time delivery to leadership.