Hersha Jogia

Senior Data Analyst operating across Supply Chain and the Buying domain — a deliberate move to gain direct exposure to commercial data and category-level decision-making. Deliver end-to-end analytical solutions across Agile and Waterfall frameworks, building scalable BI infrastructure and translating high-volume transactional data into insight that drives measurable outcomes for senior stakeholders.

• Commercial & Buying Exposure: Transitioned into the Buying domain to work directly with category performance, supplier metrics, and margin data — developing a stronger understanding of how analytical output connects to commercial decisions on pricing, ranging, and supplier negotiation.
• Data Infrastructure & BI Modernisation: Architected and maintained stored procedures in SQL Server processing millions of rows across multiple schemas, integrating outputs with SSRS Report Builder for scheduled operational reporting and Tableau for self-serve commercial dashboards — driving the transition away from manual Excel-based reporting across the function.
• Advanced SQL & Query Optimisation: Designed and optimised complex multi-schema queries and stored procedures to reduce report generation from several minutes to seconds, resolving data type conflicts and execution plan inefficiencies that had previously impacted performance at scale.
• Tableau Dashboard Development: Built dynamic Tableau dashboards with calculated fields, parameter-driven filtering, ranking logic, and hierarchical drill-downs — enabling senior commercial and operational stakeholders to interrogate data independently and make faster, evidence-based decisions.
• Stakeholder Management: Partnered with commercial buyers, supply chain leads, and operations directors to define requirements, challenge analytical assumptions, and deliver outputs fit for senior consumption — leading requirements gathering sessions and translating ambiguous business questions into structured analytical briefs.

An early-career role focused on building reporting infrastructure within a large public infrastructure programme — working primarily with qualitative and process-driven data, distinct from the commercial and transactional datasets of previous roles.

• Data & Reporting: Designed and implemented Power BI dashboards and executive-level reports across multiple business units, translating qualitative programme data into structured performance narratives for senior stakeholders.
• Data Integrity: Established data quality processes to ensure consistent, reliable reporting across all functions — building foundational skills in governance and accuracy that underpin later commercial work.
• Delivery: Managed multiple concurrent reporting projects in a complex programme environment, developing core skills in stakeholder management and prioritisation under pressure.

Commercially focused analytics role within a competitive UK transport business, responsible for pricing strategy, revenue performance, and data infrastructure across the bus division — working directly with senior internal and external stakeholders to translate data into commercial action and drive measurable revenue outcomes.

• Data Infrastructure: Oversaw a project with an external team to design and build a data warehouse, migrating the division away from fragmented Excel reporting into Tableau — establishing scalable BI infrastructure that gave commercial teams faster, more reliable access to the insight needed to make pricing and capacity decisions.
• Promotional Strategy & Impact Modelling: Led the commercial analysis underpinning an Elderly Passenger Scheme designed to drive post-Covid public transport recovery — modelling the revenue impact of promotional pricing constructs including £1 travel initiatives, balancing ridership growth against yield, and evaluating performance post-launch to inform future promotional investment.
• Pricing & Product Analysis: Modelled the commercial impact of new product launches pre-launch to stress-test assumptions and quantify risk, then conducted rigorous post-launch evaluations to measure uptake, revenue performance, and customer response — feeding findings back into the commercial planning cycle.
• Competitor & Market Intelligence: Conducted regular competitor pricing analyses and maintained a live market dashboard, ensuring the division's pricing strategy remained commercially sharp and responsive to market movements, demand shifts, and external events including rail disruptions and major holidays.
• Stakeholder Engagement: Presented commercial performance findings and pricing recommendations regularly to senior leadership and external partners — translating complex analytical output into clear, actionable narratives that influenced strategic decisions across the business.

Hands-on commercial role with direct responsibility for price and capacity management across the Northern region — using data to maximise yield, optimise load factors, and keep National Express competitive in a dynamic transport market.

• Pricing Strategy & Impact Analysis: Evaluated the before-and-after commercial impact of pricing interventions — analysing how changes to fares across routes and time windows affected load factors, yield, and revenue, and using those findings to continuously refine pricing strategy.
• Demand Forecasting: Examined historical and forward booking patterns to identify demand signals, proactively adjusting pricing ahead of major events, bank holidays, and rail disruptions to capitalise on volume opportunities and protect revenue.
• Competitor Intelligence: Maintained a live competitor pricing dashboard, conducting regular market analysis to ensure National Express pricing remained strategically positioned — directly supporting the business's standing as a market leader.
• Commercial Collaboration: Presented pricing recommendations and performance findings to commercial and operational teams, translating data into clear tactical actions and driving cross-departmental alignment on revenue decisions.

QA Ltd played a pivotal role in my development as an analyst. In this role, I analysed business performance data to identify bottlenecks and utilised tools such as Power BI and Excel to effectively present actionable insights.

• Business Dashboards : Undertook training in Power BI to design intuitive and insightful dashboards, transforming complex datasets into clear, actionable visualisations to support strategic decision-making.
• Performance Reviews : Analysed datasets to identify trends and highlight areas for improvement, with a particular focus on uncovering niche opportunities for growth.
• Communication Skills : Regularly presented findings to directors, honing my ability to deliver clear, concise, and impactful insights within a professional setting.