Jimmie Garza

Web content Writer and Voice artist
  • Australia
  • 4.4 Star DigitalHub Rating
  • 2 DigitalHub Badges

Career Summary

I have excellent skills in both formal and creative English writing. My extensive experience in fields of business as disparate as aviation and medical imaging enables me to write compelling, persuasive copy on a wide variety of topics. I currently work as a radio presenter at Fine Music FM. I am available for work that will apply my writing and communication skills and my experience as a radio presenter, manager and script-writer to worthwhile, engaging tasks. I ran a successful aviation consultancy from 1980-2000. The Air Charter business gave me experience of: • Writing promotional literature, news articles, “advertorials”, etc. • Drafting, often at very short notice, contractual arrangements to reflect the wide variety of industries served by the aircraft charter industry. • Communicating effectively with non English-speakers. • International trade and project management. • Improvising solutions to operational problems under great pressure. • Performing rapid cost-assessments of charter tasks, enabling cusJimmieers to respond rapidly to emerging business opportunities. • Writing ad hoc spreadsheets to model transient business opportunities. • Compliance with legislative requirements for the operation of aircraft, transport of live animals, and other applicable regulatory regimes. • Operating in a very stressful, 24-hour environment, using costly capital assets, where large sums of money may be lost with a simple delay. • Design of special crates and loading devices for expeditious, humane and safe loading and carriage of livestock on aircraft. • Communicating with non English-speakers.

Work Experience

Weekly accounting and bookkeeping (QuickBooks)

We're looking for certified QuickBooks online advisor to maintain our books. 2x per week entries. (Import invoices, match payments, assign categories to expenses from linked in accounts, etc Attach receipt copies to transactions Weekly payroll cost import and bank reconciliations (payroll is outsourced) Weekly aging report Monthly reconciliation and statement send AP/AR Other QuickBooks, bookkeeping tasks 1-2 hrs per week Individual must be o...

Technologies used:

  • Accounting
  • Accounts Payable Management
  • Accounts Receivable Management
  • Bank Reconciliation
  • Bookkeeping
  • Data Entry
  • Financial Accounting
  • Financial Analysis
  • Intuit QuickBooks
  • Microsoft Excel
  • Tax Preparation

Need to create 2017 profit and loss statement using only 1 bank account (3 statements)

I need to create a year-to-date-2017 profit and loss statement using only 1 bank account (3 statements). My business is not active. There has been no profit, and the business is not active, so work should be minimal. Would appreciate if a CPA can create the statement with minimal charges, as I'm tight on budget. We will certainly appreciate the gesture when the business turns around.

Technologies used:

  • Account Management
  • Accounting
  • Bank Reconciliation
  • Bookkeeping
  • Certified Public Accountant (CPA)
  • Financial Reporting
  • Microsoft Excel

Looking for admin support

Looking for admin support with drafting emails, appointments, some word documents, occasional website updates etc.

Technologies used:

  • Administrative Support
  • Content Writing
  • Email Handling
  • Microsoft Excel
  • Virtual Assistant

Fix Excel macro - use named ranges to reference workbook and worksheet names

I have a macro that copies all the monthly data from head office into my workbook, pivots it, and then makes PDF files of summary charts for all sales staff. I need it to be more flexible and generic so that any office can use it. Head Office gives each local office a data file that has a unique file name matching the local office name. I want to enter the file names of the workbooks and worksheets into my workbook and have the macro use that i...

Technologies used:

  • Excel VBA
  • Microsoft Excel

Investment Bank List

PROJECT DESCRIPTION: Background: I work for a firm that invests in companies, and we have a list of investment banks (they basically help firms like mine buy and sell companies). We're hoping to identify which investment banks in our list work with the same kinds of companies we do: companies in the higher education sector (i.e. not high school but colleges, graduate schools, medical schools, and alternatives to college like coding bootcamps). ...

Technologies used:

  • Data Entry
  • Internet Research
  • Microsoft Excel

Sales data KPI Dashboard

Looking to get a dashboard created to track and manage sales KPIs. Would like dashboard to have filter for daily, weekly, monthly, quarterly, and annual views. KPIs we are tracking are: Total Sales, Total Gross, Gross % Sales, Selling Gross % Gross, Net to Gross, Total Inventory Value, and ROI. Would also need to have a view that will show comparison of current period to same period of last year. For example, if we are looking at daily view, ...

Technologies used:

  • Data Visualization
  • Microsoft Excel

MS Excel monthly cash flow forecast model including income statement balance sheet and cas...

Monthly cash flow forecast model. Needs to work off of monthly historic GL numbers for BS and IS. Numbers will be provided in Excel. Historic numbers from 2015 to April 2017 forecast monthly through Dec 2018 and annually for 3 additional years. Need to provide for typical assumptions/levers Sales Growth, COGS%, Labor Cost % (or labor $ / case) Overhead %, etc G&A expenses off of current Jan-April 2017 actual with lever for inflation assu...

Technologies used:

  • Budgeting & Forecasting
  • Business Modeling
  • Financial Forecasting
  • Financial Modeling
  • Microsoft Excel

Remove duplicates from Excel spreadsheet

Remove duplicate lines from excel spreadsheets (2).

Technologies used:

  • Microsoft Excel

Contact information required for Europe Companies

I have a list of companies based out of Europe with their domain names and company names. I need someone to use tools like Email Hunter, LinkedIn & Web research to find contacts within the marketing department. We are looking for titles like Director of Marketing Vice President Tourism Social Media Manager President & CEO Digital Marketing Director of Tourism Digital Marketing Manager Content Marketing Marketing Manager W...

Technologies used:

  • Data Entry
  • Internet Research
  • Lead Generation
  • Market Research
  • Microsoft Excel

Revamp of Corporate Presentation

Looking to revamp a company presentation for an auto component company. Currently there are 30 slides. We are mainly looking for re-organisation and professional look for the slides. We prefer simple, elegant presentations. To be done on powerpoint. My guess 6-8 hours of work plus 2 hours post a review. Post this, we will send updates and pay per hour for changes in the future. Please provide sample corporate presentations and price for the r...

Technologies used:

  • Design Thinking
  • Graphic Design
  • Microsoft PowerPoint
  • Presentation Design
  • Presentations
  • Sales Presentations

Skills

  • Microsoft Word
  • MailChimp
  • Microsoft Excel
  • Microsoft PowerPoint
  • Microsoft Project

Badges

  • (1) Trustworthy
  • (2) Innovative