Prabhat Rawat
Fixed Income/Equity Research Analyst
Noida
Summary
Driven Equity/Fixed Income Research Analyst with a proven track record at S&P Global, leveraging SQL and Python to enhance pricing models and operational efficiency. Excelled in collaborative problem-solving, significantly improving data integrity and process automation. Skilled in translating complex market analysis into actionable insights, demonstrating exceptional analytical and teamwork abilities.
Overview
7
7
years of professional experience
5
5
years of post-secondary education
Work History
Equity/Fixed Income Research Analyst
S&P Global
Noida
2022.03 - Current
- Maintained daily management of securities pricing to deliver precise client valuations, while strategically integrating new transactions modeled on Intex in accordance with prevailing market trends and comprehensive analysis.
- Utilized Intex and developed pricing models based on assumptions for various securities. Collaborated with stakeholders to refine pricing strategies and ensure alignment with business objectives.
- Monitored market trends and yield curves using Market color and financial databases to enhance pricing accuracy.
- Provided timely pricing updates and recommendations to portfolio managers and traders, fostering collaboration for informed decision-making.
- Monitored and managed operational tasks related to fixed income investments and Implemented process improvements to enhance operational efficiency.
- Conducted periodic audits and reviews to ensure data integrity and accuracy in pricing and operations.
- Collaborate with development team to improve our existing product, incorporating client-suggested changes and addressing identified issues, thereby enhancing system efficiency and functionality.
- Identified opportunities to improve productivity through automation and collaborated with Data Science teams to continuously seek and learn new ways to solve problems.
- Create other documentation such as training material, process documentation, operational support documents and standard operating procedures.
Operation Analyst
IHS Markit
Noida
2017.04 - 2022.03
- Experienced professional specializing in middle and back office operations for Fixed Income, Equities, and Derivatives, with expertise as a Subject Matter Expert in GSAC, Structured Products, Money Market, Municipal Bonds, and Equities/Derivatives Products and Client On-boarding.
- Established consistent and appropriate business practices, enhanced process controls by Incident reporting management.
- Document business requirements, utilizing method that best fits business need. Analyze and gain acceptance of business requirements.
- Experience in effecting handling vendor feeds like Bloomberg, EDI, ICE, Euroclear, and Morningstar data.
- Effectively managing file delivery platform operations, research on new products to meet (potential) client's bespoke requirements and on-boarding.
- Preparation of Monthly KPI reports for senior management while analyzing all client and product usage
- Plan and execute testing for new solutions including identification of testing types, documentation and execution of test cases, test tracking. Perform root cause analysis on potential issues
Education
MBA -
Jaypee Business School
Noida 2015.07 - 2017.03
BBA -
Institute of Management Studies
Noida 2011.07 - 2014.07
Skills
SQL
Projects
Excel/VBA Tool based projects
- Engineered an Excel formula and integrated it into a VBA tool for identifying potential comparable based on color in CLO debt processes, enhancing efficiency and decision-making.
- Developed a tool to extract and compile statistics across all contracts, facilitating accurate billing information for Finance.
- Designed an Excel-based model tailored to the unique billing structures of securitized products, improving accuracy and efficiency in the billing processes.
Python based projects
- Developed a Python tool to analyze BWIC cover lists, providing insights into market trends and supporting evaluative processes to the end user.
- Automated the NAV upload and global file upload processes using Python, streamlining data management and ensuring data integrity.
- Created an challenges and coverage request automated report to monitor critical cases enhancing proactive decision-making and risk management.
- Implemented a VBA-based automation sheet to reflect price changes based on NAV movements, optimizing bulk upload processes and maintaining pricing accuracy.
Internship
Internship, Metals and Minerals Trading Corporation of India (MMTC)
April 2016 - June 2016
- Conducted balance sheet reconciliations.
- Performed data entry tasks efficiently.
- Assisted in expense management, including assessing employee expenses for approval of reimbursement.
Courses
- Python Basics
- SQL Essential Training
Timeline
Equity/Fixed Income Research Analyst
S&P Global
2022.03 - Current
Operation Analyst
IHS Markit
2017.04 - 2022.03
MBA -
Jaypee Business School
2015.07 - 2017.03
BBA -
Institute of Management Studies
2011.07 - 2014.07
Similar Profiles
Naresh KottiNaresh Kotti
Principal Software Engineer at S&P GLOBALPrincipal Software Engineer at S&P GLOBAL
Rahul DongreRahul Dongre
Closer Specialist at S&P GlobalCloser Specialist at S&P Global
Nikhil VivekNikhil Vivek
IT Associate II at S&P GlobalIT Associate II at S&P Global