Managing work on live deals for both natures: Syndicate and Bilateral.Redesigning various Loan Management Tools.Efficiently completed the Records Retention process by delivering real time data analysis on the Deal Management System.Responsible for tracking and verifying the loan documents and building the deal in Loan Origination application.Part of the Shared National Credit team under the Reconciliation project: Analyzing data from multiple sources, identifying gaps and resolving the breaks across all applications and sending it back to the respective teams for correction.Actively participate in automating the manual reconciliation breaks so that they can be integrated in the loan origination system as well during the Loan setup process.Managed the “Transaction Management Reporting” using tools like SQL and Tableau.Term Loan Amortization Project: Analyzing, verifying, and investigating the credit agreement and Facility Report determining which payment style the deal is backed by and providing various resolutions.Host Bank Project: Assessing the attributes of the Host Bank (deal level) and Bank legal entity (facility level) based on the credit agreement. Updating the booking unit and booking entity and host banks as per the investigation.KEY SKILLS - MS-Access Database, MS-Office (Word /PowerPoint)Alteryx - Designing workflowsTableau – AdministrationMS Power BI - Dashboards designingMS-Excel - Working on advanced Excel Formulas, Excel Macro, and calculated Pivot SheetsMS-Visio: Creating Process Flow MapsDesigning queries to pull data from Business Intelligence tool, BOXI.