JAYSHIL JAIN

add3uk@r.postjobfree.com jayshil.jain.netlify.app linkedin.com/in/JayshilJain 857-***-**** github.com/jayshilj EDUCATION

NORTHEASTERN UNIVERSITY Boston, MA GPA: 3.9 Expected May 2021 Master of Science in Information Systems

Related Courses: Data Management and Database Design, Data Science, Designing Advanced Data Architectures for BI Achievements: Winner of Global COVID-19 Hackathon for developing E-Learning mobile application with COVID-19 analysis UNIVERSITY OF MUMBAI Mumbai, India May 2019

Bachelor of Engineering in Information Technology

Related Courses: Data Structures and Algorithms, Big Data Analytics, Cloud Computing, Data Mining and Business Intelligence Achievements: Awarded 1st Position in Effective Public Speaking competition based on Global Climate Change RELEVANT EXPERIENCE

JP MORGAN FINANCIAL SERVICES, US Software Engineer Virtual Project, InsideSherpa Apr 2020 – May 2020

• Built an interface with stock price data feed & set up a system for data analysis using Python, Git & Financial data

• Implemented perspective, a web application framework for data visualization & created dashboards for making an investment strategy NORTHEASTERN UNIVERSITY Boston, MA Jan 2020 – Present Graduate Teaching Assistant Python, AWS, SQL, SSIS, Git, PowerBI, Redshift, Tableau, MongoDB

• Coordinated with Professor and guided 50+ students through coursework by arranging weekly workshops for SQL and Python

• Led tutorials every week, presented latest concepts about AWS and it’s services like S3, EMR, EC2 and Redshift Graduate Research Assistant Python, SQL, Alteryx, Endnotes, HTML, CSS, JavaScript, Excel VBA, Macros, Linux

• Managed all aspects of data quality control and quality assurance which is being collected from across 45 different countries

• Conducted updates, enhancements and maintenance of the website, prepared reports detailing web activity using Google Analytics JAG SOFTWARE SOLUTIONS PRIVATE LIMITED Mumbai, India Data Engineer Intern Python, SQL, Altreyx, Excel VBA, Git, AWS, JIRA, RESTful API, Linux May 2019 – Aug 2019

• Optimized 14 complex SQL procedures and triggers to reduce insertion costs improving overall system efficiency by 40%

• Performed data profiling and data cleaning task for tracking and improving data quality using Alteryx and Python

• Implemented SCD 2 and 7 to handle changing dimensions and maintain referential integrity Business Analyst Intern Microsoft Office (Excel, Access, PowerPoint, Word), Agile, Tableau, PowerBI May 2018 – Aug 2018

• Analyzed business requirements and functional specifications by understanding shipping container management’s workflow

• Collaborated with Stakeholders to design comprehensive A/B tests and developed insights by analyzing testing results

• Automated visualization reports illustrating company’s sales performance using Tableau over MS PowerPoint PROJECTS

Real Time COVID-19 Analysis by Web-Scraping and API Integration AWS, Python, bs4, Tableau Mar 2020 - May 2020

• Scrapped worldometer website using bs4 to collect real-time data; using data pre-processing for accuracy and stored it in Amazon S3

• Performed Advanced Analytics to track growth of regional cases thereby predicting future cases with an accuracy of 84% Data Warehousing and BI for IMDB Dataset Alteryx, ER studio, Tableau, Power BI (DAX), Talend Jan 2020 - Apr 2020

• Orchestrated ETL workflow in Talend to load all tables (60 Billion+ rows) in a scheduled manner within 70 mins (Quickest in class)

• Designed interactive BI dashboards to display specific details from database using MS PowerBI, Tableau and Qlik Sense Lending Club Interest Rate Prediction Linear Regression, RF, Pandas, NumPy, NN Jan 2020 - Apr 2020

• Integrated data cleansing, pre-processing, applied MICE to fill missing values and tuned hyperparameters using 5-fold validation

• Created an interest prediction algorithm with 97% accuracy after evaluating 3 machine learning and 3 Auto-ML models Dental Clinic Management System MS-SQL Server, TOAD, HTML, JavaScript, React, Apache-Tomcat Sept 2019 - Dec 2019

• Increased system efficiency by over 65% by implementing self-generating tables and leveraging ICD, NDC, CPT and, HCPCS

• Streamlined website design by reducing human intervention by almost 40% leading to annual savings of $30K TECHNICAL SKILLS

Programming Languages: Python, Java, C, C++, SQL, R Databases: MS SQL Server, MySQL, PostgreSQL, Oracle 11g, MongoDB, NoSQL, Snowflake, Redshift Database ETL Tools: Alteryx, Talend, SSIS, ER/Studio Architect, Toad Modeler, Hadoop, Hive, SAS, GitHub Data Analytics Tools: Tableau, Power BI, Qlik, Excel VBA, BigQuery, Google Analytics (Certified) Statistics/ML: Regression, Classification, Neural Nets, Bayesian, Clustering, Time Series, Reinforcement Learning Web / Cloud Technology: JavaScript, HTML, CSS3, REST APIs, Agile, SDLC, JIRA, AWS (EMR, Kinesis, S3), OCI, GCP CERTIFICATIONS

- Udacity Nanodegree: Data Engineering Nanodegree Data Analyst Nanodegree (In Progress)

- Tableau Analyst and Data Scientist (Official) Advanced Google Analytics (Official) Product MasterClass (Product School)

Contact this candidate