Paul Aidelokhai is efficient Data Analyst and BI Analyst offering a unique Data Analytics and Accounting perspective to analyse datasets to identify patterns and trends within datasets and present actionable insights to stakeholders. Proficient in developing data models to assess business performance and predict future trends, implementing data-driven strategies to debug, optimise, and monitor critical business metrics to generate insights for strategic planning.
Skilled in gathering data requirements, developing interactive dashboards and reports for operational functions, and monitoring and troubleshooting data-related issues to maintain data integrity. Experienced in demand forecasting, inventory management, and supply chain optimisation to enhance efficiency and reduce costs by identifying opportunities, uncovering actionable insights that provide a competitive edge, mitigating risks, and driving innovation, ensuring sustained growth and better alignment with industry demands.
• Integrated 5 disparate data sources into a unified platform using ETL pipelines, reducing data inconsistency issues and boosting data processing speed using optimised SQL scripts and cloud computing.
• Designed, implemented, and maintained a relational database system to store and manage over 750,000 records, reducing query execution time through index optimisation and partitioning strategies.
• Developed a dynamic customer segmentation model that identified 3 high-value customer groups, enabling personalised marketing campaigns that increased engagement rates by 15% and reduced churn rates.
• Spearheaded a process optimisation project for a team of 20+ staff, eliminating redundant manual workflows, which reduced task completion time, enabling real-time tracking and improved staff productivity.
