Financial Analyst Assistant Controller
Resume:
RAFAEL SCHNELL, CPA
Austin, TX 78731
**************@*****.***
EXPERIENCE
APRIL 2010 – APRIL 2022
AECOM (Multi-nationational engineering, design and services corp) Austin, TX
Joint Venture Manager/ Joint Venture Supervisor /Senior Accountant
Managed up to seven person staff; encourage professional development.
Aid in development of team members by providing training to increase GAAP compliant financials and develop analytical ability.
Prepare summary joint venture reports; combining data of more than 230 JVs.
Prepare/ lead discussion of quarterly joint venture summary report for RFD conference calls.
Prepare consolidation entry for applicable JVs each month.
Prepare Cash Forecasting for JVs’ distributions.
Work with senior management to evulate impact/strategies of JVs results to corporate finances.
Review JV agreements to ensure compliance with GAAP, unusual stipulations and assist in manging the AECOM approval process for pending JVs.
Participate in risk management review of new joint ventures.
Manage banking relationships with three banks.
Developed process for ACH payment for JVs.
Respond to internal and external audit queries for JV team activity.
Review financial documents prepared by department.
Review reconciliations of joint venture department.
Assist in data conversion from legacy GL to acquiring company’s GL.
Develope departmental policy and best practices.
Interface with other departments to facilitate cooperation.
Prepared SEC consolidation report emphasizing residual value and quarterly/annual fluctuations.
Designed database for maintaining non-accounting/operational data for over 300 current, pending and dissolved joint ventures.
Transform database to be repository for current year financial data for all jvs to facilate reporting to corporate..
Reconcile accounts: bank accounts, accounts receivable, accounts payable and others; prepare adjusting entries as necessary.
Comeplete or review all month end journal entries.
Prepare monthly financials for JVs.
Process AR, AP, cash receipts and disbursements for JVs monthly.
JULY 2008 – APRIL 2010
Boundless Network (Privately owned promotional products distribution co.) Austin, TX
Senior Accountant
Preparing monthly departmental P&L statements for executive management; emphasizing key ratios and budget variances.
Participate in month end close; producing adjusting entries; verified accuracy of key accounts before close; performing other duties relating to general ledger.
Reconcile and audit key accounts: all bank accounts, customer deposits, fixed assets and others; prepare adjusting entries as necessary.
Prepare bi-monthly payroll journals, prepare daily cash-flow analysis, and manage external wires and corporate credit cards.
Lead contact in bi-yearly investor audit and participate in year-end audit.
Designed database for reconciliation of Purchase Clearing account; conduct monthly analysis and prepare adjusting entries.
Produce AR invoices through Great Plains.
Aid in development of team members by providing training as needed.
MARCH 2001 –JULY 2008
DHI Mortgage (Mortgage arm of D.R. Horton Home Builders) Austin, TX
Senior Accountant/Financial Analyst
Prepared monthly 50+ branch P&L statements for all executives and production managers; emphasizing key ratios and budget variances.
Aid at month end; produced adjusting entries; verified accuracy of key accounts before close; performed other duties relating to GL.
Reconciled and audited key accounts: cash, principle loan amount and securities; prepare adjusting entries when necessary.
Designed databases for receipt of $4-5 billion dollars annually of loan sales with emphasis for efficient month-end reconciliation, ad hoc analysis and yearly audit.
Developed monthly staffing projections report for fiscal year. Aided in development of yearly budgets; produced pro formas at both corporate and branch level.
Computed user and exercise taxes for various taxing agencies and prepared reports for compliance of individual states.
Lead analyst in developing multi-layered financial reporting tool.
Conduct training sessions for new production managers regarding financial reports and training sessions for general employees on Microsoft Excel.
OCT. 1996–
JAN. 2001
Alex Sheshunoff Management Services (Consulting for community banks) Austin, TX
MIS/Financial Analyst
Performed analysis on banking institutions utilizing FDIC call reports. Created opportunity reports using Visual Basic to automate task. Produced multiple scenarios based on consultants’ requests.
Developed marketing performance evaluation tools using Access databases. Performed statistical analysis of data with SPSS software.
Lead analyst for Benchmarking product, a financial performance model. Responsible for validity of data, producing and distributing final report.
Conducted market analysis of AlexeBanking Procurement Service.
JAN. 1995 –
OCT. 1996
Internal Revenue Service Austin, TX
Tax Data Entry/Trainer
Assist in the training of newly hired data transcribers.
Manually input tax-payor information into the computerized IRS system
SOFTWARE
MICROSOFT
Excel (Experience with macros and visual basic programming)
Access (Experience with database design)
Window, PowerPoint and SharePoint
ACCOUNTING APPS
Oracle
E1
Peachtree
Great Plains/FRX Reporting Software
JD Edwards
Salesforce
Infinium
Quicken QuickBooks
Loan Base and FICS (Systems for mortgage servicing)
OTHER APPS
SPSS (Statistical software)
EDUCATION
DECEMBER 2011
Texas Board of Accountancy Austin, TX
Received CPA license.
SPRING ’05 –FALL ‘08
Austin Community College Austin, TX
Pursuing qualifications for CPA.
FALL ’90 - SUMMER ’94
University of Texas Austin, TX
History/Psychology. Received Bachelor’s of Arts.
FALL ’88 -
SPRING ‘89
University of Alabama Tuscaloosa, AL
Psychology/History Majors. Received Dean’s List Honors.
Contact this candidate