JUSTIN DEGUZMAN
Columbia,SC
Summary
Seasoned Accounts Payable and Receivable Clerk with comprehensive experience in managing vendor payments, processing client invoices, and maintaining financial records. Strengths include strong organizational skills, ability to manage multiple tasks simultaneously, and keen attention to details. Demonstrated capability of significantly reducing payment errors while improving accounting processes in previous roles.
Overview
3
3
years of professional experience
Work History
Business Data Analyst, Salesperson, and Accountant
GRANGER OWINGS
Columbia, SC
01.2024 - 07.2025
- Managed over $3 million in payables annually to over 40 vendors through statement and invoice tracking, requiring constant communication with vendors while maintaining an organized and weekly payment manner
- Producer of over $250 thousand in clothing sales through the year while managing over 250 alterations per year. Followed up with hundreds of clients through texts and phone calls, often several at one time to ensure customer satisfaction
- Inventory management: monitored inventory levels of several key stock clothing pieces such as Navy Blazers, White Shirts, and Dress Pants in two different locations. Led a weekly meeting with colleagues to discuss what items to buy for both stores on a dress strategy and create the purchase order on Winsale Point of Sale to track costs, retail price, and margins
- Created detailed PowerPoints through Excel Pivot Charts that tracks and analyzes Key Performance Indicators such as Net Sales, Units Sold, and margins in several departments ranging from suits to shoes on a Quarterly and Year to Year comparison. Led a 20 slide presentation per department on these reports to management to drive business and buying decisions
Development Intern
ST. THOMAS MORE CATHOLIC CHURCH AND NEWMAN CENTER
Columbia, SC
07.2023 - 08.2023
- Worked with the development director on pulling and interpreting different financial data from software databases into Excel to update donations and financial reports which can be used to determine what events can be offered to students over the school year
- Updated Excel spreadsheets that were in use by implementing VLOOKUP formulas to quickly find donor information
- Participated in donor engagement by mailing weekly and monthly newsletters to donors, proposed ideas on how to boost engagement with our community, and assisted in labor work to improve the aesthetics of the student center
Finance Intern
CONSTELLATION GROUP, PUBLICIS MEDIA
New York City, NY
06.2022 - 08.2022
- Created a billability spreadsheet that tracked work hour efficiency in the office of 200+ employees within 3 major departments. Created and presented a 50 slide PowerPoint for upper management that highlighted the average time spent on a major advertising project per team and individual, the strengths and weaknesses of each department through tracking of billable and non-billable hours, and ways to improve effectiveness of the in person work schedule post-COVID
- Embedded Pivot Tables and Graphs, SUMIFS, and XLOOKUP across the spreadsheet that would allow annual reuse of the spreadsheet as quarterly and annual employee hours data comes through the pipeline
- Collaborated with 3 colleagues to create a 30 minute internal proposal in a SWOT analysis format that will allow Publicis to attract Gen Z talent through the use of a mobile social app, a proposal that would give Publicis a blue ocean niche compared to other major marketing firms. Pitched this proposal to other interns in the program and upper management
Education
Bachelor of Science - Business Administration
MOORE SCHOOL OF BUSINESS, University of South Carolina
Columbia, SC05.2023
Skills
- Microsoft Office Suite
- Data analysis and business analytics
- Pivot tables and charts
- SAP software
- Bloomerang CRM
- WINSale POS system
- Invoice and accounts payable management
- Statement tracking
- Inventory management
- Purchase orders
- Relationship management with clients and vendors
- Order processing and control
- Data visualization
- Data evaluation
- Data analysis
- Verbal and written communication
Volunteer and Leadership Experience
- ST THOMAS MORE CATHOLIC CHURCH AND NEWMAN CENTER, Columbia, SC
- Mission Trip Missionary, March 4th, 2023 - March 11th, 2023
- Traveled to Costa Rica with 18 other missionaries over Senior Year Spring Break to assist a rural village in development and spiritual growth. Taught English to high schoolers while connecting to their personal growth through activities like basketball, soccer, and singing, building a sense of community between different backgrounds and cultures. Traveled around the village meeting locals to learn about life lessons by hearing personal stories and providing spiritual advice for future personal growth. Painted the walls of the local Catholic Church to make the church more inviting to community members. Spent 3-4 hours in prayer and service each day to improve my spiritual and mental growth.
Affiliations
I have written articles on LinkedIn about Urban Planning and Development that has garnered thousands of views and reads. Topics range from the City Beautiful Movement that was popular in the 1880s to the conservation effort to protect the Inner Harbor of Baltimore, MD. I manage my own stock portfolio of about $5000 in stocks, doing my own research on different companies and industries. I own and read upwards of 100 books on topics ranging from the History of Coca Cola to Catechism of the Catholic Church. Attends Catholic Mass daily and helps organize events for the young adult ministry. Volunteers at the local homeless shelter at least once a week, serving hundreds of meals to at risk and needy individuals. Member of Columbia Opportunity Resource, a business networking association that highlights significant accomplishments of development projects around Columbia.
Accomplishments
Dean’s List Fall 2019, Fall 2020, Spring 2022, and Spring 2023.
Languages
English
Native/ Bilingual
Spanish
Elementary
Timeline
Business Data Analyst, Salesperson, and Accountant
GRANGER OWINGS
01.2024 - 07.2025
Development Intern
ST. THOMAS MORE CATHOLIC CHURCH AND NEWMAN CENTER
07.2023 - 08.2023
Finance Intern
CONSTELLATION GROUP, PUBLICIS MEDIA
06.2022 - 08.2022
Bachelor of Science - Business Administration
MOORE SCHOOL OF BUSINESS, University of South Carolina
Similar Profiles
Kylee CroskeyKylee Croskey
Sales Representative at Granger OwingsSales Representative at Granger Owings
Jacob DellingerJacob Dellinger
Assistant Band Director/Elementary Music Teacher at Granger School (Granger ISD)Assistant Band Director/Elementary Music Teacher at Granger School (Granger ISD)
Logan HankamerLogan Hankamer
Plastic Injection Molding Machine Operator at Owings PatternsPlastic Injection Molding Machine Operator at Owings Patterns
D'Asia FavorD'Asia Favor
Dental Assistant at Dr. Ellis, Green & Jenkins Pediatric DentistryDental Assistant at Dr. Ellis, Green & Jenkins Pediatric Dentistry
Calvin BoydCalvin Boyd
Custody Officer at Recovery SolutionsCustody Officer at Recovery Solutions