Summary
Overview
Work History
Education
Skills
Projects
Awards Recognition
Languages
Timeline
Generic

Prathmesh Relekar

Pune

Summary

Detail-oriented, and technically skilled, Analyst with proven experience in managing and maintaining accurate, consistent security master data across enterprise systemizing, validating, and reconciling security master records, with strong knowledge of financial identifiers including ISIN, CUSIP, and SEDOL. Adept at ensuring data quality through rigorous validation processes, identifying discrepancies, and implementing effective resolutions. A strong collaborator with the ability to support diverse stakeholders, including portfolio managers, and risk teams. Recognized for a high level of accuracy, analytical thinking, and a strong commitment to data integrity.

Overview

3
3
years of professional experience

Work History

Analyst

Hexaware Technologies Pvt. Ltd
Pune
07.2022 - Current
  • Created and maintained security master records, ensuring consistency across enterprise systems.
  • Validated trade settlement data using CUSIP and ISIN to support accurate and compliant reconciliation processes.
  • Developed complex SQL queries and automated workflows using Power Query, reducing manual effort by 40%.
  • Collaborated with cross-functional teams (traders, portfolio managers, and risk units) to resolve data discrepancies.
  • Conducted risk-based reconciliation and ensured data compliance with internal/external regulatory frameworks.
  • Spearheaded strategic initiatives that boosted operational efficiency and accuracy by up to 55%.

Education

MBA - Business Analytics, Finance

Savitribai Phule Pune University
Pune
03-2021

BBA - Finance

Savitribai Phule Pune University
Pune
03-2018

Skills

  • Security Master Data Management
  • Financial Instruments: Bonds, Debentures, Derivatives, and Shares
  • Global identifiers: ISIN, CUSIP, SEDOL
  • Capital Markets and Trade Reconciliation
  • Portfolio Data Validation and Risk Control
  • Financial Systems: Hyperion, Worldview, ITA Advantage
  • Advanced Excel and Power Query
  • BI Tools: Power BI
  • SQL Development and Process Automation
  • Data Quality
  • Data Governance
  • Database: SQL
  • Data Tools: Power BI, Power Query

Projects

Brown Brothers Harriman & Co. (BBH) Data Statistics Project

  • Implemented an automated solution to analyze extensive financial datasets
  • Leveraged Power BI to create comprehensive monthly reports that summarized all data inputs received and processed throughout the month, along with their respective timelines
  • These reports provided stakeholders with a clear, visual overview of completed work, and highlighted potential problem areas, facilitating data-driven decision-making and process optimization
  • Enhanced operational efficiency by 55%, minimized manual effort by 46%
  • Improved SLA accuracy by 45% and empowered senior management to make data-driven decisions, and forecast future trends effectively

Pending Action (PA) Cases Dashboard:

  • Created and maintained the dashboard for PA (Pending Action) cases
  • Optimized the pending action resolve rate from 4.97% to 50% by providing data-driven insights and recommending daily case prioritization strategies, resulting in a 17% SLA improvement

Goldman Sachs activity

  • Enhanced operational efficiency by automating processes, significantly reducing manual intervention, and improving overall accuracy and reliability
  • Increased the accuracy rate by 20% for Goldman Sachs' Reclass Activity

Awards Recognition

  • Automation Analyst Award – For outstanding automation initiatives
  • Star Performer Award – Top performer for driving team objectives
  • Brain Box Award – For transforming sensitive BAU activity and reducing errors

Languages

  • Hindi, Native
  • English, Proficient

Timeline

Analyst

Hexaware Technologies Pvt. Ltd
07.2022 - Current

MBA - Business Analytics, Finance

Savitribai Phule Pune University

BBA - Finance

Savitribai Phule Pune University

Similar Profiles

CREATE PROFILE
Prathmesh Relekar