Dhruv Ahluwalia Email & Phone Number

Vancouver, British Columbia, Canada

Los Angeles Metropolitan Area

• Developed an automated inspection tracking platform using Excel, VBA, Power BI, and Access, reducing project search and look-up time by 98.8%, from 7 minutes down to 5 seconds. Presented tracking platform to company.
• Created VBA scripts to seamlessly pull 10,000+ lines of data from various sources, onto a single PowerBI dashboard. Automation also generated a monthly email to solicit project updates and progress, distributed to key.
• Created VBA scripts to seamlessly pull 10,000+ lines of data from various sources, onto a single PowerBI dashboard. Automation also generated a monthly email to solicit project updates and progress, distributed to key.
• Worked with the Gas Engineering & Distribution teams to take apart and re-assemble gas regulator valves, pressure control checks, and directional flow valves, to be installed in problematic pipelines across Southern.
• Used 2D pipeline modeling software to design a 35-mile pipe to transport high pressure liquid natural gas underground.
• Participated in the deployment of an autonomous robotic pipeline inspection drone into a large pipeline in Chatsworth, CA. Show less

Los Angeles, California, United States

• Redesigned technician time tracking process from a manual entry to automated data upload.
• Developed ~100 VBA scripts to automatically pull 1000+ lines of data from CDK and upload and calculate hours worked by each technician, saving 18.3 hours each month on data entry.
• Developed a management time tracking dashboard aggregating key information for each technician; the VBA script also automatically sent an email to every member of the Vehicle Services Team with their specific time….
• Developed a management time tracking dashboard aggregating key information for each technician; the VBA script also automatically sent an email to every member of the Vehicle Services Team with their specific time.
• Created reports and dashboards, focused on vehicle sales and service revenue, for 3 dealerships. Presented findings and observations to Sales & Service managers, driving sales & inventory management strategy for the.
• Received an extension of my internship, beyond Summer ‘21 to an ongoing timeline. Show less

Vancouver, British Columbia, Canada

• Designed and manufactured hydraulic brakes and suspension integrated wheel hub sub-systems that improved braking response by 0.36 seconds.
• Created a four-wheel drive capable gearbox with a built-in over torquing clutch system.
• Utilized advanced SOLIDWORKS modeling techniques and testing parameters such as Finite Element Analysis to determine factor of safety ratings and stress analysis testing, ensuring professional racing grade manufactured.
• Mentored sub-team members… Show more
• Mentored sub-team members through the project design process and acted as liaison between alumni and members.
• Developed hiring criteria and conducted interviews for new sub-team members, successfully hiring two new students out of a competitive pool of nine applicants.

Vancouver, British Columbia, Canada

Orientation leaders build community through virtual and in-person channels, specifically for first-year students living in on-campus Residence Areas. Leaders are required to be available for peer helping conversations, respond to safety and security issues, and execute aspects of co-curricular/social programming.

• Conducted research on the edX online learning platform to help in the development of potential future banking training and education systems and methods.
• Developed a comprehensive education & training report on the edX online learning environment to aid future decision making regarding the bank's potential engagement with edX.

Palos Verdes Peninsula, California, United States

• Led a VEX IQ Robotics class for middle school students, applying knowledge of VEX robotics and engineering.
• Educated students on the engineering design process and facilitated a robotics design and build course, with a focus on core principles of engineering.
• Assisted in teaching Pre-Algebra, Algebra 1 & 2 and Geometry classes for high school students.

Bachelor Of Applied Science - Basc, Integrated Engineering

Activities and Societies: Alpha Phi Omega, UBC Roundnet, Engineering Undergraduate Society Integrated Engineering degree with.

High School Diploma, Stem

Activities and Societies: VEX Robotics, NHS, SNHS, CSF, Mock trial, PLUS Leadership,