Pavithra S

PROJECT NAME: US MUTUAL FUND

DURATION: Jan 2022 – Apr 2022

• Conducted in-depth research on share market trends and gathered organizational documents for analysis using SQL and Advanced Excel.
• Maintained and updated records of corporate actions (mergers, dormancy, acquisitions) impacting futures and options contracts, ensuring data accuracy and compliance.
• Collected and reconciled dividend distribution details for corporate actions from signed-off companies using SQL queries and Excel functions such as Pivot Tables, VLOOKUP, and Macros.
• Performed statistical data analysis and applied Root Cause Analysis (RCA) techniques to identify and resolve discrepancies in corporate action data.
• Automated data validation and updates through SQL scripts and Excel automation, enhancing efficiency by reducing manual intervention.
• Investigated anomalies in company databases using RCA, identified root causes, and implemented corrective actions to ensure data consistency and reliability.

PROJECT NAME: DERIVATIVES

DURATION: May 2022 –Dec 2022

• Designed and maintained an advanced Excel-based database for derivatives contract specifications, leveraging tools like Pivot Tables, VLOOKUP, HLOOKUP, and advanced formulas.
• Automated daily data extraction and updates from exchange websites using Excel macros and conditional formatting.
• Managed key contract details, including instrument type, delivery levels, strike prices, expiration dates, ISINs, contract sizes, and units, ensuring data integrity and accuracy.
• Utilized advanced Excel functions for data validation and trend analysis to ensure compliance with derivatives market standards.
• Produced dynamic reports and dashboards using Excel charts and Power Query to visualize key insights from contract specifications.