Mark Cole

 mark cole professional summary A strategic thinker with 14+ years of experience in data management and analytics at Ulster Bank and NatWest. Senior Business Analyst with experience defining and delivering detailed analysis projects in dynamic, fast-paced environments. I have proven ability to work effectively on my own initiative, adapt to change and am self-driven to achieve and deliver lasting results. Implements Agile methods for continued progress within cross-functional projects. Proactive and responsive in adapting to changing circumstances and innovate best practices. I am a team player who is always willing to go the extra mile to ensure that projects are completed on time and within budget. Key Skills • Demonstrated ability to lead complex business analysis projects, including requirements gathering, gap analysis, and solution design, resulting in successful project outcomes and increased business efficiency. • Proficient in data mining utilizing SAS, SQL, and AWS generating actionable visual insights on Tableau / Power BI to drive business decisions and improve business performance. • Business intelligence expertise with exceptional communication and collaboration skills, effectively engaging with cross-functional teams, senior executives, and external stakeholders to ensure project success. • Advanced in Microsoft office suite and proficient in implementing and optimizing business processes, including process mapping, risk assessment and change management. • Strong analytical and problem-solving skills, with a focus on continuous improvement and driving business results. • Adaptability and flexibility in managing changing priorities and working under tight deadlines, while maintaining a high level of quality and attention to detail. • I ensure data accuracy and integrity through consistent data validation procedures and appropriately applying data cleansing methods. experience Ulster Bank March 2017 - Current Senior Business Analyst • Data interrogation and analysis to produce business insights. • Presentation of findings and recommendations to Senior Management. • Design and production of operational reporting and strategic campaigns. • Identification of process gaps / risk using a data led approach. • Actively contributed to re-design of data / reporting structure. • Migration of analysis code (SAS) from in-house servers to Amazon Web Services (AWS) cloud-based platform. • Developed and implemented new and adjusted processes to aid automation across divisional workflows. Ulster Bank June 2014 - March 2017 Business Analyst • Create, monitor, and report daily, weekly, and monthly metrics / KPI's for distribution to Business / Senior Managers / Executive Committee etc. • Identify potential risks, gaps, and trends to ensure all projects run efficiently. • Attendance and proactive engagement at Management meetings to ensure clear delivery and understanding of management information to drive performance and risk compliance across all teams. Ulster Bank September 2012 - June 2014 High Value / Receiver Team • Attending and presenting at Credit committee meetings. • Managing arrears customers across multiple loans. • Providing the Bank with a strategic advantage for reducing losses, increasing recovery rates and ultimately longer-term customer value. • Reconciliation of all accounts, payments, and MI from all outsourced vendors. • Creation and maintenance of MI for Receiver cases for use in reporting. Ulster Bank June 2011 - September 2012 Pre-Legal team • Portfolio management of arrears customers. • Collaboration with Underwriting, Collection and Recoveries teams to ensure correct outcomes for customers. • Managing relationship with third parties e.g., Legal firms, tracing agents, receivers etc. education • • PRINCE2 Foundation Certification – Awaiting grant from Ulster Bank to apply. • Digital Financial Services & Data Analytics (UCD) – November 2021. • Managing People Well – (Ulster Bank) - September 2018. • Mental Toughness – (Ulster Bank) - March 2017. • Determined to Lead – (Ulster Bank) - October 2016. • QFA Investments – (IOB)- January 2015. • QFA Regulations – (IOB)- May 2014. • Advanced Excel Course – (Ulster Bank) - May 2014. • QFA Loans – (IOB) - November 2013. • Intermediate Excel Course – (Ulster Bank) - January 2012. • Plumbing Apprenticeship – (FAS) – January 2006. Achievements • Instrumental in delivering data driven insights to support the achievement of the Central Bank of Ireland directive to reduce the non performing loan ratio (Circa 80% reduction achieved). • Recognition received from CEO on my contribution to the reduction in the performing loan ratio. • Designed, coded and developed the Covid 19 payment break reporting suite for MANCO, EXCO and the Central Bank. • Identification of multiple process gaps, escalation of findings with proposed solutions and implementation of same to improve customer experience. .