ROHEL PANDEY
Pune
Summary
Results-driven Associate 2 with experience in Futures & Options (Exchange-Traded Derivatives) settlements, reconciliation, and data reporting. Strong understanding of trade lifecycle, settlement processing, and operational risk controls, with proven ability to manage high-volume transactions with accuracy. Skilled in Advanced Excel and data analysis, with additional knowledge of Python for data handling and automation. Seeking opportunities in Investment Banking Operations / Trade Support / Middle Office roles.
Overview
7
7
years of professional experience
6051
6051
years of post-secondary education
Work History
Associate 2
State Street
Pune
05.2022 - Current
- Executed end-to-end settlement processing for Futures & Options trades, ensuring accuracy and timely completion.
- Performed daily reconciliation of trades, cash, and positions, identifying and resolving breaks within SLA timelines.
- Investigated and resolved settlement discrepancies by coordinating with internal stakeholders and support teams.
- Ensured high levels of data integrity, validation, and operational control compliance.
- Managed high-volume transactions efficiently while maintaining >99% accuracy (process-driven).
- Supported process improvements that enhanced operational efficiency and reduced manual effort
- Utilized Excel Macros/VBA to automate reconciliation and reporting tasks, improving efficiency and reducing manual effort.
Operation Ex.
Udaan(via Fretus Folks India Pvt Ltd)
Bangalore
07.2021 - 12.2021
- Completed day-to-day duties accurately and efficiently.
- Performed data analysis using Advanced Excel (VLOOKUP, XLOOKUP, Pivot Tables).
- Developed and maintained MIS reports and dashboards for business and operational tracking.
- Managed large datasets ensuring data accuracy, validation, and consistency
Python Developer Intern
Maxgen Technologies Pvt.Ltd
Pune
05.2019 - 07.2019
- Gained hands-on experience in Python programming for data analysis and automation.
- Worked on basic projects involving data manipulation, file handling, and logical problem solving.
- Learned fundamentals of data structures, loops, functions, and scripting for process efficiency.
- Applied Python concepts to improve data handling and analytical thinking.
Education
B.Tech - Computer Science Engineering
AKTU
LucknowSenior Secondary -
I.S.C Board
Higher Secondary -
I.C.S.E Board
Skills
Derivatives & Operations:
Futures & Options (ETD), Settlements Processing, Reconciliation & Controls, Clearing & Settlement, Exception Handling
Reconciliation & Risk:
Cash / Position / Trade Reconciliation, Break Investigation & Resolution, Data Validation, Operational Risk & Controls, SLA Management
Technical & IT Skills:
Advanced MS Excel (XLOOKUP, VLOOKUP, INDEX-MATCH, Pivot Tables), Data Analysis, MIS Reporting, Data Cleaning, Python (Basic), Reporting Automation
Professional Competencies:
Analytical Thinking, Problem Solving, Attention to Detail, Stakeholder Management, Time Management
Accomplishments
- Awarded for managing high-volume fund processing with speed and high accuracy.
- Maintained ~99% accuracy in settlements and reconciliation in a high-volume environment.
- Ensured timely break resolution within SLA timelines, improving turnaround time.
- Best Team Award by Onshore Clients
Tools And Applications
- Citrix Apps: On Demand ETD, MCH, Fax Server, Bloomberg, IMT, DHUB, PyCharm,
- Reconciliation: Trades and cash margin booking and resolution tools, Microsoft 365 Copilot
Languages
Hindi
Proficient
C2
English
Advanced
C1
Marathi
Elementary
A2
Timeline
Associate 2
State Street
05.2022 - Current
Operation Ex.
Udaan(via Fretus Folks India Pvt Ltd)
07.2021 - 12.2021
Python Developer Intern
Maxgen Technologies Pvt.Ltd
05.2019 - 07.2019
B.Tech - Computer Science Engineering
AKTU
Senior Secondary -
I.S.C Board
Higher Secondary -
I.C.S.E Board