LITAN SUBHADARSAN

Project Name: AMYLYX

Environment:Tableau Desktop,Tableau Server,SQL,Excel

Project Description:AMYLYX is a global pharmaceutical company based in Cambridge,Massachusetts,that is dedicated to the discovery and development of potential treatments for neurodegenerative deseases.We pursue unconventional approaches through lasting collaborations with industry leaders,doctors,research organization,and the communities impacted by these relentlessly progressive diseases.

Roles and Responsibilities:

• Understanding the functional and technical specifications.
• Created dashboards displays how pharmaceutical drug sales performing across different locations over time and distribution of drugs status across total pharma stock.
• Translated complex business requirements into interactive reports,combining multiple data sources ,including SQL Server ,Excel and Snowflake.
• Created complex Calculated Fields,LOD Expressions,Parameters,Sets,Groups and Dynamic filters for advanced analytical dashboards.
• KPI/Charts Used Total Sales,Inventory Coverage,Inventory Utilization Rate,Total Prescriptions,Total Healthcare Organisations,Total Patient Count and Charts Such as Bar Chart,Line Chart,Dual Axis Chart,Symbol Map Chart,Tree Map,Pie Chart,Donut Chart.
• Optimized dashboard performance by implementing best practices,such as Data Extract,Minimizing Joins,Simplifying Filters and Reducing load times by over 40 %.
• Attend daily standup/scrum calls to update daily progress also to discuss any issues/bottlenecks while doing the visualization.