Juan A. Beis Pachiarotti Email & Phone Number

Auckland, New Zealand

Auckland, New Zealand

• Responsible for automating Financial reporting duties and controls, Warehousing reporting and trust accounting• Supervise a team of 4 that reconciles more than 2m transactions per month on P2P lending and warehouse investment.• Warehousing investments and securitized portfolios reporting and performance analysis ($750m in investments)• Currently automating financial controls with SQL, Snowflake, VBA, Gsheet scripts, PowerQuery and Tableau.• Play a significant role in Controls Audit, financial audit (PwC), AUP audit, AFS, APRA reporting, creation of financial statements to publish in ASX, reports to our Audit Committee and top management, and debt sale process.

Phoenix, Arizona, United States

- Programmed in SAS and SQL logics for handling complex tax and financial reporting deliverables. - Managed large data sets of private employment records and figures for top high paying executives and employees. - Managed monthly reporting tasks and daily communication for several publicly traded companies. - Assisted in projects for Fortune 100 clients in relation to financial reporting for stock compensation. - Designed and implemented client-specific stock-based compensation accounting solutions for Stock Option plans, Performance awards, TSR (total shareholder return) awards, Restricted stock units/awards and ESPP (employee stock purchase plans). - Performed accounting reports for Tax, EPS, Forecast of Expense and DTA on a monthly basis. - Worked on projects for US GAAP and IFRS clients. - Implemented complicated projects that required a comprehensive understanding of data structure and equity compensation accounting. - Automated and streamlined client processes that shortened the turnaround time as well as reduced risk. - Developed SAS macros that accelerated the accounting process significantly. Equity Methods is the international leader in equity compensation compliance solutions and valuation services with over 35 of the Fortune 100 as clientele along with many more in the Fortune 500 and beyond. As a company, Equity Methods provides services to finance, accounting, and human resources managers in the areas of equity award valuation, financial reporting (including tax), and plan design.

Ogden, Utah, United States

• Created Budget Reports for the entire City in SQL Server Reporting Services (SSRS) by viewing SAP Crystal Reports and reviewing the SQL database• Executed internal controls and reports over budget and funds projections with Excel VBA macros• Led the design, implementation and training of changes in Accounts Payable accounting procedures• Reduced GASB accounting recording time and control by 30% with Excel VBA macros• Performed internal audits on Comptrollers and Purchasing processes (found & closed +$1.5M of unused POs) • Mapped city’s purchasing and accounting processes for a technical guide (150+ activities)Performed professional accounting activities using GASB standards. Assisted in the preparation of monthly fiscal reports and special reports relating to the progress of assigned accounts. Participated in the compilation and preparation of the City's annual budget; prepared cash flow and expenditure projects. Assisted in the preparation of the City's Comprehensive Annual Financial Report (CAFR). Prepared annual financial reports for City departments with statistical financial reports. Reviewed the accounting database and updated it with accurate financial records. Designed and produced various budget-related forecasts and reports. Maintained and reconciled a variety of ledgers, reports, and account records; examined and corrected accounting transactions to ensure accuracy. Prepared and posted journal entries to record revenues, transfers, payments, and correct expenditures.

South Jordan, Utah, United States

Joint Venture Accountant – Managed Rio reporting for Turquoise Hill (64% owner of Oyu Tolgoi $14B mine)• Consolidated Turquoise Hill (US GAAP) and Oyu Tolgoi (IFRS) financials for Rio Tinto London Controllers• Recorded corporate deferred Tax (DTA/DTL) adjustments for TRQ/RT Consolidation.• Reduced IFRS HFM (Hyperion-Oracle) reporting timeframe from 7 to 2 days (70% improvement)• Replaced Turquoise Hill management tools and enhanced timing and accuracy of management reports • Assisted in the reporting transition on several Rio Tinto entities with SAP. Produced audit paperwork for PwC audits.• Recorded corporate deferred tax adjustments for TRQ/RT Consolidation.• Produced validation controls for Controllers’ reporting and was asked to train Rio employees• Controlled technical issues on investment accounting on South Gobi mine (23% ownership)• Monitored and updated the TRQ&OT Rio reporting internal control in order to improve SOX complianceFinancial Accounting & Management Reporting, Forecast and Planning, Compliance and External Reporting, Joint Venture Accounting & Reporting, Corporate Tax analysis, Risk Management, Cost Accounting & Management, Reconciliation of the Quarterly Operations Results information and explanation of results. In relation to Rio Tinto JV projects with Turquoise Hill Company and Oyu Tolgoi LLC.Hired as a contractor via PrincePerelson.

Montevideo - Uruguay

Financial Analyst – Managed reporting and financial analysis for Marel Controllers• Managed and coordinated the monthly schedule of a finance team of 4 analysts• Reduced 25% of the time spent in FX adjustments of financials for 5 currencies (Pesos, USD, GBP, EUR, R$)• Standardized daily bookkeeping, financial analysis and internal controls• Performed quarterly consolidation of 3 entities for international reporting in Hyperion (HFM - Oracle)Daily accounting duties for 3 companiesPrepare profit and loss statements, monthly Balance Sheet and cost accounting reportsCompile and analyze financial information in the European accounting (similar to US accounting)Establish, maintain, and coordinate the implementation of accounting and accounting control procedures.Monitor and review accounting and related system reports for accuracy and completeness.Prepare and analyze the budget, revenue, expense, payroll entries, invoices, and other accounting documents.Explain billing invoices and accounting policies to staff, vendors and clients. AP & AR agent.Interact with internal and external auditors in completing audits.Software developer in VBA

Montevideo - Uruguay

Accounting Specialist – Managed and controlled the bank check clearing housing accounting• Controlled the accounting performed by 22 employees in the check clearing house• Eliminated 2 full-time positions by restructuration and automatizing accounting controls • Diagnosed and solved more than $3M in internal check deposits discrepancies• Reconciled interbank accounts with other banks ($45M daily in transactions)Bank accounting duties (Post journal entries, Prepare daily books and records, etc)Check clearing housing accounting reportsConciliation of accounts between BanksFusion accounting adjustments between Santander and ABN AMRO BankResolve accounting discrepancies in the Santander’s Accounting BooksSoftware developer in VBA for the accounting department

Master'S Degree, Accounting, 3.89 / 4.0

Bachelor’S Degree, Accounting, 3.95 / 4.0

Activities and Societies: Phi-Kappa-Phi

Associate’S Degree, Accounting, 3.96 / 4.0