Muhammad Iqbal Lukman

Experience

• 

  Accenture

  Jan 2018 - Sept 2018

  Technology Intern

  • Analize customer's behaviour for product and user experience improvement• Develop simple web-based dashboard to visualize consumer behaviour data using python

• 

  PT Mattel Indonesia

  Jan 2019 - Jan 2019

  Engineering Intern

  • Creating real-time OEE monitoring using desktop based SCADA and web based application• Develop IIoT infrastructure from generating data in manufacture tools until insight report and real-time monitoring

• 

  PwC Indonesia

  Sept 2019 - Jan 2022

  Data Analytics Associate

  - Enhanced Audit using Data Analytics:Aggregated financial data from diverse client sources (banking, insurance, travel, oil & gas) into a unified, audit-compliant repository utilizing MySQL, MS Access, and ACL. Developed advanced financial metrics and behavioral insights through Power BI and custom Python/Django Web Apps facilitating deeper audit analysis and identifying new audit points.- Data Infrastructure Modernization & Business Intelligence:Modernized a rigid, legacy MS SQL Server 2019 data infrastructure for a travel agency, transforming scattered transactional data from various manual files (Excel, PowerPoint, Word) into a centralized, efficient system. Implemented SSIS SQL Server to automate data pipelines, enriching existing data for diverse stakeholders including business development, customer relations, and executive leadership. Developed and visualized key performance indicators and insights in Power BI, providing comprehensive reporting tailored to various departmental needs.- Cross-Industry Expertise:Thrived in dynamic sectors—fintech startups, Oil and Gas, and Tour and Travel—delivering strategic data-driven solutions. Weniger anzeigen

• 

  OVO (PT Visionet Internasional)

  Jan 2022 - Jan 2023

  Business Intelligence Analyst

  - Regulatory Compliance:Ensured strict regulatory compliance for OVO's government collaborations by performing data quality assessments and modeling in BigQuery (GCP). Developed enhanced assessment insights, visualized in Tableau, for internal monitoring of government projects, effectively detecting and preventing fraud and anomalous transactions.- User Experience Data Insight:Developed a high-volume BigQuery SQL datamart to provide rapid insights into OVO user transaction behavior, enabling precise user segmentation and understanding of transactional patterns. This datamart empowers product teams to create tailored user experiences, optimize offerings, and deliver targeted promotions while also assisting tech teams in strategic feature rollouts and impact tracking on user behavior, visualized through Tableau.- Funnel Data Insight:Enabled A/B testing analysis and post-launch feature evaluation by aligning tracker logs and centralizing data in a data lake using BigQuery SQL, dbt, and Airflow. Provided critical user insights into customer funnel behavior through Tableau visualizations, allowing for continuous monitoring of feature impact, success assessment, and identification of areas for improvement. Weniger anzeigen

• 

  Grab

  Jan 2022 - now

  - Lending and Payment Data Monitoring:Maintained and optimized critical data pipelines for lending and payment transactions using Apache Airflow across GCP and AWS environments, ensuring seamless operation and cost-effectiveness with Spark and Hive. Developed Airflow sensor functions to uphold data integrity, validate data ingestion, and provide essential context to stakeholders regarding lending and payment datamarts.- Pipeline Assistant and Intermediate Solution using AI: Developed and launched advanced LLM solutions, creating tailored assistants for root cause analysis (RCA) summaries. This involved comprehensive data preparation using Python (Pandas) for seamless integration with custom LLM models (Claude-sonnet, Gemini, OpenAI).- Lending Pipeline Optimization and Enhancement:Resolved source issues and delays in the Lending pipeline by migrating from Presto to a customized Spark resource within Airflow, significantly improving performance and manageability. Standardized logic across Single Source of Truth (SOT) datamarts, ensuring timely completion of the SOT datamart and restoring downstream report schedules. Weniger anzeigen - Regulatory Compliance:Performed data quality assessments and modeling in BigQuery (GCP) and Presto to ensure strict regulatory compliance for government collaboration projects. Generated critical reports for Audit teams, facilitating internal monitoring of government projects and enabling effective detection and prevention of fraudulent and anomalous transactions.- Lending SOT and Insights:Developed a single source of truth (SOT) datamart pipeline for ID Lending, tracking the entire loan lifecycle from disbursement to repayment. Initially built on BigQuery and Airflow (GCP) for regulatory compliance, the pipeline was subsequently migrated and rebuilt in Spark SQL to provide a seamless experience for the Analytics team in building downstream reports and monitoring internal KPIs.- Customer Service Insight:Built a datamart pipeline using BigQuery and Airflow to monitor customer service metrics, specifically analyzing the relationship between customer service tickets and features like payments and products. Created comprehensive monitoring dashboards in Tableau and Power BI, providing customer service stakeholders with critical insights into key metrics such as CSAT (Customer Satisfaction) and CPT (Contact per Transaction). Weniger anzeigen

  • Data Engineer

    Jan 2023 - now

  • Business Intelligence (Data Analyst)

    Jan 2022 - Jan 2023