Diya Chandra

Technology Consultant

PricewaterhouseCoopers•  July 2017 - July 2019

MicroStrategy Developer –Performed revenue leakage analysis for a leading Pharma company, reducing overall leakage by 75%. 
– Created various schema objects such as Attributes, Hierarchies, Facts and defined Relationships by developing logical models for reporting as per business user requirements. 
– Implemented YTD, MTD and QTD analysis using Table and Formula based transformation.
 – Created cubes to increase the performance of Reports and Dashboards.
 – Set up Drill maps for end users to drill down and recover data along with dimensionality, conditions, filtering and grouping on key performance indicator metrics.
 – Customized reports, Documents/Dashboards and deployed them to MicroStrategy web.
 Tableau Developer 
– Visualized regional sales patterns for a Retail giant which resulted in increase of regional sales by 8.5%.
 – Worked extensively with customized Charts, Parameters, Maps, Trend Lines, Statistics and Table calculations.
 – Created Workbook Permissions, Ownerships and User filters.
 – Developed interactive dashboards with report scheduling in Tableau Server.
 – Used context and data source filters while handling huge volumes of data.