Talk to sales Try for Free
Payal Chandgude

Payal Chandgude

Analyst

Followers of Payal Chandgude592 followers
location of Payal ChandgudeSan Diego, California, United States

Connect with Payal Chandgude to Send Message

Connect

Connect with Payal Chandgude to Send Message

Connect

  • Timeline

  • About me

    Sr Analyst at TransUnion

  • Education

    • Savitribai Phule Pune University

      2012 - 2016
      Bachelor of Engineering - BE Mechanical Engineering 64%

    • The University of Texas at Arlington

      2021 - 2022
      Master of Science - MS Business Analytics

      Data Science and Machine Learning using Python: 1. Web Scraping • Scraped and Analyzed data from metacritics.com to create a Database for top 500 movies using Python programming with Jupyter Notebook.• Selected top 500 movies from All-time favorites and created dictionaries with Movie Name, Directors and Cast information to let user fetch the details by movie name.• Compared the number of times an actor/actress appeared in the list and analyzed the career graph for most… Show more Data Science and Machine Learning using Python: 1. Web Scraping • Scraped and Analyzed data from metacritics.com to create a Database for top 500 movies using Python programming with Jupyter Notebook.• Selected top 500 movies from All-time favorites and created dictionaries with Movie Name, Directors and Cast information to let user fetch the details by movie name.• Compared the number of times an actor/actress appeared in the list and analyzed the career graph for most appeared.2. Predicted Genre of Movie• Performed preprocessing and cleaning on a data of 20,000 movies.• Created data frames to sort and access data.• Developed multiple predictive models to train data from IMDB that can predict the genre of movies. Show less

  • Experience

    • Accenture

      Nov 2016 - Sept 2019
      Analyst

      • Collaborated with remote development teams and stakeholders to communicate Business Requirements.• Developed 300+ test plans and test scripts including regression and production readiness test plans.• Worked with SMEs and IT teams to develop and implement new automation test scripts using Selenium and UNIXwhich helped to reduce 50+ manual hours per feature release.• Managed an offshore team of 3 QA analysts, to successfully test and deliver Black Friday Deals for customers.· Created Key Performance Indicators (KPI) and presented it to the management to build business plan.• Awarded DU recognition for exceptional performance for meeting On-Time Delivery KPI. Show less

    • Vodafone

      Jan 2020 - Dec 2020
      Senior Analyst

      • Conducted requirement elicitation with stakeholders, created Requirement traceability Matrix and prepared test design suits to aid in validating application expectations.• Documented business deliverables, created test artifacts including daily/weekly status report and test signoffs to track test progress and maintain records.• Developed SQL queries in MySQL to perform data analysis for Backend Data Verification and to retrieve Test Data.• Partnered with developers to automate manual test processes to save up to 20+ manual hours per week. Show less

    • Jacobs

      Jun 2022 - Aug 2022
      Business Analyst Intern

      · Analyzed Rolling Forecast data in Excel to create and deploy Power BI reports and dynamic dashboards to track overbudget projects. · Extracted data from multiple sources to track and analyze Project Baseline, New Forecast, and Actuals, as well as doing root cause analysis to discover variables causing budget overuse.· Assisted the Project Controls team upload staffing plans to the Workforce Planning tool. · Using Excel formulae (OFFSET, SUMIFS, CHOOSE), automated the import of staffing plans, reducing manual efforts by 50%. Show less

    • TransUnion

      Jan 2023 - now
      Sr Analyst - Insurance Operations

  • Licenses & Certifications