Post Job Free

Resume

Sign in

Sap Finance Controller

Location:
Spring, TX, 77388
Posted:
October 21, 2020

Contact this candidate

Resume:

Gustavo Guevara

adg6lx@r.postjobfree.com

832-***-**** (cell phone)

832-***-**** (home)

Personal Details:

Date of Birth: August 1st, 1974.

Nationality: Venezuelan

Marital Status: Married

PROFESSIONAL EXPERIENCE

Conkor USA LLC, Houston, Tx.

Company Controller and SAP Implementation Leader

Major Duties and Responsibilities as SAP Implementation Leader:

Assists with the qualification of opportunities provided by the Company / account teams

Assists with defining scope, determining resource requirements and timeframes for delivery.

Assess risk and determine mitigation strategies.

Managing project financials including P&L

Manages project to meet or exceeds approved project budgets

Provides leadership to project team by setting direction and priorities for the project

Mentors and encourages skill development of project team members

Provides performance and development reviews for team members

Presents project status and forecast to Company Directors

Approve all Configuration of the core modules:

o Purchasing –MM

o Inventory Management – MM

o FI Module including: AR, AP, G/L, Fixed Assets

o SD – Sales Distribution

o Controlling

o Project Service

Major Duties and Responsibilities as Company Controller:

Manages business development and new business opportunities

Monitoring of Accounts Receivable aging Report and Collecting

Prepare and Control Company Branch Budget

Prepare Financial Statements Reports, Including Revenues, COGS, and Expenses & FOP and Balance Sheet Commented for monthly variances.

Review and Post Exchange Rate Differences at the End of the Month in USGAAP bases

(FASB 52).

Identify development opportunities consistent with the aims of the organization and the operating environment.

Review and Approve monthly Accruals and Provisions

Prepare and review Company Cash Flow

Analysis and decision maker on Bank Loans

Review and Update Company Policies and Finance Procedures

Persue and finding of any potencial Fraud.

Deal and Assist External Audits.

Develop Bank Relationship and Assist in formulating the company's future direction and supporting tactical initiatives

Monitor and direct the implementation of strategic business plans

Develop financial and tax strategies

Manage the capital request and budgeting processes

Develop performance measures that support the company's strategic direction

Assist in formulating the company's future direction and supporting tactical initiatives

Monitor and direct the implementation of strategic business plans

Develop financial and tax strategies

Manage the capital request and budgeting processes

Develop performance measures that support the company's strategic direction

Assist in formulating the company's future direction and supporting tactical initiatives

Monitor and direct the implementation of strategic business plans

Develop financial and tax strategies

Manage the capital request and budgeting processes

Develop performance measures that support the company's strategic direction Weatherford Latin America

Weatherford Trinidad and Tobago and RIGS Division

Finance and Administrator Manager January 2010 – June 2011

Manage and Control Inventory and Fixed Assets Financial Operation

Monitoring of Accounts Receivable aging Report and Collecting

Prepare and Control Company Branch Budget

Prepare Financial Statements Reports, Including Revenues, COGS, and Expenses & FOP and Balance Sheet Commented for monthly variances.

Review and Post Exchange Rate Differences at the End of the Month in USGAAP bases

(FASB 52).

Identify development opportunities consistent with the aims of the organization and the operating environment.

Review and Approve monthly Accruals and Provisions

Quarterly and monthly Budget Review versus actual.

Complete End of the Month Reporting in Hyperion according with Company Corporate Schedule. Prepare Journal entries in HFM to correct variances in all different modules: Inventories, Fixed Assets, A/R, A/P, Unbilled Accounts, Revenues and Expenses.

Financial Reports issue in Smartview for variance analysis and reconciliations.

Checking and reviewing of Intercompany Transactions, including Unbilled Accounts, Assets and Inventory Transfers.

Review Inventory Provisions for Slow Moving, Obsolete and Lower Price Market.

Monitor and ensure accountability for financial performance, processes, and policies.

Ensure that assets, liabilities, revenues, and expenses for responsibility area are accurately reported and accounted.

Ensure that budgets and financial performance are in accordance with business strategic initiatives.

Lead and Manage External and Internal Audit for Venezuela and Trinidad & Tobago Operation, including:

o Coordinate the completeness of all Audit Requirements from Different areas of the Company: Revenues, COGS, Inventory, Fixed Assets, and Accounts Payables, accounts Receivables, Intercompany, Payroll, and Exchange Rate Differences. o Suggesting improvement of audits, including but not limited to automated auditing and control self assessments

o Prepare Analysis in order to satisfy Audits requirements o Perform follow-up activities with management to ensure the timely resolution of internal control and operational maturity deficiencies. o Investigated handling of various transactions and accounts to bring out inefficiencies and fraudulent activities

Weatherford Latin America – Puerto La Cruz, Venezuela JDE Implementation Leader September 2008 – December 2009

Manage project activities in conjunction with JDE Region Project Manager

Manage Operations Team members (Super Users) for task assignments

Set strategies and Plan to coordinate all activities related to Classification of Inventories.

Set up Business Units mapping with Legacy Systems Accounts.

Logistic for all activities related to the Implementation Project like: Design Sessions, Super Users Training, CRP I & II, End Users.

Identify Data Owners and coordinate data validation activities

Monitor all Issues and Task to be completed related to all different modules implemented

Support all local operation and different product lines after GO LIVE SOX Analyst – Internal Control November 2007– September 2008

Special Project to reconcile the Fixed Assets and DD&A Accounts

Develop procedures and internal controls based on SOX methodology for the next business areas: Procurement – Supply Chain

Accounts Payables

Treasury

Sales and Cash Receipt

Inventory

Closing Process

Fixed Assets

Allowance

Payroll

Petrolera Zuata, Petrozuata – Puerto La Cruz, Venezuela

(Strategical Association between ConocoPhillips Inc. and Petroleos de Venezuela) September 1997 to October 2007

Capital Investment Budget Controller and Administrator (February 2007 – October 2007)

Support to Drilling, Reservoir, Construction and Engineering Departments.

Capital Budget execution and control.

Global operational and administrative consolidation reporting to top management level.

Budget control and handling. Budget execution for operation areas.

Control the execution of the Upstream Budgets for CAPEX ($155.1MM)

Coordinate and participate in the preparation of short and long term financial forecasts

Coordinate and participate in the Annual Business Plan processes.

Perform investment appraisal on new projects.

Analysis of variations between monthly Forecast versus Actual Inventory Accountant (Shared Service Division) (March 2005 – January 2007)

Designing of spreadsheets to calculate the extra heavy crude oil, naphtha, blend (extra heavy crude oil and naphtha), intermedial products and sub-products (heavy syncrude, light syncrude and gas oil) final inventories and volumetric reconciliation

Calculating and booking of extra heavy crude oil production cost and sub-products (light syncrude, heavy syncrude and gas oil); barrels of production per day: 120,000 Production

Calculating and booking of the extra heavy crude oil cost of goods sold and sub-products

(light syncrude, heavy syncrude and gas oil)

Reconcile Crude Oil Inventories for 36” and 24” Pipeline at the Month End Close.

Bill Usage of 24” & 36” Pipeline Services to Join Clients

Analyzing and calculating real cost of goods sold variance against forecast

Reconciling final inventory volume against SAP entries

Developing, updating and preparing procedures for inventory crude and materials valuations

Designing of SOX Matrix of Risk and Flowcharts for Inventory Crude and Materials processes for SOX Certification purposes

Leading and coordinating physical counts of inventory

Analyzing and booking of material price changes (SAP Material Ledger Module)

Reconciling and analyzing differences in materials physical counts

Performing and booking of materials price test (market price versus SAP materials average price)

Performing and booking of materials obsolescence and low movement provision

Booking of expenses for materials freight and duties

Analyzing the liability accounts (Good Receipts / Invoice Receipts Account) and booking adjustments for difference between Billed and Receipt.

Preparing inventory statistics for management

Calculating and booking of Materials Declared Surplus and loss provisions Resume for Gustavo Guevara

Page 2

Intercompany Coordinator (September 2003 – February 2005)

Designed and implemented a procedure for handling, booking, and approving all the intercompany charges

Designed a SAP report for all Expatriates assigned for United States and Venezuelan tax purposes

Booked payroll and reimbursable expenses

Reviewed and coded intercompany billing

Generated and reviewed reports for internal control purposes

Supported company controller by reviewing and updating all finance procedures; performed internal audit in the accounting department; and handled disbursement processes Corporate Accountant (February 2002 – September 2003)

Calculated and booked exchange rate gain and loss

Calculated, booked, and reconciled long and short term debt accounts

Consolidated financial statement for Petrozuata and affiliates

Book ing and reconciliation of significant variances analysis of Selling and Administrative Expresses Distribution.

Analyzed and reconciled intercompany accounts

Created and administered Company Master Accounts Inventory Accountant (January 2000 – January 2002)

Develop and issued procedures for inventory control, accounting, and periodic physical inventories

Reconciled inventory accounts for materials and crude ($141MM)

Developed and prepared monthly management reports regarding inventory levels, including an analysis of significant variances

Classify and book down-hole drilling equipment into capital and expense accounts

Planned, coordinated, and participated in periodic physical inventories in both company and third party warehouses

Calculated, analyzed, and accounted for monthly lifting costs Payments Coordinator (December 1998 – January 2000)

Analyzed and forecasted cash requirements associated with $2.1 billion extra heavy oil project and on-going operations

Posted all payment transactions in SAP

Reconciled VAT and withholding tax accounts

Prepared aging reports and analyzed unpaid items

Reconciled corporate bank accounts

Accounts Payable Analyst (January 1998 – December 1998)

Reviewed invoices to ensure compliance with Venezuelan tax law, confirmed existence of properly authorized purchase orders or contracts, and posted invoices into SAP accounting system

Reconciled withholding tax account

SAP Implementation Team (September 1997 – December 1997)

Implemented SAP as new operative system for accounting department

Reconciled assets, banking, tax and liability accounts from Legacy System to SAP system and input all initial balances for new SAP accounts

Booked and reconciled all the accounting operations during the transition period from Legacy System to SAP

Petroleos de Venezuela S.A., P.D.V.S.A. – Puerto La Cruz, Venezuela Accounts Payable Analyst January 1996 to September 1997

Reviewed invoices posted by accounts payable clerks

Ensured existence of vendor bank account data, proper accounting for withholding tax, and compliance with Venezuelan tax law

Followed up to ensure payments were made on all posted invoices

Reconciled corporate bank accounts and forecasted funding requirements Resume for Gustavo Guevara

Addendum

SKILLS

Computer Software: Microsoft Excel (advanced), Microsoft Word, Microsoft PowerPoint, SAP

(R/3 & 4.5 - certified)

Assigned as SAP Power User for Finance and Material Module Bilingual (Spanish/English) – read, write and speak TRAINING

SAP ( R/3 & 4.5 - Interprise)

710 Maintenance Notification

720 Maintenance Work Order.

300 Inventory / Warehouse Overview.

320 Warehouse Management

315 Inventory Management II (Physical Count)

SAP 251 External Services Management

SAP 1000 Cost Controlling

SAP 1010 Cost Master Data Maintenance

SAP 1020 Planning Processing and Revaluation

SAP 1030 Processing Settlement

SAP 1040 Cost Reporting

SAP 1070 IM Overview

SAP Material Ledger

SAP A/P and A/R Module

SAP D45FI Financial Accounting

SAP Automatic Payment Process

SAP PS and Project Management Overview

SAP Business Warehouse

ADDITIONAL TRAINING/SEMINARS:

Petroleum Fundamentals, University of Texas at Austin Division of Continuing Education.

Elementary Drilling, University of Texas at Austin Division of Continuing Education.

Oil and Gas Accounting, instruction provided by Conoco Inc.

The 7 Habits of Highly Effective People, instruction provided by Conoco Inc.

Target Development, instruction provided by Conoco Inc.

Duty Process for Oil Projects, instruction provided by Aduanera Transmundial.

Inflation Adjustment for Financial Statement, instruction provided by Espinheira Sheldon y Asociados.

International Accounting Principles, Deferred Taxes, instruction by Espinheira Sheldon y Asociados.

Process & Procedures Elaboration.

Time Management Course

Team Building

Withholding Tax Reconciliation

NIIF – NIC Updating and Application

Upgrading, Refination and Economy Seminary for Heavy and Extra Heavy Crude Oil by Baker Oil Tools.

SOX 2006 – Internal Audit

Updating of International Financial Information Rules (NIIFS - NIC) Spinheira Sheldon y Asociados

Leadership and Excellence: Key for a Service Organization Success

Budge Control and Formulation (IESA – Caracas)

Skills Training for Enterprise Excellence (Weatherford - Venezuela)

OSHA Certification Training (Conkor USA LLC – Houston, Tx, USA)



Contact this candidate