Colm Sweeney Email & Phone Number

Edinburgh, Scotland, United Kingdom

Migration of Business Objects Reports (Webi) to Tableau: This was a multi-year project recreating and redesigning reports and dashboards in Tableau, ensuring that the reporting functionality and visualizations match or improve upon the existing Business Objects Webi reportsMigration of Oracle SQL to AWS Athena: This was a multi-year project converting Oracle SQL queries and database structures to be compatible with the AWS Athena environment and Git Hub. Design new Tableau dashboards/reports: Design and create new Tableau dashboards/reports as required by Finance and wider parts of the business (via Jira board) providing insights that drive strategic data decision-making. Use daily stand-ups and weekly team meetings to provide updates to team members and team manager of progression/blockers. Regulatory Audit Assistance: Act as one of the Finance contacts for external audit, addressing queries and providing necessary data to support audit requirements.Nominated for Trainline employee of the year 2021 (Winner of Problem Solver of the Year)

Edinburgh, Scotland, United Kingdom

Cash Controls & Reconciliations: Design and implement new cash control mechanisms and reconciliation processes utilizing the Business Objects BI Tool to streamline and enhance financial accuracy.BI Reporting Library Creation: Develop and maintain a comprehensive BI reporting library tailored for the Finance team, enabling efficient access to critical financial data.Financial Data & KPI Reporting: Generate and analyse key financial data to produce reports on KPIs, providing insights that drive strategic decision-making.Data Query Support: Assist the Finance team in handling complex data queries by creating and optimizing Oracle SQL queries to ensure accurate and timely responses.Documentation of Finance Processes: Document all key finance controls, processes, and workflows in detail, utilizing tools like Microsoft Word and Visio for clarity and consistency.Project Leadership: Lead Finance in implementing new projects, including the onboarding of multiple merchant service providers and payment gateway providers, ensuring seamless integration with financial systems.Project Representation & Analysis: Act as the Finance department representative on internal projects and assess and communicate impacts of the project on the Profit & Loss (P&L) statement and Balance Sheet.Team Support: Address daily queries from the accountancy team, offering guidance and resolving financial issues.Reporting Design & Implementation: Create new reports to meet operational and financial reporting needs. Update existing reporting processes as needed to enhance accuracy and relevance.Process Review & Improvement: Analyse current daily financial workflows and make updates to improve efficiency and effectiveness.KPI Reporting: Provide senior management with regular Key Performance Indicators (KPIs) related to sales and revenue.Team Communication: Ensure the finance team stays informed on ongoing projects, translating technical details into accessible information.

Query Resolution: Work closely with fund managers and traders to address daily issues and queries, ensuring smooth operations.Trading System Queries: Provide expertise and support on the effective use of trading systems, likely involving troubleshooting and user guidance.Fault Resolution: Collaborate with the development team to identify, report, and address bugs or faults in internal programs.Change Management: Oversee and process change requests, ensuring that updates align with both user requirements and system stability.Testing Support: Assist with system testing and User Acceptance Testing (UAT) on front office systems, such as FIX Protocol and Longview, to ensure they meet operational standards.Requirement Gathering: Work with business areas to determine specifications for minor development projects and ensure compliance with evolving industry standards.Project Representation: Act as the front office support representative on internal projects, providing insight and updates as needed.Documentation: Maintain thorough documentation of support procedures for reference and continuity.Cross-Training: Train other team members to enhance their knowledge and ensure the team can cover each other's responsibilities.Reporting: Produce regular reports for various business and Information Systems stakeholders, providing insights and updates on system performance and issues.

Dublin, County Dublin, Ireland

Trade Query Management: Respond promptly to trade-related queries from traders and portfolio managers across global locations like Dublin, Milan, and Singapore.Trade Booking and Corrections: Ensure accurate trade bookings in systems like Charles River and Latent Zero, and advise the back office on corrections as needed.Handling Multiple Derivative Types: Manage inquiries across OTC derivatives, equities, bonds, futures, options, and funds, ensuring seamless operation and issue resolution.Security Data Reconciliation: Set up derivatives in the internal system and confirm daily matching of securities data between front and internal systems.System Enhancements & UAT Testing: Provide feedback on system improvements and participate in User Acceptance Testing (UAT) to ensure functionality aligns with operational needs.

Masters, Finance,Economics, Strategy

Ba, History