Adan Ghori

Adan Ghori

Data/Business Analyst
Canada
Urdu, Hindi, English

About Me

Data/Business Analyst with 3+ years of experience using SQL, Python, and BI tools to build data models and ETL pipelines, transforming complex data into actionable insights and scalable solutions.

Experience

Lead Business Systems Analyst

Dr Peter Centre
Aug 2023 - Present · 2 years 10 months

Analyzed clinical data using SQL and optimized SQL queries for reporting compliance and accuracy, Built data models and ETL pipelines to improve processing efficiency by 30%, Created Power BI dashboards for visualizing KPIs

Lead Business Systems Analyst

Dr Peter Centre
Sep 2023 - Dec 2024 · 1 year 3 months

Analyzed clinical data using SQL and optimized SQL queries to generate monthly and quarterly reports for Health Canada, VCH, and Providence Health, ensuring compliance, accuracy, and speed.
Built data models and ETL pipelines using Azure Data Factory and Synapse Analytics, improving processing efficiency by 30%.
Created Power BI dashboards to visualize KPIs for Counseling and Nursing programs, delivering actionable insights to leadership.
Collaborated with clinical and IT teams to align data reporting with compliance and strategic goals.
Led clinical data migration to Azure Cloud, ensuring minimal disruption by coordinating with internal and external team.

Investigation Analyst

WorkSafeBC
Jan 2023 - Sep 2023 · 8 months

Utilized Python libraries (Pandas, NumPy, Matplotlib) to extract, clean and analyze complex claims data, uncover fraud patterns, and improve case prioritization and workflows.
Performed code reviews on GitHub and used Git to track and manage Python scripts used for data cleaning, fraud detection, and reporting automation.
Designed interactive Tableau dashboards to visualize key trends and anomalies in claim suppression cases, enabling investigative teams to identify critical insights at a glance.
Applied UI/UX principles to design dashboards that effectively communicated complex data trends to investigative teams.

Investigation Analyst

WorkSafeBC
Dec 2022 - Sep 2023 · 8 months

Utilized Python libraries for data analysis and fraud detection, Designed Tableau dashboards to visualize key trends, Applied UI/UX principles for dashboard design

Evaluation Analyst

Simon Fraser University
Jan 2022 - Dec 2022 · 11 months

Built Excel reports using pivot tables, VLOOKUPs, advanced formulas, and data visualization tools to track student engagement metrics, helping stakeholders address underperforming areas.
Used Python for data cleaning and R for statistical analysis, uncovering trends that improved retention strategies and boosted engagement by 25%.
Analyzed program data with stakeholders to refine strategies, increasing student participation.
Implemented A/B testing to evaluate and refine student engagement strategies, optimizing student programs based on statistically significant results.

Evaluation Analyst

Simon Fraser University
Dec 2021 - Dec 2022 · 11 months

Built Excel reports with pivot tables and VLOOKUPs; utilized Python and R for analysis; implemented A/B testing to assess and improve engagement strategies.

Data Analyst

Alfoze Technologies
Jan 2021 - Dec 2021 · 11 months

Developed and maintained ETL pipelines for the Q-OBE Learning Management Platform, utilized by over 1,000 university students.
Designed Entity Relationship Diagrams (ERDs) for domain modeling, effectively visualizing data interactions between entities such as students, courses, and instructors.
Applied SQL and R for data analysis, extracting key insights to identify significant business trends.
Implemented OLAP techniques to design dashboards with Power BI, resulting in a 40% increase in actionable insights.

Data Analyst

Alfoze Technologies
Dec 2020 - Dec 2021 · 11 months

Developed and maintained ETL pipelines, designed ERDs for domain modeling, applied SQL and R for data analysis to uncover business trends and insights.

Skills

ETL Data Integration and Transformation (ETL) Microsoft Excel Python Structured Query Language (SQL) Data Extraction Data Quality Machine Learning Algorithms Data Collection Visualization Power BI R Programming Language (R) Tableau Artificial Intelligence (AI) Data Analysis and Reporting Data Analytics Java NoSQL Looker Jaspersoft Studio Excel Git Jupyter Notebook R Studio Azure Data Factory Synapse Analytics OLAP ERDs A/B Testing Pandas NumPy Matplotlib VLOOKUP Pivot Tables Data Visualization Data Modeling Code Reviews GitHub UI/UX
Report this Profile?