Nicholas Coe Email & Phone Number

Bedford, England, United Kingdom

• As a Business Intelligence & Reporting Analyst at Opus Energy, I’ve made significant contributions to our data-driven decision-making process. Here are some highlights:𝐄𝐧𝐞𝐫𝐠𝐲 𝐁𝐢𝐥𝐥 𝐑𝐞𝐥𝐢𝐞𝐟 𝐒𝐜𝐡𝐞𝐦𝐞:
• Independently developed a sophisticated SQL script to handle energy price cap discount claims.
• Aggregated data from 13 million invoices drawing insights from 30 database tables.
• Effectively managed stakeholder expectations, resulting in positive feedback
• Partnered with the compliance team on 7 successful audits of my work.𝐁𝐢𝐥𝐥𝐢𝐧𝐠 𝐒𝐲𝐬𝐭𝐞𝐦 𝐄𝐧𝐡𝐚𝐧𝐜𝐞𝐦𝐞𝐧𝐭:
• Investigated 171 million invoice lines using SQL.

Northamptonshire, England, United Kingdom

• As a SMART Experience Advisor, my primary role was that of a technical expert and customer service agent. However, recognising the team’s urgent need for reporting expertise, I took it upon myself to learn the.
• Identified 5 processes as candidates for partial automation.
• Leveraged SQL queries to extract data from three databases and aggregated the information to facilitate decision-making, mirroring human judgment.
• Produced 4 separate outputs that were worked as new streamlined processes.
• Resulted in a remarkable 98% reduction in daily data preparation time.
• These reports are still actively used by the team today. 𝐄𝐱𝐜𝐞𝐥 𝐓𝐨𝐨𝐥 𝐭𝐨 𝐚𝐬𝐬𝐢𝐬𝐭 𝐨𝐩𝐞𝐫𝐚𝐭𝐢𝐨𝐧 𝐞𝐟𝐟𝐢𝐜𝐢𝐞𝐧𝐜𝐲:

Northampton, England, United Kingdom

• As a Customer Care Specialist, I prioritised connecting with customers to address their concerns and rebuild trust. Leveraging strong communication skills, I actively engaged with customers to gain deep insights into.
• Collaborated with cross-functional teams to identify root causes of complaints and implement corrective actions.
• Offered tailored resolutions to customers, resolving an average of 3 complaints per day relating to invoice discrepancies, contract disputes, change of tenancy errors and technical metering issues.
• Drafted formal written communications outlining resolutions when mutual agreement couldn’t be reached, facilitating customer recourse through the Energy Ombudsman.

Northampton, England, United Kingdom

Northampton, England, United Kingdom

Northampton, England, United Kingdom