About Me
I am a detailed-oriented and personable Data Analyst with a foundation in mathematics and Statistics. My work ethic is marked by diligence and a comprehensive understanding of technology, finance, and data analytics. Cur…
I am a detailed-oriented and personable Data Analyst with a foundation in mathematics and Statistics. My work ethic is marked by diligence and a comprehensive understanding of technology, finance, and data analytics. Currently, I excel as a Data Analyst Intern at Pernod Ricard Eastern Africa, collaborating closely with the financial and commercial teams. In this role, I drive problem-solving initiatives and contribute to the organization's progress.
My technical expertise includes data manipulation and report generation in Power BI and Pyramid by Data-Orbis, SQL for data querying and manipulation, Tableau for Visualization and Excel proficiency in data cleaning, quality assessment and pivot tables. I am committed to leveraging my skills to deliver impactful insights and data driven decisions.
Experience
Data Analyst
1.Building market intelligence by standardizing distributor sales reports from the Kenyan, East African and Indian Ocean Islands market which qualitatively helps the stakeholders in effective decision making.
2.Generating Convivio Reports (CRM system) on qualitative measures (presence, visibility and activations) and going on trade visits with the sales representatives which contributes to up to 50% of their sales incentive scheme.
3.Maintain the business data assets, including reports, dashboards in order to streamline the workflow.
4.Perform Ad hoc and urgent analysis when needed in collaboration with stakeholders.
5.Confirming that the data loaded from our ERP system into our data visualization and report generating systems is 100% accurate to ensure maximum reliability of our reports.
6.Preparation and generation of Daily sales reports to ensure efficiency and effectiveness in decisions made by the marketing and sales departments.
7.Preparation of weekly sales reports for commercial managers that contributes majorly in distributor and market channel performance tracking.
8.Insight generation by providing recommendations based on reports I extracted from Pyramid /Data-Orbis which improves the quality of decisions made by our marketing stakeholders.
Data analysis intern
Building market intelligence by standardizing distributor sales reports from the Kenyan, East African and Indian Ocean Islands market which qualitatively helps the stakeholders in effective decision making.
Generating Convivio Reports (CRM system) on qualitative measures (presence, visibility and activations) and going on trade visits with the sales representatives which contributes to up to 50% of their sales incentive scheme.
Insight generation by providing recommendations based on reports I extracted from Pyramid /DataOrbis which improves the quality of decisions made by our marketing stakeholders.
Maintain the business data assets, including reports, dashboards in order to streamline the workflow.
Perform Ad hoc and urgent analysis when needed in collaboration with stakeholders.
Confirming that the data loaded from our ERP system into our data visualization and report generating systems is 100% accurate to ensure maximum reliability of our reports.
Preparation and generation of Daily sales reports to ensure efficiency and effectiveness in decisions made by the marketing and sales departments.
Preparation of weekly sales reports for commercial managers that contributes majorly in distributor and market channel performance tracking.
Data Analyst Intern
Performed data quality assessment on data from clients using excel, python and jupyter notebooks
which resulted in clean and complete data for further analysis.
Created a PowerPoint report on how we would come up with a model to target high value customers
based on customer demographics and attributes.
Developed Tableau dashboards that gave the clients an in-depth understanding of their customers
including the ones to target.
Data Analyst Intern
Performed data quality assessment on data from clients using excel, python and jupyter notebooks
which resulted in clean and complete data for further analysis.
Created a PowerPoint report on how we would come up with a model to target high value customers
based on customer demographics and attributes.
Developed Tableau dashboards that gave the clients an in-depth understanding of their customers
including the ones to target.
Data Analyst Intern
Performed data quality assessment on data from clients using excel, python and jupyter notebooks
which resulted in clean and complete data for further analysis.
Created a PowerPoint report on how we would come up with a model to target high value customers
based on customer demographics and attributes.
Developed Tableau dashboards that gave the clients an in-depth understanding of their customers
including the ones to target.
Data analytics intern
Performed data quality assessment on data from clients using excel, python and jupyter notebooks which resulted in clean and complete data for further analysis.
Created a PowerPoint report on how we would come up with a model to target high value customers based on customer demographics and attributes.
Developed Tableau dashboards that gave the clients an in-depth understanding of their customers including the ones to target.
IT Support
Used remote tools like Anydesk for maintenance and support of ICT systems which helped save time and cost of travel by almost 55%.
Created and trouble shoot company emails for users by configuring their credentials in the company’s mail server and the users were able to access their respective department emails.
Customized network solutions for stations in Amboseli, Ngong and Kajiado which resulted in better
network response time and reduced latencies.
Provided end-user support on technical issues covering PC hardware, printers, scanners, computer
peripherals, mobile devices and network connectivity by responding to phone and ticket requests for
services.
Lead and supported the IT attaches’ team in setting up network configurations and computer
hardware in relocated offices both at the headquarters and Nairobi National Park which allowed the
users to go back to their operations without delay.
Wrote reports that summarized our monthly tasks for the IT Head to keep track of how our office
was performing.
IT Support
Used remote tools like Anydesk for maintenance and support of ICT systems which helped save time and cost of travel by almost 55%.
Created and trouble shoot company emails for users by configuring their credentials in the company’s mail server and the users were able to access their respective department emails.
Customized network solutions for stations in Amboseli, Ngong and Kajiado which resulted in better
network response time and reduced latencies.
Provided end-user support on technical issues covering PC hardware, printers, scanners, computer
peripherals, mobile devices and network connectivity by responding to phone and ticket requests for
services.
Lead and supported the IT attaches’ team in setting up network configurations and computer
hardware in relocated offices both at the headquarters and Nairobi National Park which allowed the
users to go back to their operations without delay.
Wrote reports that summarized our monthly tasks for the IT Head to keep track of how our office
was performing.
IT Support
Used remote tools like Anydesk for maintenance and support of ICT systems which helped save time and cost of travel by almost 55%.
Created and trouble shoot company emails for users by configuring their credentials in the company’s mail server and the users were able to access their respective department emails.
Customized network solutions for stations in Amboseli, Ngong and Kajiado which resulted in better
network response time and reduced latencies.
Provided end-user support on technical issues covering PC hardware, printers, scanners, computer
peripherals, mobile devices and network connectivity by responding to phone and ticket requests for
services.
Lead and supported the IT attaches’ team in setting up network configurations and computer
hardware in relocated offices both at the headquarters and Nairobi National Park which allowed the
users to go back to their operations without delay.
Wrote reports that summarized our monthly tasks for the IT Head to keep track of how our office
was performing.
IT Attaché
Customized network solutions for stations in Amboseli, Ngong and Kajiado which resulted in better network response time and reduced latencies.
Provided end-user support on technical issues covering PC hardware, printers, scanners, computer peripherals, mobile devices and network connectivity by responding to phone and ticket requests for services.
Lead and supported the IT attaches’ team in setting up network configurations and computer hardware in relocated offices both at the headquarters and Nairobi National Park which allowed the users to go back to their operations without delay.
Wrote reports that summarized our monthly tasks for the IT Head to keep track of how our office was performing.
Social media assistant team leader
Used Trello to schedule posts for the social media pages which increased consistency and efficiency by 75%.
Utilized the social media analytical tools to generate engagement and growth reports for weekly meeting presentations which made it easy for the stakeholders to keep track of our progress.
Member
I help push awareness for our campaigns mainly through my social media platform and spreading word to my family, friends and networks.
Some of the campaigns include mobilizing funds to create Sanitary Pad banks for girls in Kenya who are not able to afford the sanitary towels.