ROOPSHIKA VENNAM

Salt Lake City, Utah aduyci@r.postjobfree.com 801-***-****

https://www.linkedin.com/in/roopshika-vennam/

EDUCATION

Master of Science - Information Systems Aug Aug 20 2023 3 University of Utah, Salt Lake City. CGPA: 4.0

Coursework: Business Intelligence and Analytics, Database Theory/Design, Networking & Servers Bachelor of Technology - Electronics and Computer Science Jul Aug 20 2023 1 Sreenidhi Institute of Science and Technology, Telangana, India. CGPA: 3.65 Coursework: Core JAVA, SQL, Data Structures, Machine Learning, Statistics, R Programing TECHNICAL SKILLS

Programming: Java, SQL (MySQL, PostgreSQL), R, Python (Matplotlib, Numpy, Pandas), JavaScript, UNIX

Web Development: HTML, CSS

Tools: Ab Initio, Teradata, DOMO, Power BI, Excel

OS: Windows, Linux

• Certification: Machine Learning – Coursera

PROFESSIONAL EXPERIENCE

Asst. Systems Engineer TATA Consultancy Services Jun 2021 - Jul 2022

Single handedly coded and tested more than 500 business rules over various dimensions using Teradata SQL Assistant/Tectia-SSH achieving an accuracy of over 97% in a time bound environment.

Enhanced the data quality of over a billion entries by computing Data Variance/Threshold check required to identify the inconsistency of data in four dimensions: completeness, domain, range and integrity.

Using ETL developed generic graphs to identify and reduce the noise in the client’s data using Ab Initio tool.

Transformed logics to SQL queries, managed to simplify (templating) and improve overall functionality. Intern National Small Industries Corporation (NSIC) - Hyderabad May 2019 - Jun 2019

• Utilized Pads software to create schematics for printed Circuit Board (PCB) design. ACADEMIC PROJECTS

Domo – Layton Hackathon Nov 2022

• Developed different visualization cards by analyzing Layton Construction’s data to define whether the ongoing projects qualify for further development based on the affecting conditions using DOMO. Football Fantasy Premier League Oct 2022

• Developed a live two-player game using PostgreSQL. The players choose their fantasy team from the created database to compete. Based on the chosen team's attributes, complex computation is performed by the SQL queries and winner is declared.

Traffic Signaling System using Image Processing May 2021

• Developed a fully autonomous dynamic traffic signaling system that applies the Haar Cascade algorithm for car detection and computation of traffic density that runs on a microcontroller. Stock Market Analysis using Data Science May 2020

• Developed a web scraping tool using Python to mine data from a provided website, cleaned it and used it to forecast the market analysis for the company, provided the company abbreviation given as an input. Color Based Fruit Harvesting Machine using Image Processing Aug 2019

Build a working prototype of a color-based segregation machine, which could improve harvesting by separating ripe fruits from unripe.