Hamza Kazmi

Developed AWS asset scanner which provides the state and monitoring status (enabled, disabled) of AWS EC2 instance. Provides list of all EC2 for a particular region, EBS volume not in use and EBS volume unencrypted.Develop AWS ETL pipeline using AWS S3, Glue and Athena.Developed python package using Boto3 which can perform CRUD operation on AWS Dynamodb.Successfully implemented data pipeline that processed 5000 XML files and extracted unique Tags from all the files. Also used REGEX for data extraction

Developed Data pipeline using python which pulls JSON data from RDMS,extracts information from JSON, clean and manipulate data and then re-generate JSON and push data into target tables. Implemented data warehouse to develop architecture to calculate revenue generated by Afiniti clients and productionalized the data architecture.Automated the process for sensors generation which checks Data Integrity.Developed alert to detect missing data

Developed complete ETL pipeline which included extraction of data from tabular and non-tabular data sources and performed Merging of Data Streams, Data Cleaning, Data Validation, Sending Email and Error Handling in ETL pipeline using Pentaho Data Integration.Developed complete ETL solution using SSIS that downloads data from AWS S3 bucket then processed the data according to business requirements, loads the processed data into AWS Redshift data warehouse and then connects AWS Redshift with Tableau

Bachelors in Business and Information Technology