Gaurav Sehrawat work email
- Valid
Gaurav Sehrawat personal email
I have Completed MBA from IBS Gurgaon in Finance with Analytics. I consider myself an analytical, challenge seeking person who uses a logical approach to solve the problems.I believe in my capabilities and best utilized in a collaboration and innovative place that blends out of box thinking with a practical approach to everyday business problem.I have keen interest in financial industry that can provide exposure across various industry and help me grow professionally .I have been awarded three times consecutive for the best performer in my department . If you believe I could be a good fit for your organization , Please reach me to me at gsehrawat16@gmail.com
Jones Lang Lasalle
-
Senior Financial AnalystJones Lang Lasalle Nov 2020 - PresentIndia Remotely Transitioned financial tasks from seven clients of JLL. Managing Financial data for more than 1500+ properties including offices in US and Canada. Provided financial expertise to three different projects. Looking over the activities of two associates who works along with me. Maintaining trackers like cash log, funding log and JE log to keep a track of our monthly and daily activities forend-to-end reporting. Keeping track of all the fundings received through CashPro (Bank of America) for timely Vendor payment(Check runs). Preparing bank reconciliations for all the accounts on timely basis. Booking regular Journals like AR, ACH receipts, revenue, intercompany reclasses, Monthly accruals etc. Worked on Yearly and monthly budgets and forecasting. Prepared Monthly and weekly payroll and overheads allocation Monthly meeting with Facility Managers to discuss open issues over the site. Completed balance sheet reconciliations on timely basis to successfully complete the month end closure andyear end closure Calculating JLL’s Management Fee as per the MSA with the client. Preparing Monthly dashboard depicting GL progress over the month and presenting it to JLL leadership. Performing quality check by picking few accounts as sample for internal audit purposes. Organising team engagement activities during lean period of the month. Training sessions for new employees on various accounting tools and process flow. Working on lean ideas using advance excel and Alteryx Designer.
-
Equity Research AnalystAranca Mar 2020 - Apr 2020Gurgaon, Haryana• Prepared financial models (FMCG, NBFC, and Banks) with special reference to capital structure and pro forma adjustments.• Preparing industry presentations and sector reports.• Direct interaction with clients to provide Adhoc support on variety of requests.• Analysis of IS, Balance sheet, and ratios. -
Financial AnalystJmarathon Advisory Services Pvt Ltd Feb 2019 - May 2019Chennai, Tamil Nadu• The aim is to help the investors (Current & Potential) understand the impact of important happening on the International Forex markets fluctuations.• To capture the trends, similarities and patterns in the activities and movements of the FOREX Market. -
Financial AnalystAmerican Express Mar 2015 - Nov 2017Gurgaon, Haryana• Reconciled Sub ledger and general ledger account of prepaid products that result from Traveler’s cheque & Gift cards and received recognition by clearing out $96k aged items from sub ledger account.• Succeeded in minimizing write off losses to unresolved exceptions on seller accounts, collecting on funds due on American Express for settlement, and reconciling exceptions and got recognition for managing NIL write off and saved $24.5k exceptions in account.• Prepared the documents for all the internal and external SOX (Sarbanes Oxley) audit checks.• Successfully done monthly/quarterly closures of US Client accounts as per reconciliation policy requirements.• Assisting manager for quality check, presentations preparations, minutes of meeting and other control matrices.• Focused on Customers and Clients by addressing changing needs of the selling partners for inventory control and follow-up with Sellers and CLMs to collect the funds due to American Express & resolve the monthly exceptions assigned.• Provided training sessions to the new hires and employment engagement activity sessions for the team members.
Gaurav Sehrawat Education Details
-
6.8 -
Finance, General
Frequently Asked Questions about Gaurav Sehrawat
What company does Gaurav Sehrawat work for?
Gaurav Sehrawat works for Jones Lang Lasalle
What is Gaurav Sehrawat's role at the current company?
Gaurav Sehrawat's current role is MBA|(Finance), IBS Gurgaon, Senior Financial Analyst in JLL.
What is Gaurav Sehrawat's email address?
Gaurav Sehrawat's email address is ga****@****jll.com
What schools did Gaurav Sehrawat attend?
Gaurav Sehrawat attended Icfai University, Delhi University.
Not the Gaurav Sehrawat you were looking for?
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial