
Shriya Pandey
Sales
Services offered
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.
Experience
- 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
Education
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
Professionals in the same Sales sector as Shriya Pandey
Professionals from different sectors near Ottawa, Ottawa
Other users who are called Shriya
Jobs near Ottawa, Ottawa
-
8+ years of experience in Data Architecture, Data Engineering, and Analytics, operating across both strategic and hands-on delivery roles. · Proven ability to design conceptual, logical, and physical data architectures, including defining As-Is and To-Be states and building execu ...
Ottawa1 day ago
-
Position overview and requirements: · The Data and Performance Management Analyst provides direct support to the Chief Administrative Officer (CAO) as a strategic performance partner, through the development and coordination of corporate dashboards, performance measurement system ...
Embrun, Ontario1 day ago
-
summary: The client is Canada's leading innovation assistance program for small and medium-sized businesses. They help small and medium-sized businesses build their innovation capacity and take their ideas to market through financial assistance, advisory services and connections ...
Greater Ottawa Metropolitan Area1 week ago