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.

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.

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.

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.

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.

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.

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