Business Information Analyst
Current•Updating and issuing important business-critical reports to senior management, providing trend analysis and commentary, identifying any significant activity in revenue.•Providing daily activity reports to senior managers in multiple departments, allowing them to have full visibility of their team’s current performance to pre-empt any potential shortfalls against targets.• Gathering the requirements from senior management and producing a weekly KPI dashboard in Microsoft Excel, allowing management to view performance at both an individual and team level.•Developing departmental activity trackers, streamlining their current processes and providing improvement suggestions, implementing best practices, also maintaining accuracy of data and liaising with team members when needed to prevent future errors.• Creating an activity tracker in Microsoft Excel for the Customer Service team, which extracts live data from multiple workbooks, allowing them to clearly see which tasks need actioning urgently, reducing the customer waiting time and maintaining customer satisfaction.•Producing accurate monthly commission reports to be reviewed by senior management by a fixed deadline, using data from multiple excel workbooks to calculate the earned commission of the Sales Executives, based on their activity and their targets.•Carrying out critical investigations as needed, locating payments and orders across various systems to maintain client satisfaction.•Being the company’s in-house Microsoft Office Excel expert, investigating issues for multiple departments, finding root causes, problem solving and optimising their workbooks when appropriate.