Dakshayani Ravilla

· Led the development and migration of existing BI Solution for one of the largest telecom service providers with more than 50 reports from MicroStrategy to Power BI.

· Developed drill though reports, analytical reports and interactive visualizations using Power BI techniques and DAX functions, aggregations, and conditional argument to present the business logic.

· Developed complex SQL queries, created many calculated columns and measures in Power BI using DAX to better evaluate quality.

• Design Datawarehouse and framework changes on new ‘Plug and Play’ predictive models.
• Reduced data processing time by 30 % by effective data partitioning and segmentation strategies.
• Integrating Power BI with ready to serve visual analytics as service for clients, we streamline the transformation of data into actionable insights within days.

• Designed and developed ETL workflows in IICS to extract, transform, and load data from various sources into data warehouse.
• Worked on building Audit Framework process that maintains logs of all operations (Inserts, Updates, Deletes) related to ETL Process and notifying through email in case of any data mismatches between source and target data thus reducing error handling time significantly.

• Designing and implementing data integration workflows to extract, transform, and load data from diverse sources into target destinations.
• Successfully deployed and managed the MicroStrategy suite for both development and production environments, facilitating the growth of end users.
• Designed and created schema and application objects, including attributes, metrics, and filters, and implemented intelligent cubes for efficient reporting. Developed custom queries to support logical views and freeform SQL reports

• Developing transformations using PDI's visual interface for tasks like data cleansing, validation, enrichment, and aggregation, ensuring data quality and integrity.
• Successfully deployed and managed the MicroStrategy suite for both development and production environments.
• Developed MicroStrategy reports and dashboards based on business requirements.