Robert Sherlock Email & Phone Number

Conroe, Tx, Us

Houston, Texas, Us

Detailed written references available on request); Support implementation/roll-out of Microsoft Dynamics NAV system for the organizations in the Oil & Gas and Construction industries. Devise and test reports and customizations in Dynamics NAV.Onsite and Remote training and UAT assistance.Write User Guides and UAT documentation.Create and setup new companies within the database including chart of accounts, posting groups, security and settings.Validate and import GL transactions, customers, vendors, contacts and other data tables.On-site review including Implementation Assessments of client business processes and requirements.

Provide accounting and analytical support for the construction of a major processing plant. Prepare using Management Reporter monthly management reports, budgets and forecasts to assist the CEO, CFO and other management with timely and well-presented information.Export data from Microsoft Dynamics AX to use in further manipulation and reporting.Assist treasury and created detailed Cash flow spreadsheets to enable close monitoring of revenues, expenses and capital expenditure. Using Excel to develop custom pivot tables, graphs and spreadsheets to assist with forecasting, budgeting and analysis of business units. Review international sales, equipment purchases, transportation contracts and procedure documentation.Conduct internal audit reviews and recommend internal control improvements.

Project manage the implementation of a new business analysis tool (Cognos TM1), including validation and reconciliation of outputs using excel. Design, develop and test an automatic reporting system that streamlines data transfers from Dynamics NAV.Analyze existing reports, systems and procedures to integrate new reporting system and new office into the organization, and confirm that the company all is meeting all quality control requirements.Develop reports to best report distribution costs and inventory levels.

Reviewing and analysis of the financial implications of contracts, projects and asset purchases. Prepare management reports, financial statements, budgets, cash flows and forecasts to assist in funding the development of real estate interests and expansion projects. On-site supervision and training of staff in multiple locations.Walk through with site management to review costs and determine any CAPEX requirements. Accounting and management of revenues, expenses (including payroll) and fixed assets. Preparation of consolidated tax return (including depreciation) and US GAAP Financials.Implement business plans to successfully grow and expand into multiple locations.

Preparation of the monthly, quarterly and annual accounts for the Anvil group and its subsidiaries in accordance with Canadian GAAP in US Dollars. Consolidation of international companies and the preparation of their taxation and financial compliance records and returns required in Australia and Canada. Review of African plant and mine operations including commodity stockpiles, chemical testing results before and after shipping and report any unforeseen variances. Assisting Company Secretary with annual report, IPO, meetings and other compliance issues Dealing with audit, exchange (ASX and TSX) and statutory requirements. Providing statistics, budgets and reports for management and corporate offices Use of Excel based IBM Cognos TM1 data cube for storage and retrieval of financial and non-financial information and viability of available projects.Assist in the collation of information for the monthly report for African mine and plant operations and distribute these as needed throughout all business sectors. Responsible for parent company as well as North American accounts involving the process of journals, creation and running of reports in the Pronto (ERP) accounting software environment.Providing statistics, budgets and reports for management and corporate offices Review and authorize multi-currency banking payments and transfers. Liaising with Auditors in relation to external audit both in Australia and Canada.

Monthly Joint Venture Management reports and multi currency Financial Statements and forecasts Reviewing joint venture data on commodity stock piles and shipping times Accounted for Revenues and Expenses of a Joint Venture Natural Gas Power Plant.Review tested commodity weight and chemical breakdown before and after shipping to confirm that sampling and measuring is conducted correctly. Daily cash management and associated cash flow forecasting and budgeting based on shipping forecasts, and energy sales.Treasury functions for the partnerships including receipt and conversion of US$ denominated sales proceeds plus Partners cash distributions and cash calls. Coordination of IT services with associated company in Sydney, Australia. Analysis of financial and non-financial information using Excel to include in the monthly management reports. Liaising with external auditors in regard to financial reports and other audit requirements. Preparation of company taxation and GST (sales tax) returns.

Producing consolidated financial statements for Australian Stock Exchange. Preparation of management reports and budgets for production plant in Asia. Preparing for and assisting with external audit. Account for the various projects and fixed assets internationally.

Varied accounting positions for two CPA public practice firms.

Cpa Australia

Bachelor Of Commerce, Accounting And Finance