|
|
|
|
|
|
|
|
 |
|
 |
|
 |
|
| InfrasoftTech recognizes the benefits that a joint technology partnership can bring to our customers. |
|
|
|
|
|
 |
|
|
|
|
|
 |
 |
|
 |
|
| OMNIEnterprise™ helps to create new business models for the dynamic financial industry by aiding 'basket product offering'. |
|
|
|
|
|
 |
|
|
|
 |
|
| We are an SEI CMMi Level 5 v1.3, ISO 27001 and ISO 9001:2008 certified company... |
|
|
|
|
 |
|
| At our Global Development Center (GDC), we continuously strive in building innovative solutions for BFSI segment... |
|
|
|
|
 |
|
 |
We are happy to assist you with the information you require |
|
|
|
|
|
|
| A leading global provider of alternative investment products & solutions |
|
|
Our client needed to enhance the existing management system to perform the Notional Capital Charge Calculation. The final calculated charges would then be exported to profitability analysis cube (PAC) for reporting.
InfrasoftTech's scope included analysis, design, build, test, implement, support & maintains the application within the defined scope of 'Capital Charge Computation & Profitability Analysis (PAC) Enhancements Programme of Work'. |
|
| Key advantages derived by the client: |
- Profitability analysis across the group, sub-groups down to the lowest level
- Consolidation of data scattered across various individual base systems facilitates full view across the board.
- Slice & dice facility enables view of regulatory capital and various exposures across groups.
- Dynamic, on-the-fly based reporting system that supports key business decision making with quality data.
- Simple and easy to use web based interfaces and dynamic report generation has drastically reduced involvement of client's IT infrastructure teams.
- Assists business managers in identifying & improving data quality issues of the source data.
|
| To understand how we can help you maximize your organisation's investment on technology, write to us at solutions@infrasofttech.com |
|
|
|
|
|
|
Over the years, our client acquired a number of systems to capture data and hence, needed a system that would pull key data from these systems spread across the group to give them useful insights on facts to analyse their profitability. |
|
| InfrasoftTech's Solution: |
- Agile Methodology to accommodate incremental requirement and incremental releases to meet the drop date.
- Standardisation of the Master Data
- Translating data feeds into the Staging Database for checking Data integrity using ETL Services in SQL Server 2005.
- Capturing and storing the data in SQL Server 2005 as Enterprise data warehouse.
- Processing the data and generating the required cubes using SQL Server 2005 Analysis service and executing reports on Business Objects XI Release 3 and Microsoft Excel.
- Partitioning of Databases and cubes to handle large data volumes.
|
|
With this implementation, our client is now able to:
|
- Generate a consolidated view of data across the group
- Perform limits monitoring, data reconciliation and overall faster reporting operations.
- Profitability Analysis across the group or any of the sub-groups drilled down, to the lowest level.
- More efficient report generation process and accurate reporting
- Lower total cost of ownership using InfrasoftTech's agile delivery model
- The solution led to identification of data quality issues in the source systems and improvements thereof.
|
|
| Technology Environment : |
|
- Business Intelligence: Business Objects XI R3
- User Interface and Administration: ASP. Net 2.0 (Language C#)
- ETL (Extract, Transform and Load): Microsoft SQL 2005 Data Transformation (DTS)
- Database: Microsoft SQL Server 2005 Enterprise Edition with 64 bit OS support
- Analytical Services: Microsoft SQL Server 2005 Analytical services
|
|
|
|
| To understand how we can help you maximize your organisation's investment on technology, write to us at solutions@infrasofttech.com |
|
|
|
|
|
|
Our client required a web application integrated with CRM system.The objective was to built a customer data management based on various territories, flexibility in customizing entities, screens and workflow (deals, opportunity, deal member, etc.), notification service by enhancing Microsoft Word mail merger service and flexibility in configuring rules & workflows. |
|
| InfrasoftTech's solution : |
- Use of Web Service to achieve Integration with different system in different Application Pool on different server.
- Plug-in registration tool development to register custom application for changing the behaviour of any entity's events or methods.
- C360 tool used to achieve customized notification service to send documents to clients.
- Deployment manager for data back up in staging or test server from production server.
- Reporting Service and Crystal Reports to generate powerful reports and deploying them in CRM report server.
|
|
| Benefits to the client : |
- One single platform to manage client
- Analysis of prospective customers and retention of existing customers
- Effective and efficient reporting
- Implementation of workflow for process flow integration
- Secured role based user and data management
- Powerful and hassle free notification service
- Integrating data between disparate systems to realise synergies
- Unified customer data across multiple business units and diverse functional systems, in order to provide reliable sources of customer information across enterprises
|
|
| To understand how we can help you maximize your organisation's investment on technology, write to us at solutions@infrasofttech.com |
|
|
|
|
|
|
Our client required to consolidate and map data from numerous systems that had been acquired over a period of time. It was essential to integrate data across groups and link them together to create an insightful fact base or profitability analysis cube. |
|
| Benefits derived by client : |
- Creating efficient on-the-fly reports as per requirements
- Flexibility in reporting and analysis
- Reduction in report generation time
- Enabled consolidated view of data across the business
- Helped in data and limit monitoring, data reconciliation and reporting operation
|
|
| Technology Environment : |
|
- ASP.NET, C#, with .NET Framework 2.0 as front-end
- SQL Server 2005-Database,DTS(ETL),Anlaysis Services (Cubes)
- Excel 2007 for Analysis using Cubes Business Objects for Reporting
|
|
|
|
| To understand how we can help you maximize your organisation's investment on technology, write to us at solutions@infrasofttech.com |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|