Aditi Dhawan

*** *** *****, *** ****, CA ***** (open to relocation) 312-***-**** add4se@r.postjobfree.com LinkedIn Tableau

• Insightful Business Data Analyst with a background in Fintech & 3+ years’ experience in Data Analytics & Business Visualization

• Data analyst by trade, a strategist & storyteller by craft, with ability to connect business hypotheses & real-world problems to data insights EDUCATION

Masters Business Analytics, University of Illinois At Chicago - Chicago, USA (GPA: 3.76/4) Jan. 2019 - May 2020

• Relevant Coursework: Statistical Modeling, Machine Learning, Data Mining, Supply Chain, Marketing Analytics, Operations & Sales Research Bachelors, Information Technology, Vellore Institute of Technology - Vellore, India (GPA: 3.9/4) Jul. 2013 - May 2017 SKILLS

• Technical Skills: Python, R, SQL, Tableau, Hadoop, Looker, Power BI, Hive, C++, Java, Apache Spark, Teradata, JavaScript, Oracle, ETL

• Analytical Skills: A/B Testing, Google Analytics, Six Sigma, Predictive Modelling, Customer Lifecycle Analysis, Salesforce, CRM, Business Data storytelling, Regression, Random Forest, Principal Component Analysis, Information Security, Text Mining, PMP Certified PROFESSIONAL EXPERIENCE

Vistracks Business Data Analyst – Chicago, USA Jan. 2020 –May 2020

• Improved fuel efficiency by 25% by training data models to predict optimized routes based on 8 KPIs for shipping globally

• Minimized idle time/driver by 40% by visualizing in-depth multivariate analysis of driver, vehicle movements & presented key insights to CEO

• Recommended the clientele to make informed decision about vehicle based on analytical findings of age, mileage & speed University of Illinois at Chicago Data Analyst – Chicago, USA Mar. 2019 – May 2020

• Reduced 15hrs of manual labor/week by automating reports of student performance on 5 KPIs in collaboration with leadership on Tableau

• Forecasted likelihood of student future salary, drop rate with 74% accuracy by building RF & logistic models correlating with 7yrs of past data

• Formulated preprocessing student data in R/SQL from Qualtrics & performed hypothesis tests & analysis in SPSS & Access using anova, t tests PayPal Business Data Analyst – Chennai, India Apr. 2018 – Jan. 2019 Drove process flow for identifying fraud profiles collaborating with Risk, Working Capital, Credit teams: Won Award for spearheading

• Lifted business revenue by 10% by filtering false positives by 1.5X by enabling pre-account onboarding scan for PayPal customer profiles

• Envisioned strategy resulting in 23% new acquired customers combining funnel analysis & marketing data insights boosting activated users Added new features to scan Facebook onboarding customers background for suspicious activity risk reporting using PIIA Data

• Dramatically lessened 24% fraudulent payments in the first 9 months of the rolling period by scanning across 550 attributes

• Established fraudulent transaction identifiers using world check data by analyzing Facebook onboarding profiles on 52 data attributes Led Compliance, Risk teams to Automate Anti-Money Laundering Reports to Regulators for Cross Border Transactions for PayPal Canada

• Slashed Xborder transaction scan by 100% by reporting all transactions/person (~1M/day) from all different accounts/person for AML check

• Pioneered SQL logic for flagging Masspay transactions from daily Xborder transactions for pilot launch of reporting global clients in Australia Standard Chartered Bank Business Data Analyst – Chennai, India June 2017 – Mar. 2018

• Boosted DAUs by 13% by analyzing web traffic by developing & digitizing 2 offline features which yielded customer churn rate by 8%

• Awarded by VP, Analytics for recommending data-driven insights for digital campaign conversion metrics across various customer segments

• Raised conversion rate by 20% on anchoring data-driven strategic decisions after identifying reasons for customer churn during checkout ACADEMIC PROJECTS

Netflix Recommender System based on Customer’s taste – Python, PySpark, Tableau, Pandas, Matplotlib, NumPy Sep. 2019- Nov. 2019

• Built recommender system & provided movie recommendations based on collaborative filtering; achieved RMSE of 0.8845 on predictions US Airlines Flight Delay Analysis– Tableau, Excel, Market Research, Competitor Analysis, Strategy Mar. 2019 – Apr. 2019

• Led a team of 4 to develop an extended strategy using weighted principles for airline industry, competitor analysis, performance metrics Bitcoin Forecasting – Python, Time Series June 2019 – Aug. 2019

• Built predictive models (ARIMA, Neural Networks) in Python and compared model metrics and brought down Error by 14.6% Web Marketing Analytics and Google Ad words: – Google Analytics, WordPress Sep. 2019- Nov. 2019

• Created marketing experiments of landing page, monthly traffic, performed SEO, to improve the performance and engagement of audience with the website by 30% for analyzing web traffic post marketing campaigns for different customer cohorts and customers in funnel Target Marketing Case Analysis– R, Revenue Modelling, Support Vector Machines, Tableau Feb. 2019 – Mar. 2019

• Optimized EDA to obtain 74 significant attributes from 312 by principal component analysis; maximized profit & predicted with 65% accuracy

• Compared predictive models - logistic, gradient boosting, for identifying donors post examining performance of SVM for classifying donors

• Str o ng anal yti c al b a ckgr o u nd a n d e xperi e n c e wi t h m ark et i ng a n aly tics, ROI/fi n a n ci al modeli ng, a n d statistical a n alys i s .

Contact this candidate