Pratik Bharuka

• Engineered VendorSnap, a modular web scraping system automating vendor data extraction from IndiaMART,reduced the sales team’s lookup time by over 90%.

• Handled session-based logins,AJAX scraping, and retry-safe logic; abstracted scraping into reusable modules with config-based workflows.

• Automated internal reporting lifecycle with Python, SQL, Excel templates — reducing prep time 50% with compliance-ready workflows.

• Built Looker dashboards and Excel reports to visualize KPI trends and ensure reporting consistency across sales teams.

• Led project checkpoints and peer reviews as intern Project Head, ensuring deliverable timelines.

• Designed SQL ETL pipelines for 100K+ records; handled schema normalization, deduplication, and cleaning.

• Reduced exploratory analysis time by 40% with Sweetviz + Pandas Profiling integration.

• Awarded $1,000 Star Intern Scholarship by Saint Louis University for top performance and delivery excellence.

Built a strong foundation in programming (Python, SQL), machine learning, and database systems. Gained practical exposure through academic projects, including: AI/ML applications such as predictive modeling and natural language processing. Capstone Project: Developed an Ayurvedic Healthcare Chatbot (Vita Cure) using FastAPI + Cohere, capable of handling 100+ medical queries, with a PostgreSQL knowledge base. Actively participated in coding labs, hackathons, and workshops, which strengthened skills in ETL pipelines, web scraping, and dashboarding tools. Collaborated on group assignments that improved teamwork, project management, and communication skills. Consistently maintained a strong academic record (CGPA: 8.31/10) while balancing internships and personal projects