Rahul Bansal

• Bentonville, Arkansas, ***** • 860-***-**** • adc7m5@r.postjobfree.com • LinkedIn • Tableau Analytics professional with 4 years of experience in Data Science, generating insights, storytelling, automating, developing and compiling reports and dashboards using Tableau. Proficient in Statistics, Machine Learning, Data Modeling, R, Python, SQL, Tableau. Extensively applied data driven techniques/machine learning algorithms to solve real world business problems EDUCATION

University of Connecticut - M.S. in Business Analytics and Project Management (GPA 3.7/4.0) Jan 18 - May 19 Manipal University - Post-Graduation Diploma in Banking and Finance (GPA 8.53/10.0) Aug 14 - May 15 Uttar Pradesh Technical University - Bachelor of Science in Electrical and Electronics (GPA 8.25/10.0) Aug 10 - May 14 SKILLS

Programming & Tools: SQL (Oracle, SQL Server), R, Python, TABLEAU, MicroStrategy, MS Excel (Pivot Tables, VLOOKUP etc.), SAS JMP, SAS Miner, MS Visio, Power BI, Google Analytics, Alteryx, SAS Enterprise Guide, JIRA Statistical Analysis & Machine Learning: Linear Regression, Logistic Regression, Decision Trees, Random Forest, Hypotheses Testing, Clustering, A/B Testing, Exploratory Data Analysis, Data Visualization, Data Warehousing, Data Wrangling, Marketing Analytics, Customer Analytics, Web Analytics, Data Interpretation and Modelling, Segmentation PROFESSIONAL EXPERIENCE

Mu Sigma Business Solutions, LLC Walmart (Health and Wellness) Bentonville Data Analyst Oct 19 – Present

• Collaborated with analytics team to gather drugs data from multiple data sources using SQL, structured data for analysis while maintaining data quality and generated reports as per business requirement

• Developed and maintained BI Dashboards for executives in Tableau and presented insights and recommendations to senior management on optimizing the total cost in buying drugs from different vendors Mu Sigma Business Solutions, LLC Walmart eCommerce San Bruno Product Data Analyst July 19 – Sep 19

• Identify shopper trends, track ad inventory, evaluate product placements to help understand current advertising efforts and find new areas to optimize customer experience

• Build data pipelines using SQL / HiveQL in order to power dashboards in DOMO. Also, resolve data issues and modify data pipelines as per updated data schemas

University of Connecticut – Client - LIMRA Hartford Graduate Analytics Consultant Aug 18 – Dec 18

• Identified key factors leading to Fixed Indexed Annuities contract cancelation and profiled customers on those factors

• Predicted potential FIA contract termination by building Random Forest model with 71% accuracy

• Visualized the data using Tableau and Python to identify the key factors in the policy that leads to termination Axis Bank LTD India Assistant Manager Data Analyst Jun 15 - Dec 17 CUSTOMER ANALYTICS & MARKETING ANALYTICS

• Performed market research and root-cause analysis on problem areas influencing Axis Bank customer base

• Analyzed customer behavior using transactional and demographics data to identify highest revenue generating and high-risk categories customer segments by performing customer segmentation in Tableau

• Evaluated Customer Lifetime Value (LTV) by performing Cohort Analysis, reported monthly retention rates for cohorts based on acquisition date that helped in understanding customer trends

• Led a team of 4 people, performed Competitive Market Analysis to examine market trends and proposed marketing and pricing strategies to increase customer engagement and conversion rates: improving CR by 16%

• Produced monthly marketing performance reports, & performed Gap analysis to identify inefficient business process and redesigned marketing campaign using social media channels for high marketing ROI

• Analyzed and enhanced website traffic using Google Analytics and performed A/B testing

• Identified factors affecting loan default and designed interactive dashboards that helped Axis optimize its interest rates to avoid potential credit risk

• Managed projects following Agile–Scrum methodology and handled Sprint planning, Daily Scrum and Backlogs

• Simplified the initial screening process of the loan applications by building various classification models and predicting if the application will be accepted or rejected; Random Forest was identified as the best model with the least misclassification rate of 22%; Reduced the work load of the underwriters by 30% and making it more efficient DATA WAREHOUSING & REPORTING

• Worked with Top Management to design customizable and responsive Monthly Operational Report (MOR) using Tableau and SQL; saving 120 Man-hours annually

• Collaborated with data engineers to implement ETL process using Talend, wrote and optimized SQL queries to perform data extraction and merging from Oracle

• Acted as a liaison between business unit and IT consulting team for performing ad-hoc analysis & reporting, gathering business requirements and business process workflows and presented to the clients