Johnny Main Email & Phone Number

Glasgow, Scotland, United Kingdom

Production of ad-hoc reports for clients and their underlying customers in response to business requirements within agreed Service Level Agreements (SLAs), quality check teams work prior to release, update procedures where required to ensure they remain relevant. ensure checklists are completed and are ready for sign off from Team Manager. Production of daily, weekly and monthly management information reports for clients and for the internal use of the company and daily, weekly and monthly portfolio reports for clients and their underlying customers as well as production of performance information for the clients on a portfolio by portfolio basis for inclusion in the periodic portfolio reports.Maintain and continue to develop efficient ways of developing reports, and achieve improvements in efficiencies, collaborate with other teams within the business to improve the quality and integrity of the data included in client reports and the reports of their customers.Liaison with clients regarding queries or all client reporting matters including performance.Liaison with external parties regarding queries on client reports produced for our clients and their customers. Maintain effective controls to mitigate risk and ensure compliance to required processes and procedures.

Glasgow, United Kingdom

Experience of working within a data delivery role within financial services analysing and delivering of data through SQL queries and Microstrategy reports. The ability to write ad-hoc SQL scripts which run on an Oracle relational database. Analysis of data extracts to look for tends and anomalies to ensure that all the data extracted is correct and fit for purpose. Ensure all reporting meets the needs of customer and that all results are presented in the most appropriate format for them. Proactive in the needs of the Customer by adding extra value to reports. Experience of data manipulation of larger data sets into Pivot tables. Responsible for setting up reports on the Cron scheduler and to investigate any instances when the report fails. Within the team, I took on responsibility to ensure that the whole team is GDPR compliant by setting up processes and procedures to reduce the amount of data held. A strong working knowledge of security classifications, data release rules, disclosure controls and procedures across the business. Support and engage with stakeholders and team members, sharing knowledge and skills. Ensuring the integrity of all data produced and distribution through best practice and the internal Quality Assurance Process and experience of working in a cross-functional environment, maintaining all documentation in line with internal team processes and procedures. Numerate, excellent written and verbal skills as well as strong problem-solving skills and excellent time management skills.

Glasgow, Scotland, United Kingdom

Analysis of MI requests so they meet internal and external customers requirements. Data extraction via Data Warehouse and SQL scripts from Oracle databases. Look for tends or investigate anomalies to ensure that all the data extracted is correct and fit for purpose. Set up reports on the scheduler to run automatically and investigate any instances when the report fails and arrange for it to be re-run. Undertake an annual rollover of scheduled scripts in-line with SLC Best Practice. Supporting and engaging with stakeholders and team members with sharing knowledge and skills. Ensuring the integrity of data produced and distributed through a Quality Assurance Process. Maintaining all documentation is in line with quality procedures. Training stakeholders on using the Data Warehouse and advising existing users how to run ad-hoc reports themselves. Numerate with excellent attention to details and I also have excellent written and verbal skills. Strong problem-solving skills and able to prioritise workload demands and able to assess the effort involved for any reporting requirements. Ability to work on my own as well as collaboratively within the internal team and external workshops. Extensive experience of Microsoft Word and Excel . One of twelve Fair Treatment Advisors throughout the company. Covering for the Reporting Analyst during absence

Glasgow, Scotland, United Kingdom

Analysis of MI requests so they meet internal and external customers requirements. Data extraction via Data Warehouse where information is available. Maintaining all team documentation is in line with quality procedures. Training stakeholders on using the Data Warehouse. Helping users of the Data Warehouse to run ad-hoc reports themselves. Production and maintenance of the Management Information Portal. Numerate with excellent attention to details and I also have excellent written and verbal skills. Strong problem-solving skills and able to prioritise workload demands and able to assess the effort involved for any reporting requirements. Ability to work on my own as well as collaboratively within the internal team and external workshops. Experience of Microsoft Word and Excel. Facilitator for the company’s annual Business Excellence Survey

Glasgow, United Kingdom

Reporting finding of Management Information queries from internal staff and external Stakeholders, collation of information office requests through the CLASS and Microstrategy Data Warehouse System, deputising for Information Office Request Manager when required, creation of Information Office Requests and Confirmation Forms, first line contact for internal and external enquiries, management of the Management Information Office mailbox, arranging and attending management meetings, maintaining a departmental filing system

Glasgow, United Kingdom

Responsible for updating all functions of social media for MetalTalk.net, the UK's biggest independent website for rock and metal news, ensuring all news and review items are as visible and accessible as possible to our readership as well recording artists, PR companies, management teams and record labels.Organising and distribution of all digital products to a pool writers and ensuring that all reviews are correctly logged and checked off as they are done.

Glasgow, United Kingdom

Journalist and columnist reviewing live gigs and recorded media as well as interview in artists and bands from all over the world. Also responsible for contacting bands from Scotland, Canada and the Russian Federation to spread the word about their music out with their immediate fan base.

Higher National Diploma, Communication, General

National Certificate, Mass Communication/Media Studies

Education record