Welcometomy3Dspace.

PratikModi

Dataandfullstackengineer

portfolio

aboutme

Introduction & Engineering Profile

Hi, I am Pratik Modi, based in Pune, Maharashtra, India. I specialize in SQL, Python, data analytics, and database engineering, translating complex business requirements into robust, high-performance technical solutions and actionable stakeholder reporting.

Technical Solutions & Enterprise Impact

Results-driven final-year B.Tech (IT) student with hands-on experience in SQL, Python, data analytics, and business intelligence reporting. Skilled at translating complex business requirements into robust technical solutions, working with large-scale datasets, and communicating data-driven insights to stakeholders. Currently interning at Yardi Systems writing SQL stored procedures, packages, and reports. 2× State-Level Hackathon Winner.

Education & Foundation

Bachelor of Technology — Information Technology — MGM University – IICT, Chh. Sambhajinagar (CGPA: 7.9 / 10.0 | 2022 – 2026). Active technical leader, TEDx organizer, and 2× state-level hackathon winner passionate about scalable systems and data intelligence.

Skills & Technical Matrix

Programming & Scripting Languages

SQLPythonJavaScriptHTMLCSSReact (Tailwind, Bootstrap)

Data Analytics & Business Intelligence

PandasNumPyMatplotlibSeabornExcelEDAPower BISSMSSQL Profiler

Databases & RDBMS Architecture

MySQLPostgreSQLSQL ServerSupabaseRDBMS DesignQuery OptimizationStored ProceduresCTEs

Developer Tools, AI & Platforms

GitHubPostmanJupyter Notebookn8nOdoo CRMWordPressShopify

Professional & Collaborative Skills

Client CommunicationAgile CollaborationStakeholder ReportingProblem-Solving

projects

E-Commerce Data Analyst

Python, MySQL, Data Analytics & Business Intelligence

Processed 10,000+ e-commerce transaction records using Python (Pandas, Matplotlib, Seaborn) and MySQL; engineered data cleaning pipelines to ensure analysis-ready datasets.

Wrote optimized SQL queries to analyze sales trends, customer segmentation, and purchasing behavior.

Produced BI-style visualizations and dashboards to communicate key business findings clearly to non-technical stakeholders.

PythonMySQLPandasMatplotlibSeabornSQL OptimizationBusiness IntelligenceEDA

Green Hash — Transparent Waste Management System

Full-Stack, PostgreSQL, Supabase, Agile Delivery

Designed and built a civic-tech platform with Supabase (PostgreSQL) backend, applying RDBMS schema design principles to structure community waste reporting data efficiently.

Implemented an admin dashboard for waste report management, community data visibility, and real-time status tracking.

Delivered end-to-end product development using agile practices and iterative engineering sprints.

SupabasePostgreSQLFull-StackRDBMS DesignAgileAdmin DashboardCivic Tech

Professional Experience

Software Engineer Intern Jan 2026 – June 2026

Yardi Systems India | Pune, India

Developed Stored Procedures (SP) and SQL packages to automate business logic and reporting workflows, translating functional requirements into reliable and scalable database solutions.

Wrote advanced queries using CTEs and cursors for complex multi-step data processing, and implemented triggers to enforce business rules and maintain data integrity automatically.

Built structured reports by joining large relational datasets, applying aggregations, and formatting output to meet business reporting standards.

Used SSMS and SQL Profiler for query performance tuning, execution plan analysis, and troubleshooting data issues in a production database environment.

Web Development & AI Intern Oct 2024 – July 2025

The Startup Mentor | Remote

Developed and deployed client websites using WordPress and Shopify; built creative carousels, portfolio pages, and landing pages that improved client engagement and brand presence.

Reviewed large volumes of business and market data to craft data-driven LinkedIn posts, articles, and blogs; communicated insights through compelling storytelling to grow audience engagement.

Produced technical writing including product documentation, blog posts, and outreach copy; drove SEO strategy and tracked campaign performance using Excel and Odoo CRM.

Built AI automation workflows using n8n, reducing manual reporting effort and improving operational efficiency across client campaigns.

Honors & Key Achievements

2× State-Level Hackathon Winner 2× State Champion

Competitive Engineering & Prototyping

Delivered high-impact technological solutions under competitive time pressure; recognized twice across university hackathons for technical design, architecture, and working prototypes.

Software Engineer Intern at Yardi Systems Enterprise Intern

Enterprise Database Engineering

Engineered enterprise Stored Procedures, SQL packages, CTEs, triggers, and high-performance reporting pipelines for large-scale production database systems.

TEDx MGMU — Organizing Committee Member Organizing Committee

Cross-functional Team & Event Leadership

Coordinated speakers, schedules, and event logistics for official TEDx sessions; led cross-functional student teams to ensure seamless event execution and high attendee experience.

Google Developer Student Clubs (GDSC) — Technical Committee Technical Committee

Technical Workshops & Student Mentorship

Planned and conducted hands-on programming workshops on Python, web development, and data tools; collaborated with peers to instruct 100+ students.

Academic Distinction — B.Tech IT CGPA 7.9 / 10.0

MGM University – IICT

Maintained an impressive 7.9 / 10.0 CGPA throughout coursework in Information Technology while balancing software engineering and industry internships.

contact

Let's Connect & Collaborate

I am always eager to discuss software engineering, SQL and data analytics opportunities, scalable database architectures, innovative projects, or technical collaborations. Feel free to connect directly:

Location: Pune, Maharashtra, India

Email: pratikgmodi22@gmail.com

Phone: +91 93228 48562

LinkedIn: https://www.linkedin.com/in/pratik-modi-11ba02283

GitHub: https://github.com/PratikModi22

finally

Thank you for exploring my 3D isometric portfolio room.
I hope this interactive experience was engaging and demonstrated my technical capabilities!

Google Cloud SkillBoost (GCP)

Microsoft Learn (Azure & AI Basics)

Postman API Fundamentals

Infosys Springboard (Python & Data Analytics)

Udemy (SQL & Python)

2× State-Level Hackathon Winner

Forage Virtual Internships

Let's Upgrade