Wrote fund-specific compliance procedures for a USD 1 billion client.
- Worked closely with BA and QA teams to refine requirements and test accordingly.
Wrote 34 flexible rule-based Sybase stored procedures for both front- and back-end
company-wide compliance purposes to replace two monolithic stored procedures.
- Procedures written to handle various complex calculations for equities, fixed-income and currencies.
- Improved morning report generation and intraday response times.
- Improved stored procedure efficiency by restructuring queries, removing temp tables and tuning indices.
- Made recommendations regarding table and query design and SQL constructs.
All database, no front-end or middle-tier. Wrote and modified complex stored procedures to perform portfolio and other valuations including fund underweight/overweight and other compliance assessments.