Data Analyst Engineer

AMIT PHADKE

Data Analyst Data Engineer

Ph: +1-862-***-**** Email: ******.******@*****.*** Greater New York City LinkedIn: www.linkedin.com/in/amit-phadke12/ GitHub: www.github.com/amitp13 Portfolio: www.amitphadke.com Tableau Public: https://public.tableau.com/profile/amit7050 EDUCATION

Rutgers University Newark, USA (2019 – 2020)

MS in Information Technology and Analytics (GPA: 3.7/4) Relevant Coursework: Data Mining, Data Management with SQL, Data Science, Project Management, Data Analysis & Decision Making, Google analytics, Marketing Management, Multivariate Analysis. University of Pune Pune, India (2014 – 2017)

MS in Computer Applications (GPA: 4.5/6)

Relevant Coursework: Relational Databases, Data Warehousing, Data Structures, Object Oriented Programming, Database Management Systems, Software Engineering

SKILLS

Programming Languages: SQL, Python, Java, R, JavaScript, PHP, HTML5, CSS3. Database Systems: MS Access, Oracle, PostgreSQL, SQLite, MySQL. Libraries: selenium, pandas, matplotlib, scikit, flask, json. Analytics/Development Tools: MS Excel, Tableau, PowerBI, Google Analytics, GitHub, JIRA, Flask, Jupyter Notebooks, RESTful APIs. EXPERIENCE

Katch Media

Data Analyst Intern Los Angeles, USA (July 2020 – December 2020)

• Gained key insights on movie revenues, by building interactive dashboards in Tableau and scalable databases in SQL and presented findings to the Executive team.

• Led a team of Interns to identify key metrics for a film’s box-office performance in global markets, by building fixed effects regression models with an accuracy of 65% using R programming.

• Identified sentiments and moods in a movie, by analyzing movie scripts using NLP techniques and classification algorithms in Python.

• Automated 50% of the data collection processes, by implementing a data pipeline from web sources to databases by using Python, Selenium and Excel.

Rutgers University

Teaching Assistant Newark, USA (January 2020 – May 2020)

• Analyzed, graded, and maintained reports for students, assisted professors with assessments and exams using MS excel macros and functions.

• Improved time efficiency, by automating tedious clerical tasks like creation of question sets using Python and the py-docx library. Accenture

Software Engineer Pune, India (December 2017 – February 2019)

• Collaborated with Developers and Data Analysts to maintain databases for the client, by analyzing, coding, and testing queries using SQL and DB2 in an Agile software life cycle.

• Consolidated server and storage software by analyzing and upgrading core functionalities of the system, using Eclipse, Excel, and COBOL.

• Improved the quality of the products, by analyzing, executing, and maintaining test cases, using COBOL and Excel. Techspawn Solutions

Web Development Intern Pune, India (December 2016 - June 2017)

• Teamed with 3 web developers to automate data migration processes by 80% for an E-commerce website, by building a tool to transfer data from one framework to another, for using SQL, REST API’s, PHP, and Python.

• Managed the business portfolio of a real-estate developer, by implementing the design and functionalities of their website, using CSS and JavaScript and PHP.

PROJECTS

Recommendation System for Spotify Python, R, GGPlot, NBClust, SQL

• Designed a content-based filtering model to find similar songs on Spotify, by categorizing songs in 4 meaningful clusters based on their audio properties, using unsupervised clustering algorithms in R.

• Collected data from Spotify’s REST API, by building a Python module, using object-oriented programming and Oauth2 concepts. Regression analysis of sports metrics in the IPL R, GGplot, SQL

• Built a regression model to predict number of wins and runs in cricket, with an adjusted R-squared of 8.22 using multiple linear regression algorithm.

• Provided key metrics to building team rosters by identifying the crucial metrics that maximize wins and runs at an efficient cost.

Contact this candidate