Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic

Aftab Alam

Bangalore

Summary

Experienced Data Analytics Engineer with over 9.5 years of expertise in building and optimizing data pipelines. Designed a data pipeline using Python for data load process and integrated Airflow for monitoring dag analyses of job execution .Adept in leveraging dbt and Snowflake to create scalable, efficient data models and analytics solutions. Proven track record in designing robust ETL processes, optimizing data workflows, and driving data-driven decision-making through insightful reporting and analysis.

Overview

8
8
years of professional experience
1
1
Certification

Work History

Technical Lead

Wipro
06.2021 - Current
  • Worked together with cross-functional teams to manage deliverables, organize tasks, and establish requirements
  • Utilized a structured communication framework to address complex client concerns, reducing escalated calls by 40% and improving satisfaction levels from 85% to 95% within a quarter
  • Led Snowflake training sessions, equipping team members with essential skills for successful project management
  • Developed efficient ETL pipelines integrating Snowflake and AWS S3, capable of loading and transforming 50 million rows per hour, which enhanced data accessibility and improved reporting speed by 40%.
  • Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.

Lead Consultant

Virtusa Consulting Services
02.2020 - 06.2021
  • Developed and maintained Snowflake data models, including dimensional and fact tables, to support business intelligence and analytics needs.
  • Lead the design and development of data pipelines using DBT and Snowflake, enhancing data accuracy and accessibility for clients.
  • Integrated webhooks for CI/CD jobs, automating deployment and updates of data models and ensuring seamless and continuous integration.
  • Experience in Developing and maintain DBT models, packages and documentation
  • Achieved nearly 100% timely and defect-free software deployments utilizing GitHub and Deployment tools.

Senior Data Analyst

Novopay Solution
10.2016 - 02.2020
  • Execute data migration projects from SQL Server to Snowflake utilizing Snowpipe, AWS S3, and SQS for seamless data transfer.
  • Design and implementation of ETL processes using Matillion to integrate data from various sources into Snowflake.
  • Generated and Automated the scheduled business reports


Education

B. Tech - Computer Science Engineering

JNTU - Hyderabad
03.2012

Skills

  • Snowflake
  • SQL
  • Python
  • ETL
  • DBT(Data Build Tool)
  • ADF(Azure)
  • AWS
  • Airflow
  • Teradata
  • Sql Server
  • Oracle
  • Matillion ETL
  • Dimension Modeling
  • Data Vault
  • Datawarehouse
  • Project Leadership

Certification

Snowflake SNOW PRO CORE (2023-25)

DBT Fundamentals

Projects

Sales by State (SBS)

Wipro   - 06/2021 - Present

Technology Used - Snowflake, Teradata, Oracle, Python, SQL, Keystone (ETL Tool), Airflow, AWS S3, 

  • Developed and optimized Snowflake stored procedures to load data from core tables into semantic reporting tables.
  • Created Python scripts to promptly generated complex TAX reports in CSV format for business users.
  • Integrated AWS S3 with dashboard servers to seamlessly upload reports for display in a UI dashboard. Core Induction, Snowflake, Teradata, Oracle, Airflow, SQL, Keystone (ETL Tool), Airflow, AWS S3, Designed and developed ETL pipelines for Snowflake

SBS Modelling

Wipro   08/2021- Present

Technology Used - Snowflake, Python, SQL, DBT (Cloud), Airflow, AWS S3, 

  • Developed a comprehensive suite of DBT models to transform raw transactional data into aggregated reports, enabling faster insights and improved data-driven decision-making.

Insights Modelling • 02/2020 - 06/2021
Virtusa
Technology Used - DBT, Snowflake , Python, AWS S3,SQL Server,Apache Airflow

  • Developed and maintained dbt models to transform and aggregate data for analytics, improving data accuracy by 30%.
  • Designed ETL workflows using Apache Airflow to automate data ingestion and transformation processes, reducing data processing time by 40%.
  • Developed and maintained data models in Snowflake, enhancing data accessibility and facilitating analytics initiatives.

Sales Analytics

Novopay Solutions 10/2016 - 02/2020

Performed  data migration using Snowpipe, AWS S3, and SQS from SQL Server to Snowflake 

Designed an ETL and generated business reports 


Timeline

Technical Lead

Wipro
06.2021 - Current

Lead Consultant

Virtusa Consulting Services
02.2020 - 06.2021

Senior Data Analyst

Novopay Solution
10.2016 - 02.2020

B. Tech - Computer Science Engineering

JNTU - Hyderabad

Similar Profiles

CREATE PROFILE
Aftab Alam