Oussama Salhi

Context: Developer within ORCA application which is providing a pricing environment for complex products to worldwide structuring and trading teams (New York, London, Singapore, Hong Kong, Lisbon and Paris).

ORCA team manages production issues, handles projects and implements users’ requests.

I have participated to new implementation tasks, change management requests, code optimization and new regulatory workflow integration.

Team tasks management:
- Manage Jira requests: assign development tasks to team members after discussion, follow up and solution validation
- Gather requirements: Work closely with users to define business use cases and identify points of improvement
- Develop new features in VBA, C++ and C#: Prioritization, requirement analysis, conception, implementation, tests, deployment
- Change management: reviews, code integration and software releases
- Colleagues training and support in apprehending internal libraries

Interfacing new payoffs and adding new features:
- Gathering requirements from users
- Liaise with R&D team to get the technical specification of the payoffs and UAT servers for testing purpose
- Liaise with the booking application team to validate the booking model
- Proposition and validation of the interface with the users
- Implementation and testing
- Demonstration, training and validation with the users
New payoffs interfaced: Bond repack, multi vanilla strategy
Payoff updated: Variance swap, Autocallable, contract spread
New tools: CPS backtesting, CPS backpricing, Regulatory tool

Enhancement of user experience and continuous improvement of existing components:
- Improve the application speed: accelerate market data insertion, review of the architecture
- Stabilize the custom Excel Ribbon
- Reduce excel crashes when there are multiple ActiveX objects in the workbook
- Add autosave feature
- Office 2016 migration: tests, corrections, enhancements
- Stabilize and optimize old components
- Internal libraries improvement (C++, C#)
- Rapid intervention for support requests

Regulatory workflow (MIFID2, PRIIPS, 871m, CFTC Reporting, SOTUS):
- Contribute to the conception and implementation of the new design in order to simplify the workflow (MIFID2, PRIIPS, 871m)
- Integrate new regulations to the workflow (CFTC Reporting and SOTUS): Gather technical requirements, liaise with impacted teams to define a release planning, implement the solution in VBA and conduct the workflow tests
- Code review and proposition of improvements

Results: Better user experience with ORCA due to an enhanced performance.
Financial environment: Structured products (X-asset), regulations (MIFID2, 871m, TRUST, CFTC, SOTUS)
IT environment: Excel VBA, T-SQL, C++, C#, Git, Gerrit, Jira, Jenkins, Visual Studio

Context: Worked as a business analyst for a KPI automation solution for which I have successfully delivered the final dashboard in Tableau Desktop and a tactical solution to extract data from internal booking systems.

I have also successfully coordinated 4 business experts during an ECB audit mission and have reported at weekly basis the mission status to top OPER management.

Role 1: Business analyst – KPI production automation – Feb 2017 to Dec 2017
- Organize workshop sessions to gather requirements: business rules, analysis axes, data sources, filters to apply
- Produce functional specifications: adding new data sources, implementation of business rules in the tactical extraction tool
- Liaise with dev teams to get a cost estimation and provide estimation for the DataViz part for each stream
- Prepare a delivery planning and communicate to management
- Test and validation of deliverables: test of consistency, non-regression tests in Python and VBA
- DataViz: Visual restitution in Tableau Desktop: template conception and validation with users
- Users training: Extraction tool training, Tableau Desktop training sessions
- Proposition and development of tactical solutions in Python and VBA

Role 2: Single point of contact (SPOC) for OPER department during an ECB supervision mission – Jul 2017 to Dec 2017
- Coordinate a team of 4 SPOCS: Assign tasks, ensure that all tasks are done on time, conduct the weekly meeting to share information
- Meetings organization
- Identification of contacts
- Follow up on supervisors’ requests
- Information centralization and participation to the synchronization meetings with PMOs
- Report the progress to the management (weekly report)

Results: I have successfully delivered the final dashboard in Tableau Desktop and have trained the end users to how to update and manipulate it. I have also successfully coordinated 4 business experts during an ECB audit mission.
Financial environment: Middle – Back office interactions
IT environment: Ms Office, VBA, Python, Tableau Desktop, SG applications

Context: TSU MOD team is responsible of controlling exotic products and validating booking schemes.
As a team member, I have participated in daily production tasks and I was responsible for processes automation.

Responsibilities:
- Development of competing warrants control macro in VBA
- Development of KIKO macro in VBA: requirement analysis, design, implementation of a POC, validation by the management, implementation of the solution, tests, users training
- POC for PDF parsing: test of PDF::API2 module in Perl, PyPDF2 and PDFMiner in Python
- Reports automation in VBA: Morning report, Pending actions report, Errors statistics
- Macro optimization
- Creation of macro procedures and user guides
- Development of internal tools in VBA: massive import of booking, massive import of referential data
- Control of booking schemes (issuance deals, maturity deals, cancelation deals) and matching between booking and economics data from the TS
- Structured products pay-off validation in SG internal system: control of LDP code, control of economics data, liaise with FO and TSU to correct booking
- Control of new scripts and proposition of corrections to FO
- Participation to the training of colleagues from Bangalore who have taken a part of activity to India

Results: Automation of internal processes which have reduced the overall workload
Financial environment: Structured products
IT environment: Ms Office, VBA, SQL, Python, Perl, XML, UML, SG applications and internal APIs