Pranav Mody

Web Developer & Data Analyst

Specializing in AWS Cloud Solutions, SQL, and cutting-edge web technologies like ReactJS to craft captivating websites and robust data infrastructures.

Explore My Work Download Resume

About Me

Pranav Mody

As a versatile Web Developer and Data Analyst, I specialize in crafting intuitive digital experiences and data-driven strategies that power business growth. My expertise spans AWS Cloud Architecture, SQL, and modern front-end frameworks like ReactJS, enabling me to build scalable web solutions and advanced analytics platforms.

With hands-on experience at Holiday Channel, Newfold Digital, and The University of Texas at Dallas, I've led initiatives that boosted feature adoption, optimized UX across web platforms, and reduced churn through actionable data insights. My toolkit includes Python, Tableau, Snowflake, and cloud technologies, which I leverage to drive innovation from prototypes to production-ready systems.

When I'm not designing intuitive interfaces or debugging data workflows, I collaborate across disciplines to bring innovative ideas to life. From agile product sprints to stakeholder presentations, I thrive at the intersection of creativity, technology, and insight.

Connect With Me

LinkedIn GitHub Instagram

Core Expertise

Web Development Data Analysis Business Analyst SQL ReactJS Python

Current Focus

User Experience Data Visualization Data Storytelling Machine Learning

Certifications

Professional Experience

Data Analyst (Product)

Holiday Channel, Remote, USA

Feb 2025 - Present
  • Performed data mining, cleaning, and structuring of recipe and user datasets (Python, SQL) to develop a Gen AI assistant (RAG, LangChain, LLaMA, FAISS), boosting repeat sessions 24%.
  • Partnered with product managers to define success metrics for new features, ensuring analytics tracked retention, engagement, and monetization impact.
  • Built executive-facing Looker dashboards with real-time product performance KPIs, enabling C-level stakeholders to make faster, evidence-based investment decisions.
  • Implemented A/B testing process to measure feature impact, enabling around 3 experiments per quarter and supporting decisions with statistically significant results.
Python SQL Looker RAG LangChain LLaMA FAISS

Data Analyst (Web & Marketing)

The University of Texas at Dallas, Dallas, TX

Aug 2023 - Dec 2024
  • Created predictive lead-scoring models for academic program inquiries using Python (Pandas, scikit-learn) with Google Analytics and Search Console data enrichment and external datasets, improving conversion rates from 3% to 5.4%.
  • Orchestrated SEO and analytics automation across 6 departments, boosting organic traffic 20% and eliminating 40% of manual reporting time.
  • Analyzed user journeys via Silktide heatmaps and Tableau, identifying high-exit pages and informing redesign that improved average session duration by 18%.
Python Pandas scikit-learn Google Analytics Tableau SEO

Business Analyst

Newfold Digital, Mumbai, India

Jul 2018 - Nov 2022
  • Led the design and automation of ETL workflows processing 1M+ Salesforce CRM records daily, improving reporting accuracy by 30% and reducing customer churn by 11%.
  • Acted as liaison between business stakeholders and data/engineering teams to translate requirements into technical specs, driving 15+ analytics and automation projects annually.
  • Spearheaded rollout of IVR and Dialogflow AI chatbot systems, cutting average support wait time from 6 to 2 minutes.
  • Upskilled 20+ employees on self-service analytics tools, increasing adoption by 35% and reducing report requests by 25%.
ETL Salesforce CRM Automation AI Chatbot

Education

The University of Texas at Dallas

Masters of Science in Information Technology and Management

Jan 2023 - Dec 2024

Relevant Coursework

Advanced Statistics for Data Science Organizing for Business Analyst Platforms Big Data Data Visualization Database Foundations System Analysis and Project Management

Dwarkadas J. Sanghvi College of Engineering

Bachelor of Engineering in Electronics and Telecommunications Engineering

Jul 2014 - Jul 2018

Relevant Coursework

Structured Programming Approach Digital Electronics Microprocessors and Peripherals Analog Electronics Computer Communication and Telecom Networks Data Compression and Encryption

Projects

Data Analyst AI

End-to-end AI-powered data analysis toolkit in Python for automating EDA, visualization, and reporting. Integrates OpenAI and LangChain for advanced analytics.

Python OpenAI LangChain EDA

Holiday Quiz Game

Interactive web-based quiz game built with TypeScript. Features dynamic questions, scoring, and a responsive UI for learning about holidays worldwide.

TypeScript Web Game

PowerBI Dashboard

Comprehensive Power BI dashboards for business intelligence, KPI tracking, and data-driven decision making. Includes DAX, Power Query, and custom visuals.

Power BI DAX Data Visualization

Movie Recommendation System

Content-based movie recommender using Python and Jupyter Notebook. Implements NLP and cosine similarity for personalized suggestions.

Python NLP Jupyter

Todo List App

Simple and effective JavaScript-based todo list application for task management. Features add, edit, and delete functionality.

JavaScript Web

Insurance Charges Predictor

Machine learning project in Jupyter Notebook to predict insurance charges using regression models and data preprocessing.

Python Machine Learning Jupyter

Customer Complaint Tableau

Tableau dashboards analyzing 50k+ customer complaints by category, channel, and severity. Uncovers root causes and drives business improvements.

Tableau Data Visualization

Stock Analysis

Jupyter Notebook project for analyzing and visualizing stock market data. Includes technical indicators and trend analysis.

Python Jupyter Finance

Excel Dashboard

Advanced Excel dashboards for business reporting and KPI tracking. Features dynamic charts, slicers, and automated insights.

Excel Dashboard

Sentiment Analysis

Jupyter Notebook for sentiment analysis using NLP techniques. Analyzes text data and visualizes sentiment trends.

Python NLP Jupyter

Stone Paper Scissor Game

Classic stone-paper-scissor game implemented in HTML, CSS, and JavaScript. Play against the computer with a simple UI.

HTML CSS JavaScript

PlayDaily Web App

Fun and interactive web app for daily games and activities. Built with JavaScript and modern web technologies.

JavaScript Web

Skills

Data Analytics & Visualization

Power BI
Tableau
Excel
Looker
Google Analytics

Programming & ML

Python
scikit-learn
Streamlit
R
HTML5
CSS3
JavaScript

Cloud & Databases

AWS (SAA-C03)
Snowflake
Azure
GCP
MySQL
MS SQL Server
Oracle

Tools

Jira
SharePoint
Atlassian
ClickUp
SSIS
Postman
GitHub
GitLab
Figma
Canva
Confluence
Docker
Illustrator
PHP
Salesforce

AI/ML Specialties

OpenAI
LangChain
RAG
LLaMA
NLP
Hugging Face
FAISS
User Behavior Analysis & Optimization
Dashboard Development & Data Visualization
Workflow & Process Improvement
A/B Testing & Conversion Rate Optimization
Data Cleaning & Transformation
Automated Data Integration
Machine Learning & Predictive Modeling
SQL Database Management & Query Optimization
Frontend Development & UX Enhancement
Cross-functional Collaboration
Agile Development & Scrum

Continuous Learning

I'm constantly expanding my skill set through online courses, professional certifications, and hands-on projects. Currently focusing on advanced data engineering techniques and modern frontend frameworks.

Interests

Fitness & Sports

I'm an avid sports enthusiast, enjoying cricket, football, and table tennis. I prioritize fitness with regular workouts to maintain a healthy lifestyle and clear mind.

Travel & Exploration

I'm passionate about travel, as it broadens my perspective and sparks continuous improvement and innovation in my work. Hiking and exploring the outdoors adds to my sense of adventure.

Entertainment

When I'm indoors, I enjoy watching anime and movies, immersing myself in new stories and worlds. These narratives often inspire creative approaches to problem-solving in my professional work.

Personal Philosophy

I believe in the power of continuous learning and growth, both personally and professionally. My diverse interests fuel my creativity and help me approach technical challenges with fresh perspectives.