Samyak Jain

+1-267-***-**** adq2dl@r.postjobfree.com **** Powelton Ave, 19104, Philadelphia, Pennsylvania Professional Experience

WebCraft IT Indore, India

Data Analyst 06/2019 - 08/2021

Conducted Ad-hoc analysis on Q1 and Q2 data of more than 15000 customers of client's website utilizing dplyr and other packages of R

Curated executive dashboards in Tableau tracking 10+ KPIs that interpreted consumer behavior, trends and market opportunities, which in turn helped the Client in improving customer retention rate by approximately 17% Extracted and cleaned a large volume of data from lakes using Alteryx and SQL to load data Optimized the accuracy of data analytics and reporting by creating multiple Tableau dashboards from multiple sources, which in turn saved 15 man-hours per week

Define problems, draw conclusions, and work with stakeholders to provide clear communication and to identify and improve reporting, analytics and visualization needs Pahal Technovision (Internship) Indore, India

Business Intelligence Intern 06/2016 - 09/2016

Analyzed data of more than 2500 patients with SQL, and Excel to produce insights on saving time at the stages of patients' stay; increasing monthly available ED hours by 160. Implemented advanced web analytics tracking, monitor KPIs using Google analytics and subsequently created google analytics reports and dashboard.

Skills

Programming: SQL(MySQL, Postgres, NoSQL), R(dplyr, ggplot2), Python(Pandas, Numpy), SAS, HTML5, CSS, RDBMS, APIs

Software: Tableau, Alteryx, Oracle database, Power BI, Microsoft Office (Excel, Powerpoint, Visio), Google analytics Tools: AWS Athena,, MySQL workbench, Google tag manager, VS code, Wireshark, Pycharm, Git hub, Google workspace

Soft: Critical thinking, Problem-solving, Communication, Teamwork, Analytical and Interpersonal skills Education

Drexel University Philadelphia, PA

Master of Science in Information Systems 06/2023 GPA: 3.9/4.0

Coursework: Database management systems, Data mining, Information Visualization, Applied database technologies, Introduction to Data Analytics

University Projects

E-commerce database

Created an ER model in accordance with the requirements developed, then translated this ER model into a normalized

(3NF) relational schema. Implemented the relational schema using SQL Populated and manipulated the data using complex SQL queries in this schema to meet the everyday needs of the website.

Online Pizza ordering website

Built a website for ordering pizza online using HTML and CSS to create and design front end. Used Javascript and PHP to make webpage more dynamic and interactive. Developed database for the website using SQL queries and MySQL workbench.

Certificates

Google Data Analytics Professional Certificate