Aarushi Pandey Email & Phone Number

Toronto, Ontario, Canada

● Designed and developed Power BI reports and dashboards using PowerQuery, PowerPivot, DAX, and other advanced features to analyze complex data and create custom calculations and visualizations. ● Performing data profiling, cleansing, and transformation to ensure data quality, accuracy, and consistency, maintained data governance policies and procedures to ensure compliance with regulatory requirements. ● Managing data infrastructure, in cloud-based platform AWS, to ensure data security, scalability, and reliability. ● Responsible for performing data analytics, creating Power BIapps, and connecting them with live datasets for real time analysis. ● Worked with SSIS tool suite, created SSIS packages, mappings in BI Studio to validate, extract, load and transform data to Data Warehouse databases. ● Continuously improved report performance and user experience by optimizing query performance, data models, and visualization design, and by implementing best practices for report development and maintenance.

Bengaluru, Karnataka, India

● Created various Power BI reports utilizing the desktop, online service, and schedule refresh, along with assisting end users with Power BI. ● Developed visualization reports and dashboards from multiple data sources using data blending. ● Created interactive, highly informative Power BI dashboards using DAX features. ● Building ETL pipelines to ingest transactional and event data, building forecasting using parameters, trend lines and reference lines. ● Performance tuning for multiple databases, table partitioning, query execution plans, SQL profilers and query optimization.● Worked with Scrum methodologies in a Python based environment in association with data analytics and Excel data extracts. ● Gathering and verifying business requirements and functional specifications

Postgraduate Degree, Artificial Intelligence And Machine Learning

Bachelor'S Degree, Physical Sciences