Hamid Hussain

• 303-***-**** • e mail:

*** ********* ****** *******, ** 77007

Functional Skills h acgsjp@r.postjobfree.com

Business Writing

•

Data Analysis

• Executive Profile

Analysis

•

• Ten years of business and financial analysis experience in domains including: Energy Trade and

Problem Solving

•

Risk Systems, Telecom, Asset Management and Financial Accounting.

• Energy Trading experience includes: trading & risk reporting, P&L reporting, position reporting,

Technical Skills

Value at Risk Reporting. Industry experience in physical commodities: Natural Gas, Power, LNG,

• Allegro

NGL, and Crude.

• Commodity XL

• ETRM system implementation and upgrade experience with Allegro, Commodity XL, Trade Pilot,

• Trade Pilot

RightAngle S11, Aligne Zainet, TRM, Gasops, Powerops, GMS, Entrade, Transenergy, Web

• Rightangle S11

Trader, and Rome.

• Zainet

• Solid Experience in designing relational databases and implementing database models utilizing MS

• Aligne (RT Cubes)

SQL Server, Oracle and MS Access.

• TRM

• Experience working with Front, mid and back-office operations and accounting for BA functions.

• Gasops

• Ten years of BA experience in financial solutions including: writing Stored Procedures, Test cases,

• Powerops

Queries, and Functions in SQL Server and Oracle databases.

• Entrade

• Highly proficient in creating reports in SQL Server Reporting Services (SSIS and DTS) and Crystal

• GMS

Reports using BI publisher.

• EDX

• Programming experience in .net, C#, Java, Visual Basic and Crystal Reports. Experience in creating

• AIF and editing macros in excel using VBA.

• SAP • Experience in providing 24x7 support to Production, QA, Stage & Development and UAT

• Enyware environments. Excellent troubleshooting and problem solving skills.

• Rome

• ICE

• EFETnet

Employment History

• Trayport

• Microsoft SQL Server

2000 and 2005

WG Consulting

• Citrix

Director of ETRM 2014 – Present

• Query Analyzer

Lead PM Consultant on Projects with PSEG, PetroChina, and Trafigura

• Enterprise Manager

• Project Lead on Gasops implementation for gas upgrade and served as

• Management Studio

subject matter expert on SunGard implementation.

• Forest and Trees

• Toad • Project Lead on Allegro 8 implementation at Trafigura and serve as subject matter

• DBVisualizer expert on testing and implementing integration systems.

• SQL Developer • Analyze current business processes and make recommendations on change. In

• Oracle 10G and 11 addition, working with front, middle and back office to help facilitate best use of the

• Business Objects system and efficiency and provide training where required.

• Sybase

• Lead BA work in Development, Acceptance, and Pre-Production for Aligne Gasops

• Harvest

suite, along with Allegro 8 and working deal flow issues through interface system and

• TFS

troubleshoot trades, global back office issues, invoices, PPA’s, etc. not flowing from

• Essbase

system to system within the ETRM system

• SOX

• Energy industry subject matter expert in field of expertise as it relates to business

• Cognos

software functionality and expertise and work efforts focus primarily on the

• Cognos Powerplay

implementation of SunGard’s proprietary software products.

• Query and Report

• Creating educational materials for internal and end-user training on use of

Studio

• Advanced Microsoft SunGard/Allegro applications along with building test cases and testing in all

Excel available environments.

• Access • Lead client through all functional phases of implementation according to SunGard’s

• Excel Foundation Methodology, along with day-to-day management of project deliverables

• Ensemble and help supervision of project team.

• Great Plains

• Reporting on system performance, and creating adhoc TRM reports for back office

• FRX

end users.

• Unix

• DTS packages

• SSIS packages

ExxonMobil 2013 – Mar 2014

Senior Consultant

• Project Lead on Allegro System upgrade and serve as subject matter expert on

Allegro implementation

• Analyze current business processes and make recommendations on change. In

addition, working with front, middle and back office to help facilitate best use of the

system and efficiency and provide training where required.

• System Administrator in Development, Acceptance, and Production for Allegro, along

with deal flow issues through interface system and troubleshoot trades, prices, etc.

not flowing from system to system.

• Energy industry subject matter expert in field of expertise as it relates to business

software functionality and expertise and work efforts focus primarily on the

implementation of Allegro’s proprietary software products.

• Creating educational materials for internal and end-user training on use of Allegro

applications along with building test cases and testing in development and user

acceptance testing environments.

• Managing customer requests using ITSM ticketing system, along with shell scripting

using CShell for Unix, Solaris, and Linux.

• Provide application design, development and support for natural gas trading solution,

Allegro 8, and other internally developed applications.

• Providing on call day to day 24-7 application support for both in house developed and

vendor packages.

• Using VBA to create and edit existing Macros in Excel and converting any existing

stored procedures to new production database environment.

• Lead client through all functional phases of implementation according to Allegro’s

Foundation Methodology, along with day-to-day management of project deliverables

and supervision of project team.

• Responding to internal and external audit requests and confirming in compliance.

• Reporting on system performance, and creating indexes within Allegro database for

more efficiency on system performance.

• Develop and support custom reports, class events and interfaces between Allegro

and existing business systems

• Maintain proper development, testing, production and disaster recovery environments

to support business and audit requirements.

ConocoPhillips 2011 – 2013

Senior Consultant

• Analyze current business processes and make recommendations on change. In

addition, working with front, middle and back office to help facilitate best use of the

system and efficiency and provide training where required.

• System Administrator for multiple ETRM systems, Commodity XL, Trade Pilot,

RightAngle, Zainet, and Transenergy, along with deal flow issues through “Enyware”

interface system and troubleshoot trades, prices, etc. not flowing from system to

system.

• Working on multiple implementations for Commodity XL, RightAngle, Trade Pilot,

Zainet, and Transenergy, along with working with various functional groups in UAT

and Development environments to test functionality of upgrades and patches.

• Creating and installing .BAT files (batch command files) using VBScript for end users to

install upgrades.

• Managing customer requests using Remedy ticketing system, along with shell

scripting using CShell for Unix, Solaris, and Linux.

• Using VBA to create and edit existing Macros in Excel.

• Providing on call day to day 24-7 application support for both in house developed and

vendor packages.

• Creating documentation for support and end users, along with building test cases and

testing in development and user acceptance testing environments.

• Using SQL or Oracle code for ad-hoc querying and system maintenance duties, and

responding to user data mining and data maintenance requests

• Responding to internal and external audit requests and confirming in compliance with

SOX regulations

• Reporting on system performance.

Chesapeake Energy 2010 – 2011

Consultant

• Analyze current business processes and make recommendations on change. In

addition, working with front, and back office to help facilitate best use of the system

and efficiency and provide training where required.

• System Administrator for multiple Back Office in house Accounting systems (AS/400

Artesia, CRI, and Hyperion)

• Managing customer requests using help desk ticketing system

• Using VBA to create and edit existing Macros in Excel and updating existing reports

due to upgrades in Test environments.

• Providing on call day to day 24-7 application support for both in house developed and

vendor packages.

• Creating documentation for support and end users, along with building test cases and

testing in development and user acceptance testing environments.

• Using SQL or Oracle code for ad-hoc querying and system maintenance duties, and

responding to user data mining and data maintenance requests

• Responding to internal and external audit requests and confirming in compliance with

SOX regulations

• Reporting on system performance.

• Owning all issues raised through to closure regardless of which team or Vendor

ultimately resolves the issue and on site comprehensive support for accounting

applications

• Serve as local Project Manager representing the business for special infrastructure

initiatives and lead business requested infrastructure projects within the office.

Identify gaps, manage and oversee changes that impact the business and ensure

integration is seamless and impact is minimized in testing environments.

• Resolve interface issues and data integrity checks in UAT and Test environments.

Iberdrola Renewables Gas Trading 2008 – 2010

Senior Business Analyst

• Analyze current business processes and make recommendations on change. In

addition, working with front, and back office to help facilitate best use of the system

and efficiency and provide training where required.

• Drive data integrity improvements for reported business results and validate all data

coming through to Front and Back office system. Conduct trial runs of programs

utilizing approved testing procedures to ensure they produce the desired

integration results and assure that all reports and systems tie and all controls are in

place.

• Develop and update financial and economic models in support of front office users,

along with running and creating macros to automate existing reports.

• Ensure that all gas data is timely actualized and propose ways to improve

actualization process, and support daily actualization and pieces of the end of day

of process.

• System Administrator for Gas Scheduling System (GMS/Gasops) along with

system of record “Aligne Zainet” and with deal flowing issues through gas

interface

• Maintain database standards/guidelines documentation and ensure compliance with

established IT control policies

• Using SQL Developer and various reporting tools to create and facilitate ad-hoc and

recurring reporting and analysis to evaluate operational initiatives and drive operational

efficiencies

• Supporting Oracle Bi (Crystal) and updating queries as requested by front and back

office end users

• Implementation of Gasops gas scheduling system and review. Design, develop,

test, and implemented updates and solution to all gas applications and

documented issues in development, and user acceptance environments.

Manage small projects related to enhancement and implementation

Comcast 2006 – 2008

Financial Analyst

• Analyze and evaluate operational performance metrics and resources and map them

against our operational plans and tactical/strategic goals to ensure alignment and

focus.

• Partner with other functional groups to coordinate, evaluate and analyze all initiatives,

conversions, migrations and projects from a data perspective, to achieve specific

business objectives.

• Account analysis for balance sheet, income statements, and expense accounts and

follow-up as appropriate with management. Assist management in the development

and assessment of long-range plans, and budgets.

• Identify issues, analyze the data and information presented, make recommendations

to management, and provide data in an easy to understand format for the end users

and respond to questions or concerns.

• Prepare daily and month end recurring operational reports to track all subscriber and

order activity for the Colorado market using Access and SQL queries.

• Using SQL and various other reporting tools to create and facilitate ad-hoc and

recurring reporting and analysis to evaluate operational initiatives and drive

operational efficiencies.

• Create and generate recurring reports and data points with SQL queries that will in

turn populate databases, Access or SQL Server, and creating DTS and SSIS

packages.

• Create and maintain multiple reporting tools for all departments within the Colorado

market including daily, weekly, and monthly point in time trends.

• Perform data integrity audits and correct data and documenting and updating

procedures for future audits.

• Evaluate and recommend action plans, based on all reporting/analysis in order to

enhance our customers (internal and external) experience and drive operational

efficiencies. Capture data from multiple sources such as Oracle databases, SQL

Server databases and Access databases, using SQL queries, other data sources.

Sage Hospitality 2005 - 2006

Financial Analyst

• Review all budgets and forecasting for all corporate properties and assist in

consolidations of all budgets and forecasts.

• Review and revise errors with budgets and forecast and audit actual daily journal

entries for properties.

• Financial reporting and analysis of monthly financial statements to ensure compliance

with contracts.

• Tie P&L budgets to Great Plains software.

• Review long-range proformas, forecasts, and other financial analysis as needed and

review financial modeling including IRR, NPV, Cash on Cash Returns, Trend

Analysis, etc.

• Compiling and analyzing financial information and develop revenue/expense model

data analysis, and reports.

• Auditing and inputting financial forecasts and reconciliation of internal accounts.

• Perform data integrity audits and correct data, fix bugs as needed.

• Documenting and updating procedures for future audits and oversee annual external

audits for the investments

• Support monthly rolling and 90 day forecasting.

• Support operations and executive teams by performing data integrity and analysis.

• Working with management team to confirm in compliance with SOX requirements.

• Build and maintain reports as needed using Cognos Analyst and Powerplay.

• Publishing financial reports to Cognos system and review and develop of various

advanced excel based spreadsheets.

• Review and develop of various advanced excel based spreadsheets.

• Perform Ad Hoc reporting.

• Produce data for projects through SQL Server 2005.

Sprint Communications 2001 – 2005

Corporate Collection Specialist

• Managing a portfolio of 100 companies and handling cell unit issues.

• Dealing with customers face to face regarding electronic issues, and taking

payments, logging problem tickets for corporate accounts.

• Taking inbound/outbound calls, concerning problems on accounts

• Responsible for collection of past due on corporate accounts.

• Effectively managed escalations using extensive problem solving techniques

• Consistently handled high volume of calls in a fast paced environment.

• Working with Excel and creating reconciliation spreadsheets for clients.

Education

Metro State College of Denver (Completed in 2005), B.S., Business Finance

Contact this candidate