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.
About Me
Data & Business Analyst and Web Developer with 5+ years of experience turning complex data into actionable insights using SQL, Python, Power BI, Tableau, and Looker. Proven success building AI models, marketing analytics, and KPI dashboards that boosted retention, streamlined operations, and supported high-impact business decisions across startups, academia, and enterprise.
I have delivered results in roles at Holiday Channel, The University of Texas at Dallas, and Newfold Digital, building AI-driven features, automating analytics, and leading dashboard/reporting projects that improved business outcomes. My toolkit includes SQL, Python, Power BI, Tableau, Looker, AWS, and cloud data platforms, with a strong focus on requirements gathering, stakeholder reporting, and agile delivery.
I thrive at the intersection of analytics, technology, and business, collaborating with cross-functional teams to deliver actionable insights and innovative solutions.
Core Expertise
Current Focus
Certifications
Professional Experience
Data Analyst (AI Products)
Holiday Channel, Remote, USA
- Programmed and deployed AI recommendation and classification models using Python, OpenAI APIs, and Streamlit, improving product discovery by 15% CTR on the seller marketplace.
- Built and managed PostgreSQL databases and Looker dashboards, enabling real-time insights for leadership and reducing ad-hoc data requests by 30%.
- Collaborated with cross-functional teams in Scrum (ClickUp/Google Colab) to define requirements and consistently deliver AI-driven features within planned sprints.
- Integrated APIs and NLP for automated product classification, streamlining workflows and reducing manual tagging.
Data Analyst (Web & Marketing)
The University of Texas at Dallas, Dallas, TX
- Optimized SEO and website analytics using Google Analytics, SQL, and WordPress CMS, driving a 20% increase in organic traffic and higher student engagement.
- Conducted A/B testing for marketing campaigns and content placement, improving conversion rates by 11%.
- Built SQL-based reports to monitor KPIs and created executive summaries, streamlining decision-making for leadership.
- Partnered with IT and marketing to document requirements and implement web enhancements, reducing load time by 25%.
- Developed time-series forecasting models in Python/R to support traffic and campaign planning decisions.
Senior Data Analyst (Customer Support)
Newfold Digital, Mumbai, India
- Designed and automated live Power BI and QuickSight dashboards for 30+ KPIs with 5-minute refresh, enabling real-time monitoring of calls, chats, and tickets and boosting self-service adoption 35%.
- Analyzed Salesforce CRM data to identify recurring issues, leading to chatbot automation that cut support tickets by 15%.
- Collaborated with operations and engineering using Jira, improving backlog tracking and reducing rework by 20%.
- Delivered monthly performance insights to executives, guiding staffing and training strategies that improved service efficiency, informed decision-making, and ultimately enhanced overall customer satisfaction.
- Implemented data governance and validation checks across SQL, Power BI, and QuickSight pipelines, improving reporting accuracy and KPI integrity by 20%.
Education
The University of Texas at Dallas
Masters of Science in Information Technology and Management
Jan 2023 - Dec 2024Relevant Coursework
Dwarkadas J. Sanghvi College of Engineering
Bachelor of Engineering in Electronics and Telecommunications Engineering
Jul 2014 - Jul 2018Relevant Coursework
Projects
Skills
Data Analytics & Visualization
Programming & ML
Cloud & Databases
Tools
AI/ML Specialties
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.
Testimonials
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.