About Me

Analytics professional with 2+ years of experience in Data Science, Business Analytics, and Business Intelligence. Passionate about leveraging data to craft compelling narratives and support strategic decision-making. Skilled in using SQL, Python, R, Tableau and Excel to transform complex datasets into actionable insights for business decisions. Demonstrated success in leading cross-functional projects and teams, proven track record in e-commerce, finance and supply chain. Adept at forecasting, data analysis and predictive modeling.

Email:
ragraw9@gmail.com
Phone:
+1 (224) 454-6844
Location:
United States
Languages:
English, Hindi, Spanish
Areas of Interest

Business Intelligence

KPI monitoring, dashboard creation, quantitative analysis, strategic reporting

Analytics

Customer segmentation, market basket analysis, recommendation systems, A/B testing, hypothesis testing

Database Management

Data wrangling, maintaining, and retrieving data from databases, developing and automating query processes.

Machine Learning

Statistics, probability, time series analysis, predictive modeling, model training and fine-tuning.

Stakeholder Management

Client communication, requirement gathering, project coordination, reporting.

Financial Analysis

Forecasting, budgeting, P&L analysis, advanced Excel (VLOOKUP, Pivot tables, financial modeling, data analysis)

Work Experience
HappiLabs

Jan 2024 - May 2024

Brand Analyst Intern

  • Led a team of 5 to drive market entry into the academic sector, conducting market research, SWOT analysis, and trend analysis. Developed tailored pitch decks and a tiered subscription model, generating $500K in new purchase orders
  • Implemented a Prophet model (15% MAPE) to forecast quarterly store sales, optimizing cash flow and reducing low-turnover inventory losses, increasing revenue by $100K
  • Built Tableau-based vendor scorecards tracking 20+ KPIs (delivery time, defect rates), identifying supplier inefficiencies that enabled contract renegotiations, reducing logistics costs by $25K

Tableau | SQL | Python
University of Illinois

Aug 2022 - May 2023

Graduate Teaching Assistant

  • Collaborated with 2 instructors to guide 200 students on methods of statistical analysis in R, Excel, SPSS, and Tableau through lectures and assignments, increasing average class grade by 20%.

R | SPSS | Excel | Tableau
Deloitte

Jun 2021 - Jun 2022

Marketing Analyst (Contract)

  • Performed customer segmentation on 5TB transaction data using K-Means clustering on RFM features to identify 5 customer personas enabling personalized marketing strategies, increasing sales by $200K
  • Automated retargeting sequences by integrating Salesforce CRM with MoEngage, triggering personalized email & push notifications based on cart value & user behavior (wishlisting, repeat search) that increased checkouts by 5%
  • Surveyed 10K+ cart abandoners via Qualtrics, identifying hidden costs driving a 12% drop-off. Introduced upfront shipping fee estimates, increasing checkouts by 8%
  • Developed campaign performance reports in SQL & Google Analytics, tracking multi-touch attribution across 5 digital campaigns. Enabled budget reallocation, cutting festive sales ad spend by 15%
  • Implemented cohort analysis in Python & Tableau, comparing first-time vs. repeat buyers, launching a targeted discount strategy that recovered 5% of at-risk customers
  • Performed market basket analysis to identify high-affinity product pairs. Collaborated with marketing to A/B test (t-test, chi-square) bundled promos, increasing average order value by 12%

Python | BigQuery | Tableau | GA4
RattanIndia

Jan 2021 - Jun 2021

Marketing Analyst

  • Conducted A/B testing on push notification timings for 50K credit card users, identifying optimal hours and increasing monthly sign-ups by $45K
  • Consolidated siloed marketing data into a Google Data Studio dashboard, reducing manual reporting time from 12 hours to 2 hours
  • Developed a predictive lead scoring model using Random Forest (F1 Score: 0.85) in HubSpot CRM to analyze behavioral, engagement, & demographic data, improving conversion of sales qualified leads by 20%

Python | SQL | HubSpot | Google Data Studio
National Informatics Centre

Feb 2020 - Jun 2020

Data Analyst Intern

  • Performed ETL process using SQL on national healthcare data improving data efficiency by 25%
  • Developed Tableau dashboard to track the rise and spread of COVID-19 in India, presenting KPIs to stakeholders facilitating government healthcare policies
  • Researched and compared facial-recognition systems such as HoG, CNN, using Python achieving 80% accuracy

SQL | Python | Tableau
Manipal University Jaipur

Jan 2021 - Jun 2021

Research Assistant

Python | RapidMiner

Education

University of Illinois at Chicago

Aug 2022 - May 2024

Master of Science

Management Information Systems

  • Relevant Coursework: Database Management, Statistics, Web Analytics, Data Storytelling, Project/Vendor Management, Finance, Supply Chain Operations
  • Tutor: Guided 10 students to achieve A grade in Data Analysis (IDS237), Intro to Finance (FIN256) and Marketing (MKT210)
  • Flames Consulting Group: Organized mock case interviews & networking events increasing community engagement by 30%

Manipal University Jaipur

Aug 2017 - Jun 2021

Bachelor of Schience

Information Technology

  • Relevant Coursework: Database Management, Data Structures & Algorithms, Micro/Macro Economics, Calculus, Product Lifecycle Management
  • Key Certifications: Managing Big Data with MySQL , Data Visualization and Communication with Tableau (Duke University), Data Analysis with Python (IBM), Machine Learning Bootcamp (ForskLab Technologies)

Projects

Contact Me
Connect with me

Address

United States

Phone

+1 (224) 454-6844

Email

ragraw9@gmail.com