Jyoti Yadav

About Jyoti Yadav

I am a marketing analyst with 3 years of experience in competitive intelligence, competitor analysis, market trend analysis, lead generation, project management and pricing analytics. Targeting for an opportunity in Marketing and Consultancy touse the experience and skill set to contribute and grow with the organization.Designing and managing a comprehensive database to assess market share and identifying target market expansion opportunities, resulting in a 3X increase in potential volume.Leveraging Advanced Excel and data visualization tools like Qlik Sense to analyze import/ export trends, conduct competitor analysis, and track monthly customer sales.Developing dashboards and reports using MS Excel, Power BI & Tableau for effective data gathering and visualizing key metrics, enabling data-driven decision-making; conducting excipient trend analysis to optimize the product portfolio.Built a comprehensive pharmaceutical product database, saving time and enabling easy access to relevant information; conducted PESTLE analysis on target companies and performed digital channel analysis.Translated complex data into user-friendly formats, created journey maps, and conducted detailed analysis of KPIs using Data Studio; developed strategies for campaign audits and tests, resulting in a 0.5% increase in landing page conversions.

Experience

1. Analyst

   诺华

   Oct 2023 — Present · Hyderabad, IN

   KEY RESULT AREASAnalytics Strategy & Roadmapping: Building and driving the annual enterprise analytics roadmap across regions, enabling sharper project prioritisation and strategicalignment with organisational objectives.Stakeholder & Vendor Management: Serving as the primary interface with third- party Data Lake partners, owning the end-to-end data lifecycle from businessrequirement definition through Snowflake data availability.Process Excellence & Optimization: Mapping complex end-to-end operationalprocesses, identifying control gaps, and recommending optimisation initiatives toimprove process transparency and KPI maturity.Requirements Engineering & Enablement: Facilitating stakeholder workshops touncover latent requirements, align cross-functional expectations, and demonstrateanalytics capabilities and value propositions.Agile Delivery & Resource Management: Leading sprint planning, task allocation, andcapacity management to ensure optimal workload distribution and predictable delivery.Risk & Dependency Management: Proactively identifying delivery risks and executing mitigation strategies to resolve potential project bottlenecks.Program Governance & Reporting: Forecasting timelines, tracking execution progress, and providing governance updates and executive-level reporting to senior leadership.Quality Assurance & Release Management: Overseeing quality assurance, UAT coordination, and controlled release management to ensure production-ready analytics solutions.Data Modeling & Visualization: Developing advanced DAX calculations, optimising Power BI data models, and integrating multi-source datasets to enhance performance and scalability.Data Engineering & SQL Optimization: Leveraging SQL extensively for data validation, transformation logic, and query performance optimisation.Cloud Data Platform (Snowflake): Supporting Snowflake initiatives by validating data models, executing test queries, and coordinating schema changes with platform teams.

Education

• SIES College of Arts, Science & Commerce SION(W)

  Bsc, Biotechnology

  2015 — 2018

• SIES College of Management Studies - India

  PGDM , Biotechnology

  2018 — 2020