Data Analyst

Khwaja Jalal Sediqi

Phone: 646-***-**** LinkedIn: https://www.linkedin.com/in/khwajajalal/

Email: ***********@*****.*** GitHub: https://github.com/khwajajalal Queens, NY 11356 Fully work Authorized, No Visa Sponsorship required Technical Skills

● Python, Tableau, SQL, R, Statistics, Git, SPSS, Excel Professional Experience:

Pacific Architectures and Engineers (PAE) Data Analyst Excel, SQL, SPSS: 2013-2017

● Led a team of five people in developing and implementing a data analysis plan for an 8 million dollar project.

● Identified KPIs, developed questionnaires, and conducted surveys (pre & post intervention) to assess progress on KPIs.

● Conducted statistical analysis to measure the progress and outcome of the project.

● Presented findings and insights in simple and approachable manner for non-technical stakeholders. United Nations-WFP Data Analyst Excel, SQL, SPSS: 2011-2013

● Designed survey questionnaires and collected required data periodically to evaluate multiple projects performance and on deliverables achievements.

● Conducted final project qualitative and quantitative evaluation/analysis on sustainability, impacts, effectiveness, and efficiency.

Recent Projects

1C Company Sales Prediction Data Analyst Tableau, SQL, Python, Excel October 2020 Predicting 1C company’s next three months sales amount (https://bit.ly/3pDVXdK)

● Cleaned 3,000,000 sales records and discovered the sales patterns professionally using Python and Tableau.

● Constructed a time series forecasting model to forecast the next three months’ sales based on the observed data. Red Hat Business Value Analysis Data Analyst Tableau, SQL, Python, Excel September 2020 Identifying potential features that lead to Red Hat business values (https://bit.ly/35Fqtfi)

● Extracted and cleaned 2,197,128 Red Hat records professionally using SQL, Excel, and Python.

● Identified the potential features that lead to Red Hat business value using Python and visualized them using both Python and Tableau after running statistical tests. Airbnb Trend Analysis Data Analyst SQL, Tableau, Python, Excel August 2020 Trend Analysis for Airbnb Data for Sydney Australia (https://bit.ly/2ILdfoA)

● Explored and cleaned 37,000 records/listings using Excel and Python and showcased trends using Tableau.

● Identified that most of the listings were entire apt/ private rooms, and 93% of all the prices are lower than $550.

● After running text analysis of the listing reviews, discovered that guests are looking for locations close to transports, beaches, restaurants, cafes, and prefer helpful and convenient hosts. Trending Videos Analysis in India and Russia Data Analyst SQL, Python, Tableau July 2020 Analyzing YouTube trending videos for India and Russia (https://bit.ly/2Ds8cq6)

● Queried 171,149 records from the database using SQL, cleaned the filtered 46,005 records for analysis and visualized the findings professionally using Tableau dashboard.

● Found out the average number of views per video is three times higher in India compared to Russia. However, Russian viewers have a higher level of engagement (i.e. likes and comments) with videos compared to Indian viewers.

Education

Galvanize - New York, NY Data Analyst Training Accelerator 2020 Kabul University B.S. in Electrical Engineering 2010

Contact this candidate