Humphrey Chapa

Humphrey Chapa

Analytics Manager, Pricing & Commercial Operations Team
Kenya
Swahili, English

About Me

Expert Analytics/Data Engineering Manager and Business Performance bringing 10+ years of expertise in Business Analytics and data visualization driving organizational data driven decisions. Effectively manages assignment…

Experience

Analytics Manager, Pricing & Commercial Team

Copia Global
Jun 2022 - Present · 4 years 1 month

• Building ML models for various organization goals such Credit Data Models, Fraud Models, Customer Segmentation, Price Elasticity using Python & R.
• Leading Pricing at Copia Global (about, Market Price Data Analysis automation in R and Python: Involves Web Scraping, Sheets reading, Scripting & Analysis, & Dumping & Visualization through Tableau Server by Product and Regions - aimed for monitoring of competitiveness with the general markets
• Partnered with relevant departments to develop strategic monthly and quarterly plans at the product level
• Contributed to the development of Marketing initiatives; Support new ventures with sales, margin and inventory analysis
• Identified and validated sales and margin growth and inventory productivity opportunities for monthly and quarterly strategic plans
• Guided the procurement and merchandising teams utilizing historical data, current trends, and socio/economic information to capitalize on new opportunities and identify risks
• Supported in completion and analysis for the monthly management presentations
• Developed Demand Sales plans, in coordination with the promo calendar to ensure the business is set - up to meet the Net Sales plan
• Communicated the Demand Sales Projections to the business, to ensure proper planning for key, upcoming Sales Initiatives
• Team management of 34 Pricing Field Officers, of whom 3 are Team Leads, and are headed by 1 Pricing Analyst
• Involved in approvals of allowances/stipends, management of data collection and data quality of market intelligence information gathered from various regions across Copia's operational regions - Drives pricing discourse and strategies
• Recruited & On-boarded of new Pricing Field Officers
• Involved in optimization of regional coverage by region, and by specified routes which facilitated pricing strategies coverage by agent & consumer population
• Supported all projects touching on Pricing to drive profitability
• Market route mapping and pricing strategy implementation
• Collaborated with team members to achieve target results.
• Created plans and communicated deadlines to complete projects on time.
• Exceeded goals through effective prioritization and consistent work ethic.
• Enhanced working relationships by participating in team-building activities.

Senior CVM Business Analyst- Consumer Business

Safaricom PLC | Nairobi, Kenya
Jun 2019 - May 2022 · 2 years 11 months

CVM Campaign analysis and business analytics.
Credit Data analysis to enhance credit products portfolio.
Liaised between business system users and the information technology team in creating automated business solutions.
Responsible for gathering, detailing and documenting business requirements in a format useful to business end users and technical developers.
Proposed ways in which existing processes and systems can be used or changed to meet new business requirements and identify new systems needed to meet business requirements within the context of a well-established Enterprise IT Architecture.
Cooperated with project partners to develop system analysis and new system design based on client specifications.
Conducted root cause analysis to formulate countermeasures to business mistakes and improve operations.
Liaised between operational and engineering teams to coordinate successful business improvement projects.
Presented advanced business cases, ROI models and change management programmes to senior stakeholders to inform decision-making and help brainstorm future strategies.
Delivered clear, actionable observations and offered targeted recommendations for business improvement.
Leveraged client data and available insights to improve alignment of business priorities and utilisation of resources.
Collaborated with business and IT groups to establish short-term and long-term goals.
Translated business requirements into high-level conceptual design to meet programme performance, usability and scalability criteria.
Elicited stakeholder feedback and collaboration to apply to analysing business data.
Streamlined business processes to reduce operating costs.
Collected, tracked and evaluated current business and data to stay abreast with market trends.
Coordinated development and deployment of data-driven and salable data visualizations.

Senior BI Analyst

Copia Kenya
Jan 2018 - May 2019 · 1 year 4 months

Created dashboards using Tableau for business KPI and other key metrics analysis providing insights into the business to help in making informed decisions and future strategy.
Used analytics to identify customer future and current behavior to Finance, Procurement, Supply chain, Business Development and Customer Service.
Analyzed customer transaction data to inform key customer metrics such as churn and lifetime value and create effective marketing campaigns.
Worked with managers across the business to improve performance using data driven decision making.
Performed intensive data mining and analytics on customer analytics including acquisition, retention and churn.
Contacted market intelligence analysis on competitor pricing.
Tracked and monitored top company products to ensure effective pricing to avoid under or over pricing depending on market prices.
Supported product margins reporting and analysis.
Supported products pricing analysis across selected markets.
Analyzed operational improvements against KPIs to measure progress.
Coordinated development and deployment of data-driven and salable data visualizations.
Translated business requirements into high-level conceptual design to meet programme performance, usability and scalability criteria.
Presented advanced business cases, ROI models and change management programmes to senior stakeholders to inform decision-making and help brainstorm future strategies.
Collected, tracked and evaluated current business and data to stay abreast with market trends.
Built reporting suite and associated tools for delivering comprehensive data for different needs.
Leveraged client data and available insights to improve alignment of business priorities and utilization of resources.
Delivered clear, actionable observations and offered targeted recommendations for business improvement.

Head- Business Intelligence

Little Ride
May 2016 - Dec 2017 · 1 year 7 months

Led BI implementation at Little, a taxi hailing company.
Defined business KPI metrics and tracked them across functions producing regular data reports and dashboards to inform decision making.
Implemented reporting, analytics and data warehousing across Commercial, Operations, Customer Service, Marketing and Finance by creating business insights and developed all required reports.
Led initiatives to drive customer acquisitions, analysis, usage, retention and churn using Tableau.
Drove organisational improvements in customer satisfaction scores and key metrics impacting revenue and profitability.
Used Fire Base and Google Analytics.

Business Intelligence Analyst

Airtel Kenya | Nairobi, Kenya
May 2015 - Jun 2016 · 1 year 1 month

Prepared reports to track daily performance of channel partners and Voice team on all Voice KPIs.
Computed Voice commissions and incentives for Channel and Voice team.
Effected changes on BTS Geography master database including new site, team and CP changes in the database.
Monitored data validity on the War Room Analytics Tool to ensure accuracy of the reports on this tool to bring greater business visibility and insight to internal stakeholders.
Provided functional administration of all the data warehouse components (Voice) thus facilitating the availing of reports and requested dashes.
Provided historical, current and predictive views of business operations using data gathered into a data warehouse or a data mart and occasionally working from operational data.
Processed and reported remunerations and bonuses of Voice KPIs and YU business to the respective HODs.
Analyzed, simulated and accounted for trends and gaps in data provided and advised the business accordingly.
Developed new Voice reports in line with reporting and business requirements and ensured timely submission and accuracy of standard daily, weekly and monthly Voice reports as well as ad hoc reports for S & D.
Handled sales and Distribution ad hoc requests on Voice and ongoing promotions.
Developed new Voice reports from Cognos BI System as requested by business by running SQL queries to customize reports.
Handled revenue analysis, sales analysis, sales team KPI performance tracking and monitoring.

Business Intelligence/Applications Support

Airtel Africa | Nairobi
Jan 2013 - May 2015 · 2 years 4 months

Supported various Airtel Africa projects.
Supported the Airtel Pretups E-recharge system for six Opcos: Kenya, Uganda, Tanzania, Malawi, Seychelles, and Madagascar.
Engaged with the different project stakeholders to ensure faultless and uptime of the Pretups E-Recharge system.
Implemented the required system configurations on the AIX platform and Oracle database.
Tracked KPIs for various applications, CEP analysis, and monthly reporting on top ten services for 17 Opcos.
Prepared daily transaction reports for circulation to the managers.
Executed different application scripts to perform various tasks.
Scheduled cronjob scripts to run repetitive application tasks at specific times and dates.
Automated sending of PreTUPS data to the FMS server for easier reporting.
Checked different logs such as transaction logs, event logs, channel request logs to cross check that transactions are going through as per the requirements and data is sent to the customers.

Analytics Manager, Pricing & Commercial Operations Team

Copia Global
Jun 2022

Building ML models for various organization goals such Credit Data Models, Fraud Models, Customer Segmentation, Price Elasticity using Python & R.
Leading Pricing at Copia Global with market price data analysis automation in R and Python.
Involves Web Scraping, Sheets reading, Scripting & Analysis, and Dumping & Visualization through Tableau Server by Product and Regions.
Aimed for monitoring of competitiveness with the general markets.
Partnered with relevant departments to develop strategic monthly and quarterly plans at the product level.
Contributed to the development of Marketing initiatives.
Supported new ventures with sales, margin and inventory analysis.
Identified and validated sales and margin growth and inventory productivity opportunities for monthly and quarterly strategic plans.
Guided the procurement and merchandising teams utilizing historical data, current trends, and socio/economic information to capitalize on new opportunities and identify risks.
Supported in completion and analysis for the monthly management presentations.
Developed Demand Sales plans, in coordination with the promo calendar to ensure the business is set up to meet the Net Sales plan.
Communicated the Demand Sales Projections to the business to ensure proper planning for key, upcoming Sales Initiatives.
Team management of 34 Pricing Field Officers, of whom 3 are Team Leads, and are headed by 1 Pricing Analyst.
Involved in approvals of allowances/stipends, management of data collection and data quality of market intelligence information gathered from various regions across Copia's operational regions.
Drives pricing discourse and strategies.
Recruited and on-boarded new Pricing Field Officers.
Involved in optimization of regional coverage by region and by specified routes which facilitated pricing strategies coverage by agent and consumer population.
Supported all projects touching on Pricing to drive profitability.
Market route mapping and pricing strategy implementation.
Collaborated with team members to achieve target results.
Created plans and communicated deadlines to complete projects on time.
Exceeded goals through effective prioritization and consistent work ethic.
Enhanced working relationships by participating in team-building activities.

Skills

Python SQL Database Data Warehouse Machine Learning Algorithms Team Management Tableau Data Analytics Data Modelling Data Warehousing Insights generation Project delivery Team supervision GCP Looker Power BI AWS Redshift Google BigQuery Web Scraping Sheets reading Scripting Analysis Visualization Google Analytics Firebase SQL Cognos BI AIX Oracle database Cron jobs Automation Business Analytics Data Visualization Business Intelligence Data Mining Reporting Dashboards KPI tracking Root cause analysis Business requirements gathering System analysis Change management ROI modeling Stakeholder management Team management
Report this Profile?