Yash Mathur Email & Phone Number

Noida, Uttar Pradesh, India

• Developing, managing and maintaining Data Operations for an internal business tool 'Jarvis' in the automotive domain.• Creating backend functionality for features using Python scripts and Flask framework.• Maintaining data in tables and relations along with related SQL queries using

Melville, New York, United States

• Developed, updated and optimized over 50 SQL scripts (IDL, DDL and DML) to enable efficient ETL operations and maintain critical data for business users using Google BigQuery on the Google Cloud Platform.• Actively supervised proper data migration from IBM AS400 and SFDC to BigQuery using ETL pipelines and tools like Google Composer, Qlik Replicate and Fivetran; leveraging Apache Airflow to move data between landing, raw and prepared data layers.• Automated internal processes using Shell scripts and Python.

Huntington Station, New York, United States

• Created and modified 30+ Python scripts to automate web-scraping using Selenium Webdriver and obtain relevant data.• Generated over 30 residential property data reports by creating relevant queries using SQL scripts and database tables. • Constantly monitoring on-premise systems, including company servers running on LINUX and occasionally provisioning and setting up Virtual Machines for employees.

Greater New York City Area

• Assisted Professor Michael Tashbook with teaching a course on Python to more than 150 students.• Helped and guided students with basic concepts of Python• Gained invaluable problem solving and inter-personal skills

Gurgaon, India

• Observed how Aon tackles its internal networking issues from around the world; participated in real time monitoring of networking systems using analytical tools like Netscout.• Got familiar with key concepts of major routing protocols and procedures in network administration including EIGRP, BGP, RIP, etc.; did basic configuration and setup of routers, access points and switches using Cisco IOS.• Explored the VMware SDDC environment and how AON has designed their data centers worldwide; learned key concepts of the ESXi model

Greater New York City Area

• Assisted in ERP management and accounting using SAP Crystal Reports; creating and maintenance of Purchase Orders using Jobscope; Exporting and editing files on MS Excel.• Gained experience in linking database (OLEDB) with ERP systems.

Stony Brook

I assisted Professor Aruna Sharma with teaching a Hindi language course.I was responsible taking questions from students and providing the best answers. Preparation of examination and homework material was also a part of this role.

Stony Brook University

My primary responsibilities included:• Providing assistance in managing and executing field operations in logistics and University maintenance operations.• Frequently lead and managed teams of up to 10 employees during field operations.• I have improved my decision-making skills and adopted a task-oriented work habit by undertaking these responsibilities.

Pune Area, India

• Created a working local web application with the coding and implementation of API’s. It was a rough representation of a typical E - commerce web page.• Learned and worked with PostgreSQL, Angular 4 and Java.• Garnered substantial experience about the working of a typical IT corporation.

United States

Served 15-20 students daily and worked with teams of 6 – 8 staff members to assist in preparing and cooking food.

Hyderabad Area, India

• Worked on basic HTML and PHP to create blueprints of webpages for the organization.• Experienced a holistic perspective of how IT firms develop business applications for their clients to help them improve their operations.

Bachelor Of Science - Bs, Computer And Information Systems Security/Information Assurance, 3.33

Activities and Societies: Specialization in System and Network Administration.Placed on Dean's List 3 times during my Academic Career

High School, General Sciences

10Th Grade, General Studies