Joshua Olugbenga Okedoyin

OKEDOYIN JOSHUA OLUGBENGA, M.Sc. Address: Aylesbury - Open to locations across the UK Contact:-|- LinkedIn: https://www.linkedin.com/in/joshua-okedoyin- PROFILE SUMMARY Results-driven Data Analyst with over 2 years of professional experience specializing in developing interactive dashboards, performing data analysis, and delivering actionable insights. Adept at leveraging tools such as Power BI, SQL, and Excel to optimize business performance across Retail, Sales, Marketing, and Supply Chain sectors. Key strengths include: Advanced data visualization and storytelling for business strategy formulation. Expertise in creating interactive dashboards, KPIs, and custom visuals for informed decision-making. Proficiency in extracting, transforming, and analysing data to uncover trends and actionable insights. CORE SKILLS • • • • • • • BI Tools/Technologies: Microsoft Power BI, Excel (Advanced), SQL Server 2023/24 Data Analysis & Visualization: DAX, Power Query, ETL Processes, KPI Scorecards Programming & Databases: SQL, T-SQL Key Strengths: Sales & Inventory Analytics, Dashboard Design, Data Modeling. Excellent team-player, stakeholder and change control management skills Collaboration and effective communication verbally and in writing. Significant problem-solving skills including diagnosis, troubleshooting and resolution. PROFESSIONAL EXPERIENCE Trading Assistant – Retail Sales | Sainsbury’s Supermarket Ltd (Nov 2023 – Present) • Collaborate with team members to ensure seamless operations and deliver exceptional service across all Sainsbury's brands. • Analyse sales trends and inventory data using tools like Excel, Power BI, and SQL to provide actionable insights for decision-making. • Prepare and present detailed sales and stock reports, monitoring inventory levels to optimize stock management and sales performance. • Develop dashboards and real-time reporting tools to track KPIs such as sales growth and replenishment cycles. • Conduct product performance analysis, aligning inventory with demand forecasts to improve retail strategies. • Maintain data accuracy, ensuring compliance with safety and reporting standards. Intern (Work Experience), Business Intelligence | Clap Academy UK (Sept 2024 – Present) • Assists in identifying data quality issues and extracting actionable insights using SQL, Power BI, and Excel. • Designs dynamic dashboards to communicate organizational and client-focused insights. • Supports senior analysts in data pipeline maintenance and the development of scalable BI solutions. • Performs data validation and testing to ensure report accuracy before deployment. Business Development/Data Analyst | Conoil Plc (Nov 2020 – Oct 2023) • Created detailed Power BI dashboards for sales performance and revenue analysis across retail locations. • Implemented DAX measures for dynamic calculations, enhancing reporting capabilities. • Conducted market research and competitive analysis to identify business opportunities, using datadriven insights to support strategic planning. • Built financial and performance models in Excel to evaluate potential partnerships, revenue streams, and market expansion plans. • Developed Power BI dashboards to visualize key business development KPIs such as revenue growth, customer acquisition, and profitability trends. • Collaborated with sales and marketing teams to align data insights with promotional strategies, improving lead conversion rates by 15%. • Designed and automated reports to track the effectiveness of business initiatives, using SQL queries to extract and clean data from multiple sources. • Supported senior management with ad-hoc analyses and presentations, helping drive decisions on market penetration strategies and pricing models. • Shared insights with management to guide product supply strategies and pricing decisions. Retail Sales Business/Data Analyst | MRS Oil Nig. Plc (Apr 2011 – Oct 2020) • Developed and maintained interactive dashboards displaying sales trends and key performance metrics. • Analysed retail sales data to identify trends, assess market performance, and optimize inventory allocation, ensuring alignment with demand patterns. • Created sales forecasts using historical data and statistical models, enabling accurate stock replenishment and reduced overstocking costs by 10%. • Built dashboards to monitor daily, weekly, and monthly sales performance, tracking KPIs such as sales volume, revenue per store, and customer retention rates. • Performed geospatial analysis of retail locations to identify underperforming outlets and recommended strategies to enhance their sales potential. • Collaborated with IT to automate the data ingestion process from SAP and FINAS systems, improving reporting efficiency by 20%. • Assisted in developing pricing strategies based on elasticity models and market trends, contributing to a 5% revenue increase in key product lines. • Utilized statistical techniques and competitive intelligence to forecast sales performance and drive strategy. • Partnered with teams across sales, marketing, and finance to align data insights with business goals. KEY PROJECTS Sales Performance Analysis | Sainsbury’s Supermarket Ltd • Designed and implemented sales and inventory dashboards using Power BI to provide real-time visibility into sales trends and stock levels. • Conducted in-depth product performance analysis to align inventory with customer demand, minimizing stockouts and improving customer satisfaction. • Automated reporting workflows, reducing manual report generation time by 40% and enabling timely decision-making by stakeholders Weekly/Monthly Sales Reports | Conoil Plc • Automated data extraction and transformation processes using SQL, streamlining the preparation of weekly and monthly sales reports for senior management. • Built Power BI dashboards to visualize regional sales performance and highlight trends, enabling focused decision-making across retail stations. • Conducted profitability analysis to identify underperforming retail locations and recommended operational adjustments, improving profit margins by 12%. • Integrated external market data into dashboards to provide context for sales performance, enhancing the strategic relevance of insights delivered to stakeholders. • Designed interactive reports tailored to executive decision-making needs. Sales Metrics Dashboard | MRS Oil Nig. Plc • Delivered advanced Power BI dashboards showcasing KPIs such as revenue per customer, sales velocity, and market share, empowering management with actionable insights. • Developed predictive models using historical data to forecast monthly sales volumes, improving resource allocation for high-demand periods. • Enhanced customer segmentation analysis using clustering techniques, allowing targeted promotional strategies that increased average sales per customer by 15%. • Partnered with the marketing team to incorporate competitive intelligence into reporting, supporting data-backed pricing and promotional strategies. EDUCATIONAL QUALIFICATIONS ● ● ● M.Sc., Marine Pollution & Management | [University of Lagos, Nigeria] B.Sc., Marine Biology | [University of Lagos, Nigeria] Professional Certifications: ✓ Business Analysis (CPD) ✓ SQL - Data Analysis (CPE) ✓ Power BI Desktop (CPE) ✓ Third-Party Risk Management, Privacy Management, and Tech Risk Management (CPE) LINKS TO POWER BI & EXCEL PROJECTS ● ● ● ● ● ● ● ● University Students’ Mental Health Project Maven Market Topline Performance Adventure2022 Sales Report A Comprehensive and Interactive View Of Jochi Electronics Company's Sales Data (2011 - 2014) Palmoria Group Analysis on Gender Equality Maven Toy Store KPI Report (Mexico) UK Train Ride Coffee Shop Sales-Project - Personal.xlsx