Piyush Kumar

• Built complex Tableau dashboards from scratch, including full KPI logic, parameters, and calculation frameworks that support business monitoring and decision-making.
• Contribute to Snowflake data modeling, creating analytical views/tables and preparing structured datasets that feed BI dashboards and reporting layers.
• Perform ongoing data quality checks in Snowflake (validating joins, date handling, null behaviour, metric consistency) to ensure accurate and trustworthy insights.
• Translate business requirements into clear technical logic by working closely with analysts and stakeholders on metric definitions, filters, and data behaviour.
• Explain dashboard logic, data structures, and analytical findings to stakeholders, ensuring they understand how metrics are built and how to interpret trends.
• Support the BI team with troubleshooting, refining calculations, and improving overall reporting reliability.

• Developed Power BI dashboards to track timelines, KPIs, budgets, and resource allocation for global market access, enabling faster decisions and reducing manual tracking for leadership.
• Conducted RWE Phase 1 analysis on IPF/ILD in R to support disease understanding and treatment strategies, providing a foundation for Phase 2 patient-level analysis.
• Collaborated on a cross-functional AI/Big Data project for early detection of IPF and ILD, contributing to project strategy and the ERF proposal by aligning data insights with medical and regulatory objectives.

• Built interactive Tableau dashboards for HR metrics (recruiting, headcount, org structure).
• Used Tableau Prep for data cleaning and modeling, improving quality and consistency.
• Designed KPIs and calculated fields to enhance dashboard clarity and relevance.
• Developed a corporate-branded dashboard template aligned with TUI's identity.
• Collaborated with HR Reporting & People Analytics teams to deliver actionable insights.

• Used DB2 tables and Teradata tools to write and optimize SQL queries for extracting and transforming large insurance datasets.
• Developed and enhanced code modules to meet business requirements in POS and Adjustment processes, ensuring scalability and compliance.
• Built dashboards in Tableau to analyze business trends and support decision-making in insurance operations.
• Automated manual reports, improving data accuracy and reducing turnaround time.
• Conducted root cause analysis to resolve data issues and improve overall system reliability.
• Used JIRA and ServiceNow for tracking tickets, issue resolution, and sprint planning in Agile workflows.
• Mentored new team members and supported onboarding with documentation and technical training.
• Collaborated with cross-functional teams and clients to define scope, manage escalations, and ensure timely project delivery.