ANIMESH SHUKLA

Summary: 3.6 years of Experience in Data Analysis and Business Intelligence

• University of Michigan – Python for Everybody | Access Web Data - APIs | Visualizations

Covid-19 analysis using AWS Pipeline:                                                                          04/2023 - 05/2023

• Created end-to-end data pipeline leveraging the AWS environment to analyze the worldwide Covid-19 dataset in Power BI.
• Used AWS Glue crawler to retrieve data from S3 bucket and utilized AWS Athena for preliminary analysis & data modeling.
• Processed the data using Python for ETL to load the curated data into the AWS Redshift dimensional model.

IMDb Data & Analysis:                                                                                                       01/2022 - 05/2022

• Created 30+ ETL pipelines on Talend and Alteryx to load data into stage tables from MSSQL, PostgreSQL, MySQL, & files
• Collaborated with teammates to create, modify, and execute DDL queries for data modeling using SQL
• Constructed ETL pipelines for data integration into the dimensional model and BI schema for visualizations
• Designed 40+ dashboards on Tableau and Power BI with 50+ GB and 1M+ row counts of data to visualize IMDb dataset

Hospital Management System:                                                                                         09/2021 - 12/2021

• Built a hospital management system to manage all patients, staffs, doctors, other users with appointments management
• Simplified manual input and work by 70% through creating SQL scripts for managing all operations
• Normalized database to resolve CRUD anomalies & also to avoid data redundancy for patients, doctors, and admin