Brendan McGeehan

Manages a team of 5 onshore data analysts supporting IKEA's US Retail organization, with a focus on fulfillment and customer service operations.

• Developed a data product analyzing delivery cost margin across key dimensions, identifying $100K in cost savings in its first year.
• Implemented a solution tracking inventory positions across 2 cloud platforms and 5 operational systems, saving 2,100 hours per year in data access, cleansing, and synthesis.
• Built a pipeline ingesting 1B+ monthly records to inform industry market-share and share-of-spend analyses.
• Delivered a product that cuts data access time for eDiscovery and product recall information from two weeks to thirty seconds, via a dashboard and a natural-language chatbot alternative.

Served as interim Data Management Leader for the US, representing the country within IKEA's Enterprise Data Management organization.

• Managed SPAN-360, Spectra's enterprise analytics team of 2, delivering actionable insight on concession operations across 300+ sports and entertainment venues.
• Partnered with internal IT and Spectra's external managed services provider to scope, design, and build the organization's first centralized data warehouse.

Aug 2017 – Aug 2019

• Drove strategy, development, and stakeholder communication for a cross-functional analytic solution contextualizing an 80% increase in digital customer touchpoints amid the shift to self-service.

Senior Manager, Enterprise Business Intelligence · Feb 2015 – Aug 2017

• Owned development and deployment of a data product adopted as the single source of truth for identifying promotion activity affecting over 17M customers enterprise-wide.
• Managed the full development lifecycle of an analytical product enabling insight into the financial and operational impacts of annual rate increases exceeding $1B.

• Standardized core data definitions for a pharmaceutical Master Data Management (MDM) catalog at AmerisourceBergen by facilitating cross-functional workshops with Finance, Accounting, and Supplier Relations stakeholders to ensure architectural alignment.
• Provided analytics and reporting strategy for Comcast Cable, focusing on the bridge between technical infrastructure and executive storytelling.

• Managed the credit monthly data collection and reporting process for Capmark's entire balance sheet loan and equity portfolio, totaling more than 2,500 loans, through a custom-designed, transaction-based system.
• Co-managed the company's Quarterly Loan Risk Rating Process, in which a subset of Capmark's loan portfolio (approximately 1,500 eligible loans) was reviewed and evaluated on an independently certified rating model as part of a custom-designed risk rating application.
• Collected, organized, and formatted key portfolio and market statistics for presentations to Capmark's executive management team, board of directors, credit agencies, and external investors.

Key Clients & Projects

Capmark Finance — Horsham, PA

• Gathered and documented functional requirements, executed data conversion, performed internal unit and integration testing, facilitated QA and UA testing, delivered end-user training, and acted as first-tier support for 2 separate custom Excel-based applications.

Key Clients & Projects

Entergy — New Orleans, LA

• Created functional reporting specifications for delivered financial analysis reports.
• Redesigned these reports using Cognos PowerPlay and Impromptu, executing comprehensive testing for formatting and data accuracy.

DST Systems — Kansas City, MO

• Created and validated Informatica mappings to seamlessly transfer data from the financial system into the enterprise data warehouse.
• Formulated PeopleSoft Insights and Cognos reports from warehouse data sources, and trained 50+ users on report access and distribution.

Key Clients & Projects

Exelon Energy — Kennett Square, PA

• Developed front-end screens in PeopleSoft and engineered back-end algorithms in Informatica to allocate indirect costs based on activity drivers.
• Designed dynamic Cognos reports to effectively convey key operating data to client stakeholders.

SEPCO — Jinan, China

• Partnered with internal business stakeholders to seamlessly align financial and logistics workflows with new ERP capabilities.
• Leveraged redesigned workflows to execute the initial configuration of PeopleSoft Purchasing and Project Costing modules.

• Oversee end-to-end administration and maintenance of the PTO digital platform, ensuring consistent uptime and user-friendly access to school news, events, and ticket sales for the community.