Divya Soni Email & Phone Number

Kirkland, Wa, Us

Menlo Park, Ca, Us

● Engineered a SQL-based pipeline, orchestrating a quantitative ranking model that seamlessly combined signals from diverse datasets, encompassing engagement rate (watch hours, Likes/Comments/share), followers, and content creation. This empowered the identification of prospective candidates for Managed Support and enabled efficient prioritization of support levels among existing partners.● Boosted Rep productivity by creating datasets and designing a comprehensive global Partner dashboard to provide a 360-degree view of new/existing partners including Partner KPIs and assets across all Meta services(FB, IG etc.), by vertical and Geo.● Automated and scaled Book of Business creation for Account Managers leveraging advanced SQL queries to gather Partner data and match it with Account Managers based on Language, Tier, Geo and Vertical. This streamlined process significantly expedited the onboarding of new teams following organizational changes.● Ensured data reliability by implementing robust data validation procedures by designing and deploying comprehensive data check queries. Leveraged advanced queries to conduct meticulous dataset comparisons over time, uncovering variances, detecting data anomalies, and conducting thorough root cause analyses.

Seattle, Wa, Us

Conducted in-depth analysis of customer reviews and ratings on Amazon products such as Alexa, Amazon Fresh, and Whole Foods utilizing SQL and Python. Employed categorization and tagging techniques to extract valuable insights from survey text, specifically focusing on areas with the lowest ratings.These findings were instrumental in generating ideas for enhancing product features.

San Francisco, California, Us

600+ hours of hands-on course material, with 1:1 industry expert mentor oversight, and completion of 2 in-depth capstone projects. Mastered skills in analyzing business problems, data analysis, presenting business insights to different stakeholders, SQL, Python and data visualization. As part of this program, I developed end-to-end business applicable data analysis projects focusing on Business Analytics, Descriptive and Inferential Statistics, data extraction, visualization and presentation.Capstone Projects:1. Airbnb Pricing model and Interpretations using New York City data using Excel(exploratory analysis), Python(statistical modeling) and Tableau (visualization). • Did comprehensive analysis on how key drivers (such as rating, neighborhood, property type) are impacting the prices.2. Linear Regression and Price prediction on Lyft/Uber Dataset of Boston: Performed comprehensive analysis on every trips of Boston, MA Rideshare applications. This included performing exploratory analysis and visualization using Python (pandas, matplotlib, seaborn, scikit learn) and Tableau and creating linear regression model using Python to identify the drivers and presented in front of different stakeholders.

New Delhi, Delhi, In

Used data analysis skills and metallurgical subject matter expertise to help clients elongate their equipment lifespan by proving targeted intervention and maintenance recommendations:- Analyzed environmental, metallurgy, usage and maintenance data using Excel and SQL to identify corrosive patterns and optimized remedial actions based on the data.- Created ETL pipelines using SQL Server to extract data from different sources like equipments, usage, environmental factors and and brought them together in EIL data warehouse. - Created SQL and Excel based monitoring tools to track equipment usage of different clients and underscore any significant deterioration.

Masters Of Technology, Corrosion Science

Data Analytics Career Track, Certification

Bachelor Of Technology, Metallurgical Engineering