Tej Gandhi

Experienced analyst skilled in business analysis, financial planning, performance analysis, and business development. Proficient in SQL, Python, and data visualization tools. Track record of enhancing KPI reporting, tracking, and identifying new business opportunities. Committed to contributing to high-performing teams and driving impact through research and analysis.

• AWS Cloud Semester (1&2) & AWS Machine Learning Foundation
• Management Information Systems and Big Data Architecture (NPTEL)
• Data Analysis Using Excel (Upgrade) and Python Data Structures (Coursera)
• Salesforce Essential Training (LinkedIn)
• Data-Driven Decision Using Power BI (Coursera)
• Advanced Power BI: DAX Languages, Formulas, and Calculations (LinkedIn

• Outreach Lead

Google Developer Student Club NUV, Hack Club NUV | 07/01/21 - 05/01/22

• Front Runner

Vadodara International Marathon | 12/01/19 - 12/01/22

• Student President and Events Lead

Navrachana University | 01/05/2021 - 01/04/2023

Public Policy and Government-Related Projects:

• Canadian Financial Markets Analysis:

Developed predictive models and employed data visualization techniques to extract actionable insights, improving decision-making by 20%.

Conducted exploratory analysis and predictive modeling of Canadian financial markets, utilizing ARIMA models for time series forecasting alongside linear regression to analyze interest rates, bond yields, Treasury bills, and inflation data.

• Infrastructure Development Analysis of Ontario

Conducted data cleaning, preprocessing, and geospatial analysis of infrastructure development projects in Ontario, utilizing Python and Google Maps API for reverse geocoding. Created interactive visualizations, including scatter plots and choropleth maps, to highlight project distributions and funding patterns.

Data Science Projects:

• Ethnicity Predictor Model

Achieved a 90% prediction rate using TensorFlow and Keras, analyzing tabular data and images from a dataset of over 20,000 rows.

• Customer Segmentation

Implemented RFM Modeling and K-Means Clustering for a dataset of over 500k customers, providing actionable insights for marketing strategies.

Power BI and Streamlit Projects:

• Precious Metals Price Analysis Dashboard

Developed an interactive tool for analyzing and forecasting the prices of gold, platinum, and silver using Streamlit, Pandas, Plotly, and Statsmodels.

• Global Superstore Metrics Analysis Dashboard

Analyzed sales, profit, customer behavior, and geographical trends using Power BI.

• FIFA Players Dashboard

Created an advanced dashboard with features for in-depth data analysis using Python, Pandas, Plotly, and Streamlit.

• Socio-Economic and Environmental Data Analysis of Major Canadian Cities

Conducted comprehensive socio-economic and environmental data analysis using SQL and GIS, focusing on housing prices, crime rates, and wages across major cities. Derived actionable insights for strategic decision-making by comparing key metrics.

AI Project:

• LLM-Powered Document Analysis Tool

Developed a document analysis tool using BART for summarization and RoBERTa for context-aware question answering, focused on improving accuracy and real-world applications.