Powered by
Codebasics DA Bootcamp

STEPHEN KERMAH YAMSON

Data Aspirant

+233 +233240299689 [email protected]

Resume

Hello, I am

STEPHEN KERMAH YAMSON.

2

Excel Projects

2

PowerBI Projects

1

SQL Project

About Me

I transitioned into financial analysis and planning after a strategic career break as an account clerk, equipping myself with the technical expertise to unlock financial clarity. I leverage my proficiency in Power BI, advanced Excel, SQL, and financial modeling to build robust financial models and conduct in-depth data analysis. This empowers me to provide actionable insights and strategic recommendations that guide individuals and businesses towards achieving their financial goals.

Also, I'm passionate about sharing financial knowledge and insights with a broader audience. Be sure to check out my informative carousel posts on LinkedIn, covering a variety of financial topics!

Let's Connect!!!

Key Skills

sql

financial modelling

Power point presentation

financial statement analysis

My Projects

Awards & Certificate

Financial Analysis & Financial Reporting Excel

Financial Analysis & Financial Reporting Excel

Power BI Financial Analysis & Financial Reporting

Power BI Financial Analysis & Financial Reporting

SQL Financial Analysis & Financial Reporting

SQL Financial Analysis & Financial Reporting

Fundamentals of Financial Analysis

Fundamentals of Financial Analysis

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.

[email protected]

https://www.linkedin.com/in/stephen-yamson-37676418a/

+ 233 +233240299689

Excel Project

Financial Analysis & Reporting with Advance Excel

With the help of DAX (Data Analysis Expressions) and Power Pivot, I was able to create a financial statement dashboard in Excel. This dashboard will tell a story, uncover trends and present data in a way that drives action.

View Project
Engagement

Financial Analysis & Reporting with Advance Excel

This is the Income statement of the Dashboard.

Financial Analysis & Reporting with Advance Excel

This is the Balance sheet.

Project Details

This interactive dashboard provides a comprehensive overview of your financial health, integrating key data points from three essential financial statements: Income Statement, Balance Sheet, and Cash Flow Statement.

Income Statement: Track your revenue streams and expenses over a chosen period (month, quarter, year). See how efficiently you convert sales into profit, with clear breakdowns of Cost of Goods Sold (COGS), operating expenses, and net income.

Balance Sheet: Get a snapshot of your financial position at a specific date. Analyze your assets (cash, inventory, equipment) and liabilities (debt, accounts payable) to understand your solvency and ability to meet obligations.

Cash Flow Statement: Monitor your cash inflows and outflows categorized by operating, investing, and financing activities. Identify trends in cash generation and usage, ensuring you have sufficient liquidity to support ongoing operations and future growth plans.

Project video

PowerBI Project

Financial Analysis & Reporting in Power BI

Uncover financial insights and make informed decisions with this interactive Power BI dashboard, integrating key data from your Income Statement, Balance Sheet, and Cash Flow Statement.

View Project
Engagement

Financial Analysis & Reporting in Power BI

This demonstrates how data is modeled in Power BI to analyze metrics across financial statements and create custom calculations for deeper insights.

Financial Analysis & Reporting in Power BI

This is the home page of the dashboard

Project Details

A beautiful financial dashboard created in Power Bi for analysis and visualization. It shows the income statement, balance sheet and cashflow statement. Its shows other KPIs for management decision.

Project video

Live Interactive Dashboard

SQL Project

SQL for Financial Data Analysis & Reporting

This project empowered me to unlock the power of financial data using SQL, a database query tool. I can now write targeted SQL queries to extract specific data sets crucial for crafting essential financial statements like Profit & Loss Statements, Balance Sheets, and Cash Flow Statements.

View Project
Engagement

SQL for Financial Data Analysis & Reporting

Queries to derive the income statement.

SQL for Financial Data Analysis & Reporting

Queries to determine the Cash flow statement.

Project Details

This project transformed me from a data novice to a confident financial analyst. I harnessed a user-friendly database query tool, ditching complex programming for simple code that unlocks crucial data. My journey included:

Database Navigation: I learned to navigate databases efficiently, pinpointing the data I need for analysis.
Querying Expertise: I mastered crafting clear queries, extracting both broad and specific data sets for in-depth analysis.
Data Manipulation Skills: I honed my ability to sort, filter, group, and split data, unlocking valuable insights from various perspectives.
Financial Reporting Powerhouse: I can now generate essential financial reports like Profit & Loss Statements, Balance Sheets, and Cash Flow Statements – all powered by my newfound database query expertise.
This project equipped me to leverage data effectively, making me a valuable asset for impactful reporting and data-driven decision-making.

Project video

Excel Project

Excel Financial Modeling for Startups and Small Business A-Z

A five-year financial model for a manufacturing company known as Kerma Lemon Drink showing the assumptions, schedules or working and the 3-statement financial model.

View Project
Engagement

Excel Financial Modeling for Startups and Small Business A-Z

This is the assumption for the model

Excel Financial Modeling for Startups and Small Business A-Z

This is the Schedule for the model

Project Details

Built a robust 5-year financial model for a manufacturing company using financial modeling software. Analyzed historical data & industry trends to forecast revenue, costs, and financial statements. Simulated various scenarios (economic shifts, product demand) to evaluate financial impact. This user-friendly model empowers strategic planning, investment decisions, and risk assessment, driving long-term financial health.

Project video

PowerBI Project

Business 360

A power Bi dashboard consisting of the finance view, Sales view, Marketing view, Supply chain view and the Executive view to help management with decision making and strategic planning.

This is the Supply chain View of the dashboard

This is the Sales View of the Dashboard

Project Details

Developed a comprehensive Power BI dashboard for a manufacturing company, providing a single source of truth across key departments: Finance, Sales, Marketing, and Supply Chain. This interactive dashboard offers:

Finance View: Track profitability, cash flow, and key financial metrics for informed financial decisions.
Sales View: Monitor sales trends, analyze customer segments, and identify growth opportunities.
Marketing View: Measure marketing campaign effectiveness and optimize marketing spend.
Supply Chain View: Gain real-time insights into inventory levels, production efficiency, and potential bottlenecks.
Executive View: Consolidated view for strategic planning, highlighting key performance indicators (KPIs) across all departments.
This empowers management with data-driven insights to make informed decisions and optimize overall business performance.

Live Interactive Dashboard

Power Point Presentation of Financial Statement

This is the PowerPoint presentation of the Financial Statement I created in Excel and Power Bi dashboard. It's very insightful and engaging as well. It's very engaging and interesting for non-finance folks.

View Project
Engagement

Power Point Presentation of Financial Statement

This is the balance sheet Overview

Power Point Presentation of Financial Statement

This is the Cash Flow statement Overview

Project Details

This captivating presentation dives deep into financial statements. Created in PowerPoint, it showcases both static Excel dashboards and dynamic Power BI dashboards, providing a comprehensive and engaging financial analysis. Go beyond static reports and explore data interactively, gaining insightful perspectives on the company's financial health and performance. This presentation is ideal for internal stakeholders seeking a clear and engaging understanding of financial information.

Project video