Rick Livermore

I want to work from home part time only

San Juan Capistrano, CA

Leveraging 38 Years Experience in Accounting and 15 years in Database Administration, I am focused on Database Administration and Data Migration.

Strong experience with Vertex Returns for Sales Tax, Management Systems, Enterprise Financial Systems, and Reporting Solutions.

Applications Vertex Returns for Sales Tax for billion dollar corporations, complete cycle processing using SQL

Server, Office, Access, Excel, VBA Macros and Html Authorized to work in the US for any employer

Work Experience

Retired Blogger Rick Livermore, Owner

https://webmaster220.blogspot.com - San Juan Capistrano, CA December 2016 to Present

Webmaster220

Bible Study Blog

1. Monetization of my blog (Webmaster220 Bible Study Blog) 2. User of personal computer, laptop computer, smartphone, tablet 3. Developer of routines that allow for incoming newsletters to become blog posts that contain html changes from original code in incoming newsletters to prevent blog post readers from inadvertently unsubscribing the blog from subscriptions that need to continue being subscriptions. 4. Installation of bulk account number replacement routines using Notepad ++ software when incoming newsletters from one of the affiliate companies arrive and get changed to be a blog post thru the use of the menu options Search -Replace - Find What - Replace With. 5. Generate Blog Posts using my own thoughts instead of taking newsletters from others, which are popular because I use search function in Wordsearch, Quickverse, Logos Platinum Bible Software and other applications.

6. My most popular post is this one:

https://webmaster220.blogspot.com/2018/07/the-tree-of-life-as-topic-for-classroom.html The Tree Of Life As A Topic For A Classroom Type Project with 36 Bibliography entries at the end of the post with 389 views. Total Pageviews 103,537

The majority of them were from a spike that came from Hong Kong over a 3 day period last month that were not logged to a sister pageview widget and therefore I don't know if it can be honestly believed to be true. The 3 day total pageview number that should be deducted from the total is 55000. Sr. Tax Accountant / Data Migration Analyst / VBA Developer / SQL Server Database User

LKQ Corporation - Nashville, TN

March 1979 to December 2016

As a Sr. Tax Accountant and Data Migration Specialist, My focus has been shifted to the development of software applications in the Microsoft platform which provide office automation and corporate financial data processing specifically for Vertex Q Series Returns for Sales Tax.

• Developed software with Microsoft Visual Basic.Net and Microsoft technologies to assist in the corporate accounting processing for a company that does over 1 billion dollars in business annually.

• Developed numerous Excel spreadsheets with VBA (Visual Basic for Applications) macros that perform various calculations, formatting, totaling, sorting, advanced formulas, and other routines for execution from VBA (Visual Basic for Applications.)

• Administered a Merchant Credit Card Acceptance Database with Microsoft Access

• Developed a transaction reconciliation report in Access which combines data from our credit card vendor and combines it with local corporate data to create complete and reliable transaction reconciliation reports from joined databases.

• Administered a Payroll Journal transaction history database with Microsoft Access

• Administered an ACH deposit Cash Management transaction history database with Microsoft Access.

• Administered a Direct Cash Management transaction history database with Microsoft Access.

• From the above 3 databases provided migration and processing of over 15,000 debits and credits per month.

• Worked with the IT programmers to automate a line item description for each and every one of those 15,000 debits and credits per month.

• Administered a Sales Tax transaction exporting and importing function using Vertex Q series for Sales Tax Returns software, Prelude Software, Microsoft Access, Excel. This is currently a function that tackles the entire United States, and is around 5,000 records per month. Each record is around 1500 characters in length

• Administered a Sales Tax Return review and confirmation reconciliation system complete with Access Tables, Queries and Reports that makes the time to review and approve the returns for payment and filing be reduced dramatically.

• Generated an emailed, Intranet and network server posted based publication schedule of a monthly Consumers Use Tax Calculation spreadsheet with updated rates inside.

• Created data storage and migration solutions for several departments including Accounting and IT.

• Coordinated tax compliance & research issues with respect to sales tax regulations and directives.

• Studied proposed sales tax legislation for legal implementation across applications, corporate-wide accounting systems, audit processes, and control systems.

• Coordinated all sales tax audits; gathered the necessary data to support transactions; followed through to completion.

• Calculated business license payments including special regressions and allocations when applicable and requesting checks.

• Acquired corporate sales tax permits, business licenses to open new warehouses and renewal for all old warehouses, including state-specific registration processes. Auditor

Defense Contract Audit Agency - Santa Ana, CA

August 1978 to February 1979

Performed Progress Payment Audits, Overhead Audits, Accounting System Audits

• Submitted findings to Defense Contract Negotiators and Purchasing officials Accountant

Lesco Manufacturing Company - Pasadena, CA

January 1976 to August 1977

Accounting manager with direct control of all tax, payroll, and bookkeeping processes

• Accounts Receivable, Accounts Payable, Journal entries, General Ledger posting and General Ledger trial balance.

• Used printing calculator and an electric typewriter, because the office was not equipped with any computer at all.

Skills & Languages Web:

ASP.Net, HTML, Scripting

Application:

VB.Net, Visual Basic 6, VBA Office Application Development, Understanding of Business, Data, and User Levels, Advanced formulas and routines in MS Access and Excel Database:

Access

Education

Continuing Education in Visual Basic.NET Computer Programming San Bernardino Valley College - Colton, CA

December 2004 to April 2005

Bachelor's Degree in Accounting

Cal. State University

Associates Degree

Pasadena City College

Skills

• VB.Net

• VB6

• HTML

• Access

• Excel VBA Macros

• Debits & Credits

• Microsoft Access

• Microsoft SQL Server

• Microsoft Excel

• Accounting

• Spanish

• Microsoft Office

• Software troubleshooting

• Computer literacy

• Computer networking

• Construction

• Administrative experience

• Microsoft Word

• Microsoft Powerpoint

• Accounts payable

• Tax experience

• Accounting software

• Account reconciliation

• Relational databases

• General ledger reconciliation

• Data collection

• Accrual accounting

• GAAP

• Data entry

• Information management

• Google Docs

• Microsoft Outlook

• Sales

• Customer service

• Word processing

• General ledger accounting

• Account analysis

• Payroll

• English

• Typing

Assessments

Spreadsheets with Microsoft Excel — Highly Proficient January 2021

Knowledge of various Microsoft Excel features, functions, and formulas Full results: Highly Proficient

Typing — Completed

January 2021

Transcribing text using a standard keyboard

Full results: Completed

Analyzing data — Highly Proficient

December 2020

Interpreting and producing graphs, identifying trends, and drawing justifiable conclusions from data Full results: Highly Proficient

Work style: Conscientiousness — Familiar

December 2020

Tendency to be well-organized, rule-abiding, and hard-working Full results: Familiar

Data entry: Attention to detail — Proficient

January 2021

Maintaining data integrity by detecting errors

Full results: Proficient

Business math — Highly Proficient

January 2021

Using basic math to solve problems in a business context Full results: Highly Proficient

Indeed Assessments provides skills tests that are not indicative of a license or certification, or continued development in any professional field.

Contact this candidate