Albert Opiyo

About Me

I  am a  Data analyst a.k.a Data Plumber who is passionate about data. I love working with data and helping businesses identify areas in their business that could be improved and coming up with solutions to solve the problems. I am open to exploring different opportunities in your company that will help me improve business processes, develop a better understanding of business operations and processes, and lead data-driven initiatives that will help you make data-driven decisions.

Work & Experience

Business Developer and Analyst

Conqueror Auto

05/03/2021 - 08/02/2022

I used excel to maintain accurate up-to-date financial records and track income, expenses and cash flows. Extracted and compiled financial data from various sources, including databases, spreadsheets, and text files. Conducted data cleaning, formatting, and statistical analysis to identify trends and patterns. Created data visualizations using Excel and Power BI to communicate insights to stakeholders. Built and updated financial models in Excel to forecast sales, expenses, and profits. Conducted scenario analysis to assess the impact of different business strategies on financial performance.

Junior Financial Analyst

Dunamis

11/05/2019 - 03/03/2021

Performed weekly bank reconciliations to ensure accurate records and identify any inconsistencies. led to an increase in revenue of 10% in 2021 by generating income statements and balance sheets half-yearly reports which identified key income inventory and unnecessary expenses. Developed a positive relationship between the different business stakeholders. Entered data, maintained records, and created reports. Collected, cleaned, and organized data from various sources to support decision-making and strategic planning Utilized the models to make informed decisions related to pricing, marketing, and other strategic initiatives. Engaged with stakeholders to gather requirements for data-driven projects. Defined relevant metrics to measure the success of initiatives and ensure alignment with business goals. Prepared clear and concise reports summarizing key findings from data analysis. Presented data-driven insights in a compelling and engaging manner to stakeholders. Facilitated discussions and workshops for data-driven adoption: Organized and led discussions and workshops to ensure stakeholders understand and embrace data-driven recommendations. Encouraged the adoption of data-driven approaches to decision-making throughout the company. Contributed to the development and implementation of effective sales strategies, resulting in a 20% increase in sales.

Skills

Python
90%
Excel
89%
SQL
90%
R programming language
89%
Data Analysis
88%
Machine Learning
88%
Powerbi
90%
Financial Analysis
94%
AWS Cloud
75%
Linux
75%
Blog and technical writing
97%