Dhanush Venkata Sai Kella

Master's graduate in Information Technology, with expertise in data analysis, machine learning, and software development. Skilled in transforming complex data into actionable business insights, with a proven track record in Agile project environments. Adept at database management, designing analytical solutions, and driving data-driven decision-making.

• Associate Data Analyst From Data camp Dec,2024

Border Crossing Analysis – US–Mexico & US–Canada

Skills: Python, Pandas, NumPy, Matplotlib, Seaborn, Hypothesis Testing, Linear Regression, Data Visualization, Statistical Analysis

• Collected, cleaned, and analyzed U.S. Border Crossing Entry Data to compare traffic between US–Mexico and US–Canada borders.
• Performed exploratory data analysis (EDA) to identify top crossing modes, seasonal patterns, and trends from 1996–2025.
• Conducted a two-sample t-test to evaluate whether mean crossings differ significantly between borders.
• Built a linear regression model to identify long-term crossing trends and predict future patterns.
• Visualized findings using Matplotlib and Seaborn, producing bar charts, time-series breakdowns, and regression plots.

Database Design & Implementation – High Fashion Inc.

Skills: ERD, Data Normalization, Relational Database Design, SQL, Database Implementation, Data Modeling

• Designed a conceptual ERD to model nationwide store operations, inventory, customers, sales, coupons, and returns for a 20-store U.S. Retail chain
• Developed a relational schema and applied data normalization (up to 3NF) to ensure data integrity and eliminate redundancy.
• Implemented the database in SQL, creating tables, relationships, and constraints to enforce business rules such as inventory tracking per store, manufacturer–product mapping, and sales–returns linkage.
• Optimized queries for sales tracking, inventory monitoring, and marketing campaigns using SQL joins, groupings, and filters.