Edelweiss is a leading financial conglomerate providing a broad range of financial products across domestic and global geographies. It had a turnover of USD 582M in FY 2015. Edelweiss Group worked on number of acquisitions and mergers in the period 2014-2016. IT department landed up with multiple business applications. This led to inflated requirement of servers and licences. One of the things which they decided to work on was MS SQL servers and licences.
Edelweiss had a rapidly increasing customer base generating large transaction volumes across its myriad business units. Edelweiss needed efficient systems to transact, analyse and report on the data generated to effectively target their products and services. To this end they had deployed several multi core servers with MSSQL as the database engine. However, the organisation was facing bottlenecks in transaction processing and reporting and was faced with significant investments in licenses and hardware to meet current and future business needs.
The Client had invested 100+ person years of time in development 5000+ stored procedures having complex business logic. Most Stored Procedures are pure SQL and heavily uses temporary tables, complex subqueries, CTE based updates and other powerful constructs. The Client has large in-house team developing .Net and MS-SQL based applications and infrastructure management over the years. We helped them migrate to PostgreSQL on Linux and rewrote hundreds of SPs.
Significant reduction in report processing times of between 30 – 40%. No AMC and license cost for the Community Maintained PostgreSQL engine. No new hardware to meet estimated data volumes for next 5 years.