Maad Saifuddin

Experience

• 

  Frontier Technology Institute

  Jul 2020 - Oct 2021

  Data Analyst

  Translated business needs into actionable reports and dashboards using Power BI, saving one week of manual work and enhancing reporting efficiency.Developed Python scripts for web scraping with Selenium and BeautifulSoup to extract key data from various sources.Conducted data analysis (EDA), preprocessing, and statistical tests using Python, Pandas, and SciPy to deliver accurate insights.

• 

  Blutech Consulting

  Oct 2021 - Jan 2023

  Associate Data Engineer

  Orchestrated the scaling and maintenance of the Cloudera Hadoop data lake for a major bank, ensuring continuous data operations and reducing downtime.Developed and optimized ETL workflows for processing data from sources like T24 and credit card systems, improving data integration by 25%.Extracted, transformed, and loaded diverse data using Hadoop ecosystem tools (HDFS, Hive, Kafka, HBase, Sqoop, Spark), ensuring reliable data flow and accurate reporting.Ensured data quality and compliance by maintaining strict governance standards, and improving data reliability and consistency.Created SQL-based reports and Power BI dashboards, contributing to a 50% increase in actionable insights and data-driven decision-making. Show less

• 

  Qordata PK

  Dec 2022 - Mar 2024

  Associate Software Engineer-Data Engineering

  Designed and implemented scalable data pipelines for the pharmaceutical sector, extracting and transforming structured and unstructured data from various sources including Concur, APIs, and receipts.Developed a sophisticated Risk Engine (KRIS) using Dynamic SQL, stored procedures, and views, optimizing performance and improving risk analysis capabilities.Played a key role in system architecture and scaling, leading to a 20% increase in performance and operational efficiency.

• 

  Systems Limited

  Jan 2024 - now

  Consultant Data Analytics- Data Engineer

  Designed and deployed data pipelines from ingestion to BigQuery, integrating diverse data sources including Redshift, SQL Server, Azure, files, and SFTP servers—resulting in a 60% increase in data availability for real-time analysis.Developed and optimized stored procedures for data transformation and insertion, improving data accuracy and reducing ETL processing time by 40%.Led the successful migration of Cloud Functions from Gen1 to Gen2, enhancing compatibility and boosting process efficiency by 30%.Automated ETL workflows with Airflow Composer, achieving 99.9% uptime and eliminating delays in data processing.Integrated BigQuery with Power BI and SSRS to enable real-time dashboards, enhancing reporting speed by 50% and empowering stakeholders to make informed decisions.Leveraged PySpark and BigQuery for optimized data processing, reducing query execution time by 45% and minimizing storage costs.Designed ingestion pipelines with Apache NiFi for efficient integration of multiple data sources, enhancing ingestion efficiency by 70%.Managed scalable data storage using AWS S3 Data Lake, reducing storage costs while supporting large-scale analytics workflows.Configured AWS EMR and Airflow DAGs for automated Spark processing, improving data processing efficiency by 60% to handle high-volume workloads.Implemented AWS Secrets Manager for encryption and key management, ensuring compliance with data security standards.Developed Python scripts for data cleaning, cutting manual data preparation time by 50%. Show less