| 20,000+ Fresh Resumes Monthly | |
|
|
| | Click here or scroll down to respond to this candidateEDUCATIONMASTER OF INFORMATION TECHNOLOGY & MANAGEMENT University of Texas at Dallas May Street Address
Relevant Courses: Data Management, Advanced Stats for Data Science, Project Management, OOP Python BACHELOR OF SCIENCE IN MECHANICAL ENGINEERING University of Texas at Dallas May Street Address GPA: 3.06SKILLS SQL (SQL Server, PostgreSQL, BigQuery) Python (Pandas, JSON) R/R Studio (ggplot2, maps, ggthemes, TinyTex) Excel (VLookup, Conditional Formatting, PivotTables) Tableau, PowerBI PySpark Databricks (Jobs, Workflows) VsCode GCP, DBT CloudCERTIFICATIONSGoogle Data Analytics Certification November 2022PROJECTSOLYMPICS EXPLORATORY DATA ANALYSIS Academic Project April 2023 Utilized RStudio to analyze Olympic and GDP datasets with more than 200,000 records to gain insights on the trends and relations in the Olympics. Implemented various techniques to create clean subsets for further data analysis operations. Aggregated and visualized the data by using ggplot2, maps and ggthemes packages in RStudio. FORMULA ONE POWER BI DASHBOARD Personal Project July 2023 Used MySQL Server to use JOINS, Nested JOINS,UPDATE, SET, and ALTER to make changes to TABLES, CTEs, and VIEWS. Cleaned and processed the data by using Transform Data function in POWER BI to ensure data completeness and validity. Created Relationships between tables for proper use of filters and slicers. Used Buttons and Bookmarks to create a dynamic dashboard. Used Performance Analyzer to find areas of improvement and implement them which improved the dashboards efficiency by 10%.FILE FORMAT CONVERTER Personal Project February 2023 Made use of Python on VsCode to create an application that converts .csv files into .json format for downstream applications. Used libraries such as Pandas, JSON, glob, sys, and re to create functions and lambda functions to convert the files. Stored the newly created files in PostgreSQL by using a file to db loader application which is written in Python. Utilized multiprocessing library to increase the efficiency of code by 50%. ELIGIBILITYUS Citizen, Eligible to work in the US for internships and full time with no restrictions. (Born in New Jersey) Data Analyst/ Business AnalysisVINAY POLISETTYPHONE NUMBER AVAILABLE EMAIL AVAILABLEhttps://LINKEDIN LINK AVAILABLE McKinney, TX 75070 |