Work Shadow
● Assisted a WTW analyst with the pioneering process automation within the investments Department for STIF entries, Position recon, Trade Costs & Matching.● Developed a robust ETL pipeline leveraging Microsoft Graph API, Microsoft Azure Functions, Apache Airflow, Python, Selenium, and FAST API to automate various tasks. These tasks included searching for files within emails and web portals, extracting information from PDFs and Excel documents, converting data into JSON and XML formats, and storing this data within a database for future use. The extracted data was then utilized for additional computations and for updating and creating various files.● Later, it was seamlessly integrated as a custom connector within Microsoft's Power Automate platform to enhance relevant workflow processes. This innovative software significantly reduced the workload for analysts and associates by automating tasks that were previously carried out manually, resulting in substantial time savings.