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)