Queens, New York

LinkedIn GitHub TOPGYAL GURUNG 347-***-****

ad4kfr@r.postjobfree.com

Technologies and Languages

Programming Languages: (Proficient): Python, SQL. (Familiar): Java, C++, JavaScript, HTML/CSS, R Libraries/Platforms: Node.js, Express, React, Redux, Docker, Flask, Git Database: PostgreSQL, SQL Server, MySQL, MariaDB, MongoDB, NoSQL, ORM, Redis Data Science: MS Excel, Power BI, Tableau, Pandas, Sklearn, NumPy, Matplotlib, WEKA Tools: VS Code, Vim, REST API, AWS, Heroku, Scrum, ETL, macOs, WordPress, Google Cloud Big Query, Anaconda Navigator, Jupyter Notebook Software Projects

Personal Portfolio: topgyalgurung.github.io/cv (for additional information and projects) House Sales Prediction Analysis Feb 2023

• Determined the market price of a house given a set of features from King County, Seattle dataset

• Utilized python, pandas and NumPy for initial import and data wrangling

• Exploratory data analysis with matplotlib, used seaborn and sklearn for model development, evaluation & refinement

Travel Diary Jan 2023

• Read input data file, retrieved geocoded response using Google Geodata API and store it in SQLite database

• Cached data in a database to avoid limiting and allow restarting

• Visualize data using HTML, JavaScript and Google Map API Transform Market Cap Currency Dec 2022

• Extracted bank and market data from JSON and transformed the market cap currency using exchange rate data implementing pandas

• Loaded the transformed data into separate csv

ETL Data Pipeline Sep 2021

• Designed a Python app that builds a database of current weather data from the OpenWeather API

• Parsed data using pandas and stored it in SQLite database Work Experience

Data Engineer Intern Real Factors (Astoria, NY) June 2019 – Aug 2019

• Solved triangle appearing problem in deck.gl polygon in Apache Superset by solving SQL code in Big Query to parse Well-Known Text (WKT) into strings right before company’s merge with 7Park Data Inc.

• Utilized joins, partitions, aggregations to create tables and views with the datasets in GCP

• Created dashboards, charts, and reports; implemented transformations, aggregations, and filtered data in Data Catalog

Student Software Engineer TTP Residency at Hunter College x Full Stack Academy May 2019 – June 2019

• Selected for competitive bootcamp that covered full-stack software development methodology in Scrum

• Built Full stack web application with React, Redux, Node, Express, Sequelize ORM for Postgres and Heroku

• Applied advanced JavaScript concepts, DOM manipulation, external REST API request Education and Certifications

Hunter College, City University of New York New York, NY Bachelor’s, Computer Science Graduated Jan 2020

Certifications: Python for Everybody Specialization (UMich), Codepath’s Cybersecurity Pathway, Java (Synopsizor), Data Analysis on Demand (General Assembly), Microsoft Power BI (Maven Analytics), IBM Data Engineering Professional Certificate (in progress)

Contact this candidate