Available for opportunities

Venus
Tyagi

Lead BI Analyst & Data Professional

7+ years delivering Power BI and ERP-driven analytics across retail and healthcare domains. Currently leading BI strategy and PLM reporting at a global scale — transforming raw data into decisions that matter.

Power BI Advanced DAX SQL Azure Databricks NetSuite · Odoo
Get In Touch Download Resume

Turning complexity into
clarity

I'm a Lead BI Analyst with a passion for building data ecosystems that organizations actually rely on. My work sits at the intersection of business intelligence, ERP systems, and advanced analytics — bridging the gap between raw operational data and the strategic decisions it should inform.

Currently at Kosos Home Pvt Ltd., I own the full Power BI strategy: from data modelling and DAX architecture through to executive-level reporting for stakeholders across the US, Vietnam, and Indonesia. I'm equally fluent in the business language of KPIs and the technical architecture of scalable data models.

Earlier in my career, I built Power BI solutions for healthcare analytics at Milliman India, where I helped identify over $586M in low-value healthcare services — proving that good data infrastructure isn't just an operational tool, it's a commercial one.

7+ Years Experience
3 Industries Served
4 ERP Platforms
🌐 Global Stakeholders
venustyagi.ai@gmail.com linkedin.com/in/venus-tyagi

Technical depth across
the full data stack

Core Proficiency

Power BI & Advanced DAXExpert
SQL (CTEs, Window Functions)Advanced
ERP Analytics (NetSuite, Odoo)Advanced
Azure DatabricksProficient
Data Modelling & ETL DesignProficient
Python (Analytics)Working

BI & Visualisation

Power BI Desktop Power BI Service DAX Studio Power Query (M) Excel (Advanced) KPI Dashboards

Data Engineering

Azure Data Factory Azure Databricks ETL Pipelines SQL Server SharePoint

ERP & Platforms

NetSuite Odoo (PLM) ERP Reporting Data Reconciliation

Domains

Retail Analytics Healthcare BI Supply Chain Finance Reporting Sales Analytics

7+ years of high-impact
data delivery

Lead BI Analyst

Kosos Home Pvt Ltd. · Noida, India

  • Leads the Business Intelligence function — owning Power BI strategy, delivery, and stakeholder alignment across the organization.
  • Drives PLM (Odoo) reporting and analytics, translating product and operations data into actionable executive insights.
  • Owns and manages enterprise Power BI dashboards for Sales, Inventory, Open Orders, Key Accounts, and Finance.
  • Designs complex DAX measures including rolling calculations, corrected bookings, and KIT/component exclusions.
  • Supports BI and ERP reporting for stakeholders across US, Vietnam, and Indonesia.
  • Integrates data from NetSuite, Odoo (PLM), Excel, and SharePoint into scalable reporting models.
  • Resolves ERP vs reporting data mismatches, ensuring accuracy in quantities, values, and rollups.
Power BIDAXNetSuiteOdoo PLMSharePoint

Business Intelligence Analyst (Contract)

Independent · Gurugram, India

  • Designed and implemented interactive Power BI dashboards for diverse clients across multiple industries.
  • Automated reporting processes providing real-time insights, reducing client reporting overhead.
Power BIClient ReportingDashboard Automation

Data Scientist

Milliman India Pvt Ltd. · Gurugram, India

Identified over $586M in low-value healthcare services via Power BI dashboards for the Health Waste Calculator (HWC) — directly supporting cost-saving initiatives.
  • Integrated and validated data from diverse sources using SQL and Power Query, enhancing data accuracy by 25%.
  • Detected discrepancies in Pharmacy Benefit Management (PBM) audits using SQL.
  • Created interactive visuals — KPI cards and patient impact charts — to assess outcomes and enhance healthcare quality assurance.
Power BISQLHealthcare AnalyticsPower Query

Data Analyst

Team Computers Pvt Ltd. · Noida, India

  • Designed and implemented data pipelines using Azure Data Factory and Azure Databricks.
  • Automated ETL processes across millions of rows, reducing manual work by 29% monthly.
  • Conducted data transformations in Power Query for clean, report-ready datasets.
  • Wrote SQL queries, stored procedures, and triggers to implement business logic.
Azure Data FactoryDatabricksSQLETL

Data Analyst

Alethe Consulting Pvt Ltd. · Gurugram, India

  • Translated business requirements into KPIs and SQL datasets for client reporting.
  • Developed analytical reports and dashboards to support business decision-making.
  • Performed data validation and reconciliation to ensure accuracy of reported metrics.
  • Documented reporting logic and KPI definitions to improve clarity and consistency.
SQLKPI DesignReportingData Validation

Selected work

Retail / Global Commerce

Enterprise Retail BI Platform

Kosos Home Pvt Ltd.

Built the full Power BI reporting ecosystem for a global furniture brand — covering Sales performance, Inventory aging, Open Orders pipeline, Key Account tracking, and Financial rollups. Designed multi-source models integrating NetSuite ERP, Odoo PLM, Excel workbooks, and SharePoint.

Impact Multi-region reporting for US, Vietnam & Indonesia stakeholders with real-time ERP accuracy.
Power BIDAXNetSuiteOdooSharePoint
Healthcare Analytics

Healthcare Waste Identification — HWC Dashboard

Milliman India Pvt Ltd.

Developed the Power BI front-end for Milliman's Health Waste Calculator — a tool identifying low-value healthcare services. Integrated clinical and claims data from multiple sources, validated through SQL reconciliation, and visualised through KPI cards and patient impact charts.

Impact $586M+ in low-value healthcare services identified; data accuracy improved by 25%.
Power BISQLPower QueryHealthcare KPIs
Data Engineering

Azure ETL Pipeline Automation

Team Computers Pvt Ltd.

Architected and deployed end-to-end data pipelines using Azure Data Factory and Databricks. Built linked services for diverse data sources, automated transformation logic across millions of rows, and replaced manual SQL-based reporting workflows with orchestrated, scalable pipelines.

Impact Reduced manual data processing work by 29% monthly across the reporting team.
Azure Data FactoryDatabricksPower QuerySQL
PLM / Operations

PLM Analytics & Odoo Reporting Initiative

Kosos Home Pvt Ltd.

Led the BI layer for a Product Lifecycle Management implementation on Odoo — translating product creation, BOM changes, and inspection workflows into executive-level dashboards. Resolved complex ERP-vs-reporting data mismatches to ensure rollup accuracy across product families.

Impact First-ever PLM visibility for operations leadership; resolved systemic reporting discrepancies.
Power BIOdoo PLMDAXData Reconciliation
BI Consulting

Multi-Client BI Consulting Portfolio

Independent Contract — 3 years

Delivered interactive Power BI solutions for clients across retail, e-commerce, and services sectors. Standardised dashboard templates, automated refresh pipelines, and trained business users on self-service reporting — building sustainable BI capabilities within client organisations.

Impact Repeatable BI delivery model; reduced client reporting lead times from days to hours.
Power BIDAXPower QueryClient Delivery

Academic & professional
credentials

Education

Bachelor of Technology — Computer Science & Engineering

Graphic Era University · Dehradun, UK, India

Foundation in data structures, algorithms, databases — directly applied across 7+ years in data engineering and analytics.

Certifications

SQL Certified

Testdome

Top 10% ranking globally — validates advanced SQL proficiency including CTEs, window functions, and query optimisation.

View Certificate ↗

Data Analytics with Databricks

Databricks Academy

Certified in cloud-scale data analytics using Apache Spark, Delta Lake, and the Lakehouse architecture on Azure Databricks.

Let's build something
data-driven

Open to senior BI, data architecture, and analytics leadership roles. Also available for consulting engagements on Power BI strategy, ERP reporting, and data transformation projects.

Email venustyagi.ai@gmail.com
Phone +91 7351 567 513
LinkedIn linkedin.com/in/venus-tyagi
  Download Resume

Send a Message