Data Analyst Python

ISHA SATSHIL HAVALDAR

315-***-**** adb7cn@r.postjobfree.com NY 13210 https://www.linkedin.com/in/isha-havaldar/ EDUCATION

Master of Science in Information Management, Syracuse University, GPA: 3.7/4 May 2020 Certificate of Advance Study in Data Science, Syracuse University May 2020 Bachelor of Engineering, Computer Science, University of Mumbai, GPA: 3.9/4 May 2018 Coursework: Big Data Analytics, Data Analysis and Decision Making, Data Science, Business Analytics, Database Management, Data Warehouse, Risk Management, Management Information Systems Projects, Scripting for Data Analysis TECHNICAL SKILLS

• Machine learning: Linear Regression, Logistic Regression, Random forest, Association Rules, Support Vector Machine, K-means clustering

• Programming Languages: R, Python, C, Java, HTML

• Analytics: Tableau, Advance Excel (PowerPivot, Solver, Pivot tables, VLookup), Google Analytics, Power BI, SSIS, SSRS, SSAS

• Database Management: SQL, MySQL, MS Access, MS SQL Server

• Applications: MS Visio, MS Excel, MS PowerPoint, MS Projects, MS SQL, MS Access, Trello, Microsoft Outlook and Google Suite

• Certifications: Google Analytics for beginners, NPTEL (IMAD, Python), Tableau (Imarticus Learning) WORK EXPERIENCE

Data Analyst Intern, iConsult Collaborative, Syracuse June 2019 – December 2019

• Performed data cleansing, outlier detection & categorical conversion to procure 60% of useful data from unstructured data

• Performed statistical analysis on 10 million records to measure impact of various factors on poverty & identified root cause

• Monitored & managed risks, built KPI’s & kept the client updated with the progress of project to deliver a high-quality analysis

• Illustrated data points by building dashboards in Tableau to gain patterns & actionable insights on population poverty ratio Data Analyst Intern, Easyst Sourcing, Mumbai August 2017 – December 2017

• Developed ad hoc requests by maintenance of SQL queries & stored procedures to procure data and format requested data

• Performed exploratory data analysis in R to identify patterns, trends and quantify business metrics for order processing

• Designed analytical models and metric reports for order processing, backlog management for customers using Advanced Excel

• Developed algorithms for performance measurement and communicated the analytical results to stakeholders PROJECTS

Big Data Analytics, Berlin Airbnb Data Analysis, Syracuse University

• Conducted predictive analytics to determine ratings of customer using logistic regression model in Python for the test dataset

• Leveraged NLP method of text mining to analyze trends & patterns of text reviews to address business problems of Airbnb

• Classified geographic region in python to analyze neighborhoods effecting cost of listing using visualization library matplotlib Data Analysis, Customer Analytics for Airlines, Syracuse University

• Carried out descriptive statistics, cleaning, validation of 2,00,000 customer records using R to improve customer satisfaction

• Conducted predictive analysis using SVM, regression analysis, association rules of 83% accuracy to predict customer behavior

• Automated data visualization by creating dashboards using Tableau to gain business insight & performed A/B testing Database Management, Opportune – The Internship Portal, Syracuse University

• Proposed a database solution by categorizing jobs to improve online job search system efficiency by 50% for students

• Built ERD of process workflow to identify attribute relationship & created forms, reports to validate requirements (MS Visio, Access)

• Developed relational database using SQL queries as per goals, triggers, stored procedures, function to store student & company data Business Analytics, Industry Analysis, Syracuse University

• Optimized business process by analyzing market trends and statistical modeling to enhance performance of an organization

• Used advance excel to optimize book profit, performed loan analysis (logit, probit) to predict customer behavior & gain insights

• Implemented descriptive statistics on Whitman Grad Program campaign to gain statistical insights using Google Analytics RESEARCH PUBLICATION

Co-authored journal ISSN 0973-6107 Vol.11 No.1 2018, “VSMS – A Survey on Voice Based SMS System” and published it in International Journal ACST at the International Conference on ‘Advances in Science and Technology’. LEADERSHIP & CAMPUS INVOLVMENT

• Graduate Student Assistant, Syracuse University

Carried out data extraction, data entry and data cleaning in Excel and assisting professor in day to day administrative tasks

• Student Supervisor, Syracuse University

Managed group of 25 employees at Sadler Dining Center to monitor student productivity and regulating daily workflow

• Graduate Mentor, Syracuse University

Assisting iSchool Career Services in advising 1st year graduate student in Resume building, job applications, career advising

• Worked as volunteer with NGO MAD for ‘Humara Station Humari Shaan’ having initiative of beautifying railway stations

Contact this candidate