My Personal Portfolio
Hello! I'm Harsha
I am a data professional with Having of experience in data engineering and analytics. My expertise includes building and optimising ETL pipelines, data modelling, and managing large-scale data processing. I have hands-on experience with tools like Python, SQL, and PySpark, along with cloud platforms such as Azure Data Factory (ADF), Azure Databricks, Azure Data Lake, Azure Event Hub, and Azure Monitor. I also use Power BI to create reports and visualisations. Passionate about designing scalable data solutions, I specialize in transforming raw data into actionable insights for business growth.
Harshavardhan Naik Sugali
Azure Data Engineer
Email:
Address:
Walsall, England, United Kingdom
Date of Birth:
06-06-2000
EDUCATION
Sep 2022 - Dec 2023
Master's Degree
Nottingham Trent University, Nottingham
MSc in Engineering Management at Nottingham Trent University, I developed expertise in global business operations, project management, and product lifecycle planning. I mastered methodologies like Six Sigma and Kano Analysis while focusing on operational efficiency and customer-centric design. This academic journey enhanced my leadership and strategic planning skills, earning commendation for outstanding performance.
July 2017 - June 2021
Sri Venkateshwara University, India
Bachelor's Degree
Bachelor of Engineering in Mechanical Engineering from Sri Venkateswara University. My studies included a strong focus on technical and engineering disciplines such as Computer Programming, CAD/CAM, Finite Element Method, Automobile Engineering, and Thermal Engineering. I also gained knowledge in industrial management and operations, equipping me with a solid foundation in both engineering principles and practical problem-solving.
June 2015 - Apr 2017
High School
Narayana Junior College, India
I completed my high school education at Narayana Junior College, specialising in Mathematics, Physics, and Chemistry. I graduated with distinction, gaining a strong foundation in analytical and scientific concepts that have supported my academic and professional journey.
PROJECTS
1) Azure Data Engineering - Car Sales Analysis
Overview
In today's data-driven world, businesses rely on real-time insights for better decision-making. This project aimed to design and implement a modern data pipeline to efficiently process car sales data using Azure cloud technologies.
Key Features
-
Automated Data Ingestion from SQL databases using Azure Data Factory.
-
Incremental Data Processing to handle real-time and batch workloads efficiently.
-
Transformation & Cleaning using Azure Databricks (PySpark, Spark SQL).
-
Optimized Storage with Delta Lake (Medallion Architecture: Bronze, Silver, Gold).
-
Data Modeling with Star Schema for efficient business intelligence queries.
-
Interactive Power BI Dashboards for sales trend analysis and insights.
-
Azure Security (RBAC & Unity Catalog) – Data governance & security.
What I Built
-
ADF pipeline for data extraction & loading
-
Databricks processing (Bronze → Silver → Gold)
-
Delta Live Tables for real-time updates
-
Power BI visualization for trend analysis
Technologies Used
-
Azure Data Factory | Databricks (PySpark) | Delta Lake | Power BI | SQL
Conclusion
Enhanced my Azure Data Engineering skills in real-time data processing, Delta Lake, and Power BI. Excited to apply these skills in enterprise-scale projects!
2) Coffee Shop Sales Dashboard
Overview
This project is an Excel dashboard that tracks key metrics for a coffee shop, enabling data-driven decision-making.
Sample Data
-
Date, Time, Product Name, Store Location, Sales Amount, etc.
Features
-
Total Sales Visualisation.
-
Top 5 Products by Sales and Transactions.
-
Footfall Analysis by Location.
Insights
-
Peak sales hours help optimize staffing.
-
Top-selling products guide inventory.
Technologies Used
-
Microsoft Excel: Pivot Tables, Charts, Slicers, Formulas.
Conclusion
This dashboard optimizes resource allocation, enhances marketing, and improves customer satisfaction.
3) Apple Retail Sales SQL Project
Overview
Analysed over 1 million rows of retail sales data to derive actionable insights for business decisions.
Key Components
-
Database schema with five interconnected tables (stores, products, sales, etc.).
-
Entity Relationship Diagram (ERD).
SQL Use Cases
-
Analyzed year-over-year growth for each store.
-
Segmented product sales trends by lifecycle.
Achievements
-
Designed efficient queries for large datasets.
-
Optimized performance with advanced SQL techniques.
Skills Gained
Advanced SQL, problem-solving, correlation analysis, and data segmentation.
Conclusion
This project demonstrates my SQL expertise and ability to solve complex data challenges.
4) Advanced IT Portfolio Management Dashboard
Introduction
This Power BI dashboard offers actionable insights for IT portfolio management, focusing on budget tracking, risk management, and project oversight.
Objectives
-
Data cleaning and preparation in Excel.
-
Advanced analysis using DAX in Power BI.
-
Designing impactful visualizations for clear decision-making.
Key Features
-
Portfolio overview with 212 projects and a $296.8 million budget.
-
Budget tracking and risk management using RAG status.
-
Leadership insights to analyze management strategies.
Technologies Used
-
Excel, Power BI, DAX.
Outcomes
Enhanced decision-making and risk management for IT portfolio leaders.
5) Credit Card Financial Dashboard
Introduction
This Power BI dashboard delivers real-time insights into credit card operations, focusing on key metrics like revenue, transactions, and delinquency rates.
Problem Statement
To provide stakeholders with weekly insights into critical performance metrics for better decision-making.
Steps Followed
-
Data preparation and integration using MySQL and Power BI.
-
Dashboard design with advanced visualizations.
-
Insight generation for trends and growth metrics.
Key Insights
-
WoW Change: Revenue decreased by 12.8%, activation rate at 57.47%.
-
YTD Overview: Total revenue: $55M, delinquent rate: 6.06%, top states contribute 68%.
Technologies Used
-
MySQL, Power BI, Power Query Editor.
Outcomes
Improved monitoring of revenue trends, customer behaviors, and state-level performance.
Conclusion
This project demonstrates my expertise in data integration, analysis, and visualization for business impact.
SKILLS
SQL - Advanced
Microsoft Excel - Advanced
Power BI - Advanced
Python - Proficient
Azure - Proficient
English - Fluent
EXPERTISE
I'M A TITlLE
As a Data Professional, I specialise in transforming complex data into actionable insights that drive strategic decisions. With expertise in data visualisation, predictive modelling, and statistical analysis, I uncover trends to optimize performance. I am committed to delivering tailored, data-driven solutions that empower business growth.
I'M A TITlLE
As a data professional, I build and improve data pipelines, making sure data is processed efficiently and accurately. I work with tools like Azure, Databricks, and Power BI to turn raw data into useful insights that help businesses make better decisions. My experience includes handling large data sets, automating workflows, and ensuring data is secure and well-organized. I enjoy solving data challenges and always look for ways to improve my skills and stay updated with the latest technologies."
I'M A TITlLE
"I specialize in designing and optimizing data pipelines to ensure smooth and efficient data processing. Using tools like Azure, Databricks, and Power BI, I help transform raw data into meaningful insights that drive business success. My expertise includes real-time and batch data processing, automation, and data security. I am passionate about solving data challenges and continuously learning new technologies to improve efficiency and performance."