DAHRIEL SERRANO
Alamo,TX
Summary
Detail-oriented Accounting Professional with a Master's in Accounting and over 12 years of experience managing budgets, payroll, and cost reports. Expertise in journal entries, account reconciliation, and US GAAP-compliant reporting, utilizing advanced Excel functions. Committed to transforming transactional data into actionable insights that support strategic decision-making.
Overview
1
1
Certification
20
20
years of professional experience
Work History
Self-Employed, Tax Preparer
Independent Practice
McAllen, TX
01.2019 - Current
- Prepare over 75 individual & business tax returns each year (1040, 1120-S, partnerships), identifying areas for clients to reduce their tax liability and streamlining business costs.
- Prepared individual and business tax returns using accounting software.
- Utilized Excel formulas, VLOOKUP, and pivot tables to organize and reconcile client financial data, maintaining high volume for 5+ years, aiding clients in selecting appropriate business structures and maximizing key deductions.
- Reviewed tax forms for accuracy and compliance with regulations.
- Assisted clients in gathering necessary financial documents for tax filing.
Accountant Support (QuickBooks)
Intuit
Remote
01.2025 - 12.2025
- Supported QuickBooks clients with accounting and bookkeeping, advising on account reconciliation, transaction categorization, and enhancing general ledger accuracy.
- Managed financial records, ensuring precision in accounting practices to uphold compliance standards.
- Prepared monthly financial statements for internal review and compliance.
- Analyzed expense reports to identify discrepancies, streamlining reporting processes for clearer financial insights.
TurboTax Expert
Intuit
Remote
01.2023 - 01.2024
- Advised individual and business clients on tax strategy and IRS compliance, preparing and reviewing tax filings to ensure accurate deductions.
- Completed day-to-day duties accurately and efficiently.
- Contributed innovative ideas and solutions to enhance team performance and outcomes.
- Worked successfully with diverse group of coworkers to accomplish goals and address issues related to our products and services.
Administrative & Accounting Manager
Kid Abilities Children Rehab
McAllen, TX
01.2007 - 12.2019
- Managed day-to-day operations and served as compliance officer; implementing and updating accounting policies and procedures; processed payroll, labor costs, and benefits for up to 30 employees using QuickBooks.
- Oversaw Billing Department operations, managing accounts receivable and collections, and performing journal entries and account reconciliations while building Excel-based budgets and financial reports for business analysis.
- Prepared and submitted federal, state, and local financial and regulatory reports monthly, quarterly, and yearly, maintaining zero audit findings throughout 12+ years of service.
Education
Master of Science - Accounting
Bellevue University
Bellevue, NEMaster of Science - Business Analytics
Bellevue University
Bellevue, NEBachelor of Arts - Social Studies
UT Pan American
Edinburg, TXSkills
- US GAAP Journal Entries & Account Reconciliation (General Ledger & Bank) Texas State Sales Tax Filing Payroll & Labor Cost Calculation QuickBooks Advanced Excel (VLOOKUP/XLOOKUP, Pivot Tables, Financial Modeling) SAP FI/CO (G/L, Vendor/AP, Cost Center Accounting) & Power BI Supply Chain & Inventory Analytics (EOQ, Safety Stock, Reorder Point, MRP, BOM/Lead-Time Analysis) Transactional Accounting & External Reporting Cost & Budget Analysis Business Analysis & Decision Support Deadline Management
- Tax preparation
- Financial analysis
- Microsoft Excel
- Tax strategy
Personal Information
- Title: Accounting Professional | GAAP, Account Reconciliation & Payroll | Excel, QuickBooks, SAP
- Availability: willing to relocate to Houston, TX or Bartlesville, OK
Certification
- QuickBooks Certified ProAdvisor
- CPA Eligible
PROJECTS
- Capital Investment Analysis (Projections & Pro Forma Modeling) | Coursework, Built a comprehensive Excel model to analyze a potential $245,000 equipment purchase, using payback period, ARR, IRR, and NPV metrics to assess the financial feasibility of the investment., Calculated a payback period of 1.96 years and an NPV of $57,475, using a MARR of 10% to project whether the equipment would exceed its cost of capital., Found internal rate of return to be 22.8%, which I used to recommend whether we should accept or reject the investment.
- Staffing / Capacity Cost Analysis | Coursework, Determined the service system capacity to be 80 applications per hour after calculating the bottleneck step in the process., Performed queuing analysis and used the results to recommend a staffing increase that would cost the business $176/hr compared to the current cost of customers waiting (factoring in service cost and customer wait time cost).
- Inventory & Materials Planning Analysis | Coursework, Applied EOQ, safety stock, and reorder point models to optimize replenishment decisions and reduce stockout risk., Built MRP grids modeling gross requirements, planned order releases, and multi-level BOM lead-time offsetting.
- SAP FI/CO ERP Training | Coursework, Completed hands-on SAP FI/CO training in G/L account analysis, vendor/AP line-item review, and cost center transactions.
PRIOR CAREER
- Secondary Educator | Multiple Texas School Districts (RVHS, MCISD, ENHS, MJH) | Edinburg & Mission, TX | 2001 – 2022
- Taught Secondary Social Studies, Spanish, and Physical Education across four campuses; served concurrently as Administrative & Accounting Manager for Kid Abilities Children Rehab from 2007–2019 while teaching full-time, building the accounting foundation that led to the M.S. in Accounting.
- Named Teacher of the Year (2016–2017); served as Testing Coordinator and Disciplinary Committee member.
- Holds a Master's in Educational Leadership and All-Level Principal Certification (K-12).
Timeline
Accountant Support (QuickBooks)
Intuit
01.2025 - 12.2025
TurboTax Expert
Intuit
01.2023 - 01.2024
Self-Employed, Tax Preparer
Independent Practice
01.2019 - Current
Administrative & Accounting Manager
Kid Abilities Children Rehab
01.2007 - 12.2019
Master of Science - Accounting
Bellevue University
Master of Science - Business Analytics
Bellevue University
Bachelor of Arts - Social Studies
UT Pan American