Aarfah Ahmad

Designed and implemented robust data pipelines using Airflow, Python, and BigQuery, streamlining the processing of rental transactions data and reducing data latency by 30%. Led the development of an API leveraging a Large Language Model (LLM) for address components extraction, enhancing the accuracy of address parsing by 30% and improving data quality for downstream applications.

Designed and developed an ETL pipeline for SQL and NoSQL databases, improving analytical task performance by 50%. Led team projects, delegated tasks, and ensured timely delivery of high-quality work. Worked on Solr optimization and vector search integration in Solr.

Created AWS architecture and implemented data warehouse solutions. Developed automated ETL pipelines and prepared analytic reports for stakeholders.

Planned, engineered, configured and deployed Spark scripts by providing optimized solutions to reduce license cost and improve efficiency for Pfizer. Assessed customer needs and goals through communication and system evaluations to modify existing databases and migrated Oracle databases to AWS Redshift. Assisted solution providers with definition and implementation of technical and business strategies

Designed and implemented data warehouses (Redshift/Snowflake) for Aflac and Bristol Myers Squibb (BMS). Developed ETL pipelines and data lake solutions using AWS. Implemented Informatica pipelines for various KPIs in the insurance domain.

Grade: 9.2

Completed a Bachelor of Engineering in Information Technology. Achieved a CGPA of 9.2.

Grade: 91.13%

Obtained a Diploma in Computer Engineering. Achieved a percentage of 91.13%.