Every night for several years, the five Latin America offices of Mich.-based medical technology products manufacturer Stryker Corp. were forced to burn the midnight oil to turn their daily financials into a single consolidated report. Each office has its own independent ERP system, so the process required three hours to compile the data for each territory plus another 90 minutes for a financial analyst at division headquarters to merge the five spreadsheets into one document. The upshot: nearly 18 hours of late-night labor that sometimes lasted past 11 p.m.
In 2004, IT managers at Stryker Latin America automated the entire process without the expense of writing code. Instead they used a drag-and-drop business process automation software program to set up the automation routines necessary to eliminate the drudgery.
Five Offices, Five Systems
Stryker is the 12th largest medical technology company in the world, with the majority of its business coming from orthopaedic products ranging from powered surgical tools to joint replacements. Stryker Latin America has offices in Argentina, Brazil, Chile, Mexico and Florida. Like the company's 11 other divisions, it must submit consolidated daily financials for review and analysis by country managers, regional vice presidents and financial executives.
The fact that each of Stryker Latin America's five offices maintains its own independent ERP system complicates the task considerably. None of the five systems are connected, and no direct link is possible because each office runs a different version of QAD's MFG PRO software. Instituting a new data collection program would be time-consuming and expensive. So would developing an automated solution in-house.
Initially, therefore, accounting personnel in each office physically logged into their local ERP system at the end of each business day, collected the necessary data, assembled it into an Excel spreadsheet, and emailed it to a sixth person for aggregation into a single report reflecting the division's overall performance for the day. This manual process was repeated night after night until George Sarabia, Regional IT Director for Stryker Latin America, decided to investigate other ways of getting the work done.
Automatic Pilot
Automation was clearly the cure for the division's late-night woes, but Sarabia rejected the option of assigning the work to in-house developers or outside contractors for two reasons. First, he estimates it would have been a 16-week job, including three weeks of writing and testing custom scripts for each country plus another week for writing a program to combine the spreadsheets. Second, he didn't want to add script maintenance to his staff's workload. "Supporting custom scripts can become a burden," he noted, "especially if there are changes in the IT team."
View article on one page