Shriya Pandey

A purpose-driven analyst with 3 years of experience. Deep analytical and quantitative expertise in transforming and analysing data to make informed decisions. Proficient in analytical tools like Power BI | Excel | Power Automate | SQL | Python | Tableau | Statistics. Strong presentation and communication skills in conveying results and insights conducted during analysis.

Udacity Nanodegree Certified Data Analyst.

Key Competencies

Data Analysis

Adaptability & Flexibility

Technical Skills

Data Analyst

Power BI

Power Automate

SQL

Excel

Python

Data Exploration/Cleaning/ Manipulation/Analytics/Visualisation

Azure(Synapse, Data Factory, Databricks etc)

Actively looking for opportunities in Canada.

• Automated mail system and tested the same for 50+ users to generate refreshed data as email notification with filtered dataset using Power Automate 
• Utilized filters and graphs in Power BI to improve data visualization techniques, ensuring business stakeholders had a comprehensive understanding of the data 
• Designed and implemented end-to-end data solutions on Microsoft Azure, leveraging services such as Azure Data Factory, Azure Databricks, and Azure SQL Database 
• Excel Proficiency in using various functions, and macros to automate tasks and improve efficiency 
• Developed a data cleaning and preprocessing pipeline that reduced data errors by 15% and improved overall data accuracy and integrity using Panda library in Python 
• Developed complex SQL queries and stored procedures to retrieve and analyze data from multiple databases
• Created, published and maintained dashboards and reports using Tableau/Power BI to track the business metrics and responsible KPIs, and to present large complex data sets
• Automating stored procedures and processes using TSQL to increase server production capacity by 5% 
• Maintaining changes in current BI Reporting Dashboard, and reduce data processing time by 80%
• Developed SQL queries to extract data, transform and load from multiple data sources to a centralized data warehouse

Masters of Technology (Information Architecture Software Engineering) 

Devi Ahilya Vishwavidyalaya, Indore

2016 - 2018

Bachelor of Technology (Computer Science & Engineering) 

Jawaharlal Nehru College Of Technology, Rewa

2011 - 2015