Capita

The role sits within the Performance Management and Forecast Team which is part of a wider multi-disciplinary Support Services team that covers Performance Management, Capacity and Forecasting, MI and Analysis, Scheduling & Contractor Management.

•	Creating a Database for Departments to view Employee Data and Linking it to SharePoint for easily viewing by the Management. Adding Pro-active Queries to identify Employee Attrition, Churn, and Turnover.

•	Created Macros that from one Sheet sends 200 Emails on a loop to Staff with up to 50 Task Reference Codes. Then depending on length of time outstanding Auto copies in the Manager or the Regional Manager to escalate tasks.

•	A Macro to validate Quarterly and Monthly Bonus payments to Staff for the Finance Team. To ensure accurate and timely payments.

•	Producing Power BI Report for a Rolling 7 Days and uploading them onto Microsoft Teams for the management to view performance. To see if they have achieved daily targets and view trends.

•	Data Mining from CRM Dynamics 365. Looking at the end-to-end process. Producing Innovative reports based on key audience objectives.

•	Training colleagues on complex reports. By documenting the process and recording on Video then uploaded onto MS Teams. Shadowing, providing assistance and support where necessary.

Business Data Analyst

Utility Team

Reporting directly to Director Level. Looking at current Processes for Consumption Data. Developing VBA Macros to highlight Spike, Overlaps in Consumption Data for our Clients.
Looking for Sale Opportunities in Company Data. 
Created VBA Macro to forecast & view Contract Performance Revenue for Accounts Dept & Directors. Important for Covid-19 impact on Supplier Claw Backs
Read and analyse HH data and has worked extensively with data aggregators. 
The role will be to overcome dataflow queries and issues particularly related to change of supply. 
The Data Analyst will be responsible for all operational dataflow processes and will be working closely with Data Collector/Aggregators and MOP providers.   

•	All dataflow management
•	Created VBA Macro to Monitor Contract Performance in Covid 19 times. 
•	Change of supplier issues and resolution
•	Working with HH data, MOP’s DC/DA’s
•	Auditing and review of operational processes
•	Quality management of processes
•	Generating adhoc reports for clients
•	Working with clients to help them understand their usage to look for reduction measures

Data Analyst

Providor

General Duties/Key Responsibilities: 

•	Produce Daily SAIF file to Process Dataflows for Smart Meter Exchanges for BMSL  Providor MOP 
•	Develop VBA Model to Process Dataflows from Jobwatch Application to AMOP
•	Process D0135 Dataflows Informing the DNO of Meter Faults to protect Customer Safety
•	Process Daily MOP Workflows D0001, D0005, D0134, D0142, D0194 
•	Report back to Providor Operation of Resolved DNO Call Outs on D0126 Flows
•	Investigating and Resolving data exceptions falling out of the interface between work 
•       management   systems and data flow management capabilities
•       Production of MAM/MOA billing files
•	Bill Validation were required
•	Ad hoc report production, manipulating data in Excel formats
•	Investigate And Resolve ECOES Rejections of D312 Flows
•	Produce MI Reports for my area of the Business
•	Analyse industry data and interpret unusual patterns and possible causes
•       GDPR Certified
•       Build and Maintain the Portfolio Database
•       Data Visualisation Skils with Power BI and Tableau

Industry Data Analyst

E.ON

•	Create Customers New Accounts from Developer Information in Eon’s  ICE Application.
•	Investigate and Problem solve any Migration issues such as Industry Dataflows both Power and Gas. 
•	Solve ICE Application issues in a timely manner.
•	Support Team Training for Department Migration from Leicester to Coventry Office 2017 to 2018
•	Manage MI Reports from the Team to Management at Leicester. Breakdown Reports for each Category so continuous improves to service can be made. 
•	Monitor Team Performance by Key Performance Indicators.
•	Improve MI Reporting with VBA to reduce reporting time
•	Manage Team Move within Coventry with internal stakeholders

Developer New Connections Analyst

•	Maintain industry SLA of 99% with Actual Meter reads
•	Investigate and raise D1 Data flows to the MOP (Meter Operator) to resolve meter communication line failures; keeping  supplier and customer informed, as required, to ensure timely fault resolution
•	Investigate validation failures to identity and resolve root cause. This includes errors Alarms, Overlap, Gap etc.
•	Export valid Meter Reads from Mv90 to MDR and Trigger Dataflows to the Supplier, HHDA and Distributor in a timely fashion. 
•	Use EON Applications including HHDC Query to check if Meter Read is within the Date Window.
•	Combine files in Mv90 to remove invalid status on meter reads
•	Re-Pole Meters by the Remote interrogation Tool to see if we can obtain meter reads without the Spike Errors
•	If there has been a Meter Exchange and we do not support the new meter type like ‘IP’ to email the supplier to De- appoint ourselves as the Data Collector.
•	Respond to D170 Dataflow requests to provide 14 Months (426 Days) of Data to the New DC by sending a D0036 flows.
•	Investigate the DC errors on all Gateways  PGEN, EMEB, OXPO and CNRG. These include P272 errors.

HHDC (Half Hourly Data Collector) Analyst 

First Utility

•	I work closely with internal departments to assist with any system errors and look for permeant fixes
•	Working through a variety of problem accounts to identify and then apply a fix which provides a satisfactory resolution for the customer
•	Identify and analysis trends that occur to aid in fixing the issue within a fixed SLA
•	Manage my own caseload of work through to resolution, ensuring they are completed within agreed timescales 
•	Make recommendations on improving processes and procedures to increase the productivity
•	Resolution of technical data errors to ensure customers are billed accurately and timely
•	Management and resolution of customer queries and complaints generated throughout the joining process

Technical Team Advisor

npower

•	Pricing Customers with New Acquisition and Renewal Products  
•	Producing Both Small Medium Enterprise (SME) Power and Gas Costs on a Daily Basis
•	Updating Price Models each day with Latest Costs.
•	Maintaining and Supporting with Visual Basic (VBA) code the Price Models for our Internal Sales Channels
•	Providing SPM data to the Internal Sales Channels
•	Billing Power Configuration at Admin Level, Entering Monthly and Quarterly Cycle Dates, Peel Off Dates for Group Billing, Updating Both VAT and Climate Change Levy (CCL).
•	Market Domain Data (MDD) Support, Updating Top-lines each Month with Meters which are valid and supported in our SME systems.
•	CMA Collation and Reporting

SME Price Analyst

•	Working in the Beryl Project Team to help Build and Test the New Billing System
•	Adding New Data for Setting up of the New SME Billing system.
•	Liaise with the rest of Business to support their Billing requirements.
•	Add Price Products and Billing Cycles

Beryl Billing Configurator

•	Bill Checking for Errors and then intercepted before been sent to the customer.
•	Making Sure the Correct Independent Energy Tariff had been applied to the customer’s Account.
•	Making sure the correct consumption had been applied. Fixing any Deductive Metering errors. Also Checking the Customers Max Demand, Reactive Power and Capacity Charges were correct.

Tariff and Bill Check Analyst

Data Analyst at Capita

I am a Data Analyst with Software experience, I have Worked for three Energy Suppliers, An HH Data Collector and a SME/Domestic Smart MOP.  Working in Customer Service, SME Billing, SME Pricing,  Data Flows for MOP for Smart Meters and now Energy Consultants.  I am always looking at ways of improving internal systems, for advanced efficiency and remove human error by Automating processes by VBA Macros & Python code. I have programming experience using Python 3 ( Including Jupiter Notebook, Numpy, Pandas, Matplotlib, Pyautogui. ) and MySQL and MSSQL. I have Data Visualisation Skills with Power BI and Tableau. I can create Company Databases and Automate them. MS Power BI experience in Visualising Data .  Salesforce Lighting Admin User in last current role.

Taplio

Gary Lines's Linkedin Analytics

Gary Lines

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Gary Lines's Linkedin Analytics

Gary Lines

Want to drive more opportunities from LinkedIn?

Gary Lines's Linkedin Analytics