Zakaria Kanyi Kamweru

Data Analyst

Kinship

Dec 2023 - Current (1 year 9 months)

• Migration of business KPIs and dashboards from Looker to Tableau • Migration of SQL database views from Google big query to redshift • Creation of new business logic and rules for new reports in Tableau

Q

Business Intelligence Analyst

Qogita

Feb 2022 - May 2023 (1 year 4 months)

• Conversion of business and data reporting requirements into reports and visualizations. mainly in Looker. • Maintenance of BI reports to match changes in business processes • Design and maintain ETLs using fivetran, airbyte and DBT • Implement and maintain user analytics pipelines and data via Segment

Data Analyst

Thrive Market

Jul 2021 - Jul 2022 (1 year 1 month)

• Conversion of business and data reporting requirements into reports and visualizations. Primarily in Tableau and Domo • Maintenance of Tableau reports to match changes in business processes. • Report migration from Tableau to Domo. • SQL script migration from Redshift to Snowflake. • Troubleshooting of Airflow DAGs in case of errors in reporting. • Product user analysis and AB testing via amplitude and Optimizely.

Data Analytics Contractor

Andela

Apr 2021 - Current (4 years 5 months)

I work as a retained contractor for Andela, but seconded to clients on projects as and when they arise

L

Data Analytics Consultant

Longhorn Publishers

Mar 2020 - Apr 2020 (2 months)

• Defined reporting KPIs and metrics for the e-learning platform. • Identified data sources to feed into the e-learning reporting platform. • Created data pipelines from data sources to the e-learning platform. • Interpreted data to management. Management's overall aim was to increase users and revenue. • Created visualizations using an open-source Business Intelligence (BI) tool.

S

Data Analytics Consultant

SafeBoda

Mar 2019 - Jul 2020 (1 year 5 months)

• Principal analyst and business advisor for the launch of SafeBoda (SB) Food in Kampala and Nairobi. • Reviewed process flows and established their suitability to meet SB Food reporting needs. • Designed and created SB Food KPIs and metrics from scratch. • Defined and implemented rules to detect and deflect fraud in SafeBoda operations. • Reviewed data processes and flows of SafeBoda rides in Uganda and Kenya. • Performed market place and churn analysis. • Advised Founders and C-level on business directions and decisions, such as the closure of Mombasa operations. • Worked with data architecture teams in Kenya and Uganda to define business rules of the data solutions for 2 developing areas – SafeBoda Mombasa and SafeBoda Food Ugand

P

Data Analytics Consultant

Pezesha Africa

May 2018 - Feb 2019 (10 months)

• Reviewed existing data and data-process flows. • Created and fine-tuned credit scoring and business rules engines. • Implemented analytics and Business Intelligence (BI) frameworks. • Generated data visualizations and made quarterly presentations on performance of the mobile lending business to the Board of Directors. • Trained Pezesha's team of data end-users for knowledge hand-over and future framework iterations. • Advised the C.E.O. on data sources for alternative credit scoring as well as strategy on partnerships with other companies. • Advised the C.E.O. on the applicability of data science buzzwords and their use cases i.e. Artificial Intelligence and Machine Learning. • Managed a cross-functional team of data engineers and

4

Data Analytics Consultantand Single Point of Contact (SPOC)

4C Group of

Oct 2017 - Oct 2018 (1 year 1 month)

• Managed, coordinated and delivered the implementation of Insight Analytics Suite. • Identified and designed scope and KPIs for reporting, monitoring and reconciliation. • Designed and created tools and dashboards used by Telkom Kenya to visualize and report on mobile money activities. • Ensured smooth work flow between the back-end developers in Cape Town and the users in Telkom Kenya and Cape Town.

V

Manager, Revenue Assurance

Vodacom Tanzania

Oct 2013 - Sep 2017 (4 years)

• I was the technical lead on the tools, controls, tests and checks of the Revenue Assurance (RA) department, with which I produced information for the organization's data-driven decisions. • SPOC for implementation, monitoring and fine-tuning of insight tool implementation by 4cGroup. This is a revenue and fraud monitoring tool that collects and aggregates data from various sources. • Created a custom-made Anti-Money Laundering (AML) and Fraud Monitoring (FM) alerting tool using Oracle backend and Bash Scripts. • Spearheaded the RA department's controls, tests and checks during the migration of mobile money from 1st generation to 2nd generation servers. Created a custom-made module replication M-pesa migration data and business rules u

S

Principal Revenue Assurance Analyst

Safaricom Kenya

May 2012 - Sep 2013 (1 year 5 months)

• I worked in collaboration with the Revenue Assurance (RA) Manager to provide the top management with a holistic view of the trends and movements in all streams of revenue and subscriber numbers. • Conceptualized, designed, developed, maintained and added new data collection flows to the Revenue Assurance Tool, RAID (Revenue Assurance Integrity Driller). This database contained up to 15 different data flows with tables of up to 200 million records per day. • Analyzed and interpreted data to check for revenue trends as well as possible revenue leakages. • Platform integrity – this involved performing activities to ensure that the subscriber profiles were synchronized across the various provisioning and billing system nodes across the ne

A

Revenue Assurance Analyst

Airtel Kenya

Aug 2010 - May 2012 (1 year 10 months)

• Acted as the Project Manager during the implementation of a FMS between Subex and Airtel Kenya, on UAT, evaluation of project milestones, and coordination of assignments and resources. • Reviewed m-commerce (Airtel Money) reconciliations performed by Stock Controller. • Reviewed m-commerce (Airtel Money) transactions versus AML value limits. • Checked adjustments and credits passed on TABS billing system, compared them with authorization documents, and confirmed that they were compliant with laid down process. • Periodically reconciled postpaid on HLR with the records on TABS. • Billing Assurance: Ensured the accuracy and completeness of bills for postpaid subscribers. • Re-rating: Performed re-rating of postpaid rate plans to ensu

Z

Revenue Assurance Analyst

Zaine

Dec 2006 - Aug 2010 (3 years 9 months)

• I was at the center of the team that implemented a new RA Tool (Onereview by Connectiva) • Continually queried and matched high volumes of data from IN, Switch, HLR, SMSC, Postpaid billing System and Oracle financials, and reconciled them to identify possible faults and anomalies in any of the systems • Prepared Scripts to audit IT systems on Oracle, ACL and UNIX (HP-UX and Solaris). • Reconciled roaming and interconnect revenue against data in the IT systems and investigated variances • Designed reconciliation processes that would establish checks on the IT systems on Roaming reconciliations

B

Business Intelligence Consultant

BRCK

• Extracted data from production systems into the BI platform. • Created baseline BI KPIs. • Reviewed the accuracy and completeness of data feeds and reports for quality assurance.

Zakaria Kanyi Kamweru

About

Detail

Timeline

Résumé