Joseph Gallant Email & Phone Number

United States

Chicago, Illinois, United States

Bloomington, Indiana, United States

•Audited financial statements including income statement, balance sheet, and statement of cash flows on a bi-semester basis in collaboration with Vice President of Finance, ensuring the integrity of the fraternity•Examined financial statements, paying attention to detail and using financial skills to find and fix 15+ errors to assure statements were in balance•Led 5+ standards board hearings considering violations to hold members accountable, maintaining fraternity core values

Wheeling, Illinois, United States

•Organized Excel spreadsheets containing 100+ items for daily orders using VLOOKUP functions and pivot tables, reducing filling time in the process by 30%•Adapted to changing circumstances, ensuring customer and managerial needs were met •Shadowed sales department, contributing to foster new client relationships and strengthen existing ones

Bloomington, Indiana, United States

·Utilized risk management techniques such as Monte Carlo simulations to answer conceptual problems presented by 60+ students throughout 10+ meetings, helping students prepare for projects and upcoming exams·Demonstrated spreadsheet manipulation tools such as pivot tables during office hours, solving problems presented by students·Constructed 25+ different visual charts that displayed financial metrics, accurately reaching desired KPIs

Bloomington, Indiana, United States

·Communicate through weekly meetings, answering questions and helping navigate through the college experience and explore study options with mentee, raising grades in the process·Guide 9 freshman students determined to gain admission into the Kelley School of Business by sharing tips about the application process, accomplishing admission for multiple students·Schedule meetings in a timely manner, successfully balancing mentorship requirements and academic tasks

Glen Ellyn, Illinois, United States

Over the summers of 2020 and 2021 I worked as a summer intern for Citywide Title Corporation, with the goal of constructing and analyzing a database. My roles included: •Developed financial models and performed data analysis using excel, utilizing VLOOKUP functions and pivot tables, to support decision-making for the sales department•Collaborated with fellow intern to create new database using Act! software for sales department, increasing potential sales and client list •Presented… Show more Over the summers of 2020 and 2021 I worked as a summer intern for Citywide Title Corporation, with the goal of constructing and analyzing a database. My roles included: •Developed financial models and performed data analysis using excel, utilizing VLOOKUP functions and pivot tables, to support decision-making for the sales department•Collaborated with fellow intern to create new database using Act! software for sales department, increasing potential sales and client list •Presented capstone project to Chief Financial Officer, successfully having updated database applied in company use Show less

San Diego, California, United States

Over the summer of 2018, I traveled to San Diego, California to Intern at Senomyx in the Supply Chain Management department of the company. I was the sole Intern in this department, and worked ahead of pace and quickly learned the necessary skills on the job to complete my tasks. - Assisted company manager in preparation for upcoming audit by organizing 15+ financial statements by date and function- Improved organizational processes by analyzing and fact checking 500+ data entries… Show more Over the summer of 2018, I traveled to San Diego, California to Intern at Senomyx in the Supply Chain Management department of the company. I was the sole Intern in this department, and worked ahead of pace and quickly learned the necessary skills on the job to complete my tasks. - Assisted company manager in preparation for upcoming audit by organizing 15+ financial statements by date and function- Improved organizational processes by analyzing and fact checking 500+ data entries, updating the company’s inventory- Conducted market research on 10+ flavoring ingredients, presenting information to managers for decision making processes Show less