Data Analyst Science

RAMOLI CHOUDHARI

United States *****************@*****.*** 979-***-**** LinkedIn

EDUCATION

Texas A&M University College Station, TX, USA

Master of Science in Industrial Engineering - Data Science Specialization, GPA (3.5/4.0) Dec 2024

Coursework: Engineering Data Analysis, Big Data Tools & Databases, Advanced Statistical Control, Design of Experiments

Dr. Vishwanath Karad MIT - WPU Pune, MH, India

Bachelor of Technology in Mechanical Engineering, CGPA (9.06/10.00) July 2021

EXPERIENCE

Data Analyst Intern, Changing the Present Feb 2025 - Present

● Automated ETL pipelines using Python to extract data from CSVs and Google Sheets, with outputs stored in Azure Blob Storage

● Analyzed donor and campaign data with EDA and PostgreSQL to develop Tableau dashboards tracking 12+ KPIs, uncovering

engagement patterns that informed targeting strategies and improved donor outreach

Analyst, Compass Group Aug 2023 - Dec 2024

● Led a 2-member team to develop a Power BI dashboard by transforming raw POS transactions into actionable inventory metrics,

driving a 33% reduction in product shortages and excess stock

● Achieved targeted sales costs by implementing dynamic pricing strategies, optimizing prices to increase profit margins by 18%

Analyst - Commercial Operations & Business Analytics, IQVIA Jul 2021 - Jul 2022

● Operationalized Alteryx workflows & Excel for targeting model, leveraging claims data to determine customers across 84 sales

territories, resulting in 81% runtime reduction

● Crafted backend SQL logic to validate metrics for UAT and automated QBR reports to track new product performance through KPI

analysis, improving reporting efficiency by 42%, leveraging joins, case statements, and window functions

● Employed fuzzy match algorithms in Alteryx to clean affiliations data and incorporated insights from secondary market research,

eliminating 99% of manual effort and improving overall process efficiency

● Developed model to predict timing and propensity of product usage from user behavior with 62% precision and recall

● Engineered interactive Tableau dashboards for 16+ KPIs, supporting cross-functional collaboration across sales, marketing, and

executive teams to accelerate data-driven decision-making

● Formulated Business Requirements Documents (BRDs), consolidating RWD into actionable insights, tailoring segmentation

strategies to meet client objectives and enhance strategic precision

Continuous Improvement Intern, Sandvik Coromant Dec 2020 - Jun 2021

● Spearheaded a Tableau dashboard initiative to track demand and pricing for inserts, reduced production costs through material

efficiency, and aligned supply with demand via supplier collaboration

PROJECTS

Cancer Mortality Prediction

● Conducted feature selection using statistical significance and multicollinearity diagnostics on health data, identifying incidence

rate, median income, and racial demographics as key drivers of cancer mortality

● Compared Linear Regression and KNN in RStudio, achieving 19.7 RMSE vs. 25.4 with a 22% improvement in test accuracy

Lean Manufacturing- TWI Steering arm assembly

● Examined AS-IS state using Visio, designed TO-BE layout leveraging 5S, applied 8-steps of Value Stream Mapping to optimize

production processes, identified bottlenecks, and implemented process improvements resulting in 80.2% reduction in lead time

Demand Forecasting using Python

● Performed data filtration using Pandas & exploratory data analysis using Matplotlib & Seaborn to plot scatter plots & correlation

matrix to identify relations, trends & patterns in data, eliminating variables with high collinearity

● Trained KNN, Boosting, and Random Forests regression models on training data & computed MSE on test data, with Random

Forest regression providing lowest MSE of 0.4 & hence was used to predict demand of SKU’s

SKILLS

● Languages/Databases: Python, R, MySQL, PostgreSQL, NoSQL

● Data Visualization: Tableau, Power BI, DAX, Looker, Advanced Microsoft Excel (PivotTables, Macros & VBA)

● Data Engineering & ETL: Alteryx, Microsoft Azure, Snowflake, MS Access, Salesforce

● Statistical Tools & Core competencies: SAS, MATLAB, Minitab, SPSS, MS Visio, Agile Methodologies, A/B Testing, Lean Principles

Contact this candidate