Data Analyst with Power BI and Tableau Expertise

Bijaya Dey

Woodbury, CT, USA +1-475-***-**** ************@*****.*** LinkedIn

PROFESSIONAL SUMMARY

Data Analyst with a Master’s in Economics and over 2 years of experience in crafting interactive dashboards and data visualizations using Power BI and Tableau. Successfully built interactive tools, managed databases, and cleaned complex datasets to extract actionable insights. Demonstrated strong SQL and communication skills, with a proactive approach to mentorship and problem-solving. PROFESSIONAL SKILLS

• Technical Tools & Software: MySQL, SAS, PowerBi, Tableau, R Programming, Microsoft Office Suite, PowerPoint

• Soft Skills: Time Management, Strong Analytical and Problem-Solving Skills, Results-Oriented, Attention to Detail, Attention to Accuracy and Creative Thinking, Strong Presentation Skill, Facilitating Teamwork, Self-Driven, Independent Attitude EXPERIENCE

rCycle Feb 2023 - Oct 2023

Data Analyst Co-op Toronto, Canada

• Developed an interactive dashboard using R and Power BI to present actionable insights, laying the groundwork for a potential user-friendly application.

• Mentored and onboarded new co-op students, effectively communicating team objectives and promoting collaboration in data analysis efforts.

• Managed and optimized a PostgreSQL database to extract and validate complex datasets, ensuring data integrity and accuracy.

• Organized, cleaned, and annotated image data for AI model training, enhancing the quality and reliability of input data.

• Analyzed live user data to identify trends and patterns, providing insights to improve platform functionality. Walmart Canada Jan 2021 - Oct 2023

Customer Associate (Part Time) Oshawa, Canada

•Assisted customers with inquiries and provided tailored solutions by actively listening to their needs.

•Fostered strong business relationships by taking accountability for resolving client issues. Shangri-La English Medium School Mar 2015 - Jun 2019 Secondary School Teacher Assam, India

• Taught Economics and English to students from 8th to 10th grade, covering curriculum objectives and preparing students for exams.

• Encourage student participation through debates, writing exercises, case studies, and group discussions.

• Simplified complex economic theories such as demand supply, inflation, and globalization for practical understanding.

• Focused on grammar, comprehension, creative writing, and public speaking in English to improve both written and verbal communi- cation.

EDUCATION

Toronto School of Management (TSoM) Toronto, Ontario May 2022 - Jan 2023 Diploma, Data Analytics

• Coursework: Data Design, Data Handling and Decision-Making using R, Data Visualization and Interpretation using PowerBi and Tableau, working with data using SAS and MySQL

Oct 2020 - Apr 2021

Certification, Investment Funds in Canada (IFIC)

• Coursework: Fundamentals of investment products and portfolio construction, mutual funds, and other managed investment products, Client communication and needs-based financial planning, Regulatory environment, compliance standards, and ethical practices, Fee structures, compensation methods, and service models, Tax planning strategies and retirement income planning, Suitability assessments and Know-Your-Client (KYC) principles

Gauhati University Guwahati, India 2012 - 2014

Master of Arts, Economics, Statistics

• Coursework: Micro / macro-Economics, Monetary Economics, Mathematical / Statistical Method for Economics, Population and Human Resources, Financial system etc.

Gauhati University Guwahati, India 2009 - 2012

Bachelor of Arts, Economics

• Coursework: Banking, money and finance, The monetary system, public finance, basics of statistics, Fundamental of Microeconomics, International trade and policy, Economics of Natural resources, and sustainable development etc. PROJECTS (AT TORONTO SCHOOL OF MANAGEMENT)

Project on Retail Segmentation in MySQL and Bank-Churners in SAS Toronto School of Management

•Technology: SQL, SAS, ppt

• Sorted retail store data with uni-variate and bi-variate analysis creating predictive modeling, to understand the value of different shopper groups on different channels and giving an insight to the business about the future sales potential. Project on Housing data in R

Toronto School of Management

•Technology: R Language, ppt

•Investigated the effect of the different features on the house price and building predictive modelling for the future house price. Project on Hockey Federation in PowerBI

Toronto School of Management

• Technology: PowerBI, ppt.

• Analyzed top hockey players’ performance using PowerBI, comparing previous modeling and external variables to identify the strengths and achieve higher scores with the selection of the group. Project on U.S wholesaler data on Tableau

Toronto School of Management

• Technology: Tableau, ppt, MS Excel.

• Extracted, Cleansed and Prepared Data for a B2B company in U.S and did a thorough analysis to find out the reason behind a continuous drop in total sales across three years.

CERTIFICATIONS

•R Essential Training: Wrangling and Visualizing Data: through LinkedIn Learning

•Tableau 10 Essential Training: through LinkedIn Learning

Contact this candidate