- Scheduling assignment for one of the processes in a textile weaving plant which included combinations of machines. The boundary conditions for the problem were set by the constraints such as meeting order deadlines, adhere ...see more
- Scheduling assignment for one of the processes in a textile weaving plant which included combinations of machines. The boundary conditions for the problem were set by the constraints such as meeting order deadlines, adherence to the machine capacity, minimizing changeovers and observing inventory policy. The company had been undertaking the scheduling based on the floor manager's experience which at times led to unavailability of one of the key process components leading to loss of capacity. The solution aligned the production schedule by meeting the constraints and uniformly distributed the production to avoid changeovers as much as possible
- Optimization of Capacity Utilization and Workflow Designing for an Australian Manufacturing Start-up
- Analysis of maximum capacity utilization of the unit for different machine configurations at each process by building an optimization model. The output also included the designing of workflow and inventory for different configuration
- Network Planning for a German Renewable Energy Company
- Assisted in designing of the network which included identifying the location of Plants and Warehouses using an optimization model.
- Multi-objective Optimization for Efficient Frontier Curve and Black
- Litterman Model for Optimized Allocation of Products for a Boutique US fund
- Developed a Black-Litterman Model for a US fund which involved determination of weights of different asset classes based on risk-return matrix
- Have Designed a Tool for Scheduling of Multi-process multi-SKU production line
- The tool helps in designing the batch composition and scheduling for a batch by optimizing based on changeovers and capacity utilization
- Have designed a Multi-Echelon Inventory Optimization pilot for internal use using Metaheuristics.
• Merger & Acquisition:
- Assisted Kuwait based Investor in the acquisition of Mattress Manufacturing Unit. The assignment involved the valuation of the target, highlighting key points for the negotiation, designing the capital structuring of the new company with adherence to the local regulations and cash flow analysis for debt repayment
- A detailed merger analysis was undertaken for the Canadian Oil Drilling Instrument Company to determine the accretion/dilution impact on EPS for various target companies. It involved forecasting pro-forma financials for the merged company after taking into consideration various synergies and valuing the company based on various approaches such as Relative Valuation, Valuation based on the recent transaction in the same space and DCF. It also included sensitivity analysis of accretion/dilution for various factors such as synergies, EBITDA etc.
- Analysis of various LBOs by developing LBO model for assessment of synergies, the impact of leverages on cash flow
- Analysis of M&A deals by identifying the synergies by analyzing technology transfer, integrations, market size etc.
- Acquisition target screening of the companies in the UK construction sector for the UK based Private Equity which was followed by negotiation by the top two companies. The assignment involved in-depth analysis of the limited information of these targets and provide insights on them.
- Detailed analysis for a Canada based Asset Management Company of a publically listed Chinese manufacturing company in the pharmaceutical sector for a PIPE deal.
- Prepared information memorandum for various companies seeking buyers in aerospace, waste management, engineering, online tourism sector, automotive and industrial sector
• Real Estate:
- Real estate feasibility study model for Developers
- Built flexible models for developers to assess the feasibility of a development project. The models included various features such as cash flow management, various types of funding such as mezzanine and funds from banks and investors, flexible profit-sharing structure such as waterfall structure, various pay-off structures to maximize the IRR for the developer and Equity partner, flexible costing sheet, optimizing the funding requirement by detailed analysis of the project
• Financial Advisory and Strategy Consulting
- Consulting a Delhi based Eye Hospital Synergy Eye Care. Assisting the Company with the expansion plan and deploying requisite Digital Transformation Strategy which included revamping their current process, financial plan and technological integrations.
- Consulted SME in base oil sector. Acted as Consultant for Mumbai based base oil company assisting in restructuring of business, identified areas of process improvements which have an impact on cash flow, aligning the operations to eliminate the cash flow mismatch with key focus on improving the valuation of the company
- Prepared business plan for various start-up companies. Prepared pro-forma financial for various start-up companies which included pro-forma financial on monthly basis, detailed revenue drivers, break-even analysis, exit valuation sheets, stake estimation sheets etc
- Prepared cap table and stake calculation model which helped the Start-up's Promoters in understanding the stake dilution for the level of investment
- Provided consultancy to the SME's to assist them in devising the best strategy from financial perspective based on dynamic financial models. It also included monitoring of the company's performance as compared to milestones set.
- Debt Syndication
- Assisted SMEs in raising debt from the bank
• Research Projects:
- Competitive benchmarking studies for SME's
- Screening of top 30 Canadian listed companies based on certain investment criteria
- Buy side equity research of a Middle East Cement Company for Kuwait based Asset Management Company
- Undertaken a detailed analysis of acquisition of Satyam by Mahindra for an Indian Stock Broking Firm
Accomplishments:
• Successfully delivered on project beyond the expertise of the team by developing the desired skillset through quick learning
• Successfully delivered on projects which resulted in repeat projects and long-term client relationships
• Have catered to clients ranging from Private Equity to Asset Management Companies and Investment Bankers to Corporate
• Recognized expert in excel-modeling, acknowledged as internal consultant-trainer