ARJUN DEWAN
Dallas, TX ***** 469-***-**** ************@*****.*** www.linkedin.com/in/arjundewan92 EDUCATION
The University of Texas at Dallas, Texas May 2018
M.S., Business Analytics (Marketing and Data Science) Amity University, India May 2014
Bachelors in Technology, Electronics and Telecommunications PROFESSIONAL WORK EXPERIENCE
Business Analyst Intern, Harlem Commonwealth Council-New York Jul 2017 – May 2018
Conducted reports for implementation of marketing strategies, leading to 30% growth in customer registrations.
Delivered insightful and accurate reporting to drive business decisions and operational improvements.
Performed deep-dive analysis of Minority/Women Business Enterprise (MWBE) data through SQL and Power BI/Tableau to enable comparative insights among business domains. Perform market assessment and comparative analysis to create process documentation. Contributions had direct result on: o 30% increase in MWBE member registration
o $100,000 revenue increase over 7-month period
o Securing $500,000 dollar grant from Citibank
Business Analyst, Orange Business Services (France Telecom) Dec 2015 – Jul 2016
Drove 4% improvement in target KPI’s through development of daily/weekly/monthly reporting for order data analysis.
Improved customer satisfaction through effective data management (collection/modelling/report generation) to reduce related escalations to 0 within six months.
Unified multiple business stakeholders with varying objectives to drive business growth. Business Analyst, Orange Business Services (Team Lease) Dec 2014 – Nov 2015
Developed customer order reporting for over 100 US projects for prolific customers including Louis Vuitton, EY, Flowserve LMVH and UMG.
Partnered in initiative that resulted in 30% reduction in time spent in taking customer orders.
Accurately developed scheduled and ad-hoc reporting. Partnered with Technical, Finance, Legal and Delivery teams throughout. ACADEMIC PROJECTS
Sales Performance Analysis (Google Analytics) Jan 2018-May 2018
Utilized Google Analytics to determine changes in advertising and discontinuation in successful products were attributable to decline in sales revenues.
Suicide Data Analysis (Tableau) Jan 2018-May 2018
Determined causation reasons for suicide rates in India, determined factors around familial and health quality. Marketing Analytics (SAS) on NGO’s Donor’s Data Set Feb 2017 – Mar 2017
Delivered analysis for Non-Governmental Organization (NGO) to understand influential and predictive factors around donation behavior. Data included ZIP code level demographics, appeals sent to donors, and past donation behavior. Predictive Analytics (SAS) on Customer Purchase Data Jan 2017 – Mar 2017
Performed analysis on 12 years of customer purchase data for catalog retailer to derive noteworthy purchase patterns. Database Management (SQL) Project on Health and Fitness Center Database Jan 2017 – May 2017
Managed database that allows gym members to monitor different health measurements and progress tracking. SAS Project on Nursing Home Rating Sep 2016 – Dec 2016
Analysis of data to find five best/worst nursing homes from resident’s perspective across each individual US state. TECHNICAL SKILLS
Tools- MS Excel, SAS Enterprise Miner, MS PowerPoint, MS Word, Tableau, Power BI, Google Analytics, Adobe Analytics Programming- SQL, SAS, Python (Pandas, NumPy, Scikit-Learn, Matplotlib), Hive, Pig, Spark, STATA Databases- SQL Server, RDBMS, MS Access