Data and Automation Expert 🚀

Hey, I’m Tejas !! My journey started in Mechanical Engineering, but I quickly realized my love for data, automation, and business intelligence. I specialize in data-driven decision-making, process automation, and optimizing workflows using SQL, Python, Power BI, and RPA tools like Ui Path & Microsoft Power Automate.

Education

M.S, Data Science (GPA 3.8) | University of Arizona (May 2025)
B.E, Mechanical Engineering (GPA 3.4) | University of Mumbai (August 2021)

Work Experience

**Data Analyst – IT Pros (May 2025 - Present)**

Led requirement-gathering sessions for dashboard development projects, resulting in 30% improvement in decision-making efficiency.
Bridged communication between technical teams and business users by converting ambiguous requests into clear, actionable data requirements.
Developed and maintained interactive dashboards using Tableau and Power BI to visualize complex datasets, resulting in a 30% improvement in data-driven decision-making processes.

**Data Analyst Intern– Avex ATP LLC (Dec 2024 - May 2025)**

Executed SQL scripts, creating indexes, stored procedures for data analysis and maintained PL/SQL objects like packages, triggers, procedures etc.
Participated in and implemented in end-to-end BI projects, including requirements gathering, data modeling, ETL processes, and report/dashboard development.
Designed and optimized SQL queries for MS SQL and Oracle databases, ensuring accurate data retrieval.
Developed and maintained interactive dashboards using Tableau and Power BI to visualize complex datasets, resulting in a 30% improvement in data-driven decision-making processes.
Collaborated with cross-functional teams throughout the SDLC to ensure seamless integration of reporting solutions and alignment with business requirements.
Analyzed large datasets to identify trends and patterns that informed strategic business decisions, contributing to a 20% increase in customer retention rates.

**Data Analyst – Smartfox (Jan 2021 - Nov 2023)**

Conducted exploratory data analysis (EDA) using Python (Pandas, NumPy, SciPy) to identify trends, anomalies, and insights from large datasets of millions.
Conducted advanced data analysis using SQL and Excel to uncover key business trends, driving a 25% increase in customer engagement through targeted marketing campaigns.
Collaborated with cross-functional teams to understand business requirements and translate them into data-driven solutions, leveraging Agile/Scrum methodologies.
Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI.
Conducted in-depth Cost/Benefit, Risk, Impact, SWOT , Regression, Time Series, Decision Making and GAP Analysis.

Technical Skills & Certifications

Data: Data Analysis, Data Visualization, Data Mining, AWS, SAP, MongoDB

Languages: R, Python, Visual Basic

Tools: Ui Path, Microsoft ( Power Automate Desktop / Cloud, Power BI ), Qlik Sense

Soft Skills: Time Management, Cross Functional Teamwork, Verbal & Written Communication, Innovation, Analytical & Critical Thinking, Leadership, Project Management, Process Documentation, Compliance Reporting, Data Driven Decision Making, Risk Analysis

Certifications: UiPath, Microsoft Power Automate, Microsoft Office, Microsoft Power BI

Academic Projects

Covid - 19 PowerBI Dashboard (View Here)

Visualized total COVID-19 cases by continent using a dynamic map and waterfall chart.
Tracked monthly trends for India and Indonesia with a time-series line graph.
Integrated DAX measures and Power Query for accurate data modeling.
Enabled users to interactively explore global and regional pandemic data from January 2020 onward.

Tech: SQL, PowerBI

Match Winner Analyzer (View Here)

Developed a predictive model using regression classification to forecast cricket match outcomes based on live match data
Deployed the model on a web page that updated in real time as new match statistics were fed into the system
Enhanced user engagement by providing dynamic, live predictions during ongoing matches

Tech: R, Quarto, REST API, Spring Boot, Java

Cricket Metrics Dashboard (View Here)

Built a dynamic dashboard using R to analyze cricket match trends based on historical datasets
Simulated real time game insights without the cost of live data feeds, offering users a near live experience with historical data
Applied data visualization techniques to create an engaging and informative interface for users

Tech: R, Python, REST API

Flight Matrix (View Here)

Analyzing flight data from major Belgian airports (2016 2019) to identify trends, seasonal variations, and Brussels Airport’s dominance in flight activity.
Chi squared statistical analysis confirmed significant differences in flight distribution across Belgian airports.
Exploratory Data Analysis with visualizations and hypothesis testing.

Tech: Python, HTML

Premier League Performance Metrics (View Here)

Analyzed how in game metrics (shots, fouls, cards) impact match outcomes in the 2021–2022 EPL season.
Used logistic regression to predict match results with 78% accuracy based on key in game statistics.
Explored team rankings if matches ended at halftime, revealing significant changes for some teams.
Top teams remained stable but clubs like Southampton improved drastically, showing the importance of second half performance.

Tech: Python

The Power of Voters (View Here)

This project analyzes US House election trends (2016 2020) and Arizona’s congressional shifts (2012 2022).
Maps and charts highlight how district based representation differs from popular vote trends.
Arizona’s elections show shifts in party control and the dominance of traditional voting methods.
Findings reveal voter sentiment changes and the impact of electoral systems on representation.

Tech: R, Quarto

Academic Work Experience

Graduate Teaching Assistant - University of Arizona

Responsible for grading assignments, exams, or other assessments.

Captured and edited digital content including photoshoots, events, and team videos, ensuring high quality production for Wheelchair Tennis and Basketball.
Assisted the Manager of Adaptive Athletics Creative Media in designing and producing recruiting materials for Wheelchair Tennis and Basketball, enhancing player engagement.
Designed custom imagery tailored for specific athlete prospects, ensuring alignment with brand identity and recruitment goals.
Cataloged digital media assets, ensuring efficient organization and accessibility for future projects.
Contributed to social media content planning, creation, monitoring, and editing, enhancing the University of Arizona’s Adaptive Athletics media presence.