Business Analytics Data Science

Amitesh Pratap Singh

Irvine,CA *****************@*****.*** 949-***-**** amiteshpratap16

Education

University of California, Irvine, The Paul Merage School of Business July 2024 – June 2025 Master of Science in Business Analytics

Institute of Technical Education & Research July 2017 – June 2021 B.Tech in computer science

Experience

Data Science Intern, PAN Group – California, US January 2025 – Present

• Built 5+ scalable ETL pipelines using Python, SQL, and Apache Airflow to process structured and unstructured investment data, optimizing data storage and retrieval for venture analysis.

• Engineered complex SQL queries to combine forecast and actual data, calculate forecast accuracy, identify root causes of deviations, and recommend actionable improvements.

• Designed and built real-time Tableau dashboards to visualize forecast accuracy trends, monitor monthly demand fluctuations, automate data updates, and deliver data-driven demand predictions. Systems Administrator Technology Operations, Walmart – Bengaluru, IN May 2023 – July 2024

• Collaborated closely with stakeholders to gather analytical requirements and developed 5+ interactive Tableau dashboards to monitor customer complaints and success metrics, enhancing customer experience through data-driven insights.

• Conducted in-depth analysis of critical replenishment KPIs, uncovering outliers, trends, and data inconsistencies; implemented 20+ data quality rules, resulting in an 18% reduction in data support tickets.

• Automated keyword validation by creating an Excel macro and KPI tracker to bulk open URLs and detect 250+ Walmart private-label keywords in sponsored ad campaigns—saving 1 minute per campaign and totaling 30+ hours monthly, while ensuring compliance and protecting brand integrity on Walmart’s e-commerce platform. Associate, Mediamint – Hyderabad, IN June 2021 – May 2023

• Partnered with Hulu’s campaign and analytics teams to design and launch Tableau dashboards that monitored ad delivery, impression pacing, and undeliverable risks, improving campaign visibility and reducing potential revenue loss.

• Executed 500+ SQL queries on client datasets to support campaign analytics and generate detailed performance reports, contributing to a 20% improvement in data-driven decision making.

• Constructed and optimized database schema, tables and stored procedures, improving query performance by 25% and ensuring high data accuracy for reporting and insight. Projects

SMS Spam Classification Model

• Processed 5,000+ SMS messages using Pandas by cleaning data through the removal of 500+ duplicates and handling all missing values to ensure quality input for modeling.

• Employed 3 key NLP techniques (tokenization, stopword removal, and TF-IDF) to extract features and improve data representation.

• Trained and compared 3 machine learning classifiers (Logistic Regression, Naïve Bayes, SVM), achieving an overall 91% F1-score on test datasets.

Sentiment Analysis and Emotion Detection App

• Created a Tkinter-based GUI integrating sentiment analysis, Named Entity Recognition (NER), and emotion detection, processing 10,000+ text inputs using 3 external APIs for real-time classification.

• Implemented a 2-step secure authentication system, doubling user data protection and significantly enhancing overall app reliability.

Skills

PowerBI Certification: Microsoft Certified PowerBI Data Analyst Associate Data Management: SQL Server, MySQL Workbench

Programming and BI Tools: SQL, Python, MATLAB, Excel, Tableau, SPSS, C, C++, JavaScript, HTML, Jira Statistical Method: Hypothesis Testing, ANOVA, ChiSquare Test, T-test, p-value, A/B Testing

Contact this candidate