AKANKSHA CHAUHAN

469-***-**** adc7m2@r.postjobfree.com www.linkedin.com/in/akankshaschauhan/ EDUCATION

The University of Texas at Dallas - Master of Science in Business Analytics May 2020 Relevant Coursework: Data Warehouse, Predictive Analytics, Information System Analysis, Risk Management Certificate of Advanced Study in Data Science

SRM University, Chennai - Bachelor of Technology in Bioinformatics May 2015 Relevant Coursework: Data Mining and Business Intelligence, Project Management, Business Communication TECHNICAL SKILLS:

Programming: Python, R, SAS, STATA, HTML Data Visualization: Tableau, Power BI, SAP Lumira Cloud Computing: Amazon web services, Microsoft Azure Operating Systems: Linux, Windows Databases: MySQL, Oracle Reporting Tools: SAP BusinessObjects, Crystal Reports Tools: Google Analytics, MS-Excel, Amazon QuickSight, SSIS Agile Methodologies: Kanban, Scrum, XP Analytics Techniques: Forecasting, Market Basket Analysis, SWOT Analysis, ARIMA Modeling, Classification, Time Series Analysis, Survival Analysis, Recency Frequency, Workflow Management, Test Case Integration, Production Key Documentation PROFESSIONAL EXPERIENCE

University of Texas at Dallas – Data Analyst Jan 2020 – May 2020

(Customer Segmentation, Market Analysis)

• Analyzed trend and profiled Resource Group Members using SAS to market events within UT Dallas Community

• Created Tableau Dashboards for data management and consumer segmentation to target profitable customers and improve managerial decisions in Diversity Department of the University Targetbase Marketing – Strategic Business Analyst June 2019 – Aug 2019

(Data Management, Data Visualization, Process Improvement)

• Supported various process improvement projects simultaneously by standardizing the data collection and integration process thereby improving efficiency by 70% and ensuring data quality

• Created Regression Models with 75% accuracy using R to predict customers who will respond to a sales call based and presented on PowerBI Dashboard.

• Coordinated with the teams globally to track the progress and assisted with ad hoc data analysis request using R Amazon - Sr. Business Analyst Aug 2016 – July 2018

(SQL, Python, Market Basket Analysis, Predictive Analytics)

• Analyzed Alexa’s Market Share by bringing insights on behavioral data of residents using QuickSight to extend into Conjoint Analysis of customer preferences assisting the management to identify profitable avenues

• Performed Market Basket Analysis using Python to find trending items customers buy for delivering targeted marketing

• Worked cross-functionally with technology, marketing and support teams to investigate customer activities on Alexa’s mobile skills and website and optimized the activities flow by 6%

• Refined Key Performance Indicators (KPIs) to collect all the data, analyzed the key metrics in Tableau to gain insights and recommended strategies to retain customers

• Gathered business requirements and proposed a process flow optimization technique to Product Managers which helped them make better decisions regarding the products Relationship Science - Data Analyst May 2015 – July 2016

(Time Series Forecasting, Text Mining, Data Querying)

• Performed web scraping to extract web data and automated content tagging by using text mining techniques in Python

• Forecasted the sales and promotion values of business clients using Time Series Forecasting with 90% accuracy

• Delivered data analysis requests by executing complex queries in SQL and preprocessing the data in Python KEY ACADEMIC PROJECTS

Data Warehousing (DW) for retail industry (ETL, PowerBI, SSAS) Performed end-to-end DW implementation through dimensional modeling from OLTP and OLAP sources

Social Media Business: Designed a social media platform with web and phone applications connecting dog owners,

Data Mining: Developed a model using LDA, Linear Regression and Random Forest, that looks at middle school math tests and predicts the probability of students opting for STEM career after ten years with a 95+% accuracy using R