Sonali Choudhary

704-***-**** ad2dcm@r.postjobfree.com https://www.linkedin.com/in/sonali-choudhary11 https://github.com/stereo11 Tableau Public EDUCATION

University of North Carolina at Charlotte, Charlotte, NC Expected Graduation: December 2024 Master of Science in Data Science and Business Analytics (GPA: 4.0/4.0) Thadomal Shahani Engineering College, Mumbai, India August 2016 – October 2020 Bachelor of Engineering in Computer Engineering (GPA: 3.5/4.0) TECHNICAL SKILLS

• Programming Languages: Python (Pandas, NumPy, Scikit-Learn, Statsmodel, Seaborn, Altair, Plotly, Matplotlib, Streamlit, PyTorch, TensorFlow), R (dplyr, tidyverse, data.table, ggplot, cluster, forecast), SQL, SAS, C, HTML, CSS

• Technology: AWS, GCP, Adobe, Tableau, Power BI, Snowflake, Apache Airflow, PostgreSQL, MySQL, GitHub, MS Productivity Suite, Qualtrics, Jira Software, Confluence, Visual Studio Code, Anaconda

• Relevant Courses: Applied Machine Learning, Model Risk Management, Advance Business Analytics, Visual Analytics, Business Intelligence and Analytics, Database Systems, and Strategic Business Analytics. PROFESSIONAL EXPERIENCE

UNC Charlotte School of Data Science, Charlotte, NC January 2023 – Present Graduate Assistant – Data Science and Analytics

• Led data retrieval and reporting for the Director of the School of Data Science at UNC Charlotte, resulting in a 48% increase in data accuracy and a 92% improvement in report turnaround time.

• Managed and enhanced the School of Data Science website, resulting in a 73% increase in user satisfaction ratings. Performed regular updates on the website using Drupal, resulting in a 94% decrease in outdated content.

• Produced insightful infographics and enrollment reports in R, offering valuable insights into student trend analysis.

• Designed R and Python courses on DataCamp using Organization tracks, resulting in a 67% increase in user engagement and a 39% improvement in course completion rates, optimizing learning experiences.

• Authored an Alumni Survey on Qualtrics. Designed an interactive Tableau dashboard for the Alumni Report. Ganit Business Solutions Pvt. Ltd, Mumbai, India August 2020 – November 2022 Senior Data Analyst

• Created a Python-based recommendation engine for a pharmaceutical company, suggesting order quantity, upsell, and cross-sell recommendations. Improved app adoption by 28% through personalized suggestions based on the users’ digital persona. Implemented product bundling using Market Basket Analysis.

• Applied DBSCAN and K-means clustering in Python to assist a Malaysian telecom company in identifying regions for 5G market penetration based on estimated demand, existing infrastructure, and demographic factors. Strategically segmented regions into priority clusters and provided investment recommendations accordingly.

• Led a team of 4 in the building, automating, and scheduling of comprehensive decision boards for a retail company.

• Implemented a three-layered architecture involving Tableau for the front end, Amazon Aurora and Postgres for the staging layer, and Apache Airflow for the backend data pipeline and workflow orchestration.

• Formed a logistic regression and cosine similarity-based recommender system using R for a Consumer Goods Manufacturing Company to generate product recommendations to perform targeted marketing. Improved precision and recall value by 31% and 19%.

• Led 3 teams to create forecasting models in AWS for budget planning, inventory optimization, and demand prediction for fast-moving consumer goods.

• Fetched data from Redshift using SQL. Detected and treated outliers using Python.

• Executed comprehensive hypothesis testing and exploratory data analysis (EDA) using Tableau and Python to pinpoint the optimal forecast level and perform feature engineering and selection.

• Deployed several neural network-based and statistical forecasting algorithms (ARIMA, BSTS) using Apache Airflow.

• Established an interactive dashboard using Tableau to provide actionable insights based on important Key Performance Indicators to enhance the performance of the forecasting engine. Increased the forecast accuracy by 49%, reduced wastage by 20%, and stockout by 3%.

• Migrated the on-premises database to Snowflake and created the analytics pipeline in Snowpark.

• Conducted hypothesis generation and expedited EDA in R to swiftly uncover valuable insights to address the CFO's objectives, resulting in an 18% reduction in decision-making time for the retail company.