Data Analyst Binghamton

Sagar Sahani

Binghamton, NY ********@**********.*** 607-***-**** https://www.linkedin.com/in/sagar-sahani/ https://www.sagarsahani.tech EDUCATION

Binghamton University, State University of New York, Thomas J. Watson College of Engineering and Applied Science Master of Science in Computer Science Expected May 2021 Relevant Coursework: Data Structures & Algorithms, Cloud Computing, Database Systems University of Mumbai, India

Bachelor of Engineering in Information Technology May 2018 KEY SKILLS AND CERTIFICATIONS

Technical Skills

● Programming Languages: Java, Python, JavaScript, C++, HTML, CSS

● Database & Software: MySQL, PostgreSQL, MongoDB, Git, VS Code, Linux, Microsoft Office

● Additional: Node.JS, Express.js, RESTful API, MVC, Docker, AWS Lambda & S3, EC2, JSON PROFESSIONAL EXPERIENCE

JerseySTEM Data Analyst Intern Summit, New Jersey July 2020 – Nov 2020

● Guided team of 3 in an organized and efficient manner to reconstruct the company’s signature analytics tool through effective analysis of requirements

● Programmed additional class functions for the tool using various OOP concepts with Python, also imparted pandas and NumPy for data manipulation needed to compute further insights

● Modified data visualization app for visualizing processed data, with an interactive dashboard using Streamlit framework for Python, featuring dynamic updates from stream

● Designed an automated script with python to eliminate manual ETL work done for semi-yearly data collection. Script makes HTTP requests to check and extract the latest available data from source, cleans and aligns the columns that are then uploaded to MySQL database

● Presented automated script work to the Analytics team of 4 along with suggestions for future and documentation of the scripts ACADEMIC PROJECT EXPERIENCE

Email prompt service Watson College of Engineering May 2021

● Implemented a Web App with Node.js for the backend and HTML, CSS for frontend, that sends email prompts to users for keeping them on track of their work

● Created the backend with Express.js framework and MVC design pattern for rapid development

● Utilized MongoDB Atlas (Cloud Database) to maintain all the registered user credentials

● Incorporated Mailgun API, a mail delivery service, and Quote API to fetch quote of the day, which are both triggered by a node-cron scheduler built with thorough programming fundamentals

● Demonstrated containerization with Docker for development work

● Deployed on Heroku used with yarn manager to run the app, all sensitive credentials were implemented securely with Heroku’s config vars Cloud Storage System on AWS Watson College of Engineering December 2020

● Built and deployed a serverless SaaS application for a personal storage drive limited to an organization

● Developed GET, POST, and DELETE functions on AWS lambda using Node.JS and created REST API endpoints

● Executed specific roles and policies to provide lambda functions access to the S3 bucket for retrieving and uploading files

● Utilized MongoDB on AWS to maintain user credentials and user access related information

● Deployed with EC2 instance to make application scalable NoSQL Application Watson College of Engineering November 2020

● Worked with Python and MongoDB, a NoSQL database, to devise an application that fetches specific data when user chooses to filter preferences

● Leveraged existing YouTube datasets, consisting of data of countries where YouTube is most-watched. Each country’s data was stored in separate collections in database

● Pre-optimized 10 complex queries to get rapid results, including aggregation with pipeline stages across 13 collections for videos and its categories

● Remodeled with Elasticsearch to explore optimizations for future improvements and evaluate compatibility, carried out on 3 complex queries

Contact this candidate