Power Bi Supply Chain

Drashti Panchal

602-***-**** ********@***.*** ï Linkedin § Github Tempe, Arizona, USA

Education

Arizona State University Aug. 2023 – May 2025

Masters of Science in Computer Science Tempe, AZ

Gujarat Technological University Jul. 2019 – Jun. 2023 Bachelors of Engineering in Computer Engineering Gujarat, India Technical Skills

• Programming Languages: Python, JavaScript, Java, C++, SQL, PHP

• Front-End: HTML, CSS, React.js, Bootstrap, Material-UI, Figma

• Back-End & Frameworks: Express.js, Django, ASP.NET, Node.js, Flask

• Databases: MySQL, PostgreSQL, SQL Server, MongoDB (basic)

• Data Analysis & Visualization: Power BI, pandas, NumPy, Matplotlib, Seaborn, Plotly

• Developer Tools: Git/GitHub, VS Code, Windows, MacOS, Linux/Unix, Microsoft Azure Professional Experience

Sabrosura Foods LLC Jan. 2025 – Present

Data Analyst Intern Monroe, WI, USA

• Automated ETL pipelines in Azure Data Factory to consolidate data from Excel, SharePoint, Canopy, and SQL platforms into SQL Server, reducing Power BI report refresh times by 90% and streamlining data workflows.

• Developed and enhanced Power BI dashboards for quality management, HR scorecards, and supply chain operations, transforming static reports into visually engaging, interactive analytics tools that improved stakeholder engagement and decision-making.

• Cleaned and transformed about 50 datasets in SQL Server using advanced SQL queries (including unpivoting and complex data manipulations), ensuring high-quality, analysis-ready data for business reporting.

• Built and managed a comprehensive safety database with over 250 tables and millions of records, supporting robust analytics and delivering actionable insights for supply chain optimization. Tech Elecon Private Limited Jan. 2023 – Apr. 2023

Web Development Intern Gujarat, India

• Led the complete revamp of the school website using React.js and Express.js, coordinating a team of 4 members and managing deployment through Git for version control, reducing average page load times from 5 seconds to 3 seconds.

• Implemented a functional inquiry system with database storage, automated notifications for new inquiries, and an admin panel with API, increasing inquiry response efficiency by 60% and handling over 300 inquiries per month.

• Incorporated metrics to measure website performance, user engagement, and inquiry system efficiency, enabling a 25% increase in user engagement and supporting data-driven decision-making.

• Increased website traffic by 60% through improved announcements and accessibility; boosted Net Promoter Score (NPS) by 20%.

Tatvasoft Feb. 2022 – Jul. 2022

Software Engineering Intern Gujarat, India

• Engineered a React and Express-based e-commerce platform, incorporating robust authentication and cart management features.

• Reduced checkout abandonment by 30% and optimized user flow, enhancing customer acquisition rates.

• Established account modification and order tracking functionality, increasing user retention by 25% and customer satisfaction by 15%.

Projects

Caltech Dataset Image Analysis Using Computer Vision Machine Learning Aug. 2023 – Dec. 2023

• Built a Python image recognition system using feature extraction (color moments, ResNet, HOG) and similarity search with Personalized Page Rank and SVM-based feedback.

Climate Change Impact Using Global Temperature Data Data Analysis, Visualization Jan. 2024 – May 2024

• Analyzed and visualized global temperature data with Matplotlib, Seaborn, and Plotly to highlight climate trends and regional disparities.

Web Usage Mining System Python, Machine Learning, Data Mining Jan. 2024 – May 2024

• Developed a web usage mining system using Markov Chains and LSTMs on NASA logs, with custom visualization tools for user behavior analysis.

Contact this candidate