API Developer at the Harris School of Public Policy, University of Chicago. Reported directly to Scott Schaafsma, with oversight from Samantha Gehm (HR Specialist).
During this 14-month engagement (May 2022 - July 2023), I architected and deployed critical integrations between Salesforce, Cvent, and Drupal, automating event management workflows and significantly improving operational efficiency for the school's IT and events teams.
Key Achievements
Salesforce & Cvent Integration
Real-time Event Data Synchronization
- Built Python and Salesforce REST APIs enabling seamless real-time data sync between Cvent (event management) and Drupal (web content management)
- Eliminated manual website updates, reducing administrative workload by 65%
- Designed scalable API architecture supporting the school's growing event portfolio
End-to-End Data Pipeline Architecture
Automation & Workflow Optimization
- Designed comprehensive data pipelines incorporating custom Salesforce triggers, batch processes, and event-driven workflows
- Implemented campaign management and status tracking scripts automating repetitive administrative tasks
- Improved overall operational efficiency by 87% through intelligent automation
- Reduced manual data handling errors and accelerated event processing timelines
Backend Automation & System Administration
Streamlined Workflows for IT & Events Teams
- Developed robust backend scripts for Salesforce data import/export operations
- Built campaign update and maintenance automation, enabling non-technical staff to manage complex workflows
- Optimized admin workflows for resource-constrained IT and events teams managing 100+ events annually
Impact
The integration enabled the Harris School to:
- Scale event management without proportional increases in administrative overhead
- Reduce manual errors through automated data validation and synchronization
- Empower non-technical teams with self-service automation tools
- Improve data consistency across all organizational systems
Recognition
In their experience letter, the University of Chicago noted: "Hardik exhibited exceptional dedication, professionalism, and a strong work ethic. He consistently delivered high-quality work and demonstrated strong problem-solving skills. His attention to detail and ability to prioritize tasks were invaluable to their role and the team."
Skills Applied
Python · Salesforce REST APIs · Salesforce Flows & Triggers · Cvent Integration · Drupal · Backend Development · ETL Pipelines · Data Automation · API Design · System Administration
Position: API Developer
Duration: May 2022 – July 2023 (14 months, Part-time)
Location: Remote, Chicago, Illinois
Manager: Scott Schaafsma
Organization: Harris School of Public Policy at the University of Chicago