QuickBooks
Robert Aguirre
Senior Grant Accountant/Analyst
San Diego,CA
Summary
Organized and dependable candidate successful at managing multiple priorities with a positive attitude. Willingness to take on added responsibilities to meet team goals.
Overview
30
30
years of professional experience
2
2
years of post-secondary education
3
3
Languages
Work History
Grant Accountant
Father Joe’s Villages
San Diego, CA
01.2020 - 01.2022
- Responsible for preparing financial statements, maintaining cash controls, providing financial reporting and analysis in support of funded programs
- Worked closely with other members of Finance Team and Program Managers, focused heavily on budgeting, compliance, reporting and variance analysis functions.
- Administered grants from local, county, state and federal agencies totaling $12 million annual budgets, for a $40 million annual budget organization.
- Created budgets and forecasts for management group to meet regular accounting deadlines
- Detected and corrected mistakes early on and implemented systems to avoid recurring issues
- Modified comprehensive reporting to reflect changing financial structure
- Reviewed accounting structures and procedures on regular basis to identify areas in need of improvement
- Partnered with auditors to track errors and add contributions to maintain accuracy
- Identified and investigated variances to optimize financial plans and forecasts
- Offered advice and direction to help Program Managers better understand financial goals
- Tracked financial progress by creating quarterly and yearly balance sheets
- Supported monthly reporting analysis to achieve validation of internal reports and to reconcile production operations and general ledger
Consultant
Self Employed
Oakland, CA
03.2016 - 05.2019
- Provided bookkeeping services for the Treasurer of the Conference of Interpreter Trainers, and for the Northern California Registry of Interpreters for the Deaf
- Assisted with quarterly and annual reporting, account reconciliation, and QuickBooks Online tutoring
- Provided advice on fiscal policy and procedures.
- Analyzed problematic areas to provide recommendations and solutions.
- Optimized customer experience by delivering superior services and effectively troubleshooting issues.
Financial Manger
People United for a Better Life
Oakland, CA
03.2015 - 12.2015
- Helped client set financial objectives & evaluate and establish fiscal policy
- Revamped bookkeeping software (QuickBooks Premium) to meet organizational needs
- Created first organizational budget in five years; $500,000
- Chaired Financial Committee meetings and prepared financial statements for Board review
- Management of grant accounting activities; monitoring and submitting detailed reports of financial activities to grant donors; keeping track of incoming funds and preparing monthly income statements vs outgoing expenses spreadsheets
Data Analyst
Pacific Gas & Electric
San Francisco, CA
08.2011 - 08.2012
- Processed applications under guidelines from The California Solar Initiative, for residential consumers requesting rebates for installation of solar panels on their homes.
- Reconciled contracts with State solar mandates.
- Learned Customer Care & Billing (accounts receivable) software; and Power Clerk: the online application system for the California Solar Initiative.
- Upheld security and confidentiality of documents and data within area of responsibility
- Identified and documented detailed business rules and use cases based on requirements analysis
Financial Manager
Robert Lewis Construction
San Francisco, CA
07.2007 - 09.2009
- Established budgetary benchmarks and formulated financial management strategies by researching operating and historical financial records.
- Analyzed budgets, financial reports and projections for accurate reporting of financial standing
- Controlled $1 million annual budget
- Developed reporting for executive financial reviews
- Established budgetary benchmarks and formulated financial management strategies by researching operating and historical financial records
- Created and implemented effective accounting systems, best practices and policies
Budget Analyst
Alameda County
Oakland, CA
07.2004 - 09.2007
- Learned CalWIN: public assistance software for Alameda County and wrote “how-to” manual.
- Monitored department budget of $5 million.
- Was liaison to State public health department.
- Assisted with establishing protocols set forth by The Patriot Act.
- Reviewed monthly operations to assess compliance with budgets and determine necessary adjustments for future plans.
- Identified and monitored budget expenses for accuracy and signs of fraud
- Evaluated procurement needs and projected expenditures
- Developed, analyzed and modified budgets to allocate current resources and estimate future financial requirements
- Created spreadsheets using Microsoft Excel for daily, weekly and monthly reporting
Director of Finance and Administration
International Diplomacy Council, IDC
San Francisco, CA
06.2001 - 09.2003
- Custodian of all financial and administrative departments for Non-Governmental Organization partnered with US Department of State.
- Oversaw technological improvements, increasing efficiency.
- Created accurate budget forecasting for $ 1 million budget; approved by board of directors.
- Generated financial and operational reports to assist management with organizational strategy.
- Monitored budget and revenue trends, compiling reports for company leadership to inform decision-making.
- Assisted with recruiting, interviewing and hiring new department employees
- Enhanced internal control systems and procedures to mitigate risk and support opportunities
- Generated financial and operational reports to assist management with business strategy
- Verified compliance of financial policies and accounting procedures against federal regulations
- Analyzed financial statements against forecasts to prepare high-level variance analysis
- Prepared monthly reconciliation of bank accounts and took corrective actions on deviations
- Completed filings and upheld strict compliance with regulatory agencies and supervisors
Education
Baccalaureate - International Business Management/Economics
International School of Economics Rotterdam
Rotterdam, The Netherlands 01.1990 - 06.1992
Skills
Budgeting
undefinedAccomplishments
- Streamlined client list for better AR tracking. Research $4 million in aging invoices. Contacted delinquent clients, made payment arrangements. Worked with Billing department to resolve billing disputes in a timely manner. Reduced aging AR by 35% .
- Processed $2 million in cash receipts and reconciliations on a monthly basis. Analyzed and reconciled bank statements and accounts. Prepared work papers, financial statements and various reports for submission to federal, state, and other agencies and for internal accounting and budgetary purposes.
- Instituted streamlined filing/project records system of over 300 files going back 5 years.
- Created first ever Operating Budget using five years of past records for reporting to Board of Directors.
- Collaborated with San Diego Housing Commission and the Director of the Neil Good Day Center with purchase of $20,000 in new computer equipment within a four day period before the close of the fiscal year.
Software
Netsuite
Black baud
Sage
Timeline
Grant Accountant
Father Joe’s Villages
01.2020 - 01.2022
Consultant
Self Employed
03.2016 - 05.2019
Financial Manger
People United for a Better Life
03.2015 - 12.2015
Data Analyst
Pacific Gas & Electric
08.2011 - 08.2012
Financial Manager
Robert Lewis Construction
07.2007 - 09.2009
Budget Analyst
Alameda County
07.2004 - 09.2007
Director of Finance and Administration
International Diplomacy Council, IDC
06.2001 - 09.2003
Baccalaureate - International Business Management/Economics
International School of Economics Rotterdam
01.1990 - 06.1992
Similar Profiles
Alonzo MorganAlonzo Morgan
Security Monitor at Father Joes VillagesSecurity Monitor at Father Joes Villages
Daniel GaliciaDaniel Galicia
Medical Assistant/Outreach Worker at Father Joe's VillagesMedical Assistant/Outreach Worker at Father Joe's Villages
Eduardo MoralesEduardo Morales
Security Officer at Father Joe's VillagesSecurity Officer at Father Joe's Villages
Siros (Ali) ArdestaniSiros (Ali) Ardestani
Performance Intern at The Fit Lab SDPerformance Intern at The Fit Lab SD
Ezzatullah RahmatEzzatullah Rahmat
Project Controls Engineer at FEC Future Contractors & EngineersProject Controls Engineer at FEC Future Contractors & Engineers