Sudarshan Rayapati

About Sudarshan Rayapati

I’m a Business Analyst with 3+ years of experience bridging business goals and technical…

Experience

1. Business Analyst

   Morgan Stanley

   Aug 2024 — Present · OH, US

   Conducted trade lifecycle analysis across trade capture to settlement using SQL for data extraction and reconciliation checks identified process gaps and reduced trade breaks in post-trade operations. Analyzed post-trade transaction data for reconciliation and exception tracking using Advanced Excel (Pivot Tables, XLOOKUP, Power Query) improved data accuracy and reduced manual reconciliation effort by 25%. Automated exception analysis and data validation processes using Python scripting for large dataset processing reduced manual effort and improved processing efficiency. Developed trade monitoring dashboards for settlement status and KPI tracking using Power BI for data visualization and reporting enabled real-time visibility into trade failures and operational performance. Created end-to-end process workflows for Front-to-Back trade lifecycle using Microsoft Visio for process modelling enhanced stakeholder understanding and identified control gaps. Elicited and documented business requirements for post-trade system enhancements using MS Word and Confluence for BRD/FRD documentation ensured alignment between business and technology teams. Managed Agile project tasks including user stories and defect tracking using JIRA for backlog management and sprint tracking improved sprint delivery predictability and reduced defect leakage by 15%. Collaborated on trade data validation and system integration activities using Oracle Server for backend data analysis ensured data consistency across trade processing systems. Performed user acceptance testing (UAT) for trade processing workflows using HP ALM for test case management and validation ensured accurate trade settlement and reduced production defects.