Data Analyst

AISHWARYA MOHAN BHONDE

adhk4m@r.postjobfree.com 443-***-**** https://www.linkedin.com/in/aishwarya-bhonde/ Education:

University of Maryland Baltimore County Jan 2019 - Dec 2020 Master of Science in Information Systems, GPA: 3.9 MIT College of Engineering, Pune, India Aug 2012 - Jun 2016 Bachelor’s in Information Technology, GPA: 3.5

Technical Skills:

• Languages: Ruby on Rails, Python, JavaScript

• Tools: Tableau, Grafana, Git, Power BI, Elastic Search, PyCharm, Anaconda, Linux, Microsoft Office, Excel, Eclipse, Bugzilla, Jenkins, Rally, Jupyter, Jira, Confluence, Docker, Databricks, Google Analytics, Google Data Studio, MS Visual Studio

• Databases and Servers: MySQL, PL/SQL, Oracle Developer, MongoDB, web logic, Apache, Unix, Cassandra, Neo4j, MS SQL

• Data Analytics/ Data Mining: Data pre-processing, Data Warehousing, ETL Technologies, Data Visualization, SSRS, SSIS, SSAS

• Library: Matplotlib, Seaborn, ggplot, plot.ly, Pandas, PySpark, NumPy, Sci-kit, Opne CV, JQuery

• Web & frameworks: XML, HTML, Bootstrap, CSS, Ajax, Rest API, JSON, WordPress

Work Experience:

Software Developer Intern- Hawkeye MedTech Inc Columbia, MD Aug 2020 - Present

• Performed manual, functional and regression testing for telemedicine application during the development phase.

• Resolved production defects by establishing and managing defect life cycle, test planning, test case creation and leading defect triage calls to increase the efficiency of the product.

• Managed application development including functional and technical specifications, design, development, and support. Data Engineer Intern- SS&C Intralinks Waltham, MA May 2020 - Aug 2020

• Developed a new modular framework by creating dynamic Grafana dashboards for monitoring the internal Infrastructure.

• Extracted the internal services data from MySQL Database by implementing code using Ruby on Rails and logged the data on Elastic Search cluster, monitoring and scheduling the data using Docker and Schedular.

• Automated the creation of Grafana dashboards that utilized the logged data on elastic search cluster for real-time analysis of selenium grid browsers, lab machines, email services and lab problems thus increasing the efficiency by 13%.

• Web scraping using regex and extracted data using API calls within the docker container using schedular. Data Analyst- Accenture Solutions Pvt Ltd Pune, India Aug 2016 - Jan 2019

• Collected, cleansed, and provided modeling and analysis of structured and unstructured insurance data using Python.

• Developed ETL pipelines by extracting consumer data from multiple data sources (CSV, JSON, Excel), manipulated using MS SQL server and generated actionable insights by building Tableau dashboards.

• Developed automated system health checks and presented data and results in Tableau to improve strategies and operations.

• Managed the development and enhancement of reporting solutions using SDLC and Agile development methodologies.

• Led daily scrum meetings, planned, and tracked team progress using JIRA. Created and updated dynamic pages using Confluence. Used bitbucket to clone and merge source code from repositories. Research Assistant- University of Maryland Baltimore County Baltimore, MD Jun 2019 - Present

• Development of content and enhancement of websites for CSEE and Cybersecurity using WordPress, and Google Site.

• Redesigned and organized web pages to streamline content and enhance pages with original images. Graduate Assistant

• Created exam solutions for Database Management Systems and Advanced Database Projects courses.

• Reviewed code by utilizing SQL developer and queries, procedures, and functions. Academic Projects:

Black Friday Sales and Prediction- Data Analysis (Python)

• Designed and built a statistical model to predict Black Friday Sales based on user data by identifying key metrics and transforming raw data into meaningful, and actionable information using ML algorithms (Linear Regression, Random Forest Regressor and Decision tree).

Event Management System -Database Management System

• Created an Oracle-based relational database architecture using SQL and PL/SQL procedures, functions, and triggers for an event management system to enter, manipulate and analyze the data, & generate reports. Data Mining - Medicare Fraud Detection

• Implemented Logistic Regression, Support Vector Machine and Multi-layer Perceptron classifier models to predict the fraudulent providers based on their Medicare by evaluating metrics like Accuracy, R-squared score, ROC score and F-1 score. Big data and Apache Spark - Credit Card fraud prediction

• Predicted credit card fraudulent transactions based on features such as ‘Time’ and ‘Amount’ utilizing big data, PySpark, its sql functions and Machine Learning features, and databricks to structure the information and improve the precision.

Contact this candidate