Espire Optimizes Data Warehouse for Resolution of Data Overload Issues of a Global Engineering Conglomerate

Business Requirement

The existing BI Data warehouse (DWH) of the client involved multiple scheduled ETL data loads from source systems such as PRS and Workbooks. This data was then converted and calculated into multiple relational databases and the cube for retrieval within the DWH. The scheduled loads were usually run overnight and during some specific times in the day. The Insight reporting application is the reporting layer which sources the data from the DWH for end user reporting.

Business Solution

Parallel Processing of tasks on multiple queues : The existing solution offered only one processing queue that received requests sequentially. A total of four queues were implemented, each for a dedicated set of business processes: PRS and Workbook loads, Operating Model Loads, GL and Budget Uploads, and a fourth queue that can be used for all other purposes (static refresh, cube process, CRM upload and any other new processes that may be implemented)

Business Benefits

  • Better data refresh rate
  • Ability to prioritize on demand and period end processes on data processing queues
  • Synchronized data sets within the Data Warehouse
  • Separate thread of execution of different queues for different purpose of data

Download Case Study

RELATED CASE STUDIES

Delivered end-to-end product development and infrastructure management services for a leading Australian wealth management ISV

The customer required a technology partner for delivering product support, maintenance and enhancement services. Espire helped the customer maximize its geographical footprint and diversify their business by providing full spectrum product development using SOA, product testing & QA services. We assisted in product development services/ new feature development for the upcoming product versions in the latest J2EE technologies using SOA and incorporating the same to the existing application framework in Sybase/ PowerBuilder. We also provided complete infrastructure management support services for issues related to the servers, network equipment and desktops

Carried Out Automated Performance Testing for a leading South America-based BPM solution provider

The need was to improve the speed, quality and functionality of the deployed software. Espire conducted automated performance testing to analyze and emulate the environment as well as customize the scripts for parameterization and checkpoints before being executed in the load runner. The Load Runner was used for recording the test scripts with different sets of parameters, based on the customer’s pre-approved scenarios. A detailed analysis report was prepared to sum up the results of the scripts run

Developed a platform agnostic web-based application for a leading resilient hosting and connectivity services company

The customer required a strategic technology partner to design a web-based application to streamline operations. Espire designed and implemented a platform agnostic web-based application for efficient data management and reporting. The tech solution improved customer service by reducing the response time by 50%, creating greater transparency and control over cost. The re-usable automation frameworks improved employee efficiency while controlling defects and reducing financial leakage

Designed a cutting-edge n-tier Web application for a UK-based multinational bank

The need was to develop a platform with advanced reporting tools. Espire designed and implemented an n-tier web application based on advanced reporting tools and distributed systems for accessing deep insights, efficiencies and effectiveness of the sanctions screening program. The tool was able to visually portray the efficiency and effectiveness of the program as well as coverage and accuracy of these systems. It easily developed Flash-based graphical reports which provided a high level of visibility of the ongoing projects and future projections for the business

Re-engineered workflow & Print Production Management for a leading Banking Company

The customer required a strategic technology partner to mitigate challenges related to the legacy systems. Espire successfully migrated all the business data from their legacy systm, Stream Serve to Quadient for easily curating and creating new sample templates based on the changing customer behaviors. We developed and implemented a file-based processing system for automated fulfillment of dispatch and e-mailing, split output for better print load management and a comprehensive reporting system

Espires top 10 webinars for fy20 21 a win win for us our partners and customers

With FY20-21 in hindsight, in this blog, we share a list of Espire’s top 10 webinars from the past financial year that resulted in win-win for us, our partners and our clients!

How has the logistics industry reshaped in new normal and roadmap ahead

Logistics industry has been undergoing a rapid boom initiated by globalization and catapulted to new heights by new means of communication and rapid advancement in supply chain technologies. However, the new normal as we face today is shaping the logistics industry in newer ways.

Importance of ai strategy for brands in the post covid world

Tech-savvy customers, increasing digital demands, growth in digital purchases, need for speed to market and elevated customer expectations have made it crucial for brands to plan, devise and roll their AI strategy in the post COVID world scenario to both remain competitive and provide superior customer experience.

Technology trends disrupting insurance in the new normal and way forward

Content with legacy models, insurance leaders appeared as late adopters of the digital boom that has resurfaced with digital transformation and evolution of disruptive digital technologies- led by artificial intelligence, data analytics, predictive modelling, blockchain, Internet Of Things, intelligent automation and machine learning