Dennis Gacharira

• Conducted data analysis and interpretation for clients in various industries including retail, healthcare, and finance
• Developed customized data visualizations and dashboards to help clients make informed business decisions
• Worked with clients to identify key metrics and KPIs for tracking and monitoring business performance
• Utilized various BI tools such as Tableau, Power BI, and QlikView for data analysis and visualization
• Managed and analyzed large datasets from various sources including SQL databases and Excel files
• Provided training and support to clients on how to effectively use BI tools for data analysis and visualization
• Successfully delivered actionable insights to clients leading to improved business performance and increased revenue
• Built and maintained strong relationships with clients through consistent communication and timely delivery of projects
• Continuously updated technical knowledge and skills by attending industry conferences and workshops

As an Asset Tagging Consultant at Extra Solutions, my roles and achievements include:

• Developed and implemented a comprehensive asset tagging system for clients in various industries, including manufacturing, healthcare, and retail.
• Utilized RFID technology and barcode scanning to accurately track and manage inventory and equipment.
• Collaborated with clients to understand their specific asset tracking needs and customized solutions to meet those needs.
• Trained client staff on proper use and maintenance of the asset tagging system.
• Improved inventory accuracy and asset tracking efficiency by an average of 15% for clients.
• Successfully managed multiple projects simultaneously, with a focus on meeting deadlines and exceeding client expectations.
• Continuously sought out new technologies and best practices in the asset tagging industry to improve services offered to clients.
• Provided ongoing support and maintenance to ensure the asset tagging system remained in optimal condition.
• Successfully completed projects with clients in various sectors such as retail, healthcare, and manufacturing.
• Developed a new method for tracking and management of assets using QR Codes that saved client an average of 30% on their tracking costs.

• Roles:
• Conducted data cleaning and acquisition from various distributors across Kenya, Uganda and Tanzania using excel and BI tools such as Power Queries and VBA.
• Transformed and updated data for visualization on Qlikview.
• Created custom Power Queries and VBA scripts to automate excel processes for data cleaning.
• Produced ad-hoc reports for management and other stakeholders.
• Achievements:
• Successfully cleaned and acquired data from over 50 distributors resulting in improved data accuracy and integrity.
• Implemented automation of excel processes, resulting in a 50% reduction in data cleaning time.
• Developed and implemented various ad-hoc reports for management, resulting in improved decision making and data-driven insights.
• Assisted in the implementation of QlikView as the primary BI tool, resulting in improved data visualization and accessibility for the entire organization.

• Developed and implemented a data-driven sales forecasting model that improved forecast accuracy by 20% and helped the company make more informed production and inventory decisions
• Created and maintained a comprehensive sales dashboard using Tableau, which provided real-time visibility into key performance indicators and helped identify key growth areas for the business
• Led a cross-functional team to analyze and optimize pricing strategy, resulting in a 5% increase in overall revenue
• Conducted in-depth market research and competitive analysis to identify new product opportunities and growth areas for the company
• Collaborated with the marketing team to develop and execute targeted promotional campaigns, resulting in a 15% increase in online sales
• Built and maintained a database of customer and sales data, utilizing SQL for query development and data manipulation
• Developed and presented regular sales performance reports to upper management, providing actionable insights and recommendations for improving business performance.

• Analyzed financial statements against forecasts to prepare high-level variance analysis.
• Drove profit increases through market research and strategic asset management to meet dynamic industry conditions.
• Introduced software tools and process improvements to mitigate loss and drive operational growth.
• Partnered with IT and operational leadership to develop financial business plans with detailed benchmarks.
• Perform full-cycle accounting, including month-, quarter-, and year-end reporting Oversee accounts payable, accounts receivable, and payroll functions