Andrea Johnson

Oakland, CA ***** adc9ib@r.postjobfree.com 510-***-****

Authorized to work in the US for any employee

Work Experience

Data Manager

Marin Alliance for Medical Marijuana - Fairfax, CA June 2017 to Present

Check in patients

Maintain patient information in Proteus 420 software

Enter and maintain inventory and sales data in Proteus 420

Maintain all data in state-mandated Metrc track-and-trace software

Manage links between Proteus 420 and Metrc

Create spreadsheets and other documents as needed for internal record-keeping

Create instructions for other staff to use for procedures, software, etc.

Financial Analyst

Chevron - San Ramon, CA September 2006 to June 2009

Developed monthly financial reports in Excel for multiple teams on a global IT project

Created and maintained Excel templates for team managers to develop their budgets

Developed pivot tables, charts, and other tools in Excel to analyze the data and make it more readily useful to the team managers

Trade Analyst

Chevron - San Ramon, CA July 2005 to September 2006

Pioneered a new position on the trading floor of Chevron's Fuel and Marine Marketing Division, which quickly became a critical part of the workflow

Developed an Excel template to ensure consistent entry of trade data

Developed a system in Excel for tracking open trades to assure timely processing

Created a detailed desk manual on all aspects of position

Analyst

University of California - Berkeley, CA January 2005 to June 2005

Worked on grant reconciliations for the Electronics Research Lab

Researched funds disbursed

Interacted with various academic and administrative individuals to resolve variances

Accounting Analyst

Pacific Gas & Electric - San Francisco, CA September 2001 to August 2004

Used Excel to prepare monthly financial reports to U.S. Bankruptcy Court

Prepared monthly variance analyses for internal reporting

Worked on Bankruptcy claims resolution team

Tax Analyst

Clorox - Oakland, CA June 2000 to July 2001

Prepared sales, use, and property tax returns

Assisted audits

Created online sales tax reference manual

Created resale certificate database

General Accountant

Liquid Sugars, Inc. - Emeryville, CA 1989 to 2001

Accounts Payable Accounts Receivable General Ledger Fixed Assets Accruals Reconciliations Consolidations Month-end Close Year-end Close Financial Reports

Sales and Use Tax Returns

Created spreadsheet systems to facilitate tax return preparation and other tasks Created a database to preserve legacy accounting data when the company changed accounting software

Acted as liaison between accounting department and IT Trained co-workers in the use of various software Wrote user manuals for various software

Skills

Microsoft Office, including Excel, Word, PowerPoint, and Access (10+ years)

SAP (3 years)

Data Analysis Skills (10+ years)

Data Management

Assessments

Social Media — Proficient - December 2019

Attention to Detail — Highly Proficient - December 2019

Creating Presentations with Microsoft PowerPoint — Highly Proficient - December 2019 Microsoft Word — Highly Proficient - December 2019

Logic & Critical Thinking — Proficient - December 2019 Problem Solving — Highly Proficient - December 2019 Research — Highly Proficient - December 2019

Data Analysis — Proficient - December 2019

Data Entry Clerk — Highly Proficient - December 2019 Spreadsheets with Microsoft Excel — Proficient - December 2019

Contact this candidate