John Lehner Email & Phone Number

Bryan, Ohio, United States

-Orchestrated a high-performing team of 6 resident assistants, overseeing daily operations and mentorship.-Optimized scheduling and training, resulting in a 15% increase in resident satisfaction ratings.-Led 340 students across 4 residential halls, overseeing day-to-day operations and student well-being.-Resolved complex student conflicts and roommate disputes through active listening, conflict resolutionstrategies, and individualized counseling sessions.-Issued comprehensive weekly incident reports that allowed for proper disciplinary action where andwhen needed. Ultimately reducing the amount of issues.

Fort Wayne, Indiana, United States

-Orchestrated the development of an avionics catalog database using Oracle 12c, integrated with Oracle Apex UI.-Consolidated Excel spreadsheets on avionics products, enhancing data management efficiency and enabling seamless data insertion, deletion, and updates, streamlining project workflow by eliminating the need to juggle sources.-Streamlined data analysis for BAE Systems by utilizing Power BI and Midas to identify key metrics in recycle tracking and product returns, resulting in a 20% enhancement in departmental process efficiency.

Angola, Indiana, United States

-Directed relationship-building efforts with 35 residents through personalized communication strategies.-Achieved a high satisfaction rate through personalized communication strategies and tailored serviceofferings.-Offered Advising to first year students on both academic and personal concerns.-Conceptualized and managed a series of interactive student gatherings, such as game nights and talentshowcases, fostering a sense of community and school spirit.

Angola, Indiana, United States

-Showed prospective students around campus-Set up preview days for prospective students to meet with advisors and go on tours-Used Slate to manage information about prospective and current students