UA

Usman Ahmed

Senior Data Consultant at Systems Ltd

Karachi, Pakistan

Work Experience

  • Senior Data Consultant

    Systems Ltd

    Oct 2024 - Present -8 months

    Pakistan

    • Job Details:Utilizing Azure Fabric to ingest data from data lake, executing complex transformations with Spark SQL and PySpark. Creating refined data views and presented insightful dashboards using Power BI for business decision-making. Designing and executing Azure pipelines (Azure Data Factory, Azure Data Lake, Databricks, SSIS), optimizing extraction, transformation, and loading. Proficient in Azure DevOps for CI/CD pipelines, automating deployments, and version control to enhance development efficiency. Applied medallion architecture, performing unit testing in development and migrating changes through testing to production environments.
  • Senior Data Engineer

    Afiniti Inc

    Nov 2021 - Sep 2024 -2 yrs, 10 months

    Turkey

    • Job Details:Automated manual processes, enhanced data delivery efficiency post-Talend migration to Python/PySpark with Airflow. Led data engineering initiatives, extracting diverse datasets using Python/Spark, Hadoop, Talend, and Informatica. Formatted data into Parquet and CSV, orchestrated seamless ingestion into PostgreSQL with Airflow, empowering AI team. Performed data analysis and engineering for clients like AT&T, DirecTV, Bouygues, and Virgin Media, utilizing data warehousing. Built efficient ETL/ELT pipelines to transfer millions of records from Snowflake/Databricks/Palantir using Spark/Talend. Conducted feature engineering on CRM data, building predictive models with ML algorithms (GBM, R-part, Random Forest). Set up containerized environment with Docker, enhancing scalability for Airflow using Docker Swarm on multiple Linux servers.
  • Data Engineer II

    Afiniti Inc

    Oct 2020 - Oct 2021 -1 yr

    • Job Details:Developed and maintained robust data warehouse solutions, optimized ETL processes to enhance data accessibility and reliability. Led the implementation of ETL processes using Informatica Big Data Management and Talend to handle high-volume data. Migrated MySQL to GP/PostgreSQL, established new data sources with Talend and PySpark, and developed testing scenarios. Led CI/CD implementation for ETL, maintaining version-controlled scripts on GitHub/GitLab for efficiency and collaboration.
  • Data Engineer I

    Afiniti Inc

    Jul 2019 - Oct 2020 -1 yr, 3 months

    Pakistan

    • Job Details:Automated scripts in Talend/Python, streamlining tasks, reducing manual intervention, and minimizing the risk of errors. Resolved critical issues promptly, minimizing downtime and ensuring uninterrupted data flow, adhering to ETL standards. Created dashboards and reports with Power BI & Tableau to visualize production metrics, providing stakeholders insights into system performance trends.
  • Education

    • Bachelor's Degree in Computer Science

      Habib University

      Jan 2015 - Jan 2019 - 4 yr

    Skills

    • Python
    • SSIS
    • Talend
    • Informatica
    • Matlab
    • SQL
    • MySQL
    • PostgreSQL
    • Snowflake
    • Spark
    View More
    Share this Profile