Our data stories & news
Check out our latest data stories & news
#Consulting
Do you think enthusiasm can fade away?
Check out our video and watch till the end!
#DataLegacyRetention
We retained banking data (Apsys, S2i, Avaloq…) into our data legacy solution eReports. Posts Linkedin 1, Linkedin 2
#DataMigration
We migrated data efficiently, with ready to go decisions tree, mapping tables templates and quantitative & qualitative reconciliation tools
#WorkflowData #Compliance
We created business workflows to manage Compliance periodical review process and meet AML requirements (workflow, data aggregation, reporting, smoothing…)
#DataReporting #CreditMonitoring
We created operational dahsboards and reports to monitor debtor exposure (liabilities vs assets collateral, limits follow-up)
#DataReporting #Fees
We created client dashboarding to monitor fees exceptions applied against standard fee schedule and evaluate P&L impacts
#DataReporting #MIS KPI
We created KPI dahsboards to monitor the AUM, deposits, withdrawals, ROI of the clients
#DerivativesCalculation
We create derivatives margin calculation engine and automatic margin call return/transfer operations
#DataReporting #MIS KPI
We calculated all tax lots to feed a tax reporting tool within a month !
#Avaloq Migration
We ease full Avaloq data migration, leveraging our Avaloq data model expertise in 10 months…
#S2i Migration
We ease S2i Azqore full data migration, leveraging our S2i full data model expertise in few months…
#CRM Migration
We ease full CRM data migration and transformation, leveraging our Front, regulatory, legal, tax business expertises from all jurisdictions
#FINNOVA Migration
We ease full FINNOVA data migration, leveraging our FINNOVA data model expertise…
Check our Data Stories per Domain
- Design AML Process to consolidate data, score accounts periodically and meet AML requirements
- Meet cross boarder requirements
- Create Advisory proposal
- Distribute Investment recommendations
#3 Central File
- Structure address data
- Cleanse data via business intelligence
- Define Operating Data Model for complex structure
- Create a derivatives margin calculation engine
- Create a Tax Lots calculation engine
- Produce Tax reporting statements
- Create a risk debtor exposure and limits follow up
- Monitor concentration risk
#DataReporting: Compliance
Last contact
Anti money laundering checks
Movement checks
Client documents conformity and checks vs positions
Concentration checks
Tax and fiscal statement and reports
RUBIK and FATCA reporting
Fiscal exposure dashboard
CRM dashboarding
#DataReporting: Portfolio Manager
Profitability
Profitability report by manager, client, application, currency, product, retrocession calculation, budget and target comparison
Net New money
Deposit and withdrawals summary and analysis
AUM
Asset under management analysis, historical view, aggregation by manager, ...
Movements
Movement analysis
Valorisation
Detailed and historical portfolio valuation
Net New money
Informative reporting on client data
Follow-up Notes
Notepad To do
#DataReporting: Treasury & Trading
Currency rates and security prices analysis
Evolution analysis
Exposure
follow-up
Forex exposure
Limits follow-up
Bank and derivatives follow-up
Operations
follow-up
Automatic warning (emails)
Own portfolios profitability
#DataReporting: Operations
Positions reporting
Fiscal reporting
FIFO-LIFO-Average price profit and loss calculation
Multilingual
Excel export
Movements reports
Maturity list
Warnings and follow-up
Securities and exchange rates prices analysis
Update and errors checks
#DataReporting: Credits & RISK
Exposure follow-up
- Debtor exposure (Liability vs. collateral)
Follow-up and alarms debtor positions (accounts with criteria,…) - Exposure follow-up with limits (Lombard calculations, limits by products, customers,…)
- Derivative exposure aggregation with margin calculations
Checks
- Document coherence (following profile and type of position)
- Securities Lombard margins checks
- Top positions checks risks, credits, etc.
- Risks of concentration
Email and custom automatic alarms
Maturity list
- Maturity list by product
- Cash-flow projection
- Renewal checks and lists, to-do,…
#DataReporting: Financial Reporting
Online profitability
Profitability by client, manager, product, EAM retrocession calculation, budget and target comparison
Balance sheet aggregation and reporting
Account balances in value date or accounting date
Balance sheet reports
#DataReporting: External
External PMS
Automatic external interfaces
Funds managers
Automatic files and mailing production
Consolidated reporting for financial needs
CSV, Excel reporting
Currency rates and security prices checks
Warnings
Legal Reporting
Legal authority reports
Auditors
#DataReporting: IT
Coherence setup checks
Data integrity checks between systems
Automatic files and mailing production
Codification checks on clients, securities, tariffs
Ex: Errors, missing data, missing documentation
Client data identification
(FINMA 2008/21)
