Morteza Mahzoon

Experience

• 

  Snappfood

  Dec 2017 - Sept 2019

  Data Analyst

  • Ingested and transformed data from various sources using SQL, ensuring data consistency and accuracy.• Provided data insights and analytics using Google Sheets and Python, delivering actionable reports to stakeholders.• Created various Excel documents to assist with pulling metrics data and presenting information to stakeholders for concise explanations of best placement for needed resources.• Utilized data visualization tools to effectively communicate business insights.• Used statistical methods to analyze data and generate useful business reports. Show less

• 

  Azimkhodro

  Jan 2020 - Jan 2021

  Data Engineer

  • Created and managed databases for storing and organizing customer data, product information, and other relevant data, ensuring efficient data retrieval and storage.• Developed data models to structure and optimize data for analysis, supporting business decision-making processes.• Performed data extraction, transformation, and loading (ETL) using Python and SQL, streamlining data integration from various sources.• Conducted data analysis and created visualizations using Tableau, providing actionable insights to support business operations and strategic planning.• Automated data reporting and dashboard creation, improving data accessibility and reducing manual reporting efforts.• Collaborated with cross-functional teams to understand data needs and deliver customized data solutions, enhancing overall data quality and utility.• Monitored and maintained data integrity and security, ensuring compliance with data governance standards. Show less

• 

  Informatics Services Corporation

  Feb 2021 - Feb 2024

  Data Engineer

  • Developed and maintained data pipeline ingesting streaming and transactional data from multiple data sources using Apache Spark, Amazon S3, and Python.• Led a seamless migration from Oracle to AWS Redshift, resulting in a 20% increase in query performance and significant cost savings.• Collaborated closely with business intelligence and data science teams to design and implement customized ETL solutions, driving specific business goals and analytics insights.• Implemented and managed containerized applications using Docker, enhancing deployment efficiency and scalability in development and production environments.• Designed quality monitoring and validation processes using Tableau providing clear visualizations for data integrity assessments.• Developed and deployed machine learning models in collaboration with the data science team, enhancing predictive analytics capabilities. Show less

• 

  Lion

  Nov 2024 - now

  Senior Data Engineer

  • Developing, deploying, and maintaining scalable data pipelines using AWS Glue, Step Functions, Lambda, and S3 to ingest and transform data from SAP S4/HANA, external APIs, and other sources into AWS Redshift. • Designing and implementing data models in dbt, ensuring financial, sales, and distribution data are correctly structured for business use, following Kimball methodologies and 3NF principles. • Automating and orchestrating workflows with Apache Airflow for seamless data ingestion and transformation. • Managing infrastructure with Terraform, provisioning AWS resources for scalable and efficient data pipelines. • Performing data acquisition, analysis, and reconciliation across SAP S4, CSD, S3, and Redshift, ensuring data consistency and accuracy. • Ensuring data quality standards by applying software engineering best practices, including version control, testing, and documentation. • Supporting data-related issues, troubleshooting pipeline failures, and optimizing performance for large-scale datasets. Show less