PORTFOLIO
We are all AIs in an evolving world of data... Consciousness is Data!
OVERVIEW
From my early years in IT and web development, I developed business strategies and solutions for banks, insurance companies, and educational institutions to enhance sales, marketing, operations, customer retention, and student admissions.
Today, my work revolves around leveraging business intelligence to drive business growth and development.
My portfolio showcases a diverse range of projects developed using various cutting-edge technologies. These projects are focused on sales, customer, finance, and HR analytics, and have been implemented for the Arizona Group of Companies and its subsidiaries (a fictional company).
Portfolio Projects
Using Agile methodologies and Jira to gather requirements, develop a project plan, and create user stories, acceptance criteria, tasks, and sprints for Arizona Bike Store Sales and Customer Analytics Dashboard.
Using AWS S3, Fivetran, DBT, Snowflake, and Tableau to build an end-to-end cloud BI architecture for the Sales and Marketing department to gain insights into sales performance and customer distribution.
Analyzing Arizona Bike store sales and customer data analytics with Python and SQL to gain insights and answer business questions.
Using Tableau to build a sales and customer dashboard, showing sales metrics, trends, year-over-year performance, customer metrics, engagement and behaviour.
Using a time-series regression model to predict future monthly sales for Arizona Bike stores. A classification model to predict titanic survivals, and a regression model to predict house prices.
Using Tableau to build an employee attrition dashboard for the HR Manager to answer questions on why employees are leaving the company. There are two briefs in this project.
Using machine learning to build an employee attrition predictive model, to predict if an employee is likely to leave the company.
Using Power BI Desktop to build a robust HR Analytics dashboard for Human Resources to answer questions about employee diversity, recruitment, and terminations.
Using SQL to analyze and conduct data validation for the HR Analytics Report in MS SQL Server
Using Power BI Desktop and Tableau to build an Income Statement dashboard and an Accounts Receivable Dashboard for the Management and Finance department to monitor Financial KPIs like Gross Profit, Net Profit Margins, Amount Receivable, and Average Days Overdue.
Using Tableau to build a Help Desk dashboard for the customer service and support department to gain insights into customer complaints and support performance.
Using Postgres and Pentaho to build an on-premises data warehouse for reporting and analytics.