Camden Asset Management needed to continuously convert accounting and trading data, pull in financial data from various sources, and distribute P&L reports to its internal and external customers. They used a mix of SQL Agent,...
Business Intelligence ETL File Transfers Financial Transactions Reporting SQLSecurities America collects daily market data from a variety of sources, processes it in several databases, then distributes customized reports to its customers. Behind the scenes, more than 10,000 jobs are run to transfer files...
File Transfers Reporting SQL
Amedisys's billing, payroll, and accounting processes required several sequences of jobs to regularly generate invoices, export electronic claims, and export information to journal entries. The jobs were managed by a custom-built scheduler that lacked advanced...
ETL File Transfers Financial Transactions Invoice Billing Reporting Software Development PeopleSoft SQL
A hospitality company had been using SQL Agent and Windows Task Scheduler to move loyalty points between their database and partner networks. The system was difficult to maintain and didn't provide visibility into the current...
File Transfers Reporting PowerShell SQLJewelers Mutual provides comprehensive repair and replacement insurance policies for jewelry. The company runs a series of critical jobs against its insurance suite and orchestrates data loads into its analytics platform and data warehouse every...
Business Intelligence ETL File Transfers Financial Transactions Invoice Billing Reporting Software Development SQL TableauAn Australian utility manages its entire load and order process for fuel oil across 23 terminals. More than 25,000 file transfers, JDE jobs, bank transfers, and ESB triggers come together daily to support critical business...
Business Intelligence ETL File Transfers Financial Transactions Invoice Billing Reporting Supply Chain JD Edwards SQLA U.S. government agency's infrastructure group was inundated with many menial tasks, and needed its complex processes to have "reliability of programming". With JAMS orchestrating each task, the agency has brought uniformity to the time...
ETL File Transfers Financial Transactions Reporting SQL
Reinhart Foodservice used various processes to distribute financial information to its distribution centers, and to send sales data reports to assorted customers. The company had previously used OpenVMS scripts (DCL) to schedule each step of...
Business Intelligence Financial Transactions ReportingWhen the University of Mary Washington (UMW) first moved to a Ruffalo Noel Levitz (RNL) net tuition discounting program, it took their team 8-10 hours a day to manually run ISIR loads through the 55...
File Transfers Reporting BannerJupiter is a fund management group, with institutional and retail clients in the UK, Europe, and the Asia Pacific region. They were using a mixture of SQL Agent, Windows Task Scheduler, ad-hoc PowerShell Scripts, and...
Business Intelligence ETL File Transfers Financial Transactions Reporting PowerShell SQL