Abhay Adil Email & Phone Number

• Support in Data and Business analysis by turning financial data into relevant insights.
• Develop various models for financial data and create MS Excel macros through VBA for automation.
• Assist in reconciling bookings and customer contract data to help produce retention and ARR reports.
• Reconcile bookings forecast to bookings actuals and understand/ resolve any differences.
• Analyze trends and other KPI metrics to help support business decisions.

• Ensuring preparation of models and designing data structures on MS Excel with dynamic functionalities
• Providing clients Excel spreadsheet cash flow models and simulating various scenarios
• Collaborating with Government Advisory as part of Program management, Urban development & bid management projects, Stakeholder Consultation, assessment and analysis for different projects
• Performing analysis of data and help execute complex transactions across all business areas such as As-Is Assessment, Gap Analysis and To-Be Research Benchmarking
• Conducting research for various projects and generated reports as per project deliverables
• Developing company valuations and financial models, preparing presentations with scenario analysis illustrations on MS PowerPoint and Excel

Gurgaon, India

• Provided valuation inputs for investment banking, operations support on the derivatives trading for one of the largest North American Investment Bank
• Managed brokerage for prime accounts for exchange trader as well as OTC trades of various securities of different asset class
• Successfully worked with different datasets and spreadsheets; processed the data into logical results by applying different analytical tools and techniques
• Designed various MS Excel templates for streaming various business processes and quick processing as well as presentation of quantifiable data to management and clients
• Processing and Automation of large set of data in MS Excel through the use of Advance Formulas, Pivot Tables and Macros & VBA
• Led reconciliation of different accounts within timelines and prepared monthly reports like Cash Flow invoices, trades and wire payments

New Delhi Area, India

• Responsible for designing banners, posters, adverts and handled promotion related activities to be marketed for the event
• Handled the event from organizing to managing activities at the venue and supervising and maintaining the website

Ghaziabad

• Reported directly to Head of Finance Department for the project involving ratio analysis from the company financials
• Gathering financial data from various sources
• Studying financial reports of the company and its competitors
• Compilation and tubulation of the gathered data
• Detailed analysis of the financial health of the company against that of the competition
• Preparing a report of the findings and presentation of the conclusion through MS PowerPoint and MS Excel.

Bba, Management, First Division

Activities and Societies: Annual Function Event Management, Debate Club

Masters Of International Business, International Business

Activities and Societies: Atharva Organizing Team, Creative Team of Marketing MeIa, Marketing Cell

Financial Markets Non-Credit Certificate, Finance And Financial Management Services, 86.2%

Special certificate course on finance and financial markets taught by Professor Robert Shiller winner of 2013 Noble Prize in Economics.