beBee background
Professionals
>
Ottawa
Shriya Pandey

Shriya Pandey

Data Analyst | Power BI Developer

Sales

Ottawa, Ottawa

Social


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.

Approximate rate: CAD$ 35 per hour

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

  • Work in company

    Data Architect (34580)

    Myticas Consulting

    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 ...

    Ottawa

    1 day ago

  • Work in company

    Data and Performance Management Analyst

    Municipalité de Russell Township

    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, Ontario

    1 day ago

  • Work in company

    Programming Analyst

    Morson Edge (Canada)

    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 Area

    1 week ago