Pragya Varshney
Hayward, CA, USA 704-***-**** ********.******@*****.*** 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