Developer Intern Sql

SUMMARY

SAI VENKATA GANESH PENUMARTHI

**** ****** ****, ******, ***** 75035

Email:******.*****@*****.*** Mobile:+1-940-***-****

Software Developer with a diverse technology experience of around 2.6 years in using Java, JavaScript, SQL, ManualTesting.

Strong command in Data Structures and Algorithms.

Worked and gained good functional exposure on Machine learning Algorithms and reporting tools like Tableau and Power BI.

Actively seeking opportunities to apply my skills, acquire new skills, and help take my firm, and career to the next level.

TECHNICAL SKILLS

Programming Languages

Databases

Java, C

MySQL, MongoDB, Maria DB

Web Technologies HTML, CSS, JavaScript

Cloud Technologies AWS, Microsoft Azure, GCP.

Operating Systems Windows, Linux

Software Development

Methodology

Software Development

Tools

Agile (Scrum), Waterfall

JIRA, Trello

Version Control Tool GitHub, Gitlab

IDE’s and Tools VS Code, PyCharm, IntelliJ, Eclipse, MySQL Workbench, Android Studio, IBM BI Cognos, Tableau, Source Trail, Understand, Visual Paradigm, Source Insight EDUCATION

Masters in Computer Science, MS

University of North Texas Jan 2021 – Present

Courses Advanced Topics in Software Development, Machine Learning, Mobile Development, Software Comprehension, Data Management & Warehousing.

Bachelor of Engineering and Technology in Electronics and Communication Engineering, BTECH GITAM University Jul 2014 – Apr 2018

Courses VLSI, Embedded Systems, Data Structures, Design and Analysis of Algorithms, Database Management Systems, Machine learning, Cloud computing, and Software Engineering. WORK EXPERIENCE

Software Development Engineer, AMAZON LLC, Texas US June 2022 - present

Developing web applications using Java8, Spring Boot Framework which has Coral dependencies

Worked on Projects related to Enforcement Tools and Services on Product Quality.

Worked on AWS services like SWF and CDK using AWS SDK and AWS CLI.

Worked on implementing integration tests for the features that are missing in the project.

Worked on Amazon Dynamo DB using NoSQL and AWS RDS to store the manipulated data developed from the application.

Software Development Engineer, Tata Consultancy services, India June 2018-December 2020. Functionality: Responsible for designing and developing various complex features in web application, monitoring database performances and integrate with different third-party applications.

Developed web applications using Spring Boot, jQuery, and HTML5.

Bottle micro-framework implemented with REST API and MongoDB NoSQL as backend database.

Created PL/SQL Stored Procedures, Functions for the DAO layer by studying the required business objects and validating them using Oracle data base.

Collaborated with an Agile team practicing scrum methodology and gained experience in Agile methods of software development Life cycle

SQL Developer Intern (Copart, India) May 2017 – Jul 2017

Extensively used high level backend PL/SQL programming involving different databases.

Involved in the development of new Procedures, Functions, Packages, Triggers and also updating the old ones based on the change requests.

Involved in the analysis, design, flow, archiving of data and databases and also with their relationships.

Performed unit testing of data extraction forms.

Prepared technical specifications document for the Procedures which is used to update the purchase order information from one database to another database.

Utilized tools like TOAD during development of the application.

Used Database Trigger for making history of insertion, updating, deletion and all kind of Audit routines. PROJECTS

Information Retrieval-Ranking Search Engine (Python, Jupyter Notebook) Winter 2021

Extracted data from the dictionary and stemmed all the words by removing stop words.

Created forward index and Inverted Index for the documents.

Calculated Term Frequency and IDF for the queries and calculated vector cosine similarity.

With the Vector cosine similarities brought the ranking for the document for each query.

Key Performance indicators of a Region (ERD, Normalization, Neo4J, MySQL)

Identified the datasets which provide the information about the region on their website.

Identified entities from the datasets which contribute to the key performance of the region and created ERD and Extended ERD. Identified functional dependencies and performed normalization.

Performed cleaning and loaded some datasets to the neo4j and MySQL database to identify the relationships in the extracted data.

Visualization on Sales Data (Data Warehouse, Star Schema, Snowflake Schema, Cognos BI, Python, Pandas, NumPy)

The goal of this project is to visualize the sales data so that the company can make the right decisions.

Identified the useful data from the Data Warehouse and transformed, cleaned, divided into data marts using python.

Constructed snowflake schema identifying the fact and dimensional table from the data.

Loaded the schema into Cognos BI and made meaningful dashboards that contain charts, plots, and maps.

Contact this candidate