Allen Troy Melo Email & Phone Number

• Drove a 99% reduction in manual processing time for Fidelity fund portfolio data by creating a macro, ensuring timely delivery of priority funds to meet monthly client requirements.• Automated approximately 80% of manual interactions in processing the Life Office Benchmark (LOB) Feed Reports by developing and implementing macros, resulting in significant time savings and enhanced accuracy in data analysis and reporting.• Developed and maintained automation initiatives, deploying 10+ macros to enhance team efficiency by 90%, while also actively debugging and maintaining automation programs within the team.• Trained analysts in the processing of monthly LOB Feed Reports, ensuring accuracy and timeliness in data handling and analysis.• Contributed to testing efforts for database/application releases, providing valuable feedback, and collaborated with the Holdings team to identify and resolve processing issues.• Maintained and updated documentation of the team’s processes.

• Contributed to clearing of China Full Holdings backlogs.• Trained and supervised analysts on processing of China Full Holdings.• Validated the accuracy of fund data received from various sources for US‑domiciled funds and ensured that this information is stored in the company's databases and is accurately reflected on its products.• Created and maintained automation tools and macros for the team that contributed to the efficiency of the team's data entry process using MS Excel and VBA.• Participated in testing database/application releases and provided feedback.• Maintained and updated documentation of the team's processes.

• Contributed to the development of Project Murdock, a critical tool aiding content analysts in reviewing deal data and preventing errors.• Collaborated with the project developers to enhance UI and implement real-time scripts.