Essential Data backpack

▪The Doraleh Container Terminal, a container terminal for the handling of container transported products has been using Excel for reporting purposes.
designed, developed and implemented reporting solutions using Qlik Sense to visualize relevant information about the operations and commercial activities summarized into one integrated view.
automated data transformation tasks for operations reports using Excel VBA. 

▪A PAYG solar water pumps company has implemented the application network across different departments to assure data consistency across systems. To extract the operational data, designed and deployed Extract Load Transform (ETL) pipelines.

Data Consultant

Easy Solar

Easy Solar is a pay-as-you-go solar distribution company operating in Sierra Leone and Liberia.
• Working with the data team to upgrade and maintain existing data systems (data pipelines) to improve the org data capabilities;
• Working with the tech team and the business to improve existing dimensional models and acquire new data sources / datasets that align with the business needs;
• Implementing methods and internal processes to improve data reliability and quality;
• Setting up some internal processes to improve the data engineering workflow;

Simusolar, Inc.

Simusolar is a distributor and financier of solar-powered equipment such as water pumps and fishing lights.
•	Collaborated on design and implementation of the loan management and ticketing systems that was previously run on AWS Cloud, costing about 4 times the current solution.
•	Analyzed ways of loading the existing data into a format suitable for the new environment; performed field mapping between 4 systems; prepared transformation rules for data migration; conducted actual migration with REST API and database-to-database migration); performed post-migration data testing and ongoing data validation and data quality assurance.
•	Designed Extract Load Transform (ETL) pipelines  to facilitate the extraction and processing of data from the newly implemented applications and developed KPI dashboards and operational reports to provide visibility into the performance of different functions,

IPC - Internationale Projekt Consult GmbH

IPC - Internationale Projekt Consult GmbH offers energy and financial solutions to international financial institutions and development agencies.
•	Preparation of an e-learning course on data literacy for the Regional Small Business Programme – RSBP – for Central Asia to introduce the standard process for data analytics project planning with 62 people registered for the course.
•	Requirements gathering for a credit portfolio monitoring tool to automate standard reports; the tool customization to meet additional reporting requirements; training of end-users on the tool across several companies.
•	Collaborated on the design and implementation of an Applicant Tracking System (ATS); process mapping and requirements gathering for the ATS; migrating of more than 1,000 text files to the ATS format; manual testing for data validation; creating an API integration between the ATS, SharePoint and  Office 365 to facilitate the data transfer between systems.

External Consultant

enable.digital

Enable offers flexible, future-proof, digital technology and data management solutions to clients in emerging markets.
•	Participated in the data management assessment to evaluate existing data management practices, needs and resources across clients, and recommendation preparation for improvement.
•	Supported digital transformation projects with managing end-to-end data migration which included migration planning, legacy data assessment, system mapping, building and testing of migration code, migration outcome testing, and post-migration data quality assurance.
•	Deployed, monitored, and maintained BI infrastructure across enable's customers which included setting up (1) ETL to extract data from the existing databases and Software as a service (SaaS), (2) data warehouse and operational data store, (3) end-user / BI/ dashboarding tools, and (4) metadata layers.

PEGAfrica

PEG delivers Pay-As-You-Go asset-based financing to consumers who lack both access to reliable electricity and formal banking services.
•	Developed zonning dashboards/app based on the internal sales and credit performance and publicly accessed electrification and socio-economic data and crop calendars to decrease customer acquisition cost.
•	Automated data transformation tasks performed by the data team. 
•	Guided the organization (Data & Analtyics department) on matters related to data management, quality and analysis with supervisory responsibilities for all staff assigned to the Data (Business Intelligence) department.

PwC Mexico

•	Developed first of their kind healthcare quality indicators and interactive dashboards based on internal insurance claims data and external data to evaluate the nationwide quality of medical procedures in hospitals across Mexico and improve industry transparency.
•	Analyzed invoice-specific datasets and participated in the development of interactive dashboards for an electronic invoice solutions provider to improve the value of the client service offerings.
•	Created a market sizing dashboard based on open datasets ranging from population, industry and economy growth rates, house depreciation, the industry participant market share, among others, to identify market potentials for a real estate company.

Senior Consultant, Data & Analytics

▪ Conducted trend identification and market analysis of open socio-economic and industry-specific datasets to support internal PwC practitioners in their engagements.
▪ Updated and audited knowledge repository content to make sure shared information is adherent to the internal guidelines.

Senior Consultant, Knowledge Cente

▪ Undertook internally commissioned desk research, including a literature review of existing research and analysis of publicly available datasets; 
▪ Performed market trend analysis and its interpretation; 
▪oversaw and contributed to PwC's territory knowledge management activities.

Analyst, Knowledge Center

Webware.io

▪ Assisted in development and execution of online marketing strategies; 
▪ Responsible for generating weekly campaign performance reports and ensuring their timely delivery to clients.

Internship, Digital Analyst

Atma - An Accelerator for Education

▪ Managed online marketing campaign operations and analytics, including paid search campaign design, implementation, tracking, reporting, analysis, and optimization.

Volunteershp, Digital Analyst

Mosaic Network (India) Pvt. Ltd.

▪ Responsible for providing information on the education and training sector and generating insights about online marketing campaign effectiveness.

Hey there, I'm Eka — a data enthusiast on a mission to empower small to medium-sized businesses in Sub-Saharan Africa that focus on essential products and services. For the last six years, I've been living on the go, specializing in kickstarting projects from the ground up, particularly greenfield initiatives.


Think of me as your data travel companion, advocating for the 'essential data backpack' philosophy. It's about carrying what truly matters for your business — no unnecessary baggage.


My focus goes beyond just data; it's about enabling collaboration with interdependent data practices, providing hands-on training, and offering support even after implementation.


If you're a startup beginning your data journey, let's connect to get started on your project! I'm here to help you navigate the data landscape, turning challenges into opportunities for sustainable growth.

Taplio

Eka Ponkratova's Linkedin Analytics

Eka Ponkratova

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Eka Ponkratova's Linkedin Analytics

Eka Ponkratova

Want to drive more opportunities from LinkedIn?

Eka Ponkratova's Linkedin Analytics