AVINASH JHA
Summary
Dedicated IT professional with a demonstrated proficiency in architecting complex data solutions, leveraging cutting-edge technologies to streamline data processing, storage, and analysis. Expertise in ETL processes, data modeling, and implementing scalable solutions that drive efficiency and enable data-driven decision-making
Overview
6
6
years of professional experience
Work History
Delivery Lead
Acuity Knowledge Partners
09.2022 - Current
- Used databricks notebooks to connect to s3 to process raw ingested data and run logical transformations using pyspark,spark sql
- conducted performance optimization for spark jobs by fine tuning cluster configuration and implementing effective execution strategies.
- Data processing on cloud using aws glue and pyspark. worked with aws glue crawlers for cataloging processed data.
Senior Associate
PwC
08.2021 - 08.2022
- Engineered, automated ETL pipelines with AWS glue studio for efficient analytics-ready data transformation.
- Automated the file loading from AWS s3 to snowflake table with the help of aws sns and snowsql pipeline.
- Experienced in working with Star Schema modeling to develop Cubes using SQL Server Analysis Services.
- Built and published 7+ customized interactive tableau reports and dashboards along with data refresh scheduling using tableau desktop and tableau server
System Engineer
TCS
07.2017 - 06.2021
- Building year-over-year or month-over-month line charts with the use of context and global filters to Witness the growth Of specific dimensions in tableau
- Building high-level KPIs with the use of fixed level of detail calculation to understand the operational efficiency of the Company in tableau
- Building custom datasets with SQL to manipulate data to better suit the dashboard requirement
- Interact directly with client to implement data analysis solutions
- Understand regional and vertical nuances of client market and develop metrics-based dashboard that surface in-depth actionable insights
- Designing and developing complex ETL workflows in alteryx from data cleaning to modeling
- Using different preparation and join tools in alteryx in order to properly manipulate data to help create better data visualizations
- Creating numerous dashboards in tableau desktop based on data collected by clients by importing and blending data from ms excel and csv files along with amazon redshift data warehouse
- Generating dashboards with calculated fields, filters groups, parameters to handle views more efficiently in Tableau.
Education
B.Tech -
Techno India Salt Lake
Skills
- Tableau
- Pyspark
- Databricks
- AWS glue,redshift,s3
- Alteryx
- Snowflake
- Sql
Timeline
Delivery Lead
Acuity Knowledge Partners
09.2022 - Current
Senior Associate
PwC
08.2021 - 08.2022
System Engineer
TCS
07.2017 - 06.2021
B.Tech -
Techno India Salt Lake
Similar Profiles
Naveen KumarNaveen Kumar
Senior Associate at Acuity Knowledge Partners (formerly Moody’s Analytics Knowledge Services)Senior Associate at Acuity Knowledge Partners (formerly Moody’s Analytics Knowledge Services)
Abhisek SasmalAbhisek Sasmal
Assistant Director at Acuity Knowledge PartnersAssistant Director at Acuity Knowledge Partners
Shipra ShivangiShipra Shivangi
Associate at Acuity Knowledge PartnersAssociate at Acuity Knowledge Partners
Kalyani KumarKalyani Kumar
Associate at Acuity Knowledge PartnersAssociate at Acuity Knowledge Partners
Leanne LewisLeanne Lewis
Delivery Lead at Officeworks, ChadstoneDelivery Lead at Officeworks, Chadstone