How Merck Family Foundation modernized its grants management with Optimy
Merck Family Foundation
The Merck Family Foundation is a philanthropic organization focused on supporting innovative projects in education, healthcare, and community development. With a mission to create sustainable and measurable impact, the foundation operates both domestically and internationally, partnering with a diverse range of organizations. As a small team managing a growing portfolio, the foundation needed to modernize its processes to keep pace with its strategic ambitions — without adding headcount.
A small team overwhelmed by manual complexity
Before Optimy, the Merck Family Foundation was managing over 100 grant applications per year with a team of just two — relying entirely on spreadsheets, email threads, and manual data entry.
- 100+ applications per year managed manually by a team of two
- Time-consuming, error-prone data handling across multiple spreadsheets
- No transparent system for tracking and reporting funded project impact
- Staff turnover threatened institutional knowledge and continuity
A centralized, automated platform adopted since 2020
The foundation discovered Optimy through consultations with peer foundations and sector experts. Implementation began in 2020, with full support from the Optimy team throughout the onboarding process.
- Centralized project data: All application and project information stored in one platform, accessible to the entire team at any time.
- Automated application handling: Streamlined intake, data entry, and review workflows — eliminating repetitive manual tasks for the small team.
- Impact tracking against predefined indicators: Integrated tools allow the team to track and visualize funded project outcomes with consistency and clarity.
- Knowledge continuity through personnel changes: Centralized records ensure that no institutional knowledge is lost when team members transition.
Strategic focus restored — admin burden lifted
Since adopting Optimy, the Merck Family Foundation has transformed its internal operations. The team now spends less time on administration and more time on what matters: building meaningful relationships with funded partners and evaluating real impact.
100+
Applications/year (Managed efficiently by a team of two)
2020
Live since (Smooth implementation with full Optimy support)
Real-time Data access
(Full transparency on every funded project)
Zero
Knowledge loss (Continuity maintained through personnel changes)
We really believe in maintaining individual relationships with each funded partner, and the system helps ensure that no detail is overlooked. The ease of accessing and sharing information has made our operations much more efficient.
Grant Manager — Merck Family Foundation
The team shifted from drowning in admin to focusing entirely on partner relationships and strategic impact evaluation.
Request a demo and start amplifying your social and business impact.
