• Assisted in developing Python models to optimize energy storage by integrating historical demand data with weather data from OpenWeatherMap API using requests and pandas.• Designed and built a Power BI dashboard integrating SQL and Excel data, leveraging Power Query for data cleaning and KPI creation and utilizing DirectQuery for real-time updates to identify demand spikes.• Improved automated Python ETL pipelines with Excel and Pandas for data cleaning and SQLAlchemy for database integration, reducing data processing time and enhancing reporting accuracy for energy performance.

• Analyzed complex Excel datasets from marketing and economic research, applying Python packages (pandas, numpy, matplotlib) for data cleaning and analysis and Power BI to identify trends and support data-driven recommendations for research insights.• Collaborated with faculty on data preparation and advanced statistical analyses, utilizing Python and Excel to ensure data accuracy and reliability for research findings and publications.• Tutored students in statistics, econometrics, Excel Data Analysis ToolPak, and STATA, developing their analytical skills and confidence and contributing to notable improvements in academic performance and research project success.

• Utilized Python to clean various Excel datasets, like tenant and property data, resolving inconsistencies in lease terms and payment records to improve reporting accuracy and support management decisions.• Developed a Power BI dashboard/pivot tables to visualize KPI’s (rental occupancy rates, payment trends, and lease expirations), enabling management to identify revenue opportunities and optimize operational planning.• Automated lease tracking and renewal reminders using Excel formulas, streamlined maintenance request updates with VLOOKUP, and improved tenant data accuracy through conditional formatting.• Created KPIs with rental income and expense data, monitored cash flow and created budget projections for property management using Excel's SUMIF, SUBTOTAL, and AVERAGE functions.

• Led a small team of sales representatives, utilizing Salesforce data to monitor performance metrics, identify top-performing strategies, and provide data-driven insights to optimize sales targets. • Implemented weekly performance reports using Salesforce, enabling the team to track progress toward goals and adjust sales tactics proactively, resulting in improved productivity.

• Developed Python-based behavioral models that contributed to three peer-reviewed academic publications, highlighting consumer behavior and psychology trends.• Designed and implemented A/B testing in Qualtrics, providing statistical validation and insights for research surveys, improving the quality of academic findings.• Interfaced with senior researchers, leveraging advanced statistical models to decode complex data sets; garnered insights that shaped ongoing research directions and methodologies.• Participated in a pioneering research effort centering on spatial reorientation and navigation with non-visual cues; conducted innovative behavioral assessments that enhanced the body of knowledge in cognitive science; published the findings in a peer-reviewed journal.

• Tutored 30+ students in statistics and data analysis, improving their performance in statistical modeling courses.• Created interactive learning tools using Excel and R, simplifying complex concepts for better student engagement.