Frederick Alvaera

• Involved in the Architecture Design of major projects that include

- IT Transformation to change core banking system

- IT Transformation to change the Instrument Referential System

- Design of Architecture to incorporate ESG Data in Product Knowledge Applications

- Evaluation and design for implementation of Transaction Reporting Solution

• Developed comprehensive documentation for technical specifications, project plans, and user guides, streamlining communication across teams.
• Evaluated emerging technologies to stay current on industry trends, making informed decisions for technology adoption.
• Collaborated with development teams to design scalable and efficient applications tailored to client requirements.
• Analyzed different cloud based solutions proposed to meet diverse business requirements.

- Evaluated SaaS solutions for Execution Management System

- Assessed implementation of Front Office Applications in the internal Cloud Architecture of the bank

• Broke down technical ideas and issues into non-technical terms for business executives.
• Promoted collaboration between cross-functional teams by serving as a liaison between developers, product managers, and stakeholders during all phases of projects.
• Worked with developers and engineers to realize technological solutions.
• Mentored junior team members in best practices and coding standards, fostering professional growth within the team.
• Maintained current and in-depth understanding of business processes, needs and objectives.

• Acted as Application Owner for Instrument Referential System called BVE.
• Projects managed under Instrument Referential include:

- Migration from Client Server to Web Based Three Tiered application

- Onboarding of New Sites (Taiwan, Luxembourg, Germany) into the System

- Integration of new data points from Bloomberg (eg. Prices)

- Integration of new data points from SIX Telekurs (eg. ESG data, MiFID data)

- Implementation of MiFID Risk computation within the Instrument Referential System

• Successfully managed multiple projects simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals.
• Planned, designed, and scheduled phases for large projects.
• Met project deadlines without sacrificing build quality or workplace safety.
• Established effective communication among team members for enhanced collaboration and successful project completion.
• Delivered reliable solutions by overseeing software design, development, testing, implementation, and support phases of IT projects.
• Streamlined project delivery by implementing Agile methodologies and improving collaboration among team members.

• Improved software efficiency by troubleshooting and resolving coding issues.
• Saved time and resources by identifying and fixing bugs before product deployment.
• Discussed issues with team members to provide resolution and apply best practices.
• Collaborated with cross-functional teams to deliver high-quality products on tight deadlines.

• Ensured reliable data integrity by enforcing strict adherence to organizational policies during data management processes.
• Reduced downtime by proactively monitoring system health and identifying potential problems before they escalated.
• Provided technical support during application development processes to ensure seamless integration with existing databases.
• Worked closely with developers to optimize SQL queries for better query performance across various applications utilizing Oracle databases.
• Developed custom scripts for automating routine tasks, increasing productivity and reducing manual labor.
• Utilized advanced analytical skills to identify trends in data usage patterns and take proactive measures for capacity planning purposes.
• Trained junior DBAs in best practices for Oracle database management, improving overall team performance.

• Improved software efficiency by troubleshooting and resolving coding issues.
• Discussed issues with team members to provide resolution and apply best practices.
• Enhanced user experience through designing and implementing user-friendly interfaces.
• Participated in software field testing to verify performance of developed projects.
• Contributed to a positive team environment through effective communication, problem-solving, and collaboration skills.