Mayank Aggarwal Email & Phone Number

Delhi, India

New Delhi, Delhi, India

Gurugram, Haryana, India

Gurugram, Haryana, India

New Delhi Area, India

Capital Markets - Fund Raising / Project FinancingEvaluate transaction requirements and liaison with investors to facilitate funds disbursement. Built complex financial models to raise funds from Capital Market for ongoing/ new projects as well as Information Memorandums for Project FinancingStrategic Analysis - Cashflow Requirement, Product Pricing, Inventory Liquidation, Sales offers etcCollaborate on the design, development, maintenance of key metrics, reports analysis, and dashboards to drive key business decisions. Cross-functional coordination across various verticals such as Finance, Sales, CRM, Marketing etc

• Transitioned New Business for COE – “Blackstone – REIT (US) Valuations and Reporting Process”• Pitch Decks, Valuation Models, Financial Reporting monthly and quarterly review cycle.• Build a New Team - Training and Aligning resources to Valuations and Reporting Process.• Formulated transformation Timeline and Progress Tracker for efficiency and decision making. • US and India - Reporting process synchronization | Stakeholder Management and Coordination.

Gurgaon, Haryana, India

Focus on delivering transaction advisory services and provide credit capital solutions and seed funding to our clients. Exclusively assist the Client in negotiating key commercial terms and entering into a Term-sheet with identified Developers/Investors for the proposed acquisition of the Project. ( DM| Sale Deed| CMA | POA | ROW etc.)1. Co-ordination in conducting the Due Diligence process.2. Facilitating deal closure on the terms and conditions specified hereinAlsoBuilding Information Memorandums and Cash-flow Schedules - Private Equity Transactions for Capital Markets(Residential and Commercial Projects) including Joint Ventures(Group Housing Projects and Corporate Towers) and Asset sales (Retail Malls and Land Deals).

Gurgaon, Haryana, India

Proficient in building and testing complex financial models using VBA scripting.-Modeling deals on structured finance workstation tool :- Focused on Credit Funds for Real Estate and Private Equity projects.-Building waterfall models for Fund Accounting projects for reconciliations and identifying data breaks.-Identified differences and reconciled supporting schedules to system reports.-Designed work flow and data reconciliations models for multiple funds targeting automation and minimizing data breaks.-Identified issues in Niagara(in house waterfall application) and recommended enhancement to improve efficiency by testing new enhancements and calculation models.- Worked with top management and helped in process improvements to come to a more efficient and controlled solution.

New Delhi Area, India

Gurgaon, India

Live Project:Technical Integration of Finance Functions Related to Debtors and Inventory Management • Identified operational errors in payment and vendor management : designed SOP’s and implemented improved processes• Cleared backlog as old as 6 months with 100% accuracy including resolution to multiple pending cases and defaults. Other domains- Operational Efficiency improvement, Category Expansion and New Product Development, Corporate Alliances.

Gurgaon, Haryana, India

Worked on multiple projects as per business needs:-GRANT PROPOSAL FOR NEW TECHNOLOGIESPinTwin – United States – India Science & Technology Endowment FundIamATM – Millennium Alliance FundCreated proposal based upon in–depth discussions with stakeholders and business heads, for better understanding, we used innovative methods to explain the idea and implementation of technologies in grant proposalINVESTOR MAPPING Using "Pitchbook" database – Analysis of US markets Growth investors –Fintech Industry ExposureMIS RESTRUCTURING Problem – System has become inefficient in revenue and cost management as multiple overlapping products have been added to portfolio in past few yearsSolution – Restructured MIS To map direct and indirect cost with the respective department and products.

New Delhi Area, India

New Delhi Area, India

Requirement gathering and client servicing.• Interpreting client change requests and asking in-depth questions to fully extract details about all special or edge cases.• Consolidating client requirements with technical team feedback to help arrive at final System Design and UI Design decisions.Others – task routing, updating client tracking system, functional error mapping and improvements.

Master Of Business Administration (Mba), Finance And Financial Management Services

Bachelor Of Business Economics, Finance And Financial Management Services

Financial Markets

TECHNICAL ANALYSIS. FUNDAMENTAL ANALYSIS,PATTERNS,OPTION STRATEGIES, VOLATILITY, INDICATORS,CONSUMER DEMAND ETC

Student Actuary

CLEARED CT1 FINANCIAL MATHEMATICS CT7 ECONOMICS STUDIED CT3 PROBABILITY AND STATISTICS CT4 FINANCIAL MODELS CT5 CONTINGENCIES CT6.

Financial Mathemetics, Banking, Corporate, Finance, And Securities Law