Abhishek S Hiremath

*** **** ****** *** *, Brooklyn, NY-11209

929-***-**** adcd7i@r.postjobfree.com https://www.linkedin.com/in/abhishek-hiremath/

EDUCATION

New York University, Tandon School of Engineering, Brooklyn, NY Expected May 2020

Master of Science in Management of Technology GPA 3.7/4

B.V. Bhoomaraddi college Of Engineering and Technology, Hubli, India May 2018

Bachelor of Engineering Computer Science GPA 3.6/4

SKILLS

Programming Language: C, Python, R studio, Tableau, SQL, Machine Learning, PostGre, Power BI, SAS, SPSS and Excel.

Technical: Data Mining, Data Analysis, creating models, writing SQL queries and related database management systems: Project Management; SWOT, quick draw.

Documentation and Presentation: Proficient in MS Word; MS PowerPoint; Adobe Photoshop; Pivot tables; Statistics.

Soft Skill: Organizing; Leadership; Communication; Decision Making; Marketing; Promoting; Interaction, Requirements Gathering & Analysis, Enterprise Implementations.

WORK EXPERIENCE

METROPOLITAN TRANSPORTATION AUTHORITY (MTA) New York, USA

Data Analyst Intern May 2019- December 2019

Analyzed survey data of (5 Boroughs of NY) on paratransit, UI dashboard, to ensure the AAR programs were correctly implemented and anomalies within the data were investigated and resolved in a timely manner.

Wrote queries using SQL in PostGre SQL to import data from online servers and performed regression and Random forest models on data.

Prepared reports for the Key Performance metrics on daily basis and monthly reports.

Used text mining to understand more than 100K reviews and study the pattern and improve performance.

Performed Exploratory Data Analysis on the data for the whole month and prepared a report for any anomalies or low performance using Pandas (Python).

NEW YORK UNIVERSITY New York, USA

Data Analyst Intern Sept 2018-April 2019

Collected, cleansed and provided modeling and analyses of structured and unstructured data used for admissions.

Analyzed the data of Graduate Student information of more than 100GB data and accessing in the admissions office.

Designed and built statistical analysis models on large data sets that helped increase online registration.

Used quantitative data gathered to develop an understanding of student behavior, demographics and lifecycle.

Performing ETL to analyze the variation in the admission registration.

Wrote complex SQL queries for retrieving texts from online servers and storing them into the database

ACCENTURE Bangalore, INDIA Sept 2017-March 2018 Data Analyst Intern

Converted data of more than 220GB into actionable insights by predicting and modeling future outcomes.

Utilized My SQL to write queries for retrieving the data and storing into the database, data warehousing programs and Tableau for data Intelligence and analysis.

Collaborated with the marketing officer and the owners in conceptualizing marketing ideas for traditional collateral and digital content.

Designed and developed business rules for online data collection from system based on the analytics results.

Creating predictive models (Random forest and XGB boost) based on insight and analytics. (using Tableau and R)

Researched, analyzed and processes information from MSRB EMMA filings, Issuer reports to produce data reports for management.

PROJECT

Amazon Fine Foods Review Jan 2019 – May 2019

Performed Text mining on Amazon fine food reviews (Teradata) more than 5 million reviews to understand the pattern and the quality of the reviews (Python).

Used clustering, Kera’s, word embedding, SQL lite to perform sentiment analysis and prepare Models (XGB) for the prediction of the ratings.

Achieved an accuracy of 89% in the predictive model of the rating and also based on the sentiment analysis results could understand the overall review of the food and suggest necessary changes.

Made Presentation to a Panel from Goldman Sachs, MARS and JP Morgan to show the text mining results and predictive models based on how they can be used in the improvement of the service.

Contact this candidate