JAHNAVI ALLAM

346-***-****, admy03@r.postjobfree.com, LinkedIn

San Jose, California 95117

OBJECTIVE

Graduate student looking for opportunities in data analytics with strong background in python, R,Tableau,SAS, and advanced data analytics skill.

EDUCATION

University of North Texas, Denton, Texas. April ‘21 Master’s in Data Science GPA - 3.9/4.0

TECHNICAL SKILLS

Hands-on experience with Data analytic algorithms includes Linear regression, logistic regression, KNN, K-Mean, Decision trees, Cluster analysis, Neural Networks. A. Packages and Modules : NumPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, Regex, MySQL, SQL Server 2000, ggplot2,qplot, Dplyr

B. Operating systems: Windows, Linux, macOS.

C. Interest: Data Management and Reporting, Tableau, Data Analytics D. Programming Skills: C, Python, and R

E. DS Tools: SPSS, SAS/Base, SAS/SQL, PowerBI, Jupyter Notebook, RapidMiner, Advance Excel. F. Certification: SAS Certified Base Programmer for SAS 9 (CBP) - N8QPGHCKCEQE1GGP EXPERIENCE

Graduate Assistant, UNT Oct ’19-Nov ‘20

• Designed database tables and structures, created views, functions, and wrote optimized SQL queries for integration.

• Created visualizations for the data by using Tableau, Designed Dashboards, Twisting SQL queries for improving performances.

• Performed Data Visualization using packages like Seaborn, NumPy, matplotlib, ggplot in Python and SAS, (dplyr, ggplot2,qplot) in R to generate Scatter Plot, Box Plot, Histogram etc., also created predictive and descriptive models based on the analytics of data generated using twitter data.

• Produced ad-hoc reports with V-lookups, Pivot tables, and Macros in Excel and recommended solutions to drive decision making, for business problems and provided business modeling solutions. SAS Programmer, Signet soft Private Limited, Bangalore, India. Jan ‘18 - Jul ‘19

• Developed code using various procedures like PROC SQL, PROC SORT, PROC PRINT, PROC MEANS, PROC CONTENTS, PROC FREQ, PROC FORMAT, PROC TRANSPOSE, PROC REPORT.

• Provided statistical support to principal investigators and research staff in the design of research studies, developing statistical analysis plan, methodology, and procedures, IRB protocol.

• Prepared new datasets from raw data files using Import Techniques and modified existing datasets using Data steps, Set, Merge, Sort and Update, Formats, Functions, and conditional statements.

• Developed, maintained, and performed SAS program with the use of SAS/BASE, SAS/MACRO, SAS/SQL for data transfers, manipulation, cleaning, analysis, and reporting.

COURSE PROJECTS

Netflix Video Recommender – [Python, ML-SVD, Tableau, EDA] Spring ‘21

• Preprocessed the Netflix movie data using EDA, done data analysis, data visualization

• Used pandas, pyplot, and seaborn in SVD Algorithm to recommend videos for the users based on gender, age, and genre. Hospital Management system – [Data Modelling-ERD, My SQL Workbench, Draw.io] Fall ‘20

• To computerize all the details about the Physician, patient, and hospital.

• Used Database is the SQL server for writing the Queries of each table like insert statement, create a statement, update, insertion of a new record, alter and delete statements.

• Created the ERD diagram in the draw.co.in and a data dictionary was created based on the ERD and business rules. Impact Of G.D.P_per_capita, HDI On Suicide Rate –[Advanced-Data Analytics, MS Excel] Summer ‘20

• The main aim of the project is to analyze the suicide rates dataset and compare whether the suicide rate is dependent on the GDP per capita and Human Development Index or not.

• The analysis is done by doing the correlation between the G.D.P_per_capita and HDI with the suicidal rates and tested the hypothesis by plotting the scatterplot and Normal probability and compared with the final regression output. FIFA Data Analysis – [Data Visualization, Tableau] Spring ‘20

• Preprocessed the data using different techniques. By using Tableau and Microsoft Excel the processed data is analyzed.

• Performed different visualizations on the data by different visualizing maps or graphs and some of the assumed hypothesis statements are explained in this project.

Data Analysis of the Foodservice Zomato – [Data Mining, SAS enterprise miner] Fall ‘19

• Preprocessed the data using preprocessing techniques (Data Selection, Data Cleaning, transformation, and integration).

• Determined the best classification model (Decision Tree) by comparing the accuracy and other outcome indicators.

• Worked on SAS Enterprise Miner to perform Logistic Regression, Cluster analysis, Decision trees.