Joyson Prince Alvares

Power BI Developer.Data Analyst

[email protected] +91 7624892931

Resume

Hello, I am

Joyson Prince Alvares.

1

Excel
Project

3

PowerBI
Projects

2

SQL
Projects

About Me

Welcome to my world of data wizardry! I'm not just your average Data Analyst -- I'm a passionate explorer of digital landscapes, armed with Excel, SQL, Python and Power BI as my trusty tools. While my journey began with a degree in Mechanical Engineering, I discovered my calling lay in the captivating realm of Data Analytics.

Sure, I may not have clocked in at a traditional organization yet, but don't let that fool you. My projects have been real-world business cases, where I've dissected and decoded data to unearth invaluable insights. From crunching numbers to crafting compelling visualizations, I've turned raw data into gold mines of actionable intelligence.

So, why should you pay attention? Because I'm not just another name on a resume -- I'm a dynamic problem-solver, a relentless learner and a creative thinker ready to tackle any challenge thrown my way. Let's team up and revolutionize the way you look at data.

Key Skills

SQL

Tableau

Python

Effective Communication

Stakeholder management

My Projects

Customer and Market performance Analytics - AtliQ Technologies

Domain/Function: Consumer Electronics

Business Insights 360 - AtliQ Technologies

Domain/Function: Consumer Electronics

PwC: Customer Churn, Customer Risk Analysis and Call Centre Trends

Hospitality Trends Analytics - Hotel Chain Project

Sales and Finance Analytics - AtliQ Hardware

Customer Goods Ad-Hoc Insights

My Experience

Power BI Developer - Indigatech FZ LLC, UAE

Jan 2022 - May 2023

● Operational Insights and efficiency: Developed and maintained Power BI dashboards, improving operational efficiency by 30% through real-time insights into key metrics.

● Quality Improvement and Analysis: Achieved a 60% decrease in customer complaints by reducing the defect rate from 5% to 2% through rigorous data analysis and quality control measures.

● Maintenance of machineries: Decreased machine downtime by 20% by implementing predictive maintenance and real-time monitoring systems, enhancing overall production efficiency.

● Stakeholder management: Worked closely with technical and non-technical stakeholders, translating business requirements into actionable insights, resulting in a 25% improvement in project execution.

Awards & Certificate

Numpy, Pandas & Matplotlib

PwC: Customer Risk & Churn analytics

Python Core concepts

Lean Six Sigma Black Belt

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://linkedin.com/in/prince-joyson7

Call Me

+91 7624892931

GitHub

https://github.com/JoysonPrince

Excel Project

Customer and Market performance Analytics - AtliQ Technologies

Domain/Function: Consumer Electronics

Created 7 reports for the management which will help in understanding financial health, customer behaviour, market position and profitability, enabling informed decision-making and strategic planning

View Project
Engagement

View Project
on GitHUB

By including GM% alongside GM values, the report offers insights into the profitability and cost efficiency of operations in each country

Top-5 & Bottom-5 Product Reports rank performance by sales, aiding stakeholders in identifying best and worst performers

Project Details

Customer Performance Report:
The Customer Performance Report provides a comprehensive analysis of sales performance for FY19, FY20, and FY21, allowing stakeholders to compare sales figures across multiple fiscal years and identify trends or patterns in customer purchasing behavior over time.

Division-level Report:
--> There are 3 divisions in which AtliQ has divided their products: A. Peripherals & Accessories, B. Networking & Storage devices, and C. PC components like Desktops,Notebooks
--> This report will give an idea on which product division sells generates more sales for them.

P&L Report:
--> The P&L Report provides a detailed breakdown of financial metrics such as net sales, cost of goods sold (COGS), gross margin, and gross margin percentage for different countries, allowing stakeholders to analyze the financial performance of each country's operations and identify regions contributing the most to overall profitability.

PowerBI Project

Business Insights 360 - AtliQ Technologies

Domain/Function: Consumer Electronics

Led the development of comprehensive Power BI dashboards for diverse teams at AtliQ Technologies, empowering Sales, Finance, Supply Chain, Marketing, and Executive teams with actionable insights for informed decision-making and enhanced performance

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

SQL

Dynamic P&L statement and matrix visuals empower users to compare current performance with benchmarks across categories, products, segments, markets.

Insightful metrics compare customer and product performance, including net error, absolute error, and forecast accuracy, year-over-year.

Project Details

Developed a comprehensive dashboard accessible to stakeholders across Sales, Finance, Supply Chain, Marketing, and Executive teams. Key highlights include robust data modeling, user-centric dashboard design, and drillable filters for enhanced usability.

Key Concepts Mastered:
--> Proficient in Power Query for both basic and advanced data transformations.
--> Expertise in DAX for complex calculations.
--> Demonstrated proficiency in data modeling with over 10 tables using STAR and SNOWFLAKE schemas.
--> Skilled in selecting appropriate visuals and implementing conditional formatting.
--> Advanced understanding of Power BI features including bookmarks, dynamic visual titles, numeric and field-based parameters, image and
button-based action controls.
--> Successfully deployed reports in Power BI Service and incorporated stakeholder feedback for continuous improvement

Project video

Live Interactive Dashboard

PowerBI Project

PwC: Customer Churn, Customer Risk Analysis and Call Centre Trends

Successfully executed Power BI projects for PwC, including customer churn analysis, customer risk assessment, and call center trend analysis. Leveraged advanced analytics to deliver actionable insights and drive strategic decision-making.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Designed precise visuals for churn rate contributions by customer contracts, subscription services, and internet types

Developed precise visuals for at-risk customers based on payment methods, loyalty, and internet services

Project Details

Crafted an accessible report for PwC stakeholders, delving into customer risk, churn analysis, and call center trends.
Emphasized on:-
1. Identifying churned customers
2. Applying design principles
3. Analyzing trends of at-risk customers
Key Learnings:
--> Mastery of Power Query for intricate data transformations
--> Proficiency in DAX for nuanced analysis
--> Expertise in HR metrics like churn rate and gender attrition
--> Strategic use of visual and page-level filters
--> Implementation of advanced Power BI features such as bookmarks and interactive controls
--> Seamless deployment of reports in Power BI Service.

Project video

Live Interactive Dashboard

PowerBI Project

Hospitality Trends Analytics - Hotel Chain Project

Transformed hotel chain data into actionable insights using Power BI, analyzing key metrics like ADR, occupancy, and realization rates across multiple properties in 4 Indian cities. Enhanced decision-making for optimized operations and revenue growth.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Displayed dynamic card visuals and tabular data for hotel metrics, analyzing weekly trends in occupancy rate and ADR.

Presented cancellation rates by cities and booking percentages by platform, enhancing data-driven decision-making.

Project Details

Designed a dynamic Power BI dashboard for AtliQ Grands management, facilitating week-on-week, city-wise analysis of hotel customer trends. Highlights include:
--> City-wise property performance assessment
--> Week-over-week trends in occupancy rate, realization rate, and revenue
--> Drillable filters for top-2 and bottom-2 performing cities.

Key Learnings:
--> Utilized the latest updates in the Card Visual to enhance visual appeal and highlight trend changes.
--> Applied basic and advanced hotel chain metrics such as RevPAR, occupancy rate, and ADR.
--> Implemented scroll button feature using Bookmarks for property and city analysis.
--> Explored the weekday/weekend concept for luxury/business/leisure hotels, analyzing occupancy rate and revenue trends.

Project video

Live Interactive Dashboard

SQL Project

Sales and Finance Analytics - AtliQ Hardware

Mastered SQL for sales and finance analytics. Developed custom functions for fiscal timeframes, utilized stored procedures, CTEs, VIEWs and subqueries for insightful data analysis. Enhanced team decision-making with actionable insights.

View Project
Engagement

View Project
on GitHUB

Other Tools

Excel

Produced SQL report showcasing FY21 gross sales metrics for Croma India, including sales, fiscal months, product details

Crafted a professional report for Amazon India, detailing fiscal years, product codes, names, and total gross sales

Project Details

--> Successfully completed a dynamic sales and finance analytics project for AtliQ Tech, integrating user-defined functions for fiscal timeframes and essential business metrics such as pre-invoice discounts, net invoice sales, and gross sales.
--> Implemented stored procedures to automate report generation for top 5 customers, markets, and products by net sales across fiscal years, offering user-friendly input options.
--> Leveraged Views and CTEs to streamline code complexity, ensuring efficient data processing. This project showcases adeptness in SQL, data analytics, and user-centric solution development, driving informed decision-making and operational efficiency.

Project video

SQL Project

Customer Goods Ad-Hoc Insights

Empower decision-making with real-time SQL queries, ad-hoc reporting, data visualization, and predictive analytics. Enhance efficiency, gain a competitive edge, and ensure data security.

View Project
Engagement

View Project
on GitHUB

Utilized SQL aggregation and sorting techniques to analyze unique product counts per segment, facilitating informed decision-making based on segment-

Employed SQL's rank function and common table expressions to identify top-selling products within divisions for fiscal year 2021, aiding in strategic

Project Details

--> Completed a comprehensive adhoc SQL project for Atliq Hardware, focusing on market operations, product trends, customer behavior, and sales performance.
--> Developed customized SQL queries to address specific stakeholder requests, ranging from market segmentation to product analysis and customer discounts.
--> Utilized MySQL features including stored procedures, views, and common table expressions (CTEs) to streamline code complexity and optimize data processing. This project demonstrates expertise in SQL, data analysis, and tailored solution development, empowering strategic decision-making and operational excellence
Concepts learnt:
1. Window functions
2. Multiple-table JOIN
3.Aggregate functions
4. Multiple CTEs