Part of the Core team consisted of 10 members and mapped out the ETL Jobs Inventory, CDW(Corporate Data Warehouse) table of 1Tb in Volume, and laid down the groundwork and discoveries from the present architecture.

● Developed scripts using Google cloud function service to trigger and automate daily ETL jobs.● Orchestrated and developed the Airflow composer DAG to migrate 5 TBs of historical HDFS data from cloud storage to Google BigQuery, increasing the data transfer rate by 20%● Developed SQL Scripts and automated the data pre-process, transform, and Insert data to BigQuery making it 40% more efficient. The data was fed to ML forecasting models through Vertex AI which helped an increase in efficiency by 5% to their current models.● Led the team to move on-premises historical data from sources like RDBMS and AS400 to GCP by creating the no-code ETL pipelines using Cloud Fusion.

- Developed Python scripts using AWS Lambda to efficiently handle and process data from AWS S3, managing over 100k HTTP requests made from the client side of the website.- Designed and implemented an advanced data ingestion pipeline using Informatica, extracting and processing large-scale datasets from Snowflake.- Built a dynamic analysis dashboard with Looker, providing actionable insights and data visualization for enhanced decision-making.

● Designed the UI using the UI/UX tool Figma for both web and mobile devices.● Developed website’s client-side using JavaScript’s React framework, HTML and CSS.🔗 https://rishabh-pagaria.github.io/weekendSites/

● Connecting and Inviting guest speakers for online webinars on various topics.● Content Creation for online webinar.● Leading and mentoring a team of 5 campus ambassadors for an event Internship Fair

Learnt basics of Machine Learning and libraries like numpy, pandas, matplotlib, scikit-learn, seaborn etc.Made a project of predicting the score of the person against the no. of hours he has studied by Simple Linear Regression.