ELLA PINZON
Pensacola
Summary
Highly motivated and detail-oriented Bookkeeper with more than 10 years of experience in bookkeeping services. Proven ability to manage payroll, accounts payable, and accounts receivable functions with accuracy and efficiency. Mastery of manual-based accounting software has deepened my expertise in T accounts and double-entry accounting, which has seamlessly transitioned to a professional proficiency in QuickBooks. Adept at leveraging technology to streamline processes and generate insightful data visualizations. Skilled in Power BI, Excel, and Power Query, I create clear and actionable dashboards that empower informed decision-making and support business growth.
Overview
18
18
years of professional experience
1
1
Certification
Work History
Bookkeeper & Data reporting
Tributamos-B&G Associated Accountants
12.2010 - 12.2023
- Managed accounting operations for a portfolio of 15 diverse businesses, encompassing both merchandising and professional service providers
- Conducted precise manual entry of expenses for all 15 businesses, ensuring meticulous financial data management
- Documented daily journal entries for income, facilitating accurate financial tracking for businesses utilizing POS systems
- Conducted monthly bank reconciliations, ensuring precision and alignment between financial records and bank statements
- Generated timely financial reports aiding in informed decision-making by management and strategic planning
- Understands and interprets data to address business problems
- Transforms data sets, provides quantitative and qualitative analysis, and brings to life that analysis through compelling visuals and reporting
- Developed and implemented automated templates leveraging Power Query, enhancing efficiency in payroll generation, accrual processing, and payment management
- Automated various repetitive processes using Power Query, Power BI, and Microsoft Forms, optimizing operational efficiency and accuracy.
Accounting Assistant
Tributamos-B&G Associated Accountants
02.2006 - 11.2010
- Processed over 200 daily manual entries for purchase invoices, ensuring meticulous accuracy and adherence to financial protocols
- Oversaw accounts payable operations for a high-volume workload exceeding 200 invoices daily, maintaining meticulous control to prevent penalties and late fees
- Handled close to 40 daily sales invoices for service-based businesses and managed invoicing for small business clients using POS systems requiring sales invoices.
Education
Associates degree in Accounting -
Institucion Universitaria Politecnico Grancolombiano
Bogota, Colombia12.2019
Skills
- QuickBooks Online & Desktop
- T Accounts
- Accounts Receivable
- Accounts Payable
- MS Excel
- Financial Reporting
- Bank Reconciliation
- Power Query
- ETL processes
- Database Maintenance
- Data reporting & Visualization
- Data inputting
Accomplishments
- Streamlined Transition to Modern Accounting Systems: Efficiently migrated from manual journal entry-based systems to QuickBooks, reducing processing time by 50% and maximizing software advantages.
- Automated Excel Processes with Power Query: Utilized Power Query expertise to automate Excel processes, including payroll and benefits deduction templates, reducing time spent on tasks by at least 80%.
- Developed Interactive Dashboard in Power BI: Utilized coding skills and created measures within Power BI to develop manual dashboards, enhancing data visualization and analysis capabilities.
- Reduced Operational Costs: Assisted management in cutting operational expenses by 15% through detailed financial reporting.
Personal Information
Title: Experienced Bookkeeper | Data Reporting | Quickbooks Online & Desktop
Certification
Certified Bookkeeper
IAP Career College
Languages
English
Full Professional
Spanish
Native or Bilingual
Timeline
Bookkeeper & Data reporting
Tributamos-B&G Associated Accountants
12.2010 - 12.2023
Accounting Assistant
Tributamos-B&G Associated Accountants
02.2006 - 11.2010
Associates degree in Accounting -
Institucion Universitaria Politecnico Grancolombiano
Similar Profiles
ASHORE AVASHORE AV
Accountant at Sanjay Kadel and co. Chartered AccountantsAccountant at Sanjay Kadel and co. Chartered Accountants
Zayn EbrahimZayn Ebrahim
Junior accounts assistant at W & Co independent accountantsJunior accounts assistant at W & Co independent accountants
Dennis LukDennis Luk
Senior Staff Accountant at HSM LLP Chartered Professional AccountantsSenior Staff Accountant at HSM LLP Chartered Professional Accountants
Luljeta ShanksLuljeta Shanks
Lead Teacher at Precious Ones Learning CenterLead Teacher at Precious Ones Learning Center
Krysta CampKrysta Camp
Retail/Sales Associate at Pensacola PoolsRetail/Sales Associate at Pensacola Pools