Data Analyst Engineer

Khashayar Asgari

SUMMARY

● Data Engineer and Data Analyst with over 6 years of experience, skilled in building automated data pipelines, applying statistical methods, and delivering data-driven insights across diverse industries.

● Proficient in R, Python, SQL, and Databricks, with expertise in building automated ETL pipelines, CRM solutions, and analytical applications.

● Strong background in Data Visualization using Power BI and Tableau, effectively communicating insights to support strategic decisions.

● Certified Microsoft Excel Expert, skilled in automating workflows and creating advanced analytical solutions using Excel (VBA, Power Query, DAX), driving significant process improvements.

● Proficient in cloud platforms such as AWS and Microsoft Azure, with hands- on experience implementing scalable and reliable data solutions. EXPERIENCE

Data Analyst May 2023 – Present

Beverly Hills Therapy Group (BHT), Los Angeles, CA, USA

● Developed a CRM system using R (dplyr, tidyr, data.table), Python (pandas, numpy, requests), and SQL, integrating third-party APIs and automating ETL of EHR data, handling multi-data from different format sources—cutting processing time by 40%. Now being brought to market.

● Designed advanced Excel dashboards using PivotTables, VBA, and DAX, providing real-time insights for resource allocation and identifying accounting errors, saving the company over $70,000 annually.

● Applied machine learning models (deep learning, logistic regression) to analyze operational data, increasing revenue by 15% and reducing costs by 20% through data-driven decision-making.

● Developed a feedback management system using Google Forms and Python

(pandas, requests, json) to collect, process, and analyze clinician and patient feedback, enhancing service quality and increasing patient satisfaction by 25% and clinician retention by 20%.

● Implemented AWS cloud services to optimize data storage and pipelines, improving system scalability and reducing costs by 15%. Managed version control via GitHub, ensuring efficient code deployment and collaboration.

● Led database design and development using PostgreSQL (RDBMS) to support CRM and EHR systems, enhancing data integrity and improving query performance by 30%.

● Leveraged Databricks and Snowflake for data warehouse technical development, integrating and analyzing large datasets to improve data processing speed by 30% and enable real-time reporting and advanced analytics across the organization

CONTACT

• ******.*********@*****.***

• +1-424-***-****

• www.linkedin.com/in/khashayar-asgari

SKILLS

• Programming Languages:

R,Python,DAX,VBA MATLAB,

JavaScript

• Data Visualization Package:

Power BI,Tableau,Excel

• Cloud Computing:

Google Cloud,AWS,Microsoft

Azure

• Operating Systems:

Windows, macOS, Linux

• Interpersonal:

Creative problem-solving,

Teamwork, Leadership, Written

and oral presentation, Analytical

thinking, Time Management

EDUCATION

Master in Information System

and Technology

York University

Toronto, Canada, (2023)

Master in Statistics

York University

Toronto, Canada, (2019)

BSc in Statistics

York University

Toronto, Canada, (2018)

Selected Coursework:

• System Analysis and Design

• Business Analytics

• Information Visualization

• Applied Optimization in IS

• Advanced Statistics

• Generalized Linear Models

• Applied Statistics

Data Analyst Jan 2023 – Apr 2023

Profit Factory, Austin, TX, USA

● Improved data workflows by automating ETL processes using Python

(pandas, numpy), managing multi-source and multi-data from different format sources, reducing manual input by 70% and enhancing data accuracy and reporting efficiency.

● Developed interactive dashboards in Power BI, integrating with Snowflake and supporting data warehouse technical development to enable real-time data visualization and improve scalability across reporting pipelines.

● Optimized operational workflows by implementing automation scripts with Python (pandas, requests), achieving a 30% increase in team efficiency and faster reporting cycles.

● Standardized reporting processes by developing automated data validation scripts, ensuring consistency and accuracy across reports and reducing errors by 20%.

● Executed database design and development with MySQL (RDBMS) to enable efficient data structuring, automated reporting, and real-time dashboard integration.

Data Analyst Jul 2019 – Dec 2022

Solve & Excel Consulting, Toronto, ON, Canada

● Built custom business solutions in Excel and automated ETL pipelines using Power Query and VBA, processing multi-source and multi-data from different format sources, and reducing data processing time by 30%.

● Built interactive Power BI dashboards with advanced DAX calculations, Snowflake integration, and data warehouse technical development, delivering real-time insights that improved decision-making and streamlined KPI tracking for clients.

● Provided data analysis and visualization using Python (pandas, numpy) and R (dplyr, tidyr) to identify financial trends and discrepancies, improving reporting accuracy by 25%.

● Implemented and trained clients on ZOHO CRM, ensuring seamless adoption and integration, resulting in improved customer relationship management and higher client satisfaction.

● Utilized Microsoft Azure for data storage, integration, and pipeline automation—boosting efficiency and delivering scalable solutions for clients.

● Designed and optimized relational (MySQL) and NoSQL (MongoDB) databases for client projects, improving data accessibility by 40%, query performance by 30%, and reporting efficiency by 25%. Teaching Assistant Sep 2018 – Jun 2019

York University, Toronto, ON, Canada

● Assisted in developing course materials and delivering tutorials for advanced statistical concepts, enhancing student understanding and engagement.

● Provided one-on-one support to students, clarifying complex topics in statistics and data analysis, improving overall academic performance. CERTIFICATIONS

Microsoft Office Specialist:

Excel Expert

Issued by Microsoft

Credential ID : 90083475

Master Excel Power Pivot &

DAX

Credential ID : cert_tdhp5bc4

Fast Track to Power BI

Credential ID : cert_tmxybhn5

SQL Training

Credential ID : 2174970

Contact this candidate