• Migrated data from Oracle to Biq Query for data governance project. Created views and tables for business purposes and optimized queries to reduce latency, memory.• Implemented Spark Scripts using Scala, Spark SQL to access big query tables into Spark for faster processing of data.• Automated ETL processes, making it easier to wrangle data and reducing time by as much as 40%.

• Process, cleanse, and verify the integrity of data used for analysis• Create data ingestion and processing routines using technologies like Talend, Spark, Python, Cognos Cube.• Work with databases like AWS RDS, PostgreSQL, Teradata, and Oracle.• Build data visualization dashboards as per business requirements using technologies like Tableau. • Creating consumer Data reports of financial data using WebFOCUS.• Analyze the defects raised by QA team to fix and implement the changes in QA.• Build and implement code components in AWS Cloud environment

Semester: Summer-2 2020Graduate Teaching Assistant for the course Intro Artificial Intelligence (ITCS 3153).Semester: Summer-1 2020Graduate Teaching Assistant for the course Intro Artificial Intelligence (ITCS 3153).Graduate Teaching Assistant for the course Algorithms and Data Structures (ITCS 2214).Semester: Spring 2020Graduate Teaching Assistant for the course Intro to Machine Learning (ITCS 4156). This course covers linear regression, linear classification, discriminant analysis, logistic regression, other old classification (ie. decision tree, Naive Bayes) clustering (kNN, GMM, agglomerative), dimensionality reduction, reinforcement learning, neural networks, deep learning (tensorflow, autoencoder, CNN, RNN), support vector machines, hidden markov model, Bayesian learning, and ensemble learning.

Technologies used: Infoblox, AKiPS, Putty, Cherwell Browser Client

Client: Andhra Pradesh State FiberNet LimitedThe Andhra Pradesh Fibernet project undertaken by the Tera software limited mainly aims at delivering fast internet services, high quality television and telephone services at the lowest price possible. To keep the customers more satisfied, providing high quality services is not enough but the customer should be provided with guidance and should be kept upto date about his utilization of the data services that are provided, through SMS API.For this purpose a well structured and articulated system is designed, which is compatible with the other modules of the project that are fabricated by using the SPRING framework in java and which goes along with the project flow. Achieved it by using Spring MVC, Maven, JDBC, REST, and SOAP APIs. For the system, A database schema which satisfies all the requirements is created. The database tables contain various flags and other attributes that help in the message sending. Apart from keeping the user informed about his utilization of the data services, the system also gives alerts about the inactive connections and also sees that the user doesn’t use excess amount of high speed data. For this purpose the system is included with features of throttling and de-throttling, using the SOAP API, which reduces and increases the bandwidth of the data connection respectively.Maintaining, tuning, and repairing applications to keep them performing according to technical and functional specifications; performing preventive maintenance activities; providing user support. Optimized the SQL queries thereby resulting in reduced latency and an increase in applications of the users by 20%.

Worked in creating a website Infovijayawada.com that provides local search for different services over the Internet which includes online ads, B2B, B2C services as key contents using Python, HTML, CSS, AngularJS. The goal of this application is to create a space where people can find whatever they need at one place from shopping, jobs, service providers, products, today deals, news, events, rentals and what not. The inventory is meant to provide a smooth interaction between prospective customers and perceptive sellers. Created a real-time messenger/ chatbox to establish a direct connection between the end-user and seller. Implemented optimized check-out page that increased user clicks by 25%, and subsequently customer purchases by 28%. Continuous bug fixes by writing reusable unit test documents to ensure quality for an end-to-end business management solution for SMEs.

Project: intrusion detection system using face detection and recognition (Open CV)The purpose of this project is to implement intrusion detection system using face detection andrecognition (Open CV) and obtain reasonable performance. The automatic detection and email management will replace the manual method, which is time consuming and difficult to detect. Even when needed, having a security camera system may sometimes be impossible due to extensive costs for installation. Also whenever a robbery happens if it is known when it is happening there may be a possibility to stop it. In order to implement this project we need a web camera, internet connectivity, a system to send mail. The system contains a software motion which enables the camera to detect motion and save image. A python script then directs the system to send mail notifications every time the motion is detected. With these components , a cost effective and efficient security camera system is made and reported.