Data Analyst

Amit Israni

Jersey City, NJ 201-***-**** ************@*****.*** linkedin.com/in/amit-israni

EDUCATION

Pace University, New York, NY May 2020

Master of Science in Information Systems

Related Coursework: Database Management System, Database Programming, Database Mining, Data Warehousing, Data Visualization, Database Design and Development of Web Applications, IS Design and Development, IS Project and Change Management.

University of Mumbai, Mumbai, India May 2017

Bachelor of Engineering in Electronics and Telecommunication Related Coursework: Structured Programming Approach, Object-Oriented Programming and Operating Systems. TECHNICAL SKILLS

Database: MySQL, MS SQL Server, PostgreSQL and Oracle Data Analytics and Visualization: Tableau, Power BI, Advanced Excel, Matplotlib, Seaborn and Scikit-learn Programming: R, Python, PHP and HTML

PROJECTS

Exploratory Data Analysis of Airbnb in Seattle (NumPy, Pandas, Matplotlib, Seaborn) Jan 2020 – May 2020

• Analyzed the Airbnb data of roughly 8000 listings to describe the activity of homestays in Seattle and to understand real- estate and short-term rental market by using data science libraries in python (pandas, SciPy, NumPy, Scikit, matplotlib, pyplot)

• Executed algorithms such as Regression, Decision trees, Random Forest on dataset to find out what type of Airbnb is preferred by people based on dependent variables and in what part of Seattle the revenue is raising NYC Crime Data Analysis using MSSQL and Power BI (MS SQL, Talend, Power BI) Sep 2019 – Dec 2019

• Performed EDA on the NYC Crime dataset

• Designed and developed a data warehouse, pipelining NYC Crime data from diverse sources using Talend

• Generated the database in MS SQL and it to PowerBI

• Analyzed data by building dashboards, to visualize how has crime changed over the years, which part of NYC has the highest crime rate and what kind of crimes that have been occurring frequently False alarm detection (R, RapidMiner) Sep 2019 – Dec 2019

• Created a prediction model of false alarms in real-time transactions generated by security devices and applications.

• Performed training, testing, and validating a data mining model using RapidMiner

• Analyzed the best accuracy of 99.59%, obtained by the Decision tree algorithm Data Capturing and Segregation in SQL workbench (SQL) Jun 2019 – Aug 2019

• Designed an end to end company database including data modeling, table relationships, normalization, and triggers.

• Established Data integrity and accuracy rules using triggers to provide employees with role-based access to the database.

• Created Complex stored procedures to communicate with the database Walmart – Supply Chain Project Management (SWOT, DGGP, ROI) Jan 2019 – May 2019

• Identified Big Data issues faced by Walmart in the field of Supply Chain Management after detailed analysis

• Designed a Vision Diagram for current and future state of the project to analyse the tools used in project development

• Performed Project Business Analysis, SWOT Analysis, Cost Management and Return on Investment to understand the current situation and process

• Crafted Data Governance Guiding Principle for the company to understand various data goals Online Automotive Business (HTML, PHP, MySQL) Sep 2018 – Dec 2018

• Designed a website for buying and selling cars which includes performing the affinity analysis by maintaining data of visitors

• Optimized the query processing in MySQL database by normalizing tables and implementing indexes followed by testing to ensure no inconsistencies exist

Intelligent Helmet for Blind (Python) May 2016 – May 2017

• Certified Patent by Electronic Vision Assistance system (EVA)

• Designed a lightweight helmet to avoid obstacles for ensuring the safety of the blind. Developed using Raspberry Pi integrated with ultrasonic sensors, USB camera, solar portable power bank, and resistors

• Coded the program in Python to infuse the detection of objects which stimulates the hardware components to enable the conversion of structured code to audio output

PATENT PUBLICATION

• Published Design (308566), Idea (308565) & Product (201*********) patents of EVA System with Indian patent office.

• Link: http://ipindiaservices.gov.in/designapplicationStatus/

Contact this candidate