Accountant

Robert Hostetler

robertdhostetler.net / ******.*.*********@*****.***

[pic]

Accountant with experience using the latest software tools to provide

productive accounting and tax information to clients.

EDUCATION / certification

University of South Florida, Tampa, FL

Bachelor of Science, Major: Finance with an emphasis in accounting, 2012 (GPA

3.9)

Stetson University, Deland, FL

Bachelor of Science, Major: Accounting, Minor: Information Technology, 1996

(GPA 3.5)

Graduate studies in accounting at the University of Central Florida to qualify

for licensure as a CPA in the state of Florida.

Certification: Certified Public Accountant

Microsoft Certified Professional - SQL Server 2012

Chartered Global Management Accountant

QuickBooks ProAdvisor - Desktop 2014, 2013, Enterprise, POS, and Online

Affiliations: AICPA, AOPA

SKILLS SUMMARY

QuickBooks 2013, 2014 Drake Tax Software 2012, Microsoft Office Suite

and Online 2013 2000, 2007, 2010

Drake Client Write-Up

Peachtree/Sage Advanced use of Excel Excel macros using Visual

including Power Pivot Basic Applications

ACCOUNTING Experience

Accountant - Tom Ellis CPA & Company, Atlanta GA 02/2013 - Present

During tax season, interview clients to gather relevant tax information and

supporting documents. Complete the tax returns and file electronically with

IRS EFile. Generate client work papers using Excel to write complex tax

calculations. Prepare journal entries using Drake Client Write-Up software.

These entries were used to reconcile the ending balance for partnership

returns. Research tax law changes and make tax planning calculations in

Excel spreadsheets.

Throughout the year, work with clients reviewing and entering data in

QuickBooks Accountant. Maintain QuickBooks by paying bills, creating

journal entries, reconciling bank and credit card accounts. Maintain

historical records by filing documents. Prepare financial reports by

collecting, analyzing, and summarizing account information and trends.

Accountant- Temprel Engineering, Boyne City MI 04/2008 - 07/2008

As an accountant I performed functions such as monthly reporting, accounts

payable, accounts receivable, bank reconciliation, and payroll. Ensured all

transactions were recorded properly in Peachtree accounting software.

Identify accounting irregularities and cost overrides. Provide input to

management regarding the impact of business solutions to the financial

statements and tax consequences or opportunities. I left Michigan because

my father back in Florida had a stroke and required full time care.

OTHER EXPERIENCE

Part Time Associate- RaceTrac, Atlanta GA 10/2013 - Present

Part Time Associate- Publix, Sarasota FL & Atlanta GA 12/2010 - 07/2014

Technician- Gettel Toyota, Bradenton FL 03/2010 - 12/2010

All aspects of automotive repair including inspection, diagnosis, oil

changes, minor engine repair, tire replacement, and brake repairs.

Communicate in layman's terms how repairs are necessary to maintain the

safety of the vehicle.

SQL Server Contractor- Lochrane Engineering, Orlando FL 01/2008 - 04/2008

Wrote queries and trained the Human resource team on how to use SQL Server

2008 at Lochrane Engineering in Orlando. I also migrated reports from

Microsoft Access to SQL Server Reporting Services. Training included the

TSQL language and use of SQL Server tools such as Enterprise Manager,

Profiler, and SSRS.

Software Developer- Vertex Inc, Sarasota FL 06/2002 - 12/2006

Strong knowledge of relational database design and the principles of

normalization. I have created numerous tables with primary and foreign key

constraints and triggers to preserve referential integrity. Experience

writing views and complex parameterized stored procedures with cursors,

temp tables, and inline functions. Improved performance of Vantage Tax

imports by rewriting stored procedures and implementing database indexes

based on results from the Query Optimizer. Stored procedures related to

payroll were nested in transactions so that it was "all or nothing"

operation. De-normalized much of the payroll data to provide a snapshot of

data at the point in time payroll was approved

Report development with Crystal Reports and SQL Server Reporting Services.

Gathered report details requiring complex data analysis and report

management for clients. Built large reports requiring multiple sub reports

and sub queries. The Stacked Entity reports I wrote for one particular

client helped preserve an at-risk engagement valued at tens of thousands of

dollars.

Excel Spreadsheets- Used Excel to format data into CSV files for import

into HR system such as Peoplesoft, and SAP. Extensive use of Excel VBA

macros to transform data from client sources into import files. Set up

complex calculations using Excel for several client applications.

Experience using VLOOKUP, IF statements, Analysis Tool Pack in Excel for

statistical analysis, etc.

Software Tester- Arthur Andersen, Sarasota FL 07/1996 - 06/2002

Software Testing- Wrote scripts with automated testing software (SQA) to

perform regression tests for WorldPro. WorldPro is a 3 tiered application

including a web and console UI interface, business object layer hosted in

COM+, and a large SQL Server database. Working from the technical design

documents wrote test requirements and test cases to ensure adequate test

coverage. UI scripting to validate CRUD operations including required

fields. Data capture at the UI level to verify all data entered can be

retrieved by the user. Test scripts found many bugs in 3rd party controls

that required further coding by developers to prevent unhandled exceptions

in the UI layer. Software testing resulted in delays for early releases

but a highly stable product in later releases.

Client Management- Traveled throughout the country to client sites to

gather reporting and custom solutions requirements. Acted as a client

advocate during JAD sessions with the software development team and

facilitated change management with clients. Wrote custom solutions using

Excel macros to satisfy client needs until functionality could be fully

implemented in future releases of the software.

Contact this candidate