Prachi Gaur

About Prachi Gaur

4+ years of experience working with in collecting, consolidating, cleaning, analyzing and visualizing complex business and technical datasets, identify trends and present insights to decision makers to drive business decision.With my strong background in SQL, Python, R and statistics, I transform data from multiple sources into meaningful actionable stories and insights. Key Highlights of my Data Analysis and Business Acumen Experience: Consumer Packaged Good (CPG) industry: Performed market research, competitor analysis, documented key differentiators, and presented the findings to the brand manager and CEO to create a go-to-market strategy. Reviewed and analyzed 50+ product offering and pricing listed on Amazon by multiple vendors/sellers and created Tableau dashboard for inventory forecast Retail Industry: Analyzed 2M+ rows of historical product pricing data, identified customer purchase trends, and created actionable Tableau dashboards, visualizations, and reports for leadership to enhance BSN sports’ product pricing strategies. Automobile Manufacturing Industry: Spearheaded customer demographic and sales requirement gathering from 270 Mahindra & Mahindra dealerships, defined data attributes, and obtained rows of data using SQL queries. Collected rows of customers’ demographic data from multiple sources and streamlined it using Excel formulas, eliminating discrepancies in data samples for marketing teams for 4 emerging M&M products. Identified sales trends, analyzed 3 competitor offerings, outlined customer preferences, and presented the story to the marketing team using a Tableau dashboard, resulting in finalizing promotional offers. Created a dashboard to present monthly sales data findings to leadership to adjust promotional offers and discounts that resulted in increasing $200K in product sales in 2019. Core Skills: Data Analytics: Data Cleaning, Data Visualization, Feature Selection, Feature Engineering, Predictive Modeling, Statistical Analysis, Dashboard, Market Research, Competitor Analysis Machine Learning: Linear Regression, Logistic Regression, Decision Trees, Random Forest, K Means Clustering, Support Vector Machines Programming Languages & Tools: Python, R, SQL, Tableau, MS Office, Advance Excel, Adobe Analytics, Google Analytics, Jira, Rally, Confluence, Trello, Asana, AirTable, ServiceNow Want to learn more about how I can contribute to your team/product\'s vision? Let’s connect! Please message me on LinkedIn.

Experience

1. Data Analyst

   Bungee Tech

   Jul 2023 — Present · Redmond, WA, US

Education

• The University of Texas at Dallas

  Masters, Business Analytics

  2021 — 2023