Dinesh kumar Raju

Student

[email protected] +1 6163499681

Resume

Hello, I am

Dinesh kumar Raju.

1

Excel
Project

2

PowerBI
Projects

1

SQL
Project

1

Machine Learning
Project

About Me

As an aspiring Data Analyst, I bring a unique blend of skills and a passion for extracting insights from data. While my academic background is in Mechanical Engineering, my journey has led me to discover my natural talent for data analysis. Proficient in Excel, PowerBI, SQL, and Python, I excel in transforming complex datasets into actionable insights.

Despite not having prior professional experience, I have undertaken numerous business projects that showcase my ability to analyze data effectively. My bachelor's degree provides a strong foundation in problem-solving and analytical thinking, which I leverage in my data analysis projects.

In my portfolio, you will find examples of my work that demonstrate my analytical prowess and dedication to mastering data analysis. I am eager to apply my skills and continue my growth as a Data Analyst.

Key Skills

sql

javascript

python

R language

HTML

Node js

Powerbi

machine learning

statistics

Oracle

My Projects

Sales Insights

Domain/Function: Sales

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

Todos Application

Optimizing Data Management & Automating Processes for AtliQ Hardware using SQL

Domain/Function: Hardware Manufacturing / Data Management & Process Automation

Insights-Driven Power BI Dashboard for AtliQ Grands in Hospitality

Domain/Function: Hospitality Industry / Data Analytics & Visualization

Machine Learning-Based Soil Moisture Prediction

Domain/Function: Precision Farming

My Experience

Data Analyst Intern – AtliQ Technologies
Nov 2024 – Dec 2024 (2 months) – Remote
• Conducted data cleaning and transformation processes using SQL and Python, ensuring the integrity and usability of complex datasets for analysis.
• Developed automated dashboards and reports using Power BI, providing actionable insights to support data-driven decision-making for business strategies.
• Collaborated with cross-functional teams to analyze key performance metrics, identifying trends and patterns that improved operational efficiency by 15%.
• Utilized statistical techniques to interpret data, presenting findings in a clear and concise manner to stakeholders, leading to the adoption of two new strategic initiatives.
• Enhanced existing workflows by implementing data visualization best practices, ensuring effective communication of insights and project results.

Awards & Certificate

Excel: Mother of Business Intelligence

Get Job Ready: Power BI Data Analytics for All Levels 3.0

SQL Beginner to Advanced For Data Professionals

Java script

Let's Connect

Feel free to get in touch with me. I am always open to discussing new projects, creative ideas or opportunities to be part of your visions.

Mail Me

[email protected]

https://www.linkedin.com/in/dineshkumarraju0223

Call Me

+1 6163499681

GitHub

https://github.com/dineshraju147

Excel Project

Sales Insights

Domain/Function: Sales

Created 2 reports for the sales team which will help them to evaluate customer performance and understand their market performance with respect to their target.

View Project
on GitHUB

Customer Performance Report: Provides net sales performance of each customer across years

Market performance vs Target report across years: Enables stakeholders to assess the country's performance and compare it to set targets.

Project Details

In this project, I created a sales report using excel pivot tables which will enable businesses to determine effective customer discounts, facilitate negotiations with consumers, and identify potential business expansion opportunities in promising countries. The reports generated will provide actionable insights and recommendations for businesses to optimize their sales strategies, enhance customer satisfaction, and maximize revenue generation.

I have learned the following:

1. Pivot table
2. Power Query
3. DAX (Basics)
4. Conditional Formatting
5. Report Beautification
6. Sales Domain Metrics

Overall, this project aims to empower businesses with the necessary tools and insights to monitor, evaluate, and enhance their sales activities. By leveraging sales data analysis, businesses can unlock new opportunities, drive growth, and stay competitive in the dynamic market landscape.

PowerBI Project

Business Insights 360 Dashboard for Finance, Sales, Marketing and Supply Chain

AtliQ Hardwares is a consumer electronics company expanding rapidly but is not able to compete with other companies using data as most of their report still exists in Excel. My goal is to implement an advanced analytics solution using Power BI that will enable the company to get insights and make in

View Project
Engagement

User-empathetic landing page as a part of dashboard design

Data modelling involving 10+ tables

Project Details

In this project, the goal is to be one report which could be used by stakeholders from sales, marketing, finance and executive team. The focus is made on the following

1. Robust Data Modeling
2. User-empathetic Report design
3. Drillable Insights

I learned the following things in this project

1. Power Query (Basic and Advanced Operations)
2. Basic and complex DAX formulas
3. Data modelling involving 10+ tables
4. Choosing the right visuals and formatting
5. Dashboard designing principles
6. Using bookmarks
7. Deploying in Power BI service
8. Stakeholder Feedback Implementation
9. Sales, Marketing, Finance & Supply Chain metrics

Live Interactive Dashboard

Todos Application

The Todos Application project involved designing and developing a responsive business website using HTML, JavaScript, CSS, and Bootstrap. The website includes a navigation bar and four main sections: Home, Services, Pricing, and Contact Us. I ensured a seamless user experience across various devices

View Project
on GitHUB

Other Tools

Javascript

In the Todo web application project, I focused on creating a seamless user experience for adding and saving task details. Users can easily input new t

Another key feature of the Todo web application is its functionality for marking and deleting todos. Users can mark tasks as completed, visually indic

Project Details

In the Todos Application project, I aimed to create a seamless user experience for task management. The website, developed using HTML, JavaScript, CSS, and Bootstrap, features a responsive design ensuring optimal functionality on various devices. Users can easily add, delete, update, and mark tasks as completed. The interface is intuitive, with a navigation bar providing easy access to Home, Services, Pricing, and Contact Us sections. Through this project, I honed my skills in frontend development, focusing on user interface design, responsive design principles, and web development best practices.

Project video

SQL Project

Optimizing Data Management & Automating Processes for AtliQ Hardware using SQL

Domain/Function: Hardware Manufacturing / Data Management & Process Automation

Transitioned AtliQ Hardware from an Excel-based system to SQL, optimizing data handling, automating reports, and improving forecasting for sales and supply chain. Utilized stored procedures, CTEs, views, and data triggers to streamline operations and boost efficiency.

View Project
Engagement

Data-set provided by the Atliq hardware

Created store procedures to automate sales reporting

Project Details

In this project, I helped AtliQ Hardware, a global leader in electronics manufacturing, transition from an Excel-based system to SQL, significantly improving their data processes. I implemented SQL-based solutions like stored procedures, CTEs, views, and data triggers to automate sales reporting, market trend forecasting, and supply chain analysis. This streamlined operations, reduced manual tasks, and enabled data-driven decision-making. Key achievements include optimizing query performance using the Star Schema and automating repetitive tasks, ensuring scalability for future growth.

PowerBI Project

Insights-Driven Power BI Dashboard for AtliQ Grands in Hospitality

Domain/Function: Hospitality Industry / Data Analytics & Visualization

Created an interactive Power BI dashboard for AtliQ Grands, providing deep insights into hospitality metrics. Utilized advanced features like drill-through filters and ribbon charts to analyze key metrics across various properties, enabling granular data exploration and trend analysis.

View Project
Engagement

This dashboard dives deep into every property, especially focusing on AtliQ Grand, providing invaluable insights into the hospitality industry.

Implemented advanced features, with a special focus on learning and utilizing drill-through filters for a more granular view of data.

Project Details

In this project, I developed a comprehensive Power BI dashboard for AtliQ Grands, focusing on key metrics within the hospitality industry. The dashboard provides a deep dive into property performance, using drill-through filters for a detailed, property-specific view. I also incorporated a ribbon chart to display key metrics by city over time, bringing new insights to the analysis. This project enhanced my skills in data visualization and advanced Power BI functionalities, driving actionable insights for better decision-making in hospitality management.

Live Interactive Dashboard

Machine Learning Project

Machine Learning-Based Soil Moisture Prediction

Domain/Function: Precision Farming

Efficient water management is essential for precision farming. This project leverages machine learning to predict soil moisture levels in unsensed areas using limited sensor data. By reducing sensor dependency, this solution makes precision farming more affordable and scalable.

View Project
on GitHUB

1. Marked Coordinates: o Central and peripheral points were identified for sensor deployment.

2. Data Collection: o Moisture data was recorded at each marked point individually over several days using a single sensor.

Project Details

• Developed a machine learning model to predict soil moisture levels, achieving R² almost 0.9 and reducing sensor deployment costs by 50%.
• Simulated moisture trends using real-time environmental data, providing actionable insights for improved irrigation planning.
• Automated data preprocessing and feature engineering, ensuring seamless integration and enhanced prediction accuracy.