Jessup Schons Email & Phone Number

Mission, Ks, Us

Mission, Ks, Us

Kansas City, Missouri, United States

- Wrote and implemented a scalable automation tool in VBA that managed unique processes for over 30 clients, enhancing operational efficiency by over 60%.-Designed a comprehensive user interface in Python using PyQt5 and Pandas to streamline data entry for annual reporting. The interface enhanced user experience, facilitated more efficient data management, and minimized entry errors.-Mapped and redesigned an existing monthly reporting process, transforming a manual, time-consuming task into an automated solution with a user-friendly interface and customizable report options. This improvement significantly reduced manual effort and streamlined report generation.

Kansas City, Missouri Area

- Processed and managed thousands of manual ballots each season, ensuring accuracy and adherence to client requirements.- Developed a comprehensive macro dashboard with over 70 bespoke macros, improving data management and reporting efficiency.- Wrote a Selenium VBA program to automate form entry, reducing an hours-long manual process to just a few minutes, significantly increasing efficiency.- Created a self-correcting model for the research team, facilitating more efficient training and reducing errors.

Kansas City, Missouri, United States

Kansas City, Missouri Area

• Performed detailed examinations of financial documents such as DEF14A's and 10-K's for pertinent data points to run a comprehensive analysis of a company's equity plans. • Reviewed merger filings and golden parachute agreements to make sure the plans were in line with modern corporate governance recommendations and were also aligned with shareholder interest. • Set the all-time R.A Equity Team record for most reports completed in a single day. • Created a sophisticated Excel model to analyze my own data regarding report completion, speed, and accuracy, so I could recognize any weaknesses in my performance. Then using the data points I was able to specifically target the weak areas to improve my overall performance.

Lawrence, Kansas Area

• Managed fraternities budget of approximately $30,000 per semester• Resolved embezzlement scandal from previous president and by end of my term had the Fraternity back in the black• Developed skills and experience in debt collection and monetary communication skills• Represented fraternity at Treasurers’ Academy Leadership Conference in Carmel, Indiana

Lawrence, Kansas Area

Attended all Alumni and university meetings with the Exec Board and gained excellent note taking and listening skills while taking minutes• Facilitated communication between exec board members to help keep both parties objective and happy• Selected to attend a leadership conference at the University of Illinois where I learned skills regarding management of large groups

Lawrence, Kansas Area

• Served as representative for my fraternity at bi-weekly IFC meetings• Refined my skills in communicating information to my chapter regarding the information presented at the IFC meetings as it was vital for our goals to align with that of the university.• Helped my fraternity improve campus relations with the university and IFC via constant communication between groups