Daniel Christiansen
Los Angeles,CA
Summary
Adept at leveraging Excel VBA automation and SQL data manipulation, I significantly enhanced operational efficiency by over 30% at Western Asset Management. My keen attention to detail and problem-solving skills ensured the accurate settlement of futures and compliance with regulatory standards, demonstrating a proven track record in data analysis and dashboard development.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Derivatives Settlements Specialist
Western Asset Management
Pasadena, CA
10.2023 - Current
- Developed and implemented Excel VBA macros that automated key settlement processes, reducing manual errors, and improving operational efficiency by over 30%.
- Oversaw the settlement of futures and options trades, ensuring proper allocation and reconciliation of positions in compliance with regulatory requirements and internal controls.
- Worked closely with the trading desk to ensure the accuracy and timeliness of collateral movements and margin calls.
Treasury Operations Specialist
City National Bank
Los Angeles, CA
02.2023 - 09.2024
- Processed 5,000 profile setup and maintenance requests using internal systems and industry-standard platforms with precise accuracy.
- Excelled in handling and integrating more than 10 diverse applications.
- Ensured smooth coordination in collaboration with cross-functional teams.
Data Analyst
Apex International Transportation
Van Nuys, CA
05.2022 - 02.2023
- Utilized advanced analytics tools such as SAS, SPSS, Excel PowerPivot, to manipulate large volumes of structured and unstructured data sets.
- Prepared detailed reports by collecting, analyzing, and summarizing information and trends.
- Developed dashboards with Tableau to monitor key performance indicators.
- Created data visualizations and reports for management, showcasing findings and recommendations.
- Leveraged SQL queries to extract, transform and load data into databases.
Education
Bachelor of Science - Mathematics
University of Colorado At Boulder
Boulder, CO05-2022
Skills
- Excel VBA automation
- Futures settlement
- Collateral management
- Data visualization
- SQL data manipulation
- Regulatory compliance
- Data analysis
- Dashboard development
- Attention to detail
- Problem solving
Certification
- Google Data Analytics Professional Certificate – Coursera, 2024
Timeline
Derivatives Settlements Specialist
Western Asset Management
10.2023 - Current
Treasury Operations Specialist
City National Bank
02.2023 - 09.2024
Data Analyst
Apex International Transportation
05.2022 - 02.2023
Bachelor of Science - Mathematics
University of Colorado At Boulder
Similar Profiles
John HwangJohn Hwang
Portfolio Manager at Western Asset ManagementPortfolio Manager at Western Asset Management
DAVID PEREZDAVID PEREZ
Marketing Assistant / Coordinator (Contract) at Western Asset ManagementMarketing Assistant / Coordinator (Contract) at Western Asset Management
Kenneth DesjardinKenneth Desjardin
Office Services Steward at Western Asset Management CompanyOffice Services Steward at Western Asset Management Company
Carolina RamosCarolina Ramos
Crew Member at McDonald'sCrew Member at McDonald's
ASHLEY SANCHEZASHLEY SANCHEZ
Sales Associate at TargetSales Associate at Target