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• Reviewing customer solution documents and Request for Proposal (RFP) RFP for business development and preparing a proposal and overall bid management• Creating documents for preparing bid submissions; through analysis of the RFP requirements and gap assessment to formulating the mitigation strategy • Devised a successful strategy for winning a bid, including pinpointing the unique selling points (key differentiators) of your organization, knowledge of company’s operating and profit margins and understanding the clients’ specific requirements

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• Ensured the smooth running of the Accounts Payable and Receivable Department and managed wire transactions• Developed client relationship, identified income streams & new business opportunities and accountable for timely inflow of payments and mitigating any hurdles in transactions• Drafted investment plans and asset allocation for clients by using a consultative approach to tailor investment needs of clients based on their financial situation, objectives, returns expectations and risk appetite

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.