John (Jack) Mansour

• Analyze data points of asset-backed securities and mortgage-backed securities reports and forecast analytics for clients and users of Yield Book. • Manage the workflow of a critical and unique file transfer protocols (FTP) for a large data repository (Bitbucket) that consists of 5,000+ deals used to automate and expedite the processing time of securities data. • Monitor the FTP reports and analyzed data produced to identify errors. • Cross collaborative with data engineers to correct and prevent future reporting errors and present recommendations to enhance the automation process and reduce manual intervention. This resulted in achieving 90% automation for our data pipeline process. This success has shown to significantly exceed customer satisfaction. • Create data templates to request engineers to create and enhance data pipeline and existing text parsers. • Accept modeling requests from clients for securities data and initiate the retrieval of specific data from prospectus report used for analytical analysis. This results in same day modeling access for clients. • Deliver data to modelers for prospectus report. • Administer the Jira ticketing system to ensure timely resolutions of errors within data querying modules. • Utilize advanced understanding of FTP workflows to educate staff both locally and globally for London Stock Exchange Group.

• Collaborated with team to plan and execute a major product expansion project of over 70,000 industrial products, allowing for vast growth in new markets. • Used Data and assign attributes to filter out data for search by companies. • Standardized and translated product data for recently acquired items to be added to company website, leading to potential new customer acquisitions and company profits. • Responsible for revising and providing feedback to ensure Excel files are free of errors for seamless transferring of data into company website through a variety of data pipelines • Supervised two team members.

• Responsible for managing the operations of a residential living facility for disabled individuals. • Coordinated day-to-day activities for residents