Udaya Krishna Karanam

Projects

My Portfolio Website

I needed a professional platform to showcase my skills and projects. A portfolio website was the ideal solution to present my work with a comprehensive view of my abilities. I aimed to design and develop a project portfolio website using HTML, CSS, and JavaScript. The website needed to be visually appealing and easy to navigate, ensuring it worked well on both desktops and mobile devices. Additionally, it was important to include detailed descriptions of my projects.

I started by sketching a layout for the website, focusing on a clean and modern design. I built the website using HTML for the structure, CSS for styling, and JavaScript for interactive elements. I implemented responsive design techniques to ensure that the site looked great on various screen sizes, from desktops to smartphones. For each project, I wrote detailed descriptions explaining the objectives, technologies used, and my role in the project. After thoroughly testing the website, I committed the code to a GitHub repository for version control and deployed the site using Netlify, ensuring easy access and continuous integration.

The portfolio website successfully showcased my projects and skills in a professional and organized manner. It provided a central location for potential employers and collaborators to view my work and learn more about my expertise. The responsive design ensured a consistent and user-friendly experience across all devices.

Skills: HTML · JavaScript · Creative Work · Cascading Style Sheets (CSS) · GitHub

Adidas Sales Insights

Needed to analyze a large dataset of Adidas sales information to gain insights into their business performance, identify trends, and make data-driven decisions. The dataset from Kaggle included a wide range of metrics, such as revenue, product performance, and regional sales distribution. My task was to use Tableau to create data visualizations that aligned closely with Adidas's business needs. The goal was to develop intuitive dashboards and visualizations that would provide actionable insights into sales performance, highlight key metrics, and enable deeper exploration of the data.

I began by exploring the dataset to identify the most relevant metrics and trends. I then leveraged Tableau's powerful features to design a series of dashboards and visualizations, including charts and graphs. These visualizations showcased key metrics such as total revenue, sales trends over time, product category performance, and regional sales distribution. I used color coding to differentiate data points, applied filters to customize users' views, and implemented drill-down capabilities for a more detailed analysis. This approach ensured that users could easily interpret the data and gain insights at various levels of detail.

The visualizations I created gave a comprehensive view of sales performance. The dashboards enabled the company to quickly identify top-performing products, regions with the highest sales, and areas needing improvement. The flexibility of the Tableau dashboards allowed users to interact with the data and drill down into specific metrics, facilitating more informed decision-making.

Skills: Datasets · Tableau · Creative Work · Data Visualization

Student Grade Management System

Many educational institutions rely on manual processes or outdated software, making it challenging to analyze student data and track progress. I aimed to create a comprehensive student grade management system using Python. The system needed to handle student IDs and marks for various subjects, calculate relative and average grades, and store this information in a CSV file. Additionally, it was important to include features for editing and deleting records and visualization tools like bar charts and heatmaps.

I began by outlining the system's requirements, and to store data, I used dictionaries. I implemented functionalities to input, edit, and delete student records, ensuring that all changes were accurately reflected in the CSV file. To enhance the user experience, I added visualization features, including bar charts to display the average marks of all students per subject and heatmaps to illustrate individual student marks. Finally, I developed a feature to generate a comprehensive grade report in a tabular format.

The system proved to be highly effective and user-friendly, allowing users to manage student data efficiently. The visualization features provided clear insights into student performance, making it easier for educators and administrators to identify trends and areas for improvement.

Skills: Datasets · Anaconda · NumPy · Data Manipulation · Python (Programming Language) · Matplotlib · Seaborn · Team Coordination · Data Visualization · Teamwork


Walmart Superstore Relational Database Management System

Walmart Superstore requires an efficient database system to manage its dynamic operational data. My task was to design and implement a relational database management system (RDBMS) using SQL in APEX Oracle. This involved creating a comprehensive database structure that could efficiently store and manage the diverse data types relevant to Walmart's operations. The system needed to ensure data integrity, minimize redundancy, and support efficient data retrieval and manipulation.

I started by developing an Entity-Relationship Diagram (ERD) to visualize the database structure and relationships between entities. Redundancy was reduced and data integrity was ensured by applying normalization and refining database schema. This process involved designing tables and relationships to accommodate various data types, such as product information, inventory levels, sales data, and customer information. The implemented RDBMS significantly improved data management. The normalized schema ensured data integrity and reduced redundancy, leading to more reliable data storage and retrieval.

Skills: Datasets · Data Manipulation · ERD · Relational Databases · Oracle Database · Database Management System (DBMS) · Team Coordination · Teamwork · SQL