Harika Katragadda

704-***-**** ac57p6@r.postjobfree.com 9509F University Terrace, Charlotte, 28262 SKILLS

• 2.5+ years of experience in Software Development and Data Analysis.

• Experience in design and development of software applications using Agile and Waterfall methodologies.

• Expertise in Developing Web Applications using Java Spring MVC, JavaScript, Bootstrap HTML5 and CSS.

• Good understanding of Object Oriented Design concepts and Software Design Patterns.

• Experience in handling Large Databases of up to 700G in Test, Development and Production environments. Expertise in implementing Database Stored Procedures, Functions, Indexes and Triggers.

• Strong working knowledge in Machine Learning Algorithms in Python and R.

• Excellent problem solving and communication skills with ability to meet challenging deadlines. EDUCATION

Masters of Science in Information Technology May 2018 University of North Carolina, Charlotte, NC GPA – 4 out of 4 Bachelor of Technology in Electronics April 2015

K L University, Vijayawada, India GPA – 8.97 out of 10 TECHNICAL SKILLS

Programming Languages : C/C++, SAS, R programming

Web Technologies & Frameworks: JAVA, Spring MVC, Hibernate, REST API, Spring Boot, HTML, CSS, Bootstrap, JQuery, JSP and Servlets, JavaScript, XML, JSON Scripting languages: UNIX shell scripting, Python, Perl and Powershell Databases: MySQL, Oracle 11g

Tools/Software’s: Selenium, UFT,SAS Enterprise Miner, EXCEL, Tableau, Eclipse, Net Beans, Quality Centre (HPQC),SVN, Git, NGC-eSPS, Jira, Taiga, SSIS. Application Servers: Apache Tomcat, Glass Fish; Cloud Services: AWS PROFESSIONAL EXPERIENCE

Wipro Technologies Project Engineer Chennai, India January 2015 – December 2016 Skills - Perl, MySQL, MS Excel, UNIX, HP Quality Centre Responsibilities:

• The project includes developing and enhancing the applications to make the Order management System simpler and effective.

• Primary contributor of enhancements and maintenance tasks in development team.

• Design and evaluate the necessary database schemas and data transformations for individual projects.

• Assisted in database maintenance, optimization, and replication in a global database deployment.

• Review and modify new and existing stored procedures to enhance performance and incorporate best practices while encouraging and educating others.

• Analyzed user requirements and designed the database changes accordingly.

• Strong experience supporting large database environments by creating complex stored procedures, helped in optimizing the database by writing queries and triggers.

• Automated recurring data extraction activities using a combination of SQL routines and Perl scripts.

• Developed projects which integrate the production data with different source systems.

• Responsible for gathering requirement, perform coding, Unit testing, System testing and integration Testing. Support during UAT.

• Earned Management appreciation for working quickly and logically under pressure, understand and fix problems in a fact-paced environment.

Utkata Soft Solutions Summer Intern Hyderabad, India May 2017 – September 2017

• Underwent training in Java and Selenium.

• Developed a website that allows customers to directly buy goods from seller over internet using Java, JSP, HTML, CSS, MySQL and Java Script.

• Automated the manual test cases into Selenium Web Driver scripts. Performed test execution and raised issues in JIRA.

• Used 3-tier architecture for presentation, business and data access layers. ACADEMIC PROJECTS:

StarterZone: Skills – Spring Boot, Hibernate, Thymeleaf, HTML, CSS, Bootstrap, MySQL,Git StarterZone is an ecommerce website which facilitates users to browse and buy curated startup products. Implemented in agile methodology. Implemented various design patterns, written user stories and acceptance criteria for each user story in TAIGA. JavaScript is used for server-side validations and UI development. Data access is implemented using Hibernate.

Apartment Management system: Skills – Spring Boot, Hibernate, CSS, HTML, Bootstrap, MySQL,Git Developed web application for housing community for tracking and managing grievances of tenants. The main aim of our web application is to automate most of the interactions between tenants and the leasing office. Implemented service layer using Spring annotations and Controllers. Used JavaScript for Client Side validation in JSP pages. Implemented all the components following test-driven development methodology using JUnit.

Conduira - Education services Web application: Skills – Servlets and JSP, HTML, CSS and MySQL. Developed a website which provides details regarding all the programs and their timings provided by the coaching institute. Implemented dynamic web pages using JSP. Handled HTTP Requests using Java Servlets and developed the project using MVC model.

Pump it Up: Data Mining the Water Table: Skills - R It is a intermediate-level practice competition by Data-Driven where we predicted one of the three classes based on a number of variables about what kind of pump is operating, when it was installed, and how it is managed using machine learning algorithms like Decision Trees and Random Forests and the results are compared to make accurate predictions.

Daimler Trucks: Skills – Tableau, D3 JS

It is a Truck Manufacturing Plant Visualization Challenge where we analyzed the data using Tableau and developed Sunburst prototype using D3 so that the user can make a faster informed decision making and know where to focus attention. Developed a dashboard that presents a graphical representation of performance in various aspects which can assist employees at Daimler’s trucks manufacturing plant in key decision making. Surprise Discoveries from Health Information: Skills – R In this project we developed a computational approach to identify “surprising” news from a news corpus related to diabetes. We have used different techniques and finally used Topic modelling to decide the final surprise. Our surprise calculation is based on established metrics in the text mining field called Mutual Information (MI) and correlation.

Student Clinic-Electronic Medical Record System: Skills – MySQL Student Clinic is a database project designed to facilitate student health record in a university. Created an API using stored procedures that allows an EMR system developer to work with the database without having to write SQL statements. Implemented user authentication and role-based access control. Tape Management System: Skills – C, Data Structures, UNIX In this project we implemented a system to manage the usage and retention of computer backup tapes. Our project provides the features of reading and understanding physical structures of the available libraries of tapes.

Contact this candidate