Resume

Download PDF

Rohit Vijay Mangtani

Nashua, NH603.305.0320mangtani.rohit20@gmail.comlinkedin.com/in/rohitmangtani

Education

Bentley UniversityWaltham, MA
Master of Business Administration in Business AnalyticsMay 2024
Bachelor of Science in Computer Information Systems, Minor in FinanceMay 2023

Relevant Coursework: Finance and Economics | Quantitative and Statistical Analysis | Data Management | Operations

Work Experience

Royal Bank of Canada (RBC)Jersey City, NJ
Fixed Income Operations AnalystJune 2024 – Present
  • Execute daily cross-system reconciliations across multiple fixed income entities, validating transaction-level data between internal platforms and external counterparties to ensure position accuracy and control integrity
  • Isolate and diagnose funding discrepancies by extracting account-level transaction data and performing root-cause analysis across settlement, cash, and journal records to resolve breaks before downstream impact
  • Identified structural inefficiencies in daily reconciliation workflows; redesigned Excel-based templating processes to reduce redundant manual steps and improve data consistency across reporting cycles
  • Monitor trial balance variances across independent source systems, flagging anomalies that indicate upstream data quality degradation or potential control failures
  • Evaluate reconciliation processes for automation potential by categorizing workflows as rules-based vs. judgment-dependent, scoping systematic reduction of manual overhead
Fidelity InvestmentsBoston, MA
Technology Risk Analyst InternJune 2022 – August 2022 | June 2023 – August 2023
  • Enhanced data integrity across 3 platforms; uncovered 100+ inconsistencies in audit-related documents
  • Created a PowerBI dashboard enabling business units to filter and view specific controls related to their applications
  • Improved internal audit processes by tracking findings, documenting control inconsistencies, and presenting solutions to business unit leads and the audit committee
  • Gained in-depth knowledge in service organization controls (SOC) reporting and IT general control assessments
  • Placed first in paper trading competition for interns
Carbix CorporationQuincy, MA
Finance InternJune 2020 – September 2020
  • Supported Carbix's growth by creating financial models, including competitive analysis, cost models, and LOIs
  • Facilitated discussions with 10+ clients to identify partnerships and tax advantages to reduce expenditures
  • Implemented strategy to increase brand awareness for venture capitalists
Allegro MicrosystemsManchester, NH
Corporate Finance InternDecember 2019 – January 2020
  • Formulated a system to import updated foreign exchange rates from a trusted source into proprietary reports
  • Monitored reports and identified cost-saving opportunities at Allegro manufacturing facilities worldwide
  • Analyzed competitors' forecasted expenses and financial statements to highlight opportunities for improvement

Leadership Experience

Bentley Streetwear SocietyWaltham, MA
Co-Founder & Co-PresidentSeptember 2021 – May 2023
  • Directed and supervised overall operations, including educational content and member engagement
  • Organized monthly marketplace events with participation from 10+ vendors and 300+ students

Skills & Interests

Skills: Financial Modeling, Analytical Skills, Agile Methodologies, Strategic Thinking, Communication, Collaboration

Applications: Microsoft Word, Microsoft Excel, Microsoft PowerPoint, JIRA, Confluence, PowerBI, Tableau, Alteryx, Snowflake, PyCharm, Eclipse, Rstudio, MySQL, SAP, ServiceNOW, Bloomberg, Morningstar

Computer Languages: Python, R, SQL, HTML, CSS

Interests: Thematic Investing, Collecting Novelty Shoes, Music Production, Taekwondo (Black Belt II)