Ruthvik Gampa
Research Coordination & Technology Transfer Intern at IDOT | MS Data Analytics Student | AI/ML Enthusiast | SQL | Python | R | Exploring AI-Driven Infrastructure Solutions
- Role
- Research Coordination and Technology Transfer Intern at Illinois Department of Transportation
- Location
- Springfield, IL, US
- LinkedIn followers
- 500 followers
Experience
Research Coordination and Technology Transfer Intern
Illinois Department of Transportation
Sep 2024 — Present · US
DATABASE & DATA INFRASTRUCTURE• Designed and deployed a self-hosted PostgreSQL database server on a secure local IDOT/ICART machine for research and payment data.• Built normalized schemas and optimized SQL queries for structured storage, retrieval, and reporting.• Integrated Directus (data management) and Metabase (analytics dashboards) for real-time insights, trend analysis, and downloadable reports.• Utilized Docker containers to modularize and deploy the system for maintainability and scalability.AUTOMATION & WORKFLOW OPTIMIZATION• Developed an automated payment reminder system in Power Automate (Outlook integration), eliminating missed deadlines for Transportation Pooled Fund (TPF) projects.• Automated budget-tracking workflows by extracting and classifying data from ICT and TPF websites, improving efficiency and transparency.PROJECT & RESEARCH TRACKING• Created detailed tracking sheets for research implementation and IDOT’s contributions to TPF projects (2008–2029).• Reviewed and summarized the Research, Development, and Technology Transfer Manual to document approval processes and funding mechanisms.• Coordinated with project managers to monitor implementation progress across multiple bureaus.FIELD & EVENT SUPPORT• Assisted with a pavement lane-painting Mini Robot during a field visit, learning its programming logic, limitations, and potential applications.• Supported the planning and execution of a statewide research exhibition, enabling collaboration between universities, researchers, and transportation professionals.
Education
CVR College of Engineering, Hyderabad
Bachelor of Technology - BTech, Computer Science
University of Illinois Springfield
Master's degree, Data analytics
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.