Ipsita Ghatak
Chicago, IL 312-***-**** *******@***.*** linkedin.com/in/ipsitaghatak github.com/ipsitaghatak95
EDUCATION
University of Illinois at Chicago Chicago, IL
Master of Science in Management Information Systems Aug 2019 – May 2021
University of Mumbai Mumbai, India
Bachelor of Engineering in Electronics and Telecommunication Aug 2013 – May 2017
PROFESSIONAL EXPERIENCE
InternetFM Chicago, IL
Project Intern Jan 2021 – Present
•Developed desktop PC version of the mobile Internet radio app available on both Android and IOS
•The application would be downloaded and executed on a user desktop (either Windows or Mac)
•Technologies: Node.js, HTML, JavaScript, MySQL, CSS, Electron
Oracle Financial Services Software LTD. Mumbai, India
Associate Consultant Jul 2017 – Jun 2019
•Analyzed client requirements and built customized features for Flexcube Core Banking Solution
•Linked each account (~ 2.5M) of a Japanese bank with a unique number by modifying front-end modules and linking them to back-end applications
•Identified dormant accounts, handled their deposits of ~ USD 1.5B by developing banking screens
•Implemented term deposit products on collaboration with client, functional and testing teams
•Performed database manipulation on the client’s customer database using advanced querying
•Prepared and executed test plans for unit testing, integration testing and UAT testing
•Technologies: SQL, Unix/Linux, Shell Scripting, Java, JavaScript, VB, SOAP API, REST API, Oracle BI
SKILLS
Programming Python, Shell scripting, Batch Scripting, R, Java, C++, C, C#
Web Technologies XML, HTML, CSS, JavaScript, React, Node.js, Spring Boot, JSP, Servlets
Statistics & Visualization Tableau, Power BI, IBM SPSS
Machine Learning Scikit-learn, NumPy, pandas, matplotlib, SciPy, Tensorflow
Database Oracle, MS SQL Server, MySQL, MS Azure Cloud Database
Tools Jupyter Notebook, Oracle PL/SQL Developer, AWS, Docker, GIT, JIRA, MS Excel
PROJECTS
Illinois Hospitals Covid-19 Twitter Analysis, Technologies: Python, Tableau Oct 2020 – Nov 2020
•Analyzed 11000 tweets from 46 hospitals to find the topics they tweeted on during the pandemic
•Extracted, cleaned data and built regression model to find features impacting traction of tweets
Amazon Review Helpfulness Prediction, Technologies: Python, Spark Aug 2020 – Sept 2020
•Predicted helpfulness of customer reviews on Amazon’s Video Games product dataset
•Built Random forest model that predicted each review as helpful or not with 77% accuracy
Inventory Control Tracking Application, Technologies: MySQL, Java, HTML, CSS Jun 2020 – Jul 2020
•Designed a Web-based application that helps athletic teams keep a record of their inventory
•Created a database and developed features to add, extract and edit the inventory
Loan Approval Prediction, Technologies: Python Feb 2020 – Mar 2020
•Predicted the eligibility of applicants for loan using machine learning algorithms
•Performed exploratory data analysis and compared the performance of the models
On-Time Performance Analysis of Envoy Air, Technologies: Tableau Aug 2019 – Oct 2019
•Prepared visualizations from the BTS Dataset to evaluate the on-time performance of Envoy Air
•Compared the airline with its closest competitor based on key performance features