Debaarati Mitra

adjg45@r.postjobfree.com 215-***-****

SUMMARY

• MS Business Analytics graduate student with 3 years of experience in data analytics, data mining, and business intelligence.

• Strong expertise in SQL, Python, Tableau, Power BI, and Advanced Excel EDUCATION

Drexel University, LeBow College of Business, Philadelphia, PA Anticipated Mar 2021 Master of Science in Business Analytics

Guru Gobind Singh Indraprastha University, New Delhi, India May 2016 Bachelor of Technology, Instrumentation and Control Engineering SKILLS

Languages: Python (pandas, scikit-learn, xgboost, apriori), SQL, R Tools: Power BI, Tableau, Google Analytics, Advanced Excel (VLOOKUP, pivot, Power Query), Talend Analytical Supervised Learning (logistic regression, random forest, decision trees, gradient boosting, associative rule), Techniques: Unsupervised Learning (K means clustering, principal component analysis), A/B Testing Databases: Amazon RedShift, Microsoft SQL Server

PROFESSIONAL EXPERIENCE

CONTINUUM HEALTH June 2020 to Sept 2020

Data Analyst Intern

• Used multi-linear regression in Python and advanced Excel to predict provider charges and insurance payments with 87% accuracy.

• Saved 80% time by automating, on SQL, the monthly process of performing ETLs and calculating KPIs on insurance data.

• Created Power BI dashboards that visualized financial data, enabling managers to zero in on areas needing attention. ACCENTURE Nov 2016 to Aug 2019

Business Analyst (Aug 2018 to Aug 2019)

• Designed ER models that increased the ETL team’s efficiency when creating scalable data warehouses.

• Performed exploratory data analysis of insurance claims data and formulated a standardized performance metrics for M-O-M evaluation.

• Conducted competitive analysis and created benchmark based KPIs for the marketing team.

• Employed Python scripts to automate the process to download and prepare data for Tableau reporting solution. Application Development Analyst (Jun 2018 to Aug 2018)

• Developed SAP ABAP programs to fetch data from the SAP application server, pre-process it and validate it and prepared financial documents for the transaction of the client and created visualizations.

• Provided training to fellow software developers, lead workshops and knowledge transfer sessions.

• Received the Outperformer Award for providing solutions timely, to the critical issues faced by the clients. Associate Software Engineer (Nov 2016 to May 2018)

• Developed SAP ABAP programs for FI, MM and SD modules.

• Improved time efficiency by 40% by automating the process of updating the database that stored the assets created for the client.

• Implemented SAPSCRIPTS and SMARTFORMS to design sales order and invoices for the client. PROJECTS

• Improving sales by running an A/B Test (2020)

Designed a survey to run an A/B testing experiment amongst 500 participants to understand whether a created variation can improve the sales of a coffee shop. The data received after the completion of the experiment was statistically analyzed in R programming language.

• Customer Segmentation for Increasing Sales (2020) Devised a model using Python programming language to segment a dataset of 5000 customers for predicting purchasing patterns using RFM analysis and K Means clustering that would increase the response rate and sales of the store.

• Prediction of Chronic Kidney Disease (CKD) (2020) Designed a logistic regression model to ascertain the likelihood of CKD in a dataset of 8000 people and developed a screening tool that predicts the same with 97% accuracy.

• Data Quilting on Harry Potter Scripts (2019)

Used R programming language to perform Natural Language Processing, for text mining, sentiment analysis and social network analysis, on a movie script to analyze how specific characters impacted the box office sales of the movie.

Contact this candidate