Yugmi Bhatt Email & Phone Number

United States

New York, United States

• Design and implement robust data pipelines using Hadoop and PySpark to process large sales datasets, with a focus on automating data cleaning and imputation for real-time analytics.
• Develop and optimize ETL processes utilizing Hive, PySpark, and SQL, streamlining data extraction, transformation, and loading to enhance data accessibility for business intelligence.
• Collaborate with data scientists to integrate machine learning models, such as random forests and logistic regression, into production pipelines for predictive analytics.
• Improve SQL query performance by 30% through effective indexing, query tuning, and refinement of stored procedures in SQL Server Management Studio (SSMS).
• Leverage AWS services, including Lambda, RDS, and DynamoDB, to scale data processing pipelines while building interactive dashboards in Power BI and Tableau for actionable insights.

United States

• Assisted in redesigning and automating data pipelines using Hive and PySpark, contributing to improved operational efficiency and timely delivery of key reports for senior leadership decision-making.
• Collaborated with the Product team to develop an internal data management tool using SQL and Tableau, enhancing data integrity and accessibility for stakeholders.
• Supported the creation of a compliance tracker in Asana to monitor contract obligations, facilitating smoother communication between Spotify and its partners.
• Analyzed data using Python and R to evaluate the performance of an internal matching tool against a third-party option, providing insights for data quality enhancements.
• Engaged with cross-functional teams to validate data from various sources, participated in discussions on data architecture, and assisted in training sessions on data annotation and quality control processes.

India

• Developed interactive dashboards in Power BI and Tableau with color coding for performance metrics, enabling quick assessments of success (green) and areas needing attention (red).
• Created advanced DAX measures for insights like year-over-year sales growth and customer segmentation, empowering datadriven decision-making and strategic enhancements.
• Streamlined data extraction and transformation using SQL and Hive, ensuring accurate and reliable datasets for reporting and analysis, while improving data integrity through validation and cleansing with Python and R.
• Produced custom visualizations, including funnel and waterfall charts in Power BI, effectively transforming complex data into actionable narratives for team members.
• Collaborated with cross-functional teams using JIRA for project tracking, automated reporting tasks in Power BI and SQL via Microsoft Flow (Power Automate), and documented processes in Confluence to promote data.

India

• Enhanced data workflows by creating SQL stored procedures and Python scripts for efficient ETL of customer and transaction data using Hadoop, improving data accessibility for the team.
• Developed interactive Tableau dashboards to highlight customer segments and purchasing patterns, identifying a 15% drop in satisfaction rates that prompted targeted service quality initiatives.
• Performed K-means clustering on a 10K customer dataset using Python and Hive to uncover distinct segments, facilitating more personalized marketing strategies.
• Extracted meaningful insights from large databases using SQL and Hadoop, enabling data-driven decision-making and improving operational efficiency.
• Analyzed trends and patterns with Python libraries like Pandas and NumPy, communicated findings through clear visualizations and reports, and collaborated with cross-functional teams to ensure data accuracy and.

India

• Collaborated with stakeholders to document business requirements and shape a customer segmentation strategy for product quality assessment, utilizing Excel and Jira for effective project tracking.
• Analyzed data for the product quality team to identify key customer segments, enhancing product quality and customer satisfaction through impactful reporting in Power BI.
• Improved inventory data accuracy by 20% and reduced processing time by 30% via SQL-based data extraction and ETL processes using Hadoop, while developing SQL queries for a sales forecasting tool to enhance forecast.
• Streamlined data cleaning and transformation for customer behavior analysis, reducing manual tasks by 40%, and participated in A/B testing for email campaigns using Python, resulting in a 25% increase in open and.

Master Of Science - Ms, Computer Science

Courses: Design and Analysis of Algorithms Principles of Operating Systems Structured Programming and Formal Methods Computer Architecture.

Bachelor Of Engineering - Be, Computer Engineering, 9.4

Relevant Courses: Data Structures and Algorithms Database Management Systems Operating Systems Computer Architecture Cloud Computing.