Dr Shekhar Singh

Experience

• 

  F1F9

  Jul 2006 - Oct 2009

  Senior Financial Analyst

  Senior Financial Analysto Supervised team of junior modelers to build, maintain, update and review financial models and meet short turnaround modelling assignmentso Analyzed client’s existing financial model and understanding the specification for their new modelo Based on the above, building a bespoke financial model, from scratch and to the FAST Standardo Communicating relevant modelling and commercial issues arising from the process to the consultant in charge of the assignmento Quality controlling the model using proprietary and third-party spreadsheet analysis softwareo Visited Rotterdam, Netherlands at client site (for 1 week) to provide training, assistance and guidance in building the financial model for the cliento Conducted MODELLING101 training course for client, teaching them the basic concepts of financial modellingo Guided client in Antwerp, Belgium in building a financial model for a construction company providing transportation infrastructure in the citySelected Transaction/Project Experienceo Gas network client in Europe - developed strategic regulatory financial model in order to provide the holding company a tool to negotiate pricing and revenue structure with the regulatory body of the country and also act as a reporting tool to the rating agencies for its regular credit rating updationo European SME businesses - developed a template model with the objective of doing financialforecasting on the basis of historic monthly accounting statements (Trial Balances and Balance Sheet) to be used as operating cum reporting tool by finance managers o Hospital in Europe - converted a financial close bid model for a PFI - PPP hospital project into anoperational model to be regularly updated with management accountso European PFI projects - Valuation analysis done on group of 10 European PFI projects with theobjective to increase/improve the Shareholder’s IRR by taking out the trapped cash from the project through refinancing Show less

• 

  Ernst and Young

  Nov 2009 - Jul 2010

  Senior Analyst

  I worked as Senior Analyst in the modelling team of Transaction Advisory Services at Ernst and Young, GBS, Gurgaon. My job responsibilities involved the following:o Performed detailed reviews of Excel financial models to arrive at preliminary conclusions and prepare a report of findings in a standardized format (client-deliverable standard)o Develop advanced skills in Excel and use model auditing tools and other software packages (where appropriate)o Build or modify Excel financial models based on specifications provided by one of firm’s core modeling teamsSelected Transaction/Project Experienceo Private Equity firm in education sector: Built a financial model for a leading PE firm in educationsector in India. The primary objective of the model was to take out the trapped cash from the university trust and enhance the returns for the promoterso Strategic investor in construction sector - Reviewed financial models projecting revenues generated from proposed toll roads to be constructed in India. The primary objective of the models was to arrive at exit valuations of the projectso Conglomerate client’s investment in sporting – developed event management calendar tool tofacilitate event scheduling for a top sporting infrastructure facility in India Show less

• 

  Jaypee University of Engeenering & Technology, Guna

  Aug 2010 - now

  Assistant Professor

  Teaching• Lectured eight courses across students of all years, tutored over 30 batches over last 12 semesters. Relevant courses are highlighted below• Financial Managemento Focus – to provide students knowledge of basic concept of corporate finance, investment and financing concepts, emphasizing the financial aspects of managerial decision makingo Achievement/Contribution -§ Incorporated case studies and numerical examples aimed at simplifying learning of complexcorporate finance concepts§ Introduced Excel-based approach to enhance practicality and industry relevance of the course• Fundamentals of Financial Marketso Focus – to familiarize students with general understanding of the different functions performed by the financial markets and their role in the financial system of economyo Achievement/Contribution -§ Designed, developed and commenced this new course§ Created detailed lectures, tutorials and lesson plans aimed at enabling other faculty members toteach the class in future• Managerial Economicso Focus – to provide students with a basic foundation of economic concepts and tools that have directmanagerial applicationso Achievement/Contribution -§ Cultivated problem solving approach among students by introducing numerical approach to economics concepts§ Incorporated contemporary news items in class discussions to encourage students to applytheoretical economics concepts in real world Leadership• Consistently designed, redesigned and developed course content of four courses as per industry requirements and student feedback• Streamlined the process of result preparation and grade finalization by creating reusable excel templates• Coached one new faculty and three teaching assistants on their addition in the department• Led targeted mock interviews of students as part of preparation for university placements• Researched, analyzed and finalized the findings of feasibility study for the commencement of MBA/BBA programme Show less