Pharohl Charles
Commercial Analyst @ARM Energy
Signup · Get unlimited contacts
WORK HISTORY
Commercial Analyst @ARM Energy
Houston, TX, US
Commercial Operations | Power BI | Power Query | ETRM | Data Analytics | AI-Assisted Workflows• Rebuild P&L and MTM reporting in Power BI using Power Query and SQL for swaps, storage, and forward positions• Leverage AI tools (LLM-assisted DAX and SQL modeling, automated data transformation logic) to accelerate report development, optimize data cleansing, and standardize valuation logic across multiple data tables within the ETRM environment.• Lead cross-functional ETRM implementation for gas trading operations, partnering with Trading, Risk, Accounting, Legal and IT to modernize trade capture, automate processes and retire legacy systems.
EDUCATION
Rice Business
Master of Business Administration - MBA
Middlebury College
Intensive Russian
KIMEP University
Study Abroad in Almaty, Kazakhstan
New York University
Master of Science (M.S.), Global Affairs
California State University, Long Beach
Bachelor of Arts (B.A.), International Relations; Political Science and Russian Double Minor
California State University, Northridge
STARTALK Intensive Russian Language and Cultural Immersion Program, Russian Studies
SKILLS
ABOUT PHAROHL CHARLES
I sit at the intersection of energy markets, data, and AI, helping trading and finance teams operate from the same reality when it comes to risk, positions, and P&L. As a Commercial Analyst at ARM Energy, my work centers on three areas: commercial analytics, reporting, and ETRM systems transformations. I translate complex trading activity into structured data, dashboards, and insights that support decision-making across finance and commercial trading teams. I believe the most effective reporting starts at the database level. Instead of relying on front-end exports and manual spreadsheets, I tap in directly from system backend datasets using SQL and Power Query and conduct modeling and transforms to create automated workflows. I also lead a major ETRM system modernization within an Agile framework using AI-assisted workflows to draft and refine user stories, organize requirements, and keep front, middle, and back office needs aligned as we modernize our technical infrastructure. Across all of this, I use AI as a practical accelerator. Tools like Claude Cowork and Code, Perplexity Computer, Copilot, Notion and others help me prototype complex queries and measures for data modeling, structure requirements, draft documentation, and stay on top of energy, data, technology and AI trends so we can adopt these capabilities safely and responsibly. Focus Areas: Trading · Operations · Risk · Reporting Products: Natural Gas · Power (CAISO, ERCOT, PJM) · Crude · Refined Products Technical stack: Power BI · Power Query · DAX · Azure DevOps (ADO) · ETRM (Endur, Horizon/Allegro, RightAngle, SAP, Adapt2) · Applied AI for analytics and workflow automation Education: Rice MBA | NYU MS Global Affairs | CSULB BA International Affairs
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.