Resume
Download PDFRohit Vijay Mangtani
Nashua, NH|603.305.0320|mangtani.rohit20@gmail.com|linkedin.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)