Business & Financial Modules in Excel and Power BI
"Dov is simply exceptional!! Furthermore he is very accessible and a delightful person to work with. He consistently delivers!! More specifically, he prepared detailed 10-year financial projections (cash flow, balance sheet and income statement), on a monthly and annual basis. Useful sensitivity analysis was also prepared. I have worked w/ Dov on a variety of projects--aquaculture farms (very complicated model); geothermal electric plant and telecom operation. He was "on point" for each of these projects!!!."
- Camille C.
I am a financial expert, a guru in Excel, VBA, and Power BI. I have extensive knowledge and expertise in extract, transform, load (ETL), advanced formulas, pivot tablesincluding preparation of graphical and visualisation reports, dynamic dashboards, and charts (by VBscript). Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic & designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.
What do I love to do?
- Modules in Excel: financial projections, inventory, financial reports, Extract & Cleaning
- Accounting, Consolidation & reconciliation
- Databases in Excel by algorithms, VBA/Macro and Pivot Tables
- Database manipulation and population reporting
* CFO, Chief Accountant, a specialist in managing cash flow and liquidity solutions for the multi-currency environment and globally including collections, payments, inventory, and taxation.
* Extensive experience in corporate information concisely effective management reporting, budget control, and costing reports Financial Statements.
* Expert in Microsoft Excel and VBA programming.
* Developing of consolidated financial statements, financial plans.
* Budget Development & Management
Chief Financial officer
Far East Land Bridge Ltd.
Jan 2007 - Aug 2013 (6 years, 7 months)
• Managing of daily LT/ST financial planning
• Managing of all aspects of daily finance, accounting, and treasury operations
• Individual treatment of the significant customers and suppliers
• Preparation of the business plan, cash flow and the budget
• Assist management in analysing cash requirements and related financing needs according to the strategic and operational targets
• Review / analyse business flow and related
Chief accountant, Financial Reporting Manager
Venture Capital Firm
Jan 1996 - Dec 2005 (9 years, 11 months)
• Managed the reporting requirements, processes, and procedures for the valuation of the portfolio and the capital
• Provided input into business rationalization plans in order to reduce cash burn of the portfolio
• Designed the finance system infrastructure to assure accurate and timely data extraction and report submission
• Managed the IT department to keep the flow of the
BA and MBA
University of Derby, United Kingdom 1999 - 2006
University of Derby
Contact Dov Goldenberg about your job
Log in to discuss any details over chat.
US English 1 95% Preferred Freelancer Program SLA 1 94% Data Entry 1 80%