ETRM Consultant
Resume:
Hamid Hussain
• 303-***-**** • e mail:
*** ********* ****** *******, ** 77007
Functional Skills h **************@*******.***
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