Data Analyst Power Bi

Parth Kalani

Chicago, IL

Phone: 617-***-**** Email: ****************@*****.***

LinkedIn : linkedin.com/in/parth-kalani GitHub: github.com/ParthKalani

Summary

Results-oriented Data Analyst with experience turning complex data clear, actionable insights. Skilled at working across teams to gather information from varied sources, uncover trends, and communicate findings in simple, business-friendly language that drives smarter decisions.

Technical Skills

Alteryx DBT Airflow Tableau PowerBI Advanced Excel AWS S3 Azure Data Factory Spark Talend Hive Kafka Python Pandas Numpy Selenium SKLearn Pytorch XGBoost K-means LLM GenAI Snowflake Google BigQuery AWS Redshift MS SQL MySQL PostgreSQL Github REST API Docker Jira Confluence Jupyter Notebooks MS Power Automate

Experience

Data Analyst Sep 2024 - Present

Community Dreams Foundation Org. Remote, IL

●Measured performance of marketing and co-marketing campaigns (email, promotions, partner media), providing insights that improved campaign ROI by 22%.

●Built automated SQL + BigQuery pipelines to consolidate ad engagement, conversion, and spend data from multiple sources, ensuring reliable campaign reporting.

●Designed and productionized Tableau/Power BI dashboards to track impressions, CTR, conversion rates, and retention metrics, used by 10+ business partners for decision-making.

●Partnered with marketing, product, and engineering teams to define campaign tracking requirements and ensure alignment on success metrics.

●Implemented data quality checks and monitoring routines to identify discrepancies across campaign datasets, reducing reporting errors by 35%.

Data Engineer and Analyst Intern Aug 2023 – Jan 2024

Tesla Inc. Fremont, CA

●Led end-to-end enterprise BI dashboard for division, increased DAU (daily active users) by 175% and saved 28,800 man-hours yearly.

●Modeled Data Warehouse for 150MN records, automated ETL pipelines using Airflow, Python & SQL. Optimized runtime by 15%.

●Increased data pipeline reliability by 50% by Airflow orchestration with failure handling, alerting, and retry logic.

●Generated 10+ data pulls and ad hoc reports for senior stakeholders’ meetings, leading to more external stakeholder recognition.

●Partnered with DE, DS, DA and PM to define and manage data requirements, building One-Stop solution and DWH for division.

Data Analyst Jan 2023 - Mar 2023

Northeastern University Boston, MA

●Created interactive Power BI dashboards for Coop-statistics, increasing student engagement by 30%.

●Automated data extraction and transformation using Python (Pandas, Selenium), integrating real-time insights into reports.

●Designed DAX queries for Power BI reports, improving operational efficiency and reporting accuracy.

Assistant Manager - Data Quality Sep 2020 - Jul 2022

HFCL Limited Haryana, India

●Examined customer end-user data using tools such as Excel and SQL, identifying key trends and opportunities, and presenting findings to management, resulting in a 25% increase in customer satisfaction and retention rates.

●Evaluated massive data using Microsoft Excel (VLOOKUP, Pivot Tables) to clean, analyze, and create master data for SCM application.

●Coordinated with supply chain, logistics, and IT teams to align data center resource availability with critical delivery schedules, preventing project delays.

Projects

HR Data Analytics GitHub Link

●Conducted exploratory data analysis on 30+ HR features to identify top drivers of employee attrition, uncovering key patterns in tenure, role, and performance metrics.

●Engineered 5+ new features (e.g., employee tenure, performance score ratios) and applied correlation analysis, improving predictive insight into attrition risk by 20–25%.

PDF & Web Scrapper Webapp GitHub Link

●Integrated web scraping and text extraction techniques with PyPDF2 and Grobid, employing data schema validation using Pydantic, facilitating structured storage in AWS S3, and implementing DBT with Snowflake for data warehousing.

Disease Prediction Analysis GitHub Link

●Employed KNN, Logistic regression, Support Vector Classifier, Decision Tree, Naive Bayes algorithms and Random Forest Classifier on Disease identification data to compare model accuracies on prediction outputs.

Education

Masters of Science in Information Systems: Northeastern University, Boston, Massachussetts

Bachelor of Technology in Electronics and Communication Engineering: Sardar Vallabhbhai National Institute of Technology, Surat, India

Certifications

Data Analytics and Machine Learning Certificate of Completion Aug 2025 - Present

ElevateMe Bootcamp

●Engaging in 150+ hours of hands-on learning and project work, including active participation in a live project and two optional capstone projects.

●Utilize advanced tools such as Python, Jupyter Notebooks, Pandas, Numpy, Matplotlib, Seaborn, and Scikit-learn to build and evaluate machine learning models.

●Deploy machine learning models on Microsoft Azure, integrating Azure ML with Azure SQL databases to enable real-time analytics and predictions.

●Perform data preprocessing, feature engineering, and model selection, and evaluate regression, classification, and clustering algorithms to optimize performance.

Alteryx Designer Core Certificate Oct 2024 - Oct 2026

Alteryx

40+ hours of training and hands-on projects in building 15+ automated workflows to clean, join, and analyze datasets, reducing manual effort by 60% and improving data accuracy by 25%.

Contact this candidate