Worked closely with Finance teams to manage a suite of 100+ reports vital to the royalty distribution workflow for both PRS for Music and other external partners such as ICE and GEMA• Leveraged SQL skills to check data issues, prototype report ideas, write custom business logic and develop views to combine data from across the Unit4 Financials SQL Server database• Led end-to-end development of three brand new reports, working closely with cross-functional teams to design, develop, and test reports that delivered reliable insights• Improved report performance in business-critical distribution and invoicing reports by refactoring and redeveloping unoptimized queries• Wrote, tested and deployed scripts to re-process a multi-million record financial data set, while working closely with the finance team to validate results. Conducted thorough testing to ensure seamless deployment and minimize errors• Prepared documentation, collaborated with the infrastructure team to troubleshoot configuration issues, and played a key role in the successful completion of a Cognos upgrade project

Responsible for stakeholder management, outreach, data discovery for new KPIs, and Cognos 11 development for a global Cognos reporting suite at IBM (~2000 users, ~100 reports)• Partnered with worldwide product leaders to design and deliver key business intelligence data across all product segments• Worked as part of a team of 8 analytics professionals where I focused on data discovery, KPI development, stakeholder relationship management and report development• Presented prototypes and proof of concepts to executives, demonstrating how key business questions can be answered using business intelligence• Built prototypes into fully functional tools through quick iterations based on customer feedback• Developed new KPIs and refined existing ones in conjunction with business stakeholders to create meaningful, actionable insights which take advantage of previously untapped data sources.• Increased attachment of consulting services bundled with software licenses from 15% to 30% through the development of a “Services Attachment” metric, which highlighted potential new leads and tracked deal attachment % through a dedicated dashboard

Responsible for end-to-end development of an EMEA-based Cognos reporting suite at IBM (~700 users, ~50 reports)• Partnered with sales and operations market leaders for each of the 8 regions in EMEA, identifying opportunities and improvements for their existing business intelligence toolkit• Worked as part of a small, focused team which required the use of a wide skillset across all areas of business intelligence and analytics• Consulted directly with sales and operations leaders to design attractive, intuitive dashboards across a variety of financial and resourcing metrics• Responsibilities as lead developer included overseeing strategic direction, development, maintenance, support, and education for EMEA software services management reporting• Utilised skills in ETL and SQL to create data pipelines to extract, transform and load data from corporate data sources into a centralised data warehouse• Delivered education and technical support to a 700+ user base through 1 on 1 education, group training sessions and presentations covering new developments and updates• Led a ground-up redesign of the EMEA Cognos infrastructure, ensuring our reporting suite was best in class within IBMs internal analytics tools in terms of reliability, visual clarity and data provenance• Boosted user numbers from 400 to over 700 through training sessions, improved communications (blog posts, mass emails, dedicated Slack channels), and recommendations from Software Services executives• Instigated and lead a ground up visual redesign of the European reporting suite (50+ reports and dashboards) to be both more intuitive for users and more visually appealing through the use of a cohesive design language and strong branding