Jyoti Goyal

*** ****** ******, ******, **, ***** 857-***-**** adb3o6@r.postjobfree.com https://www.linkedin.com/in/jyo-goyal/ https://www.kaggle.com/goyalj

EDUCATION

Northeastern University, Boston, MA

Master of Science, Information Systems Anticipated May 2020

Relevant Courses: Advanced Database Management System, Advance Data Science & Architecture, Business Analysis

JECRC University, Jaipur, India

Bachelor of Technology, Computer Science & Engineering Jul 2016

Graded ‘A’ in Green Revolution Examination by International Centre for Culture and Education (ICCE) in association with United Nation’s Convention on Climate Change (UNFCC). Examination conducted by United Nations and World Bank.

TECHNICAL SKILLS

Database: MySQL, PL/SQL, Oracle10g/11g

Visualization & Analysis: Tableau, MS Excel, Power BI, Alteryx

Programming Languages: Python, C++, Java, R, PL/SQL, SQL, SAP ABAP, C

Machine Learning Framework: NumPy, Pandas, Seaborn, Matplotlib, Scikit-learn

Web Designing Language: HTML,PHP, AJAX, JQUERY, JavaScript

Worked on Talend, Amazon Redshift and ER Studio

WORK EXPERIENCE

Data Analyst (Managed Markets & Specialty Analytics), EMD Serono, Rockland, USA Jul 2019 – Dec 2019

Integrated 13 years of data (Veeva HCP/HCO affiliation and IQVIA Sub-National claims) to form the Integrated delivery network (IDN)

Performed statistical analysis and data extraction to Analyze the control of HCP and payer over each IDN

Designed a Tableau report for a project which gave an insight into the company’s newly launched product and its performance across the country

Fetched Medicaid data for Texas and Colorado to visualize the performance of different MS drug in the influence of different plans and payers

Strategized a plan to get hold of patients which helped in recognizing the plans which are downstream and not controlled by that PBM

Designed a performance tracker in tableau with different flags indicating the lift of NDC block on different drugs thus indicating the gap analysis with the involved insurance provider

Performed quality check on incoming pharmacy data into the database

Associate Software Engineer, Accenture Services Private Limited, Mumbai, India Nov 2016 - May 2018

Handled, analyzed, designed, tested reports, interfaces, conversions, enhancements and workflow in SAP-ABAP

Maintained Excel Modelling for client’s development model

Analyzed and developed a dashboard for BoM which provides information about the materials used by clients

Suggested idea for automating the process of manually updating an excel sheet by running an abap program

Generated tables using pivot tables and visualized data using tableau

Front End Designing Intern, Dogma Soft Pvt. Ltd., Jaipur, India Jan 2016 – Jun 2016

Designed websites for multiple clients in the company’s portfolio in Dreamviewer using HTML, CSS, PHP.

ACADEMIC PROJECTS

Airplane Booking & Blood Donation Database System (Oracle 11, PL/SQL in SQL Developer) Apr 2019

Modeled entity-relationship diagram, developed a potential database for blood donation system

Normalized tables and implemented triggers, views, sub-routines, stored procedures, cursors increasing its efficiency

TMDB Box Office Prediction (Automl, Word Embedding/Word to vec, Random Forest using Python) Mar 2018

Participated in Kaggle Competition to predict the overall worldwide box office revenue

Performed feature engineering in JSON like data to transform features and handle missing values

Applied feature selection and feature extraction to project data into a smaller number of dimensions

Executed H2o automl and later tuned hyperparameter beating the H2o automl score, securing top 20% in competition with 2.4 rmse in the training data

Boston House Pricing Prediction (Regression & Classification Using Python) Jan 2018

Visualized and cleaned dataset using multiple Python packages like numpy, Matplotlib

Checked multicollinearity and used Interaction effect in the model which improved accuracy from 74% to 98%

Implemented regularization to avoid overfitting dataset which improved its accuracy by 14%

Contact this candidate