Patrick Mcmanus Email & Phone Number

Belfast, Gb

Belfast, Gb

Belfast, Northern Ireland, United Kingdom

Working within the Professional Services team to deliver high value data projects to both internal and external stakeholders across a wide range of data systems.Key Responsibilities:• Technical Data Skills – Writing of scripts in Oracle PL/SQL to create complex data sets; Production/Maintenence of OLAP Cubes and Data Schemas for user-facing BI Analytics systems; Data Migration project work for CU business mergers; Data Amendments & uploads to Central Credit Register CCR for corrective financial work.• Client Communication – Liaising with clients across a variety of Credit Unions (CUs) throughout Ireland; Project Requirements Gathering for data & BI systems; Delivery of solutions to end users, including documentation and training as required.• Data Visualization – The implementation of Dashboards and Reporting (Hitatchi Pentaho, Power BI) from source data, ground-up builds of all aspects of dashboards to final implementation and end-user testing.• Project & Time Management – Ability to effectively manage a complex workload across projects across a number of business verticals, and for a variety of business stakeholders.

Belfast, Northern Ireland, United Kingdom

Working as a liaison between various Business Divisions (e.g., Finance, Project Management, Supply Chain etc.) and Technology teams within the business, my role has been to effectively ‘bridge the gap’ between the needs of end-users and the technical expertise in how to achieve these goals in order to bring about change and process improvement.Key Responsibilities:• Effective Communication – Liaising with stakeholders across a variety of business teams (spread over numerous global geographical locations), in order to translate end-user requirements into technical specifications (and conversely, explain technological roadblocks in a readily understandable fashion when required). Advising on best-practices and workflow implementation as required.• Technical Data Skills – Including the understanding of data systems & structures, data warehousing and wrangling (Oracle and GCP); strong SQL skills & the ability to analyse, clean & transform raw data into useful data sets for reporting.• Data Visualization – The implementation of Dashboards and Reporting (Oracle OBIA/OBIEE, Tableau) from source data, ground-up builds of all aspects of dashboards to final implementation and end-user UAT testing.• Project & Time Management – Ability to effectively manage complex workloads across projects within an AGILE framework, to adapt and react to business needs and manage stakeholder expectations effectively across the board.

Belfast, Northern Ireland, United Kingdom

Working as a freelance data consultant agent for several local businesses to facilitate the effective leveraging of company data & create value through better metrics and KPI dashboards.Key Responsibilities:• Client Consultation – Effectively communicating with each client to identify their requirements, budget and any potential roadblocks to success; managing expectations and offering solutions to existing workflows in order to more effectively gain insight into their operations.• Data Investigation Work – Determining data sources & structures in order to effectively integrate all required elements into a cohesive framework, identifying ETL & data cleansing processes required in order to pull information into a useful format.• Project Management – Delivering projects in a timely fashion and calling out any potential issues affecting this to the client; managing multiple competing priorities effectively in order to deliver a high quality of service to key stakeholders.• Effective Solution Development – Creation of KPI, Dashboard and Reporting solutions across a number of applications and software; identifying effective workflows to ‘join-up’ siloed information into intuitive and cohesive processes for clients

Belfast, Northern Ireland, United Kingdom

Working as part of the leadership team in a Client Services (CS) division, overseeing a staff of 100+ based across the UK, US and Philippines. My function in this role was two-fold; firstly, to manage & capacity plan for resources across a multi-channel CS division; second, to use my knowledge of business systems to implement effective BI and management reporting solutions for the Executive Leadership Team (including CEO, CTO, CFO & SVPs).Key Responsibilities:• Capacity & Resource Planning – Developing data models to best utilise available resources in order to provide high-level customer service • Forecast Modelling – Drawing on various data to create rolling workload forecasts (12M+) in order to ensure the effective distribution of staff; using expertise to highlight areas of improvement and recruitment requirements for future business activities/upscaling• Systems Implementation – Had oversight of the build & integration into the existing information systems framework of numerous applications, including: o Complete ground-up build & implementation of a new WFM system (Calabrio) o Design and creation of Contact Centre Wallboards for real-time performance management (2Ring) o Telephony integration processes for existing data systems (Cisco, Netsuite) o Development of automation to improve business process (MS Excel, VBA Macros, SQL)• BI Reporting – Development of a complete suite of BI reporting for various teams and management stakeholders, including intraday real-time reporting, interval reporting (weekly, monthly, quarterly, annual); Data Visualization through KPI dashboards across a number of systems• Budgetary Planning – Working in conjunction with the SMT, Finance & HR departments in order to develop effective financial plans for business headcount (with responsibilities for staffing budgets of $1 million+), to ensure efficient ROI on investment in staff & training, as well as financial transparency to all key stakeholders.

Belfast, Northern Ireland, United Kingdom

I worked in this role as part of a support team dedicated to the continuous monitoring, forecasting and planning of a contract for a prestigious client (BBC). This role had two different aspects, BI Reporting and Resource Planning, each of which overlapped towards the overall goal of effective implementation of contractual obligations for both the employer and client.Key Responsibilities:• Resource Forecasting & Planning – Development of capacity plans and forecasts, based on multiple data sources in order to allow SMT to effectively plan, train & budget for a staff of 100+ agents• Staff Scheduling – Effective intraday scheduling of staff to ensure high levels of customer service & achievement of numerous contractual SLAs for a multi-channel workforce• Data Analytics & Wrangling – Trend analysis and data investigation across CRM & Telephony systems in order to build a comprehensive model of business performance and areas for continuous improvement & efficiency savings; mining of large-scale data sets to create useful statistical models & transformed datasets for MI reporting• Data Visualization & Reporting – Creation of reports for team leaders and SMT to allow for effective performance management, Contractual Reporting to key client stakeholders, and analysis as to factors affecting contract performance.

Bachelor Of Science (Bsc), Psychology

BSc In Psychology including various modules in Statistical Modelling.

Education record

10 GSCE & 4 A-Levels