ANIMESH SHUKLA
Jamaica Plain,MA
Summary
Summary: 3.6 years of Experience in Data Analysis and Business Intelligence
Overview
3
3
years of professional experience
1
1
Certification
Work History
Data Analyst
FixxGroup LLP
09.2018 - 06.2021
- Analyzed and validated business needs for healthcare & retail projects to align with stakeholder objectives & project scope
- Designed robust data ingestion framework, facilitating extraction of data from various sources into SQL Server
- Performed advanced Excel analysis using functions & pivot tables to analyze complex data sets & deliver insights
- Utilized python libraries to import and export data to large datasets on initial and staging tables
- Deployed scalable Enterprise Data Warehouse (EDW) using Talend and Alteryx ETL, resulting in 80% performance growth
- Crafted ETL scripts to extract data from Google Analytics to SQL Server and Azure Cloud, enhancing data richness by 80%
- Optimized ETL workload by 30% on large datasets by adjustments to data reconciliation process, enhancing data accuracy
- Developed Tableau and Power BI dashboards with bar graphs, scatter plots, maps, Gantt charts, DAX functions
- Participated in scrum practices with lean-agile teams, mapped project flows, resolved issues and backlogs.
Junior Data Analyst
Magnet Brains Software Technology Pvt. Ltd.
01.2018 - 08.2018
- Assisted stakeholders in requirements gathering, defining KPIs, and ad-hoc analysis for decision-making SaaS projects
- Utilized Alteryx to extract data from multiple sources into SQL Server, reducing data complexities by 85%
- Created insightful BI reports on Tableau and Excel, providing actionable insights for shaping future sales strategies
- Boosted sales efficiency by 81% through implementation of A/B testing, regression analysis, and competitor analysis.
Education
Master of Science - Information Systems
Northeastern University
Boston, MA05.2023
Bachelor of Engineering - Computer Science And Engineering
Rajiv Gandhi Proudyogiki Vishwavidyalaya
Bhopal, India06.2017
Skills
- SQL
- PL/SQL
- Python
- SQL Server
- Azure
- AWS
- MySQL
- Talend
- Alteryx
- Power BI
- Tableau
- Excel
- Github
- ER Data Studio
Certification
- University of Michigan – Python for Everybody | Access Web Data - APIs | Visualizations
Projects
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
Timeline
Data Analyst
FixxGroup LLP
09.2018 - 06.2021
Junior Data Analyst
Magnet Brains Software Technology Pvt. Ltd.
01.2018 - 08.2018
Master of Science - Information Systems
Northeastern University
Bachelor of Engineering - Computer Science And Engineering
Rajiv Gandhi Proudyogiki Vishwavidyalaya