WILFRIED YAO

• Automated Financial Processes: Utilized Python and JobScheduler to automate daily NAV (Net Asset Value) management reports for the finance team, enhancing efficiency and accuracy.
• External Client Report Encryption and Automation: Automated the encryption of client PDF reports using Python and JobScheduler, and developed an Excel macro to streamline email generation and report attachment processes for the accounting team.
• Led RPA Deployment: Developed and deployed Robotic Process Automation (RPA) in Asia, automating CRM data input and improving internal processes. Managed user creation and robot setup in UiPath Orchestrator.
• Amundi Website Data Migration Check Automation: Automated data verification tasks (NAV, dividend, time series data, etc.) between new and old company websites using RPA and Python, ensuring data integrity and saving manual effort.
• RPA Expertise: Became an RPA expert at Amundi, improving and deploying solutions to Japan users, and aiding in critical projects like the website migration for the marketing team.
• RESTful API Development: Developed and integrated RESTful APIs using Flask, enhancing data processing by connecting them with Excel macros.
• Project Management: Managed multiple projects concurrently, ensuring clear communication and consistent follow-up on development decisions across teams.
• Daily Application Support: Provided daily support for Front to Back-office applications for Tokyo and Asia users, including log analysis, code/database review, Splunk usage, project handling, and system morning checks.
• Trading Process Enhancements: Completed auto-routing for bond trading for Singapore and Tokyo desks, improving the trading process and reducing manual tasks.
• Financial Workflow Knowledge: Applied a deep understanding of trade execution and booking workflows, including the FIX protocol, to optimize financial processes.
• Technical Solutions for Business Users: Engaged business users and provided technical solutions, as evidenced by the monthly automation report for the accounting team.

Technical Environment and Tools: MSSQL DB, Sybase, Python, Java, Docker, Unix/Windows servers, FIX protocol, Citrix, CyberArk, Splunk, Job Scheduler, Control-M, Centreon, Grafana, Prometheus, Traefik

• Daily Support for Trading and Booking Applications: Investigated production issues by analyzing logs, code, and databases, and handled various projects to ensure system reliability and performance.
• Application Packaging and Testing: Conducted morning checks and real-time monitoring using Geneos and Sysload to maintain application stability.
• Change, Release, Incident, and Problem Management: Managed change and release processes, and reported incidents and problems using ServiceNow.
• Best Practices Implementation: Developed and documented best practices and procedures with Confluence and OneNote, resulting in faster resolution of common and recurring incidents.
• Problem Management Meetings: Moderated problem management meetings to perform post-incident analysis and follow up on the implementation of pending actions.
• Collaborative Team Player: Demonstrated strong teamwork skills, contributing to a cohesive and productive work environment.
• Geneos Monitoring Dashboard: Built a Geneos monitoring dashboard for the APS team in Japan, enhancing real-time system monitoring capabilities.

Technical Environment and Tools: MSSQL DB, Java, Python, Unix/Windows servers, Citrix, CyberArk, AutoSys, Geneos, ServiceNow, Jira, Confluence