Local to Houston, TX *****; Available Immediately
Prefers Interviews with 24-48 hrs notice
Flexible to work remotely
Supplier Notes: Lee is a CPA certified having 12+ years of experience in Energy-related companies with 1/3 in derivatives, 1/3 in full-cycle accounting, and 1/3 with FPA. He has recent working experience in SAP, PeopleSoft, Openlink, and CXL trading systems. Researched and implemented complex FAS 133 derivative accounting issues including ineffectiveness, hedge accounting, and proper accounting treatments; conducted monthly analysis of MTM P&L and balance sheet for Gas, Power, and Emissions.
M.B.A. - Finance and Accounting from Rice University, Jesse H. Jones Graduate School of Administration, Houston, Texas, 1991-1993
B.S. - magna cum laude; Phi Kappa Phi, Accounting from University of Houston-Clear Lake, Houston, Texas 1987-1989
Ernst & Young, Houston, TX(Left to attend Rice MBA program), 1989-1991
CPA and CFA
IT and Key Skills
NetSuite or similar ERP, Peoplesoft, Open Link, PowerBI. Excel, Discounted Cash Flow model, (Pivot table, lookups, Index Match, Macros, Basic VBA), SAP, Access
Other Skills: Able to read, write, and speak fluently in English, Mandarin, and Taiwanese, Toastmaster member.
Reliance, Contracting, Houston, TX Nov 2022 to Feb 2023
Senior Accountant-Mid office
Update forward curve and support trading desk on an as-needed basis relating to price quotes, calculation of tank mark and tracking of physical inventory.
Manage reconciliations and analyses of complex accounting functions, which may include inventory, cost accounting and accruals.
Support credit team with daily updates of Finance clearance working with the operation for the physical moment of crude commodity and prepare daily pnl on realized and unrealized profitability and MTM accounting on the refined product.
Assist with the preparation of the year-end audit and work closely with the audit team to provide an accurate supporting schedule.
Working with IT in India to support CXL/Endur trading system working with price quotes and forward curves and TAS.
Intertek, Houston, TX July 2020 to Aug 2022
Senior Business Analyst
Support month-end close process and financial statement preparation.
Prepare journal entries, balance sheet reconciliations and relevant supporting schedules.
Recover over $85k of vendor charges by working closely with legal, AP, and operations on charges initially deem unrecoverable.
Lead bi-weekly meetings with operations and branches in the accrual process, disputed invoiced, and bad debt in achieving over 80% invoicing vs accrual.
Support the development, implementation and testing of controls and processes across the organization, internal audit, accounting, and lease accounting, and prepare schedules for audits and coordinate prepared by client schedule by acting as liaison to the branches (FPA function)
Key contributor of the Full accounting Cycle close by streamlining and developing the template for ease of accrual calculation of run rate for utility charges and gain 50% timesaving. Automate Excel charts update by taking a four-hour manual process down to two- hours with the use of VBA code and macros.
Tax sessions concluded and looking for new roles Apr 2020 to June 2020
Intuit Jan 2020 to Mar 2020
Support customers by answering 1040 tax return questions. Rank 6 out of 50 in terms of performance. Provide above and beyond customer service in answering individual tax return questions.
HISD July 2019 to Oct 2019
Prepare and compile budget for 57 schools within Houston Independent school District by working with school Principals. Perform special cost analysis of school and special projects on as needed basis. Provide analysis of forecast for school expenses and allocations of school related costs.
Oxy Jan 2019 to Mar 2019
Sr. Financial Analyst
Fair value Accounting for Natural Gas and NGL commodity for daily accounting transactions.
Responsible for Full cycle accounting close by preparing and reviewing journal entries
Prepare account reconciliation of Risk management accounts on timely basis
Maintain Excel models of risk management accounts and related financial analysis
Shell Sept 2018 to Nov 2018
Working on derivatives and technical accounting relating to trading
Research new trades type related accounting treatments and pronoucements
Write accounting memo on technical trading accounting issues
Life Energy Aug 2017 to Aug 2018
Full Cycle accounting close, Derivative and balance sheet account reconcilations
Working with financial statements and notes for LifeEnergy 2017 annual financial statements
Prepare forecast and budgets of retail power sales and costs
Validate sale commission reasonableness and perform variance flux analysis of revenue and cost drivers.
Looking for new roles Mar 2017 to July 2017
Repsol Aug 2016 to Feb 2017
Full cycle accounting close, Derivative, working with crude commodity.
Prepare daily cash management of derivative accounts
Prepare month end close MTM accounting entries
Prepare balance sheet account reconciliation after close
BP, Houston, TX Mar 2011 – June 2016
Planning and Performance Analyst
Provide performance and planning analysis for BP Solar and BP GCRO by leading and facilitating Quarterly Performance Reviews by monitoring actual performance versus forecast, identifying key business drivers, and providing detailed explanations.
Led, influenced, and manage relationships by coordinating 6+ staff to successfully deliver GCRO and Finance Entity Plan.
Compile and analyze financial data for net margin calculation and reporting involving working on allocations.
Analyze competitors by retrieving data from the financial engine from CIQ by utilizing power points and charting and gathering analyst comments and outlooks for various solar companies.
Provide support for the compilation of financial forecasts relating to the management of BP trust relating to the 2010 Deepwater, Horizon accident.
Dynegy Inc., Houston, TX March 2006 – Feb 2011
Senior Commercial Analyst
Took the lead role in streamlining and organizing departmental processes by working with IT and selected to train others for better utilization of Excel and Access; recognized as a go-to person for Excel.
Analyzed and reported weekly market trends and pricing for power generation and natural gas for top executive management by obtaining an understanding of market conditions, fundamentals, and risk exposures.
Performed special analysis to meet the needs of traders, risk control reporting, asset management, planning, and investor relations.
Calculated and presented results relating to In-Market Availability of power plant generation and worked with various complex financial models (Endur) to capture plant performance and benchmarks.
Worked with plant operational accounting group in answering operational results and performance activities relating to pricing.
Researched and implemented complex FAS 133 derivative accounting issues including ineffectiveness, hedge accounting, and proper accounting treatments; conducted monthly analysis of MTM P&L and balance sheet for Gas, Power, and Emissions.
Acted as an accounting liaison to trading/commercial, risks control reporting, credit and Treasury.
Achieved significant process improvement resulting in one day saved in preparation of consolidation of Risk management roll- Forward, MTM P&L by month and balance sheet analysis.