ExterranSr. Financial/Business & Market Intelligence Analyst
May. 2007 - Jan. 2012Houston, Texas AreaAnalyzed external and internal data to assess the markets for business units and ensured market data was provided to North America president. Produced insightful research, reports, and updates on industry trends. Managed the creation, automation, and maintenance of weekly, monthly, and quarterly reports and other key performance indicators to management by creating complex spreadsheets and turned them into visually enhancing dashboards and reports. Prepared oil and gas market research, e.g. production, consumption, storage, etc. Assisted with monthly close by reviewing activity to ensure consistent reporting, including analysis of activity to current plan detail to ensure completeness of financial information. Performed extensive financial statement analysis including balance sheet and divisional profit and loss statements by tracking, researching and resolving significant fluctuations or other business issues. Compiled and prepared monthly/annual plan. Partnered with accounting and other groups to assure the accuracy and consistency of system data, and provided accounting and transaction process guidance. Worked with fixed asset group to prepare, analyze and project capital expenditures on an entity and company-wide basis. Compiled various financial results on a project by project basis including comparison to original project economics. Assisted with preparation and distribution of monthly/year-to-date actual to plan variances and explanations including detail analysis as needed. Interpreted trends, drew conclusions and prepared reports including sound recommendations. Analyzed non-financial operating statistics and correlated variances to the relating financial items. Recommended and implemented system and process improvements. Prepared and presented quarterly results, periodic budgets, forecasts, sector outlooks, cash flow projections and other ad hoc reports and analyses to CFO and Core Team.