Zakaria

Demonstrated experience with SQL.

Demonstrated experience with Python.

Demonstrated experience with MySQL.

Demonstrated experience with PostgreSQL.

Demonstrated experience with SQL server.

Migration of SQL database views from Google BigQuery to Amazon Redshift., Migration of business KPIs and dashboards from Looker to Tableau, resulting in ease of visualizing daily sales by the Products team., Designing A/B tests to establish market relevance of new products and services, done using Optimizely., With the regular launch of new products and services, I create new business logic and rules for additional reports in Tableau.

Designed and maintained ETLs using Fivetran, Airbyte and DBT., Implemented and maintained user analytics data and pipelines via Segment., Converted customer behaviour data and sales into reports and visualizations in Looker., Maintained BI reports to match changes in business processes., As the founding Data Analytics Engineer, I developed Standard Operating Procedures for the entire process of Data Handling in the business, including Quality Assurance and Data Documentation.

Migrated reports from Tableau to Domo, to support user self-service., Migrated SQL scripts from Redshift to Snowflake., Used Tableau and Domo to present and visualize reports that supported the Product, Marketing and Finance departments., Maintained Tableau reports to match changes in business processes., Maintained data quality by troubleshooting Airflow DAGs in case of errors in reporting., Conducted product user analysis and A/B testing via Amplitude and Optimizely.

I work as a retained contractor for Andela. I get seconded as a Data Analyst or Data Engineer to Andela’s clients on projects basis.

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., Participated in the C-line management’s weekly meetings to interpret data, which led to decisions – like an improved payment funnel – which led to an increase in users and revenue., Created visualizations using Metabase open-source Business Intelligence (BI) tool., Built lakehouse data model using Databricks Delta Live Tables, enabling real-time analytics., Led ETL migration to Databricks medallion architecture., Developed production ML pipeline using MLflow and AutoML for churn prediction., Implemented analytics infrastructure with Databricks Workflows and Unity Catalog, enabling cross-regional self-service analytics.

I served as the 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 analysis and churn analysis., Collaborated 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 Uganda., Performed regular quality assurance of the integrity of data from all sources., Created visualizations using Metabase and Power BI., On-boarded, managed and mentored 2 data analysts., Advised founders and C-level management on business directions and decisions, such as the closure of Mombasa operations.

Reviewed existing data and data-process flows., Created and fine-tuned credit scoring and business rules engines after analyzing alternative data points., Implemented Camunda scoring and decisioning framework., 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 junior data scientists during the building of a lending decisioning framework.

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 collaborative flow between the back-end developers in Cape Town and the users in Telkom Kenya and Cape Town.

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.

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 business’s data-driven decisions, which included advising the business on risks around revenue generation as well as failures in systems integrity and fraud management., Was the SPOC for implementation, monitoring and fine-tuning of Insight Tool by 4C Group, 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, that is in use to-date., 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 using PL/SQL and bash scripts, which was used to validate and detect errors during migration., M-pesa assurance: performed analytical activities on M-pesa data and used the ensuing information to advise the business on opportunities and new processes tweaks., Analyzed, reviewed and monitored all RA reports and KPIs and provided updates to the weekly management meeting on revenue trends., Provided guidance and supervision to the RA team to ensure that revenue assurance controls were executed., Conceptualized and developed new reports and interfaces on RA and FM tools., Managed and coordinated RA and FM projects, and interfaced with other business units to ensure that controls were implemented in new products and services., Managed and mentored a team of 5 data analysts.

Worked in collaboration with the Revenue Assurance (RA) Manager to provide the top management with a weekly, 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 network., Prepay and Postpay Voice Switch to Bill reconciliation: I did daily record matching of raw and aggregated records to ensure that network usage of minutes matches with daily billed minutes. This provided assurance of revenue worth approximately USD 3.5 million per day.

Acted as the Project Manager during the implementation of a Fraud Management System (FMS) between Subex and Airtel Kenya, on User Acceptance (UATs), 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 the business’s billing system - TABS, 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 ensure accuracy., Analyzed dumps from network nodes to ensure correctness and conformity to business rules.

I was part 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.