SaiKumar Chalamarla

Recently joined TCS, successfully completed training in Java, JDBC, and MySQL, further enhancing technical skills. Proficient in programming languages such as Java, Python, and Salesforce Administration. Excited to apply knowledge and contribute to innovative projects at TCS.

Edureka Advanced Python Training, Bangalore

Training Period-06/01/24-08/01/24 

Covered a wide range of topics, including testing with Python, DevOps (Docker), Networking, APIs, REST APIs, with a focus on Machine Learning and Django. Completed a project using the Django framework.

1.Database Management System Project (Departmental Stores) 

Tools - Oracle Database

This project focused on complex query writing, enabling me to become proficient in creating and optimizing queries. It covered key DBMS concepts such as Data Definition Language (DDL), Data Manipulation Language (DML), Joins, Views, and more. This experience solidified my understanding of relational databases and their practical applications. 

2.Financial Data Analysis

Tools: Google Colab, NumPy, Pandas, Seaborn, Matplotlib

The project analyzed bank-data.csv to determine loan eligibility based on a client's profession. It involved reading and preprocessing data, applying conditions to filter eligible clients, and analyzing the results. The goal was to improve marketing campaign efficiency by identifying potential clients for personal loans. 

3.Data Extraction and Text Analysis

Tools: Google Colaboratory, Pandas, Natural Language Processing, BeautifulSoup

This project involved extracting data from URLs listed in an Excel file. It fetched webpage content, extracted article titles and text using BeautifulSoup, and saved the content as text files. The project included sentiment analysis by calculating sentiment scores (positive, negative, and polarity) and assessing readability through sentence length and complex word count.

4. Gym-Nutrition App
Tools: VS Code, Django, Python, HTML, CSS, Bootstrap
Abstract: A subscription-based platform developed using Django, Python, HTML, CSS, and Bootstrap. The app provides personalized fitness training and nutrition plans. It aims to help users improve their health by offering tailored exercise routines and dietary guidance, with an intuitive interface for managing subscriptions and tracking progress.

5.Clothing Website

Tools: HTML, CSS, Bootstrap, PHP, JavaScript | Team Size-3 | My Role: Backend Development, 

I was responsible for backend development using PHP, focusing on server-side logic to manage user accounts, product catalogs, and order processing. This included creating a secure user authentication system, managing database interactions for product details, and implementing features like adding items to the cart, checkout, and order tracking.

• 2-Day National Level 'E-HACK' Cyber Security Summit, 2021, Sky Tech Labs
• Azure Fundamentals (AZ-900)
• Salesforce Certified Administrator, 07/01/24, Present, 4681208
• Salesforce Virtual Internship by SmartBridge, Achieved 64,300 points, 59 Badges, and 2 Superbadges.

• Survey on Chatbot Classification and Technologies, Author, IRJET Volume 9, Issue 11, 2022, https://www.irjet.net/archives/V9/i11/IRJET-V9I1118.pdf
• Human Mimic Chatbot, Lead Author, WJARR Cross Ref DOI: 10.30574/wjarr, https://wjarr.com/content/human-mimic-chatbot

• ACE College Cricket Team Captain, Led the team to win several tournaments.
• Cooking, Fitness