Liam Gallagher Email & Phone Number

• 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.
• 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

Hursley, England, United Kingdom

• 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.

Hursley, England, United Kingdom

• 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