Noopur Sinha

Noopur has successfully delivered key engagements displaying a sustained energy and determination in the face of obstacles to set and meet challenging targets, in compliance with quality, time and diversity standard.

Key projects include:

• Pre and post deal synergies analysis for one of the largest integration of two companies in UK: Forecasting post deal cost and revenue synergies and value creation analysis of cost to achieve. Areas of deliverable included development of robust integrated models to capture cost synergies, revenue synergies, FTEs and cost to achieve from submitted business cases of fourteen workstreams (like IT, Finance, HR etc.), development of automated tool for benefit tracking, and updating of client models for smooth and accurate shifts of baseline cost and FTE by each workstreams between the two companies. Noopur managed the project directly with onshore team and end client and deliverables were instrumental in delivery of the synergy programme over the 5 year period
• Performance Transformation for innovative athlete product company : Led the engagement to provide assistance in managing client's cash cycle as the business came to standstill and evaluating the immediate impact of a variety of possible operational, financial and strategic decisions on their cashflow needs
• Performance tracking of mortgage portfolio for UAE client : The client wanted to track the performance of their mortgage portfolio and make key decision regarding the securitization / sale and purchase of the mortgage portfolio. Developed a very detailed model that covered operational forecast (for 25 offices and then consolidating it to region and country level), portfolio view, detailed financial statements and a decision management platform to support key decisions around securitization. With the tool, client got the flexibility to monitor the performance of each tranches in a portfolio (Total of 10 portfolios), by regions (5 regions), branches (with 5 branches for each region) and each product category
• Noopur also has ~5 years of experience in healthcare modelling where she led and delivered multiple engagements working with UK NHS trusts and CCGs. She has worked on numerous assignments related to strategic demand / capacity models and LTFM (Long term financial models) for NHS. Noopur was at client's location for 6 weeks in the UK for one of the healthcare sector project
• UK County Sustainability & Transformation Planning: Led one of the large engagements with UK county for building an integrated forecasting tool to produce a Sustainability and Transformation Plan (STP) for the county's health and care economy – that set out the measures required for the system to achieve clinical and financial sustainability in the short to medium term. The tool enabled to quantifying the impact of the Activity transformation initiatives, applied using Intervention tool and make decisions to improve financial performance in the short, medium and long term. Developed System Model that helped the client to view consolidated performance view of all the provider models (22 Trusts) and CCGs (12 CCGs).The demand, capacity and cost analysis provided decision makers with the assurance and confidence that any changes they make will have the impact they intend
• UK County's Health & Economy Long Term Financial Analysis : Led the engagement in building a LTFM (Long term financial model) for Mental Healthcare Trust in UK to support the development of a joined up and agreed plan of action to place a Trust's health system on a sustainable footing. The model was used for forecasting Activity, Income & Expense position, capacity, cash position and preparing Integrated Financial statements
• Workforce Analysis and forecasting for NHS trusts: Managed the development of workforce analysis model to forecast ten years of workforce requirement for two trusts by five core delivery areas - ward staff, theatres staff, outpatients' staff, specialty staff (non-geographically specific) and departmental staff (non-geographically specific). The model allowed for up to 40 unique job roles across these areas and specialty staff for up to 40 specialties. Very detailed user friendly dashboard and detailed overlay was built in the model which served as a platform to allow the hospitals to determine bed numbers, surgical procedures, and outpatient appointments, and use these three areas as the core drivers of growth in workforce requirement
• Performance assessment for Entertainment and Leisure sector client: Holding company wanted to understand operational forecast of financial statements at group as well as 10 Operating companies level. Led and delivered highly flexible model to provide flexibility to select centre as franchise / ownership and take key decision by monitoring the exit year valuation at different years. The assignment was managed with constant interaction with end client
• Financial Feasibility Analysis : A detailed feasibility analysis was performed for a client intending to enter into retail market in Qatar. Supported to develop a very detailed financial model, analyzing various scenarios like Purchase or Rent model, High-end or Mid segment, multiple working capital scenarios, detailed revenue, cost, capital expenditure and financing calculations, and interactive dashboard
• Autonomization of public hospitals in Cyprus : Led the development of forecasting activity, capacity and finance models for the public hospitals of Cyprus, as part of the wider autonomisation project to define and apply appropriate methodologies in order to establish the cost of individual inpatient and outpatient services offered across the island on the basis of actual costs
• Feasibility Analysis and Business Planning for KSA client : Led and managed the development of detailed integrated business planning model for establishment of new Autism rehabilitation centre in KSA
• Transaction Modelling for Pub and brewery sector UK client: Led and developed detailed analysis of existing business at consolidated as well as at each division level (Five divisions - Pub, Brewing, Wholesale, Retail and Tobacco) and different geographies and analysis for acquisition / disposal of new pubs. The calculations were detailed to analyze Revenue, Cost, Capital Expenditure and working capital for multiple business divisions and geographies at individual pub level (Approx 80 Pubs). Dashboard and sensitivities calculation were built to see the impact of any future acquisition of individual / portfolio Pub. Model had functionality to view all the business lines (in various geographies) together & helped in making key decision in potential sale and acquisition of the business
• Extensive experience in managing and delivering model reviews across sectors and geographies: Delivered and managed multiple detailed arithmetic cell by cell review, macro review and stress testing of a simulator tool for pharmaceutical company, mathematical reviews, stress testing and document review in real estate, retail, education, healthcare, infrastructure and oil and gas sectors with challenging timelines.

• Shell Account (SH UI SPEED MODELING SUP)
• Worked on the financial model enhancement for the Nigerian Oil & Gas Company. Building of Financial model from scratch for Egypt Oil & Gas Company
• Roles & Responsibilities:
• Financial Modeling
• Supporting the users
• Enhancing the changes in the models
• Tax Models based on country Fiscal regime
• Proven aptitude in analysis of the Cash Flows,
• NPVs (Net Present Value) and IRRs (Internal Rate of Return) for exploration cases prepared by SHELL planners for Business Planning and Forecasting
• Extensive and detailed analysis of the Reports critical for the business
• Piloted transitions from planners of new Operating Units of SHELL, which involved understanding the Fiscal Regime, contractual agreements with third parties followed by supporting the fiscal modeling for exploration in these Operating Units
• Create New Tax Models based on the Fiscal Regime of each country that Shell operates
• Highly client facing role which involved interacting with Business Planners/Economists for requirement gathering.

• Worked on one of the UK's renowned Infrastructure Fund Model – Model rebuild at Management Account Fund Interface level and actuals updation & maintenance of the models
• Worked on the model rebuild and model optimization for Bid Model for Infrastructure project of UK
• Roles & Responsibilities:
• Building financial models from scratch in Excel for Project Finance Infrastructure (PFI) sector
• Integrating actual and forecast financial models for PFI Projects
• Updating excel financial models for actual and master version maintenance
• Software checks for model consistency and errors
• Achievements
• Won ‘Above and Beyond' recognition and ‘Kudos' recognition twice in KPMG
• Received special Bonus twice due outstanding performace on the projects
• Qualified for the State level in National Science Olympiad ('99-'00)
• Scholarship holder in last two semester of MBA Program
• Project
• Project : Investment Decision & Portfolio Management and Analysis
• Project Area, Financial Services - Equity Research

• The Project dealt with investing behavior of investors and the factors that influence them while making any investment
• The portfolio analysis of the five funds was done which helped to realize the decisions taken by the fund manager and where were the pitfalls in their decision.