ROHAN LUTHRA
Monroe Township,NJ
Summary
Results-driven Sourcing and Procurement Analyst at KIRAN GEMS USA INC, skilled in data management and financial performance reporting. Proven ability to enhance sourcing efficiency and vendor relationships through strategic analysis and collaboration. Proficient in Excel and adept at problem-solving, delivering actionable insights that optimize procurement processes.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Sourcing and Procurement Analyst
KIRAN GEMS USA INC
New York, USA
12.2023 - Current
- Manage supplier payment cycles and ensure timely processing of high-value transactions, contributing to overall sourcing efficiency.
- Coordinate with finance, legal, and inventory teams to maintain audit-ready documentation and compliance with procurement policies.
- Engage with key vendors to address issues, support onboarding transitions, and improve relationship management.
- Analyze purchase trends and cost structures to identify optimization opportunities, and support strategic sourcing decisions.
- Track procurement metrics and workflows in Excel and Smartsheet, enhancing reporting and decision-making.
- Assist in cross-functional alignment for sourcing strategy and vendor transitions.
Data Analyst
BLOOMBERG LP
Princeton, USA
10.2022 - 11.2023
- Analyzed financial data trends and contributed to data classification systems that supported internal sourcing decisions.
- Utilized VLOOKUP, Pivot Tables, and internal tools to manage large datasets, ensuring data integrity and actionable reporting.
- Collaborated across departments to troubleshoot data and process issues, improving internal knowledge bases.
- Supported internal teams with timely delivery of data reports used in vendor assessments and performance tracking.
Investment Specialist Intern
MERRILL LYNCH
Pennington, USA
06.2022 - 09.2022
- Supported senior specialists in developing tailored investment strategies for high-net-worth clients.
- Conducted detailed market and investment research across equity, fixed income, and alternative assets.
- Assisted in portfolio performance reporting and provided insights to optimize client asset allocation.
- Participated in client meetings and addressed inquiries to maintain high satisfaction and compliance.
Education
Bachelor of Science - Finance
Rutgers Business School
05.2022
Skills
- Bloomberg Terminal
- Microsoft Office
- Excel
- Outlook
- Word
- PowerPoint
- Data Management & Analysis
- Financial Performance Reporting
- VLOOKUP
- PIVOT TABLES
- SQL
- TABLEAU
Certification
- Google Project Management Certification
- SIE (Securities Industry Essentials)
Skills And Tools - Technical Skills
- Bloomberg Terminal
- Reuters
- Microsoft Office (Excel, Outlook, Word, PowerPoint)
- Data Management & Analysis
- Financial Performance Reporting
- Proficient in VLOOKUP, PIVOT TABLES, SQL and TABLEAU
Timeline
Sourcing and Procurement Analyst
KIRAN GEMS USA INC
12.2023 - Current
Data Analyst
BLOOMBERG LP
10.2022 - 11.2023
Investment Specialist Intern
MERRILL LYNCH
06.2022 - 09.2022
Bachelor of Science - Finance
Rutgers Business School
Similar Profiles
VARSHA JADHAVVARSHA JADHAV
Sales Executive at Kiran Gems Pvt LtdSales Executive at Kiran Gems Pvt Ltd
ZOË BROWNEZOË BROWNE
Sales and Marketing Executive at Kiran GemsSales and Marketing Executive at Kiran Gems
Pradip VasoyaPradip Vasoya
cleaving of diamond(planning) at kiran gemscleaving of diamond(planning) at kiran gems
Dean PandolfiDean Pandolfi
Student Athletic Trainer at Rutgers University Football Athletic Training DepartmentStudent Athletic Trainer at Rutgers University Football Athletic Training Department
Sue Ann DiMaggioSue Ann DiMaggio
Food Service Worker at Pomptonian Food ServiceFood Service Worker at Pomptonian Food Service