Pragya Varshney

Hayward, CA, USA 704-***-**** adea5z@r.postjobfree.com LinkedIn - pragya-varshney GitHub - pragyavarshney

Profile

A graduate student from California State University with professional experience of 4 years working on Software Development. Expertise in Python, Java, VBScript automation tools and databases MySQL, Machine Learning. A skilled computer programmer with strong technical and functional experience in data analysis, profiling, and migration. Seeking full-time opportunity in software engineering, data science in a collaborative environment.

Skills

Primary Languages: Python, C++, Java, SQL, JavaScript, PHP

Secondary Languages: node JS, Ruby on Rails, HTML, Bootstrap, CSS, C, ReST Webservices

Database –Microsoft SQL Server, MySQL, MongoDB, Oracle

IDEs: Visual Studio Code, JetBrains (PyCharm, IntelliJ, WebStorm, RubyMine), Eclipse, Trello, PuTTY, etc.

Cloud platform: AWS cloud (EC2, S3, IoT), Heroku, Google cloud (Vision API), GAE, Facebook Graph API

Deep Expertise in IoT and Machine Learning. Developed complete real-time complex tracking system for valuable college Assets to Handle Theft and Mishandling using Python and C++

Proficient in Implementing Machine Learning Algorithms using Python.

Very good understanding Data Structure and Algorithms

Instrumental in Web Designing and Development for frontend and backend using PHP, JavaScript and MySQL

Strong Experience of Software Development Lifecycle and Worked intensively in Multi-Vendor and Onshore-Offshore Model in 4 years of professional experience

Strong customer service orientation, excellent interpersonal and communication skills, and efficient time management

Experience

SYSTEM ENGINEER TATA CONSULTANCY SERVICES

OCT 2011 – FEB 2015 CLIENT – CISCO BANGALORE, INDIA

Extensively worked with data migration team managing the Product (PID) data profiling, fixing the present data error in BOM (Bill of Material) and migrating it to Oracle Agile PLM

Proficiently Designed and developed VB script automation tool and reduced time of work by 20% in excel for data filtering.

Created test cases and deployed NoSQL database (CouchDB) on different OS (Windows8, CentOS) and gave a comparative study between NoSQL database and relational database (SQL based)

Designed scripts to fetch and cluster data on MS SQL Server 2008 using SQL Queries, Functions, and Tables. Increase efficiency of the process by 25% using a database over excel functions.

Strong Experience on Selenium automation testing, created test cases for cisco website

College Project

STUDENT CALIFORNIA STATE UNIVERSITY - EAST BAY

AUG 2018 – MAY 2020(M.S.) HAYWARD, CA, USA

Asset Management: Developed a real-time tracking system for valuable assets of college like projectors, laptops, etc. to oversee the theft and mishandling. Track their position in the campus using BLE tags (IoT) and by using SVM (Machine learning) Model 90% precision to track the location. Used MySQL, WAMP, Python, C++, and PHP.

Smart-Thermostat: Designed, developed, and tested a smart thermostat (Internet of things) to set the AC, fan, or heater on to maintain the temperature of the home. Used sensors PIR, BME680, and devices such as Arduino, Raspberry PI, MQTT broker, AWS cloud. C++, Python

Developed a social-interaction web application for posting pictures and adding comments. Platform use: ruby on rails, MEAN stack hosted on Heroku and JSP and servlets hosted on Google cloud

Education

MASTER OF SCIENCE IN COMPUTER SCIENCE MAY 2020 CALIFORNIA STATE UNIVERSITY CALIFORNIA, HAYWARD, CA, USA

BACHELOR OF TECHNOLOGY IN INFORMATION TECHNOLOGY JUNE 2011 UNIVERSITY COLLEGE OF ENGINEERING, KOTA, RAJASTHAN, INDIA