• It used to take Ancestry hours to make changes to their applications. Now it takes minutes.
  • Forecasting took weeks, now it happens instantaneously.
  • Accounting and financial planning departments have access to real-time data.

Ancestry knows data. Their goal is to help users discover their family stories and gain insight into their genetic lineage. To do this, they manage more than 100 million family trees, 13 billion ancestral profiles, and 300 million user generated photos, scanned documents and written stories. Ancestry is by far the world’s largest genealogy site with the largest consumer DNA database.

For the last nine years, Jose Balitactac has served as Financial Planning and Analysis Applications Manager at Ancestry. Sitting between the financial planning and accounting teams, he’s the point of contact for IBM applications including Planning Analytics with Watson, Cognos Analytics and Watson. Balitactac designs, develops and manages finance-related applications that enable analysts to quickly derive insights from Ancestry’s many expansive data sets. His mission is to build tools that enable the company’s analysts to better plan, report and forecast business performance with faster, more accurate and more reliable results.

“I enable my stakeholders to get insights on the data, so they can make informed business decisions,” says Balitactac.

The applications Balitactac had been using were no longer meeting the growing company’s needs. When Ancestry moved from on-prem to the cloud, Balitactac saw it as an opportunity to look for alternatives.

“Every time we needed to run a calculation or a forecast, or to make changes in our application, we needed to bring down the system for a minimum of one to eight hours,” says Balitactac. What’s more, all users had to be ejected from the system during this downtime. This was unsustainable.

“Because we had such a large application, it took hours to do the fragmentation,” says Balitactac. “We cannot afford to bring down the system for hours so that I can add a new account or business unit.” Even before the pandemic, Ancestry maintained a global workforce spread across many time zones, so there was no convenient time to conduct these processes.Forecasting was also a challenging task. “Our forecast process was taking two painful weeks because it takes hours to make changes to the hierarchy,” he says. “We needed to move into the 21st Century. Executives need to have real-time info,” says Balitactac. “And we need to leverage AI.”

Balitactac now uses IBM Planning Analytics with Watson on the IBM Cloud for several applications, including for income statement, balance sheet and cash flow. With Planning Analytics with Watson, Balitactac can make changes in real time. “It helped a lot during the pandemic,” he says. “I can make a change now and the users wouldn’t even know it.”

Balitactac’s team started with the income statement as a test case. They built their workforce module, their revenue module, and their CapEx module. When they were satisfied that it was working, they built out more modules and started to integrate planning across their enterprise. Now they use Planning Analytics with Watson, Cognos Analytics and Watson to analyze all financial data, including budgeting, labor costs, and forecasting subscriptions and revenue, and have even started to use Planning Analytics with Watson to manage their DNA supply chain. The team also built a new data source for Cognos, and they are working on using Planning Analytics with Watson as a data source as well to deploy Cognos in the mobile app.

“The biggest benefit is that we’re able to make changes so quickly,” says Balitactac. “The ability to do “what if” analysis, to be able to see results instantaneously, is the biggest benefit. The key in any business is to be able to react quickly. You don’t want to wait one day, two days, or even several hours to make a decision. With Planning Analytics you can go in, make a change in the parameters or make a code change so easily, and users are able to see the end results.”

Before implementing these solutions, the time required to change a parameter in a model might run to an hour or more. Now the same task can be performed in a matter of seconds. While Ancestry enables its customers to look more deeply into the past, Balitactac’s application modernization efforts are helping to ensure the company has a clear-eyed vision of the future.

“Don’t compromise on your requirements,” Balitactac says. “Build for the future, not only for today.”

Learn more

More from Business transformation

How Red Hat OpenShift on AWS (ROSA) accelerates enterprise modernization initiatives on cloud, delivering business application innovation

3 min read - When it comes to driving large technology transformation on Cloud, leveraging existing investments, and optimizing open innovation within the larger ecosystem with a hybrid cloud platform, IBM Consulting™ offers several learnings to help organizations address the architecture and technology challenge.  Consider large financial services organization going through core banking modernization. The core banking application landscape involves multiple applications (both legacy and custom off-the-shelf) that are integrated and surfaced across multiple customer experiences, including mobile. The goal of modernizing such a large…

3 min read

IBM Consulting unveils Center of Excellence for generative AI

4 min read - IBM Consulting has established a Center of Excellence for generative AI. It stands alongside IBM Consulting’s existing global AI and Automation practice, which includes 21,000 data and AI consultants who have conducted over 40,000 enterprise client engagements. The Center of Excellence (CoE) already has more than 1,000 consultants with specialized generative AI expertise that are engaging with a global set of clients to drive productivity in IT operations and core business processes like HR or marketing, elevate their customer experiences…

4 min read

Turning hybrid cloud security into a profit center

5 min read - As more enterprises move to hybrid cloud environments, hybrid cloud security has become imperative to business growth. According to a 2021 study by the IBM Institute for Business Value (IBV), 80% of executives expected their organizations to operate more than 10 distinct clouds by 2023, up from eight in 2020. “The scale of most enterprise hybrid cloud deployments is so vast and penetrates so deeply that the need for an all-in security culture is absolute,” says Shue-Jane Thompson, managing partner…

5 min read

How to achieve high-impact personalization at scale with managed marketing services

3 min read - To help companies better deliver on their marketing vision and scale their marketing business processes, managed marketing services (MMS) offshore has become a fast growing trend. According to an Everest Group® study, offshore MMS centers increased over 50% from 2019 to 2022. What’s more, the number of offshore full-time equivalent employees (FTE) jumped 115%. What are managed marketing services (MMS)? Managed marketing services are the outsourcing of marketing business processes, such as campaign planning and execution, content management and enhancement,…

3 min read