DATA360 AND SINGLE CUSTOMER VIEW
One of the top 5 banks from the Philippines has traditionally been reliant with branch banking and relationship management. To prepare for the onset of wealth transfer to the younger generation the bank initiated digital transformation to:
- Provide online channels through mobile banking
- Acquire digital native customers
- Offer products and services to cater to various customer segments
- Increase profitability at customer level.
The Enterprise Business Intelligence Division head under the CFO, created the project charter to modernise the data platform to cloud, ingest more data from other products, visualise using a BI tool and support digital marketing activities (cross-selling, up-selling) as well as serve top management and regular reporting requirements, including:
- Single customer view
- Single repository of customer, accounts and transactions data
- Customer data deduplication
- Cloud platform to minimize hardware footprint on premise.
Results include complete visibility on previously unknown customer portfolio and quick management response enabled by consolidated data in a central platform.
Solvento’s end-to-end consulting capability bridged the business requirement to the technical solution. With the seamless integration of numerous applications including Microsoft Stack and Syniti Knowledge Platform, we were able to simplify the process for the customer.
STAFF AUGMENTATION TO SUPPORT DATA MANAGEMENT ACTIVITIES
A payment facility company provides self-service payment kiosks and ATMs in the Philippines. A subsidiary of an Australian company that specialises in payments and ATM technology, they currently have 3,000 payment kiosks located nationwide. The customer’s goal is to provide kiosks for customers to top up to e-wallets conveniently and handle bills payments.
Reports were generated by various teams using Excel. Manual preparations have led to management’s distrust of reporting generated by various units. Unsure if values reported are correct, the customer wanted to resolve this problem fast but needed a flexible and cost-effective consultancy to help accelerate delivery of trusted data to management.
As a proven solutions consultancy with deep expertise in various applications, Solvento worked on ensuring the customer requirements were met. These included:
- Analysing the current data situation
- Designing and developing the scripts to transform the data needed for regular reporting
- Automating data preparation for management reporting (local and Australia management)
- Data profiling to identify data quality issues
- Power BI design and development
Solvento’s flexible, multi-skilled and cost-effective team accelerated the data management activities for the customer, and in doing so created value from the customer’s data.
DATA MANAGEMENT FOR BUSINESS INTELLIGENCE REPORTING
A global fast food brand has over 700 stores in the Philippines and needed to consolidate its POS data to ensure robust reporting and analysis. This meant ingestion of big volume data.
The customer asked Solvento to create data layers to support requirements for business intelligence reporting using on-premise solution of Microsoft SQL Server. This later on expanded to other projects to support: additional source systems covering back office applications, such as SAP and to prepare data for downstream applications that use the data for vendor portal and branch portal.
Solvento’s strong competency in handling complex data, our capability to understand the customer’s data even if these are unknown to the customer and robust project management practice enabled us to meet the customer’s requirements to:
- Monitor effectivity of promotions
- Consolidate data for global reporting
- Consolidate data for supplier portal and branch visibility of performance
- Support analytics team.
Our proven success has allowed us to remain with the client over the years. Working on various projects including migration from on-premise to cloud, across various source data types (database, xml, cloud-databases), and SSIS to Qlik Talend.
MANAGING SERVICES FOR ORACLE DATABASES
A municipality office in Metro Manila is among the largest local government units in the Philippines, collecting AU $600M in taxes in 2024.
The customer has two 2-node Oracle RAC database servers with many databases used as the back end of the city’s various critical services. The incumbent database managed service provider was perceived to be mostly absent in providing the necessary maintenance of the databases. This could lead to serious risk as potential downtimes would have severely affected delivery of critical government services.
Solvento’s deep understanding of Oracle database technology and solid working relationships with Oracle helped the customer avoid this risk as we were able to fix unresolved issues of the previous services provider. We were also able to stabilise the Database by conducting regular database health checks.
Consistency of service delivery has also led to a renewal of our the service with the customer.