• Developed an ETL pipeline utilizing Prefect and Python for data ingestion extracting organizational and researcher data from 7 different sources, followed by data cleaning and wrangling. Pre-processed data was stored in AWS S3 for further processing. • Led the design and implementation of a data processing pipeline to process 40k text data of organizational and researcher data and generating 350 million data artifacts using Python, MySQL and AWS EC2.• Optimized batch processing with a custom claim-check pattern to ensure task management and efficient parallel processing across multiple pipeline stages, reducing overall processing time by 80%.• Tailored the pipeline using custom Python-SQL solution with Implementing chunk-based, parallel and batch processing to improve computation efficiency by 40% and achieving fault tolerance and flexibility in task management.• Designed a database schema to manage task dependencies. Used row-level locking and concurrency control, which increased pipeline throughput by 60% while avoiding race conditions and deadlocks during high-load operations.• Optimized SQL queries through indexing - improving database performance by 35% and reduced retrieval latency for high-volume data.• Created Data Visualizations and Dashboards in Tableau about Resilience Metrics using data from federal, state, and private agencies.• Performed Data Cleaning, Wrangling and Exploratory data Analysis in Python (Pandas, NumPy, statsmodels).• Identified important KPIs and correlations for variables such as living cost, housing eviction, heat and temperature in Arizona, assistance programs, various demographics of population, etc.

Supported Research Advancement team & professors: Gathered data & organized finances for grant proposals and maintenance.Financial Management (MS Excel, AWS BI): Budgeting, Forecasting, reporting, & reconciled financial data, communicating with PIs and aiding in financial planning. Business Operations (Workday): Processed invoices, managed purchase orders, and collaborated with finance stakeholders. Post-Award Management: Assisted ensuring proper fund allocation, oversaw transactions, and facilitated award closeouts.

• Worked with the professor of the class teaching and clearing students’ doubts regarding the class material and coursework.• Helped the students of the class by advising them in their projects for the course and assisting them in their coursework.• Worked and coordinated with the Graduate Teaching Assistant and the professor in every class to make sure the class ran smoothly.