Id Ojo Email & Phone Number

Birmingham, Gb

United Kingdom

Leicester, England, United Kingdom

Role Summary:• Senior marketing analyst responsible for creating and translating data-driven insight into CRM, Loyalty, Acquisition, and Retention activities to help drive clients' marketing performance across physical and digital channels.Key Achievements:• Developed SQL stored procedures, SQL-linked Excel pivots, and VBA macros that significantly reduced the errors and time required for repetitive tasks and complex reportgeneration.• Created a detailed Power BI dashboard to visualize the department’s time utilization across different accounts and tasks which helped efficiently manage workload assignments and aided client invoicing.• Conducted exploratory ETL and analysis of potential new client data, presenting insights in visually appealing decks. Led the onboarding process, including development ofsegmentations, campaign strategies, and performance forecasting/reporting templates.Tasks:• Data Analytics | Market Analytics | Modelling | Segmentation | Campaign Management | A/B Testing | Database Management | SQL Code Development | Process Automation | Reporting | Presentation | Dashboard Creation

Role Summary:• Senior data analyst performing dual roles and reporting to the CEO and CCO, responsible for analyzing customer and market data and reporting profitability and revenue performance. Also responsible for pricing and inventory management as well as executing commercial projects /events.Key Achievements:• Determined the basket size thresholds needed to qualify for free shipping. This helped grow average order values while maintaining profitability in target locations.• Identified and implemented 5 key actions that helped improve profitability by analyzing the business performance in unit economics. These actions targeted specific categories, locations, sizes, and cart combinations that impacted profit significantly.• Developed PowerBI dashboards that helped account managers and commercial analysts quickly identify opportunities and deep-dive into the reason for poor performance up to the SKU level.Tasks:• Budgeting | Planning | Operations Excellence | Performance Steering | Reporting | AB Testing | Project execution | Pricing Analysis | Inventory Management | Stakeholder management

Lagos, Nigeria

Role Summary:• Revenue Planning and Business Analyst lead for the commercial unit responsible for translating commercial and customer data into business decisions. Also responsible for market research, financial reporting and forecasting as well as KPI target dimensioning.Key Achievements:• Defined customized location based voice/data/device pricing strategy by profiling usage and device spread of the customers within each location.• Planned the deployment of recharge distribution centers and warehouses within every 50km grid using spatial analysis and historical sales data. This ensured optimal product availability and distribution.• Developed a commission structure that guaranteed recharge availability at the recommended pricing at remote low-revenue sites which led to combined net revenue growth of 22% at these locations.Tasks:• Revenue Forecasting | Trend Analysis and Performance Monitoring | Market Analysis | Risk Analysis | Data Mining | Data Analysis | Reporting | Market Research | Presentation

Nigeria

Role Summary:• GIS and Customer Data analyst responsible for analyzing data from a geographical, chronological and customer perspective. Identify trends based on customer insights and create segments to extract more value. Provide detailed spatial analysis and map representations of the businessfootprint.Key Achievements:• Used customer usage and location analysis to identify towns with good potential for 4G. This aided quick ROI after deployment and contributed significantly to growing data revenue by 70% in FY19.• Designed dimensioning guidelines that helped with the rapid rollout of 400 retail shops with a focus on population, spend power, travel time, and demographic patterns.• Created sales cluster boundaries to track and monitor the performance of the sales team with a focus on recharge selling outlet, beat map for outlet visits, customer acquisition and revenue performance. This helped to drive execution and grow customer acquisition by 30%Tasks:• Data Analytics | Spatial Analytics | GIS Analysis | Root Cause Analysis | Consumer Profiling | Segmentation | CLV Management | Prediction | Mapping | Reporting and Presentation

Lagos

• 2G/3G/LTE Coverage Planning for Airtel Nigeria• KPI validation for new/modernized sites to ensure sites are integrated according to design and meeting agreed KPI requirements.• Redesigning existing sites to enhance coverage/capacity/quality with added focus on Airtel Nigeria's top 15 cities• Coverage prediction, forecasting and analysis.• CAPEX & OPEX Optimization initiatives to enhance low coverage sites Revenue • Regularly provide Finance, Performance, Regulatory, Marketing and Technical reports to support business needs.• Project Management and reporting.• Coverage complaints resolution.• Database management.

Nigeria

• Radio Network Planning and Optimization for CDMA /EVDO and GSM 2G networks.• LAC, Frequency/PN, Neighbor, Coverage and other network parameter planning and tuning using various planning tools including Huawei Naster, OMstar, MapInfo and Easy RNP.• GSM and CDMA/EVDO drives test and logs file analysis using Ding Li Pioneer/Navigator, Ericsson Tems and Genex Probe/Assistant softwares.• In depth performance data analysis utilizing data from iManager M2000 & LMT.• Parameter tuning, KPI (CSSR, HOSR, DRC) management/maintenance and optimization of Top-N cells.• Plan, Implement and Manage the RF aspects of turnkey projects.• Interface with client and customers for project delivery, fault resolution and performance management.

Lagos, Nigeria

• Carrying out detailed radio link surveys in regions within the company’s implementation map. • Installation, Integration and Commissioning of ipNX base stations on various platforms (WiMax and OFDM)• Establishing and managing end-to-end connectivity for banks and• corporate bodies (using GRE and IPSec Tunnels and MPLS).• Implementing, managing and troubleshooting VoIP related problems on Cisco Call Managers and Voice Gateways• Configuring of Cisco switches and routers running various protocols (BGP, OSPF, EIGRP) • Configuration and Maintenance of several core servers. • Remote and Onsite support for corporate clients.