Data Analyst, Power Bi, SQL

Dipankar Roy

+1-780-***-**** *******@*****.*** GitHub: https://github.com/droy2021

Edmonton, AB — Canadian Citizen

Professional Summary

Analytical and detail-oriented Data Analyst with 2+ years of post-secondary/institutional data experience. Skilled in extracting, cleansing, validating, and visualizing data from ERP/data warehouse systems (e.g., PeopleSoft). Proficient in Power BI (DAX), SQL, Excel, Python, and survey administration. Demonstrated ability to support compliance reporting, build dashboards, and deliver data-driven insights to stakeholders in an academic setting. Technical Skills

- Data Extraction/Preparation: SQL, Python (Pandas), ETL pipelines for institutional systems

- Visualization & Reporting: Power BI (DAX), Tableau, Excel (Pivot Tables, macros)

- Statistical & Survey Methods: SPSS, Python; survey programming and administration

- Data Quality & Validation: QA frameworks, integrity checks, documentation standards

- Tools & Systems: PeopleSoft/ERP, BigQuery, Google Cloud, Git, Linux Relevant Experience

Data Analyst QED Solutions Inc.

Edmonton, AB 2024–

- Consult customers in data analytics.

Research Associate University of Alberta

Edmonton, AB 2016–Present

- Extract, clean, and validate clinical research and administrative datasets.

- Design and maintain dashboards in Power BI and Excel to monitor KPIs (e.g. patient recruitment, program metrics).

- Deliver presentations and training sessions to cross-functional teams on data interpretation and visualization best practices.

- Perform routine data QA and integrity checks; reduce reporting discrepancies by 25%.

- Supported institutional compliance reports and internal surveys: data prep, administration, and timeline management.

Scientific Adviser Software for Multiscale Modeling Inc. Remote 2021–Present

- Collaborate on design and execution of internal surveys; program instruments, clean responses, and deliver insights.

- Translate complex model outputs into concise executive reports and training for non-technical stakeholders.

Postdoctoral Research Associate City University of New York New York, NY 2010–2015

- Managed relational datasets (MySQL), processed and validated large-scale data for research analysis.

- Developed dataviz workflows in Python and Excel; presented findings to varied audiences. Education

Ph.D., Theoretical & Computational Chemistry — IIT Bombay M.Sc., Chemistry — IIT Bombay

B.Sc., Chemistry — University of Calcutta

Selected Projects & Initiatives

- Institutional Dashboards: Built a Power BI dashboard tracking student success and activity metrics for internal monitoring and presentation.

- Survey Administration Improvement: Programmed and managed multiple institutional surveys, ensuring data quality and timely delivery.

- Data Training Workshops: Created and led training sessions on Power BI and Excel best practices for university staff.

Key Highlights (Tailored to Role Requirements)

Posting Requirement My Experience

Prepare standardized reports and

visualizations

Developed daily/weekly dashboards in

Power BI & Excel to monitor institutional

KPIs

Communicate results to non-technical

audiences

Presented actionable insights to

stakeholders; led training sessions on data

interpretation

Extract and clean data from ERP/data

warehouse

Hands-on SQL/data extraction from

MySQL, BigQuery, and institutional data

systems

Conduct data validation & QA Implemented validation checks to improve data integrity and reduce errors by 25%

Survey administration Programmed surveys, managed

distribution, cleaned responses, and

prepared analysis timelines

Power BI (DAX), SQL, Excel, Python Proficient in all; routinely use DAX for calculated measures and Python for

ETL/data cleaning

Contact this candidate