Assistant Manager
Taiwan
build a mini treasury solution for TRF/Pivot fx derivatives:- using Excel VBA for trade capture, and store data in PostgreSQL.- calling NumeriX CrossAsset for pricing and scenarios testing.- incorporate trade ticket and pricing result into Kondor system which does not support derivative like TRF using decomposition to fit option cash flows.Involed projects:- introducing Murex to subsitute Kondor: - Curve Building, Market Data and Referencing Data, linked to Reuters data source - Generators: Set DayCountBasis, Day Rolling, Convntions, Market configuration for Cash Flow generating in Murex. - help back office to verify interest calculations. - help font office to design TRF trade capture. - help IT to fetch data for compliance and reporting.- introducing NumeriX to pricing exotic financial derivatives: - modeling FX(TRF, DKO), IR(DCI, IRI) derivatives under Numerix Cross Asset. - cross check counterparts' MtM report for model calibration. - integrate with EOD process to fit trade workflow.- Enhancement of EOM process routines:- daily MtM for financial products and derivatives.- limit control and alert for all FX/IR position.- Basel III reporting.- back testing, scenarios testing.- reconciliation in accounting for position and P/L.- middle office workflow enhancement: cron jobs and batch reports (using VBA/Ruby language)