Business Situation
- A global financial market data provider sought an implementation partner who could transition its process while maintaining high-quality assurance and strict timeline adherence.
- The client required expert assistance for its onboarding and migration process and needed to convert Excel financial models, currently linked to outdated and competitor financial databases, to a new system.
SGA Approach
- Utilized SMEs: Engaged subject matter experts (SMEs) specializing in database Excel add-ins.
- Optimized Solutions: Enhanced solutions for client database add-ins to improve efficiency.
- Categorized Models: Organized models based on the effort required for each.
- Set ETA Targets: Established the estimated time of arrival (ETA) targets for the model completion.
- Maintained client-specific best practices by leveraging competitor terminals and Excel add-ins. Created SOPs for stakeholder coordination, incorporating decision intelligence to refine and improve the practices.
- Recorded and shared key challenges regularly. Kept a repository of models, tickers, and data mappings to reduce manual work.
- Supported client onboarding and migration efforts. Converted Excel-based financial models linked to legacy and competitor databases (e.g., Bloomberg, LSEG, FactSet, S&P Capital IQ, etc.) and linked the same to the client’s latest database product offerings.
Key Takeways
- Efficient and relevant staffing offered technical and financial database expertise.
- Implementing a flexible staffing model assisted in handling volume spikes and reducing efforts by 15%.
- The creation of a reusable repository had improved turnaround time by 10%.
- Improving ETA communication enabled the client to be informed when each model conversion would be complete within the first 24 hours of process commencement.
- Maintaining a 3-day TAT with 99% quality scores was achieved.
- Client onboarding time decreased to 3 days, which boosted satisfaction by 20% and efficiently migrated over 10,000 users.
