Arashdeep Kaur

Los Angeles, CA ***** 805-***-**** ac03e4@r.postjobfree.com

Data Visualization Portfolio: https://public.tableau.com/profile/arashdeep.kaur#!/ LinkedIn Profile: https://www.linkedin.com/in/arashdeep-kaur-23771033 A Data Enthusiast with a proven track record of providing actionable insights to help businesses grow and improve Education

Carnegie Mellon University Pittsburgh, PA

Master of Information Systems Management May 2017

(Coursework: Statistics for IT Manager, R Programming, Data focused Python, Big Data, Decision Making under Uncertainty etc.) Thapar University Patiala, India

Master of Computer Applications May 2012

(Coursework: Statistics and Combinatorics, Discrete Mathematics, System Analysis & Design, Advanced Java etc.) Skills

• Functional: Data Visualization, Data Analytics, Web Analytics, Statistical Analysis, Business Analysis, Agile Scrum

• Business Intelligence Tools: Tableau, Google Analytics, SAP Business Objects, Minitab, SAP Lumira,

• Languages & Scripting: SQL, PL/SQL, R Programming, JavaScript, D3, Python, C, C++, HTML, Java,

• ERP & Databases: Oracle 11g, MongoDB, Redis, Cassandra, Neo4J, SAP ECC 6.0, SAP HANA

• Business Tools: MS Excel (Pivot, VLookups etc), MS SharePoint, MS Visio, MS Project, IBM Rational Academic Projects

Carnegie Mellon University May 2016 - May 2017

Customer Churn Analysis and Recommendations for Retention MS Excel, R, Shiny

• Presented insights from the customer care data of a Point-of-Sale system by performing exploratory data analysis.

• Concluded the reasons and trend of customer churn based on the insights.

• Recommended a strategy to improve customer support process to reduce the number of customer care cases. Website Traffic and Conversion Analysis from A/B Testing Tableau, Google Analytics, MS Excel

• Evaluated A/B Test results for a leading newspaper website to test the impact of enhancements on the site.

• Concluded the analysis in favor of test variant which showed 40% more traffic and 50% more conversions. New York Crime Analysis Python (numpy, scipy, matplotlib, pandas)

• Presented insights from the New York crime data categorized by boroughs, crime type, criminal’s age/gender etc.

• Used numerical and statistical functions to support the analysis and design visuals in Python. Market Campaign Success Analysis of an Ecommerce website R, MS Excel

• Analyzed the pre-campaign and post-campaign data for an ecommerce website to measure the effect on sale, customer engagement, up-selling, and cross-selling etc.

• Used Inferential Statistics like t-tests to determine the effectiveness of campaign. Statistical Analysis of Income Gap between men and women in the USA R, MS Excel

• Analyzed various factors that affect the income gap between men and women in the United States by employing statistical techniques like Correlation, Regression, Clustering, t-tests, ANOVA etc.

• Presented the insights in a report that can be used by government or other policy making bodies. Work Experience

Deloitte Hyderabad, India

Senior Analyst (Data and Business Analysis) June 2015 - May 2016

• Led Agile development of 2 finance projects by acting as a scrum master, leading scrum calls and review meetings.

• Designed innovative dashboards in Tableau to provide business insights on financial KPIs to various stakeholders.

• Influenced business decisions of process improvement in financial workflows by 40% through the insights obtained from the dashboards.

• Leveraged MS Excel Analysis for Office, vLookup, pivot tables etc. to analyze the monthly financial reports from the SAP systems and presented insights to senior leaders.

• Spearheaded several training sessions on BI Tools like Tableau and SAP Lumira for teams in USA and India.

• Collaborated with internal and external stakeholders to translate their business needs into data-oriented solutions.

• Proactively initiated and lead several proof-of-concepts to develop innovative data solutions for clients. Analyst June 2012 - May 2015

• Analyzed business requirements of about 15 change requests by engaging with cross-functional teams.

• Extensively used SQL queries to generate custom reports and perform data management activities in the SAP system.

• Optimized SQL queries during HANA migration project to reduce the report execution time by 80%.

• Demonstrated excellent problem-solving skills by resolving about 200 production issues in the user applications.

• Maintained several back-end SAP jobs to ensure 100% on time execution in the production system.

• Authored user stories and technical documents for technical and data solutions.

Contact this candidate