Dhiren Mahajan

Partnered with a top U.S.-based real estate client as part of the Retransform team, acting as the bridge between product, data, and operations to ship resilient AI solutions.

• ▹Delivered production GenAI assistants with retrieval-augmented generation, comprehensive evaluation harnesses, and safety guardrails to ensure accurate, compliant responses.
• ▹Automated cross-application workflows with Power Automate, Excel (VBA, Power Query), and SharePoint/Outlook integrations, replacing manual handoffs with SLA-driven dashboards.
• ▹Led document abstraction initiatives by designing schema-first extractors, validation layers, and runbooks for repeatable rollouts across heterogeneous business documents.
• ▹Managed and tuned Microsoft SQL Server instances, defining data contracts and quality checks aligned with business SLAs to protect integrity and performance.
• ▹Implemented proactive PowerShell and Azure administration scripts for health checks, alerting, and remediation, keeping platforms reliable at scale.
• ▹Collaborated across product, engineering, and operations to translate research prototypes into maintainable production systems.

Drove automation, data strategy, and AI experimentation to modernize operations supporting national retail real estate portfolios.

• ▹Engineered document-abstraction pipelines for utility bills leveraging Azure OpenAI, reaching 93% accuracy and sharply reducing manual review.
• ▹Directed SQL database management and optimization to uphold data integrity and accessibility for critical business intelligence workloads.
• ▹Enhanced MRI software capabilities alongside product and operations, focusing releases on usability, stability, and stakeholder feedback.
• ▹Automated operational workflows with PowerShell and Power Automate, boosting responsiveness and reducing repetitive tasks.
• ▹Built actionable Power BI dashboards that elevated decision-making for energy and finance teams.

Implemented embedded control firmware for optical networking platforms while coordinating validation efforts across hardware and test teams.

• ▹Developed embedded control firmware for high-reliability fiber optics and optoelectronic sub-system controllers under senior engineer guidance.
• ▹Authored Python automation for hardware debugging and CHM6 upgrade test cases, accelerating regression coverage and reducing manual effort.
• ▹Collaborated with FW DVT, optical test, system software test, and manufacturing teams to co-develop comprehensive validation suites.
• ▹Worked alongside hardware and optical engineers to diagnose and resolve ZYNQ platform firmware issues.

Fostering a vibrant and supportive campus community through mentorship, engagement programming, and on-call response.

• ▹Mentor a diverse cohort of residents, connecting them with wellness, academic, and social resources tailored to individual needs.
• ▹Design and host community events that strengthen belonging while reinforcing university policies and safety standards.
• ▹Coordinate with housing leadership during incidents, documenting follow-up actions to maintain a safe residential environment.

Supported summer housing operations by training staff, managing logistics, and safeguarding residential assets.

• ▹Trained and coached Desk Assistants on communication best practices, emergency procedures, and service expectations.
• ▹Managed key distribution and inventory, maintaining precise records to support 24/7 desk coverage.
• ▹Coordinated staffing schedules with scheduling software, ensuring coverage and rapid response to operational changes.

Built automation tooling that accelerated multimedia processing and informed media research initiatives.

• ▹Developed scalable Python and PowerShell scripts integrating FFmpeg and Beautiful Soup to handle video frame extraction for 5,000+ films.
• ▹Optimized VLC automation workflows, boosting web scraping throughput by 50% and cutting frame extraction time by 35%.
• ▹Participated in Agile sprints, contributing to planning, stand-ups, and retrospectives for iterative delivery.

Delivered academic support to students and student-athletes across high-demand computer science and math courses.

• ▹Conducted 8+ individualized tutoring sessions weekly across 8+ courses, aligning plans with student success goals.
• ▹Cultivated inclusive environments where learners could candidly address academic challenges and build confidence.
• ▹Completed ongoing training to expand pedagogical techniques and extend classroom instruction effectively.

GPA: 4.0