Ross Monaghan Email & Phone Number

Glasgow, Gb

Glasgow

Application Development & Data Analysis Services* Developed and deployed an integrated Case Management, Workflow and QC application utilising VB.Net with SQL Server data storage [*.exe file, built with Visual Studio] for the client DSAR (Data Subject Access Request) team* Responsible for the tracking and reconciliation of a large, fragmented remediation population across multiple sites and distinct CM systems, ensuring coherence, clarity and transparency on the population as a whole, allowing positive confirmation of correct customer outcomes utilising SQL Server & VB.Net* Developed a bespoke .NET Application to interrogate and extract data, with scheduling functionality, from a suite of ageing Lotus Notes (Domino) databases, forming relational data from largely unstructured data and allowing fast, efficient querying of said data on SQL Server* Developed several operational applications ranging from workflow through quality assurance to systems aggregation, driving substantial cost savings for the client and enhancing the customer journey* Developed and maintained extensive executive reporting resulting from deep data analysis and mining, allowing strategic decisions to be made with confidence* Provided consultancy to other client areas, performing 'point of last call' support for technical and reporting issues unresolvable by BaU client teams (ranging from replacement of antiquated spreadsheet solutions with bespoke applications, repair of business critical tools with no clear support model and analytical work on emerging problem areas, scoping depth and span of impacted customers)* Worked with IT teams to port applications into client support structures and production servers, completing a range of documentation associated with that purpose and providing 2nd line support for developed applications following handover to client teams

Edinburgh, United Kingdom

Responsible for the delivery, maintenance and ongoing improvement of MI reporting for the Specialist Banking business (Advice & Protection). Utilizing Business Objects (InfoView/Web Intelligence) as a primary reporting delivery engine, Also utilizing VBA and SQL to provide more customized reporting, and process automation. In this role I was responsible for the delivery of a project to completely rebuild the Specialist Advice reporting environment in light of operational and data-environment changes.

London, Uk (Based), Location Independant

This role involves the management of a small team of analysts/specialists providing BAU and bespoke MI solutions for the Specialist Complaints team within Barclays (complaints escalated to the FOS).The role involves MI reporting across the operation, using various technologies (Teradata, SQL, VBA, Tableau, MS Office Applications) as well as developing and implementing application solutions for workflow and MI reporting (SQL server backend, MS Access front end, MS Excel/Power Point Reporting).My primary objective in this role is accurate and robust strategic reporting, consistently, across the business and creating a "Best In Class" team that consistently provide the highest level of service for our stakeholders, striving to exceed their expectations.More recently I have been developing Tableau reporting solutions - allowing us scheduled, low-resource reporting allowing our users to get closer to their data.

Glasgow, United Kingdom

This role involves supporting the end to end processing of PPI complaints in UK Retail Banking. I designed, develop and support several applications to support the operation. From a global workflow management application (SQL server backend/MS Access front end/MS Excel Reporting) in use by colleagues up and down the UK and in Chennai India (~500 users), to process specific applications to facilitate MI reporting (~2000 users). Independent of processing I have also developed and support an Employee Management System used to track staffing across the business, including complete hierarchy, contract hours and annual leave tracking.

Glasgow, United Kingdom

As an MI analyst my role involves being responsible for and maintaining regular MI reporting for the business unit, including centre specific MI, and cross centre MI. My role extensively involves application development and project planning, for applications designed to facilitate MI reporting and aid process workflow. I have an expert understanding of VBA and SQL, specifically integration with Microsoft Access. Monitoring agent and divisional KPIs, including incentivised metrics, is a key part of my role.

Glasgow, United Kingdom

My role as an Account Reconciliation Team Member involved correcting exceptions on customer and internal accounts, such as Rejected Entries. The role involved analytical skills and an attention to detail. As part of a project staff intake I quickly became an integral part of the team and secured a role in the MI team the following month.

Glasgow, United Kingdom

My role at Lloyds TSB involved frontline customer service via the telephone – dealing with a wide range of customer queries, from simple balance enquiries to payment investigations. I underwent a period of banking training at Lloyds which introduced me to many aspects of the financial services industry and gave me a solid foundation and platform from which to begin my career with Barclays.

Bachelor Of Science (Honours) In Computing And It (Software)

Higher National Diploma, General Science

High School

2 Advanced Highers (Biology, Chemistry) 5 Highers (English, Biology, Chemistry, Physics, Mathematics)