Post Job Free

Resume

Sign in

Financial Analyst Senior Accountant

Location:
Murrieta, CA
Salary:
120000
Posted:
November 01, 2023

Contact this candidate

Resume:

Jay Bineau, C.P.A, MBA, JD

ad0rrg@r.postjobfree.com, 1-951-***-****,1-951-***-****

● Cost Accountant ● Budget Implementation ● Software Developer

● 10K/Q SEC Reporting ● Microsoft Dynamics G P ● Financing Industry

● Controller ● MS SQL Server ● Manufacturing Industry

● Financial Analyst ● MS Excel/ MS Word/Access● Marketing/Medical Acct

● Hospitality Industry ● People Soft/Net Suite ● Financial Stmt. Consolidations

● Construction Industry ● Intuit LaCerte taxes ● QuickBooks/Sage

ROBERT HALF - FAMILY SERVICE CENTER

Controller 04/23 to present

Using the MIP Accounting for Non-Profit we were able reduce workload in checking A/P, G/L and A/R 50% since the department, program and site combination was now handled in the MIP oftware without staff manually checking the combination.

We have done major clean up of the Balance Sheet and Income Statement by checking all G/L accounts and making corrections as appropriate.

We automated the financials using Excel macros to give the departments heads and CEO and upper management the financial information in a timely manner.

All improvements we helped create involve me using my teaching abilities to train staff so they can use their knowledge to solve accounting problems like multiple controllers giving FSA a huge staff improvement. I enjoy improving the team.

COMMERCIAL LIGHTING INDUSTRIES 01/23 TO 03/23

Controller 01/23 to 03/23

Streamlined A/R & A/P monthly bank report creation to just 45 minutes instead of outside CP firm taking 2 days to do the monthly reports with use of Excel Macros.

Using Epicor Solar Eclipse software report generator report with side by side monthly balance sheet and income statement were created making financial statement easy to print and analyze.

Simplified Epicor Solar Eclipse tax filing with Sales reports

Controller position duties reduced due to efficiencies and streamlining of controller duties by actions above and other streamlining of controller position by talented CFO and Operations Manager.

Controller able to help out other areas of company with free time created in controller position.

ROBERT HALF ARMTEC INTERNATIONAL 08/22 TO 12/22

Senior Accountant 08/22 to 12/22

G/L Account Reconciliation, Payroll Journals and other journals

Automated Financial Statements Used Infor LN trial balance to create 16 Income statements in MS Access & Excel

ROBERT HALF ELSINORE VALLY MUNICIPAL WATER DISTRICT 04/022 TO PRESENT

Financial Analyst 04/22 to 07/22

Maintain financial statement comparing dollar expenses with budget

Export large data set required to compare dollar paid for water and water flow of water

Reconcile water and sewer service credits to developers and water district.

ROBERT HALF TITUS MAINTENANCE & INSTALLATION FONTANA, CA/ TVA TEPLA/ FRONTIER HOLDINGS INC/ SUNLINE TRANSIT AUTHORITY

Consultant Controller, Senior Accountant 02/21 to 03/22

Help load payroll open enrollment data at end of year into the Tyler Incode ERP solution

Help with all journal entries of the monthly close

OK Bank recs and journal entries

Create extensive Excel macros and accounting software for loading files and budgets

QuickBooks 20.0 Desktop Enterprise I streamlined and sped up accounting system while freeing up CEO time and money.

Using Tyler Incode Technologies ERP solution to help create accounting journal entries. In addition I am help preparing detail Excel financial analysis for CFO.

Helped Sunline Transit Authority setup import procedure for journal entries from Excel/csv files in Tyler Incode Technologies ERP.

Using QuickBooks I created consolidated Financial statements Balance Sheet, Income Statement, Cash Flow for Frontier Holding Inc for their five Retail, and cultivation companies that sell Cannabis. I also completed all workpapers for their five subsidiary companies in preparation for the full audit. Doing the full metric analysis for all five companies.

Helped migrate QuickBooks from Cloud to local network with backup up and condensing of data.

Implemented a no cost scanning system of all A/P invoices into shared accounting directories, this in turn sped up A/R billing process since material invoices now separated by vendor name, invoice date, invoice number, check #, project job code and profit center all at CEO and managers fingertips online for 2020-2021.

Help implement TCP (Time Clock Plus) setting up new payroll time system to speedup biweekly payroll. I created export time detail for A/R billing of the employee time spent to various clients/customers thus ensuring timely biweekly billing to clients/customer.

Implemented the use of Transaction Pro Importer in order to quickly import payroll time biweekly into Quick Books so that staff is paid in a timely manner.

Added financial balance sheet and income statements by client project and jobs.

BAILBOND HOTLINE RIVERSIDE, CA

Accounting Consultant 08/20 to 12/20

Using Online QuickBooks and import software speed up import of journal entries. In addition I streamlined and cleaned up Accounts Payable system in Quick Books.

Worked on setting up MS Access connection to SQL database of Bailbond Hotline service to access non accounting system to create Account Receivable schedules and liability schedules in order to collect and track millions of potential income for Bail Hotline in old A/R bills.

Using the MS Access SQL connection to bailbond data also track proper collateral and bond provision so that company was charging proper fees

ROBERT HALF BULK TRANSPORTATION WALNUT, CA

Accounting Controller 06/20 to 07/20

Using MS Great Plains Dynamics create financial statements in order to close the business down by end of July 2020. Moved financial statements from Excel to Management Reporter by cleaning up the chart of account categories.

Did all major wires and bank account transfers of many hundreds of thousands of dollars.

I also work in A/R posting and importing billing of TMW into MS Great Plains of A/R and then posting of deposits into the A/R system of MS Great Plains.

I also printed A/P checks and input A/P when staff shortages occurred.

Help CPA organize bank reconciliation and clean up of A/R and A/P from prior years in order to close 2019.

Completed several income financials along with balance sheet.

SEIGLER & TWEEDLIE CPAS RIVERSIDE, CA

Staff Audit Accountant 12/19 to 03/20

Using Thomas Reuters Workpapers CS I was able to complete audit report and review report for different clients by myself with very helpful supervision from partner.

I also worked on client compilation project remotely at computer at home with great speed and discipline.

Enjoyed working on tax research projects for partners of firm.

Completed all CPE requirements for 2020.

I also completed tax return for client while reviewing other tax returns in Intuit Lacerte software.

Worked with partners and accounting auditors to help complete work papers for major client Farmer Boys including remote work and site work on client premises.

APPLE ONE – PERRICONE JUICES - BEAUMONT, CA

Senior Accounting / Financial Analysis work 08/19 to 11/19

Use Sage300 software to implement a clean efficient import of journal entries and bank reconciliation service journals from extensive Excel to Sage300 saving Perricone staff from reentering long journal manually into Sage300 while producing a more detailed and informative general ledger. Goal is to make full use of Sage300 automation features so that all input is minimized leaving more time for accounting review.

Completed 8 months of general and payroll bank account reconciliations in MS Excel format and then in Sage 300 accounting system setup bank reconciliation and daily cash balances to allow Perricone Juices to have a daily cash balance in Sage300 software at their finger tips.

Currently working on complete import of MS Excel fixed asset listing into Sage300 to allow automated computation of monthly depreciation.

Currently working on generating a complete daily cash usage financial analysis record for 6 months of activity.

KARAT BY LOLLICUP- CHINO, CA

Interim temporary Controller work May 1 – June 28, 2019

Using NetSuite setup clean customized useful financial statements mapped to GAAP requirements. Lollicup Inc (C Corp) was a full plastic, paper, food service manufacturing Inc company with offices and production facilities all over United States

Helped check & complete closing entries of parent and subsidiary company while financials manager finished her maternity leave.

Worked with outstanding software development staff to fully utilize NetSuite capability to post land sale.

Worked in Quick Books to do parent and subsidiary company checking and posting of Karat & Global Wells LLP respectively. Worked with excel company consolidation schedule of 3 entities to complete financial check of S-1 filing financials reviewed by BDO in 10Q format.

Assist & supervise outstanding A/R, A/P and financial analyst staff to check and correct posting of staff and check and correct contracted CPA firm working for Karat helping with the filing of S-1 document for a public offering of stock.

ROBERT HALF CPA RAMONA TIRE AND TIRE SERVICES– HEMET, CA

Interim temporary Controller work – March 2019 – April 2019 Accounting Project,

5 Daily internal reports using Excel macros, vlookup, pivot tables etc.

Set up all 7 key financial statements in Microsoft Great Plains report designer Management Reporter reducing work load of controller by 30%.

Daily bank reconciliation of cash for all 18 Ramona Tire stores.

Extensive closing journals and reports required to close the books for the month

Complete documentation in MS Word of controller duties for Ramona Tire.

ROBERT HALF CPA SPOT LIGHT 29 CASINO – INDIO, CA

Financial Analysis / Accounting Project, 04/18 to 03/19 project work.

Streamline closing entries for financial statements.

Work preparing in Excel the 2019 budget with 42 background reports by 2019 month. All the vlookup work and accounting analysis required to prepare the budget.

Streamlined and simplified detailed tracking of Fixed Asset project completion and transmission using MS Access and MS Excel.

Extensive use of Excel written coded macros to automate the production of the 20 departmental reports comparing casino revenue $ & stats with payroll $ and hours. Accounting and software background really made complicated project simple with easy to maintain Excel macros. Excellent teaching technique helped staff quickly pick up the maintenance of the project after 10/18.

Work with CFO and Director of Finance to create weekly report combining revenue data and statistics with labor hours, wages by position.

RIVER ROCK ENTERTAINMENT AUTHORITY – GEYSERVILLE, CA

Controller, November 2009 to September 2017

Key person in implementing change from People Soft to MS Dynamics Great Plains accounting system from Microsoft. MS system purchase cost 13 % of legacy system cost. 20% of legacy system maintenance cost.

Extensive work with our external auditors to answer all questions on financial statements.

Prepare all major wires for CFO confirmation at Bank of the West

Timely completion of the financial statements 10K/10Q

Supervise G/L, A/P and Payroll and revenue audit staff and all related functions.

Extensive MS Access and Excel work to produce 10K financial format and internal format

Managed staff and promoted a relaxed, respectful and productive team atmosphere in all staff supervised.

Timely work on bank reconciliation, bank wires and ach transfers at Bank of the West

Produced full financial statements in MS Access to enhance People Soft reports. This includes A/P and Payroll complete detail.

Multi- tasking controller that is not afraid to get hands dirty who pulls data for audit requests with queries and doc search saving A/P and payroll staff the stress of the audit.

FANTASY SPRINGS RESORTS CASINO–Indio, CA

Controller, May 2006 to November 2009

Timely completion of the 10K, 10Q, internal financial statements within seven working days.

Promoted a relaxed, respectful and productive team atmosphere in all staff supervised.

Prepare financial statements and footnotes for external audits and quarterly reviews.

Responsible for reviewing all balance sheet accounts before close of books within seven working days. Includes cash accounts, receivables, prepaid expenses, fixed assets, accounts payable, accrued expenses, note payable and equity accounts.

Timely monthly revenue reconciliation of all revenue accounts to detailed reports in micros system (F & B etc), Opera (Hotel System) and ACSC (Gaming Accounting systems). Revenue accounts include Bingo, table games, slot revenue, OTB, 12 Food & Beverage outlets, Golf and Golf Pro shop, Gift Shop, Bowling Alley and Pro Shop.

Timely completion of Microsoft Access monthly payroll report by end of the month showing complete detail of payroll hours, rate and amount by department, G/L account and employee name and all types of payroll (Exempt, non-exempt, overtime, PTO). Timely reconciliation of all Fixed Asset account detail. Sage FAS system was created and maintained by myself from May 2002 on.

Responsible for supervision of accounting departments along with soft count, hotel and revenue accounting in prior years About 40 employees.

CABAZON BAND O F MISSION INDIANS–Indio, CA

Software Engineer /Financial Analyst /Accounting Manager May 2002- May 2006

All cost accounting required to close books for Rubber recycling plant.

Timely completion of all financial statements, budgets and financials analysis schedules.

My efficiencies reduced the accounting staff from 2 full time contractors and 7 staff to 1 staff member.

During my tenure, I also prepared the Fantasy Springs Casino financial statement in Timeline (financial reporting tool) for 2005 on and checked for major errors as well as completing the Fantasy Springs Casino fiscal 2005 audit.

ONE INC/SPHERION CORPORATION-Santa Monica/Irvine, CA

Software Engineer /Financial/ Accounting Software design and implementation, February 2000 to January 2002

Key Accomplishments:

Designed and wrote accounting software components to transfer billions of loans each day for client Federal Loan Home Bank.

Helped design and write the One Inc. Hilton Hotel Financial Web application for all Hilton hotels saving Hilton millions of dollar cost in hotel staffing.

Designed and implemented daily on line budget reports for all managers of Big Store.com Internet Company allowing them to make the decision to cut back unprofitable market segments saving millions of dollars in lost profits.

TOTAL BENEFIT SERVICES\ALCONE MARKETING GROUP\NATIONAL WATER & POWER, Santa Ana/Irvine, CA

Software Engineer /Financial Software Designer, January 1994 to February 2000

Key Accomplishments:

Designed and wrote an accounting system which eliminated 32 staff positions saving National Water & Power (NWP) over a million dollars cost per year and helping NWP stay in business and survive.

Maintained and created state of the art marketing software at Alcone Marketing for clients Burger King, Shimano Fishing, Cal State Lottery, ASL Engineering and Soft-Train.

Certification and Education

California Certified Public Accountant (CPA), Current License #93817, 12/2005

Juris Doctor of Law, Northwestern California University School of Law Jan 2019

Master of Business Administration, California State University Dominguez Hills 2013 and California State University, San Bernardino a total of 20 MBA courses were taken to fulfill requirements GPA 3.87

Bachelor of Science in Electrical Engineering, California State University, Long Beach, 1987

Bachelor of Science in Computer Science, California State University Dominguez Hills, 1984

Bachelor of Science in Business (Accounting), University of Nevada at Las Vegas, 1981



Contact this candidate