Looking for a job

Joncarlo Abarcar

@joncarloabarcar

Detail-oriented data and operations professional specializing in data tracking, reporting, SQL, and workflow optimization.

United States

Message

What I'm looking for

I’m looking for a data-focused role where I can use SQL and spreadsheets to build reliable reporting, keep databases accurate and clean, and optimize workflows—partnering with cross-functional teams to deliver measurable improvements.

I’m a data and operations professional with hands-on experience in data tracking, reporting, scheduling coordination, and workflow optimization. In my current Freelance Photographer & Media Operations Specialist work, I managed end-to-end client operations—scheduling, invoicing, file management, and data tracking—and maintained organized databases of 10,000+ digital assets with accurate metadata and categorization.

I use Excel and Google Sheets to track bookings, revenue, deliverables, and client communications, and I’ve built optimized workflows that improved turnaround time and delivery efficiency. I also bring a strong data foundation from my Google Data Analytics Professional Certificate (Coursera), including data cleaning, SQL, and visualization using spreadsheets, Excel/Google Sheets, and R.

Experience

Work history, roles, and key accomplishments

Current

Freelance Photographer

Current

Freelance

Jan 2018 - Present (8 years 3 months)

Managed end-to-end event and sports photography operations, including scheduling, invoicing, and client communications, while maintaining a 10,000+ digital asset database with accurate metadata and categorization. Built Excel/Google Sheets tracking and optimized workflows to monitor bookings, revenue, deliverables, and improve turnaround time.

Excel Google Sheets Digital Asset Management Metadata Management Scheduling coordination Invoicing Workflow Optimization

Photographer & Front Desk Associate

JCPenney Portraits

Jan 2024 - Present (2 years 3 months)

Served as a studio photographer and front desk associate, greeting customers, confirming appointments, guiding clients through sessions, and processing payments while maintaining accurate records. Used Excel to track photoshoot schedules and monitor package purchases, invoice records, and customer selections during high-volume seasonal traffic.

Customer Service Appointment Management Payment Processing Excel Scheduling coordination Attention To Detail

Education

Degrees, certifications, and relevant coursework

Coursera

Google Data Analytics Professional Certificate, Data Analytics

Completed the Google Data Analytics Professional Certificate, covering data cleaning, data analysis, and visualization using spreadsheets (Excel/Google Sheets), SQL, and R.

University of Washington

Bachelor of Arts (Geography) and Minor in Informatics, Geography (Data Science Focus); Informatics (Minor)

Earned a B.A. in Geography with a data science focus and a minor in Informatics. Coursework included database programming, machine learning, data visualization, and data management.