Medhavi Rathod

Medhavi Rathod Portfolio - https://tinyurl.com/2zt44hrh Professional Summary Data Analyst with 3 years of experience turning complex data into clear insights that improve operations and service reliability. Skilled in Python, SQL, and Power BI, with experience building dashboards, cleaning data, and creating reports that help teams make better decisions. Comfortable working with IT operations, solving problems quickly, and using data to prevent issues before they happen. Core Competencies       Programming & Data Analysis: Python, R, SQL, C, Google Colab, Excel (Advanced) AI Tools & Prompting: ChatGPT, Claude, Cursor, Loveable, n8n, MCP Business Intelligence & Reporting: Power BI, Tableau, SAS Viya, JMP Pro, RapidMiner Cloud & Tools: MySQL, Snowflake (familiar), AWS basics, Docker Collaboration & Support Tools: JIRA, ServiceNow, Microsoft Teams, SharePoint, OneDrive, Power Automate Analytics & Visualization: Data cleaning, EDA, dashboard development, statistical modeling, predictive modeling Professional Experience AI & Data Analyst | Aeonture Corporation, CA      Jan 2024 – Present Worked on automation for on-boarding new restaurants on DoorDash/UberEats platform. Involved in creating a python-based tool to convert digital menu using document provided by Restaurant owners like Excel sheet, Word document or Image of the menu. Created a utility program to enhance the quality of images, specially removing backgrounds of the images to make them more appealing. Created a marketing tool for generating leads using n8n workflow, which automatically reaches to customers using messaging tools like Email, Phone or WhatsApp Created a dashboard for marketing team to visualize the performance of their team activities. Tools: Python, n8n, MCP, MySQL, Paint, PowerBI, Claude, Docker, Ubuntu Graduate Research Assistant | Arkansas State University, AR     Collaborate with the course instructor to organize and prepare course materials, assist in classroom management, and promote student participation through office hours and exam proctoring. Conducted independent research on COVID-19’s impact on volunteerism and student outcome data (e.g., major, graduation year, job status, salary, higher education plans) using Excel and JMP Pro. Skills learned: Data mining, Predictive Analytics with simulation, SAS Viya, SAS Enterprise RapidMiner, Microsoft Power BI, SQL, Microsoft Excel, PowerPoint, data visualization, academic research, JMP Pro, communication, classroom coordination, reporting, time management, Presentation Skills Relevant Coursework: Business Analytics, Data Mining, Predictive Analytics with Simulation, Project Management. Systems Engineer | Zebra Technologies, MD     May 2024 – Aug 2025 Jul 2022 – Nov 2023 Developed SLA tracking dashboards in Power BI, reducing average response time by 15%. Automated IT service desk workflows with Power Automate and PowerApps, cutting manual effort by 20%. Integrated AI prompting techniques into reporting processes to improve ticket categorization and speed of resolution. Ensured accuracy of operational data across SharePoint, Outlook, and Teams, supporting 100+ users.  Resolved incidents and managed problem tracking in ServiceNow, consistently meeting SLA targets and improving customer satisfaction scores. Tools: Microsoft SharePoint, Power Automate, PowerApps, PowerBI Projects AI-Powered Customer Support Web App     Developed a Streamlit web application integrated with the ChatGPT API to deliver automated support for ticket inquiries and FAQs. Built a user-friendly chat interface that combined AI responses with data from a CSV of support tickets, enhancing the accuracy of ticket resolution. Implemented real-time query handling and reporting, reducing manual effort in ticket classification and response generation by 30%. Deployed a working prototype on Streamlit Cloud, demonstrating end-to-end AI-driven workflow automation. Power BI Project         Built interactive dashboards and reports in Power BI using curated datasets. Applied data cleaning & transformation (text, numerical, and date functions, removing nulls/unwanted columns). Designed and optimized data models: relationships, cardinality, and cross-filter directions. Developed calculated columns and measures using DAX (logical, text, date/time, and aggregation functions). Created visualizations: KPI cards, slicers, maps, tree maps, and matrix visuals for business insights. Incorporated AI visuals, bookmarks, and buttons to improve interactivity and storytelling. Published reports to Power BI Service and customized for desktop vs. mobile viewing. Completed multiple end-to-end projects, demonstrating real-world analytics use cases. Website Performance Analysis    Performed data cleaning, exploratory data analysis (EDA), and visualization using Python. Identified user engagement trends, bounce rates, and high-traffic pages. Generated actionable insights to support website performance optimization. Retirement Portfolio Simulation    Simulated over 1,000 investment scenarios using Monte Carlo analysis in Excel. Forecasted retirement outcomes under varying interest rates and contribution levels. Enabled real-time adjustments to optimize investment strategies. Netflix Movie Data Analysis      Cleaned and analyzed Netflix movie dataset using Python (Pandas, NumPy). Handled multi-genre entries and categorized numerical features using quartile-based binning. Visualized ratings, genres, and vote distributions with Seaborn and Matplotlib. Optimized performance by converting string columns to categorical types. Conducted exploratory data analysis with statistical summaries to uncover viewer trends. Leadership & Volunteering Founding Member – YOUWA Foundation, India -)   Designed and delivered interactive sessions on cybersecurity, cyber laws, and safe internet practices for school children. Created educational materials to raise awareness about cybercrime prevention and data privacy.    Led menstrual hygiene awareness campaigns in rural areas, educating adolescent girls on proper menstrual health practices. Advocated for safe disposal methods for sanitary products to promote environmental sustainability. Engaged with community leaders and volunteers to expand outreach and program effectiveness. President – International Student Association, Arkansas State University -)    Led tours for prospective students, showcasing campus facilities, answering questions, and sharing insights about academic resources, extracurricular activities, and campus life. Organized and led events, such as cultural nights, Valentine's Day activities, and game tournaments, while fostering collaboration among student groups to enhance the international student experience. Promoted a positive, inclusive environment, served as a college representative, gathered feedback from new students, and worked collaboratively with other welcome ambassadors to ensure a successful and welcoming experience. Leadership Intern – Women’s Leadership Center, Arkansas State University -)    Attended and actively participated in conferences, mentoring sessions, and workshops aimed at empowering young women and promoting leadership development. Coordinated and assisted in organizing community service projects, including food bank drives, flowers for flowers, cards for caring, domestic violence initiatives, and the Pink Warrior Walk for breast cancer. Conducted mentor spotlight interviews, collaborated with fellow interns to plan events for the Women's Business Leadership Center, and serve as a Step-Up Reach Back Mentor for high school and college freshman girls. Achievements & Professional Certificates      1st Place, Create@Griffin Research Presentation, Arkansas State University (2025) Python Data Structures, Coursera (2020) R Programming, Coursera (2020) Microsoft PowerBI Data Analyst, Coursera (In Progress, Expected Oct 2025) Google Project Management, Coursera (In Progress, Expected Oct 2025) Education Master’s Degree | Business Analytics Jan 2024 – Jul 2025 Arkansas State University | Jonesboro, Arkansas   Relevant Courses: Business Analytics, Data Mining, Predictive Analytics with Simulation, Project Management Merit Scholarship ($10,000 tuition waiver + $1,000 monthly stipend) - Bachelor of Technology | Computer Science Engineering Aug 2018 – Jul 2022 Deogiri Institute of Engineering and Management Studies | Aurangabad, India  Relevant Courses: Python, R Programming, Machine Learning, Database Management System, Business Communication