Mrunal Mahapatra

Business Analyst supporting business performance, resource planning, work-winning strategy and management information through data analysis, business intelligence and reporting.

Key Duties

• Partner with senior stakeholders, Resource Managers and operational teams to translate business requirements into data-driven analysis, reporting and actionable insights.
• Develop and maintain Power BI dashboards and SQL-based data models, integrating financial, operational, capacity and work-winning data.
• Produce monthly & quarterly financial, capacity, work-winning and operational performance packs, highlighting KPIs, trends, variances, risks and opportunities.
• Analyse resource capacity, utilisation and business demand to support workforce planning and effective staff allocation.
• Analyse UK and international markets, sectors and opportunities to support the work-winning strategy and the prioritisation of bid activity.
• Scope, design and develop new reports and enhance existing reporting solutions in response to changing business requirements.
• Act as key contact for reporting and business intelligence requirements and support stakeholders in interpreting data for decision-making.

Key Achievements

• Developed a resource analysis dashboard using Power BI and SQL, adopted by 20+ Resource Managers and 3+ Commercial Operations Managers across 5 business areas, providing visibility into 200+ staff/resources and enabling data-driven allocation based on capacity, utilisation and demand, contributing to a 3%+ improvement in overall utilisation.
• Developed UK and international work-winning analysis covering 3+ markets and 8+ geographies, identifying high-potential opportunities and enabling focused bid activity that influenced approximately £3m of pipeline.
• Streamlined management reporting by developing 15+ Power BI dashboards and reports used by 50+ stakeholders, reducing reporting turnaround time by 7% and saving approximately 250 hours per month.

Commercial Finance Business Partner supporting Sales, Marketing, Finance and operational stakeholders with performance analysis, forecasting and commercial decision-making.

Key Duties

• Partner with senior stakeholders and budget holders on P&L, customer profitability, revenue performance and commercial opportunities.
• Own budgeting, forecasting and target-setting processes aligned with strategic objectives.
• Produce monthly and quarterly KPI reporting with detailed analysis of trends, variances, risks and opportunities.
• Analyse customer profitability, revenue streams and promotional activity to identify growth and efficiency opportunities.
• Support business cases and investment decisions through ROI, payback, scenario and sensitivity analysis.
• Identify opportunities to improve systems, reporting processes and operational efficiency.

Key Achievements

• Improved reporting accuracy by 14% through implementation of Power BI reporting solutions.
• Identified opportunities across three budgets, delivering approximately £100,000 annual savings.
• Developed reporting and forecasting solutions contributing to ~6% increase in company profit over three years.
• Led financial analysis and due diligence for new client acquisition, contributing to 6% revenue growth within six months.

Commercial Analyst within a leading MedTech organisation, partnering with Sales, Marketing, Finance, Business Intelligence, Legal and Business Unit Directors across UKINOR cluster.

Key Duties

• Partnered with Sales and Marketing to analyse market share, customer performance, bid and tender pricing, profitability, KPIs and competitor activity, translating data into actionable commercial insights.
• Built complex commercial and financial models covering ROI, margin, payback, transfer pricing, P&L, pricing and product launches to support investment and commercial decisions.
• Analysed customer, market and competitor data across franchises, sectors and geographies to identify growth opportunities and inform commercial strategy.
• Supported commercial planning and forecasting through financial modelling, scenario analysis, sensitivity analysis and revenue/margin assessment.
• Led bonus & incentive calculations to ensure accurate and timely incentive plan processing.
• Performed quarterly rebate analysis against revenue, identifying discrepancies, assessing provisions and validating deductions in line with commercial agreements.
• Worked cross-functionally with Finance, Sales, Marketing and commercial stakeholders to investigate data discrepancies, resolve issues and strengthen data quality and reporting controls.

Key Achievements

• Developed commercial pricing and profitability models across four franchises, supporting Sales and Business Unit Directors with customer, margin, ROI and pricing decisions and contributing approximately $1m in incremental revenue.
• Established and reviewed commercial agreements contributing approximately $0.6m in additional revenue, analysing pricing, margin, customer requirements and contractual terms to support sustainable commercial growth.
• Developed e-auction pricing model for NHS Supply Chain tenders, enabling Sales Managers to evaluate live bid scenarios, optimise price points and protect target margins during competitive bidding.

Key Responsibilities:

• Providing confidential, sensitive and specialist financial advice and support to assist CEO, Directors and Budget Holders in order that meet targets set by Board.
• Working closely with Directors, Project Managers, PMO and IT Managers to forecast monthly year-end position under each cost centre and project.
• Identifying relevant costs and revenues, correctly modelling cost behaviours and scenario/sensitivity testing and analysing them with financial ratios to establish viable opportunities.
• Pricing new and existing contracts where there are opportunities for up-sell and identifying lowest price for competitive pricing whilst maintaining company profit.
• Creating client profile and pipeline models and profitability analysis for different sectors and geographies to use as base line for market analysis. Gathering information to spot and predict trends for forecasting.
• Led financial aspects of tenders and working with bid team to get on to frameworks. Providing cost modelling to identify correct price points.
• Issued financial information and margin data to support revenue recognition.
• Developed forecasting tools to analyse revenue variance, business pipeline and industry trends.
• Worked with business teams to identify issues affecting financial results and profitability.
• Compared competitor data and statistics to develop business investment strategy and drive growth.
• Overseeing month-end tasks of finance analysts.

Key Achievements:

• Build new dynamic pricing model to increase turnaround time for proposals incorporating different staff groups, engagement types and year on year migration.
• Led several successful client Trust meetings resulting in additional annual £50M revenue.
• Produced order book to be presented to executive board and auditor's highlighting value of NHSP based on all existing contracts.

Key Responsibilities:

• Create all-inclusive strategy for operation of information management systems.
• Overseeing data compilation, retention and perform regular data quality checks to ensure all reported information is accurate and relevant.
• Design and used appropriate validation mechanisms to ensure that all reports produced meet user's requirements and are accurate, reliable and clearly presented.
• Evaluated existing project management practices and recommend improvements to project and program management practices.
• Ensured that projects are well planned and organised, including business case development, impact assessment, charter, communication plans, and integrated projects schedules.
• Lead on planning, coordination and execution of projects with technology bias, with clear focus on risk management and cross-functional stakeholder communication.
• Anticipate information requirements, evaluate business processes, and uncover areas for improving information sharing. Provide robust data usage and analytics reports to appropriate leaders in management.
• Completed duties to deliver on targets with accuracy and efficiency.

Key Achievements:

• Automated and improved monthly dashboards for Recruitment, IT and Telephony. Identified and corrected errors in historical reports.
• Changed month end written report to make it more useful and relevant.
• Created new monthly forecasting process for Recruitment, IT and Telephony. Encouraged Project Managers and IT Managers to take ownership of their numbers.

Key Responsibilities:

• Setting and implementing internal/external quality requirements to ensure company products/services meet customer expectations.
• Managed technical support page by creating FAQs and posting knowledge-based articles.
• Provided technical support throughout development phases of new products.
• Reduced escalation workload and maintained timely feedback to management.
• Participated in weekly department meetings to provide input on new and technical processes.
• Developed knowledge-sharing methodologies, diagnostic tools and creative processes to improve end-user experience.
• Gave first-line support to customers within agreed Service Line Agreement (SLA).
• Reported incidents, risks and hazards by following set procedures.

Achievements:

• Reduced technical support queries requests by 8%.
• Enhanced help desk ticketing system, reducing solution time by 15%.

Key Responsibilities:

• Partner with Relationship Management and Compliance teams to assist with preparation, development, due diligence and approval of electronic Know Your Client (KYC) record and supporting appendices.
• Execute integrated sales, relationship, and credit strategies that are aligned with branch's business plan.
• Identify inconsistencies in data, define business issues and formulate recommendations on policies, procedures or practices.
• Understand and adhere to all operational controls to ensure safety and security of client and bank assets.
• Identified and corrected errors in historical reports.
• Generated status reports, brief books and IPO pitches.

Key Achievements:

• Established and maintained relationships with customers to achieve branch performance goals and provide excellent customer service.
• Created independent tools to verify data and results of analytical systems.