YASH BIPIN SHAH
*************@*****.*** 201-***-**** Hoboken, NJ
EDUCATION
Pace University, Seidenberg School of Computer Science and Information System New York, NY Master of Science (MS) in Information Systems G.P.A: 3.80 December 2019 University of Mumbai Mumbai, India
Bachelor of Engineering (BE) in Computer Engineering May 2017 RELATED COURSEWORK
Big Data & Information System, Data Warehouse, Mining & Visualization, Information Security & Controls Database Design & Development of Web, Information System & Planning, Business Analytics for Decision Making TECHNICAL SKILLS
Software: MS Visio/Excel/PowerPoint/Word, Project Libre, Rapid Miner, Tableau Programming Languages: Python, HTML, R Programming, PHP, SQL, Hadoop, Mongo DB, SQL Server Certifications: Ethical Hacking Course, Cloud Computing, Big Data technology WORK EXPERIENCE
IT Analyst, New Jersey March 2019- Present
CORE PHARMA
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Maintaining proper use of data including testing data for integrity and quality assurance
• Optimized and reduced runtime of SQL queries by 20% on workbench using execution plan, simplifying queries and indexing
• Provide input to develop framework for serialisation process.
• Responsibility for managing the implementation of new program. Hashtag Technology, Mumbai, India June 2017 – Dec 2017 SQL Developer
• Liaised with project management and development teams to identify and implement reporting, and control and automation opportunities to improve overall access to information.
• Gathered all the data of customers and created database
• Assisted new and existing clients with integration and data conversion activities. Panna Enterprises, Mumbai, India May 2016 – Aug 2016 Data Analyst Intern
• Utilized Rapid Miner and Tableau Statistical software to track and analyse data.
• Optimized data collection table to create reports on weekly basis.
• Gathered data on sales and customer information to create reports on implementation of marketing strategies. ACADEMIC PROJECTS
Library Management System April 2018
• Created a library management systems database using MySQL Workbench and PHPStorm to design a website.
• Developed functionalities to enable users to search, checking in, and check out books.
• Designed customer login page and used MD5 encryption method to secure personal record of the customer. Web-Based Online Shopping March 2018
• Created a website name Just Click using Bootstrap, PHP, CSS, and HTML to create different types of categories for shopping, such as sports, movies, and/or electronics.
• Designed a login page and included feedback form to record the user experience. Data Analytics on Public Opinion May 2017
• Lead a team of four to construct a web-base application used to study people’s response to social phenomena.
• Researched necessary material and gathered information to analyze and interfere public opinion.
• Utilized Hadoop framework, Python library, and FP-Tree algorithm to store and process huge data collected from Twitter to represent data as graphs, pie-chart, and maps. ACTIVITES
Volunteer math teacher for underprivileged children, Make a Difference Represented college in national level soccer competition, University of Mumbai Participated in Techno Fest competition organized by Thakur Polytechnic